Hi I have been struggling to setup CoreDB to use MySQL but no luck so far. Before that I was using an older version of ODBC connector which Freeswitch was able to connect to however wasn't able to make multi-line statements as they were not supported in that particular ODBC connector release, so I upgraded to mysql-connector-odbc-5.1.8 which solves the multi-line statement problem but now freeswitch is unable to connect to the db at startup heres what the console prints: 2010-11-24 08:46:26.006947 [INFO] switch_core_sqldb.c:1616 Opening DB 2010-11-24 08:46:26.011415 [CRIT] switch_odbc.c:210 The sql server is not responding for DSN fs [][188] 2010-11-24 08:46:26.011454 [INFO] switch_odbc.c:215 The connection has been re-established . and this goes on and on for a while after which the process terminates. Heres what my odbcinst and odbc files look like: Odbcinst.ini Description = ODBC for MySQL Driver = /usr/lib64/libmyodbc5.so Setup = /usr/lib64/libmyodbc3S.so UsageCount = 1 FileUsage = 1 Odbc.ini [fs] Driver = MySQL SERVER = 208.xx.xxx.xxx USER = fsuser PASSWORD = fsuser DATABASE = freeswitch PORT = 3306 Option = 67108864 I am on a 64 bit CentOS with FreeSWITCH Version 1.0.head (git-e828282 2010-11-24 06-07-21 +0000). MySQL Server version: 5.1.44-community MySQL Community Server (GPL). Thanks Ahmed
participants (1)
-
Ahmed Ajmal