<HTML>
<HEAD>
<TITLE>Re: [Freeswitch-users] nibblebill, spidermonkey_odbc issue</TITLE>
</HEAD>
<BODY>
<FONT FACE="Monaco, Courier New"><SPAN STYLE='font-size:11pt'>You don’t load mod_spidermoney_odbc<BR>
You uncomment it in autoload_configs/spidermonkey.conf.xml<BR>
<BR>
Mod_spidermonkey loads that module... Mod_spidermonkey is probably the only module that can actually load its own extension modules<BR>
<BR>
<BR>
On 2/26/13 2:48 PM, "Tomasz Szuster" <<a href="tomasz.szuster@gmail.com">tomasz.szuster@gmail.com</a>> wrote:<BR>
<BR>
</SPAN></FONT><BLOCKQUOTE><FONT FACE="Monaco, Courier New"><SPAN STYLE='font-size:11pt'>Hi,<BR>
<BR>
I'm struggling with making nibblebill working.<BR>
What I've did till now is:<BR>
<BR>
Installed odbc:<BR>
* libmyodbc<BR>
* libodbc1<BR>
* odbcinst<BR>
* odbcinst1debian2<BR>
* unixodbc<BR>
* unixodbc-dev<BR>
<BR>
compile freeswitch using<BR>
<BR>
<BR>
<BR>
./configure --enable-core-odbc-support<BR>
make; make install<BR>
<BR>
My spidermonkey.conf file has:<BR>
<BR>
<configuration name="spidermonkey.conf" description="Spider Monkey JavaScript Plug-Ins"><BR>
<modules><BR>
<!-- <load module="mod_spidermonkey_teletone"/> --><BR>
<load module="mod_spidermonkey_core_db"/><BR>
<load module="mod_spidermonkey_socket"/><BR>
<load module="mod_spidermonkey_odbc"/><BR>
</modules><BR>
</configuration><BR>
<BR>
<BR>
My odbc.ini:<BR>
<BR>
[nibblebill1]<BR>
Driver = /usr/lib/x86_64-linux-gnu/odbc/libmyodbc.so<BR>
SERVER = callcenter<BR>
PORT = 3306<BR>
DATABASE = nibblebill1<BR>
OPTION = 67108864<BR>
USER = nibblebill1<BR>
PASSWORD = XXXXXXX<BR>
<BR>
<BR>
<BR>
<BR>
ldd /usr/local/freeswitch/mod/mod_spidermonkey_odbc.so<BR>
linux-vdso.so.1 => (0x00007fffbd7ff000)<BR>
libfreeswitch.so.1 => /usr/local/freeswitch/lib/libfreeswitch.so.1 (0x00007f2f193ee000)<BR>
libjs.so.1 => /usr/local/freeswitch/lib/libjs.so.1 (0x00007f2f19120000)<BR>
libnspr4.so => /usr/local/freeswitch/lib/libnspr4.so (0x00007f2f18eef000)<BR>
libodbc.so.1 => /usr/lib/x86_64-linux-gnu/libodbc.so.1 (0x00007f2f18c82000)<BR>
libpthread.so.0 => /lib/x86_64-linux-gnu/libpthread.so.0 (0x00007f2f18a65000)<BR>
libc.so.6 => /lib/x86_64-linux-gnu/libc.so.6 (0x00007f2f186a5000)<BR>
libdl.so.2 => /lib/x86_64-linux-gnu/libdl.so.2 (0x00007f2f184a1000)<BR>
libcrypt.so.1 => /lib/x86_64-linux-gnu/libcrypt.so.1 (0x00007f2f18268000)<BR>
librt.so.1 => /lib/x86_64-linux-gnu/librt.so.1 (0x00007f2f1805f000)<BR>
libssl.so.1.0.0 => /lib/x86_64-linux-gnu/libssl.so.1.0.0 (0x00007f2f17e03000)<BR>
libcrypto.so.1.0.0 => /lib/x86_64-linux-gnu/libcrypto.so.1.0.0 (0x00007f2f17a3b000)<BR>
libtinfo.so.5 => /lib/x86_64-linux-gnu/libtinfo.so.5 (0x00007f2f17813000)<BR>
libstdc++.so.6 => /usr/lib/x86_64-linux-gnu/libstdc++.so.6 (0x00007f2f17513000)<BR>
libm.so.6 => /lib/x86_64-linux-gnu/libm.so.6 (0x00007f2f17217000)<BR>
libgcc_s.so.1 => /lib/x86_64-linux-gnu/libgcc_s.so.1 (0x00007f2f17000000)<BR>
libltdl.so.7 => /usr/lib/x86_64-linux-gnu/libltdl.so.7 (0x00007f2f16df6000)<BR>
/lib64/ld-linux-x86-64.so.2 (0x00007f2f19a48000)<BR>
libz.so.1 => /lib/x86_64-linux-gnu/libz.so.1 (0x00007f2f16bde000)<BR>
<BR>
<BR>
FreeSWITCH (Version 1.2.6 git a424765 2013-01-04 15:45:59Z)<BR>
<BR>
When I try to run<B> load mod_spidermonkey_odbc</B> I get:<BR>
<BR>
</SPAN><FONT SIZE="1"><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><SPAN STYLE='font-size:11pt'><BR>
<B>load mod_nibblebill:<BR>
</B><BR>
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>
<BR>
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>
2013-02-26 21:46:40.116678 [CONSOLE] switch_loadable_module.c:1348 Successfully Loaded [mod_nibblebill]<BR>
<BR>
<BR>
Also from time to time in logs I've see:<BR>
<BR>
</SPAN><FONT SIZE="1"><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><SPAN STYLE='font-size:11pt'><BR>
Will you be able to help with this issue ?<BR>
Thank you.<BR>
</SPAN></FONT></BLOCKQUOTE><FONT FACE="Monaco, Courier New"><SPAN STYLE='font-size:11pt'><BR>
-- <BR>
Ken<BR>
<FONT COLOR="#0000FF"><U><a href="http://www.FreeSWITCH.org">http://www.FreeSWITCH.org</a><BR>
<a href="http://www.ClueCon.com">http://www.ClueCon.com</a><BR>
<a href="http://www.OSTAG.org">http://www.OSTAG.org</a><BR>
</U></FONT>irc.freenode.net #freeswitch<BR>
</SPAN></FONT>
</BODY>
</HTML>