<div dir="ltr"><div><div><div><div>Thanks for your reply and time...<br></div>Both variables are correctly set and call is accounted only after termination.<br></div>I don&#39;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.<br></div>After i fire heartbeat from cli everything works perfectly.<br><br></div>Did anybody get mod_nibblebill in working conditions.?<br></div><div class="gmail_extra"><br><div class="gmail_quote">On 20 September 2014 03:23, Bernhard Wendel <span dir="ltr">&lt;<a href="mailto:bernhard@sessionbird.com" target="_blank">bernhard@sessionbird.com</a>&gt;</span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
  
    
  
  <div text="#000000" bgcolor="#FFFFFF">
    Hi,<br>
    <br>
    I think you have an error in your dialplan. You are using <i>variable</i>-tags
    that are actually ment for directory instead of the <i>set</i>-dialplan
    application.<br>
    Please try again with <br>
    <span><span class=""><br>
         &lt;condition field=&quot;destination_number&quot;
      expression=&quot;^(1[2-9][0-9]{2}[0-9]{7})$&quot;&gt;<br>
      </span><b>          &lt;action application=&quot;set&quot; data=&quot;nibble_rate0.03&quot;
        /&gt;
      </b><b><br>
      </b><b>          &lt;action application=&quot;set&quot;
        data=&quot;nibble_account=45893148&quot;/&gt;</b><span class=""><b><br>
      </b>          &lt;action application=&quot;bridge&quot;
      data=<a href="mailto:sofia/external/1$@168.183.648" target="_blank">&quot;sofia/external/1$@168.183.648&quot;</a>/&gt; <br>
              &lt;/condition&gt;<br>
        &lt;/extension&gt;</span></span><br>
    <br>
    If this does not help with your problem, try with the <i>info</i>-dialplan
    application to check whether all channel variables needed by
    nibblebill are set.<br>
    <br>
    Regards,<br>
    Bernhard<br>
    <br>
    <br>
    <div>Am 19.09.2014 17:56, schrieb Aqs
      Younas:<br>
    </div><div><div class="h5">
    <blockquote type="cite">
      <div dir="ltr">
        <div>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.<br>
          <br>
          [time call ended] - [time call answered] x [rate per minute] =
          $total bill rate<br>
          <br>
          <div>Though this formula is used when  global_heartbeat is
            off.<br>
          </div>
          Here is my nibblebill.conf.xml<br>
          <br>
          &lt;configuration name=&quot;nibblebill.conf&quot; description=&quot;Nibble
          Billing&quot;&gt;<br>
            &lt;settings&gt;<br>
          <br>
          <br>
                  &lt;param name=&quot;odbc-dsn&quot;
          value=&quot;odbc://freeswitch&quot;/&gt;<br>
          &lt;param name=&quot;db_table&quot; value=&quot;users&quot;/&gt;<br>
          <br>
              &lt;!-- The column name where we store the value of the
          account --&gt;<br>
              &lt;param name=&quot;db_column_cash&quot; value=&quot;balance&quot;/&gt;<br>
          <br>
              &lt;!-- The column name for the unique ID identifying the
          account --&gt;<br>
              &lt;param name=&quot;db_column_account&quot;
          value=&quot;accountcode&quot;/&gt;<br>
          <br>
              &lt;!-- Custom SQL for loading current balance - overrides
          column names<br>
                   channel vars are interpreted.<br>
                   field nibble_balance is used for balance info<br>
          <br>
              &lt;param name=&quot;custom_sql_lookup&quot; value=&quot;SELECT cash AS
          nibble_balance FROM accounts WHERE account_code=&#39;${nibble_
          <div dir="ltr">account}&#39;&quot;/&gt;<br>
                --&gt;<br>
            <br>
                &lt;!-- Custom SQL for loading current balance -
            overrides column names<br>
                     channel vars are interpreted.<br>
                     nibble_increment is the amount to update<br>
            <br>
                &lt;param name=&quot;custom_sql_save&quot; value=&quot;UPDATE accounts
            SET cash=cash-${nibble_increment} WHERE
            account_code=&#39;${nibble_account}&#39;&quot;/&gt;<br>
                --&gt;<br>
            &lt;!-- Default heartbeat interval. Set to &#39;off&#39; for no
            heartbeat (i.e. bill only at end of call) --&gt;<br>
                &lt;param name=&quot;global_heartbeat&quot; value=&quot;1&quot;/&gt;<br>
            <br>
                &lt;!-- By default, warn a caller when their balance is
            at $5.00. You can set this to a negative number. --&gt;<br>
                &lt;param name=&quot;lowbal_amt&quot; value=&quot;5&quot;/&gt;<br>
                &lt;param name=&quot;lowbal_action&quot; value=&quot;play ding&quot;/&gt;<br>
            <br>
                &lt;!-- By default, terminate a caller when their
            balance hits $0.00. You can set this to a negative number.
            --&gt;<br>
                &lt;param name=&quot;nobal_amt&quot; value=&quot;0&quot;/&gt;<br>
                &lt;param name=&quot;nobal_action&quot; value=&quot;hangup XML
            default&quot;/&gt;<br>
            <br>
                &lt;!-- If a call goes beyond a certain dollar amount,
            flag or terminate it --&gt;<br>
                &lt;param name=&quot;percall_max_amt&quot; value=&quot;0&quot;/&gt;<br>
                &lt;param name=&quot;percall_action&quot; value=&quot;hangup&quot;/&gt;<br>
            <br>
              &lt;/settings&gt;<br>
            &lt;/configuration&gt;<br>
            <br>
          </div>
          <div>When i apply this on Freeswitch cli for channel uuid i
            get this..<br>
            <br>
          </div>
          <div dir="ltr"><br>
            <br>
          </div>
          freeswitch@internal&gt; nibblebill
          3f3f3b4a-fe4e-47d0-a43a-e1d8a54c6dfe check<br>
          -ERR no reply<br>
          <br>
          2014-09-19 04:30:38.704124 [INFO] mod_nibblebill.c:793 Can&#39;t
          check - channel is not initialized for billing!<br>
          2014-09-19 04:30:38.704124 [INFO] mod_nibblebill.c:888 Current
          billing is at $-99999.000000<br>
          <br>
        </div>
        Why freeswitch does not fire heartbeat after one second and set
        the channel for billing.?<br>
      </div>
      <div class="gmail_extra"><br>
        <div class="gmail_quote">On 19 September 2014 02:29, Aqs Younas
          <span dir="ltr">&lt;<a href="mailto:aqsyounas@gmail.com" target="_blank">aqsyounas@gmail.com</a>&gt;</span>
          wrote:<br>
          <blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
            <div dir="ltr">
              <div>Sorry Still i am unable to terminate calls.Here are
                both files.<span><br>
                  <br>
                  <div>Here is my nibblebill.conf.xml file.<br>
                  </div>
                  <span><br>
                    &lt;configuration name=&quot;nibblebill.conf&quot;
                    description=&quot;Nibble Billing&quot;&gt;<br>
                      &lt;settings&gt;<br>
                        <br>
                        &lt;param name=&quot;odbc-dsn&quot;
                    value=&quot;odbc://freeswitch&quot;/&gt;<br>
                        &lt;param name=&quot;db_table&quot; value=&quot;users&quot;/&gt;<br>
                  </span><span>    &lt;param name=&quot;db_column_cash&quot;
                    value=&quot;balance&quot;/&gt;<br>
                  </span><span>    &lt;param name=&quot;db_column_account&quot;
                    value=&quot;accountcode&quot;/&gt;<br>
                  </span><span>    &lt;param name=&quot;lowbal_amt&quot;
                    value=&quot;5&quot;/&gt;<br>
                        &lt;param name=&quot;lowbal_action&quot; value=&quot;play
                    ding&quot;/&gt;<br>
                    <br>
                    <br>
                  </span></span><span><span>    &lt;param
                    name=&quot;nobal_amt&quot; value=&quot;0&quot;/&gt;<br>
                  </span>    &lt;param name=&quot;nobal_action&quot; value=&quot;hangup
                  XML default&quot;/&gt;<br>
                  <br>
                </span><span><span>    &lt;param
                    name=&quot;percall_max_amt&quot; value=&quot;0&quot;/&gt;<br>
                        &lt;param name=&quot;percall_action&quot;
                    value=&quot;hangup&quot;/&gt;<br>
                    <br>
                      &lt;/settings&gt;<br>
                    &lt;/configuration&gt;</span><br>
                  <br>
                  <br>
                  <br>
                  Here is my default.xml<br>
                  <br>
                  &lt;include&gt;<br>
                    &lt;context name=&quot;default&quot;&gt;<br>
                     &lt;extension name=&quot;unloop&quot;&gt;<br>
                  <br>
                     &lt;condition field=&quot;destination_number&quot;
                  expression=&quot;^(1[2-9][0-9]{2}[0-9]{7})$&quot;&gt;<br>
                             &lt;variable name=&quot;nibble_rate&quot;
                  value=&quot;0.03&quot;/&gt;
                  <br>
                            &lt;variable name=&quot;nibble_account&quot;
                  value=&quot;45893148&quot;/&gt;<br>
                            &lt;action application=&quot;bridge&quot;
                  data=<a href="mailto:sofia/external/1$@168.183.648" target="_blank">&quot;sofia/external/1$@168.183.648&quot;</a>/&gt; <br>
                          &lt;/condition&gt;<br>
                    &lt;/extension&gt;<br>
                  <br>
                  <br>
                </span>&lt;extension name=&quot;hangup&quot;&gt;<br>
                  &lt;condition field=&quot;destination_number&quot;
                expression=&quot;^(hangup)$&quot;&gt;<br>
                    &lt;action application=&quot;hangup&quot;/&gt;<br>
                  &lt;/condition&gt;<br>
                &lt;/extension&gt;<br>
                <br>
                &lt;/context&gt;<br>
                &lt;/include&gt;<br>
                <br>
                <br>
              </div>
              Any Suggestion :(<br>
              <div><br>
              </div>
            </div>
            <div>
              <div>
                <div class="gmail_extra"><br>
                  <div class="gmail_quote">On 19 September 2014 01:33,
                    Aqs Younas <span dir="ltr">&lt;<a href="mailto:aqsyounas@gmail.com" target="_blank">aqsyounas@gmail.com</a>&gt;</span>
                    wrote:<br>
                    <blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
                      <div dir="ltr">
                        <div>Thanks for your reply..i try it and get
                          back to you.<br>
                        </div>
                        Many thanks<br>
                      </div>
                      <div>
                        <div>
                          <div class="gmail_extra"><br>
                            <div class="gmail_quote">On 19 September
                              2014 01:14, Steven Ayre <span dir="ltr">&lt;<a href="mailto:steveayre@gmail.com" target="_blank">steveayre@gmail.com</a>&gt;</span>
                              wrote:<br>
                              <blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
                                <div dir="ltr">
                                  <pre style="font-family:monospace,Courier;padding:1em;border:1px dashed rgb(47,111,171);color:rgb(0,0,0);line-height:1.3em;font-size:12.7272720336914px;background-color:rgb(249,249,249)">&lt;param name=&quot;nobal_action&quot; value=&quot;hangup XML default&quot;/&gt;
</pre>
                                  <div>It&#39;s a dialplan transfer, you
                                    need the XML and context name, and
                                    an extension to handle it.</div>
                                </div>
                                <div class="gmail_extra"><br>
                                  <div class="gmail_quote">
                                    <div>
                                      <div>On 18 September 2014 19:39,
                                        Aqs Younas <span dir="ltr">&lt;<a href="mailto:aqsyounas@gmail.com" target="_blank">aqsyounas@gmail.com</a>&gt;</span>
                                        wrote:<br>
                                      </div>
                                    </div>
                                    <blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
                                      <div>
                                        <div>
                                          <div dir="ltr">
                                            <div>Hi,<br>
                                              <br>
                                            </div>
                                            <div>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.<br>
                                              <br>
                                            </div>
                                            <div>Here is my
                                              nibblebill.conf.xml file.<br>
                                            </div>
                                            <div>
                                              <div><span><br>
                                                  &lt;configuration
                                                  name=&quot;nibblebill.conf&quot;
                                                  description=&quot;Nibble
                                                  Billing&quot;&gt;<br>
                                                    &lt;settings&gt;<br>
                                                      <br>
                                                      &lt;param
                                                  name=&quot;odbc-dsn&quot;
                                                  value=&quot;odbc://freeswitch&quot;/&gt;<br>
                                                      &lt;param
                                                  name=&quot;db_table&quot;
                                                  value=&quot;users&quot;/&gt;<br>
                                                </span><span>   
                                                  &lt;param
                                                  name=&quot;db_column_cash&quot;
                                                  value=&quot;balance&quot;/&gt;<br>
                                                </span><span>   
                                                  &lt;param
                                                  name=&quot;db_column_account&quot;
value=&quot;accountcode&quot;/&gt;<br>
                                                </span><span>   
                                                  &lt;param
                                                  name=&quot;lowbal_amt&quot;
                                                  value=&quot;5&quot;/&gt;<br>
                                                      &lt;param
                                                  name=&quot;lowbal_action&quot;
                                                  value=&quot;play ding&quot;/&gt;<br>
                                                  <br>
                                                  <br>
                                                </span><span>   
                                                  &lt;param
                                                  name=&quot;nobal_amt&quot;
                                                  value=&quot;0&quot;/&gt;<br>
                                                      &lt;param
                                                  name=&quot;nobal_action&quot;
                                                  value=&quot;hangup&quot;/&gt;<br>
                                                  <br>
                                                </span><span>   
                                                  &lt;param
                                                  name=&quot;percall_max_amt&quot;
                                                  value=&quot;0&quot;/&gt;<br>
                                                      &lt;param
                                                  name=&quot;percall_action&quot;
                                                  value=&quot;hangup&quot;/&gt;<br>
                                                  <br>
                                                    &lt;/settings&gt;<br>
                                                  &lt;/configuration&gt;<br>
                                                  <br>
                                                </span></div>
                                              <div>Here is my
                                                default.xml<br>
                                                <br>
                                                include&gt;<br>
                                                  &lt;context
                                                name=&quot;default&quot;&gt;<br>
                                                   &lt;extension
                                                name=&quot;unloop&quot;&gt;<br>
                                                <br>
                                                   &lt;condition
                                                field=&quot;destination_number&quot;
expression=&quot;^(1[2-9][0-9]{2}[0-9]{7})$&quot;&gt;<br>
                                                          &lt;variable
                                                name=&quot;nibble_rate&quot;
                                                value=&quot;0.03&quot;/&gt;
                                                <br>
                                                          &lt;variable
                                                name=&quot;nibble_account&quot;
                                                value=&quot;45893148&quot;/&gt;<br>
                                                          &lt;action
                                                application=&quot;bridge&quot;
                                                data=<a href="mailto:sofia/external/1$@168.183.648" target="_blank">&quot;sofia/external/1$@168.183.648&quot;</a>/&gt;
                                                   <br>
                                                    &lt;/condition&gt;<br>
                                                  &lt;/extension&gt;<br>
                                                  &lt;/context&gt;<br>
                                                &lt;/include&gt;<br>
                                                <br>
                                              </div>
                                              <div>Could Someone please
                                                tell me why
                                                mod_nibblebill is not
                                                terminating call but
                                                accounts call perfectly.<br>
                                                <br>
                                              </div>
                                              <div>(if a user balance is
                                                below or at zero(0)
                                                mob_nibblebill let them
                                                call and after call sets
                                                balance to negative
                                                value)<br>
                                              </div>
                                              <div><br>
                                                Thanks In Advance.<br>
                                              </div>
                                            </div>
                                          </div>
                                          <br>
                                        </div>
                                      </div>
_________________________________________________________________________<br>
                                      Professional FreeSWITCH Consulting
                                      Services:<br>
                                      <a href="mailto:consulting@freeswitch.org" target="_blank">consulting@freeswitch.org</a><br>
                                      <a href="http://www.freeswitchsolutions.com" target="_blank">http://www.freeswitchsolutions.com</a><br>
                                      <br>
                                      Official FreeSWITCH Sites<br>
                                      <a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
                                      <a href="http://confluence.freeswitch.org" target="_blank">http://confluence.freeswitch.org</a><br>
                                      <a href="http://www.cluecon.com" target="_blank">http://www.cluecon.com</a><br>
                                      <br>
                                      FreeSWITCH-powered IP PBX: The
                                      CudaTel Communication Server<br>
                                      <a href="http://www.cudatel.com" target="_blank">http://www.cudatel.com</a><br>
                                      <br>
                                      FreeSWITCH-users mailing list<br>
                                      <a href="mailto:FreeSWITCH-users@lists.freeswitch.org" target="_blank">FreeSWITCH-users@lists.freeswitch.org</a><br>
                                      <a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
                                      UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
                                      <a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
                                    </blockquote>
                                  </div>
                                  <br>
                                </div>
                                <br>
_________________________________________________________________________<br>
                                Professional FreeSWITCH Consulting
                                Services:<br>
                                <a href="mailto:consulting@freeswitch.org" target="_blank">consulting@freeswitch.org</a><br>
                                <a href="http://www.freeswitchsolutions.com" target="_blank">http://www.freeswitchsolutions.com</a><br>
                                <br>
                                Official FreeSWITCH Sites<br>
                                <a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
                                <a href="http://confluence.freeswitch.org" target="_blank">http://confluence.freeswitch.org</a><br>
                                <a href="http://www.cluecon.com" target="_blank">http://www.cluecon.com</a><br>
                                <br>
                                FreeSWITCH-powered IP PBX: The CudaTel
                                Communication Server<br>
                                <a href="http://www.cudatel.com" target="_blank">http://www.cudatel.com</a><br>
                                <br>
                                FreeSWITCH-users mailing list<br>
                                <a href="mailto:FreeSWITCH-users@lists.freeswitch.org" target="_blank">FreeSWITCH-users@lists.freeswitch.org</a><br>
                                <a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
                                UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
                                <a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
                              </blockquote>
                            </div>
                            <br>
                          </div>
                        </div>
                      </div>
                    </blockquote>
                  </div>
                  <br>
                </div>
              </div>
            </div>
          </blockquote>
        </div>
        <br>
      </div>
      <br>
      <fieldset></fieldset>
      <br>
      <pre>_________________________________________________________________________
Professional FreeSWITCH Consulting Services: 
<a href="mailto:consulting@freeswitch.org" target="_blank">consulting@freeswitch.org</a>
<a href="http://www.freeswitchsolutions.com" target="_blank">http://www.freeswitchsolutions.com</a>

Official FreeSWITCH Sites
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a>
<a href="http://confluence.freeswitch.org" target="_blank">http://confluence.freeswitch.org</a>
<a href="http://www.cluecon.com" target="_blank">http://www.cluecon.com</a>

FreeSWITCH-powered IP PBX: The CudaTel Communication Server
<a href="http://www.cudatel.com" target="_blank">http://www.cudatel.com</a>

FreeSWITCH-users mailing list
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org" target="_blank">FreeSWITCH-users@lists.freeswitch.org</a>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a></pre>
    </blockquote>
    <br>
  </div></div></div>

<br>_________________________________________________________________________<br>
Professional FreeSWITCH Consulting Services:<br>
<a href="mailto:consulting@freeswitch.org">consulting@freeswitch.org</a><br>
<a href="http://www.freeswitchsolutions.com" target="_blank">http://www.freeswitchsolutions.com</a><br>
<br>
Official FreeSWITCH Sites<br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
<a href="http://confluence.freeswitch.org" target="_blank">http://confluence.freeswitch.org</a><br>
<a href="http://www.cluecon.com" target="_blank">http://www.cluecon.com</a><br>
<br>
FreeSWITCH-powered IP PBX: The CudaTel Communication Server<br>
<a href="http://www.cudatel.com" target="_blank">http://www.cudatel.com</a><br>
<br>
FreeSWITCH-users mailing list<br>
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a><br>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br></blockquote></div><br></div>