Re: [Freeswitch-users] FreeSWITCH-users Digest, Vol 44, Issue 217
Hi Tod, After configuring ODBC connection using MySQL database issue isql *ODBC Connection Name *on cli. If it connects successfully you can see the database's tables what you've mentioned in odbc.ini file i.e. 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. <http://clk.atdmt.com/GBL/go/201469226/direct/01/>
_______________________________________________ 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
participants (1)
-
Ahmed Munir