[Freeswitch-users] no table account in mod_nibblebill

[Aqs Younas]

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 onhttp://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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20140704/6a1b627d/attachment-0001.html