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@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@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@gmail.com> wrote:
Anyone about this?
Thanks
On Mon, Feb 18, 2013 at 2:07 PM, David Villasmil < david.villasmil.work@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@freeswitch.org http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
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
-- Muhammad Shahzad ----------------------------------- CISCO Rich Media Communication Specialist (CRMCS) CISCO Certified Network Associate (CCNA) Cell: +49 176 99 83 10 85 MSN: shari_786pk@hotmail.com Email: shaheryarkh@googlemail.com
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
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
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
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
-- Muhammad Shahzad ----------------------------------- CISCO Rich Media Communication Specialist (CRMCS) CISCO Certified Network Associate (CCNA) Cell: +49 176 99 83 10 85 MSN: shari_786pk@hotmail.com Email: shaheryarkh@googlemail.com