<p dir="ltr">There is a known bug and a known patch to fix it. I can't remember right now which one it is.</p>
<div class="gmail_quot<blockquote class=" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div text="#000000" bgcolor="#FFFFFF">
Hello<br>
I would like to use nibblebilling for fraud prevention on
international and premium numbers ( national or emergency calls
should never be blocked and should still working even if the billing
database is unavailable )<br>
<br>
Unfortunately that never hangup my calls using standard dial plan<br>
<br>
<b>nibblebill.conf.xml</b><br>
<br>
<tt><configuration name="nibblebill.conf" description="Nibble
Billing"></tt><tt><br>
</tt><tt> <settings></tt><tt><br>
</tt><tt> <!-- See
<a href="http://wiki.freeswitch.org/wiki/Mod_nibblebill" target="_blank">http://wiki.freeswitch.org/wiki/Mod_nibblebill</a> for help with these
options --></tt><tt><br>
</tt><tt><br>
</tt><tt> <!-- Information for connecting to your database
--></tt><tt><br>
</tt><tt> <param name="db_dsn"
value="pgsql://hostaddr=127.0.0.1 dbname=xxxx user=xxxx
password=xxxx"/></tt><tt><br>
</tt><tt><br>
</tt><tt> <!-- The database table where your CASH column is
located --></tt><tt><br>
</tt><tt> <param name="db_table" value="accounts"/></tt><tt><br>
</tt><tt><br>
</tt><tt> <!-- The column name where we store the value of the
account --></tt><tt><br>
</tt><tt> <param name="db_column_cash" value="cash"/></tt><tt><br>
</tt><tt><br>
</tt><tt> <!-- The column name for the unique ID identifying
the account --></tt><tt><br>
</tt><tt> <param name="db_column_account" value="id"/></tt><tt><br>
</tt><tt><br>
</tt><tt> <!-- Default heartbeat interval. Set to 'off' for no
heartbeat (i.e. bill only at end of call) --></tt><tt><br>
</tt><tt> <param name="global_heartbeat" value="20"/></tt><tt><br>
</tt><tt><br>
</tt><tt> <!-- By default, warn a caller when their balance is
at $5.00. You can set this to a negative number. --></tt><tt><br>
</tt><tt> <param name="lowbal_amt" value="-100"/></tt><tt>
<!-- i don't need this --><br>
</tt><tt> <param name="lowbal_action" value="play ding"/></tt><tt><br>
</tt><tt><br>
</tt><tt> <!-- By default, terminate a caller when their
balance hits $0.00. You can set this to a negative number. --></tt><tt><br>
</tt><tt> <param name="nobal_amt" value="0"/></tt><tt><br>
</tt><tt> <param name="nobal_action" value="hangup"/></tt><tt><br>
</tt><tt><br>
</tt><tt> <!-- If a call goes beyond a certain dollar amount,
flag or terminate it --></tt><tt><br>
</tt><tt> <param name="percall_max_amt" value="10"/></tt><tt><br>
</tt><tt> <param name="percall_action" value="hangup"/></tt><tt><br>
</tt><tt><br>
</tt><tt> </settings></tt><tt><br>
</tt><tt></configuration></tt><br>
<br>
<b>outbound route</b><br>
<br>
<tt><extension name="international" ></tt><tt><br>
</tt><tt> <condition field="destination_number"
expression="^00(\d{6,20})$" ></tt><tt><br>
</tt><tt> <action application="nibblebill"
data="flush"/></tt><tt><br>
</tt><tt> <action application="set"
data="nibble_account=${accountcode}"/></tt><tt><br>
</tt><tt> <action application="set"
data="nibble_rate=0.1"/></tt><tt><br>
</tt><tt> <action application="bridge"
data="sofia/gateway/gw_idt/$1" /></tt><tt><br>
</tt><tt> </condition></tt><tt><br>
</tt><tt></extension></tt><br>
<br>
<br>
<b>My balance</b><br>
My balance is already negative<br>
<br>
<tt> select * from accounts ;</tt><tt><br>
</tt><tt> id | cash </tt><tt><br>
</tt><tt>----------------------------------+-----------</tt><tt><br>
</tt><tt> <a href="http://company.voip.mydomain.com" target="_blank">company.voip.mydomain.com</a> | -0.789471</tt><br>
<br>
<b>A sample call</b><br>
My balance already negative, the call will be billed but never
blocked<br>
<br>
<tt>Dialplan: <a href="mailto:sofia/internal/5003@company.voip.domain.com" target="_blank">sofia/internal/5003@company.voip.domain.com</a> Action
nibblebill(flush)</tt><tt><br>
</tt><tt>Dialplan: <a href="mailto:sofia/internal/5003@company.voip.domain.com" target="_blank">sofia/internal/5003@company.voip.domain.com</a>
Action set(nibble_account=${accountcode})</tt><tt><br>
</tt><tt>Dialplan: <a href="mailto:sofia/internal/5003@company.voip.domain.com" target="_blank">sofia/internal/5003@company.voip.domain.com</a>
Action set(nibble_rate=0.1)</tt><tt><br>
</tt><tt>EXECUTE <a href="mailto:sofia/internal/5003@company.voip.domain.com" target="_blank">sofia/internal/5003@company.voip.domain.com</a>
nibblebill(flush)</tt><tt><br>
</tt><tt>EXECUTE <a href="mailto:sofia/internal/5003@company.voip.domain.com" target="_blank">sofia/internal/5003@company.voip.domain.com</a>
set(nibble_account=<a href="http://company.voip.domain.com" target="_blank">company.voip.domain.com</a>)</tt><tt><br>
</tt><tt>2016-04-10 12:10:04.049418 [DEBUG] mod_dptools.c:1477
<a href="mailto:sofia/internal/5003@company.voip.domain.com" target="_blank">sofia/internal/5003@company.voip.domain.com</a> SET
[nibble_account]=[<a href="http://company.voip.domain.com" target="_blank">company.voip.domain.com</a>]</tt><tt><br>
</tt><tt>EXECUTE <a href="mailto:sofia/internal/5003@company.voip.domain.com" target="_blank">sofia/internal/5003@company.voip.domain.com</a>
set(nibble_rate=0.1)</tt><tt><br>
</tt><tt>2016-04-10 12:10:04.049418 [DEBUG] mod_dptools.c:1477
<a href="mailto:sofia/internal/5003@company.voip.domain.com" target="_blank">sofia/internal/5003@company.voip.domain.com</a> SET
[nibble_rate]=[0.1]</tt><tt><br>
</tt><tt>2016-04-10 12:10:52.132458 [DEBUG] mod_nibblebill.c:488
Attempting to bill at $0.1 per minute to account
<a href="http://company.voip.domain.com" target="_blank">company.voip.domain.com</a></tt><tt><br>
</tt><tt>2016-04-10 12:10:52.132458 [INFO] mod_nibblebill.c:540
Beginning new billing on 644488fc-ff04-11e5-9a27-fd2791153af9</tt><tt><br>
</tt><tt>2016-04-10 12:10:52.132458 [DEBUG] mod_nibblebill.c:546 42
seconds passed since last bill time of 2016-04-10 12:10:09</tt><tt><br>
</tt><tt>2016-04-10 12:10:52.132458 [DEBUG] mod_nibblebill.c:563
Billing $0.071033 to <a href="http://company.voip.domain.com" target="_blank">company.voip.domain.com</a> (Call: / 0.000000 so
far)</tt><tt><br>
</tt><tt>2016-04-10 12:10:52.132458 [DEBUG] mod_nibblebill.c:393
Doing update query</tt><tt><br>
</tt><tt>2016-04-10 12:10:52.172440 [DEBUG] mod_nibblebill.c:420
Doing lookup query</tt><tt><br>
</tt><tt>[SELECT cash AS nibble_balance FROM accounts WHERE
id='<a href="http://company.voip.domain.com" target="_blank">company.voip.domain.com</a>']</tt><tt><br>
</tt><tt>2016-04-10 12:10:52.172440 [DEBUG] mod_nibblebill.c:428
Retrieved current balance for account <a href="http://company.voip.domain.com" target="_blank">company.voip.domain.com</a>
(balance = -0.860504)</tt><br>
<br>
<br>
<b>Using b-leg only</b><br>
Alternatively i tried an alternative dialplan ( Even if i don't
relay understand what is the meaning of b-leg billing )<br>
<br>
<tt><action application="bridge"
data="{enable_heartbeat_events=5,nibble_rate=0.1,nibble_account=${accountcode},originate_timeout=90}sofia/gateway/gw_idt/33$1"
/></tt><tt> </tt><br>
<br>
The result is better because the pending call is hanged up when the
balance reach 0.<br>
<br>
<tt>2016-04-10 12:39:59.012462 [CRIT] mod_nibblebill.c:607 Balance
of -0.003237 fell below allowed amount of 0.000000! (Account </tt><tt><a href="http://company.voip.domain.com" target="_blank">company.voip.domain.com</a></tt><tt>)</tt><br>
<br>
But if i make a new call ( when my balance is negative ) , the
caller party is immediately hanged but this did not cancel
immediately the bridge: The called party ring and can stay bridged
for 61 seconds after answer.<br>
<br>
<br>
<br>
<br>
<br>
</div>
<br>_________________________________________________________________________<br>
Professional FreeSWITCH Consulting Services:<br>
<a href="mailto:consulting@freeswitch.org">consulting@freeswitch.org</a><br>
<a href="http://www.freeswitchsolutions.com" rel="noreferrer" target="_blank">http://www.freeswitchsolutions.com</a><br>
<br>
Official FreeSWITCH Sites<br>
<a href="http://www.freeswitch.org" rel="noreferrer" target="_blank">http://www.freeswitch.org</a><br>
<a href="http://confluence.freeswitch.org" rel="noreferrer" target="_blank">http://confluence.freeswitch.org</a><br>
<a href="http://www.cluecon.com" rel="noreferrer" target="_blank">http://www.cluecon.com</a><br>
<br>
FreeSWITCH-users mailing list<br>
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a><br>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" rel="noreferrer" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" rel="noreferrer" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
<a href="http://www.freeswitch.org" rel="noreferrer" target="_blank">http://www.freeswitch.org</a><br></div>