[syslog-ng] Syntax in 3.0 Admin Guide not working for MySQL

[Chuck]

Yea I am.... gasp.. I tried rolling from source but got a slew of compile
errors.

-Chuck

On Fri, Jul 30, 2010 at 12:38 AM, Zoltán Pallagi <pzolee at balabit.hu> wrote:

>  Hi,
>
> I think you are using syslog-ng without sql support.
> Execute "syslog-ng -V" command to check it.
> You should see the following line:
> "Enable-SQL: on"
>
> If Enable-SQL is off, you should recompile syslog-ng with sql support
>
>
> On 2010-07-29 20:29, Chuck wrote:
>
>
> I am trying to log to mysql. I am running syslog-ng 3.0.4 on Solaris 10
> Update 8.
>
> I have the following stanza in syslog-ng.conf:
> destination r_mysql {
>   sql(type(mysql)
>   host("localhost") username("syslog") password("xxxxxxx")
>   database("syslog")
>   table("messages_${HOST}_${R_YEAR}${R_MONTH}${R_DAY}")
>   columns("datetime", "host", "program", "pid", "message")
>   values("$R_DATE", "$HOST", "$PROGRAM", "$PID", "$MSGONLY")
>   indexes("datetime", "host", "program", "pid", "message"));
>   };
>
> It is complaining about the syntax.. Anyone have any ideas?
>
> Thx
>
>
> ______________________________________________________________________________
> Member info: https://lists.balabit.hu/mailman/listinfo/syslog-ng
>
> Documentation: http://www.balabit.com/support/documentation/?product=syslog-ng
> FAQ: http://www.campin.net/syslog-ng/faq.html
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.balabit.hu/pipermail/syslog-ng/attachments/20100730/e72db4d4/attachment.htm