[Freeswitch-users] nibblebill, spidermonkey_odbc issue

[Ken Rice]

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

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