Hi<br><br>I am getting the following error when giving load mod_lcr on the command line. <br><br>~~<br>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<br>
2012-04-11 20:10:56.346283 [CRIT] switch_core_sqldb.c:418 Failure!<br>2012-04-11 20:10:56.346283 [CRIT] mod_lcr.c:1018 Cannot Open ODBC Database!<br>2012-04-11 20:10:56.346283 [ERR] mod_lcr.c:2036 Unable to load lcr config file<br>
2012-04-11 20:10:56.346283 [CRIT] switch_loadable_module.c:1290 Error Loading module /usr/local/freeswitch/mod/mod_lcr.so<br>**Module load routine returned an error**<br>~~<br><br>I followed steps give on <br><a href="http://wiki.freeswitch.org/wiki/Using_ODBC_in_the_core">http://wiki.freeswitch.org/wiki/Using_ODBC_in_the_core</a><br>
<br>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. <br>
<br>I configured the ini files and my odbc works with MySQL<br><br># cat /etc/odbc.ini <br>[freeswitch]<br>Driver = /usr/lib64/odbc/libmyodbc.so<br>SERVER = localhost<br>PORT = 3306<br>DATABASE = freeswitch<br>
OPTION = 3<br>USER = root<br>PASSWORD = password<br><br># cat /etc/odbcinst.ini <br>[MySQL]<br>Description = MySQL driver<br>Driver = /usr/lib64/odbc/libmyodbc.so<br>Setup = /usr/lib64/odbc/libodbcmyS.so<br>
UsageCount = 1<br>FileUsage = 1<br>Threading = 0<br><br><br><br># isql -v freeswitch<br>+---------------------------------------+<br>| Connected! |<br>| |<br>
| sql-statement |<br>| help [tablename] |<br>| quit |<br>| |<br>+---------------------------------------+<br>SQL> <br>
<br>My conf/autoload_configs/switch.conf.xml has the line<br><br><param name="core-db-dsn" value="dsn:freeswitch:password" /><br><br><br>My conf/autoload_configs/lcr.conf.xml has the lines<br><br>
<settings><br> <param name="odbc-dsn" value="dsn:freeswitch:password"/><br></settings><br><br><br>I shutdown and restarted freeswitch after doing all configurations. <br><br><br><br>
<br><br clear="all">regards,<br>Anita<br><br>