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

[Stallmann, Andreas]

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 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