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@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@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@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@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@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@gmail.com<tomasz.szuster@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@freeswitch.org http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
FreeSWITCH-users mailing list FreeSWITCH-users@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