Also, I didn¹t read the whole email earlier.. Spidermonkey odbc and nibblebill odbc are 2 different config settings... You need to check the wiki for the proper odbc dsn syntax and make sure the DSN you configured in your odbc.ini works from isql K On 2/26/13 4:00 PM, "Jason Moran" <jmoran@secureachsystems.com> wrote:
Can you make connections to your database using the ODBC connection outside of FreeSWITCH (but from the same server that FS is installed on)? I¹ve often caught problems either in my firewall or a dumb typo in my ODBC configurations.
From: Tomasz Szuster [mailto:tomasz.szuster@gmail.com] Sent: Tuesday, February 26, 2013 3:48 PM To: FreeSWITCH Users Help Subject: [Freeswitch-users] nibblebill, spidermonkey_odbc issue
Hi,
I'm struggling with making nibblebill working.
What I've did till now is:
Installed odbc:
* libmyodbc
* libodbc1
* odbcinst
* odbcinst1debian2
* unixodbc
* unixodbc-dev
compile freeswitch using
./configure --enable-core-odbc-support make; make install
My spidermonkey.conf file has:
<configuration name="spidermonkey.conf" description="Spider Monkey JavaScript Plug-Ins">
<modules>
<!-- <load module="mod_spidermonkey_teletone"/> -->
<load module="mod_spidermonkey_core_db"/>
<load module="mod_spidermonkey_socket"/>
<load module="mod_spidermonkey_odbc"/>
</modules>
</configuration>
My odbc.ini:
[nibblebill1]
Driver = /usr/lib/x86_64-linux-gnu/odbc/libmyodbc.so
SERVER = callcenter
PORT = 3306
DATABASE = nibblebill1
OPTION = 67108864
USER = nibblebill1
PASSWORD = XXXXXXX
ldd /usr/local/freeswitch/mod/mod_spidermonkey_odbc.so
linux-vdso.so.1 => (0x00007fffbd7ff000)
libfreeswitch.so.1 => /usr/local/freeswitch/lib/libfreeswitch.so.1 (0x00007f2f193ee000)
libjs.so.1 => /usr/local/freeswitch/lib/libjs.so.1 (0x00007f2f19120000)
libnspr4.so => /usr/local/freeswitch/lib/libnspr4.so (0x00007f2f18eef000)
libodbc.so.1 => /usr/lib/x86_64-linux-gnu/libodbc.so.1 (0x00007f2f18c82000)
libpthread.so.0 => /lib/x86_64-linux-gnu/libpthread.so.0 (0x00007f2f18a65000)
libc.so.6 => /lib/x86_64-linux-gnu/libc.so.6 (0x00007f2f186a5000)
libdl.so.2 => /lib/x86_64-linux-gnu/libdl.so.2 (0x00007f2f184a1000)
libcrypt.so.1 => /lib/x86_64-linux-gnu/libcrypt.so.1 (0x00007f2f18268000)
librt.so.1 => /lib/x86_64-linux-gnu/librt.so.1 (0x00007f2f1805f000)
libssl.so.1.0.0 => /lib/x86_64-linux-gnu/libssl.so.1.0.0 (0x00007f2f17e03000)
libcrypto.so.1.0.0 => /lib/x86_64-linux-gnu/libcrypto.so.1.0.0 (0x00007f2f17a3b000)
libtinfo.so.5 => /lib/x86_64-linux-gnu/libtinfo.so.5 (0x00007f2f17813000)
libstdc++.so.6 => /usr/lib/x86_64-linux-gnu/libstdc++.so.6 (0x00007f2f17513000)
libm.so.6 => /lib/x86_64-linux-gnu/libm.so.6 (0x00007f2f17217000)
libgcc_s.so.1 => /lib/x86_64-linux-gnu/libgcc_s.so.1 (0x00007f2f17000000)
libltdl.so.7 => /usr/lib/x86_64-linux-gnu/libltdl.so.7 (0x00007f2f16df6000)
/lib64/ld-linux-x86-64.so.2 (0x00007f2f19a48000)
libz.so.1 => /lib/x86_64-linux-gnu/libz.so.1 (0x00007f2f16bde000)
FreeSWITCH (Version 1.2.6 git a424765 2013-01-04 15:45:59Z)
When I try to run load mod_spidermonkey_odbc I get:
[CRIT] switch_loadable_module.c:1330 Error Loading module /usr/local/freeswitch/mod/mod_spidermonkey_odbc.so **/usr/local/freeswitch/mod/mod_spidermonkey_odbc.so: undefined symbol: mod_spidermonkey_odbc_module_interface**
load mod_nibblebill:
2013-02-26 21:46:40.116678 [ERR] switch_odbc.c:365 STATE: IM002 CODE 0 ERROR: [unixODBC][Driver Manager]Data source name not found, and no default driver specified
2013-02-26 21:46:40.116678 [CRIT] mod_nibblebill.c:220 Cannot connect to ODBC driver/database odbc://callcenter (user: nibblebill1 / pass XXXXX)!
2013-02-26 21:46:40.116678 [CONSOLE] switch_loadable_module.c:1348 Successfully Loaded [mod_nibblebill]
Also from time to time in logs I've see:
[ERR] switch_odbc.c:365 STATE: IM002 CODE 0 ERROR: [unixODBC][Driver Manager]Data source name not found, and no default driver specified
Will you be able to help with this issue ?
Thank you.
-- Ken http://www.FreeSWITCH.org http://www.ClueCon.com http://www.OSTAG.org irc.freenode.net #freeswitch