[Freeswitch-users] [CRIT] mod_nibblebill.c:558 Failed to log to database!

[mrajib321 at yahoo.com]

Hi,
 Is anyone running or tested mod_nibblebill on the latest release of FreeSWITCH 1.2.10. A simple internal profile call between two SIP clients completes successfully but fails to debit the balance. I have the following configuration settings

Dialplan configuration
<action application="set" data="nibble_rate=0.20"/>
<action application="set" data="$${nibble_account}"/>

User directory configuration
<variable name="nibble_account" value="1"/>

Nibblebill module configuration 

<param name="odbc_dsn" value="odbc://freeswitch:freeswitch:freeswitchrw"/>
<param name="db_table" value="accounts"/>
<param name="db_column_cash" value="cash"/>
<param name="db_column_account" value="id"/>


ODBC driver has been tested sucessfully with mySQL using isql command.

Running FreeSWITCH 1.2.10 on Linux machine
FreeSWITCH Version 1.2.10+git~20130625T154058Z~30be15fd52

Any pointers on how to fix the error would be appreciated. Thanks.


I received the following errors:

2013-06-28 14:24:49.488199 [ERR] mod_nibblebill.c:403 Error
running this query: [SELECT cash AS nibble_balance FROM accounts WHERE
account_code='1']
2013-06-28 14:24:49.488199 [INFO] mod_dialplan_xml.c:558
Processing 1600 <1600>->1601 in context default
2013-06-28 14:24:49.488199 [ERR]mod_dptools.c:1351
No variable name specified.
2013-06-28 14:24:49.508248 [NOTICE] switch_channel.c:1030
New Channel sofia/internal/sip:1601 at 192.168.104.191:5073
[e0a7b224-c48e-449d-b8ca-280ea016af07]
2013-06-28 14:24:49.528204 [NOTICE] sofia.c:6443 Channel
[sofia/internal/sip:1601 at 192.168.104.191:5073] has been answered
2013-06-28 14:24:49.528204 [NOTICE] sofia_glue.c:4291
Pre-Answer sofia/internal/1600 at 192.168.104.191!
2013-06-28 14:24:49.528204 [NOTICE] switch_ivr_originate.c:3427
Channel [sofia/internal/1600 at 192.168.104.191] has been answered
2013-06-28 14:24:54.568203 [NOTICE] sofia.c:716 Hangup
sofia/internal/1600 at 192.168.104.191 [CS_EXECUTE] [NORMAL_CLEARING]
2013-06-28 14:24:54.588237 [NOTICE] switch_ivr_bridge.c:721
Hangup sofia/internal/sip:1601 at 192.168.104.191:5073 [CS_EXCHANGE_MEDIA]
[NORMAL_CLEARING]
2013-06-28 14:24:54.588237 [ERR] mod_nibblebill.c:403 Error
running this query: [SELECT cash AS nibble_balance FROM accounts WHERE
account_code='2']
2013-06-28 14:24:54.588237 [ERR]mod_nibblebill.c:403
Error running this query: [SELECT cash AS nibble_balance FROM accounts WHERE
account_code='2']
2013-06-28 14:24:54.588237 [INFO] mod_nibblebill.c:521
Beginning new billing on 51157e70-fb95-4c90-91f6-3575f097fe00
2013-06-28 14:24:54.588237 [CRIT]mod_nibblebill.c:558
Failed to log to database!
2013-06-28 14:24:54.588237 [ERR]mod_nibblebill.c:403
Error running this query: [SELECT cash AS nibble_balance FROM accounts WHERE
account_code='1']
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20130629/a040c4df/attachment-0001.html