Hi -- i am new here, and was not sure if this has been posted i am trying to use syslog-ng to log to a mysql datase, i was told that i could pipe or use program, but i do not know how to, my syslog-ng file is very basic, i am adding lines to create sep files like this for each router, is there a way to just pipe this to a mysql database. ### ### 7206-core ### destination 192.168.1.245 { file("/var/log/routers/7206-core.log"); }; filter f_192.168.1.245 { host(192.168.1.245); }; log { source(net); filter(f_192.168.1.245); destination(192.168.1.245); }; ## main router destination 192.168.1.1 { file("/var/log/routers/main-rr.log"); }; filter f_192.168.1.1 { host(192.168.1.1); }; log { source(net); filter(f_192.168.1.1); destination(192.168.1.1); }; ## switch 192.168.1.254 destination 192.168.1.254 { file("/var/log/routers/michaeleaarls-switch.log"); }; filter f_192.168.1.254 { host(192.168.1.254); }; log { source(net); filter(f_192.168.1.254); destination(192.168.1.254); }; ### ### this should work... ### ## tony kings router destination 192.168.3.1 { file("/var/log/routers/tking-main.log"); }; filter f_192.168.3.1 { host(192.168.3.1); }; log { source(net); filter(f_192.168.3.1); destination(192.168.3.1); }; ## tking switch 192.168.3.254 destination 192.168.3.254 { file("/var/log/routers/tking-switch.log"); }; filter f_192.168.3.254 { host(192.168.3.254); }; log { source(net); filter(f_192.168.3.254); destination(192.168.3.254); };
On Mon, Jan 14, 2002 at 04:49:46PM -0500, Michael Earls wrote:
Hi -- i am new here, and was not sure if this has been posted
i am trying to use syslog-ng to log to a mysql datase, i was told that i could pipe or use program, but i do not know how to,
my syslog-ng file is very basic, i am adding lines to create sep files like this for each router, is there a way to just pipe this to a mysql database.
I put up some pointers on this stuff at http://www.campin.net/newlogcheck.html -- Nate Campi http://www.campin.net GnuPG key: 0xC17AEF79 "Whom computers would destroy, they must first drive mad." -Anon.
participants (2)
-
Michael Earls
-
Nate Campi