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); };