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!DavidOn 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,Thank you.On Wed, Feb 20, 2013 at 2:10 PM, David Villasmil <david.villasmil.work@gmail.com> wrote:
_________________________________________________________________________Anyone about this?ThanksOn 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