[Freeswitch-users] Cannot connect to ODBC driver/database freeswitchdb

[Todd Baumgartner]

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 at 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.html
>
> 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 at lists.freeswitch.org
> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
> http://www.freeswitch.org
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20091006/ade9ac36/attachment-0002.html