[Freeswitch-users] Mod_nibblebill doesn't terminate call
Aqs Younas
aqsyounas at gmail.com
Thu Oct 2 18:00:11 MSD 2014
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 at gmail.com> wrote:
> Ooops sorry...that came through accidentally.
>
> On Sat, Sep 20, 2014 at 5:36 PM, Aqs Younas <aqsyounas at gmail.com> wrote:
>
>> Sorry i couldn't understand.
>>
>> On 20 September 2014 20:31, David Wafula <davidwaf at gmail.com> wrote:
>>
>>> Ok cool cool and I will thhzmKvdhmg
>>> On 20 Sep 2014 16:23, "Aqs Younas" <aqsyounas at 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 at 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 at 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 at 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 at 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 at 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 at 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 at freeswitch.org
>>>>>>>>> http://www.freeswitchsolutions.com
>>>>>>>>>
>>>>>>>>> Official FreeSWITCH Sites
>>>>>>>>> http://www.freeswitch.org
>>>>>>>>> http://confluence.freeswitch.org
>>>>>>>>> http://www.cluecon.com
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> FreeSWITCH-users mailing list
>>>>>>>>> FreeSWITCH-users at 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 at freeswitch.org
>>>>>>>> http://www.freeswitchsolutions.com
>>>>>>>>
>>>>>>>> Official FreeSWITCH Sites
>>>>>>>> http://www.freeswitch.org
>>>>>>>> http://confluence.freeswitch.org
>>>>>>>> http://www.cluecon.com
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> FreeSWITCH-users mailing list
>>>>>>>> FreeSWITCH-users at 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 at freeswitch.orghttp://www.freeswitchsolutions.com
>>>>>
>>>>> Official FreeSWITCH Siteshttp://www.freeswitch.orghttp://confluence.freeswitch.orghttp://www.cluecon.com
>>>>>
>>>>> FreeSWITCH-powered IP PBX: The CudaTel Communication Server
>>>>>
>>>>> FreeSWITCH-users mailing listFreeSWITCH-users at lists.freeswitch.orghttp://lists.freeswitch.org/mailman/listinfo/freeswitch-users
>>>>> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-usershttp://www.freeswitch.org
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> _________________________________________________________________________
>>>>> Professional FreeSWITCH Consulting Services:
>>>>> consulting at freeswitch.org
>>>>> http://www.freeswitchsolutions.com
>>>>>
>>>>> Official FreeSWITCH Sites
>>>>> http://www.freeswitch.org
>>>>> http://confluence.freeswitch.org
>>>>> http://www.cluecon.com
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> FreeSWITCH-users mailing list
>>>>> FreeSWITCH-users at 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 at freeswitch.org
>>>> http://www.freeswitchsolutions.com
>>>>
>>>> Official FreeSWITCH Sites
>>>> http://www.freeswitch.org
>>>> http://confluence.freeswitch.org
>>>> http://www.cluecon.com
>>>>
>>>>
>>>>
>>>>
>>>> FreeSWITCH-users mailing list
>>>> FreeSWITCH-users at 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 at freeswitch.org
>>> http://www.freeswitchsolutions.com
>>>
>>> Official FreeSWITCH Sites
>>> http://www.freeswitch.org
>>> http://confluence.freeswitch.org
>>> http://www.cluecon.com
>>>
>>>
>>>
>>>
>>> FreeSWITCH-users mailing list
>>> FreeSWITCH-users at 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 at freeswitch.org
>> http://www.freeswitchsolutions.com
>>
>> Official FreeSWITCH Sites
>> http://www.freeswitch.org
>> http://confluence.freeswitch.org
>> http://www.cluecon.com
>>
>>
>>
>>
>> FreeSWITCH-users mailing list
>> FreeSWITCH-users at 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 at freeswitch.org
> http://www.freeswitchsolutions.com
>
> Official FreeSWITCH Sites
> http://www.freeswitch.org
> http://confluence.freeswitch.org
> http://www.cluecon.com
>
>
>
>
> FreeSWITCH-users mailing list
> FreeSWITCH-users at lists.freeswitch.org
> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
> http://www.freeswitch.org
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20141002/d926b5e3/attachment-0001.html
Join us at ClueCon 2016 Aug 8-12, 2016
More information about the FreeSWITCH-users
mailing list