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

  