I try to execute the following command and receive this error:
[root@localhost ~]# isql -v asterisk-connector
[01000][unixODBC][Driver Manager]Can't open lib '/usr/lib/libmyodbc.so' : /usr/lib/libmyodbc.so: cannot open shared object file: No such file or directory [ISQL]ERROR: Could not SQLConnect
I have checked and libmyodbc.so does not exist?
I have used:
yum install mysql-connector-odbc
yum install unixODBC
I need to use this odbc to connect to Asterisk. My System is CentOS. MySQL is already installed. I cannot figure out what I have done wrong in the installation process. what should I do?
NOTE this command does not work:
yum install MyODBC
No package MyODBC available.
here are my odbc files
/etc/odbc.ini
[asterisk-connector]
driver = MySQL
Database = test
Server = localhost
Socket = /var/lib/mysql/mysql.sock
User = root
Password = password
/etc/odbcinst.ini
Driver from the MyODBC package
Setup from the unixODBC package
[MySQL]
Description = ODBC for MySQL
Driver = /usr/lib/libmyodbc.so
Setup = /usr/lib/libodbcmyS.so
FileUsage = 1