Thanks a lot Joel!  

You advice about #2 works great for me.

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 :(

On Tue, 27 Nov 2018 at 18:57, Joel Serrano <joel@textplus.com> wrote:

Not sure for #1. 

But for #2 you should download the official ODBC MySQL connector for your OS (Debian/ubuntu available), that includes libmyodbc.so:

https://dev.mysql.com/downloads/connector/odbc/

NOTE: you will have to register with oracle.com to download it. 

Cheers,

Joel. 

On Mon, Nov 26, 2018 at 13:53 Yuriy Nasida <ynasida@gmail.com> wrote:

Hi guys,

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. 

Which issues ?

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:)

# isql -v pgsqldsn

DEBUG:  CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGR, xid/subid/cid: 0/1/0

Segmentation fault

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.

Please advce that you use to get odbc working with Deb9 

Thanks. 

_________________________________________________________________________
Professional FreeSWITCH Services
sales@freeswitch.com
https://freeswitch.com

Official FreeSWITCH Sites
https://freeswitch.com/oss
https://freeswitch.org/confluence
https://cluecon.com

FreeSWITCH-users mailing list
FreeSWITCH-users@lists.freeswitch.org
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
https://freeswitch.com

_________________________________________________________________________
Professional FreeSWITCH Services
sales@freeswitch.com
https://freeswitch.com

Official FreeSWITCH Sites
https://freeswitch.com/oss
https://freeswitch.org/confluence
https://cluecon.com

FreeSWITCH-users mailing list
FreeSWITCH-users@lists.freeswitch.org
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
https://freeswitch.com

_________________________________________________________________________
Professional FreeSWITCH Services
sales@freeswitch.com
https://freeswitch.com

Official FreeSWITCH Sites
https://freeswitch.com/oss
https://freeswitch.org/confluence
https://cluecon.com

FreeSWITCH-users mailing list
FreeSWITCH-users@lists.freeswitch.org
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
https://freeswitch.com