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