On Tue, Feb 26, 2013 at 11:14 PM, Ken Rice <krice@freeswitch.org> wrote:

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_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

_________________________________________________________________________
Professional FreeSWITCH Consulting Services:
consulting@freeswitch.org
http://www.freeswitchsolutions.com

FreeSWITCH-powered IP PBX: The CudaTel Communication Server
http://www.cudatel.com

Official FreeSWITCH Sites
http://www.freeswitch.org
http://wiki.freeswitch.org
http://www.cluecon.com

FreeSWITCH-users mailing list
FreeSWITCH-users@lists.freeswitch.org
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
http://www.freeswitch.org

--
Pozdrawiam
Tomasz