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
- Mysql is configure
- odbc.ini and odbcinst.ini are setup
- Have installed required packages but still not sure if i have missed any
- 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#