Cannot connect to ODBC driver/database freeswitchdb
Hi, I've installed FS on Ubuntu 9.04 and I want to run mod_nibbles on it. I follow the steps to configure my ODBC connection with MySQL as explained in wiki (mod_nibbles and mod_spidermonkey). But FS, unable to connect it. The error I got is listed below when I restart FS, 2009-10-06 15:47:21.164590 [ERR] switch_odbc.c:188 STATE: IM002 CODE 0 ERROR: [unixODBC][Driver Manager]Data source name not found, and no default driver specified 2009-10-06 15:47:21.164617 [CRIT] mod_nibblebill.c:221 Cannot connect to ODBC driver/database freeswitchdb (user: root / pass password) 2009-10-06 15:47:21.164650 [CONSOLE] switch_loadable_module.c:889 Successfully Loaded [mod_nibblebill] 2009-10-06 15:47:21.164664 [NOTICE] switch_loadable_module.c:248 Adding Application 'nibblebill' 2009-10-06 15:47:21.164710 [NOTICE] switch_loadable_module.c:270 Adding API Function 'nibblebill' But when I use isql it accepts my odbc connection i.e. isql MySQL-freeswitch I'm listing my settings of odbc.ini and odbcinst.ini as listed below; odbc.ini -------------- [MySQL-freeswitch] Driver = MySQL #Driver = /usr/lib/odbc/libodbcmyS.so Description = Connector/ODBC Driver DSN With FreeSwitch SERVER = localhost PORT = 3306 USER = root Password = password Database = freeswitchdb odbcinst.ini ------------------- [MySQL] Description = ODBC for MySQL Driver = /usr/lib/odbc/libmyodbc.so Setup = /usr/lib/odbc/libodbcmyS.so FileUsage = 1 odbc.ini and odbcinst.ini are located at /etc/. Even I set my odbc connection setting as I provide with this link; http://dev.mysql.com/doc/refman/5.0/en/connector-odbc-configuration-dsn-unix... But unfortunately my problem is unresolved then. Kindly advise me, how can I resolve this problem? -- Regards, Ahmed Munir
Hi, are you configured correctly the nibblebill.conf.xml file? BR
Ahmed, I believe you need to specify the database name as it is configured in the odbc.ini I am assuming you have something like this in your nibblebill.conf.xml <param name="db_dsn" value="freeswitchdb"/> Try changing it to this as it is named in the odbc.ini: <param name="db_dsn" value="MySQL-freeswitch"/> Thanks, Todd On Tue, Oct 6, 2009 at 6:11 AM, Ahmed Munir <ahmedmunir007@gmail.com> wrote:
Hi, I've installed FS on Ubuntu 9.04 and I want to run mod_nibbles on it. I follow the steps to configure my ODBC connection with MySQL as explained in wiki (mod_nibbles and mod_spidermonkey). But FS, unable to connect it. The error I got is listed below when I restart FS,
2009-10-06 15:47:21.164590 [ERR] switch_odbc.c:188 STATE: IM002 CODE 0 ERROR: [unixODBC][Driver Manager]Data source name not found, and no default driver specified 2009-10-06 15:47:21.164617 [CRIT] mod_nibblebill.c:221 Cannot connect to ODBC driver/database freeswitchdb (user: root / pass password) 2009-10-06 15:47:21.164650 [CONSOLE] switch_loadable_module.c:889 Successfully Loaded [mod_nibblebill] 2009-10-06 15:47:21.164664 [NOTICE] switch_loadable_module.c:248 Adding Application 'nibblebill' 2009-10-06 15:47:21.164710 [NOTICE] switch_loadable_module.c:270 Adding API Function 'nibblebill'
But when I use isql it accepts my odbc connection i.e. isql MySQL-freeswitch
I'm listing my settings of odbc.ini and odbcinst.ini as listed below;
odbc.ini -------------- [MySQL-freeswitch] Driver = MySQL #Driver = /usr/lib/odbc/libodbcmyS.so Description = Connector/ODBC Driver DSN With FreeSwitch SERVER = localhost PORT = 3306 USER = root Password = password Database = freeswitchdb
odbcinst.ini ------------------- [MySQL] Description = ODBC for MySQL Driver = /usr/lib/odbc/libmyodbc.so Setup = /usr/lib/odbc/libodbcmyS.so FileUsage = 1
odbc.ini and odbcinst.ini are located at /etc/. Even I set my odbc connection setting as I provide with this link; http://dev.mysql.com/doc/refman/5.0/en/connector-odbc-configuration-dsn-unix...
But unfortunately my problem is unresolved then.
Kindly advise me, how can I resolve this problem?
-- Regards,
Ahmed Munir
_______________________________________________ FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
participants (3)
-
Ahmed Munir
-
bakko
-
Todd Baumgartner