ahmedmunir007 at gmail...
Guest
|
 Posted: Wed Oct 07, 2009 7:50 am Post subject: [Freeswitch-users] Configuring Nibble Bill |
 |
|
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.
| Quote: |
---------- Forwarded message ----------
From: Todd Baumgartner <todd.baumgartner@gmail.com (todd.baumgartner@gmail.com)>
To: freeswitch-users@lists.freeswitch.org (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 <ahmedmunir007@gmail.com (ahmedmunir007@gmail.com)> wrote:
| Quote: | 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 (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 (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 |
|
Search
