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

[Garry De Toffoli]

Hello,


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>