WARNING[96990]: res_odbc.c:1083 odbc_obj_connect: res_odbc: Error SQLConnect=-1 errno=0 [unixODBC][Driver Manager]Can’t open lib ‘/usr/lib/x86_64-linux-gnu/odbc/libmyodbc8w.so’ : file not
/usr/lib/x86_64-linux-gnu/odbc/libmyodbc8w.so file is exist.
WARNING[96990]: res_odbc.c:1083 odbc_obj_connect: res_odbc: Error SQLConnect=-1 errno=0 [unixODBC][Driver Manager]Can’t open lib ‘/usr/lib/x86_64-linux-gnu/odbc/libmyodbc8w.so’ : file not
/usr/lib/x86_64-linux-gnu/odbc/libmyodbc8w.so file is exist.
It seems the content of /etc/odbcinst.ini doesn’t match the way ODBC is installed on your host.
Before connecting from Asterisk, a first step is to connect to your ODBC database through isql, for instance. For this to succeed, you’ll to edit /etc/odbcinst.ini or /etc/odbc.ini.
For a more helpful answer, provide more details on your host setup (linux version, …).
This is the typical error when the ODBC connector package dependencies are not properly installed. As mentioned before, you need to make sure you have a connection to the Linux OS level using ISQL and ensure that your ODBC configuration files are pointing to the correct library and are installed on your system. This is more of a Linux package installation issue than an Asterisk issue itself.
Thankyou for your reply
Server Details:
Distributor ID: Ubuntu
Description: Ubuntu 22.04.4 LTS
Release: 22.04
Codename: jammy
can you please provide the steps for install ODBC
@anas27 you can follow this video to setup odbc with mysql/mariadb:
This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.