[syslog-ng]FW: parse error on Template (
KELLY,THOMAS (HP-Boise,ex1)
syslog-ng@lists.balabit.hu
Tue, 4 Nov 2003 15:31:25 -0500
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_000_01C3A312.7E73424C
Content-Type: multipart/alternative;
boundary="----_=_NextPart_001_01C3A312.7E73424C"
------_=_NextPart_001_01C3A312.7E73424C
Content-Type: text/plain
Attached is my syslog-ng.conf file
<<syslog-ng.conf>>
_____________________________________________
From: KELLY,THOMAS (HP-Boise,ex1)
Sent: Tuesday, November 04, 2003 11:39 AM
To: 'syslog-ng@lists.balabit.hu'
Subject: parse error on Template (
Hello,
I am using syslog-ng-1.6.0rc4 on RH 9. I just migrated to using mysql for
syslog-ng.
After I added in the support for mysql in my syslog-ng.conf, when I try
starting syslog-ng is gives me a parse error on the line that specifies the
template:
template("INSERT INTO logs (host, facility, priority, level,
tag, date,
Does anyone know how to resolve this error?
Thanks,
Tom Kelly
------_=_NextPart_001_01C3A312.7E73424C
Content-Type: text/html
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Dus-ascii">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2657.73">
<TITLE>FW: parse error on Template (</TITLE>
</HEAD>
<BODY>
<P ALIGN=3DLEFT><FONT COLOR=3D"#000080" SIZE=3D2 =
FACE=3D"Verdana">Attached is my syslog-ng.conf file</FONT></P>
<P ALIGN=3DLEFT><FONT FACE=3D"Arial" SIZE=3D2 COLOR=3D"#000000"> =
<<syslog-ng.conf>> </FONT></P>
<P ALIGN=3DLEFT><FONT SIZE=3D2 =
FACE=3D"Tahoma">_____________________________________________<BR>
</FONT><B></B><B><FONT SIZE=3D2 FACE=3D"Tahoma">From:</FONT></B><FONT =
SIZE=3D2 FACE=3D"Tahoma"> KELLY,THOMAS (HP-Boise,ex1)<BR>
</FONT><B></B><B><FONT SIZE=3D2 FACE=3D"Tahoma">Sent:</FONT></B><FONT =
SIZE=3D2 FACE=3D"Tahoma"> Tuesday, November 04, 2003 11:39 AM<BR>
</FONT><B></B><B><FONT SIZE=3D2 FACE=3D"Tahoma">To:</FONT></B><FONT =
SIZE=3D2 FACE=3D"Tahoma"> 'syslog-ng@lists.balabit.hu'<BR>
</FONT><B></B><B><FONT SIZE=3D2 =
FACE=3D"Tahoma">Subject:</FONT></B><FONT SIZE=3D2 FACE=3D"Tahoma"> =
parse error on Template (</FONT></P>
<P ALIGN=3DLEFT><FONT SIZE=3D2 FACE=3D"Verdana">Hello,</FONT></P>
<P ALIGN=3DLEFT><FONT SIZE=3D2 FACE=3D"Verdana">I am using =
syslog-ng-1.6.0rc4 on RH 9. I just migrated to using mysql for =
syslog-ng. </FONT></P>
<P ALIGN=3DLEFT><FONT SIZE=3D2 FACE=3D"Verdana">After I added in the =
support for mysql in my syslog-ng.conf, when I try starting syslog-ng =
is gives me a parse error on the line that specifies the =
template: </FONT></P>
<UL><UL>
<P ALIGN=3DLEFT><FONT COLOR=3D"#000000" SIZE=3D2 =
FACE=3D"Verdana">template("INSERT INTO logs (host, facility, =
priority, level, tag, date,</FONT></P>
<BR>
</UL></UL>
<P ALIGN=3DLEFT><FONT COLOR=3D"#000000" SIZE=3D2 FACE=3D"Verdana">Does =
anyone know how to resolve this error?</FONT></P>
<P ALIGN=3DLEFT><FONT COLOR=3D"#000000" SIZE=3D2 =
FACE=3D"Verdana">Thanks,</FONT></P>
<P ALIGN=3DLEFT><FONT COLOR=3D"#000000" SIZE=3D2 FACE=3D"Verdana">Tom =
Kelly</FONT></P>
</BODY>
</HTML>
------_=_NextPart_001_01C3A312.7E73424C--
------_=_NextPart_000_01C3A312.7E73424C
Content-Type: application/octet-stream;
name="syslog-ng.conf"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: attachment;
filename="syslog-ng.conf"
# syslog-ng configuration file.=0A=
#=0A=
# This should behave pretty much like the original syslog on RedHat. =
But=0A=
# it could be configured a lot smarter.=0A=
#=0A=
# See syslog-ng(8) and syslog-ng.conf(5) for more information.=0A=
#=0A=
# 20000925 gb@sysfive.com=0A=
#=0A=
# Updated by Frank Crawford (<Frank.Crawford@ac3.com.au>) - 10 Aug =
2002=0A=
# - for Red Hat 7.3=0A=
# - totally do away with klogd=0A=
# - add message "kernel:" as is done with klogd.=0A=
#=0A=
# Updated by Frank Crawford (<Frank.Crawford@ac3.com.au>) - 22 Aug =
2002=0A=
# - use the log_prefix option as per Balazs Scheidler's email=0A=
#=0A=
=0A=
options { sync (0);=0A=
time_reopen (10);=0A=
log_fifo_size (1000);=0A=
long_hostnames (off);=0A=
use_dns (no);=0A=
use_fqdn (no);=0A=
create_dirs (no);=0A=
keep_hostname (yes);=0A=
};=0A=
=0A=
#source s_sys { pipe ("/proc/kmsg" log_prefix("kernel: ")); unix-stream =
("/dev/log"); internal(); };=0A=
=0A=
destination d_cons { file("/dev/console"); };=0A=
destination d_mesg { file("/var/log/messages"); };=0A=
destination d_auth { file("/var/log/secure"); };=0A=
destination d_mail { file("/var/log/maillog"); };=0A=
destination d_spol { file("/var/log/spooler"); };=0A=
destination d_boot { file("/var/log/boot.log"); };=0A=
destination d_cron { file("/var/log/cron"); };=0A=
destination d_mlal { usertty("*"); };=0A=
=0A=
filter f_filter1 { facility(kern); };=0A=
filter f_filter2 { level(info) and=0A=
not (facility(mail)=0A=
or facility(authpriv) or facility(cron)); };=0A=
filter f_filter3 { facility(authpriv); };=0A=
filter f_filter4 { facility(mail); };=0A=
filter f_filter5 { level(emerg); };=0A=
filter f_filter6 { facility(uucp) or=0A=
(facility(news) and level(crit)); };=0A=
filter f_filter7 { facility(local7); };=0A=
filter f_filter8 { facility(cron); };=0A=
=0A=
#log { source(s_sys); filter(f_filter1); destination(d_cons); };=0A=
log { source(s_sys); filter(f_filter2); destination(d_mesg); };=0A=
log { source(s_sys); filter(f_filter3); destination(d_auth); };=0A=
log { source(s_sys); filter(f_filter4); destination(d_mail); };=0A=
log { source(s_sys); filter(f_filter5); destination(d_mlal); };=0A=
log { source(s_sys); filter(f_filter6); destination(d_spol); };=0A=
log { source(s_sys); filter(f_filter7); destination(d_boot); };=0A=
log { source(s_sys); filter(f_filter8); destination(d_cron); };=0A=
=0A=
# # Log syslog-ng to mysql database=0A=
# #=0A=
destination d_mysql {=0A=
pipe("/tmp/mysql.pipe"=0A=
#template("INSERT INTO logs(host,facility,priority,level,tag,date,=0A=
#time,program,msg) VALUES =
('$HOST,'$FACILITY,'$PRIORITY','$LEVEL','$TAG',=0A=
#'$YEAR-$MONTH-$DAY','$HOUR:$MIN:$SEC','$PROGRAM','$MSG');\n") =
template-escape(yes));=0A=
#};=0A=
#log { source(net); destination(d_mysql);=0A=
#};=0A=
------_=_NextPart_000_01C3A312.7E73424C--