[Freeswitch-users] mod_nibblebill

Wed Feb 24 06:06:24 PST 2010

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