Hi I am getting the following error when giving load mod_lcr on the command line. ~~ 2012-04-11 20:10:56.346283 [ERR] switch_odbc.c:365 STATE: IM002 CODE 0 ERROR: [unixODBC][Driver Manager]Data source name not found, and no default driver specified 2012-04-11 20:10:56.346283 [CRIT] switch_core_sqldb.c:418 Failure! 2012-04-11 20:10:56.346283 [CRIT] mod_lcr.c:1018 Cannot Open ODBC Database! 2012-04-11 20:10:56.346283 [ERR] mod_lcr.c:2036 Unable to load lcr config file 2012-04-11 20:10:56.346283 [CRIT] switch_loadable_module.c:1290 Error Loading module /usr/local/freeswitch/mod/mod_lcr.so **Module load routine returned an error** ~~ I followed steps give on http://wiki.freeswitch.org/wiki/Using_ODBC_in_the_core I am on Ubuntu 10.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/lib64/odbc/libmyodbc.so SERVER = localhost PORT = 3306 DATABASE = freeswitch OPTION = 3 USER = root PASSWORD = password # cat /etc/odbcinst.ini [MySQL] Description = MySQL driver Driver = /usr/lib64/odbc/libmyodbc.so Setup = /usr/lib64/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="dsn:freeswitch:password" /> My conf/autoload_configs/lcr.conf.xml has the lines <settings> <param name="odbc-dsn" value="dsn:freeswitch:password"/> </settings> I shutdown and restarted freeswitch after doing all configurations. regards, Anita
participants (2)
-
Anita Hall
-
Serge S. Yuriev