[syslog-ng]MYSQL problem
Michael Earls
Michael.Earls@chmcc.org
Tue, 24 Sep 2002 09:17:38 -0400
This is a MIME message. If you are reading this text, you may want to
consider changing to a mail reader or gateway that understands how to
properly handle MIME multipart messages.
--=_4A16EAEA.00610C54
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
What ver of syslog-ng are u running? The dbName, dbPassword, and
dbUsername are stored in the script and that script then takes the input
from the mysql.pipe, or from the command line
mysql -u root --password=passwd syslog < /tmp/mysql.pipe
Look the scripts,, http://www.vermeer.org/syslog/scripts
michael
>>> cat_roger22@hotmail.com 09/24/02 08:13AM >>>
Hi *,
I didn't understood the posts on the mailing list about the entryes
inserted into syslog-db, I've some questions:
destination d_mysql {
pipe("/var/chroot/syslog-ng/tmp/mysql.pipe"
template("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")
template_escape(yes));
};
I verified the conf file with "-s" option and it didn't returned any
error.
The Db works fine and I noticed that other people have the same
problem...What is the solution ?
...And... Where is set the DB name variable ?...in a conf file I
suppose....but where is that ?
I Activated the debug option but the output was :
gc_mark: Marking object of class 'UNKNOWN' (1)
I see the same output even if I don't use mysql option....
Ciao
_______________________________________________
syslog-ng maillist - syslog-ng@lists.balabit.hu
https://lists.balabit.hu/mailman/listinfo/syslog-ng
Frequently asked questions at http://www.campin.net/syslog-ng/faq.html
--=_4A16EAEA.00610C54
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2600.0" name=GENERATOR></HEAD>
<BODY style="MARGIN-TOP: 2px; FONT: 8pt Tahoma; MARGIN-LEFT: 2px">
<DIV><FONT size=3>What ver of syslog-ng are u running? The dbName, dbPassword,
and dbUsername are stored in the script and that script then takes
the input from the mysql.pipe, or from the command
line</FONT></DIV>
<DIV><FONT size=3>mysql -u root --password=passwd syslog <
/tmp/mysql.pipe</FONT></DIV>
<DIV><FONT size=3></FONT> </DIV>
<DIV><FONT size=3>Look the scripts,, <A
href="http://www.vermeer.org/syslog/scripts">http://www.vermeer.org/syslog/scripts</A>
</FONT></DIV>
<DIV><FONT size=3></FONT> </DIV>
<DIV><FONT size=3>michael</FONT></DIV>
<DIV><BR><BR>>>> cat_roger22@hotmail.com 09/24/02 08:13AM
>>><BR>Hi *,<BR>I didn't understood the posts on the mailing list about
the entryes<BR>inserted into syslog-db, I've some questions:<BR><BR>destination
d_mysql {<BR>
pipe("/var/chroot/syslog-ng/tmp/mysql.pipe"<BR>
template("INSERT INTO
logs<BR>
(host, facility, priority, level, tag, date, time,<BR>program,
msg)<BR>
VALUES ( '$HOST', '$FACILITY', '$PRIORITY',
'$LEVEL',<BR>'$TAG',<BR>
'$YEAR-$MONTH-$DAY', '$HOUR:$MIN:$SEC', '$PROGRAM',<BR>'$MSG'
);\n")<BR>
template_escape(yes));<BR>};<BR><BR>I verified the conf file with "-s"
option and it didn't returned any<BR>error.<BR>The Db works fine and I noticed
that other people have the same<BR>problem...What is the solution ?<BR>...And...
Where is set the DB name variable ?...in a conf file I<BR>suppose....but
where is that ?<BR><BR>I Activated the debug option but the output was
:<BR><BR>gc_mark: Marking object of class 'UNKNOWN' (1)<BR><BR>I see the same
output even if I don't use mysql
option....<BR><BR>Ciao<BR><BR>_______________________________________________<BR>syslog-ng
maillist - syslog-ng@lists.balabit.hu<BR><A
href="https://lists.balabit.hu/mailman/listinfo/syslog-ng">https://lists.balabit.hu/mailman/listinfo/syslog-ng</A><BR>Frequently
asked questions at <A
href="http://www.campin.net/syslog-ng/faq.html">http://www.campin.net/syslog-ng/faq.html</A><BR><BR></DIV></BODY></HTML>
--=_4A16EAEA.00610C54--