[Freeswitch-users] load mod_lcr error

[Anita Hall]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20120411/2fd24e12/attachment.html