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@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@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org