<p dir="ltr">I vaguely remember having to apply a patch to libdbi drivers to make that column detection trick work with SQLite.</p>
<p dir="ltr">I also remember submitting it upstream but i don't know which version it was.</p>
<p dir="ltr">Hmm can you show the compilation problem with 0.9.0?</p>
<p dir="ltr">Also, balabit has a somewhat stale fork of libdbi and drivers on GitHub, those should definitely have that patch.</p>
<div class="gmail_extra"><br><div class="gmail_quote">On Oct 13, 2016 2:48 PM, "Andrea Laini" <<a href="mailto:andrea.laini@claypaky.it">andrea.laini@claypaky.it</a>> wrote:<br type="attribution"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div lang="IT" link="blue" vlink="purple">
<div class="m_-100449163742853416WordSection1">
<p class="MsoNormal"><span lang="EN-US">Hello everybody,<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">I would like to ask you a question about libdbi (version 0.8.4.1 with libdbi-drivers 0.8.3).<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">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.<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">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.<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">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.<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">Have you any suggestions?<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">Thanks in advance,<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">Regards<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">Andrea<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"><u></u> <u></u></span></p>
<p class="MsoNormal" style="margin-bottom:8.0pt;line-height:106%"><span lang="EN-US"><br>
</span><i><span lang="EN-US" style="font-size:9.0pt;line-height:106%;font-family:"Arial",sans-serif;color:black">Please be informed that our offices will be closed for National Holidays from Monday 31/10/16 to Tuesday 01/11/16 included.
</span></i><i><span style="font-size:9.0pt;line-height:106%;font-family:"Arial",sans-serif;color:black">We will be back on Wednesday 02/11/16.<br>
<br>
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.<br>
</span></i><span style="font-size:9.0pt;line-height:106%;font-family:"Arial",sans-serif;color:black"><br>
<br>
</span><b><span style="font-size:10.0pt;line-height:106%;font-family:"Arial",sans-serif;color:black">Andrea Laini<br>
<br>
</span></b><span style="font-size:8.0pt;line-height:106%;font-family:"Arial",sans-serif;color:black">Email:
<a href="mailto:andrea.laini@claypaky.it" title="andrea.laini@claypaky.it" target="_blank"><span style="color:black;text-decoration:none">andrea.laini@claypaky.it</span></a><br>
</span><b><span style="font-family:"Arial",sans-serif;color:#ffcc00">______________________________<wbr>___</span></b><span style="font-size:10.0pt;line-height:106%;font-family:"Arial",sans-serif;color:black"><br>
<b>Clay Paky S.p.A.<br>
</b></span><span style="font-size:8.0pt;line-height:106%;font-family:"Arial",sans-serif;color:black">Via Pastrengo, 3/b - 24068 Seriate (BG) - ITALY<br>
Phone: +39 - 035.654.311 - Fax: +39 - 035.30.18.76<br>
Web: <a href="http://www.claypaky.it/" title="Clay Paky Home Page" target="_blank"><span style="color:black;text-decoration:none">www.claypaky.it</span></a><br>
</span><b><span style="font-family:"Arial",sans-serif;color:#ffcc00">______________________________<wbr>___</span></b><span style="font-size:10.0pt;line-height:106%;font-family:"Arial",sans-serif;color:black"><br>
<a href="http://www.claypaky.it/disclaimer/index.html" title="Read our Disclaimer @ www.claypaky.it/disclaimer" target="_blank"><span style="font-size:8.0pt;line-height:106%;color:black;text-decoration:none">Read our Disclaimer @ www.claypaky.it/disclaimer</span></a></span><span style="font-size:8.0pt;line-height:106%;font-family:"Arial",sans-serif;color:black"><br>
<br>
</span><span style="font-size:10.0pt;line-height:106%;font-family:"Arial",sans-serif;color:black"><u></u><u></u></span></p>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
</div>
<br>______________________________<wbr>______________________________<wbr>__________________<br>
Member info: <a href="https://lists.balabit.hu/mailman/listinfo/syslog-ng" rel="noreferrer" target="_blank">https://lists.balabit.hu/<wbr>mailman/listinfo/syslog-ng</a><br>
Documentation: <a href="http://www.balabit.com/support/documentation/?product=syslog-ng" rel="noreferrer" target="_blank">http://www.balabit.com/<wbr>support/documentation/?<wbr>product=syslog-ng</a><br>
FAQ: <a href="http://www.balabit.com/wiki/syslog-ng-faq" rel="noreferrer" target="_blank">http://www.balabit.com/wiki/<wbr>syslog-ng-faq</a><br>
<br>
<br></blockquote></div></div>