[Freeswitch-users] load error mod_nibblebill

Aqs Younas aqsyounas at gmail.com
Fri Jul 4 15:07:32 MSD 2014


Hi

I am getting the following error when giving load mod_lcr on the command
line.

~~
2014-07-04 06:55:57.829089 [INFO] mod_enum.c:880 ENUM Reloaded
2014-07-04 06:55:57.829089 [INFO] mod_nibblebill.c:222 odbc_dsn is
mysql://hostaddr=127.0.0.1 dbname=tcapi user=root password=hammer
2014-07-04 06:55:57.829089 [DEBUG] mod_nibblebill.c:282 dsn is
"mysql://hostaddr=127.0.0.1 dbname=tcapi user=root password=hammer"
2014-07-04 06:55:57.829089 [INFO] switch_time.c:1369 Timezone reloaded
530 definitions
2014-07-04 06:55:57.829089 [ERR] switch_odbc.c:365 STATE: IM002 CODE 0
ERROR: [unixODBC][Driver Manager]Data source name not found, and no
default driver specified

2014-07-04 06:55:57.829089 [CRIT] switch_core_sqldb.c:507 Failure to
connect to ODBC mysql!
2014-07-04 06:55:57.829089 [CRIT] mod_nibblebill.c:287 Cannot Open
ODBC Database!
2014-07-04 06:55:57.829089 [CONSOLE] switch_loadable_module.c:1466
Successfully Loaded [mod_nibblebill]
2014-07-04 06:55:57.829089 [NOTICE] switch_loadable_module.c:269
Adding Application 'nibblebill'
2014-07-04 06:55:57.829089 [NOTICE] switch_loadable_module.c:315
Adding API Function 'nibblebill'
~~

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/switch.conf.xml has the line

<param name="core-db-dsn" value="mysql://hostaddr=127.0.0.1
dbname=tcapi user=root password='password' options='-c
client_min_messages=NOTICE' application_name='freeswitch'" />
    <param name="core-db-dsn" value="dsn:tcapi:password" />


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

<settings>
   param name="odbc-dsn" value="mysql://hostaddr=127.0.0.1
dbname=tcapi user=root password=hammer"/>

    <!-- The database table where your CASH column is located -->
    <param name="db_table" value="accounts"/>

    <!-- The column name where we store the value of the account -->
    <param name="db_column_cash" value="cash"/>

    <!-- The column name for the unique ID identifying the account -->
    <param name="db_column_account" value="name"/>

</settings>


Can anybody please tell me where i am doing something wrong.

Thanks
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20140704/cca80f3f/attachment.html 


Join us at ClueCon 2016 Aug 8-12, 2016
More information about the FreeSWITCH-users mailing list