[asterisk-bugs] [JIRA] (ASTERISK-25895) ODBC configuration not working with Postgres on Debian 8.4_64

[Sean Brady (JIRA)]

     [ https://issues.asterisk.org/jira/browse/ASTERISK-25895?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Sean Brady updated ASTERISK-25895:
----------------------------------

    Attachment: odbcinst.ini
                odbc.ini
                res_odbc.conf

All relevant configuration files, all of which work with 13.7.2

> ODBC configuration not working with Postgres on Debian 8.4_64
> -------------------------------------------------------------
>
>                 Key: ASTERISK-25895
>                 URL: https://issues.asterisk.org/jira/browse/ASTERISK-25895
>             Project: Asterisk
>          Issue Type: Bug
>      Security Level: None
>          Components: Resources/res_odbc
>    Affects Versions: 13.8.0
>         Environment: Debian 8.4 x84_64 on Digital Ocean 512 Mb instance with virtio installed. Using the base Debian image. All postgres and odbc related items from install_prereq have been installed
>            Reporter: Sean Brady
>            Severity: Critical
>         Attachments: odbc.ini, odbcinst.ini, res_odbc.conf
>
>
> Res_odbc will not connect. Identical configuration worked on 13.7.2 on this VM and is working on other instances of 13.7.2. Upgrade of 13.8.0 results in res_odbc failing to connect. 
> Connected to Asterisk 13.8.0 currently running on ast00 (pid = 16338)
> ast00*CLI> core set debug 10
> Core debug was 3 and is now 10.
> ast00*CLI> core set verbose 10
> Console verbose was OFF and is now 10.
> ast00*CLI> module reload res_odbc
> Module 'res_odbc' reloaded successfully.
>     -- Reloading module 'res_odbc.so' (ODBC resource)
>   == Parsing '/var/deploy/base/asterisk/conf/res_odbc.conf': Found
> [Apr  7 02:05:03] WARNING[16504]: res_odbc.c:821 odbc_obj_connect: res_odbc: Error SQLConnect=-1 errno=0 [unixODBC][Driver Manager]Data source name not found, and no default driver specified
> [Apr  7 02:05:03] NOTICE[16504]: res_odbc.c:585 load_odbc_config: Registered ODBC class 'cairn_postgres' dsn->[cairn_postgres]



--
This message was sent by Atlassian JIRA
(v6.2#6252)