[Freeswitch-users] Nibblebill database update

[William Alianto]

Thanks for pointing that out. I think I missed that part when I edited 
the config.

On 11/02/2012 02:22 PM, Evgeniy Movlyan wrote:
> Seems you need to uncomment custom SQL-queries and rewrite it to 
> according to your needs.
>
> 02.11.2012 05:54, William Alianto пишет:
>> Hi,
>>
>> This is my nibblebill.conf.xml
>>
>> <configuration name="nibblebill.conf" description="Nibble Billing">
>> <settings>
>> <!-- See http://wiki.freeswitch.org/wiki/Mod_nibblebill for help with
>> these options -->
>>
>> <!-- Information for connecting to your database -->
>> <param name="db_username" value="root"/>
>> <param name="db_password" value="xxxxxxxx"/>
>> <param name="db_dsn" value="billing"/>
>>
>> <!-- The database table where your CASH column is located -->
>> <param name="db_table" value="accounts"/>
>>
>> <!-- The column name where we store the value of the account -->
>> <param name="db_column_cash" value="usage"/>
>>
>> <!-- The column name for the unique ID identifying the account -->
>> <param name="db_column_account" value="user"/>
>>
>> <!-- Custom SQL for loading current balance - overrides column names
>> channel vars are interpreted.
>> field nibble_balance is used for balance info
>>
>> <param name="custom_sql_lookup" value="SELECT cash AS nibble_balance
>> FROM accounts WHERE account_code='${nibble_account}'"/>
>> -->
>>
>> <!-- Custom SQL for loading current balance - overrides column names
>> channel vars are interpreted.
>> nibble_increment is the amount to update
>>
>> <param name="custom_sql_save" value="UPDATE accounts SET
>> cash=cash-${nibble_increment} WHERE account_code='${nibble_account}'"/>
>> -->
>>
>>
>> <!-- Default heartbeat interval. Set to 'off' for no heartbeat (i.e.
>> bill only at end of call) -->
>> <param name="global_heartbeat" value="1"/>
>>
>> <!-- By default, warn a caller when their balance is at $5.00. You can
>> set this to a negative number. -->
>> <!--<param name="lowbal_amt" value="5"/>-->
>> <!--<param name="lowbal_action" value="play ding"/>-->
>>
>> <!-- By default, terminate a caller when their balance hits $0.00. You
>> can set this to a negative number. -->
>> <!--<param name="nobal_amt" value="0"/>
>> <param name="nobal_action" value="hangup"/>-->
>>
>> <!-- If a call goes beyond a certain dollar amount, flag or terminate it
>> -->
>> <!--<param name="percall_max_amt" value="100"/>
>> <param name="percall_action" value="hangup"/>-->
>>
>> </settings>
>> </configuration>
>>
>>
>> On 11/01/2012 02:56 PM, Evgeniy Movlyan wrote:
>>> 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=age-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=age-0.476000 WHERE
>>>> user=001'' at line 1
>>>> ]
>>>> 2012-11-01 10:51:00.559472 [ERR] mod_nibblebill.c:343 ERR: [UPDATE
>>>> accounts SET usage=age-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=001']
>>>> 2012-11-01 10:51:00.559472 [ERR] mod_nibblebill.c:385 ERR: [SELECT 
>>>> usage
>>>> AS nibble_balance FROM accounts WHERE user=001']
>>>> [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=001'' 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=001']
>>>>
>>>> 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
>>>>
>>>
>>
>>
>