Re: [Exim] Logging to a SQL database

Top Page
Delete this message
Reply to this message
Author: Volker Augustin
Date:  
To: exim-users
Subject: Re: [Exim] Logging to a SQL database
--
hi,

nice idea, i like to try it out, but... what to do with these few lines?
where should i save them? and what to do with it?

greetings :)
volker

Wild Karl-Heinz wrote:

>Hallo David Jericho,
>
>In message "[Exim] Logging to a SQL database"
> on 16.07.2002, David Jericho <david.jericho@???> writes:
>
>DJ> I'm currently looking at doing some logging to a SQL database so Exim
>DJ> can interface with a billing engine.
>
>DJ> Has anyone done anything like this, or am I going to be using Exim's
>DJ> syslog facility with syslog-ng and a filter?
>
>#! /usr/bin/env ruby
>
>require 'dbi'
>
>dbh = DBI.connect( 'DBI:Mysql:dbname', 'username', 'password' )
>insertSQL = "Insert into syslog ( slg_text ) Values ( ? )"
>stm = dbh.prepare( insertSQL )
>
>while gets
>        puts $_
>        stm.execute( $_ )

>
>It'll be pipped via syslogd.
>
>--
>Mit freundlichen Gruessen,
>Wild Karl-Heinz
>mailto:kh.wild@wicom.li
>
>
>--
>
>## List details at http://www.exim.org/mailman/listinfo/exim-users Exim details at http://www.exim.org/ ##
>
>
>
>
>
>


--