Mabe your system env variables are not set. it looks like odbc can't find the path... ----- Original Message ----- From: Rafqat . To: freeswitch-users@lists.freeswitch.org Sent: Sunday, December 12, 2010 3:36 PM Subject: Re: [Freeswitch-users] mod_nibblebill ODBC issue I only updated the nibblebill config file with the following: <!-- Information for connecting to your database --><param name="db_username" value="rafqat"/><param name="db_password" value="?????"/><param name="db_dsn" value="FreeSWITCH"/>I did not change any of the dsn related stuff in any of the other FreeSWITCH config files.I dont see why I should be changing other freeswitch config files, can't one use a different database for the billing side of things? It seems odd to allow dsn config to be added to the nibblebill conf file but not actually get used?or am i missing the point?CheersRaf ------------------------------------------------------------------------------ From: infos@madovsky.org To: freeswitch-users@lists.freeswitch.org Date: Sun, 12 Dec 2010 15:27:39 -0500 Subject: Re: [Freeswitch-users] mod_nibblebill ODBC issue what did you write on every db_dsn in Freeswitch config ? ----- Original Message ----- From: Rafqat . To: freeswitch-users@lists.freeswitch.org Sent: Sunday, December 12, 2010 3:19 PM Subject: Re: [Freeswitch-users] mod_nibblebill ODBC issue More than what I have already specified? 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 ---------------------------------------------------------------------------- From: infos@madovsky.org To: freeswitch-users@lists.freeswitch.org Date: Sun, 12 Dec 2010 15:11:32 -0500 Subject: Re: [Freeswitch-users] mod_nibblebill ODBC issue you have to specify a unix odbc drivers, usually in /etc/odbc.ini /etc/odbcinst.ini ----- Original Message ----- From: Rafqat . To: freeswitch-users@lists.freeswitch.org Sent: Sunday, December 12, 2010 3:02 PM Subject: [Freeswitch-users] mod_nibblebill ODBC issue 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/etcln -s /etc/odbcinst.ini /usr/local/freeswitch/etc/odbcinst.iniln -s /etc/odbc.ini /usr/local/freeswitch/etc/odbc.iniI 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 _______________________________________________ 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 ---------------------------------------------------------------------------- _______________________________________________ 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 _______________________________________________ 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 ------------------------------------------------------------------------------ _______________________________________________ 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