Hi all,<br>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. <br>
<br>[root@test]# ll /usr/local/lib/libmyodbc5.so<br>-rwxr-xr-x 1 root root 318366 Dec 1 07:06 /usr/local/lib/libmyodbc5.so<br><br>freeswitch.log =><br>2011-12-01 07:30:15.386020 [DEBUG] switch_rtp.c:2699 Correct ip/port confirmed.<br>
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<br>
2011-12-01 07:30:17.206663 [CRIT] switch_core_sqldb.c:381 Failure!<br>2011-12-01 07:30:17.206663 [INFO] switch_cpp.cpp:1190 TEST_DB - cannot connect to database<br><br>/usr/local/etc/odbcinst.ini <br>[MySQL]<br>Description=ODBC for MySQL<br>
Driver=/usr/local/lib/libmyodbc5.so<br>UsageCount=2<br><br>/usr/local/etc/odbc.ini<br>[freeswitch_odbc]<br>Driver=MySQL<br>SERVER=localhost<br>PORT=3306<br>DATABASE=vm<br>Socket = /tmp/mysql.sock<br><br>[root@test]# isql -v freeswitch_odbc root test<br>
+---------------------------------------+<br>| Connected! |<br>| |<br>| sql-statement |<br>| help [tablename] |<br>
| quit |<br>| |<br>+---------------------------------------+<br>SQL> <br><br><br>[root@test]# mysql -V<br>mysql Ver 14.14 Distrib 5.5.18, for Linux (i686) using EditLine wrapper<br>
<br><br><br>Br<br>
Sanath<br>