Thanks all for your time.Actually i was not setting session heartbeat in my dial-plan. On 20 September 2014 20:54, David Wafula <davidwaf@gmail.com> wrote:
Ooops sorry...that came through accidentally.
On Sat, Sep 20, 2014 at 5:36 PM, Aqs Younas <aqsyounas@gmail.com> wrote:
Sorry i couldn't understand.
On 20 September 2014 20:31, David Wafula <davidwaf@gmail.com> wrote:
Ok cool cool and I will thhzmKvdhmg On 20 Sep 2014 16:23, "Aqs Younas" <aqsyounas@gmail.com> wrote:
Thanks for your reply and time... Both variables are correctly set and call is accounted only after termination. 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. After i fire heartbeat from cli everything works perfectly.
Did anybody get mod_nibblebill in working conditions.?
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" <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.
[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
Why freeswitch does not fire heartbeat after one second and set the channel for billing.?
On 19 September 2014 02:29, Aqs Younas <aqsyounas@gmail.com> wrote:
Sorry Still i am unable to terminate calls.Here are both files.
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" <sofia/external/1$@168.183.648>/> </condition> </extension>
<extension name="hangup"> <condition field="destination_number" expression="^(hangup)$"> <action application="hangup"/> </condition> </extension>
</context> </include>
Any Suggestion :(
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" <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.orghttp://www.freeswitchsolutions.com
Official FreeSWITCH Siteshttp://www.freeswitch.orghttp://confluence.freeswitch.orghttp://www.cluecon....
FreeSWITCH-powered IP PBX: The CudaTel Communication Serverhttp://www.cudatel.com
FreeSWITCH-users mailing listFreeSWITCH-users@lists.freeswitch.orghttp://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-usershttp://www.frees...
_________________________________________________________________________ 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
-- David Wafula
_________________________________________________________________________ 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