odbc issues with Deb9. how FS community members solve them ?
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.
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
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
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. For both those test you will need to remove the related OS installed packages. On Tue, Nov 27, 2018 at 09:49 Yuriy Nasida <ynasida@gmail.com> wrote:
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
Thank you Joel! I didn't try your advice for #1 but will keep it in mind in case of extra issues with pgsq-odbc. My issue #1 was solved by changing in postgresql.conf client_min_messages = debug5 to client_min_messages = notice One great guy - Hiroshi Inoue (pgsql-odbc community) adviced this trick. Thanks! On Wed, 28 Nov 2018 at 13:47, Joel Serrano <joel@textplus.com> wrote:
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.
For both those test you will need to remove the related OS installed packages.
On Tue, Nov 27, 2018 at 09:49 Yuriy Nasida <ynasida@gmail.com> wrote:
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
_________________________________________________________________________ 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
Historically I've found MyODBC has always been prone to segfaults, even with threading=2. Are the latest connectors from Oracle and MariaDB any better? On Tue, 27 Nov 2018 at 15:52, 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
participants (3)
-
Joel Serrano
-
Steven Ayre
-
Yuriy Nasida