[Freeswitch-users] Configuring Nibble Bill

[Ahmed Munir]

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.baumgartner at gmail.com>
> To: freeswitch-users at 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 at 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 at 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 at 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20091007/b45cfae3/attachment-0002.html