Issue with installing MySQL ODBC on asterisk 11

Asterisk Asterisk Support
1

Please I’m having a little issue with installing mysql odbc on asterisk. I’ve done the installation and configuration. But the issue now is that when I try to test my connection to the database, I’m getting an error saying:

root@ubuntu:/usr/lib/x86_64-linux-gnu/odbc# isql -vvv asterisk-connector
[01000][unixODBC][Driver Manager]Can't open lib '/usr/lib/x86_84-linux-gnu/odbc/libmyodbc.so' : file not found
[ISQL]ERROR: Could not SQLConnect

And I checked this particular file and could find it in the correct path listed above:

root@ubuntu:/usr/lib/x86_64-linux-gnu/odbc# ls
libesoobS.so  libmyodbc.so  libodbcdrvcfg1S.so  libodbcminiS.so  libodbcnnS.so    libodbctxtS.so  liboraodbcS.so  libtdsS.so
libmimerS.so  libnn.so      libodbcdrvcfg2S.so  libodbcmyS.so    libodbcpsqlS.so  liboplodbcS.so  libsapdbS.so

Also below is the log file showing the attempt and error while trying to connect to the database:

[Jan 30 08:32:22] NOTICE[1088] res_odbc.c: Connecting asterisk
[Jan 30 08:32:22] WARNING[1088] res_odbc.c: res_odbc: Error SQLConnect=-1 errno=0 [unixODBC][Driver Manager]Can't open lib '/usr/lib/x86_84-linux-gnu/odbc/libmyodbc.so' : file not f
[Jan 30 08:32:22] WARNING[1088] res_odbc.c: Failed to connect to asterisk
[Jan 30 08:32:22] NOTICE[1088] res_odbc.c: Registered ODBC class 'asterisk' dsn->[asterisk-connector]
[Jan 30 08:32:22] NOTICE[1088] res_odbc.c: res_odbc loaded.
2

System has been pretty explicit about , what is one of the issues, also Asterisk 11 is dead since 2017-10-25

I will share the configuration of one of my system, so hopefully it will helps others on the future

Ubuntu 16.04.3 LTS \n \l

/etc/odbcinst.ini

[MySQL]
Description = ODBC for MySQL
Driver = /usr/lib/x86_64-linux-gnu/odbc/libmyodbc5a.so
Setup = /usr/lib/x86_64-linux-gnu/odbc/libodbcmyS.so
FileUsage = 1

 /etc/odbc.ini

[asterisk-connector]
Description           = MySQL connection to 'asterisk' database
Driver                = MySQL
Database              = asterisk
Server                = localhost
UserName              = root
Password              = password
Port                  = 3306
Socket                = /var/run/mysqld/mysqld.sock

res_odbc.conf

[asterisk]
enabled => yes
dsn =>asterisk-connector
username => root
password => password
pre-connect => yes

cdr_adaptive_odbc.conf

[asterisk-mysql]
connection=asterisk
table=cdr
alias start => calldate

http://asteriskdocs.org/en/3rd_Edition/asterisk-book-html-chunk/installing_configuring_odbc.html

3

Hi @ambiorixg12
Let me share my configuration too.
But my issue as explained in my question is that why am I getting the error saying file not found when the file path is correct and the file is in the correct folder with correct file name?

root@ubuntu:/etc# less odbc.ini 
[asterisk-connector]
Description             = MySQL connection to 'asterisk' database
Driver                = MySQL
Database          = asterisk
User                  = root
Password          = password
Server          = localhost
Port            = 3306
Socket          = /var/run/mysqld/mysqld.sock

root@ubuntu:/etc# less odbcinst.ini 
[MySQL]
Description = ODBC for MySQL
Driver = /usr/lib/x86_84-linux-gnu/odbc/libmyodbc.so
Setup = /usr/lib/x86_64-linux-gnu/odbc/libodbcmyS.so
FileUsage = 1

root@ubuntu:/etc# less res_odbc.conf
[asterisk]
enabled => yes
dsn => asterisk-connector
username => root
password => password
pre-connect => yes
4

Hi.
I had similar problem, and resolved has two points. First. Are you sure, you are connecting to mysql not to mariadb, second please check sumcontrol for that file, the file maybe corrupt ant this is why you have warning about file not exist