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