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

[Steven Ayre]

Try connecting to the DB at the commandline via that DSN:

> isql freeswitch:freeswitch:freeswitchrw

And run the failing query:
SELECT cash AS nibble_balance FROM accounts WHERE account_code='2';

to see what the error is.

-Steve





On 29 June 2013 17:58, <mrajib321 at yahoo.com> wrote:

> 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']
>
> _________________________________________________________________________
> Professional FreeSWITCH Consulting Services:
> consulting at freeswitch.org
> http://www.freeswitchsolutions.com
>
> 
> 
>
> Official FreeSWITCH Sites
> http://www.freeswitch.org
> http://wiki.freeswitch.org
> http://www.cluecon.com
>
> FreeSWITCH-users mailing list
> FreeSWITCH-users at lists.freeswitch.org
> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
> http://www.freeswitch.org
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20130629/35455861/attachment.html