[syslog-ng] syslog-ng with sql() command, cpu to 100%

Garry De Toffoli dtgarry at hotmail.com
Mon Oct 5 10:11:29 CEST 2009

I am using the version 3.04 of syslog-ng, as reported:

$./syslog-ng -V
syslog-ng 3.0.4
Compile-Date: Aug  5 2009 17:38:20
Enable-Threads: on
Enable-Debug: off
Enable-GProf: off
Enable-Memtrace: off
Enable-Sun-STREAMS: off
Enable-Sun-Door: off
Enable-IPv6: on
Enable-Spoof-Source: on
Enable-TCP-Wrapper: off
Enable-SSL: on
Enable-SQL: on
Enable-Linux-Caps: on
Enable-Pcre: off

I would like to use the sql() features;

but syslog-ng does not write anything on dbase, and the cpu go to 100%;

this is the configuration of the destination sql

destination d_mysql {
        host("localhost") username("syslogadmin") password("syslogadmin")
        columns("host", "facility", "priority", "level", "tag", "datetime", "program", "msg", "seq")
values("$HOST_FROM", "$FACILITY", "$PRIORITY", "$LEVEL", "$TAG",
        indexes("host", "facility", "priority", "datetime", "program", "seq"));

of course, the configuration like this
destination d_mysql {
    program("/usr/bin/mysql -usyslogadmin -psyslogadmin syslog"
    template("INSERT INTO logs (host, facility, priority, level, tag, datetime, program, msg)
run OK, but I would like to use the sql() statement instead;

what can I do?

Is the sql() command supported by the syslog-ng 3.0.4?

Thank you.

Gossip, Sport, Notizie... Accendi la Messenger TV!
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.balabit.hu/pipermail/syslog-ng/attachments/20091005/94787443/attachment-0001.htm 

More information about the syslog-ng mailing list