<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Verdana
}
--></style>
</head>
<body class='hmmessage'>
I have tried to run syslog-ng in this way:<br><br><a name="13433"></a><font style="" face="Courier New">root@syslog-srv904:/opt/syslog-ng/sbin# ./syslog-ng -f /opt/syslog-ng/etc/syslog-ng.conf</font><br><br>without any option of debug;<br><br>on syslog-ng.conf there is:<br><font style="" face="Courier New">destination d_mysql {</font><font style="" face="Courier New"><br></font><font style="" face="Courier New"> sql(type(mysql)</font><font style="" face="Courier New"><br></font><font style="" face="Courier New"> host("127.0.0.1") username("syslogadmin") password("syslogadmin")</font><font style="" face="Courier New"><br></font><font style="" face="Courier New"> database("syslog")</font><font style="" face="Courier New"><br></font><font style="" face="Courier New"> table("logs")</font><font style="" face="Courier New"><br></font><font style="" face="Courier New"> columns("host", "facility", "priority", "level", "tag", "datetime", "program", "msg")</font><font style="" face="Courier New"><br></font><font style="" face="Courier New"> values("$HOST", "$FACILITY", "$PRIORITY", "$LEVEL", "$TAG", "$YEAR-$MONTH-$DAY $HOUR:$MIN:$SEC", "$PROGRAM", "$MSG")</font><font style="" face="Courier New"><br></font><font style="" face="Courier New"> indexes());</font><font style="" face="Courier New"><br></font><font style="" face="Courier New">};</font><br><br>MySql is configured to accept the configuration from network, so the <font style="" face="Courier New">host("127.0.0.1") username("syslogadmin") password("syslogadmin") is correct;</font><br><br>and the CPU run to 100%<br><br>and doesn't write anything to dbase;<br><br>but if use this configuration<br><font style="" face="Courier New">destination d_mysql {</font><font style="" face="Courier New"><br></font><font style="" face="Courier New"> program("/usr/bin/mysql -usyslogadmin -psyslogadmin syslog"</font><font style="" face="Courier New"><br></font><font style="" face="Courier New"> template("INSERT INTO logs (host, facility, priority, level, tag, datetime, program, msg)</font><font style="" face="Courier New"><br></font><font style="" face="Courier New"> VALUES ( '$HOST', '$FACILITY', '$PRIORITY', '$LEVEL', '$TAG', '$YEAR-$MONTH-$DAY $HOUR:$MIN:$SEC', '$PROGRAM', '$MSG' );\n")</font><font style="" face="Courier New"><br></font><font style="" face="Courier New"> template-escape(yes));</font><font style="" face="Courier New"><br></font><font style="" face="Courier New">};</font><br><br>run OK;<br><br>it seems that the sql() statement go in loop;<br><br>where is the error?<br><br>Someone can send a configuration that run OK?<br><br>Thank you.<br><br><br><br><br><br><br><br> <br /><hr />Hai tante foto? <a href='http://www.windowslive.it/raccoltaFoto.aspx' target='_new'>Organizzale con Windows Live</a></body>
</html>