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.
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
_______________________________________________
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