<div dir="ltr">I use following dialplan extension. All work fine<div><br></div><div>







<p class="p1"><span class="s1">    &lt;extension name=&quot;setNibbleBillRate&quot; continue=&quot;true&quot;&gt;<br></span>        &lt;condition field=&quot;${destination_number}&quot; expression=&quot;^\+7(495|499)\d+$&quot; break=&quot;on-true&quot;&gt;<br>            &lt;action application=&quot;set&quot; data=&quot;nibble_rate=1&quot;/&gt;<br>        &lt;/condition&gt;<br>        &lt;condition field=&quot;${destination_number}&quot; expression=&quot;^\+7800\d+$&quot; break=&quot;on-true&quot;&gt;<br>            &lt;action application=&quot;set&quot; data=&quot;nibble_rate=0&quot;/&gt;<br>        &lt;/condition&gt;<br>        &lt;condition field=&quot;${destination_number}&quot; expression=&quot;^\+7\d+$&quot; break=&quot;on-true&quot;&gt;<br>            &lt;action application=&quot;set&quot; data=&quot;nibble_rate=3&quot;/&gt;<br>        &lt;/condition&gt;<br>        &lt;condition field=&quot;${destination_number}&quot; expression=&quot;^\+\d+$&quot; break=&quot;on-true&quot;&gt;<br>            &lt;action application=&quot;set&quot; data=&quot;nibble_rate=20&quot;/&gt;<br>        &lt;/condition&gt;<br>        &lt;condition field=&quot;${destination_number}&quot; expression=&quot;^[a-zA-Z0-9]+$&quot; break=&quot;on-true&quot;&gt;<br>            &lt;action application=&quot;set&quot; data=&quot;nibble_rate=0&quot;/&gt;<br>            &lt;anti-action application=&quot;set&quot; data=&quot;nibble_rate=200000000&quot;/&gt;<br>        &lt;/condition&gt;<br>    &lt;/extension&gt;</p>
<p class="p2">    &lt;extension name=&quot;froudContol&quot; continue=&quot;true&quot;&gt;<br>      &lt;condition&gt;<br>        &lt;action application=&quot;nibblebill&quot; data=&quot;flush&quot;/&gt;<br>      &lt;/condition&gt;<br>    &lt;/extension&gt;</p><div><br></div></div></div><br><div class="gmail_quote"><div dir="ltr">вс, 10 апр. 2016 г. в 14:22, Tanguy &lt;<a href="mailto:phenix@vfemail.net">phenix@vfemail.net</a>&gt;:<br></div><blockquote class="gmail_quote" 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>&lt;configuration name=&quot;nibblebill.conf&quot; description=&quot;Nibble
      Billing&quot;&gt;</tt><tt><br>
    </tt><tt>  &lt;settings&gt;</tt><tt><br>
    </tt><tt>    &lt;!-- 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 --&gt;</tt><tt><br>
    </tt><tt><br>
    </tt><tt>    &lt;!-- Information for connecting to your database
      --&gt;</tt><tt><br>
    </tt><tt>    &lt;param name=&quot;db_dsn&quot;
      value=&quot;pgsql://hostaddr=127.0.0.1 dbname=xxxx user=xxxx
      password=xxxx&quot;/&gt;</tt><tt><br>
    </tt><tt><br>
    </tt><tt>    &lt;!-- The database table where your CASH column is
      located --&gt;</tt><tt><br>
    </tt><tt>    &lt;param name=&quot;db_table&quot; value=&quot;accounts&quot;/&gt;</tt><tt><br>
    </tt><tt><br>
    </tt><tt>    &lt;!-- The column name where we store the value of the
      account --&gt;</tt><tt><br>
    </tt><tt>    &lt;param name=&quot;db_column_cash&quot; value=&quot;cash&quot;/&gt;</tt><tt><br>
    </tt><tt><br>
    </tt><tt>    &lt;!-- The column name for the unique ID identifying
      the account --&gt;</tt><tt><br>
    </tt><tt>    &lt;param name=&quot;db_column_account&quot; value=&quot;id&quot;/&gt;</tt><tt><br>
    </tt><tt><br>
    </tt><tt>    &lt;!-- Default heartbeat interval. Set to &#39;off&#39; for no
      heartbeat (i.e. bill only at end of call) --&gt;</tt><tt><br>
    </tt><tt>    &lt;param name=&quot;global_heartbeat&quot; value=&quot;20&quot;/&gt;</tt><tt><br>
    </tt><tt><br>
    </tt><tt>    &lt;!-- By default, warn a caller when their balance is
      at $5.00. You can set this to a negative number. --&gt;</tt><tt><br>
    </tt><tt>    &lt;param name=&quot;lowbal_amt&quot; value=&quot;-100&quot;/&gt;</tt><tt>
      &lt;!-- i don&#39;t need this --&gt;<br>
    </tt><tt>    &lt;param name=&quot;lowbal_action&quot; value=&quot;play ding&quot;/&gt;</tt><tt><br>
    </tt><tt><br>
    </tt><tt>    &lt;!-- By default, terminate a caller when their
      balance hits $0.00. You can set this to a negative number. --&gt;</tt><tt><br>
    </tt><tt>    &lt;param name=&quot;nobal_amt&quot; value=&quot;0&quot;/&gt;</tt><tt><br>
    </tt><tt>    &lt;param name=&quot;nobal_action&quot; value=&quot;hangup&quot;/&gt;</tt><tt><br>
    </tt><tt><br>
    </tt><tt>    &lt;!-- If a call goes beyond a certain dollar amount,
      flag or terminate it --&gt;</tt><tt><br>
    </tt><tt>    &lt;param name=&quot;percall_max_amt&quot; value=&quot;10&quot;/&gt;</tt><tt><br>
    </tt><tt>    &lt;param name=&quot;percall_action&quot; value=&quot;hangup&quot;/&gt;</tt><tt><br>
    </tt><tt><br>
    </tt><tt>  &lt;/settings&gt;</tt><tt><br>
    </tt><tt>&lt;/configuration&gt;</tt><br>
    <br>
    <b>outbound route</b><br>
    <br>
    <tt>&lt;extension name=&quot;international&quot; &gt;</tt><tt><br>
    </tt><tt>   &lt;condition field=&quot;destination_number&quot;
      expression=&quot;^00(\d{6,20})$&quot; &gt;</tt><tt><br>
    </tt><tt>       &lt;action application=&quot;nibblebill&quot;
      data=&quot;flush&quot;/&gt;</tt><tt><br>
    </tt><tt>        &lt;action application=&quot;set&quot;
      data=&quot;nibble_account=${accountcode}&quot;/&gt;</tt><tt><br>
    </tt><tt>        &lt;action application=&quot;set&quot;
      data=&quot;nibble_rate=0.1&quot;/&gt;</tt><tt><br>
    </tt><tt>       &lt;action application=&quot;bridge&quot;
      data=&quot;sofia/gateway/gw_idt/$1&quot; /&gt;</tt><tt><br>
    </tt><tt>   &lt;/condition&gt;</tt><tt><br>
    </tt><tt>&lt;/extension&gt;</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=&#39;<a href="http://company.voip.domain.com" target="_blank">company.voip.domain.com</a>&#39;]</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&#39;t
    relay understand what is the meaning of b-leg billing  )<br>
    <br>
    <tt>&lt;action application=&quot;bridge&quot;
      data=&quot;{enable_heartbeat_events=5,nibble_rate=0.1,nibble_account=${accountcode},originate_timeout=90}sofia/gateway/gw_idt/33$1&quot;
      /&gt;</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>
Professional FreeSWITCH Consulting Services:<br>
<a href="mailto:consulting@freeswitch.org" target="_blank">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" target="_blank">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></blockquote></div>