0
responses

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

OS: Ubuntu 20.04, last NXLog CE 3.0.2272

<Input sql_send>
Module im_dbi
SavePos TRUE
PollInterval 10
Driver freetds
Option host ***
Option username ***
Option password ***
Option dbname ***
SQL SELECT * FROM ***
</Input>

AskedFebruary 15, 2022 - 12:33pm

Answers (0)