[Freeswitch-users] nibblebill, spidermonkey_odbc issue

[Tomasz Szuster]

Thank you all for fast reply.

In nibblebill.xml I've changed

*<param name="db_dsn" value="odbc://nibblebill1"/>*

to

*<param name="db_dsn" value="nibblebill1"/>*

and now it is working.

Thank you for all advices.

Regards.
Tom.


On Tue, Feb 26, 2013 at 11:14 PM, Ken Rice <krice at 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 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<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
>
> _________________________________________________________________________
> Professional FreeSWITCH Consulting Services:
> consulting at freeswitch.org
> http://www.freeswitchsolutions.com
>
> 
> 
>
> Official FreeSWITCH Sites
> http://www.freeswitch.org
> http://wiki.freeswitch.org
> http://www.cluecon.com
>
> FreeSWITCH-users mailing list
> FreeSWITCH-users at 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20130227/328172d4/attachment-0001.html