[Freeswitch-users] nibblebill, spidermonkey_odbc issue

Sun Mar 10 21:07:43 MSK 2013

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20130310/771e61eb/attachment-0001.html 