Thank you all for fast reply.<div><br></div><div>In nibblebill.xml I've changed</div><div><br></div><div><b><param name="db_dsn" value="odbc://nibblebill1"/></b></div><div><br></div><div>to </div>
<div><br></div><div><b><param name="db_dsn" value="nibblebill1"/></b></div><div><br></div><div>and now it is working.</div><div><br></div><div>Thank you for all advices.</div><div><br></div><div>
Regards.</div><div>Tom.</div><div><br><br><div class="gmail_quote">On Tue, Feb 26, 2013 at 11:14 PM, Ken Rice <span dir="ltr"><<a href="mailto:krice@freeswitch.org" target="_blank">krice@freeswitch.org</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div>
<font face="Monaco, Courier New"><span style="font-size:11pt">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<span class="HOEnZb"><font color="#888888"><br>
<br>
K</font></span><div><div class="h5"><br>
<br>
<br>
On 2/26/13 4:00 PM, "Jason Moran" <<a href="http://jmoran@secureachsystems.com" target="_blank">jmoran@secureachsystems.com</a>> wrote:<br>
<br>
</div></div></span></font><div><div class="h5"><blockquote><span style="font-size:11pt"><font color="#1F497D"><font face="Calibri, Verdana, Helvetica, Arial">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.<br>
<br>
</font></font><font face="Monaco, Courier New"><br>
</font></span><font><font face="Tahoma, Verdana, Helvetica, Arial"><span style="font-size:10pt"><b>From:</b> Tomasz Szuster [<a href="mailto:tomasz.szuster@gmail.com" target="_blank">mailto:tomasz.szuster@gmail.com</a>] <br>
<b>Sent:</b> Tuesday, February 26, 2013 3:48 PM<br>
<b>To:</b> FreeSWITCH Users Help<br>
<b>Subject:</b> [Freeswitch-users] nibblebill, spidermonkey_odbc issue<br>
</span></font></font><font face="Times New Roman"><span style="font-size:12pt"> <br>
Hi,<br>
</span></font><font face="Monaco, Courier New"><span style="font-size:11pt"><br>
</span></font><font face="Times New Roman"><span style="font-size:12pt"> <br>
</span></font><font face="Monaco, Courier New"><span style="font-size:11pt"><br>
</span></font><font face="Times New Roman"><span style="font-size:12pt">I'm struggling with making nibblebill working.<br>
</span></font><font face="Monaco, Courier New"><span style="font-size:11pt"><br>
</span></font><font face="Times New Roman"><span style="font-size:12pt">What I've did till now is:<br>
</span></font><font face="Monaco, Courier New"><span style="font-size:11pt"><br>
</span></font><font face="Times New Roman"><span style="font-size:12pt"> <br>
</span></font><font face="Monaco, Courier New"><span style="font-size:11pt"><br>
</span></font><font face="Times New Roman"><span style="font-size:12pt">Installed odbc:<br>
</span></font><font face="Monaco, Courier New"><span style="font-size:11pt"><br>
</span></font><font face="Times New Roman"><span style="font-size:12pt">* libmyodbc<br>
</span></font><font face="Monaco, Courier New"><span style="font-size:11pt"><br>
</span></font><font face="Times New Roman"><span style="font-size:12pt">* libodbc1<br>
</span></font><font face="Monaco, Courier New"><span style="font-size:11pt"><br>
</span></font><font face="Times New Roman"><span style="font-size:12pt">* odbcinst<br>
</span></font><font face="Monaco, Courier New"><span style="font-size:11pt"><br>
</span></font><font face="Times New Roman"><span style="font-size:12pt">* odbcinst1debian2<br>
</span></font><font face="Monaco, Courier New"><span style="font-size:11pt"><br>
</span></font><font face="Times New Roman"><span style="font-size:12pt">* unixodbc<br>
</span></font><font face="Monaco, Courier New"><span style="font-size:11pt"><br>
</span></font><font face="Times New Roman"><span style="font-size:12pt">* unixodbc-dev<br>
</span></font><font face="Monaco, Courier New"><span style="font-size:11pt"><br>
</span></font><font face="Times New Roman"><span style="font-size:12pt"> <br>
</span></font><font face="Monaco, Courier New"><span style="font-size:11pt"><br>
</span></font><font face="Times New Roman"><span style="font-size:12pt">compile freeswitch using<br>
</span></font><font face="Monaco, Courier New"><span style="font-size:11pt"><br>
</span></font><font face="Times New Roman"><span style="font-size:12pt"> <br>
</span></font><font face="Monaco, Courier New"><span style="font-size:11pt"><br>
<br>
<br>
./configure --enable-core-odbc-support<br>
make; make install<br>
</span></font><font face="Times New Roman"><span style="font-size:12pt"> <br>
</span></font><font face="Monaco, Courier New"><span style="font-size:11pt"><br>
</span></font><font face="Times New Roman"><span style="font-size:12pt">My spidermonkey.conf file has:<br>
</span></font><font face="Monaco, Courier New"><span style="font-size:11pt"><br>
</span></font><font face="Times New Roman"><span style="font-size:12pt"> <br>
</span></font><font face="Monaco, Courier New"><span style="font-size:11pt"><br>
</span></font><font face="Times New Roman"><span style="font-size:12pt"><configuration name="spidermonkey.conf" description="Spider Monkey JavaScript Plug-Ins"><br>
</span></font><font face="Monaco, Courier New"><span style="font-size:11pt"><br>
</span></font><font face="Times New Roman"><span style="font-size:12pt"> <modules><br>
</span></font><font face="Monaco, Courier New"><span style="font-size:11pt"><br>
</span></font><font face="Times New Roman"><span style="font-size:12pt"> <!-- <load module="mod_spidermonkey_teletone"/> --><br>
</span></font><font face="Monaco, Courier New"><span style="font-size:11pt"><br>
</span></font><font face="Times New Roman"><span style="font-size:12pt"> <load module="mod_spidermonkey_core_db"/><br>
</span></font><font face="Monaco, Courier New"><span style="font-size:11pt"><br>
</span></font><font face="Times New Roman"><span style="font-size:12pt"> <load module="mod_spidermonkey_socket"/><br>
</span></font><font face="Monaco, Courier New"><span style="font-size:11pt"><br>
</span></font><font face="Times New Roman"><span style="font-size:12pt"> <load module="mod_spidermonkey_odbc"/><br>
</span></font><font face="Monaco, Courier New"><span style="font-size:11pt"><br>
</span></font><font face="Times New Roman"><span style="font-size:12pt"> </modules><br>
</span></font><font face="Monaco, Courier New"><span style="font-size:11pt"><br>
</span></font><font face="Times New Roman"><span style="font-size:12pt"></configuration><br>
</span></font><font face="Monaco, Courier New"><span style="font-size:11pt"><br>
</span></font><font face="Times New Roman"><span style="font-size:12pt"> <br>
</span></font><font face="Monaco, Courier New"><span style="font-size:11pt"><br>
</span></font><font face="Times New Roman"><span style="font-size:12pt"> <br>
</span></font><font face="Monaco, Courier New"><span style="font-size:11pt"><br>
</span></font><font face="Times New Roman"><span style="font-size:12pt">My odbc.ini:<br>
</span></font><font face="Monaco, Courier New"><span style="font-size:11pt"><br>
</span></font><font face="Times New Roman"><span style="font-size:12pt"> <br>
</span></font><font face="Monaco, Courier New"><span style="font-size:11pt"><br>
</span></font><font face="Times New Roman"><span style="font-size:12pt">[nibblebill1]<br>
</span></font><font face="Monaco, Courier New"><span style="font-size:11pt"><br>
</span></font><font face="Times New Roman"><span style="font-size:12pt">Driver = /usr/lib/x86_64-linux-gnu/odbc/libmyodbc.so<br>
</span></font><font face="Monaco, Courier New"><span style="font-size:11pt"><br>
</span></font><font face="Times New Roman"><span style="font-size:12pt">SERVER = callcenter<br>
</span></font><font face="Monaco, Courier New"><span style="font-size:11pt"><br>
</span></font><font face="Times New Roman"><span style="font-size:12pt">PORT = 3306<br>
</span></font><font face="Monaco, Courier New"><span style="font-size:11pt"><br>
</span></font><font face="Times New Roman"><span style="font-size:12pt">DATABASE = nibblebill1<br>
</span></font><font face="Monaco, Courier New"><span style="font-size:11pt"><br>
</span></font><font face="Times New Roman"><span style="font-size:12pt">OPTION = 67108864<br>
</span></font><font face="Monaco, Courier New"><span style="font-size:11pt"><br>
</span></font><font face="Times New Roman"><span style="font-size:12pt">USER = nibblebill1<br>
</span></font><font face="Monaco, Courier New"><span style="font-size:11pt"><br>
</span></font><font face="Times New Roman"><span style="font-size:12pt">PASSWORD = XXXXXXX<br>
</span></font><font face="Monaco, Courier New"><span style="font-size:11pt"><br>
</span></font><font face="Times New Roman"><span style="font-size:12pt"> <br>
</span></font><font face="Monaco, Courier New"><span style="font-size:11pt"><br>
</span></font><font face="Times New Roman"><span style="font-size:12pt"> <br>
</span></font><font face="Monaco, Courier New"><span style="font-size:11pt"><br>
</span></font><font face="Times New Roman"><span style="font-size:12pt"> <br>
</span></font><font face="Monaco, Courier New"><span style="font-size:11pt"><br>
</span></font><font face="Times New Roman"><span style="font-size:12pt"> <br>
</span></font><font face="Monaco, Courier New"><span style="font-size:11pt"><br>
</span></font><font face="Times New Roman"><span style="font-size:12pt">ldd /usr/local/freeswitch/mod/mod_spidermonkey_odbc.so<br>
</span></font><font face="Monaco, Courier New"><span style="font-size:11pt"><br>
</span></font><font face="Times New Roman"><span style="font-size:12pt"> linux-vdso.so.1 => (0x00007fffbd7ff000)<br>
</span></font><font face="Monaco, Courier New"><span style="font-size:11pt"><br>
</span></font><font face="Times New Roman"><span style="font-size:12pt"> libfreeswitch.so.1 => /usr/local/freeswitch/lib/libfreeswitch.so.1 (0x00007f2f193ee000)<br>
</span></font><font face="Monaco, Courier New"><span style="font-size:11pt"><br>
</span></font><font face="Times New Roman"><span style="font-size:12pt"> libjs.so.1 => /usr/local/freeswitch/lib/libjs.so.1 (0x00007f2f19120000)<br>
</span></font><font face="Monaco, Courier New"><span style="font-size:11pt"><br>
</span></font><font face="Times New Roman"><span style="font-size:12pt"> libnspr4.so => /usr/local/freeswitch/lib/libnspr4.so (0x00007f2f18eef000)<br>
</span></font><font face="Monaco, Courier New"><span style="font-size:11pt"><br>
</span></font><font face="Times New Roman"><span style="font-size:12pt"> libodbc.so.1 => /usr/lib/x86_64-linux-gnu/libodbc.so.1 (0x00007f2f18c82000)<br>
</span></font><font face="Monaco, Courier New"><span style="font-size:11pt"><br>
</span></font><font face="Times New Roman"><span style="font-size:12pt"> libpthread.so.0 => /lib/x86_64-linux-gnu/libpthread.so.0 (0x00007f2f18a65000)<br>
</span></font><font face="Monaco, Courier New"><span style="font-size:11pt"><br>
</span></font><font face="Times New Roman"><span style="font-size:12pt"> libc.so.6 => /lib/x86_64-linux-gnu/libc.so.6 (0x00007f2f186a5000)<br>
</span></font><font face="Monaco, Courier New"><span style="font-size:11pt"><br>
</span></font><font face="Times New Roman"><span style="font-size:12pt"> libdl.so.2 => /lib/x86_64-linux-gnu/libdl.so.2 (0x00007f2f184a1000)<br>
</span></font><font face="Monaco, Courier New"><span style="font-size:11pt"><br>
</span></font><font face="Times New Roman"><span style="font-size:12pt"> libcrypt.so.1 => /lib/x86_64-linux-gnu/libcrypt.so.1 (0x00007f2f18268000)<br>
</span></font><font face="Monaco, Courier New"><span style="font-size:11pt"><br>
</span></font><font face="Times New Roman"><span style="font-size:12pt"> librt.so.1 => /lib/x86_64-linux-gnu/librt.so.1 (0x00007f2f1805f000)<br>
</span></font><font face="Monaco, Courier New"><span style="font-size:11pt"><br>
</span></font><font face="Times New Roman"><span style="font-size:12pt"> libssl.so.1.0.0 => /lib/x86_64-linux-gnu/libssl.so.1.0.0 (0x00007f2f17e03000)<br>
</span></font><font face="Monaco, Courier New"><span style="font-size:11pt"><br>
</span></font><font face="Times New Roman"><span style="font-size:12pt"> libcrypto.so.1.0.0 => /lib/x86_64-linux-gnu/libcrypto.so.1.0.0 (0x00007f2f17a3b000)<br>
</span></font><font face="Monaco, Courier New"><span style="font-size:11pt"><br>
</span></font><font face="Times New Roman"><span style="font-size:12pt"> libtinfo.so.5 => /lib/x86_64-linux-gnu/libtinfo.so.5 (0x00007f2f17813000)<br>
</span></font><font face="Monaco, Courier New"><span style="font-size:11pt"><br>
</span></font><font face="Times New Roman"><span style="font-size:12pt"> libstdc++.so.6 => /usr/lib/x86_64-linux-gnu/libstdc++.so.6 (0x00007f2f17513000)<br>
</span></font><font face="Monaco, Courier New"><span style="font-size:11pt"><br>
</span></font><font face="Times New Roman"><span style="font-size:12pt"> libm.so.6 => /lib/x86_64-linux-gnu/libm.so.6 (0x00007f2f17217000)<br>
</span></font><font face="Monaco, Courier New"><span style="font-size:11pt"><br>
</span></font><font face="Times New Roman"><span style="font-size:12pt"> libgcc_s.so.1 => /lib/x86_64-linux-gnu/libgcc_s.so.1 (0x00007f2f17000000)<br>
</span></font><font face="Monaco, Courier New"><span style="font-size:11pt"><br>
</span></font><font face="Times New Roman"><span style="font-size:12pt"> libltdl.so.7 => /usr/lib/x86_64-linux-gnu/libltdl.so.7 (0x00007f2f16df6000)<br>
</span></font><font face="Monaco, Courier New"><span style="font-size:11pt"><br>
</span></font><font face="Times New Roman"><span style="font-size:12pt"> /lib64/ld-linux-x86-64.so.2 (0x00007f2f19a48000)<br>
</span></font><font face="Monaco, Courier New"><span style="font-size:11pt"><br>
</span></font><font face="Times New Roman"><span style="font-size:12pt"> libz.so.1 => /lib/x86_64-linux-gnu/libz.so.1 (0x00007f2f16bde000)<br>
</span></font><font face="Monaco, Courier New"><span style="font-size:11pt"><br>
</span></font><font face="Times New Roman"><span style="font-size:12pt"> <br>
</span></font><font face="Monaco, Courier New"><span style="font-size:11pt"><br>
</span></font><font face="Times New Roman"><span style="font-size:12pt"><br>
FreeSWITCH (Version 1.2.6 git a424765 2013-01-04 15:45:59Z)<br>
</span></font><font face="Monaco, Courier New"><span style="font-size:11pt"><br>
</span></font><font face="Times New Roman"><span style="font-size:12pt"> <br>
</span></font><font face="Monaco, Courier New"><span style="font-size:11pt"><br>
</span></font><font face="Times New Roman"><span style="font-size:12pt">When I try to run<b> load mod_spidermonkey_odbc</b> I get:<br>
</span></font><font face="Monaco, Courier New"><span style="font-size:11pt"><br>
</span></font><font face="Times New Roman"><span style="font-size:12pt"> <br>
</span></font><font face="Monaco, Courier New"><span style="font-size:11pt"><br>
</span></font><font size="1"><font face="Courier New"><span style="font-size:9pt">[CRIT] switch_loadable_module.c:1330 Error Loading module /usr/local/freeswitch/mod/mod_spidermonkey_odbc.so <br>
**/usr/local/freeswitch/mod/mod_spidermonkey_odbc.so: undefined symbol: mod_spidermonkey_odbc_module_interface** <br>
</span></font></font><font face="Monaco, Courier New"><span style="font-size:11pt"><br>
</span></font><font face="Times New Roman"><span style="font-size:12pt"> <br>
</span></font><font face="Monaco, Courier New"><span style="font-size:11pt"><br>
</span></font><font face="Times New Roman"><span style="font-size:12pt"><b>load mod_nibblebill:<br>
</b></span></font><font face="Monaco, Courier New"><span style="font-size:11pt"><br>
</span></font><font face="Times New Roman"><span style="font-size:12pt"> <br>
</span></font><font face="Monaco, Courier New"><span style="font-size:11pt"><br>
</span></font><font face="Times New Roman"><span style="font-size:12pt">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<br>
</span></font><font face="Monaco, Courier New"><span style="font-size:11pt"><br>
</span></font><font face="Times New Roman"><span style="font-size:12pt"> <br>
</span></font><font face="Monaco, Courier New"><span style="font-size:11pt"><br>
</span></font><font face="Times New Roman"><span style="font-size:12pt">2013-02-26 21:46:40.116678 [CRIT] mod_nibblebill.c:220 Cannot connect to ODBC driver/database odbc://callcenter (user: nibblebill1 / pass XXXXX)!<br>
</span></font><font face="Monaco, Courier New"><span style="font-size:11pt"><br>
</span></font><font face="Times New Roman"><span style="font-size:12pt">2013-02-26 21:46:40.116678 [CONSOLE] switch_loadable_module.c:1348 Successfully Loaded [mod_nibblebill]<br>
</span></font><font face="Monaco, Courier New"><span style="font-size:11pt"><br>
</span></font><font face="Times New Roman"><span style="font-size:12pt"> <br>
</span></font><font face="Monaco, Courier New"><span style="font-size:11pt"><br>
</span></font><font face="Times New Roman"><span style="font-size:12pt"> <br>
</span></font><font face="Monaco, Courier New"><span style="font-size:11pt"><br>
</span></font><font face="Times New Roman"><span style="font-size:12pt">Also from time to time in logs I've see:<br>
</span></font><font face="Monaco, Courier New"><span style="font-size:11pt"><br>
</span></font><font face="Times New Roman"><span style="font-size:12pt"> <br>
</span></font><font face="Monaco, Courier New"><span style="font-size:11pt"><br>
</span></font><font color="#FF0000"><font size="1"><font face="Courier New"><span style="font-size:9pt">[ERR] switch_odbc.c:365 STATE: IM002 CODE 0 ERROR: [unixODBC][Driver Manager]Data source name not found, and no default driver specified <br>
</span></font></font></font><font face="Monaco, Courier New"><span style="font-size:11pt"><br>
</span></font><font face="Times New Roman"><span style="font-size:12pt"> <br>
</span></font><font face="Monaco, Courier New"><span style="font-size:11pt"><br>
</span></font><font face="Times New Roman"><span style="font-size:12pt">Will you be able to help with this issue ?<br>
</span></font><font face="Monaco, Courier New"><span style="font-size:11pt"><br>
</span></font><font face="Times New Roman"><span style="font-size:12pt">Thank you.<br>
</span></font></blockquote><font face="Times New Roman"><span style="font-size:12pt"><br>
</span></font></div></div><font face="Monaco, Courier New"><span style="font-size:11pt">-- <br><div class="im">
Ken<br>
<font color="#0000FF"><u><a href="http://www.FreeSWITCH.org" target="_blank">http://www.FreeSWITCH.org</a><br>
<a href="http://www.ClueCon.com" target="_blank">http://www.ClueCon.com</a><br>
<a href="http://www.OSTAG.org" target="_blank">http://www.OSTAG.org</a><br>
</u></font><a href="http://irc.freenode.net" target="_blank">irc.freenode.net</a> #freeswitch<br>
</div></span></font>
</div>
<br>_________________________________________________________________________<br>
Professional FreeSWITCH Consulting Services:<br>
<a href="mailto:consulting@freeswitch.org">consulting@freeswitch.org</a><br>
<a href="http://www.freeswitchsolutions.com" target="_blank">http://www.freeswitchsolutions.com</a><br>
<br>
FreeSWITCH-powered IP PBX: The CudaTel Communication Server<br>
<a href="http://www.cudatel.com" target="_blank">http://www.cudatel.com</a><br>
<br>
Official FreeSWITCH Sites<br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
<a href="http://wiki.freeswitch.org" target="_blank">http://wiki.freeswitch.org</a><br>
<a href="http://www.cluecon.com" target="_blank">http://www.cluecon.com</a><br>
<br>
FreeSWITCH-users mailing list<br>
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a><br>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
<br></blockquote></div><br><br clear="all"><div><br></div>-- <br>Pozdrawiam<br>Tomasz
</div>