hello,<br>
<br>
<br>
i'm having trouble with the template i created to pipe to mysql
(acording to php-syslog-ng), at first it was working fine but then (i
started messing around) and it just stop working, i had configure
syslog-ng to store logs coming from server A into mysql and on a text
file, here's&nbsp; my syslog-ng.conf:<br>
<br>
&nbsp; ## Log syslog-ng to mysql database<br>
&nbsp; ##<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; destination d_mysql {<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; pipe(&quot;/tmp/mysql.pipe&quot;<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; template(&quot;INSERT
INTO logs (host, facility, priority, level, tag, date, time, program,
msg) VALUES ( '$HOST', '$FACILITY', '$PRIORITY', '$LEVEL', '$TAG',
'$YEAR-$MONTH-$DAY', '$HOUR:$MIN:$SEC', '$PROGRAM', '$MSG' );\n&quot;)
template-escape(yes));<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; };<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; log { source(net); destination(d_mysql); };<br>
<br>
&nbsp; ## Log on to text file<br>
&nbsp; ##<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; destination hosts {<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; file(&quot;/var/log/$HOST.$FACILITY&quot;<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
owner(root) group(root) perm(0600) dir_perm(0700)<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
create_dirs(yes));<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
};<br>
<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; log {source(net); destination(hosts); };<br>
<br>
#Then comment out this line --<br>
<br>
&nbsp;&nbsp; # This is the default behavior of sysklogd package<br>
&nbsp;&nbsp; # Logs may come from unix stream, but not from another machine.<br>
&nbsp;&nbsp; #<br>
&nbsp;&nbsp; #source src { unix-dgram(&quot;/dev/log&quot;); internal(); };<br>
<br>
#Then uncomment out this line --<br>
<br>
&nbsp;&nbsp; # If you wish to get logs from remote machine you should uncomment<br>
&nbsp;&nbsp; # this and comment the above source line.<br>
&nbsp;&nbsp; source src { unix-dgram(&quot;/dev/log&quot;); internal(); };<br>
&nbsp;&nbsp; source net { udp(); };<br>
<br>
<br>
it actually worked, but i don't know what i did, i see the logs coming
from server A (#tcpdump host server A and port 514) but it doesn't
store them on mysql...<br>
<br>
help please!!!<br><br>-- <br>Ciao,Javier<br>linux user #393724