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@freeswitch.org http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
FreeSWITCH-users mailing list FreeSWITCH-users@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.