[Freeswitch-users] mod_nibblebill

[phunk000]

Hello there!  I am using the fusionPBX freeSWITCH installation.  I am
attempting to setup the mod_nibblebill module to keep track of billing using
a database.  I have installed ODBC, mod_spidermonkey, and nibblebill appears
to be working, except for the blank line after "last successful billing time
was____" based on the freeSWITCH log as follows:


2010-02-22 08:46:55.535673 [DEBUG] switch_ivr_bridge.c:131
sofia/internal/sip:3008 at 192.168.15.176:42866 receive message [DISPLAY]
2010-02-22 08:46:55.555674 [DEBUG] switch_ivr_bridge.c:131
sofia/internal/3007 at 192.168.15.177 receive message [DISPLAY]
2010-02-22 08:47:23.735442 [DEBUG] mod_nibblebill.c:529 Received request via
SESSION_HEARTBEAT!
2010-02-22 08:47:23.735442 [DEBUG] mod_nibblebill.c:397 Attempting to bill
at $1.0 per minute to account 3007
2010-02-22 08:47:23.735442 [INFO] mod_nibblebill.c:447 Beginning new billing
on 68cde83c-26f4-44e3-8060-4188a106ff51
2010-02-22 08:47:23.735442 [DEBUG] mod_nibblebill.c:455 28 seconds passed
since last bill time of 2010-02-22 08:46:55
2010-02-22 08:47:23.735442 [DEBUG] mod_nibblebill.c:461 Billing $0.474338 to
3007 (Call: 68cde83c-26f4-44e3-8060-4188a106ff51 / 0.000000 so far)
2010-02-22 08:47:42.701637 [DEBUG] switch_core_sqldb.c:111 Dropping idle DB
connection db="core";user="";pass="";thread="3070618512"
2010-02-22 08:47:42.701637 [DEBUG] switch_core_sqldb.c:111 Dropping idle DB
connection db="sofia_reg_internal-ipv6";user="";pass="";thread="3070618512"
2010-02-22 08:47:42.701637 [DEBUG] switch_core_sqldb.c:111 Dropping idle DB
connection db="sofia_reg_external";user="";pass="";thread="3070372752"
2010-02-22 08:47:53.875324 [DEBUG] mod_nibblebill.c:529 Received request via
SESSION_HEARTBEAT!
2010-02-22 08:47:53.875324 [DEBUG] mod_nibblebill.c:397 Attempting to bill
at $1.0 per minute to account 3007
2010-02-22 08:47:53.875324 [DEBUG] mod_nibblebill.c:449 Last successful
billing time was 
2010-02-22 08:47:53.875324 [DEBUG] mod_nibblebill.c:455 30 seconds passed
since last bill time of 2010-02-22 08:47:23
2010-02-22 08:47:53.875324 [DEBUG] mod_nibblebill.c:461 Billing $0.502331 to
3007 (Call: 68cde83c-26f4-44e3-8060-4188a106ff51 / 0.474338 so far)
2010-02-22 08:48:23.995212 [DEBUG] mod_nibblebill.c:529 Received request via
SESSION_HEARTBEAT!
2010-02-22 08:48:23.995212 [DEBUG] mod_nibblebill.c:397 Attempting to bill
at $1.0 per minute to account 3007
2010-02-22 08:48:23.995212 [DEBUG] mod_nibblebill.c:449 Last successful
billing time was 
2010-02-22 08:48:23.995212 [DEBUG] mod_nibblebill.c:455 30 seconds passed
since last bill time of 2010-02-22 08:47:53
2010-02-22 08:48:23.995212 [DEBUG] mod_nibblebill.c:461 Billing $0.501998 to
3007 (Call: 68cde83c-26f4-44e3-8060-4188a106ff51 / 0.976670 so far)
2010-02-22 08:48:54.115099 [DEBUG] mod_nibblebill.c:529 Received request via
SESSION_HEARTBEAT!
2010-02-22 08:48:54.115099 [DEBUG] mod_nibblebill.c:397 Attempting to bill
at $1.0 per minute to account 3007
2010-02-22 08:48:54.115099 [DEBUG] mod_nibblebill.c:449 Last successful
billing time was 
2010-02-22 08:48:54.115099 [DEBUG] mod_nibblebill.c:455 30 seconds passed
since last bill time of 2010-02-22 08:48:23
2010-02-22 08:48:54.115099 [DEBUG] mod_nibblebill.c:461 Billing $0.501998 to
3007 (Call: 68cde83c-26f4-44e3-8060-4188a106ff51 / 1.478668 so far)
2010-02-22 08:49:12.271231 [NOTICE] sofia.c:329 Hangup
sofia/internal/3007 at 192.168.15.177 [CS_EXECUTE] [NORMAL_CLEARING]

Any help in regards of how to get nibblebill to access the database properly
would be great.  Again I have installed ODBC and created the accounts table
with the required fields.  Thanks a ton


-----
Todd who is to learn
-- 
View this message in context: http://n2.nabble.com/mod-nibblebill-tp4612298p4612298.html
Sent from the freeswitch-users mailing list archive at Nabble.com.