| Summary: | ASTERISK-25895: ODBC configuration not working with Postgres on Debian 8.4_64 | ||
| Reporter: | Sean Brady (TheSeanBrady) | Labels: | |
| Date Opened: | 2016-04-07 03:06:32 | Date Closed: | 2016-04-07 03:48:08 |
| Priority: | Critical | Regression? | |
| Status: | Closed/Complete | Components: | Resources/res_odbc |
| Versions: | 13.8.0 | Frequency of Occurrence | Constant |
| Related Issues: | |||
| 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 | Attachments: | ( 0) odbc.ini ( 1) odbcinst.ini ( 2) res_odbc.conf |
| Description: | 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] | ||
| Comments: | By: Asterisk Team (asteriskteam) 2016-04-07 03:06:34.249-0500 Thanks for creating a report! The issue has entered the triage process. That means the issue will wait in this status until a Bug Marshal has an opportunity to review the issue. Once the issue has been reviewed you will receive comments regarding the next steps towards resolution. A good first step is for you to review the [Asterisk Issue Guidelines|https://wiki.asterisk.org/wiki/display/AST/Asterisk+Issue+Guidelines] if you haven't already. The guidelines detail what is expected from an Asterisk issue report. Then, if you are submitting a patch, please review the [Patch Contribution Process|https://wiki.asterisk.org/wiki/display/AST/Patch+Contribution+Process]. By: Sean Brady (SeanBrady) 2016-04-07 03:22:28.744-0500 All relevant configuration files, all of which work with 13.7.2 By: Sean Brady (TheSeanBrady) 2016-04-07 03:48:08.421-0500 Issue with host platform discovered upon further troubleshooting. | ||