Ok cool cool and I will thhzmKvdhmg
Did anybody get mod_nibblebill in working conditions.?After i fire heartbeat from cli everything works perfectly.I don't know why heartbeat is not fired from nibblebill.conf.xml file after 1 second.But does fire from fs_cli for given call manually.Thanks for your reply and time...Both variables are correctly set and call is accounted only after termination.On 20 September 2014 03:23, Bernhard Wendel <bernhard@sessionbird.com> wrote:Hi,
I think you have an error in your dialplan. You are using variable-tags that are actually ment for directory instead of the set-dialplan application.
Please try again with
<condition field="destination_number" expression="^(1[2-9][0-9]{2}[0-9]{7})$">
<action application="set" data="nibble_rate0.03" />
<action application="set" data="nibble_account=45893148"/>
<action application="bridge" data="sofia/external/1$@168.183.648"/>
</condition>
</extension>
If this does not help with your problem, try with the info-dialplan application to check whether all channel variables needed by nibblebill are set.
Regards,
Bernhard
Am 19.09.2014 17:56, schrieb Aqs Younas:
After some considertation i foung, Its heartbeat fire does not fire after 1 second as i have specified in my nibblebill.conf.xml file. After call is completed nibblebill update the database balance column according to given formula.Why freeswitch does not fire heartbeat after one second and set the channel for billing.?
[time call ended] - [time call answered] x [rate per minute] = $total bill rate
Though this formula is used when global_heartbeat is off.Here is my nibblebill.conf.xml
<configuration name="nibblebill.conf" description="Nibble Billing">
<settings>
<param name="odbc-dsn" value="odbc://freeswitch"/>
<param name="db_table" value="users"/>
<!-- The column name where we store the value of the account -->
<param name="db_column_cash" value="balance"/>
<!-- The column name for the unique ID identifying the account -->
<param name="db_column_account" value="accountcode"/>
<!-- Custom SQL for loading current balance - overrides column names
channel vars are interpreted.
field nibble_balance is used for balance info
<param name="custom_sql_lookup" value="SELECT cash AS nibble_balance FROM accounts WHERE account_code='${nibble_account}'"/>
-->
<!-- Custom SQL for loading current balance - overrides column names
channel vars are interpreted.
nibble_increment is the amount to update
<param name="custom_sql_save" value="UPDATE accounts SET cash=cash-${nibble_increment} WHERE account_code='${nibble_account}'"/>
-->
<!-- Default heartbeat interval. Set to 'off' for no heartbeat (i.e. bill only at end of call) -->
<param name="global_heartbeat" value="1"/>
<!-- By default, warn a caller when their balance is at $5.00. You can set this to a negative number. -->
<param name="lowbal_amt" value="5"/>
<param name="lowbal_action" value="play ding"/>
<!-- By default, terminate a caller when their balance hits $0.00. You can set this to a negative number. -->
<param name="nobal_amt" value="0"/>
<param name="nobal_action" value="hangup XML default"/>
<!-- If a call goes beyond a certain dollar amount, flag or terminate it -->
<param name="percall_max_amt" value="0"/>
<param name="percall_action" value="hangup"/>
</settings>
</configuration>
When i apply this on Freeswitch cli for channel uuid i get this..
freeswitch@internal> nibblebill 3f3f3b4a-fe4e-47d0-a43a-e1d8a54c6dfe check
-ERR no reply
2014-09-19 04:30:38.704124 [INFO] mod_nibblebill.c:793 Can't check - channel is not initialized for billing!
2014-09-19 04:30:38.704124 [INFO] mod_nibblebill.c:888 Current billing is at $-99999.000000
On 19 September 2014 02:29, Aqs Younas <aqsyounas@gmail.com> wrote:
Sorry Still i am unable to terminate calls.Here are both files.Any Suggestion :(
Here is my nibblebill.conf.xml file.
<configuration name="nibblebill.conf" description="Nibble Billing">
<settings>
<param name="odbc-dsn" value="odbc://freeswitch"/>
<param name="db_table" value="users"/>
<param name="db_column_cash" value="balance"/>
<param name="db_column_account" value="accountcode"/>
<param name="lowbal_amt" value="5"/>
<param name="lowbal_action" value="play ding"/>
<param name="nobal_amt" value="0"/>
<param name="nobal_action" value="hangup XML default"/>
<param name="percall_max_amt" value="0"/>
<param name="percall_action" value="hangup"/>
</settings>
</configuration>
Here is my default.xml
<include>
<context name="default">
<extension name="unloop">
<condition field="destination_number" expression="^(1[2-9][0-9]{2}[0-9]{7})$">
<variable name="nibble_rate" value="0.03"/>
<variable name="nibble_account" value="45893148"/>
<action application="bridge" data="sofia/external/1$@168.183.648"/>
</condition>
</extension>
<extension name="hangup">
<condition field="destination_number" expression="^(hangup)$">
<action application="hangup"/>
</condition>
</extension>
</context>
</include>
On 19 September 2014 01:33, Aqs Younas <aqsyounas@gmail.com> wrote:
Thanks for your reply..i try it and get back to you.Many thanks
On 19 September 2014 01:14, Steven Ayre <steveayre@gmail.com> wrote:
<param name="nobal_action" value="hangup XML default"/>It's a dialplan transfer, you need the XML and context name, and an extension to handle it.
On 18 September 2014 19:39, Aqs Younas <aqsyounas@gmail.com> wrote:
_________________________________________________________________________Hi,
I am new to freeswitch, i am using mod_nibblebill for billing of realtime calls.It works perfectly, detects correct balance after the completion of call and performs update query on database.What difficulty I am facing now is that mod_nibblebill does not terminate call even when user balance is below zero(0) or is zero(0), which I have specified in my xml file.
Here is my nibblebill.conf.xml file.
<configuration name="nibblebill.conf" description="Nibble Billing">
<settings>
<param name="odbc-dsn" value="odbc://freeswitch"/>
<param name="db_table" value="users"/>
<param name="db_column_cash" value="balance"/>
<param name="db_column_account" value="accountcode"/>
<param name="lowbal_amt" value="5"/>
<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="0"/>
<param name="percall_action" value="hangup"/>
</settings>
</configuration>
Here is my default.xml
include>
<context name="default">
<extension name="unloop">
<condition field="destination_number" expression="^(1[2-9][0-9]{2}[0-9]{7})$">
<variable name="nibble_rate" value="0.03"/>
<variable name="nibble_account" value="45893148"/>
<action application="bridge" data="sofia/external/1$@168.183.648"/>
</condition>
</extension>
</context>
</include>
Could Someone please tell me why mod_nibblebill is not terminating call but accounts call perfectly.
(if a user balance is below or at zero(0) mob_nibblebill let them call and after call sets balance to negative value)
Thanks In Advance.
Professional FreeSWITCH Consulting Services:
consulting@freeswitch.org
http://www.freeswitchsolutions.com
Official FreeSWITCH Sites
http://www.freeswitch.org
http://confluence.freeswitch.org
http://www.cluecon.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server
http://www.cudatel.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
Official FreeSWITCH Sites
http://www.freeswitch.org
http://confluence.freeswitch.org
http://www.cluecon.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server
http://www.cudatel.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 Official FreeSWITCH Sites http://www.freeswitch.org http://confluence.freeswitch.org http://www.cluecon.com FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.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
Official FreeSWITCH Sites
http://www.freeswitch.org
http://confluence.freeswitch.org
http://www.cluecon.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server
http://www.cudatel.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
Official FreeSWITCH Sites
http://www.freeswitch.org
http://confluence.freeswitch.org
http://www.cluecon.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server
http://www.cudatel.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