CODEWITHSUNDEEP
mysqlodbcasteriskunixodbc
Tanuj Uttarwar
Tanuj Uttarwar

Reputation: 9

Error after ODBC configuration in MySQL

I have fired this query "# echo "select 1" | isql -v asterisk-connector" got error:

[01000][unixODBC][Driver Manager]Can't open lib '/usr/lib64/odbc/libmyodbc.so' : file not found [ISQL]ERROR: Could not SQLConnect

tried to Installing and Configuring ODBC like wise

sudo apt-get install unixODBC unixODBC-dev

This is the configuration of ODBC for MySQL in /etc/odbcinst.ini:

[MySQL]

Description = ODBC for MySQL
Driver = /usr/lib/odbc/libmyodbc.so
Setup = /usr/lib/odbc/libodbcmyS.so
FileUsage = 1

Upvotes: 1

Views: 6229

Answers (2)

Azhar Nawaz
Azhar Nawaz

Reputation: 91

You need reinstall ODBC Driver and make an appropiate link to driver libraries.

Here are the full details:

https://blog.onesconsultants.com/2018/08/troubleshooting-odbc-module-in-asterisk.html

Upvotes: 1

Ron
Ron

Reputation: 6551

why don't you try installing:
asterisk-addons - An addons package, which includes MySQL support for call detail records

A guide how to use it:
http://www.voip-info.org/wiki/view/Asterisk+cmd+MYSQL

Upvotes: 1

Related Questions