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 ??????
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
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/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 _______________________________________________ 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
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
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? Cheers Raf 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/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 _______________________________________________ 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
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
Which variables do I need to set? I am suprised to see the following line in my error output: 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)! I looked at the mod_nibblebill.c source code to see when the values for the variables used in this error message get set. They should be getting set from the values in the nibblebill config file, so I have no idea how 'bandwidth.com' gets to be in the variable globals.db_dsn. All seems very odd. Please help. Cheers Raf From: infos@madovsky.org To: freeswitch-users@lists.freeswitch.org Date: Sun, 12 Dec 2010 15:50:20 -0500 Subject: Re: [Freeswitch-users] mod_nibblebill ODBC issue 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? Cheers Raf 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/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 _______________________________________________ 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
I am a total idiot! I was changing the wrong nibblebill conf file! Thanks very much guys. Sorry for wasting your time. Cheers Raf From: rafonline@hotmail.com To: freeswitch-users@lists.freeswitch.org Date: Sun, 12 Dec 2010 21:04:00 +0000 Subject: Re: [Freeswitch-users] mod_nibblebill ODBC issue Which variables do I need to set? I am suprised to see the following line in my error output: 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)! I looked at the mod_nibblebill.c source code to see when the values for the variables used in this error message get set. They should be getting set from the values in the nibblebill config file, so I have no idea how 'bandwidth.com' gets to be in the variable globals.db_dsn. All seems very odd. Please help. Cheers Raf From: infos@madovsky.org To: freeswitch-users@lists.freeswitch.org Date: Sun, 12 Dec 2010 15:50:20 -0500 Subject: Re: [Freeswitch-users] mod_nibblebill ODBC issue 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? Cheers Raf 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/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 _______________________________________________ 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 _______________________________________________ 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
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
participants (3)
-
Madovsky
-
Rafqat .
-
Steven Ayre