mod_nibblebill errors [ERR] switch_core_sqldb.c:1126 SQL ERR:
Hi, I have installed, compiled and loaded mod_nibblebill sucessfully but when I tried to test it with some data using MySQL I received the following error ============================================================ 2013-06-27 21:57:23.892791 [ERR] mod_nibblebill.c:403 Error running this query: [SELECT cash AS nibble_balance FROM accounts WHERE id='2'] 2013-06-27 21:57:23.892791 [NOTICE] switch_ivr.c:1822 Transfer sofia/internal/1201@192.168.1.120 to XML[hangup@default] 2013-06-27 21:57:23.892791 [ERR] mod_nibblebill.c:403 Error running this query: [SELECT cash AS nibble_balance FROM accounts WHERE id='2'] I have added two variables, "nibble_rate" and "nibble_account", to the user's directory entry for simple testing. User 1 <variable name="nibble_rate" value="0.10"/> <variable name="nibble_account" value="1"/> User 2 <variable name="nibble_rate" value="0.15"/> <variable name="nibble_account" value="2"/> ODBC connection to MySQL database works fine. I tested it using " isql -v freeswitch". I can connect and display the tables and all that. The settings in the nibblebill.conf.xml file are: <param name="odbc_dsn" value="odbc://freeswitch:freeswitch:freeswitchrw"/> <param name="db_table" value="accounts"/> <param name="db_column_cash" value="cash"/> <param name="db_column_account" value="id"/> Database name: freeswitch username: freeswitch pswd: freeswitchrw The database data is the following mysql> use freeswitch; Database changed mysql> select * from accounts; +----+----------------+------+ | id | name | cash | +----+----------------+------+ | 1 | x-lite-win | 20 | | 2 | linphone-linux | 30 | +----+----------------+------+ I am running freeswitch version 1.2.10 git 30be15f on a Linux Mint 14 machine. Any help as to what the error means or how to fix it would be appreciated. Thanks.
participants (1)
-
mrajib321@yahoo.com