Hi all,
I write lua program to connect with mysql db through ODBC & play the things. But it is not work due to /usr/local/lib/libmyodbc5.so' : file not found.But it is there. Pls advice to solve this problem.
[root@test]# ll /usr/local/lib/libmyodbc5.so
-rwxr-xr-x 1 root root 318366 Dec 1 07:06 /usr/local/lib/libmyodbc5.so
freeswitch.log =>
2011-12-01 07:30:15.386020 [DEBUG] switch_rtp.c:2699 Correct ip/port confirmed.
2011-12-01 07:30:17.206663 [INFO] switch_cpp.cpp:1190 TEST_DB - db_connection2011-12-01 07:30:17.206663 [ERR] switch_odbc.c:365 STATE: 01000 CODE 0 ERROR: [unixODBC][Driver Manager]Can't open lib '/usr/local/lib/libmyodbc5.so' : file not found
2011-12-01 07:30:17.206663 [CRIT] switch_core_sqldb.c:381 Failure!
2011-12-01 07:30:17.206663 [INFO] switch_cpp.cpp:1190 TEST_DB - cannot connect to database
/usr/local/etc/odbcinst.ini
[MySQL]
Description=ODBC for MySQL
Driver=/usr/local/lib/libmyodbc5.so
UsageCount=2
/usr/local/etc/odbc.ini
[freeswitch_odbc]
Driver=MySQL
SERVER=localhost
PORT=3306
DATABASE=vm
Socket = /tmp/mysql.sock
[root@test]# isql -v freeswitch_odbc root test
+---------------------------------------+
| Connected! |
| |
| sql-statement |
| help [tablename] |
| quit |
| |
+---------------------------------------+
SQL>
[root@test]# mysql -V
mysql Ver 14.14 Distrib 5.5.18, for Linux (i686) using EditLine wrapper
Br
Sanath