<div dir="ltr">Hi, <div><br></div><div>I kinda remember seeing similar issues before, but I don't know exactly what the problem was. </div><div>I'd suggest trying a newer syslog-ng version (3.5 is rather old and somewhat buggy), and maybe also trying to set the persist-name() option of the destination (see <a href="https://github.com/balabit/syslog-ng/issues/1275">https://github.com/balabit/syslog-ng/issues/1275</a> ).</div><div><br></div><div>HTH, </div><div><br></div><div>Robert</div></div><div class="gmail_extra"><br><div class="gmail_quote">On Thu, Feb 15, 2018 at 6:53 PM, Garry De Toffoli <span dir="ltr"><<a href="mailto:dtgarry@hotmail.com" target="_blank">dtgarry@hotmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">




<div dir="ltr">
<div id="m_-7851663128901432444divtagdefaultwrapper" style="font-size:12pt;color:rgb(0,0,0);font-family:Calibri,Helvetica,sans-serif,"EmojiFont","Apple Color Emoji","Segoe UI Emoji",NotoColorEmoji,"Segoe UI Symbol","Android Emoji",EmojiSymbols" dir="ltr">
<p style="margin-top:0;margin-bottom:0">Hello,</p>
<p style="margin-top:0;margin-bottom:0"><br>
</p>
<p style="margin-top:0;margin-bottom:0">I have configured syslog.ng OSE version 3.5.3 <span> to log to a MSSQL destination and that all works well.</span></p>
<p style="margin-top:0;margin-bottom:0"><span><br>
</span></p>
<p style="margin-top:0;margin-bottom:0"><span>However when I have specified 2 MSSQL destination, same SQL Server, same table on different database, syslog-ng have problem to insert on database, <span id="m_-7851663128901432444result_box" class="m_-7851663128901432444short_text" lang="en"><span>both
 on the first and on the second.</span></span></span></p>
<p style="margin-top:0;margin-bottom:0"><span><br>
</span></p>
<p style="margin-top:0;margin-bottom:0"><span>Some time will insert, sometimes not.</span></p>
<p style="margin-top:0;margin-bottom:0"><span><br>
</span></p>
<p style="margin-top:0;margin-bottom:0"><span>On /var/log/syslog I have found some lines reporting error CREATE TABLE on the second database,<br>
</span></p>
<p style="margin-top:0;margin-bottom:0"><span><br>
</span></p>
<p style="margin-top:0;margin-bottom:0"><span>Restarting the service, <i>sudo service syslog-ng restart,</i>
<span id="m_-7851663128901432444result_box" class="m_-7851663128901432444short_text" lang="en"><span>takes a long time.</span></span></span></p>
<p style="margin-top:0;margin-bottom:0"><span><span id="m_-7851663128901432444result_box" class="m_-7851663128901432444short_text" lang="en"><span><br>
</span></span></span></p>
<p style="margin-top:0;margin-bottom:0"><span><span id="m_-7851663128901432444result_box" class="m_-7851663128901432444short_text" lang="en"><span>When I comment out the destination of the 2nd database, syslog-ng run very well.<br>
</span></span></span></p>
<p style="margin-top:0;margin-bottom:0"><span><span id="m_-7851663128901432444result_box" class="m_-7851663128901432444short_text" lang="en"><span><br>
</span></span></span></p>
<p style="margin-top:0;margin-bottom:0"><span><span id="m_-7851663128901432444result_box" class="m_-7851663128901432444short_text" lang="en"><span>Is it a limit of the OSE version? Or may be an error on the configuration file?<br>
</span></span></span></p>
<p style="margin-top:0;margin-bottom:0"><span><br>
</span></p>
<p style="margin-top:0;margin-bottom:0"><span>See attached my configuration file.</span></p>
<p style="margin-top:0;margin-bottom:0"><span><br>
</span></p>
<p style="margin-top:0;margin-bottom:0"><span>Thank you for the patience.</span></p>
<p style="margin-top:0;margin-bottom:0"><span><br>
</span></p>
<p style="margin-top:0;margin-bottom:0"><span>-----------------------</span></p>
<p style="margin-top:0;margin-bottom:0"><span>Garry De Toffoli</span></p>
<p style="margin-top:0;margin-bottom:0"><span>-----------------------</span></p>
<p style="margin-top:0;margin-bottom:0"><span><br>
</span></p>
<p style="margin-top:0;margin-bottom:0"><span><br>
</span></p>
<p style="margin-top:0;margin-bottom:0"><span></span><br>
</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><br></div>