<div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr">Thank you Joel!</div><div dir="ltr"><br></div><div dir="ltr">I didn't try your advice for #1 but will keep it in mind in case of extra issues with pgsq-odbc.</div><div dir="ltr"><br></div><div dir="ltr">My issue #1 was solved by changing in postgresql.conf</div><div dir="ltr"><br></div><div dir="ltr"> client_min_messages = debug5 </div><div dir="ltr">to</div><div dir="ltr"> client_min_messages = notice</div><div dir="ltr"><br></div><div dir="ltr">One great guy - Hiroshi Inoue (pgsql-odbc community) adviced this trick. </div><div dir="ltr"><br></div><div dir="ltr">Thanks!</div></div><div dir="ltr"><div><br></div></div></div></div></div></div></div><br><div class="gmail_quote"><div dir="ltr">On Wed, 28 Nov 2018 at 13:47, Joel Serrano <<a href="mailto:joel@textplus.com">joel@textplus.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div dir="auto">For #1... I would first try with debian unixodbc + latest pgsql driver from their web. If that doesn’t work, then I would try with unixodbc latest + latest driver. </div></div><div dir="auto"><br></div><div dir="auto">For both those test you will need to remove the related OS installed packages. </div><div dir="auto"><br></div><div><br><div class="gmail_quote"><div dir="ltr">On Tue, Nov 27, 2018 at 09:49 Yuriy Nasida <<a href="mailto:ynasida@gmail.com" target="_blank">ynasida@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Thanks a lot Joel! <div><br></div><div>You advice about #2 works great for me.</div><div><br></div><div>As for #1 I am ready to provide any exta info if this will help. I currently think I should downgrade pgsql10 to pgsql9 because of this segfault issue. I also asked in pgsql-odbc community but looks like nobody read it :(</div><div><br></div><div><br></div></div><br><div class="gmail_quote"><div dir="ltr">On Tue, 27 Nov 2018 at 18:57, Joel Serrano <<a href="mailto:joel@textplus.com" target="_blank">joel@textplus.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div dir="auto">Not sure for #1. </div></div><div dir="auto"><br></div><div dir="auto">But for #2 you should download the official ODBC MySQL connector for your OS (Debian/ubuntu available), that includes libmyodbc.so:</div><div dir="auto"><br></div><div dir="auto"><a href="https://dev.mysql.com/downloads/connector/odbc/" target="_blank">https://dev.mysql.com/downloads/connector/odbc/</a><br></div><div dir="auto"><br></div><div dir="auto">NOTE: you will have to register with <a href="http://oracle.com" target="_blank">oracle.com</a> to download it. <br></div><div dir="auto"><br></div><div dir="auto"><br></div><div dir="auto">Cheers,</div><div dir="auto">Joel. </div><div dir="auto"><br></div><div><br><div class="gmail_quote"><div dir="ltr">On Mon, Nov 26, 2018 at 13:53 Yuriy Nasida <<a href="mailto:ynasida@gmail.com" target="_blank">ynasida@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Hi guys,<br class="m_7378429799183239777m_-7415056987425611030m_-935548225805892314m_2763156712572020505gmail-m_-8987516829201435050gmail-Apple-interchange-newline"><div><br></div><div>I was very glad to know that Deb9 is supported officially by FS team and did some tests. Unfortunatelly I noted a lot of odbc problems with Deb9. Freeswitch is NOT the reason but I would like to ask other comunity members how they solve such problems. A lot of FS modules can not work with pgsql directly (like mod_lcr for example) and that is why I can not just stop to use odbc. </div><div><br></div><div>Which issues ?</div><div><br></div><div>1) Well, 1st of them is odbc-postgresql in case I try to reach pgsql10. Please look below. I can send odbc.ini file but don't want to send too many info:)</div><div><div># isql -v pgsqldsn</div><div>DEBUG: CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGR, xid/subid/cid: 0/1/0</div><div><b>Segmentation fault</b></div></div><div><br></div><div>2) Second issue with mysql-percona. I suppose everybody knows that libmyodbc.so doesn't exist in Deb9. There is possibility to install manually odbc connector for mariadb but... what should I do for percona ? Also I saw very sad feedbacks from asterisk guys who tried to use mariadb odbc connecter.</div><div><br></div><div>Please advce that you use to get odbc working with Deb9 </div><div>Thanks. </div></div>
_________________________________________________________________________<br>
Professional FreeSWITCH Services<br>
<a href="mailto:sales@freeswitch.com" target="_blank">sales@freeswitch.com</a><br>
<a href="https://freeswitch.com" rel="noreferrer" target="_blank">https://freeswitch.com</a><br>
<br>
Official FreeSWITCH Sites<br>
<a href="https://freeswitch.com/oss" rel="noreferrer" target="_blank">https://freeswitch.com/oss</a><br>
<a href="https://freeswitch.org/confluence" rel="noreferrer" target="_blank">https://freeswitch.org/confluence</a><br>
<a href="https://cluecon.com" rel="noreferrer" target="_blank">https://cluecon.com</a><br>
<br>
FreeSWITCH-users mailing list<br>
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org" target="_blank">FreeSWITCH-users@lists.freeswitch.org</a><br>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" rel="noreferrer" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" rel="noreferrer" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
<a href="https://freeswitch.com" rel="noreferrer" target="_blank">https://freeswitch.com</a></blockquote></div></div>
_________________________________________________________________________<br>
Professional FreeSWITCH Services<br>
<a href="mailto:sales@freeswitch.com" target="_blank">sales@freeswitch.com</a><br>
<a href="https://freeswitch.com" rel="noreferrer" target="_blank">https://freeswitch.com</a><br>
<br>
Official FreeSWITCH Sites<br>
<a href="https://freeswitch.com/oss" rel="noreferrer" target="_blank">https://freeswitch.com/oss</a><br>
<a href="https://freeswitch.org/confluence" rel="noreferrer" target="_blank">https://freeswitch.org/confluence</a><br>
<a href="https://cluecon.com" rel="noreferrer" target="_blank">https://cluecon.com</a><br>
<br>
FreeSWITCH-users mailing list<br>
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org" target="_blank">FreeSWITCH-users@lists.freeswitch.org</a><br>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" rel="noreferrer" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" rel="noreferrer" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
<a href="https://freeswitch.com" rel="noreferrer" target="_blank">https://freeswitch.com</a></blockquote></div>
_________________________________________________________________________<br>
Professional FreeSWITCH Services<br>
<a href="mailto:sales@freeswitch.com" target="_blank">sales@freeswitch.com</a><br>
<a href="https://freeswitch.com" rel="noreferrer" target="_blank">https://freeswitch.com</a><br>
<br>
Official FreeSWITCH Sites<br>
<a href="https://freeswitch.com/oss" rel="noreferrer" target="_blank">https://freeswitch.com/oss</a><br>
<a href="https://freeswitch.org/confluence" rel="noreferrer" target="_blank">https://freeswitch.org/confluence</a><br>
<a href="https://cluecon.com" rel="noreferrer" target="_blank">https://cluecon.com</a><br>
<br>
FreeSWITCH-users mailing list<br>
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org" target="_blank">FreeSWITCH-users@lists.freeswitch.org</a><br>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" rel="noreferrer" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" rel="noreferrer" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
<a href="https://freeswitch.com" rel="noreferrer" target="_blank">https://freeswitch.com</a></blockquote></div></div>
_________________________________________________________________________<br>
Professional FreeSWITCH Services<br>
<a href="mailto:sales@freeswitch.com" target="_blank">sales@freeswitch.com</a><br>
<a href="https://freeswitch.com" rel="noreferrer" target="_blank">https://freeswitch.com</a><br>
<br>
Official FreeSWITCH Sites<br>
<a href="https://freeswitch.com/oss" rel="noreferrer" target="_blank">https://freeswitch.com/oss</a><br>
<a href="https://freeswitch.org/confluence" rel="noreferrer" target="_blank">https://freeswitch.org/confluence</a><br>
<a href="https://cluecon.com" rel="noreferrer" target="_blank">https://cluecon.com</a><br>
<br>
FreeSWITCH-users mailing list<br>
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org" target="_blank">FreeSWITCH-users@lists.freeswitch.org</a><br>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" rel="noreferrer" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" rel="noreferrer" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
<a href="https://freeswitch.com" rel="noreferrer" target="_blank">https://freeswitch.com</a></blockquote></div>