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.<br><br><div class="gmail_quote">On Tue, Feb 23, 2010 at 9:42 AM, Meg Stroodle <span dir="ltr"><<a href="mailto:phunk0000@hotmail.com">phunk0000@hotmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<div>
<p class="MsoNormal">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:</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">2010-02-23 10:32:52.869149 [DEBUG] switch_rtp.c:2004 Correct
ip/port confirmed.</p>
<p class="MsoNormal">2010-02-23 10:32:53.077162 [DEBUG] sofia.c:3727 Channel <a href="mailto:sofia/internal/3007@192.168.15.177" target="_blank">sofia/internal/3007@192.168.15.177</a>
entering state [ready][200]</p>
<p class="MsoNormal">2010-02-23 10:32:53.149166 [DEBUG] switch_core_session.c:706
Send signal sofia/internal/<a href="http://sip:3008@192.168.15.176:21828" target="_blank">sip:3008@192.168.15.176:21828</a> [BREAK]</p>
<p class="MsoNormal">2010-02-23 10:32:53.149166 [DEBUG] switch_core_session.c:706
Send signal <a href="mailto:sofia/internal/3007@192.168.15.177" target="_blank">sofia/internal/3007@192.168.15.177</a>
[BREAK]</p>
<p class="MsoNormal">2010-02-23 10:32:53.149166 [DEBUG] switch_ivr_bridge.c:131
sofia/internal/<a href="http://sip:3008@192.168.15.176:21828" target="_blank">sip:3008@192.168.15.176:21828</a> receive message [DISPLAY]</p>
<p class="MsoNormal">2010-02-23 10:32:53.169168 [DEBUG] switch_ivr_bridge.c:131 <a href="mailto:sofia/internal/3007@192.168.15.177" target="_blank">sofia/internal/3007@192.168.15.177</a>
receive message [DISPLAY]</p>
<p class="MsoNormal">2010-02-23 10:33:21.388949 [DEBUG] mod_nibblebill.c:529
Received request via SESSION_HEARTBEAT!</p>
<p class="MsoNormal">2010-02-23 10:33:21.388949 [DEBUG] mod_nibblebill.c:397
Attempting to bill at $1.0 per minute to account 3007</p>
<p class="MsoNormal">2010-02-23 10:33:21.388949 [INFO] mod_nibblebill.c:447
Beginning new billing on 3ec17ffc-c94e-46ff-bb0d-7ad0ef27bdab</p>
<p class="MsoNormal">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</p>
<p class="MsoNormal">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)</p>
<p class="MsoNormal">2010-02-23 10:33:51.508822 [DEBUG] mod_nibblebill.c:529
Received request via SESSION_HEARTBEAT!</p>
<p class="MsoNormal">2010-02-23 10:33:51.508822 [DEBUG] mod_nibblebill.c:397 Attempting
to bill at $1.0 per minute to account 3007</p>
<p class="MsoNormal">2010-02-23 10:33:51.508822 [DEBUG] mod_nibblebill.c:449 Last
successful billing time was </p>
<p class="MsoNormal">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</p>
<p class="MsoNormal">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)</p>
<p class="MsoNormal">2010-02-23 10:34:21.649708 [DEBUG] mod_nibblebill.c:529
Received request via SESSION_HEARTBEAT!</p>
<p class="MsoNormal">2010-02-23 10:34:21.649708 [DEBUG] mod_nibblebill.c:397
Attempting to bill at $1.0 per minute to account 3007</p>
<p class="MsoNormal">2010-02-23 10:34:21.649708 [DEBUG] mod_nibblebill.c:449 Last
successful billing time was </p>
<p class="MsoNormal">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</p>
<p class="MsoNormal">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)</p>
<p class="MsoNormal">2010-02-23 10:34:26.254308 [NOTICE] sofia.c:329 Hangup <a href="mailto:sofia/internal/3007@192.168.15.177" target="_blank">sofia/internal/3007@192.168.15.177</a>
[CS_EXECUTE] [NORMAL_CLEARING]</p>
<p class="MsoNormal">2010-02-23 10:34:26.254308 [DEBUG] switch_channel.c:1912
Send signal <a href="mailto:sofia/internal/3007@192.168.15.177" target="_blank">sofia/internal/3007@192.168.15.177</a>
[KILL]</p>
<p class="MsoNormal">2010-02-23 10:34:26.254308 [DEBUG] switch_core_session.c:999
Send signal <a href="mailto:sofia/internal/3007@192.168.15.177" target="_blank">sofia/internal/3007@192.168.15.177</a>
[BREAK]</p>
<p class="MsoNormal">2010-02-23 10:34:26.254308 [DEBUG]
switch_core_state_machine.c:459 <a href="mailto:sofia/internal/3007@192.168.15.177" target="_blank">sofia/internal/3007@192.168.15.177</a>
thread mismatch skipping state handler.</p>
<p class="MsoNormal">2010-02-23 10:34:26.269008 [DEBUG] switch_ivr_bridge.c:470 <a href="mailto:sofia/internal/3007@192.168.15.177" target="_blank">sofia/internal/3007@192.168.15.177</a>
ending bridge by request from read function</p>
<p class="MsoNormal">2010-02-23 10:34:26.269008 [DEBUG] switch_ivr_bridge.c:563
BRIDGE THREAD DONE [sofia/internal/<a href="mailto:3007@192.168.15.177" target="_blank">3007@192.168.15.177</a>]</p>
<p class="MsoNormal">2010-02-23 10:34:26.269008 [DEBUG] switch_ivr_bridge.c:565
Send signal sofia/internal/<a href="http://sip:3008@192.168.15.176:21828" target="_blank">sip:3008@192.168.15.176:21828</a> [BREAK]</p>
<p class="MsoNormal">2010-02-23 10:34:26.269008 [DEBUG] switch_ivr_bridge.c:520
sofia/internal/<a href="http://sip:3008@192.168.15.176:21828" target="_blank">sip:3008@192.168.15.176:21828</a> receive message [UNBRIDGE]</p>
<p class="MsoNormal">2010-02-23 10:34:26.269008 [DEBUG] switch_core_session.c:645
Send signal sofia/internal/<a href="http://sip:3008@192.168.15.176:21828" target="_blank">sip:3008@192.168.15.176:21828</a> [BREAK]</p>
<p class="MsoNormal">2010-02-23 10:34:26.269008 [DEBUG] switch_ivr_bridge.c:563
BRIDGE THREAD DONE [sofia/internal/<a href="http://sip:3008@192.168.15.176:21828" target="_blank">sip:3008@192.168.15.176:21828</a>]</p>
<p class="MsoNormal">2010-02-23 10:34:26.269008 [DEBUG] switch_ivr_bridge.c:565
Send signal <a href="mailto:sofia/internal/3007@192.168.15.177" target="_blank">sofia/internal/3007@192.168.15.177</a>
[BREAK]</p>
<p class="MsoNormal">2010-02-23 10:34:26.269008 [NOTICE] switch_ivr_bridge.c:617
Hangup sofia/internal/<a href="http://sip:3008@192.168.15.176:21828" target="_blank">sip:3008@192.168.15.176:21828</a> [CS_EXCHANGE_MEDIA]
[NORMAL_CLEARING]</p>
<p class="MsoNormal">2010-02-23 10:34:26.269008 [DEBUG] switch_channel.c:1912
Send signal sofia/internal/<a href="http://sip:3008@192.168.15.176:21828" target="_blank">sip:3008@192.168.15.176:21828</a> [KILL]</p>
<p class="MsoNormal">2010-02-23 10:34:26.269008 [DEBUG] switch_core_session.c:999
Send signal sofia/internal/<a href="http://sip:3008@192.168.15.176:21828" target="_blank">sip:3008@192.168.15.176:21828</a> [BREAK]</p>
<p class="MsoNormal">2010-02-23 10:34:26.269008 [DEBUG]
switch_core_state_machine.c:488 (sofia/internal/<a href="http://sip:3008@192.168.15.176:21828" target="_blank">sip:3008@192.168.15.176:21828</a>)
State HANGUP</p>
<p class="MsoNormal">2010-02-23 10:34:26.269008 [DEBUG] mod_sofia.c:358 Channel
sofia/internal/<a href="http://sip:3008@192.168.15.176:21828" target="_blank">sip:3008@192.168.15.176:21828</a> hanging up, cause: NORMAL_CLEARING</p>
<p class="MsoNormal">2010-02-23 10:34:26.269008 [DEBUG] mod_sofia.c:400 Sending
BYE to sofia/internal/<a href="http://sip:3008@192.168.15.176:21828" target="_blank">sip:3008@192.168.15.176:21828</a></p>
<p class="MsoNormal">2010-02-23 10:34:26.269008 [DEBUG] mod_nibblebill.c:397
Attempting to bill at $2.30 per minute to account 3008</p>
<p class="MsoNormal">2010-02-23 10:34:26.269008 [INFO] mod_nibblebill.c:447
Beginning new billing on c1c42712-89e9-44c5-914f-11ed8f6aebb1</p>
<p class="MsoNormal">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</p>
<p class="MsoNormal">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)</p>
<p class="MsoNormal">2010-02-23 10:34:26.269008 [DEBUG]
switch_core_state_machine.c:46 sofia/internal/<a href="http://sip:3008@192.168.15.176:21828" target="_blank">sip:3008@192.168.15.176:21828</a>
Standard HANGUP, cause: NORMAL_CLEARING</p>
<p class="MsoNormal">2010-02-23 10:34:26.269008 [DEBUG]
switch_core_state_machine.c:488 (sofia/internal/<a href="http://sip:3008@192.168.15.176:21828" target="_blank">sip:3008@192.168.15.176:21828</a>)
State HANGUP going to sleep</p>
<p class="MsoNormal">2010-02-23 10:34:26.269008 [INFO] switch_core_session.c:1108
sofia/internal/<a href="http://sip:3008@192.168.15.176:21828" target="_blank">sip:3008@192.168.15.176:21828</a> setting session heartbeat to 30
second(s).</p>
<p class="MsoNormal">2010-02-23 10:34:26.269008 [DEBUG] switch_core_state_machine.c:351
(sofia/internal/<a href="http://sip:3008@192.168.15.176:21828" target="_blank">sip:3008@192.168.15.176:21828</a>) State EXCHANGE_MEDIA going to
sleep</p>
<p class="MsoNormal">2010-02-23 10:34:26.269008 [DEBUG]
switch_core_state_machine.c:314 (sofia/internal/<a href="http://sip:3008@192.168.15.176:21828" target="_blank">sip:3008@192.168.15.176:21828</a>)
Running State Change CS_HANGUP</p>
<p class="MsoNormal">2010-02-23 10:34:26.269008 [DEBUG]
switch_core_state_machine.c:465 sofia/internal/<a href="http://sip:3008@192.168.15.176:21828" target="_blank">sip:3008@192.168.15.176:21828</a>
handler already called, skipping state handler.</p>
<p class="MsoNormal">2010-02-23 10:34:26.269008 [DEBUG]
switch_core_state_machine.c:333 (sofia/internal/<a href="http://sip:3008@192.168.15.176:21828" target="_blank">sip:3008@192.168.15.176:21828</a>)
State Change CS_HANGUP -> CS_REPORTING</p>
<p class="MsoNormal">2010-02-23 10:34:26.269008 [DEBUG] switch_core_session.c:999
Send signal sofia/internal/<a href="http://sip:3008@192.168.15.176:21828" target="_blank">sip:3008@192.168.15.176:21828</a> [BREAK]</p>
<p class="MsoNormal">2010-02-23 10:34:26.269008 [DEBUG] switch_core_state_machine.c:314
(sofia/internal/<a href="http://sip:3008@192.168.15.176:21828" target="_blank">sip:3008@192.168.15.176:21828</a>) Running State Change
CS_REPORTING</p>
<p class="MsoNormal">2010-02-23 10:34:26.269008 [DEBUG]
switch_core_state_machine.c:579 (sofia/internal/<a href="http://sip:3008@192.168.15.176:21828" target="_blank">sip:3008@192.168.15.176:21828</a>)
State REPORTING</p>
<p class="MsoNormal">2010-02-23 10:34:26.269008 [DEBUG]
switch_core_state_machine.c:53 sofia/internal/<a href="http://sip:3008@192.168.15.176:21828" target="_blank">sip:3008@192.168.15.176:21828</a>
Standard REPORTING, cause: NORMAL_CLEARING</p>
<p class="MsoNormal">2010-02-23 10:34:26.269008 [DEBUG]
switch_core_state_machine.c:579 (sofia/internal/<a href="http://sip:3008@192.168.15.176:21828" target="_blank">sip:3008@192.168.15.176:21828</a>)
State REPORTING going to sleep</p>
<p class="MsoNormal">2010-02-23 10:34:26.269008 [DEBUG]
switch_core_state_machine.c:327 (sofia/internal/<a href="http://sip:3008@192.168.15.176:21828" target="_blank">sip:3008@192.168.15.176:21828</a>)
State Change CS_REPORTING -> CS_DESTROY</p>
<p class="MsoNormal">2010-02-23 10:34:26.269008 [DEBUG] switch_core_session.c:999
Send signal sofia/internal/<a href="http://sip:3008@192.168.15.176:21828" target="_blank">sip:3008@192.168.15.176:21828</a> [BREAK]</p>
<p class="MsoNormal">2010-02-23 10:34:26.269008 [DEBUG]
switch_core_session.c:1136 Session 6
(sofia/internal/<a href="http://sip:3008@192.168.15.176:21828" target="_blank">sip:3008@192.168.15.176:21828</a>) Locked, Waiting on external
entities</p>
<p class="MsoNormal">2010-02-23 10:34:26.272437 [DEBUG] switch_core_state_machine.c:348
(<a href="mailto:sofia/internal/3007@192.168.15.177" target="_blank">sofia/internal/3007@192.168.15.177</a>)
State EXECUTE going to sleep</p>
<p class="MsoNormal">2010-02-23 10:34:26.272437 [DEBUG]
switch_core_state_machine.c:314 (<a href="mailto:sofia/internal/3007@192.168.15.177" target="_blank">sofia/internal/3007@192.168.15.177</a>)
Running State Change CS_HANGUP</p>
<p class="MsoNormal">2010-02-23 10:34:26.272437 [DEBUG] switch_core_state_machine.c:488
(<a href="mailto:sofia/internal/3007@192.168.15.177" target="_blank">sofia/internal/3007@192.168.15.177</a>)
State HANGUP</p>
<p class="MsoNormal">2010-02-23 10:34:26.272437 [DEBUG] mod_sofia.c:358 Channel <a href="mailto:sofia/internal/3007@192.168.15.177" target="_blank">sofia/internal/3007@192.168.15.177</a>
hanging up, cause: NORMAL_CLEARING</p>
<p class="MsoNormal">2010-02-23 10:34:26.272437 [DEBUG] mod_nibblebill.c:397
Attempting to bill at $1.0 per minute to account 3007</p>
<p class="MsoNormal">2010-02-23 10:34:26.272437 [DEBUG] mod_nibblebill.c:449 Last
successful billing time was </p>
<p class="MsoNormal">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</p>
<p class="MsoNormal">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)</p>
<p class="MsoNormal">2010-02-23 10:34:26.272437 [DEBUG]
switch_core_state_machine.c:46 <a href="mailto:sofia/internal/3007@192.168.15.177" target="_blank">sofia/internal/3007@192.168.15.177</a>
Standard HANGUP, cause: NORMAL_CLEARING</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">Anyhelp getting nibblebill to connect to the database would
be greatly appreciated. Thanks</p>
<p class="MsoNormal"> </p><div class="hm">
<br><hr>Hotmail: Trusted email with Microsoft’s powerful SPAM protection. <a href="http://clk.atdmt.com/GBL/go/201469226/direct/01/" target="_blank">Sign up now.</a></div></div>
<br>_______________________________________________<br>
FreeSWITCH-users mailing list<br>
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a><br>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
<br></blockquote></div><br><br clear="all"><br>-- <br>-Rupa<br>