[Freeswitch-users] Mod_nibblebill doesn't terminate call
David Wafula
davidwaf at gmail.com
Sat Sep 20 19:54:20 MSD 2014
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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20140920/4ebb9cd0/attachment-0001.html
Join us at ClueCon 2016 Aug 8-12, 2016
More information about the FreeSWITCH-users
mailing list