[Freeswitch-users] nibblebill, spidermonkey_odbc issue

Sun Mar 10 14:51:30 MSK 2013

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