asterisk ODBC Data source name not found debian 9

0

I've been trying to get odbc working with asterisk.

As of now, I think the fault is with ODBC/driver/packages as I am not able to even run isql command and get output:

Error : 
root@odbctest:/home/scsupport# isql -v asterisk-connector asterisk asterisk
[IM002][unixODBC][Driver Manager]Data source name not found, and no default driver specified
[ISQL]ERROR: Could not SQLConnect
root@odbctest:/home/scsupport#

Below is quick rundown

  1. Mysql is configure
  2. odbc.ini and odbcinst.ini are setup
  3. Have installed required packages but still not sure if i have missed any
  4. Downlaoded mariaDB wget https://downloads.mariadb.com/Connectors/odbc/connector-odbc-2.0.19/mariadb-connector-odbc-2.0.19-ga-debian-x86_64.tar.gz

I have followed asterisks guide page but of course packges will be different so I have used apt-cache search to find packages

Guide I followed is : https://wiki.asterisk.org/wiki/display/AST/Getting+Asterisk+Connected+to+MySQL+via+ODBC

Here are details system and setup :

packages 
Debian 9.9
MariaDB : Distrib 10.1.38-MariaDB
Installed packages
ii  libcppdb-odbc0:amd64              0.3.1+dfsg-5                      amd64        SQL Connectivity Library (odbc backend)
ii  libodbc1:amd64                    2.3.4-1                           amd64        ODBC library for Unix
ii  odbcinst                          2.3.4-1                           amd64        Helper program for accessing odbc ini files
ii  odbcinst1debian2:amd64            2.3.4-1                           amd64        Support library for accessing odbc ini files
ii  unixodbc                          2.3.4-1                           amd64        Basic ODBC tools
ii  unixodbc-dev                      2.3.4-1                           amd64        ODBC libraries for UNIX (development files)

odbc.ini

root@odbctest:/home/scsupport# cat /etc/odbc.ini
[asterisk-connector]
Description = MySQL connection to 'asterisk' database
Driver = MySQL
Database = asterisk
Server = localhost
Port = 3306
Socket = /var/run/mysqld/mysqld.sock

odbcinst.ini

root@odbctest:/home/scsupport# cat /etc/odbcinst.ini
[MariaDB]
Description     = ODBC for MariaDB
Driver          = /usr/lib/libmaodbc.so
FileUsage       = 1
root@odbctest:/home/scsupport#

Krishnam

Posted 2019-06-30T08:22:49.910

Reputation: 301

No answers