[Freeswitch-users] Nibblebill database update

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