[syslog-ng] syslog-ng destination to multiple mssql database

Garry De Toffoli dtgarry at hotmail.com
Thu Feb 15 17:53:11 UTC 2018


I have configured syslog.ng OSE version 3.5.3  to log to a MSSQL destination and that all works well.

However when I have specified 2 MSSQL destination, same SQL Server, same table on different database, syslog-ng have problem to insert on database, both on the first and on the second.

Some time will insert, sometimes not.

On /var/log/syslog I have found some lines reporting error CREATE TABLE on the second database,

Restarting the service, sudo service syslog-ng restart, takes a long time.

When I comment out the destination of the 2nd database, syslog-ng run very well.

Is it a limit of the OSE version? Or may be an error on the configuration file?

See attached my configuration file.

Thank you for the patience.


Garry De Toffoli


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.balabit.hu/pipermail/syslog-ng/attachments/20180215/b09b6bdf/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: test_syslog.conf
Type: application/octet-stream
Size: 1245 bytes
Desc: test_syslog.conf
URL: <http://lists.balabit.hu/pipermail/syslog-ng/attachments/20180215/b09b6bdf/attachment.obj>

More information about the syslog-ng mailing list