<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
Hi,<br>
<br>
I think you are using syslog-ng without sql support.<br>
Execute "syslog-ng -V" command to check it.<br>
You should see the following line:<br>
"Enable-SQL: on"<br>
<br>
If Enable-SQL is off, you should recompile syslog-ng with sql support<br>
<br>
On 2010-07-29 20:29, Chuck wrote:
<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="">
<fieldset class="mimeAttachmentHeader"></fieldset>
______________________________________________________________________________
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>
<br>
</body>
</html>