Hi, Thanks for replying. The advise u gave resolved my problem. I want to ask three questions related to nibble bills, as I 'm listing down below;
1- Can we select/use dynamic tables for billing using nibble bill? 2- Can we define more than two tables and attributes in nibblebill.conf.xml? 3- As Nibble bill is use to deduct amount of user account, Can we deduct minutes instead of cash? Because my case is, if a user buy a package and I only want to deducts his/her minutes. How we can resolve it by nibble bill? / What other way we can resolve it? Kindly advise soon. > > ---------- Forwarded message ---------- > From: Todd Baumgartner <todd.baumgart...@gmail.com> > To: freeswitch-users@lists.freeswitch.org > Date: Tue, 6 Oct 2009 10:31:06 -0400 > Subject: Re: [Freeswitch-users] Cannot connect to ODBC driver/database > freeswitchdb > 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 <ahmedmunir...@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@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 > > -- Regards, Ahmed Munir
_______________________________________________ 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
