[Freeswitch-users] mod_nibblebill errors [ERR] switch_core_sqldb.c:1126 SQL ERR:

[mrajib321 at yahoo.com]

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 at 192.168.1.120 to XML[hangup at 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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20130627/74172d2d/attachment.html