[Freeswitch-users] mod_nibblebill

Tue Feb 23 15:37:41 PST 2010

what database backend are you using?  Have you verified the SQL is going to
the right database backend?  I use mod_nibblebill against postgresql w/out
problems.

On Tue, Feb 23, 2010 at 9:42 AM, Meg Stroodle <phunk0000 at hotmail.com> wrote:

>  Hello List!  I am trying to install mod_nibblebill on my FS
> installation.  I get the following log entry form FS & nibblebill, but the
> database table I setup remains unchanged.  Any help in this matter would be
> greatly appreciated.  Following is an excerpt from the FS log:
>
>
>
> 2010-02-23 10:32:52.869149 [DEBUG] switch_rtp.c:2004 Correct ip/port
> confirmed.
>
> 2010-02-23 10:32:53.077162 [DEBUG] sofia.c:3727 Channel
> sofia/internal/3007 at 192.168.15.177 entering state [ready][200]
>
> 2010-02-23 10:32:53.149166 [DEBUG] switch_core_session.c:706 Send signal
> sofia/internal/sip:3008 at 192.168.15.176:21828 [BREAK]
>
> 2010-02-23 10:32:53.149166 [DEBUG] switch_core_session.c:706 Send signal
> sofia/internal/3007 at 192.168.15.177 [BREAK]
>
> 2010-02-23 10:32:53.149166 [DEBUG] switch_ivr_bridge.c:131 sofia/internal/
> sip:3008 at 192.168.15.176:21828 receive message [DISPLAY]
>
> 2010-02-23 10:32:53.169168 [DEBUG] switch_ivr_bridge.c:131
> sofia/internal/3007 at 192.168.15.177 receive message [DISPLAY]
>
> 2010-02-23 10:33:21.388949 [DEBUG] mod_nibblebill.c:529 Received request
> via SESSION_HEARTBEAT!
>
> 2010-02-23 10:33:21.388949 [DEBUG] mod_nibblebill.c:397 Attempting to bill
> at $1.0 per minute to account 3007
>
> 2010-02-23 10:33:21.388949 [INFO] mod_nibblebill.c:447 Beginning new
> billing on 3ec17ffc-c94e-46ff-bb0d-7ad0ef27bdab
>
> 2010-02-23 10:33:21.388949 [DEBUG] mod_nibblebill.c:455 28 seconds passed
> since last bill time of 2010-02-23 10:32:52
>
> 2010-02-23 10:33:21.388949 [DEBUG] mod_nibblebill.c:461 Billing $0.475997
> to 3007 (Call: 3ec17ffc-c94e-46ff-bb0d-7ad0ef27bdab / 0.000000 so far)
>
> 2010-02-23 10:33:51.508822 [DEBUG] mod_nibblebill.c:529 Received request
> via SESSION_HEARTBEAT!
>
> 2010-02-23 10:33:51.508822 [DEBUG] mod_nibblebill.c:397 Attempting to bill
> at $1.0 per minute to account 3007
>
> 2010-02-23 10:33:51.508822 [DEBUG] mod_nibblebill.c:449 Last successful
> billing time was
>
> 2010-02-23 10:33:51.508822 [DEBUG] mod_nibblebill.c:455 30 seconds passed
> since last bill time of 2010-02-23 10:33:21
>
> 2010-02-23 10:33:51.508822 [DEBUG] mod_nibblebill.c:461 Billing $0.501998
> to 3007 (Call: 3ec17ffc-c94e-46ff-bb0d-7ad0ef27bdab / 0.475997 so far)
>
> 2010-02-23 10:34:21.649708 [DEBUG] mod_nibblebill.c:529 Received request
> via SESSION_HEARTBEAT!
>
> 2010-02-23 10:34:21.649708 [DEBUG] mod_nibblebill.c:397 Attempting to bill
> at $1.0 per minute to account 3007
>
> 2010-02-23 10:34:21.649708 [DEBUG] mod_nibblebill.c:449 Last successful
> billing time was
>
> 2010-02-23 10:34:21.649708 [DEBUG] mod_nibblebill.c:455 30 seconds passed
> since last bill time of 2010-02-23 10:33:51
>
> 2010-02-23 10:34:21.649708 [DEBUG] mod_nibblebill.c:461 Billing $0.502348
> to 3007 (Call: 3ec17ffc-c94e-46ff-bb0d-7ad0ef27bdab / 0.977995 so far)
>
> 2010-02-23 10:34:26.254308 [NOTICE] sofia.c:329 Hangup
> sofia/internal/3007 at 192.168.15.177 [CS_EXECUTE] [NORMAL_CLEARING]
>
> 2010-02-23 10:34:26.254308 [DEBUG] switch_channel.c:1912 Send signal
> sofia/internal/3007 at 192.168.15.177 [KILL]
>
> 2010-02-23 10:34:26.254308 [DEBUG] switch_core_session.c:999 Send signal
> sofia/internal/3007 at 192.168.15.177 [BREAK]
>
> 2010-02-23 10:34:26.254308 [DEBUG] switch_core_state_machine.c:459
> sofia/internal/3007 at 192.168.15.177 thread mismatch skipping state handler.
>
> 2010-02-23 10:34:26.269008 [DEBUG] switch_ivr_bridge.c:470
> sofia/internal/3007 at 192.168.15.177 ending bridge by request from read
> function
>
> 2010-02-23 10:34:26.269008 [DEBUG] switch_ivr_bridge.c:563 BRIDGE THREAD
> DONE [sofia/internal/3007 at 192.168.15.177]
>
> 2010-02-23 10:34:26.269008 [DEBUG] switch_ivr_bridge.c:565 Send signal
> sofia/internal/sip:3008 at 192.168.15.176:21828 [BREAK]
>
> 2010-02-23 10:34:26.269008 [DEBUG] switch_ivr_bridge.c:520 sofia/internal/
> sip:3008 at 192.168.15.176:21828 receive message [UNBRIDGE]
>
> 2010-02-23 10:34:26.269008 [DEBUG] switch_core_session.c:645 Send signal
> sofia/internal/sip:3008 at 192.168.15.176:21828 [BREAK]
>
> 2010-02-23 10:34:26.269008 [DEBUG] switch_ivr_bridge.c:563 BRIDGE THREAD
> DONE [sofia/internal/sip:3008 at 192.168.15.176:21828]
>
> 2010-02-23 10:34:26.269008 [DEBUG] switch_ivr_bridge.c:565 Send signal
> sofia/internal/3007 at 192.168.15.177 [BREAK]
>
> 2010-02-23 10:34:26.269008 [NOTICE] switch_ivr_bridge.c:617 Hangup
> sofia/internal/sip:3008 at 192.168.15.176:21828 [CS_EXCHANGE_MEDIA]
> [NORMAL_CLEARING]
>
> 2010-02-23 10:34:26.269008 [DEBUG] switch_channel.c:1912 Send signal
> sofia/internal/sip:3008 at 192.168.15.176:21828 [KILL]
>
> 2010-02-23 10:34:26.269008 [DEBUG] switch_core_session.c:999 Send signal
> sofia/internal/sip:3008 at 192.168.15.176:21828 [BREAK]
>
> 2010-02-23 10:34:26.269008 [DEBUG] switch_core_state_machine.c:488
> (sofia/internal/sip:3008 at 192.168.15.176:21828) State HANGUP
>
> 2010-02-23 10:34:26.269008 [DEBUG] mod_sofia.c:358 Channel sofia/internal/
> sip:3008 at 192.168.15.176:21828 hanging up, cause: NORMAL_CLEARING
>
> 2010-02-23 10:34:26.269008 [DEBUG] mod_sofia.c:400 Sending BYE to
> sofia/internal/sip:3008 at 192.168.15.176:21828
>
> 2010-02-23 10:34:26.269008 [DEBUG] mod_nibblebill.c:397 Attempting to bill
> at $2.30 per minute to account 3008
>
> 2010-02-23 10:34:26.269008 [INFO] mod_nibblebill.c:447 Beginning new
> billing on c1c42712-89e9-44c5-914f-11ed8f6aebb1
>
> 2010-02-23 10:34:26.269008 [DEBUG] mod_nibblebill.c:455 93 seconds passed
> since last bill time of 2010-02-23 10:32:52
>
> 2010-02-23 10:34:26.269008 [DEBUG] mod_nibblebill.c:461 Billing $3.582436
> to 3008 (Call: c1c42712-89e9-44c5-914f-11ed8f6aebb1 / 0.000000 so far)
>
> 2010-02-23 10:34:26.269008 [DEBUG] switch_core_state_machine.c:46
> sofia/internal/sip:3008 at 192.168.15.176:21828 Standard HANGUP, cause:
> NORMAL_CLEARING
>
> 2010-02-23 10:34:26.269008 [DEBUG] switch_core_state_machine.c:488
> (sofia/internal/sip:3008 at 192.168.15.176:21828) State HANGUP going to sleep
>
> 2010-02-23 10:34:26.269008 [INFO] switch_core_session.c:1108
> sofia/internal/sip:3008 at 192.168.15.176:21828 setting session heartbeat to
> 30 second(s).
>
> 2010-02-23 10:34:26.269008 [DEBUG] switch_core_state_machine.c:351
> (sofia/internal/sip:3008 at 192.168.15.176:21828) State EXCHANGE_MEDIA going
> to sleep
>
> 2010-02-23 10:34:26.269008 [DEBUG] switch_core_state_machine.c:314
> (sofia/internal/sip:3008 at 192.168.15.176:21828) Running State Change
> CS_HANGUP
>
> 2010-02-23 10:34:26.269008 [DEBUG] switch_core_state_machine.c:465
> sofia/internal/sip:3008 at 192.168.15.176:21828 handler already called,
> skipping state handler.
>
> 2010-02-23 10:34:26.269008 [DEBUG] switch_core_state_machine.c:333
> (sofia/internal/sip:3008 at 192.168.15.176:21828) State Change CS_HANGUP ->
> CS_REPORTING
>
> 2010-02-23 10:34:26.269008 [DEBUG] switch_core_session.c:999 Send signal
> sofia/internal/sip:3008 at 192.168.15.176:21828 [BREAK]
>
> 2010-02-23 10:34:26.269008 [DEBUG] switch_core_state_machine.c:314
> (sofia/internal/sip:3008 at 192.168.15.176:21828) Running State Change
> CS_REPORTING
>
> 2010-02-23 10:34:26.269008 [DEBUG] switch_core_state_machine.c:579
> (sofia/internal/sip:3008 at 192.168.15.176:21828) State REPORTING
>
> 2010-02-23 10:34:26.269008 [DEBUG] switch_core_state_machine.c:53
> sofia/internal/sip:3008 at 192.168.15.176:21828 Standard REPORTING, cause:
> NORMAL_CLEARING
>
> 2010-02-23 10:34:26.269008 [DEBUG] switch_core_state_machine.c:579
> (sofia/internal/sip:3008 at 192.168.15.176:21828) State REPORTING going to
> sleep
>
> 2010-02-23 10:34:26.269008 [DEBUG] switch_core_state_machine.c:327
> (sofia/internal/sip:3008 at 192.168.15.176:21828) State Change CS_REPORTING
> -> CS_DESTROY
>
> 2010-02-23 10:34:26.269008 [DEBUG] switch_core_session.c:999 Send signal
> sofia/internal/sip:3008 at 192.168.15.176:21828 [BREAK]
>
> 2010-02-23 10:34:26.269008 [DEBUG] switch_core_session.c:1136 Session 6
> (sofia/internal/sip:3008 at 192.168.15.176:21828) Locked, Waiting on external
> entities
>
> 2010-02-23 10:34:26.272437 [DEBUG] switch_core_state_machine.c:348 (
> sofia/internal/3007 at 192.168.15.177) State EXECUTE going to sleep
>
> 2010-02-23 10:34:26.272437 [DEBUG] switch_core_state_machine.c:314 (
> sofia/internal/3007 at 192.168.15.177) Running State Change CS_HANGUP
>
> 2010-02-23 10:34:26.272437 [DEBUG] switch_core_state_machine.c:488 (
> sofia/internal/3007 at 192.168.15.177) State HANGUP
>
> 2010-02-23 10:34:26.272437 [DEBUG] mod_sofia.c:358 Channel
> sofia/internal/3007 at 192.168.15.177 hanging up, cause: NORMAL_CLEARING
>
> 2010-02-23 10:34:26.272437 [DEBUG] mod_nibblebill.c:397 Attempting to bill
> at $1.0 per minute to account 3007
>
> 2010-02-23 10:34:26.272437 [DEBUG] mod_nibblebill.c:449 Last successful
> billing time was
>
> 2010-02-23 10:34:26.272437 [DEBUG] mod_nibblebill.c:455 4 seconds passed
> since last bill time of 2010-02-23 10:34:21
>
> 2010-02-23 10:34:26.272437 [DEBUG] mod_nibblebill.c:461 Billing $0.077045
> to 3007 (Call: 3ec17ffc-c94e-46ff-bb0d-7ad0ef27bdab / 1.480343 so far)
>
> 2010-02-23 10:34:26.272437 [DEBUG] switch_core_state_machine.c:46
> sofia/internal/3007 at 192.168.15.177 Standard HANGUP, cause: NORMAL_CLEARING
>
>
>
> Anyhelp getting nibblebill to connect to the database would be greatly
> appreciated.  Thanks
>
>
>
> ------------------------------
> Hotmail: Trusted email with Microsoft’s powerful SPAM protection. Sign up
> now. <http://clk.atdmt.com/GBL/go/201469226/direct/01/>
>
> _______________________________________________
> 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
>
>

-- 
-Rupa
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20100223/1e887229/attachment-0002.html 