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"/>
        </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"/>
        </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"/>   
    </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

_________________________________________________________________________
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