[syslog-ng] MS-SQL Question

[Alicia Smith]

You'll want to tune your config according to the resources available and
the throughput it requires.

I can follow up with a link on how to do that.

Are you using json format from syslog-ng?
Can you provide an example event that it's getting hung up on?

Alicia


On Wed, Feb 6, 2019, 11:42 AM Garridan <garridan at gmail.com> wrote:

> Hello!   I'm a new syslog-ng user, so please be gentle with me.  :)
>
> I'm attempting to log to an MS-SQL database and would like to send to
> different tables in the same DB based on the source IP - for example device
> A to its own table, device B to its own table, and so on.
>
> I thought I would simply need to create the same destination but define
> different table names in each, it works, however under load the syslog-ng
> service starts restarting over and over and eventually MS-SQL errors and
> alerts that the login packet is structurally invalid.
>
> Is it possible to send to different table names in this manner or is there
> another way to do it?
>
> Thanks!
>
>
> ______________________________________________________________________________
> 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/20190206/3b3b8ff5/attachment.html>