VoIP Mailing List Archives

[ahmedmunir007 at gmail...]

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.html


But unfortunately my problem is unresolved then.




Kindly advise me, how can I resolve this problem?  

--
Regards,

Ahmed Munir

[todd.baumgartner at gm...]

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 (ahmedmunir007@gmail.com)> wrote: