As per the debug logs, the name of the dsn is missing a "n" inside FreeSWITCH. Regards HASSAN On 2010-10-20, budi wibowo <bwibowo@gmail.com> wrote:
dear all
i install mod_nibblebil on centos 5.5 according to steps in http://wiki.freeswitch.org/wiki/Using_ODBC_in_the_core
odbc.ini config: [fs_connect] Driver = mySQL SERVER = localhost PORT = 3306 DATABASE = fs OPTION = 67108864 Socket = /var/lib/mysql/mysql.sock
switch.conf.xml i add this
<param name="odbc-dsn" value="fs_connect:root:rootpass" />
if i execute isql fs_connect root rootpass it's the result +---------------------------------------+ | Connected! | | | | sql-statement | | help [tablename] | | quit | | | +---------------------------------------+ SQL>
but i found this error, where's my mistake ?
i 2010-10-20 07:20:39.411254 [CRIT] switch_odbc.c:210 The sql server is not responding for DSN fs_conect [STATE: 08003 CODE 0 ERROR: [unixODBC][Driver Manager]Connnection does not exist ][169] 2010-10-20 07:20:39.411254 [CRIT] switch_odbc.c:218 The connection could not be re-established 2010-10-20 07:20:40.412241 [ERR] switch_odbc.c:318 STATE: IM002 CODE 0 ERROR: [unixODBC][Driver Manager]Data source name not found, and no default driver specified
2010-10-20 07:20:40.412241 [CRIT] switch_odbc.c:210 The sql server is not responding for DSN fs_conect [STATE: 08003 CODE 0 ERROR: [unixODBC][Driver Manager]Connnection does not exist ][169] 2010-10-20 07:20:40.412241 [CRIT] switch_odbc.c:218 The connection could not be re-established 2010-10-20 07:20:41.412257 [ERR] switch_odbc.c:318 STATE: IM002 CODE 0 ERROR: [unixODBC][Driver Manager]Data source name not found, and no default driver specified
2010-10-20 07:20:41.412257 [CRIT] switch_odbc.c:210 The sql server is not responding for DSN fs_conect [STATE: 08003 CODE 0 ERROR: [unixODBC][Driver Manager]Connnection does not exist
regards
budi
-- Sent from my mobile device