[syslog-ng]syslog-ng

Michael Earls [email protected]
Mon, 14 Jan 2002 23:12:04 -0500


what do u think about this one,  b/c i still can not get to to log to the mysql database,

destination rrrouter {
program("/usr/bin/mysql -u root -p -D rrrouter -t"); };                  
filter f_192.168.3.254 { host(192.168.3.254); };
log { source(net); filter(f_192.168.3.254); destination(rrrouter); }; 


thanks

michael


>>> [email protected] 01/14/02 20:16 PM >>>
On Mon, Jan 14, 2002 at 07:48:35PM -0500, Michael Earls wrote:
> sorry if i am missing something but I do not see that there, i see that u are logging to a host file, or are using sqlsyslog, i am looking for a way to take the statement for syslog-ng then pipe that into a database, 

Are you saying you only want to insert *certain* messages into the
database? I really don't understand.

I see now that my example syslog-ng.conf doesn't have an example line
for using sqlsyslogd. If that's what you need, here you go:

----
destination sqlsyslogd { program("/usr/local/sbin/sqlsyslogd -u sqlsyslogd -t logs sqlsyslogd -p"); };

log { source(src); destination(sqlsyslogd); };
----
"src" in this case is all the incoming messages, there's no filtering of
messages.

You still need to setup your database according to the instructions for
sqlsyslogd. Read the docs that come with it.
-- 
Nate Campi     http://www.campin.net    GnuPG key: 0xC17AEF79   

"My computer's sick. I think my modem is a carrier."


_______________________________________________
syslog-ng maillist  -  [email protected]
https://lists.balabit.hu/mailman/listinfo/syslog-ng