Hello out there, my problem with syslog-ng not logging to mysql still persists. The only hint so far was:
Apart from the specific problem one note I have is that syslog-ng OSE 2.1 can do inserts on its own, without the help of the mysql binary.
Thanks for that one, but unfortunately I'm using version 1.6.8, because that's the version delivered with SLES 10.0. I think I may have narrowed down the problem a bit: I still use the following configuration (syslog-ng.conf): #################syslog-ng.conf######################### source net { udp(ip("0.0.0.0") port(514)); }; destination mysql { #file("/var/log/mysqltest.log" program("/usr/bin/mysql --reconnect -f -T --user=syslogadmin --password=xxxxxx syslog >> /var/log/db_log.log 2>&1" template("INSERT INTO logs (host, facility, priority, level, tag, datetime, program, msg) VALUES ( '$HOST', '$FACILITY', '$PRIORITY', '$LEVEL', '$TAG', '$YEAR-$MONTH-$DAY $HOUR:$MIN:$SEC','$PROGRAM', '$MSG' );\n") template-escape(yes)); }; log { source(net); destination(mysql); }; #################################################### If I use "file" instead of "program" the logging works just fine: The string "INSERT INTO..." is written into the file mysqltest.log. When I copy and paste this line into mysql (using the same program call as in the syslog-ng.conf "program" statement), the insert is done without any problem. Using "program" instead, literally nothing happens. No records are written to mysql, and no problems are reported do the db_log.log file. It is, as the statement was *never* executed. *ARRRRGHHH* I'm pretty sure, that this has worked *before* the servers admin applied a SuSE-Update. Yes, I know, never change a running system. If you have any ideas what's going wrong here and why, please let me know. Thanks a lot, Andreas -- CONET Solutions GmbH Andreas Stallmann, Senior Berater Theodor-Heuss-Allee 19, 53773 Hennef Tel.: +49 2242-939-677, Fax: +49 2242-939-393 Internet: http://www.conet.de, mailto: astallmann@conet.de ----------------------------------- CONET Solutions GmbH, Theodor-Heuss-Allee 19, 53773 Hennef Registergericht/Registration Court: Amtsgericht Siegburg (HRB Nr. 9136) Geschaftsfuhrer/Managing Directors: Dipl.-Inform. Rudiger Zeyen (Sprecher/Chairman), Dipl.-Betriebsw. Wilfried Putz und Dipl.-Inform. Jurgen Zender Vorsitzender des Aufsichtsrates/Chairman of the Supervisory Board: Dipl.-Math. Hans-Jurgen Niemeier