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

[Fekete, Róbert]

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 at 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
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.balabit.hu/pipermail/syslog-ng/attachments/20180216/26252f44/attachment.html>