[Freeswitch-users] mod_nibblebill ODBC issue

[Steven Ayre]

2010-12-12 18:01:24.112413 [CRIT] mod_nibblebill.c:223 Cannot connect
to ODBC driver/database bandwidth.com (user: bandwidth.com / pass
password)!

Those are the default settings. I think you've probably loaded the
module with the default options before you saved the new nibblebill
config file.

Try running these commands at the console/cli:
reloadxml
reload mod_nibblebill

Also, check you're editing the correct nibblebill.conf.xml file, which
will be at
/usr/local/freeswitch/conf/autoload_configs/nibblebill.conf.xml

You won't need to check the DSN settings for any other files - nibble
bill will only use its own DSN setting.

-Steve


On 12 December 2010 20:02, Rafqat . <rafonline at hotmail.com> wrote:
>
> Hi,
>
> I have a problem trying to get mod_nibblebill to work.  I have thought I had
> done everything to get it to work but obviously not:
>
> 2010-12-12 18:01:24.112241 [ERR] switch_odbc.c:313 STATE: IM002 CODE 0
> ERROR: [unixODBC][Driver Manager]Data source name not found, and no default
> driver specified
>
> 2010-12-12 18:01:24.112413 [CRIT] mod_nibblebill.c:223 Cannot connect to
> ODBC driver/database bandwidth.com (user: bandwidth.com / pass password)!
>
> Do I need to update more than just the nibblebill conf file?
>
> Any help is much appreciated
>
> CHeers
>
> Raf
>
>
> My /etc/odbc.ini file:
>
> [FreeSWITCH]
> Driver   = MySQL
> SERVER   = localhost
> PORT     = 3306
> DATABASE = FreeSWITCH
> OPTION  = 67108864
> Socket   = /var/lib/mysql/mysql.sock
>
> My /etc/odbcinst.ini file:
>
> # Example driver definitinions
> #
> #
> # Included in the unixODBC package
> #[PostgreSQL]
> #Description    = ODBC for PostgreSQL
> #Driver         = /usr/lib/libodbcpsql.so
> #Setup          = /usr/lib/libodbcpsqlS.so
> #FileUsage      = 1
>
> # Driver from the MyODBC package
> # Setup from the unixODBC package
> [MySQL]
> Description     = ODBC for MySQL
> Driver            = /usr/lib64/libmyodbc3.so
> Setup            = /usr/lib64/libodbcmyS.so
> FileUsage      = 1
>
> Snippet of my nibblebill.conf.xml file:
>
> <!-- Information for connecting to your database -->
> <param name="db_username" value="rafqat"/>
> <param name="db_password" value="?????"/>
> <param name="db_dsn" value="FreeSWITCH"/>
>
>
> I have even setup the following links:
>
> mkdir /usr/local/freeswitch/etc
> ln -s /etc/odbcinst.ini /usr/local/freeswitch/etc/odbcinst.ini
> ln -s /etc/odbc.ini /usr/local/freeswitch/etc/odbc.ini
>
> I can connect successfully using isql:
>
> isql FreeSWITCH rafqat ??????
>
>
>
>
>
>
>
>
> _______________________________________________
> 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
>
>