[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"> =
&lt;&lt;syslog-ng.conf&gt;&gt; </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.&nbsp; I just migrated to using mysql for =
syslog-ng.&nbsp; </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:&nbsp;&nbsp; </FONT></P>
<UL><UL>
<P ALIGN=3DLEFT><FONT COLOR=3D"#000000" SIZE=3D2 =
FACE=3D"Verdana">template(&quot;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--