<div dir="ltr">Where should i configure the data source name in odbc?<br><br><div class="gmail_quote">On Mon, Sep 29, 2008 at 1:05 PM, preetha Ayyappan <span dir="ltr"><<a href="mailto:preetha.ayyappan@gmail.com">preetha.ayyappan@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div dir="ltr">Yes. I have uncommented that line before installing itself.Even though i am getting the same error.<div>
<div></div><div class="Wj3C7c"><br><br><div class="gmail_quote">On Mon, Sep 29, 2008 at 1:00 PM, Ken Rice <span dir="ltr"><<a href="mailto:krice@suspicious.org" target="_blank">krice@suspicious.org</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div>
<font size="4"><font face="Calibri, Verdana, Helvetica, Arial"><span style="font-size: 11pt;">In modules.conf in the root of the freeswitch source directory did you uncomment languages/mod_spidermonkey_odbc if you didn't its not building the module<br>
<br>
<br>
<hr size="3" width="95%" align="center"><b>From: </b>preetha Ayyappan <<a href="mailto:preetha.ayyappan@gmail.com" target="_blank">preetha.ayyappan@gmail.com</a>><br>
<b>Reply-To: </b><<a href="mailto:freeswitch-users@lists.freeswitch.org" target="_blank">freeswitch-users@lists.freeswitch.org</a>><br>
<b>Date: </b>Mon, 29 Sep 2008 12:44:40 +0530<br>
<b>To: </b><<a href="mailto:freeswitch-users@lists.freeswitch.org" target="_blank">freeswitch-users@lists.freeswitch.org</a>><br>
<b>Subject: </b>Re: [Freeswitch-users] Error loading ODBC<div><div></div><div><br>
<br>
Thanks.I have uncommented the line yoy specified and run the program sample.js from the freeswitch console.It shows the following error:<br>
freeswitch@localhost> 2008-09-29 18:13:03 [ERR] switch_odbc.c:160 switch_odbc_handle_connect() STATE: IM002 CODE 0 ERROR: [unixODBC][Driver Manager]Data source name not found, and no default driver specified<br>
<br>
2008-09-29 18:13:03 [ERR] mod_spidermonkey_odbc.c:235 odbc_exec() Database is not connected!<br>
2008-09-29 18:13:03 [ERR] mod_spidermonkey_odbc.c:235 odbc_exec() Database is not connected!<br>
2008-09-29 18:13:03 [ERR] mod_spidermonkey_odbc.c:235 odbc_exec() Database is not connected!<br>
2008-09-29 18:13:03 [ERR] mod_spidermonkey_odbc.c:235 odbc_exec() Database is not connected!<br>
2008-09-29 18:13:03 [ERR] mod_spidermonkey_odbc.c:235 odbc_exec() Database is not connected!<br>
2008-09-29 18:13:03 [ERR] mod_spidermonkey_odbc.c:235 odbc_exec() Database is not connected!<br>
2008-09-29 18:13:03 [NOTICE] sample.js:1 console_log() ==============================<br>
2008-09-29 18:13:03 [ERR] mod_spidermonkey_odbc.c:235 odbc_exec() Database is not connected!<br>
2008-09-29 18:13:03 [ERR] mod_spidermonkey_odbc.c:266 odbc_num_rows() Database is not connected!<br>
2008-09-29 18:13:03 [ERR] mod_spidermonkey_odbc.c:314 odbc_next_row() Database is not connected!<br>
2008-09-29 18:13:03 [NOTICE] sample.js:1 console_log() ==============================<br>
2008-09-29 18:13:03 [ERR] mod_spidermonkey_odbc.c:235 odbc_exec() Database is not connected!<br>
<br>
Thanks<br>
<br>
<br>
On Mon, Sep 29, 2008 at 12:29 PM, Michael Jerris <<a href="mailto:mike@jerris.com" target="_blank">mike@jerris.com</a>> wrote:<br>
</div></div></span></font></font><blockquote><div><div></div><div><font size="4"><font face="Calibri, Verdana, Helvetica, Arial"><span style="font-size: 11pt;"><br>
On Sep 29, 2008, at 2:45 AM, preetha Ayyappan wrote:<br>
<br>
</span></font></font><blockquote><font size="4"><font face="Calibri, Verdana, Helvetica, Arial"><span style="font-size: 11pt;">I have uncommented the line <b>'langages/mod_spidermonkey_odbc' </b>from /usr/local/freeswitch/modules.conf and installed like the following<br>
<br>
step1:-I have downloaded the unixodbc and put it in usr/local/freeswitch.<br>
step2:-I have installed like the following from the /usr/local/freeswitch<br>
a)</span></font><font face="Consolas, Courier New, Courier"><span style="font-size: 10pt;">tar -xvzf unixODBC-2.2.12.tar.gz<br>
</span></font><font face="Calibri, Verdana, Helvetica, Arial"><span style="font-size: 11pt;">step3:-In the path /usr/local/freeswitch/unixodbc-2.2.12 ,i have done<br>
b)</span></font><font face="Consolas, Courier New, Courier"><span style="font-size: 10pt;">./configure --enable-gui=no<br>
c)make<br>
d)make install<br>
<br>
step3:-In the path /usr/local/freeswitch,I have done <br>
</span></font><font face="Calibri, Verdana, Helvetica, Arial"><span style="font-size: 11pt;">a)./configure --enable-core-odbc-support<br>
b)make all install<br>
<br>
when doing the above steps <br>
<br>
a)./configure --enable-core-odbc-support<br>
b)make all install, I am getting the lines <br>
<br>
Making install in src<br>
Making install in mod<br>
<br>
is not a valid FreeSWITCH module dir, skipping it.....<br>
<br>
is not a valid FreeSWITCH module dir, skipping it.....<br>
<br>
<br>
<br>
After making all the above I have put a sample odbc.js in /usr/local/javascript/scripts and tried to run from the freeswitch console like jsrun odbc.js.<br>
<br>
I am getting the following error:<br>
<br>
freeswitch@localhost> 2008-09-29 17:44:12 [ERR] mod_spidermonkey.c:3303 js_api_use() Error loading ODBC<br>
<br>
<br>
2008-09-29 17:44:12 [ERR] sample.js:11 mod_spidermonkey() ReferenceError: ODBC is not defined<br>
<br>
please let me know where i am wrong here.<br>
<br>
Thanks.<br>
</span></font></font></blockquote><font size="4"><font face="Calibri, Verdana, Helvetica, Arial"><span style="font-size: 11pt;"><br>
in the file conf/autoload_configs/spidermonkey.conf.xml<br>
<br>
uncomment <load module="mod_spidermonkey_odbc"/><br>
<br>
I know you said you did before but double check... are you still getting the error that it can not open mod_spidermonkey_odbc.so? When it builds, do you see it building mod_spidermonkey_odbc? Does it actually create the so?<br>
<br>
Mike<br>
<br>
<br>
<br>
</span></font></font><blockquote><font size="4"><font face="Consolas, Courier New, Courier"><span style="font-size: 10pt;"><br>
</span></font><font face="Calibri, Verdana, Helvetica, Arial"><span style="font-size: 11pt;"> <br>
<br>
On Fri, Sep 26, 2008 at 3:16 PM, David Knell <<a href="mailto:dave@3c.co.uk" target="_blank">dave@3c.co.uk</a>> wrote:<br>
</span></font></font><blockquote><font size="4"><font face="Calibri, Verdana, Helvetica, Arial"><span style="font-size: 11pt;"> <br>
Hi Preetha,<br>
<br>
You've probably not compiled the module. Have a look in /usr/src/freeswitch (or wherever your source is); you'll<br>
find a modules.conf there. Uncomment the line 'langages/mod_spidermonkey_odbc', rebuild, reinstall and things<br>
might get better.<br>
<br>
--Dave<br>
<br>
</span></font></font><blockquote><font size="4"><font face="Calibri, Verdana, Helvetica, Arial"><span style="font-size: 11pt;"> <br>
yes, I did ./configure --enable-core-odbc-support && make && make install.When i gave make install during installation,i found the following error:<br>
<br>
<br>
<br>
2008-09-26 19:37:19 [CRIT] switch_loadable_module.c:767 switch_loadable_module_load_file() Error Loading module /usr/local/freeswitch/mod/mod_spidermonkey_odbc.so<br>
**/usr/local/freeswitch/mod/mod_spidermonkey_odbc.so: cannot open shared object file: No such file or directory**<br>
<br>
Thanks<br>
<br>
<br>
On 9/25/08, <b>Raymond Chandler</b> <<a href="mailto:intralanman@freeswitch.org" target="_blank">intralanman@freeswitch.org</a>> wrote: <br>
</span></font></font><blockquote><font size="4"><font face="Calibri, Verdana, Helvetica, Arial"><span style="font-size: 11pt;"> <br>
if you built from source, make sure you use the --enable-core-odbc-support option on your ./configure<br>
<br>
like so<br>
./configure --enable-core-odbc-support && make && make install<br>
<br>
-Ray<br>
<br>
<br>
preetha Ayyappan wrote: <br>
</span></font></font><blockquote><font size="4"><font face="Calibri, Verdana, Helvetica, Arial"><span style="font-size: 11pt;"> <br>
<br>
You mean i have to uncomment the line <load module="mod_spidermonkey_odbc"/>.?<br>
yes.I have uncommented that line.eventhough the same error occurs<br>
<br>
<br>
On Thu, Sep 25, 2008 at 2:33 PM, Michael Jerris <<a href="mailto:mike@jerris.com" target="_blank">mike@jerris.com</a>> wrote:<br>
<br>
</span></font></font><blockquote><font size="4"><font face="Calibri, Verdana, Helvetica, Arial"><span style="font-size: 11pt;"> <br>
<br>
On Sep 25, 2008, at 4:47 AM, preetha wrote:<br>
<br>
><br>
> Hi,<br>
> when i try to run a sample odbc code from freeswitch console like<br>
> freeswitch@localhost> jsrun odbc.js<br>
><br>
> I found the following error:<br>
> API CALL [jsrun(odbc.js)] output:<br>
> OK<br>
><br>
> freeswitch@localhost> 2008-09-25 19:44:35 [ERR] mod_spidermonkey.c:<br>
> 3303<br>
> js_api_use() Error loading ODBC<br>
> 2008-09-25 19:44:35 [ERR] odbc.js:11 mod_spidermonkey()<br>
> ReferenceError:<br>
> ODBC is not defined<br>
><br>
<br>
<br>
Make sure you have mod_spidermonkey_odbc loaded in your<br>
spidermonkey.conf.xml file<br>
<br>
Mike<br>
<br>
<br>
<br>
</span></font></font></blockquote></blockquote></blockquote></blockquote></blockquote></blockquote></div></div><font size="4"><font face="Calibri, Verdana, Helvetica, Arial"><span style="font-size: 11pt;"><div><div></div>
<div><br>
<br>
_______________________________________________<br>
Freeswitch-users mailing list<br>
<a href="mailto:Freeswitch-users@lists.freeswitch.org" target="_blank">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>
<br>
<br>
<br>
-- <br>
Preetha.A<br>
<br>
</div></div><hr size="3" width="95%" align="center"></span></font></font></blockquote><div><font size="4"><font face="Consolas, Courier New, Courier"><span style="font-size: 10pt;">_______________________________________________<br>
Freeswitch-users mailing list<br>
<a href="mailto:Freeswitch-users@lists.freeswitch.org" target="_blank">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>
</span></font></font>
</div></div>
<br>_______________________________________________<br>
Freeswitch-users mailing list<br>
<a href="mailto:Freeswitch-users@lists.freeswitch.org" target="_blank">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"><br>-- <br>Preetha.A<br>
</div></div></div>
</blockquote></div><br><br clear="all"><br>-- <br>Preetha.A<br>
</div>