[Freeswitch-users] odbc issues with Deb9. how FS community members solve them ?

[Yuriy Nasida]

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 at 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 at 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 at 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 at 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 at 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 at 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 at 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 at 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 at 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 at 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 at 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 at lists.freeswitch.org
> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
> https://freeswitch.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20181129/94cdcd82/attachment-0001.html>