I vaguely remember having to apply a patch to libdbi drivers to make that column detection trick work with SQLite. I also remember submitting it upstream but i don't know which version it was. Hmm can you show the compilation problem with 0.9.0? Also, balabit has a somewhat stale fork of libdbi and drivers on GitHub, those should definitely have that patch. On Oct 13, 2016 2:48 PM, "Andrea Laini" <andrea.laini@claypaky.it> wrote:
Hello everybody,
I would like to ask you a question about libdbi (version 0.8.4.1 with libdbi-drivers 0.8.3).
I’m using syslog-ng 3.5.4.1 on my Yocto Poky 1.7 Linux distro. I need to log my data into a sqlite3 database and everything works fine, but the database has not be written: no log data stored.
According to debug infos, it seems that syslog-ng recognizes that the database exists, connects to it, found (with the sql statement “SELECT * FROM tableName WHERE 0=1) that the table named “tableName” exists but it gets an error when verifying columns’ names; so it tries to add a column with that name to the table, but the operation fails since this column already exists.
I’ve googled and search on the web, but I’ve found nothing interesting. Trying syslog-ng 3.6.4 doesn’t change anything, while using libdbi 0.9.0 returns an error when compiling due to mismatch between function signature in the source and header file.
Have you any suggestions?
Thanks in advance,
Regards
Andrea
*Please be informed that our offices will be closed for National Holidays from Monday 31/10/16 to Tuesday 01/11/16 included. *
*We will be back on Wednesday 02/11/16. Vi ricordiamo che saremo chiusi per festività i giorni lunedì 31/10/16 e martedì 01/11/16. Saremo nuovamente operativi da mercoledì 02/11/16. *
*Andrea Laini *Email: andrea.laini@claypaky.it *_________________________________*
*Clay Paky S.p.A. *Via Pastrengo, 3/b - 24068 Seriate (BG) - ITALY Phone: +39 - 035.654.311 - Fax: +39 - 035.30.18.76 Web: www.claypaky.it *_________________________________* Read our Disclaimer @ www.claypaky.it/disclaimer <http://www.claypaky.it/disclaimer/index.html>
____________________________________________________________ __________________ 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