It is, as the statement was *never* executed. *ARRRRGHHH*
Are you sure that syslog-ng is successful in creating a persistent child running that mysql command line? You should see in "ps -elf" a syslog-ng process with a child process running that mysql command line. The pid of the child process should *not* change over time. If the child pid is changing then this means that the child mysqld is exiting and syslog-ng is creating a new one. This should not be happening if your config is OK. I see that you have already tried sending the output to a file and it looks ok that way. The only other thing I can suggest is to send it to a script of your own instead of mysql and in your script you can see *exactly* what mysql would receive on its stdin. Joe. -----Original Message----- From: syslog-ng-bounces@lists.balabit.hu [mailto:syslog-ng-bounces@lists.balabit.hu] On Behalf Of Stallmann, Andreas Sent: 17 September 2008 22:07 To: Syslog-ng users' and developers' mailing list Subject: [syslog-ng] syslog-ng and "program" function (was: RE: Trouble with logging to 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 ______________________________________________________________________________ Member info: https://lists.balabit.hu/mailman/listinfo/syslog-ng Documentation: http://www.balabit.com/support/documentation/?product=syslog-ng FAQ: http://www.campin.net/syslog-ng/faq.html