[Freeswitch-users] Nibble billing is not deducted balance

virendra bhati virbhati at gmail.com
Tue Jul 31 10:48:50 MSD 2012 

Hi Team,

I have installed and configure Freeswitch. I want to used Mod_nibblebill
for realtime billing with freeswitch. I have configure and installed
freeswtich with Mod_nibblebill but balance is not deducted still. Any help
will be appreciated....

/******************************************************************/
<configuration name="nibblebill.conf" description="Nibble Billing">
  <settings>
    <!-- See http://wiki.freeswitch.org/wiki/Mod_nibblebill for help with
these options -->

    <!-- Information for connecting to your database -->
    <param name="db_username" value="root"/>
    <param name="db_password" value="ViR39dra"/>
    <param name="db_dsn" value="newfies"/>
    <variable name="nibble_rate" value="11"/>
    <variable name="nibble_increment" value="33" />

    <!-- The database table where your CASH column is located -->
    <param name="db_table" value="accounts"/>

    <!-- The column name where we store the value of the account -->
    <param name="db_column_cash" value="cash"/>

    <!-- The column name for the unique ID identifying the account -->
    <param name="db_column_account" value="id"/>

    <!--  field nibble_balance is used for balance info -->
    <param name="custom_sql_lookup" value="SELECT cash AS nibble_balance
FROM accounts WHERE id='${nibble_account}'"/>

    <!-- nibble_increment is the amount to update -->

    <param name="custom_sql_save" value="UPDATE accounts SET
cash=cash-${nibble_increment} WHERE id='${nibble_account}'"/>

    <!-- Default heartbeat interval. Set to 'off' for no heartbeat (i.e.
bill only at end of call) -->
    <param name="global_heartbeat" value="30"/>

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

    <!-- If a call goes beyond a certain dollar amount, flag or terminate
it -->
    <param name="percall_max_amt" value="100"/>
    <param name="percall_action" value="hangup"/>

  </settings>
</configuration>
/******************************************************************/

*FS CLI *

2012-07-31 02:30:02.268212 [DEBUG] switch_ivr_originate.c:1947 Parsing
global variables
2012-07-31 02:30:02.268212 [DEBUG] switch_event.c:1519 Parsing variable
[plivo_request_uuid]=[28a9ae1a-dad9-11e1-b432-00163e908c9f]
2012-07-31 02:30:02.268212 [DEBUG] switch_event.c:1519 Parsing variable
[plivo_answer_url]=[http://46.252.152.160:8008/api/v1/answercall/]
2012-07-31 02:30:02.268212 [DEBUG] switch_event.c:1519 Parsing variable
[plivo_hangup_url]=[http://46.252.152.160:8008/api/v1/hangupcall/]
2012-07-31 02:30:02.268212 [DEBUG] switch_event.c:1519 Parsing variable
[origination_caller_id_number]=[0498722120]
2012-07-31 02:30:02.268212 [DEBUG] switch_event.c:1519 Parsing variable
[bridge_early_media]=[true]
2012-07-31 02:30:02.268212 [DEBUG] switch_event.c:1519 Parsing variable
[hangup_after_bridge]=[true]
2012-07-31 02:30:02.268212 [DEBUG] switch_event.c:1519 Parsing variable
[hangup_after_bridge]=[true]
2012-07-31 02:30:02.268212 [DEBUG] switch_event.c:1519 Parsing variable
[nibble_account]=[97183008]
2012-07-31 02:30:02.268212 [DEBUG] switch_event.c:1519 Parsing variable
[plivo_from]=[0498722120]
2012-07-31 02:30:02.268212 [DEBUG] switch_event.c:1519 Parsing variable
[plivo_to]=[919718300881]
2012-07-31 02:30:02.268212 [DEBUG] switch_event.c:1519 Parsing variable
[plivo_app]=[true]
2012-07-31 02:30:02.268212 [DEBUG] switch_event.c:1519 Parsing variable
[absolute_codec_string]=[PCMA]
2012-07-31 02:30:02.268212 [DEBUG] switch_event.c:1519 Parsing variable
[originate_timeout]=[60]
2012-07-31 02:30:02.268212 [DEBUG] switch_event.c:1519 Parsing variable
[ignore_early_media]=[true]
2012-07-31 02:30:02.268212 [NOTICE] switch_channel.c:926 New Channel
sofia/external/919718300881 [28aa5810-dad9-11e1-b60b-1782e99edc0a]
2012-07-31 02:30:02.268212 [DEBUG] mod_sofia.c:4705
(sofia/external/919718300881) State Change CS_NEW -> CS_INIT
2012-07-31 02:30:02.268212 [DEBUG] switch_core_session.c:1224 Send signal
sofia/external/919718300881 [BREAK]
2012-07-31 02:30:02.268212 [DEBUG] switch_core_state_machine.c:385
(sofia/external/919718300881) Running State Change CS_INIT
2012-07-31 02:30:02.268212 [DEBUG] switch_core_state_machine.c:424
(sofia/external/919718300881) State INIT
2012-07-31 02:30:02.268212 [DEBUG] mod_sofia.c:85
sofia/external/919718300881 SOFIA INIT
2012-07-31 02:30:02.268212 [DEBUG] mod_sofia.c:125
(sofia/external/919718300881) State Change CS_INIT -> CS_ROUTING
2012-07-31 02:30:02.268212 [DEBUG] switch_core_session.c:1224 Send signal
sofia/external/919718300881 [BREAK]
2012-07-31 02:30:02.268212 [DEBUG] switch_core_state_machine.c:424
(sofia/external/919718300881) State INIT going to sleep
2012-07-31 02:30:02.268212 [DEBUG] switch_core_state_machine.c:385
(sofia/external/919718300881) Running State Change CS_ROUTING
2012-07-31 02:30:02.268212 [DEBUG] switch_channel.c:1919
(sofia/external/919718300881) Callstate Change DOWN -> RINGING
2012-07-31 02:30:02.268212 [DEBUG] switch_core_state_machine.c:433
(sofia/external/919718300881) State ROUTING
2012-07-31 02:30:02.268212 [DEBUG] mod_sofia.c:148
sofia/external/919718300881 SOFIA ROUTING
2012-07-31 02:30:02.268212 [DEBUG] switch_ivr_originate.c:67
(sofia/external/919718300881) State Change CS_ROUTING -> CS_CONSUME_MEDIA
2012-07-31 02:30:02.268212 [DEBUG] switch_core_session.c:1224 Send signal
sofia/external/919718300881 [BREAK]
2012-07-31 02:30:02.268212 [DEBUG] mod_nibblebill.c:383 Doing lookup query
[SELECT cash AS nibble_balance FROM accounts WHERE id='97183008']
2012-07-31 02:30:02.268212 [DEBUG] switch_core_session.c:919 Send signal
sofia/external/919718300881 [BREAK]
2012-07-31 02:30:02.268212 [DEBUG] mod_nibblebill.c:393 Retrieved current
balance for account 97183008 (balance = 500.500000)
2012-07-31 02:30:02.268212 [DEBUG] switch_core_state_machine.c:433
(sofia/external/919718300881) State ROUTING going to sleep
2012-07-31 02:30:02.268212 [DEBUG] switch_core_state_machine.c:385
(sofia/external/919718300881) Running State Change CS_CONSUME_MEDIA
2012-07-31 02:30:02.268212 [DEBUG] switch_core_state_machine.c:452
(sofia/external/919718300881) State CONSUME_MEDIA
2012-07-31 02:30:02.268212 [DEBUG] mod_nibblebill.c:383 Doing lookup query
[SELECT cash AS nibble_balance FROM accounts WHERE id='97183008']
2012-07-31 02:30:02.268212 [DEBUG] mod_nibblebill.c:393 Retrieved current
balance for account 97183008 (balance = 500.500000)
2012-07-31 02:30:02.268212 [DEBUG] switch_core_state_machine.c:452
(sofia/external/919718300881) State CONSUME_MEDIA going to sleep
2012-07-31 02:30:02.268212 [DEBUG] sofia.c:5745 Channel
sofia/external/919718300881 entering state [calling][0]
2012-07-31 02:30:02.308197 [DEBUG] switch_core_session.c:919 Send signal
sofia/external/919718300881 [BREAK]
2012-07-31 02:30:02.308197 [DEBUG] switch_core_session.c:919 Send signal
sofia/external/919718300881 [BREAK]
2012-07-31 02:30:02.308197 [DEBUG] sofia.c:5745 Channel
sofia/external/919718300881 entering state [calling][0]
2012-07-31 02:30:05.488328 [DEBUG] switch_core_session.c:919 Send signal
sofia/external/919718300881 [BREAK]
2012-07-31 02:30:05.488328 [DEBUG] switch_core_session.c:919 Send signal
sofia/external/919718300881 [BREAK]
2012-07-31 02:30:05.488328 [DEBUG] sofia.c:5745 Channel
sofia/external/919718300881 entering state [proceeding][183]
2012-07-31 02:30:05.488328 [DEBUG] sofia.c:5756 Remote SDP:
v=0
o=root 3607 3607 IN IP4 31.216.132.13
s=session
c=IN IP4 31.216.132.13
t=0 0
m=audio 14460 RTP/AVP 8 101
a=rtpmap:8 PCMA/8000
a=rtpmap:101 telephone-event/8000
a=fmtp:101 0-16
a=silenceSupp:off - - - -
a=ptime:20

2012-07-31 02:30:05.488328 [DEBUG] sofia_glue.c:4915 Audio Codec Compare
[PCMA:8:8000:20:64000]/[PCMA:8:8000:20:64000]
2012-07-31 02:30:05.488328 [DEBUG] sofia_glue.c:2995 Set Codec
sofia/external/919718300881 PCMA/8000 20 ms 160 samples 64000 bits
2012-07-31 02:30:05.488328 [DEBUG] switch_core_codec.c:111
sofia/external/919718300881 Original read codec set to PCMA:8
2012-07-31 02:30:05.488328 [DEBUG] sofia_glue.c:5029 Set 2833 dtmf send
payload to 101
2012-07-31 02:30:05.488328 [DEBUG] sofia_glue.c:3244 AUDIO RTP
[sofia/external/919718300881] 46.252.152.160 port 20512 -> 31.216.132.13
port 14460 codec: 8 ms: 20
2012-07-31 02:30:05.488328 [DEBUG] switch_rtp.c:1676 Starting timer [soft]
160 bytes per 20ms
2012-07-31 02:30:05.508186 [DEBUG] sofia_glue.c:3508 Set 2833 dtmf send
payload to 101
2012-07-31 02:30:05.508186 [DEBUG] sofia_glue.c:3514 Set 2833 dtmf receive
payload to 101
2012-07-31 02:30:05.508186 [DEBUG] sofia_glue.c:3541
sofia/external/919718300881 Set rtp dtmf delay to 40
2012-07-31 02:30:05.508186 [NOTICE] sofia_glue.c:4052 Pre-Answer
sofia/external/919718300881!
2012-07-31 02:30:05.508186 [DEBUG] switch_channel.c:3019
(sofia/external/919718300881) Callstate Change RINGING -> EARLY
2012-07-31 02:31:02.008196 [DEBUG] switch_channel.c:2882
(sofia/external/919718300881) Callstate Change EARLY -> HANGUP
2012-07-31 02:31:02.008196 [NOTICE] switch_ivr_originate.c:3246 Hangup
sofia/external/919718300881 [CS_CONSUME_MEDIA] [NO_ANSWER]
2012-07-31 02:31:02.008196 [DEBUG] switch_channel.c:2905 Send signal
sofia/external/919718300881 [KILL]
2012-07-31 02:31:02.008196 [DEBUG] switch_core_session.c:1224 Send signal
sofia/external/919718300881 [BREAK]
2012-07-31 02:31:02.008196 [DEBUG] switch_core_state_machine.c:385
(sofia/external/919718300881) Running State Change CS_HANGUP
2012-07-31 02:31:02.008196 [DEBUG] switch_core_state_machine.c:625
(sofia/external/919718300881) State HANGUP
2012-07-31 02:31:02.008196 [DEBUG] mod_sofia.c:469 Channel
sofia/external/919718300881 hanging up, cause: NO_ANSWER
2012-07-31 02:31:02.008196 [DEBUG] mod_sofia.c:527 Sending CANCEL to
sofia/external/919718300881
2012-07-31 02:31:02.008196 [DEBUG] mod_nibblebill.c:383 Doing lookup query
[SELECT cash AS nibble_balance FROM accounts WHERE id='97183008']
2012-07-31 02:31:02.008196 [DEBUG] mod_nibblebill.c:393 Retrieved current
balance for account 97183008 (balance = 500.500000)
2012-07-31 02:31:02.008196 [DEBUG] switch_core_state_machine.c:47
sofia/external/919718300881 Standard HANGUP, cause: NO_ANSWER
2012-07-31 02:31:02.008196 [DEBUG] switch_core_state_machine.c:625
(sofia/external/919718300881) State HANGUP going to sleep
2012-07-31 02:31:02.008196 [DEBUG] switch_core_state_machine.c:416
(sofia/external/919718300881) State Change CS_HANGUP -> CS_REPORTING
2012-07-31 02:31:02.008196 [DEBUG] switch_core_session.c:1224 Send signal
sofia/external/919718300881 [BREAK]
2012-07-31 02:31:02.008196 [DEBUG] switch_core_state_machine.c:385
(sofia/external/919718300881) Running State Change CS_REPORTING
2012-07-31 02:31:02.008196 [DEBUG] switch_core_state_machine.c:685
(sofia/external/919718300881) State REPORTING
2012-07-31 02:31:02.008196 [DEBUG] switch_core_state_machine.c:79
sofia/external/919718300881 Standard REPORTING, cause: NO_ANSWER
2012-07-31 02:31:02.008196 [DEBUG] switch_core_state_machine.c:685
(sofia/external/919718300881) State REPORTING going to sleep
2012-07-31 02:31:02.008196 [DEBUG] switch_core_state_machine.c:410
(sofia/external/919718300881) State Change CS_REPORTING -> CS_DESTROY
2012-07-31 02:31:02.008196 [DEBUG] switch_core_session.c:1224 Send signal
sofia/external/919718300881 [BREAK]
2012-07-31 02:31:02.008196 [DEBUG] switch_core_session.c:1424 Session 104
(sofia/external/919718300881) Locked, Waiting on external entities
2012-07-31 02:31:02.008196 [NOTICE] switch_core_session.c:1442 Session 104
(sofia/external/919718300881) Ended
2012-07-31 02:31:02.008196 [NOTICE] switch_core_session.c:1444 Close
Channel sofia/external/919718300881 [CS_DESTROY]
2012-07-31 02:31:02.008196 [DEBUG] switch_core_state_machine.c:514
(sofia/external/919718300881) Callstate Change HANGUP -> DOWN
2012-07-31 02:31:02.008196 [DEBUG] switch_core_state_machine.c:517
(sofia/external/919718300881) Running State Change CS_DESTROY
2012-07-31 02:31:02.008196 [DEBUG] switch_core_state_machine.c:527
(sofia/external/919718300881) State DESTROY
2012-07-31 02:31:02.008196 [DEBUG] mod_sofia.c:374
sofia/external/919718300881 SOFIA DESTROY
2012-07-31 02:31:02.008196 [DEBUG] switch_core_state_machine.c:86
sofia/external/919718300881 Standard DESTROY
2012-07-31 02:31:02.008196 [DEBUG] switch_core_state_machine.c:527
(sofia/external/919718300881) State DESTROY going to sleep
freeswitch at internal>

-- 

Thanks and regards

 Virendra Bhati
+91-9718300881
Asterisk Developer
E-mail-: virbhati at gmail.com
Skype id:- virbhati2
New Delhi(India)
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20120731/2c930cc6/attachment-0001.html

Join us at ClueCon 2011 Aug 9-11, 2011
More information about the FreeSWITCH-users mailing list