[Freeswitch-users] Mod_nibblebill doesn't terminate call

Bernhard Wendel bernhard at sessionbird.com
Sat Sep 20 02:23:41 MSD 2014


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.
>
> [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 
> <mailto: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"/>
>             </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
>     <mailto: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
>         <mailto: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 <mailto: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"/>
>                     </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
>                 <mailto:consulting at 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
>                 
>
>                 FreeSWITCH-users mailing list
>                 FreeSWITCH-users at lists.freeswitch.org
>                 <mailto: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 <mailto: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
>             <mailto: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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20140920/f85bf09b/attachment-0001.html 


Join us at ClueCon 2016 Aug 8-12, 2016
More information about the FreeSWITCH-users mailing list