[Freeswitch-users] nibblebill, spidermonkey_odbc issue

Tomasz Szuster tomasz.szuster at gmail.com
Sun Mar 10 22:50:20 MSK 2013


Resolved

<param name="*odbc-dsn*" value="odbc://datasourcename:username:password"/>

is working.

regards.
Tom

On Sun, Mar 10, 2013 at 7:07 PM, Tomasz Szuster <tomasz.szuster at gmail.com>wrote:

> Hello.
>
> Quick question is there any way to set DSN-less connection to the
> nibblebill database.
>
> For core-db there is entry in wiki:
>
> DSN-less
>
> DSN-less connections are also possible. Such connections don't require
> setting up in odbc.ini.
>
> Essentially the syntax is the same options you would have in odbc.ini
> name-value pairs, separated by ;
>
> MyODBC example (OPTION=67108864 enables batched statements):
>
>
> <param name="core-db-dsn" value="odbc://DRIVER=mysql;SERVER=a.b.c.d;UID=username;PWD=secretpassword;DATABASE=freeswitch;OPTION=67108864">
>
> I've tried to set this in nibblebill.conf.xml replacing core-db-dsn
> to db_dsn and later to odbc_dsn including variable to my username,
> password, server name but without luck.
>
> Regards.
>
> On Sun, Mar 10, 2013 at 12:51 PM, Tomasz Szuster <tomasz.szuster at gmail.com
> > wrote:
>
>> Hello,
>>
>> After upgrading to freeswitch ver 1.2.7 nibblebill has stopped working.
>>
>> In logs I don't see any signpost where to look after configuration error,
>> I get only this:
>>
>> [SELECT cash AS nibble_balance FROM accounts WHERE id='1']
>> 2013-03-10 12:48:16.528612 [ERR] mod_nibblebill.c:380 Error running this
>> query: [SELECT cash AS nibble_balance FROM accounts WHERE id='1']
>>
>> Can you please advice me how to precise diagnose this issue, where to
>> look ?
>>
>> Regards.
>> Tom.
>>
>> On Wed, Feb 27, 2013 at 7:08 PM, Tomasz Szuster <tomasz.szuster at gmail.com
>> > wrote:
>>
>>> 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
>>>
>>
>>
>>
>> --
>> Pozdrawiam
>> Tomasz
>>
>
>
>
> --
> Pozdrawiam
> Tomasz
>



-- 
Pozdrawiam
Tomasz
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20130310/ff6c2e25/attachment-0001.html 


Join us at ClueCon 2011 Aug 9-11, 2011
More information about the FreeSWITCH-users mailing list