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. -- Regards. Tomasz