[Freeswitch-users] mod_nibblebill

Wed Feb 24 08:35:22 PST 2010

Yeah,  think I'm going to give it a shot from the beginning again and be
very careful about install and config.  Thanks, I will keep you posted. 

From: freeswitch-users-bounces at lists.freeswitch.org
[mailto:freeswitch-users-bounces at lists.freeswitch.org] On Behalf Of Rupa
Schomaker
Sent: Wednesday, February 24, 2010 9:06 AM
To: freeswitch-users
Subject: Re: [Freeswitch-users] mod_nibblebill

I am only passingly familiar with MySQL.   There must be a way for it to log
all sql statements sent to it?  

Setting up postgresql would be the same (in broad terms) as mysql.  Install
packages, create database/user/tables, populate data, configure odbc dsn,
test.

On Wed, Feb 24, 2010 at 7:03 AM, Todd <phunk0000 at hotmail.com> wrote:

I am attempting to us MySQL.  I installed the spidermonkey mod, newest ODBC,
compiled FS with ODBC, configured xml's in FS.  not 100% sure I did it right
though..followed wiki directions as close as possible.  What is the best way
to verify the SQL is talking to MySQL. or perhaps the easiest way to switch
to postgresql?  Still kinda new to DB admin.  Thanks a ton.

From: freeswitch-users-bounces at lists.freeswitch.org
[mailto:freeswitch-users-bounces at lists.freeswitch.org] On Behalf Of Rupa
Schomaker
Sent: Tuesday, February 23, 2010 6:38 PM
To: freeswitch-users
Subject: Re: [Freeswitch-users] mod_nibblebill

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
<http://clk.atdmt.com/GBL/go/201469226/direct/01/>  now.

_______________________________________________
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

_______________________________________________
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/20100224/e99d37d3/attachment-0002.html 