Syntax in 3.0 Admin Guide not working for MySQL
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
Put quotes around mysql in type(mysql). Sent: Thursday, July 29, 2010 12:29:56 PM From: Chuck <chuck.carson@gmail.com> To: Syslog-ng users' and developers' mailing list <syslog-ng@lists.balabit.hu> Subject: [syslog-ng] Syntax in 3.0 Admin Guide not working for MySQL
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
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
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@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
On Fri, 2010-07-30 at 06:24 -0700, Chuck wrote:
Yea I am.... gasp.. I tried rolling from source but got a slew of compile errors.
You could perhaps check the binaries that we publish, those include SQL support as well. -- Bazsi
participants (4)
-
Balazs Scheidler
-
Chuck
-
syslogng＠feystorm.net
-
Zoltán Pallagi