[Freeswitch-users] Mysql unixODBC problem

[Sanath Prasanna]

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 at 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 at test]# isql -v freeswitch_odbc root test
+---------------------------------------+
| Connected!                            |
|                                       |
| sql-statement                         |
| help [tablename]                      |
| quit                                  |
|                                       |
+---------------------------------------+
SQL>


[root at test]# mysql -V
mysql  Ver 14.14 Distrib 5.5.18, for Linux (i686) using  EditLine wrapper



Br
Sanath
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20111201/f942c1ca/attachment.html