<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#0050d0">
<font size="-1"><font face="Helvetica, Arial, sans-serif">Put quotes
around mysql in type(mysql).</font></font><br>
<br>
Sent: Thursday, July 29, 2010 12:29:56 PM<br>
From: Chuck <a class="moz-txt-link-rfc2396E" href="mailto:chuck.carson@gmail.com"><chuck.carson@gmail.com></a><br>
To: Syslog-ng users' and developers' mailing list
<a class="moz-txt-link-rfc2396E" href="mailto:syslog-ng@lists.balabit.hu"><syslog-ng@lists.balabit.hu></a> <br>
Subject: [syslog-ng] Syntax in 3.0 Admin Guide not working for MySQL
<blockquote
cite="mid:AANLkTi=wjtkoo7afn5L97qus9KU7h4C72wo7wVJaH7n2@mail.gmail.com"
type="cite"><br>
I am trying to log to mysql. I am running syslog-ng 3.0.4 on Solaris 10
Update 8.<br>
<br>
I have the following stanza in syslog-ng.conf:<br>
<span style="font-family: courier new,monospace;">destination r_mysql
{</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;"> sql(type(mysql)</span><br
style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;"> host("localhost")
username("syslog") password("xxxxxxx")</span><br
style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;"> database("syslog")</span><br
style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">
table("messages_${HOST}_${R_YEAR}${R_MONTH}${R_DAY}")</span><br
style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">
columns("datetime", "host", "program", "pid", "message")</span><br
style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;"> values("$R_DATE",
"$HOST", "$PROGRAM", "$PID", "$MSGONLY")</span><br
style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">
indexes("datetime", "host", "program", "pid", "message"));</span><br
style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;"> };</span><br>
<br>
It is complaining about the syntax.. Anyone have any ideas?<br>
<br>
Thx<br>
<pre wrap="">
<hr size="4" width="90%">
______________________________________________________________________________
Member info: <a class="moz-txt-link-freetext" href="https://lists.balabit.hu/mailman/listinfo/syslog-ng">https://lists.balabit.hu/mailman/listinfo/syslog-ng</a>
Documentation: <a class="moz-txt-link-freetext" href="http://www.balabit.com/support/documentation/?product=syslog-ng">http://www.balabit.com/support/documentation/?product=syslog-ng</a>
FAQ: <a class="moz-txt-link-freetext" href="http://www.campin.net/syslog-ng/faq.html">http://www.campin.net/syslog-ng/faq.html</a>
</pre>
</blockquote>
</body>
</html>