Hi
I am getting the following error after call is hangup on the command line.


~~
2014-07-04 08:36:50.428532 [DEBUG] mod_nibblebill.c:488 Attempting to bill at $0.03 per minute to account 1010
2014-07-04 08:36:50.428532 [INFO] mod_nibblebill.c:540 Beginning new billing on d71d9966-0377-11e4-a114-2972d0b41bbc
2014-07-04 08:36:50.428532 [DEBUG] mod_nibblebill.c:546 13 seconds passed since last bill time of 2014-07-04 08:36:37
2014-07-04 08:36:50.428532 [DEBUG] mod_nibblebill.c:563 Billing $0.006550 to 1010 (Call: d71d9966-0377-11e4-a114-2972d0b41bbc / 0.000000 so far)
2014-07-04 08:36:50.428532 [DEBUG] mod_nibblebill.c:393 Doing update query
[UPDATE accounts SET cash=cash-0.006550 WHERE name='1010']
2014-07-04 08:36:50.428532 [ERR] switch_core_sqldb.c:586 NATIVE SQL ERR [no such table: accounts]
UPDATE accounts SET cash=cash-0.006550 WHERE name='1010'
2014-07-04 08:36:50.428532 [CRIT] mod_nibblebill.c:577 Failed to log to database!
2014-07-04 08:36:50.428532 [DEBUG] mod_nibblebill.c:420 Doing lookup query
[SELECT cash AS nibble_balance FROM accounts WHERE name='1010']
2014-07-04 08:36:50.428532 [ERR] switch_core_sqldb.c:1196 SQL ERR: [SELECT cash AS nibble_balance FROM accounts WHERE name='1010'] no such table: accounts
2014-07-04 08:36:50.428532 [ERR] mod_nibblebill.c:422 Error running this query: [SELECT cash AS nibble_balance FROM accounts WHERE name='1010']

~~

I followed steps give on
http://wiki.freeswitch.org/wiki/Using_ODBC_in_the_core

I am on Ubuntu 14.04 LTS and I installed unixodbc, unixodbc-dev, libmyodbc
packages by using apt-get. Then I did ./configure
--enable-core-odbc-support , make, make install on freeswitch and the
config.log shows that unixodbc got recognized and compiled.

I configured the ini files and my odbc works with MySQL

# cat /etc/odbc.ini
[freeswitch]
Driver          = /usr/lib/i386-linux-gnu/odbc/libmyodbc.so
SERVER          = localhost
PORT            = 3306
DATABASE        = tcapi
OPTION          = 67108864
USER            = root
PASSWORD        = password

# cat /etc/odbcinst.ini
[MySQL]
Description     = MySQL driver
Driver          = /usr/lib/i386-linux-gnu/odbc/libmyodbc.so
Setup           = /usr/lib/i386-linux-gnu/odbc/libodbcmyS.so
UsageCount      = 1
FileUsage       = 1
Threading       = 0








# isql -v freeswitch
+---------------------------------------+
| Connected!                        |
|                                         |
| sql-statement                    |
| help [tablename]                |
| quit                                   |
|                                         |
+---------------------------------------+
SQL>

My conf/autoload_configs/nibblebill.conf.xml has the lines

<settings>
   param name="odbc-dsn" value="freeswitch"/>
   <param name="db_table" value="accounts"/>
   <param name="db_column_cash" value="cash"/>

   <param name="db_column_account" value="name"/>
</settings>

Mysql database structure.

mysql> use tcapi;
Database changed
mysql> desc accounts;
+-------+--------------+------+-----+---------+-------+

| Field | Type         | Null | Key | Default | Extra |
+-------+--------------+------+-----+---------+-------+
| id    | int(11)      | NO   | PRI | NULL    |       |
| name  | varchar(255) | YES  |     | NULL    |       |

| cash  | double       | NO   |     | NULL    |       |
+-------+--------------+------+-----+---------+-------+
3 rows in set (0.01 sec)

mysql> select * from accounts;
+------+------+------------+
| id   | name | cash       |

+------+------+------------+
|    0 | 1000 |       7777 |
| 1010 | 1010 | 8887.98792 |
+------+------+------------+
2 rows in set (0.00 sec)

Though the table exit.But freeswitch is unable to find it. 

Any help in this regard would be much appreciated.

Thanks