Hi All

I have a problem with connecting to a database from LUA using ODBC. I have noticed that when my freeswitch starts it doesn't load the spider monkey module. I did the following:

Installed Freeswitch using debian repository from "deb http://files.freeswitch.org/repo/deb/debian/ squeeze main". I installed the package freeswitch-meta-vanilla and freeswitch-spidermonkey
I copied the vanilla configuration from /usr/share/freeswitch/conf/vanilla/* to /etc/freeswitch folder
I configured MySQL DB ODBC as described in http://wiki.freeswitch.org/wiki/Using_ODBC_in_the_core and tested it through isql command and it connected fine
I started my freeswitch as root using the command /usr/bin/freeswitch and I got the below error
2013-05-07 22:19:33.922678 [CRIT] switch_loadable_module.c:1330 Error Loading module /usr/lib/freeswitch/mod/mod_spidermonkey.so
**/usr/lib/freeswitch/mod/mod_spidermonkey.so: cannot open shared object file: No such file or directory**

I didn't see the file mod_spidermonkey.so in my /usr/lib/freeswitch folder but in /opt/freeswitch/mod folder. So I added a symbolic link from /opt/freeswitch/mod to /usr/lib/freeswitch/mod for below files:
      mod_spidermonkey_core_db.so
      mod_spidermonkey_odbc.so 
      mod_spidermonkey_socket.so
      mod_spidermonkey_curl.so
      mod_spidermonkey.so
      mod_spidermonkey_teletone.so

Then I started freeswitch again and received the error below:
2013-05-07 22:30:25.813120 [CRIT] switch_loadable_module.c:1330 Error Loading module /usr/lib/freeswitch/mod/mod_spidermonkey.so
**/usr/lib/freeswitch/mod/mod_spidermonkey.so: undefined symbol: switch_core_session_locate**

Also when I try to execute a LUA script with the code freeswitch.Dbh("odbc://freeswitch") in a LUA file then I got the error

2013-05-07 23:05:46.915209 [ERR] switch_odbc.c:365 STATE: IM002 CODE 0 ERROR: [unixODBC][Driver Manager]Data source name not found, and no default driver specified
2013-05-07 23:05:46.915209 [CRIT] switch_core_sqldb.c:504 Failure to connect to PGSQL odbc://freeswitch!

Any ideas what I am doing wrong? FYI - I am running on UBuntu

Help will be appreciated.

Regards
Asif