<span><br>Hi,<br>I'm trying to setup a central logging server to get
logs from many hosts on a network, and store in a mysql database. I
followed the following docs:: <br><br><a href="http://gentoo-wiki.com/HOWTO_setup_PHP-Syslog-NG">http://gentoo-wiki.com/HOWTO_setup_PHP-Syslog-NG</a><br><br><a href="http://vermeer.org/docs/1">http://vermeer.org/docs/1</a>
<br><br>only nothing is being logged :D <br>my syslog-ng.conf so far:: </span><br><br><br><span style="color: rgb(255, 0, 0);"># $Header: /var/cvsroot/gentoo-x86/app-ad</span><span style="color: rgb(255, 0, 0);">min/syslog-ng/files/syslog-
ng.c</span><span style="color: rgb(255, 0, 0);">onf.gentoo,v 1.5 2005/05/12 05:46:10 mr_bones_ Exp $</span><br style="color: rgb(255, 0, 0);"><span style="color: rgb(255, 0, 0);"> #</span><br style="color: rgb(255, 0, 0);">
<span style="color: rgb(255, 0, 0);"># Syslog-ng default configuration file for Gentoo Linux</span><br style="color: rgb(255, 0, 0);"><span style="color: rgb(255, 0, 0);"> # contributed by Michael Sterrett</span><br style="color: rgb(255, 0, 0);">
<br style="color: rgb(255, 0, 0);"><span style="color: rgb(255, 0, 0);">options { </span><br style="color: rgb(255, 0, 0);"><span style="color: rgb(255, 0, 0);"> chain_hostnames(off); </span><br style="color: rgb(255, 0, 0);">
<span style="color: rgb(255, 0, 0);"> keep_hostname(yes);</span><br style="color: rgb(255, 0, 0);"><span style="color: rgb(255, 0, 0);"> log_fifo_size(1024);</span><br style="color: rgb(255, 0, 0);"><span style="color: rgb(255, 0, 0);">
sync(0); </span><br style="color: rgb(255, 0, 0);"><br style="color: rgb(255, 0, 0);"><span style="color: rgb(255, 0, 0);"> # The default action of syslog-ng 1.6.0 is to log a STATS line</span><br style="color: rgb(255, 0, 0);">
<span style="color: rgb(255, 0, 0);"> # to the file every 10 minutes. That's pretty ugly after a while. </span><br style="color: rgb(255, 0, 0);"><span style="color: rgb(255, 0, 0);"> # Change it to every 12 hours so you get a nice daily update of
</span><br style="color: rgb(255, 0, 0);"><span style="color: rgb(255, 0, 0);"> # how many messages syslog-ng missed (0).</span><br style="color: rgb(255, 0, 0);"><span style="color: rgb(255, 0, 0);"> stats(43200);
</span><br style="color: rgb(255, 0, 0);"><span style="color: rgb(255, 0, 0);"> };</span><br style="color: rgb(255, 0, 0);"><br style="color: rgb(255, 0, 0);"><span style="color: rgb(255, 0, 0);">source shell {</span><br style="color: rgb(255, 0, 0);">
<span style="color: rgb(255, 0, 0);"> unix-dgram("/dev/log");</span><br style="color: rgb(255, 0, 0);"><span style="color: rgb(255, 0, 0);">internal(</span><span style="color: rgb(255, 0, 0);">);</span><br style="color: rgb(255, 0, 0);">
<span style="color: rgb(255, 0, 0);">#tcp( port(5141) keep-alive(yes) max-connections(3000)); </span><br style="color: rgb(255, 0, 0);"><span style="color: rgb(255, 0, 0);">udp(ip(<a href="http://0.0.0.0">0.0.0.0</a>),port(514));
</span><br style="color: rgb(255, 0, 0);"><span style="color: rgb(255, 0, 0);"> };</span><br style="color: rgb(255, 0, 0);"><br style="color: rgb(255, 0, 0);"><span style="color: rgb(255, 0, 0);">source src { unix-stream("/dev/log"); internal(); pipe("/proc/kmsg"); };
</span><br style="color: rgb(255, 0, 0);"><br style="color: rgb(255, 0, 0);"><span style="color: rgb(255, 0, 0);">source net {udp(); };</span><br style="color: rgb(255, 0, 0);"><br style="color: rgb(255, 0, 0);"><span style="color: rgb(255, 0, 0);">
destination messages { file("/var/log/messages"); };</span><br style="color: rgb(255, 0, 0);"><br style="color: rgb(255, 0, 0);"><span style="color: rgb(255, 0, 0);"> # By default messages are logged to tty12...
</span><br style="color: rgb(255, 0, 0);"><span style="color: rgb(255, 0, 0);">destination console_all { file("/dev/tty12"); };</span><br style="color: rgb(255, 0, 0);"><span style="color: rgb(255, 0, 0);"> # ...if you intend to use /dev/console for programs like xconsole
</span><br style="color: rgb(255, 0, 0);"><span style="color: rgb(255, 0, 0);"># you can comment out the destination line above that references /dev/tty12 </span><br style="color: rgb(255, 0, 0);"><span style="color: rgb(255, 0, 0);">
# and uncomment the line below.</span><br style="color: rgb(255, 0, 0);"><span style="color: rgb(255, 0, 0);">#destination console_all { file("/dev/console"); }; </span><br style="color: rgb(255, 0, 0);"><br style="color: rgb(255, 0, 0);">
<span style="color: rgb(255, 0, 0);">log { source(src); destination(messages); };</span><br style="color: rgb(255, 0, 0);"><span style="color: rgb(255, 0, 0);"> log { source(src); destination(console_all); };</span><br style="color: rgb(255, 0, 0);">
<span style="color: rgb(255, 0, 0);">log { source(shell); filter(allstuff);destination(t</span><span style="color: rgb(255, 0, 0);">estfile); };</span><br style="color: rgb(255, 0, 0);"><span style="color: rgb(255, 0, 0);">
log { source(net); destination(testfile); };</span><br style="color: rgb(255, 0, 0);"><span style="color: rgb(255, 0, 0);">filter allstuff { host("194.146.*"); }; </span><br style="color: rgb(255, 0, 0);"><br style="color: rgb(255, 0, 0);">
<span style="color: rgb(255, 0, 0);"># pipe messages to /var/log/mysql.pipe to be processed by mysql</span><br style="color: rgb(255, 0, 0);"> <br style="color: rgb(255, 0, 0);"><span style="color: rgb(255, 0, 0);">destination d_mysql { pipe("/var/log/mysql.pipe" template("INSERT INTO logs
</span><br style="color: rgb(255, 0, 0);"><span style="color: rgb(255, 0, 0);"> (host, facility, priority, level, tag, datetime, program, msg)</span><br style="color: rgb(255, 0, 0);"><span style="color: rgb(255, 0, 0);">
VALUES ( '$HOST', '$FACILITY', '$PRIORITY', '$LEVEL', '$TAG', '$YEAR-$MONTH-$DAY $HOUR:$MIN:$SEC', </span><br style="color: rgb(255, 0, 0);"><span style="color: rgb(255, 0, 0);">'$PROGRAM', '$MSG' );\n") template-escape(yes)); };
</span><br style="color: rgb(255, 0, 0);"><br style="color: rgb(255, 0, 0);"><span style="color: rgb(255, 0, 0);"> #destination testfile {</span><br style="color: rgb(255, 0, 0);"><span style="color: rgb(255, 0, 0);">destination testfile {
</span><br style="color: rgb(255, 0, 0);"><span style="color: rgb(255, 0, 0);"> file("/var/log/test/$HOST/zab.l</span><span style="color: rgb(255, 0, 0);">og" </span><br style="color: rgb(255, 0, 0);"><span style="color: rgb(255, 0, 0);">
sync(0) log_fifo_size(10) create_dirs(yes) </span><br style="color: rgb(255, 0, 0);"><span style="color: rgb(255, 0, 0);"> owner(root) group(system) perm(0660) dir_perm(0770));</span><br style="color: rgb(255, 0, 0);"><span style="color: rgb(255, 0, 0);">
};</span><br> <br><span>
i suspected something wrong with the way i setup mysql database.. thats
why i added the last bit, to log to a text file, still nothing .. i
cant figure out what else could be wrong. <br> <br> Any help appreciated.<br> <br> Greets, <br> Naim</span><br>