<div>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)?</div><div><br></div>Thank you.<div><br><br><div class="gmail_quote">On Thu, Feb 21, 2013 at 1:49 PM, David Villasmil <span dir="ltr">&lt;<a href="mailto:david.villasmil.work@gmail.com" target="_blank">david.villasmil.work@gmail.com</a>&gt;</span> wrote:<br>

<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Hello,<div><br></div><div>Thanks for replying!</div><div><br></div><div>It was not set, but i understood from the wiki that if you don&#39;t want any rounding, you dont&#39;t set it.</div>

<div><br>

</div><div>I set it to &quot;10&quot;, i want the user to be charged tvery 10 seconds, you nibblebil is charging 10 DOLLARS!</div><div>I must be getting something wrong...</div><div><br></div><div>

<br></div><div>Here&#39;s my nibblebill.conf.xml. </div><div><br></div><div>(BTW, the two highlighted lines, is it possible to do that? I want the custom SQLs to use channel variables, is it possible?)</div>

<div><br></div><div><br></div><div><div>    &lt;section name=&quot;configuration&quot;&gt;</div><div>        &lt;configuration name=&quot;nibblebill.conf&quot; description=&quot;Nibble Billing&quot;&gt;</div>

<div>            &lt;settings&gt;</div><div>                &lt;param name=&quot;db_username&quot; value=&quot;myroot&quot; /&gt;</div><div>                &lt;param name=&quot;db_password&quot; value=&quot;mypass&quot; /&gt;</div>



<div>                &lt;param name=&quot;odbc-dsn&quot; value=&quot;odbc://viking&quot; /&gt;</div><div>                &lt;param name=&quot;db_table&quot; value=&quot;sip_users&quot; /&gt;</div><div>                &lt;param name=&quot;db_column_cash&quot; value=&quot;balance&quot; /&gt;</div>



<div>                &lt;param name=&quot;db_column_account&quot; value=&quot;id&quot; /&gt;</div><div>                <b>&lt;param name=&quot;custom_sql_lookup&quot; value=&quot;SELECT ${variable_card_db_column_cash} AS nibble_balance FROM ${variable_card_db_table} WHERE ${variable_card_db_column_account}=${nibble_account};&quot; /&gt;</b></div>



<div><b>                &lt;param name=&quot;custom_sql_save&quot; value=&quot;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};&quot; /&gt;</b></div>



<div>                &lt;param name=&quot;global_heartbeat&quot; value=&quot;10&quot; /&gt;</div><div>                &lt;param name=&quot;lowbal_amt&quot; value=&quot;0&quot; /&gt;</div><div>                &lt;param name=&quot;lowbal_action&quot; value=&quot;play ding&quot; /&gt;</div>



<div>                &lt;param name=&quot;nobal_amt&quot; value=&quot;0&quot; /&gt;</div><div>                &lt;param name=&quot;nobal_action&quot; value=&quot;hangup&quot; /&gt;</div><div>                &lt;param name=&quot;percall_max_amt&quot; value=&quot;100&quot; /&gt;</div>



<div>                &lt;param name=&quot;percall_action&quot; value=&quot;hangup&quot; /&gt;</div><div>            &lt;/settings&gt;</div><div>        &lt;/configuration&gt;</div><div>    &lt;/section&gt;</div></div><div>



<br></div><div>Here&#39;s the dialplan:</div><div><br></div><div><div>    &lt;section name=&quot;dialplan&quot;&gt;</div><div>        &lt;context name=&quot;route_call&quot;&gt;</div><div>            &lt;extension name=&quot;routeCall&quot;&gt;</div>



<div>                &lt;condition field=&quot;destination_number&quot; expression=&quot;^.*&quot;&gt;</div><div>                    &lt;action application=&quot;set&quot; data=&quot;continue_on_fail=NO_ROUTE_DESTINATION,UNALLOCATED_NUMBER,407&quot; /&gt;</div>



<div>                    &lt;action application=&quot;set&quot; data=&quot;sip_from_user=1002&quot; /&gt;</div><div>                    &lt;action application=&quot;set&quot; data=&quot;sip_auth_username=1002&quot; /&gt;</div>



<div>                    &lt;action application=&quot;set&quot; data=&quot;sip_req_user=1002&quot; /&gt;</div><div>                    &lt;action application=&quot;set&quot; data=&quot;hangup_after_bridge=true&quot; /&gt;</div>



<div>                    &lt;action application=&quot;set&quot; data=&quot;nibble_rate=0.0500&quot; /&gt;</div><div>                    &lt;action application=&quot;nibblebill&quot; data=&quot;heartbeat 10&quot; /&gt;</div>



<div>                    &lt;action application=&quot;set&quot; data=&quot;card_db_table=cards_table&quot; /&gt;</div><div>                    &lt;action application=&quot;set&quot; data=&quot;card_db_column_cash=balance&quot; /&gt;</div>



<div>                    &lt;action application=&quot;set&quot; data=&quot;card_db_column_account=pin&quot; /&gt;</div><div>                    &lt;action application=&quot;set&quot; data=&quot;nibble_account=12345&quot; /&gt;</div>



<div>                    &lt;action application=&quot;set&quot; data=&quot;gw=${distributor(TEST_ROUTE)}&quot; /&gt;</div><div>                    &lt;action application=&quot;limit&quot; data=&quot;hash $${domain} $${domain} ${sip_auth_username} 1 !NORMAL_TEMPORARY_FAILURE&quot; /&gt;</div>



<div>                    &lt;action application=&quot;export&quot; data=&quot;execute_on_answer=nibblebill adjust -0.1000&quot; /&gt;</div><div>                    &lt;action application=&quot;bridge&quot; data=&quot;{enable_heartbeat_events=10,nibble_rate=0.0500,nibble_account=12345}sofia/gateway/${gw}/0013058883456&quot; /&gt;</div>



<div>                &lt;/condition&gt;</div><div>            &lt;/extension&gt;</div><div>        &lt;/context&gt;</div><div>    &lt;/section&gt;</div><div><br></div><div><br></div><div>Thanks for your help!</div><span class="HOEnZb"><font color="#888888">
<div>
<br></div><div><br></div><div>David</div></font></span></div><div><br></div></div><div class="HOEnZb"><div class="h5"><div class="gmail_extra"><br><br><div class="gmail_quote">On Wed, Feb 20, 2013 at 2:23 PM, Muhammad Shahzad <span dir="ltr">&lt;<a href="mailto:shaheryarkh@gmail.com" target="_blank">shaheryarkh@gmail.com</a>&gt;</span> wrote:<br>



<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Did you set nibble_increment variable? e.g.<div><br></div><div>&lt;variable name=&quot;nibble_increment&quot; value=&quot;30&quot; /&gt;</div>



<div><br></div><div>Here is its details,</div><div><br></div><div><a href="http://wiki.freeswitch.org/wiki/Mod_nibblebill#Nibble_Method_.28Default.29" target="_blank">http://wiki.freeswitch.org/wiki/Mod_nibblebill#Nibble_Method_.28Default.29</a></div>





<div><br></div><div>Thank you.</div><div><br><br><div class="gmail_quote"><div><div>On Wed, Feb 20, 2013 at 2:10 PM, David Villasmil <span dir="ltr">&lt;<a href="mailto:david.villasmil.work@gmail.com" target="_blank">david.villasmil.work@gmail.com</a>&gt;</span> wrote:<br>





</div></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div><div dir="ltr">Anyone about this?<div><br></div><div>Thanks</div></div><div><div><div class="gmail_extra">





<br><br><div class="gmail_quote">On Mon, Feb 18, 2013 at 2:07 PM, David Villasmil <span dir="ltr">&lt;<a href="mailto:david.villasmil.work@gmail.com" target="_blank">david.villasmil.work@gmail.com</a>&gt;</span> wrote:<br>







<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Hello guys,<div><br></div><div>I have the following config for nibbebill:</div><div><br></div><div><div>







                &lt;param name=&quot;custom_sql_lookup&quot; value=&quot;SELECT ${card_db_column_cash} AS nibble_balance FROM ${card_db_table} WHERE ${card_db_column_account}=${nibble_account};&quot; /&gt;</div>
<div>                &lt;param name=&quot;custom_sql_save&quot; value=&quot;UPDATE ${card_db_table} SET ${card_db_column_cash}=${card_db_column_cash}-${nibble_increment} WHERE ${card_db_column_account}=${nibble_account};&quot; /&gt;</div>








<div><br></div></div><div>I see this on the log, which is obviously failing:</div><div><br></div><div><br></div><div> [UPDATE cards_table SET balance=balance- WHERE pin=12345;]<br></div><div>
<br></div><div>is ${nibble_increment} not the correct variable to use? It looks like it is empty!</div><div><br></div><div>Thanks!</div><span><font color="#888888"><div><br></div><div>David</div></font></span></div>


</blockquote></div><br></div>
</div></div><br></div></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" target="_blank">http://www.freeswitchsolutions.com</a><br>
<br>
FreeSWITCH-powered IP PBX: The CudaTel Communication Server<br>
<a href="http://www.cudatel.com" target="_blank">http://www.cudatel.com</a><br>
<br>
Official FreeSWITCH Sites<br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
<a href="http://wiki.freeswitch.org" target="_blank">http://wiki.freeswitch.org</a><br>
<a href="http://www.cluecon.com" 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" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
<br></blockquote></div><span><font color="#888888"><br><br clear="all"><div><br></div>-- <br><span style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">Muhammad Shahzad</span><br style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">





<span style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">------------------------------</span><span style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">-----</span><br style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">





<span style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">CISCO Rich Media Communication Specialist (CRMCS)</span><br style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">

<span style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">CISCO Certified Network Associate (CCNA)</span><br style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">

<span style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">Cell: <a href="tel:%2B49%20176%2099%2083%2010%2085" value="+4917699831085" target="_blank">+49 176 99 83 10 85</a></span><br style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">





<span style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">MSN: </span><a href="mailto:shari_786pk@hotmail.com" style="color:rgb(17,85,204);font-size:13px;font-family:arial,sans-serif" target="_blank">shari_786pk@hotmail.com</a><br style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">





<span style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">Email: </span><a href="mailto:shaheryarkh@googlemail.com" style="color:rgb(17,85,204);font-size:13px;font-family:arial,sans-serif" target="_blank">shaheryarkh@googlemail.com</a>
</font></span></div>
<br>_________________________________________________________________________<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" target="_blank">http://www.freeswitchsolutions.com</a><br>
<br>
FreeSWITCH-powered IP PBX: The CudaTel Communication Server<br>
<a href="http://www.cudatel.com" target="_blank">http://www.cudatel.com</a><br>
<br>
Official FreeSWITCH Sites<br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
<a href="http://wiki.freeswitch.org" target="_blank">http://wiki.freeswitch.org</a><br>
<a href="http://www.cluecon.com" 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" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
<br></blockquote></div><br></div>
</div></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" target="_blank">http://www.freeswitchsolutions.com</a><br>
<br>
FreeSWITCH-powered IP PBX: The CudaTel Communication Server<br>
<a href="http://www.cudatel.com" target="_blank">http://www.cudatel.com</a><br>
<br>
Official FreeSWITCH Sites<br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
<a href="http://wiki.freeswitch.org" target="_blank">http://wiki.freeswitch.org</a><br>
<a href="http://www.cluecon.com" 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" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
<br></blockquote></div><br><br clear="all"><div><br></div>-- <br><span style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">Muhammad Shahzad</span><br style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">

<span style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">------------------------------</span><span style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">-----</span><br style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">

<span style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">CISCO Rich Media Communication Specialist (CRMCS)</span><br style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">

<span style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">CISCO Certified Network Associate (CCNA)</span><br style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">

<span style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">Cell: +49 176 99 83 10 85</span><br style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">

<span style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">MSN: </span><a href="mailto:shari_786pk@hotmail.com" style="color:rgb(17,85,204);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)" target="_blank">shari_786pk@hotmail.com</a><br style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">

<span style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">Email: </span><a href="mailto:shaheryarkh@googlemail.com" style="color:rgb(17,85,204);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)" target="_blank">shaheryarkh@googlemail.com</a>
</div>