[Freeswitch-users] no table account in mod_nibblebill

[Steven Ayre]

Use odbc://freeswitch as the dsn, the syntax you're using is a sqlite
filename.


On 4 July 2014 14:00, Aqs Younas <aqsyounas at gmail.com> wrote:

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