[syslog-ng] syslog-ng and "program" function (was: RE: Trouble with logging to mysql)

[Fegan, Joe]

> 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 at lists.balabit.hu [mailto:syslog-ng-bounces at 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 at 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