Hi, 

I kinda remember seeing similar issues before, but I don't know exactly what the problem was. 
I'd suggest trying a newer syslog-ng version (3.5 is rather old and somewhat buggy), and maybe also trying to set the persist-name() option of the destination (see https://github.com/balabit/syslog-ng/issues/1275 ).

HTH, 

Robert

On Thu, Feb 15, 2018 at 6:53 PM, Garry De Toffoli <dtgarry@hotmail.com> wrote:

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

-----------------------





______________________________________________________________________________
Member info: https://lists.balabit.hu/mailman/listinfo/syslog-ng
Documentation: http://www.balabit.com/support/documentation/?product=syslog-ng
FAQ: http://www.balabit.com/wiki/syslog-ng-faq