[Freeswitch-users] nibblebill, spidermonkey_odbc issue

[Ken Rice]

You don¹t load mod_spidermoney_odbc
You uncomment it in autoload_configs/spidermonkey.conf.xml

Mod_spidermonkey loads that module... Mod_spidermonkey is probably the only
module that can actually load its own extension modules


On 2/26/13 2:48 PM, "Tomasz Szuster" <tomasz.szuster at gmail.com> wrote:

> 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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20130226/e4279a01/attachment.html