[Freeswitch-users] nibblebill custom_sql_save

Thu Feb 21 18:43:23 MSK 2013

Not sure what you mean below. You want to charge every 10 seconds (billing
interval) or you want to charge 10 cents per minute (billing rate)?

Thank you.

On Thu, Feb 21, 2013 at 1:49 PM, David Villasmil <
david.villasmil.work at gmail.com> wrote:

> Hello,
>
> Thanks for replying!
>
> It was not set, but i understood from the wiki that if you don't want any
> rounding, you dont't set it.
>
> I set it to "10", i want the user to be charged tvery 10 seconds, you
> nibblebil is charging 10 DOLLARS!
> I must be getting something wrong...
>
>
> Here's my nibblebill.conf.xml.
>
> (BTW, the two highlighted lines, is it possible to do that? I want the
> custom SQLs to use channel variables, is it possible?)
>
>
>     <section name="configuration">
>         <configuration name="nibblebill.conf" description="Nibble Billing">
>             <settings>
>                 <param name="db_username" value="myroot" />
>                 <param name="db_password" value="mypass" />
>                 <param name="odbc-dsn" value="odbc://viking" />
>                 <param name="db_table" value="sip_users" />
>                 <param name="db_column_cash" value="balance" />
>                 <param name="db_column_account" value="id" />
>                 *<param name="custom_sql_lookup" value="SELECT
> ${variable_card_db_column_cash} AS nibble_balance FROM
> ${variable_card_db_table} WHERE
> ${variable_card_db_column_account}=${nibble_account};" />*
> *                <param name="custom_sql_save" value="UPDATE
> ${variable_card_db_table} SET
> ${variable_card_db_column_cash}=${variable_card_db_column_cash}-${nibble_increment}
> WHERE ${variable_card_db_column_account}=${nibble_account};" />*
>                 <param name="global_heartbeat" value="10" />
>                 <param name="lowbal_amt" value="0" />
>                 <param name="lowbal_action" value="play ding" />
>                 <param name="nobal_amt" value="0" />
>                 <param name="nobal_action" value="hangup" />
>                 <param name="percall_max_amt" value="100" />
>                 <param name="percall_action" value="hangup" />
>             </settings>
>         </configuration>
>     </section>
>
> Here's the dialplan:
>
>     <section name="dialplan">
>         <context name="route_call">
>             <extension name="routeCall">
>                 <condition field="destination_number" expression="^.*">
>                     <action application="set"
> data="continue_on_fail=NO_ROUTE_DESTINATION,UNALLOCATED_NUMBER,407" />
>                     <action application="set" data="sip_from_user=1002" />
>                     <action application="set"
> data="sip_auth_username=1002" />
>                     <action application="set" data="sip_req_user=1002" />
>                     <action application="set"
> data="hangup_after_bridge=true" />
>                     <action application="set" data="nibble_rate=0.0500" />
>                     <action application="nibblebill" data="heartbeat 10" />
>                     <action application="set"
> data="card_db_table=cards_table" />
>                     <action application="set"
> data="card_db_column_cash=balance" />
>                     <action application="set"
> data="card_db_column_account=pin" />
>                     <action application="set" data="nibble_account=12345"
> />
>                     <action application="set"
> data="gw=${distributor(TEST_ROUTE)}" />
>                     <action application="limit" data="hash $${domain}
> $${domain} ${sip_auth_username} 1 !NORMAL_TEMPORARY_FAILURE" />
>                     <action application="export"
> data="execute_on_answer=nibblebill adjust -0.1000" />
>                     <action application="bridge"
> data="{enable_heartbeat_events=10,nibble_rate=0.0500,nibble_account=12345}sofia/gateway/${gw}/0013058883456"
> />
>                 </condition>
>             </extension>
>         </context>
>     </section>
>
>
> Thanks for your help!
>
>
> David
>
>
>
> On Wed, Feb 20, 2013 at 2:23 PM, Muhammad Shahzad <shaheryarkh at gmail.com>wrote:
>
>> Did you set nibble_increment variable? e.g.
>>
>> <variable name="nibble_increment" value="30" />
>>
>> Here is its details,
>>
>> http://wiki.freeswitch.org/wiki/Mod_nibblebill#Nibble_Method_.28Default.29
>>
>> Thank you.
>>
>>
>> On Wed, Feb 20, 2013 at 2:10 PM, David Villasmil <
>> david.villasmil.work at gmail.com> wrote:
>>
>>> Anyone about this?
>>>
>>> Thanks
>>>
>>>
>>> On Mon, Feb 18, 2013 at 2:07 PM, David Villasmil <
>>> david.villasmil.work at gmail.com> wrote:
>>>
>>>> Hello guys,
>>>>
>>>> I have the following config for nibbebill:
>>>>
>>>>                 <param name="custom_sql_lookup" value="SELECT
>>>> ${card_db_column_cash} AS nibble_balance FROM ${card_db_table} WHERE
>>>> ${card_db_column_account}=${nibble_account};" />
>>>>                 <param name="custom_sql_save" value="UPDATE
>>>> ${card_db_table} SET
>>>> ${card_db_column_cash}=${card_db_column_cash}-${nibble_increment} WHERE
>>>> ${card_db_column_account}=${nibble_account};" />
>>>>
>>>> I see this on the log, which is obviously failing:
>>>>
>>>>
>>>>  [UPDATE cards_table SET balance=balance- WHERE pin=12345;]
>>>>
>>>> is ${nibble_increment} not the correct variable to use? It looks like
>>>> it is empty!
>>>>
>>>> Thanks!
>>>>
>>>> David
>>>>
>>>
>>>
>>> _________________________________________________________________________
>>> Professional FreeSWITCH Consulting Services:
>>> consulting at freeswitch.org
>>> http://www.freeswitchsolutions.com
>>>
>>> 
>>> 
>>>
>>> Official FreeSWITCH Sites
>>> http://www.freeswitch.org
>>> http://wiki.freeswitch.org
>>> http://www.cluecon.com
>>>
>>> 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
>>>
>>>
>>
>>
>> --
>> Muhammad Shahzad
>> -----------------------------------
>> CISCO Rich Media Communication Specialist (CRMCS)
>> CISCO Certified Network Associate (CCNA)
>> Cell: +49 176 99 83 10 85
>> MSN: shari_786pk at hotmail.com
>> Email: shaheryarkh at googlemail.com
>>
>> _________________________________________________________________________
>> Professional FreeSWITCH Consulting Services:
>> consulting at freeswitch.org
>> http://www.freeswitchsolutions.com
>>
>> 
>> 
>>
>> Official FreeSWITCH Sites
>> http://www.freeswitch.org
>> http://wiki.freeswitch.org
>> http://www.cluecon.com
>>
>> 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
>>
>>
>
> _________________________________________________________________________
> Professional FreeSWITCH Consulting Services:
> consulting at freeswitch.org
> http://www.freeswitchsolutions.com
>
> 
> 
>
> Official FreeSWITCH Sites
> http://www.freeswitch.org
> http://wiki.freeswitch.org
> http://www.cluecon.com
>
> 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
>
>

-- 
Muhammad Shahzad
-----------------------------------
CISCO Rich Media Communication Specialist (CRMCS)
CISCO Certified Network Associate (CCNA)
Cell: +49 176 99 83 10 85
MSN: shari_786pk at hotmail.com
Email: shaheryarkh at googlemail.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20130221/73280056/attachment.html 