Hi I am getting the following error when giving load mod_nibblebill 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
participants (1)
-
Aqs Younas