<br>Yea I am.... gasp.. I tried rolling from source but got a slew of compile errors.<br><br>-Chuck<br><br><div class="gmail_quote">On Fri, Jul 30, 2010 at 12:38 AM, Zoltán Pallagi <span dir="ltr">&lt;<a href="mailto:pzolee@balabit.hu">pzolee@balabit.hu</a>&gt;</span> wrote:<br>
<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">


  
  

<div bgcolor="#ffffff" text="#000000">
Hi,<br>
<br>
I think you are using syslog-ng without sql support.<br>
Execute &quot;syslog-ng -V&quot; command to check it.<br>
You should see the following line:<br>
&quot;Enable-SQL: on&quot;<br>
<br>
If Enable-SQL is off, you should recompile syslog-ng with sql support<div><div></div><div class="h5"><br>
<br>
On 2010-07-29 20:29, Chuck wrote:
</div></div><blockquote type="cite"><div><div></div><div class="h5"><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(&quot;localhost&quot;)
username(&quot;syslog&quot;) password(&quot;xxxxxxx&quot;)</span><br style="font-family: courier new,monospace;">
  <span style="font-family: courier new,monospace;">  database(&quot;syslog&quot;)</span><br style="font-family: courier new,monospace;">
  <span style="font-family: courier new,monospace;"> 
table(&quot;messages_${HOST}_${R_YEAR}${R_MONTH}${R_DAY}&quot;)</span><br style="font-family: courier new,monospace;">
  <span style="font-family: courier new,monospace;"> 
columns(&quot;datetime&quot;, &quot;host&quot;, &quot;program&quot;, &quot;pid&quot;, &quot;message&quot;)</span><br style="font-family: courier new,monospace;">
  <span style="font-family: courier new,monospace;">  values(&quot;$R_DATE&quot;,
&quot;$HOST&quot;, &quot;$PROGRAM&quot;, &quot;$PID&quot;, &quot;$MSGONLY&quot;)</span><br style="font-family: courier new,monospace;">
  <span style="font-family: courier new,monospace;"> 
indexes(&quot;datetime&quot;, &quot;host&quot;, &quot;program&quot;, &quot;pid&quot;, &quot;message&quot;));</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>
  </div></div><pre><fieldset></fieldset>
______________________________________________________________________________
Member info: <a href="https://lists.balabit.hu/mailman/listinfo/syslog-ng" target="_blank">https://lists.balabit.hu/mailman/listinfo/syslog-ng</a><div class="im">
Documentation: <a href="http://www.balabit.com/support/documentation/?product=syslog-ng" target="_blank">http://www.balabit.com/support/documentation/?product=syslog-ng</a>
FAQ: <a href="http://www.campin.net/syslog-ng/faq.html" target="_blank">http://www.campin.net/syslog-ng/faq.html</a>

  </div></pre>
</blockquote>
<br>
</div>

</blockquote></div><br>