[Freeswitch-users] Nibblebill database update

[Evgeniy Movlyan]

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
>>>
>>
>
>

-- 
Evgeniy Movlyan,
BestNet Ltd.