[Freeswitch-users] Using MySQL for CoreDB

[Ahmed Ajmal]

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

 

 

 

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20101124/5fdd319d/attachment.html