[Freeswitch-users] Nibblebill database update

[Evgeniy Movlyan]

Hello.
Show please your nibblebill.conf.xml.

01.11.2012 05:57, William Alianto пишет:
> Hi,
>
> I was trying to use nibblebill as billing control of my FS. I have
> configured the odbc and the nibblebill configuration. When I tried to
> call, the query looks ok. But when I hanged up the call, it seems like
> there is something wrong with the database connection, since it's not
> updating the database at all. I got error message on CLI
>
> 2012-11-01 10:51:00.559472 [ERR] switch_odbc.c:494 ERR: [UPDATE accounts
> SET usage=usage-0.476000 WHERE user='1001']
> [STATE: 42000 CODE 1064 ERROR: [unixODBC][MySQL][ODBC 5.1
> Driver][mysqld-5.5.24-0ubuntu0.12.04.1]You have an error in your SQL
> syntax; check the manual that corresponds to your MySQL server version
> for the right syntax to use near 'usage=usage-0.476000 WHERE
> user='1001'' at line 1
> ]
> 2012-11-01 10:51:00.559472 [ERR] mod_nibblebill.c:343 ERR: [UPDATE
> accounts SET usage=usage-0.476000 WHERE user='1001']
> []
> 2012-11-01 10:51:00.559472 [CRIT] mod_nibblebill.c:542 Failed to log to
> database!
> 2012-11-01 10:51:00.559472 [DEBUG] mod_nibblebill.c:383 Doing lookup query
> [SELECT usage AS nibble_balance FROM accounts WHERE user='1001']
> 2012-11-01 10:51:00.559472 [ERR] mod_nibblebill.c:385 ERR: [SELECT usage
> AS nibble_balance FROM accounts WHERE user='1001']
> [STATE: 42000 CODE 1064 ERROR: [unixODBC][MySQL][ODBC 5.1
> Driver][mysqld-5.5.24-0ubuntu0.12.04.1]You have an error in your SQL
> syntax; check the manual that corresponds to your MySQL server version
> for the right syntax to use near 'usage AS nibble_balance FROM accounts
> WHERE user='1001'' at line 1
> ]
> 2012-11-01 10:51:00.559472 [ERR] mod_nibblebill.c:386 Error running this
> query: [SELECT usage AS nibble_balance FROM accounts WHERE user='1001']
>
> Could anybody help me solve this issue?
>
> Regards
>
> _________________________________________________________________________
> 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
>

-- 
Evgeniy Movlyan,
BestNet Ltd.