<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>