MS SQL SavePos is not used

Hello, I send data from MS SQL to SysLog, i use im_dbi+freetds and even if i have set SavePos it always starts from the beginning at startup.

After starting the service
2022-02-15 11:19:32 DEBUG im_dbi sql: SELECT * FROM *** WHERE id > -1

When it is already running, the id is used.
2022-02-15 11:19:35 DEBUG im_dbi sql: SELECT * FROM *** WHERE id > 116407

-rw-r--r-- 1 nxlog nxlog 64 Feb 15 11:20 configcache.dat

AskedFebruary 15, 2022 - 12:33pm

Send file to Graylog im_file not working.

I have a very basic setup. I was easily able to get the general syslog functionality working.

I have been unable to get the file transport working. I've spent several days trying alternative configurations and Googling for help; all to no avail.

I also tested with om_file - trying to just grab the file and output it locally - the outcome was just a blank file.

Any help will be greatly appreciated.

Here is my config:

AskedMay 8, 2017 - 10:59pm

Log to MS SQL Server

Is there a way to use the Community Edition to log to MS SQL Server? I have tried writing a Perl script to dump the text log files into the database, but have had no luck. I understand that you can use im_odbc and om_odbc in the Enterprise version, but not the Community Edition (CE). Has anyone had any luck doing this in the CE?

AskedFebruary 11, 2015 - 6:07pm