isql mysql_fs (ODBC connection name)

---------- Forwarded message ----------
From: "Todd" <phunk0000@hotmail.com>
To: <freeswitch-users@lists.freeswitch.org>
Date: Wed, 24 Feb 2010 11:35:22 -0500
Subject: Re: [Freeswitch-users] mod_nibblebill

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@lists.freeswitch.org [mailto:freeswitch-users-bounces@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@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@lists.freeswitch.org [mailto:freeswitch-users-bounces@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@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@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@192.168.15.176:21828 [BREAK]

2010-02-23 10:32:53.149166 [DEBUG] switch_core_session.c:706 Send signal sofia/internal/3007@192.168.15.177 [BREAK]

2010-02-23 10:32:53.149166 [DEBUG] switch_ivr_bridge.c:131 sofia/internal/sip:3008@192.168.15.176:21828 receive message [DISPLAY]

2010-02-23 10:32:53.169168 [DEBUG] switch_ivr_bridge.c:131 sofia/internal/3007@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@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@192.168.15.177 [KILL]

2010-02-23 10:34:26.254308 [DEBUG] switch_core_session.c:999 Send signal sofia/internal/3007@192.168.15.177 [BREAK]

2010-02-23 10:34:26.254308 [DEBUG] switch_core_state_machine.c:459 sofia/internal/3007@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@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@192.168.15.177]

2010-02-23 10:34:26.269008 [DEBUG] switch_ivr_bridge.c:565 Send signal sofia/internal/sip:3008@192.168.15.176:21828 [BREAK]

2010-02-23 10:34:26.269008 [DEBUG] switch_ivr_bridge.c:520 sofia/internal/sip:3008@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@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@192.168.15.176:21828]

2010-02-23 10:34:26.269008 [DEBUG] switch_ivr_bridge.c:565 Send signal sofia/internal/3007@192.168.15.177 [BREAK]

2010-02-23 10:34:26.269008 [NOTICE] switch_ivr_bridge.c:617 Hangup sofia/internal/sip:3008@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@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@192.168.15.176:21828 [BREAK]

2010-02-23 10:34:26.269008 [DEBUG] switch_core_state_machine.c:488 (sofia/internal/sip:3008@192.168.15.176:21828) State HANGUP

2010-02-23 10:34:26.269008 [DEBUG] mod_sofia.c:358 Channel sofia/internal/sip:3008@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@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@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@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@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@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@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@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@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@192.168.15.176:21828 [BREAK]

2010-02-23 10:34:26.269008 [DEBUG] switch_core_state_machine.c:314 (sofia/internal/sip:3008@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@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@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@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@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@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@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@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@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@192.168.15.177) State HANGUP

2010-02-23 10:34:26.272437 [DEBUG] mod_sofia.c:358 Channel sofia/internal/3007@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@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.

_______________________________________________
FreeSWITCH-users mailing list
FreeSWITCH-users@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@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@lists.freeswitch.org
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
http://www.freeswitch.org

--
Regards,

Ahmed Munir