[Freeswitch-users] SQL connection problem with mod_nibblebil

[Dmitry Erankevich]

Dear all.

I'm testing mod_nibblebill and it looks like the mod can't connect to 
the mysql db:

reload mod_nibblebill
+OK Reloading XML
+OK module unloaded
+OK module loaded

2014-05-29 05:35:05.627682 [INFO] mod_enum.c:876 ENUM Reloaded
2014-05-29 05:35:05.627682 [INFO] switch_time.c:1191 Timezone reloaded 
530 definitions
2014-05-29 05:35:05.627682 [NOTICE] switch_loadable_module.c:978 
Deleting Application 'nibblebill'
2014-05-29 05:35:05.627682 [NOTICE] switch_loadable_module.c:1033 
Deleting API Function 'nibblebill'
2014-05-29 05:35:05.627682 [CONSOLE] switch_loadable_module.c:1876 
Stopping: mod_nibblebill
2014-05-29 05:35:05.627682 [NOTICE] switch_event.c:2073 Event Binding 
deleted for mod_nibblebill:SESSION_HEARTBEAT
2014-05-29 05:35:05.627682 [CONSOLE] switch_loadable_module.c:1896 
mod_nibblebill unloaded.
2014-05-29 05:35:05.627682 [INFO] mod_nibblebill.c:222 odbc_dsn is 
freeswitch
2014-05-29 05:35:05.627682 [CONSOLE] switch_loadable_module.c:1409 
Successfully Loaded [mod_nibblebill]
2014-05-29 05:35:05.627682 [NOTICE] switch_loadable_module.c:267 Adding 
Application 'nibblebill'
2014-05-29 05:35:05.627682 [NOTICE] switch_loadable_module.c:313 Adding 
API Function 'nibblebill'

Trying to make call:

2014-05-29 05:38:20.606838 [ERR] switch_core_sqldb.c:1131 SQL ERR: 
[SELECT cash AS nibble_balance FROM accounts WHERE id='12'] no such 
table: accounts
2014-05-29 05:38:20.606838 [ERR] mod_nibblebill.c:420 Error running 
this query: [SELECT cash AS nibble_balance FROM accounts WHERE id='12']

But:

[root at localhost default]# isql freeswitch
+---------------------------------------+
| Connected! |
| |
| sql-statement |
| help [tablename] |
| quit |
| |
+---------------------------------------+
SQL> SELECT cash AS nibble_balance FROM accounts WHERE id='12'
+-------------------------+
| nibble_balance |
+-------------------------+
| 5 |
+-------------------------+
SQLRowCount returns 1
1 rows fetched


FreeSWITCH Version 1.2.24+git~20140528T155016Z~e19860eef4~64bit (git 
e19860e 2014-05-28 15:50:16Z 64bit)


I've already tried different parameters for DB connection in 
nibblebill.conf.xml (odbc-dsn, db-dsn, etc.) with no success.

Would be appreciated for any help.

Dmitry.