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

[Chuck]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.balabit.hu/pipermail/syslog-ng/attachments/20100729/382469e3/attachment-0001.htm