Refer to one of the many unixODBC howtos like the one found here
http://developer.mimer.com/howto/howto_57.htm
Or visit the unixODBC website @ www.unixodbc.org ....
From: preetha Ayyappan <preetha.ayyappan@gmail.com>
Reply-To: <freeswitch-users@lists.freeswitch.org>
Date: Mon, 29 Sep 2008 13:06:51 +0530
To: <freeswitch-users@lists.freeswitch.org>
Subject: Re: [Freeswitch-users] Error loading ODBC
Where should i configure the data source name in odbc?
On Mon, Sep 29, 2008 at 1:05 PM, preetha Ayyappan <preetha.ayyappan@gmail.com> wrote:
Yes. I have uncommented that line before installing itself.Even though i am getting the same error.
On Mon, Sep 29, 2008 at 1:00 PM, Ken Rice <krice@suspicious.org> wrote:
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
From: preetha Ayyappan <preetha.ayyappan@gmail.com>
Reply-To: <freeswitch-users@lists.freeswitch.org>
Date: Mon, 29 Sep 2008 12:44:40 +0530
To: <freeswitch-users@lists.freeswitch.org>
Subject: Re: [Freeswitch-users] Error loading ODBC
Thanks.I have uncommented the line yoy specified and run the program sample.js from the freeswitch console.It shows the following error:
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
2008-09-29 18:13:03 [ERR] mod_spidermonkey_odbc.c:235 odbc_exec() Database is not connected!
2008-09-29 18:13:03 [ERR] mod_spidermonkey_odbc.c:235 odbc_exec() Database is not connected!
2008-09-29 18:13:03 [ERR] mod_spidermonkey_odbc.c:235 odbc_exec() Database is not connected!
2008-09-29 18:13:03 [ERR] mod_spidermonkey_odbc.c:235 odbc_exec() Database is not connected!
2008-09-29 18:13:03 [ERR] mod_spidermonkey_odbc.c:235 odbc_exec() Database is not connected!
2008-09-29 18:13:03 [ERR] mod_spidermonkey_odbc.c:235 odbc_exec() Database is not connected!
2008-09-29 18:13:03 [NOTICE] sample.js:1 console_log() ==============================
2008-09-29 18:13:03 [ERR] mod_spidermonkey_odbc.c:235 odbc_exec() Database is not connected!
2008-09-29 18:13:03 [ERR] mod_spidermonkey_odbc.c:266 odbc_num_rows() Database is not connected!
2008-09-29 18:13:03 [ERR] mod_spidermonkey_odbc.c:314 odbc_next_row() Database is not connected!
2008-09-29 18:13:03 [NOTICE] sample.js:1 console_log() ==============================
2008-09-29 18:13:03 [ERR] mod_spidermonkey_odbc.c:235 odbc_exec() Database is not connected!
Thanks
On Mon, Sep 29, 2008 at 12:29 PM, Michael Jerris <mike@jerris.com> wrote:
On Sep 29, 2008, at 2:45 AM, preetha Ayyappan wrote:
I have uncommented the line 'langages/mod_spidermonkey_odbc' from /usr/local/freeswitch/modules.conf and installed like the following
step1:-I have downloaded the unixodbc and put it in usr/local/freeswitch.
step2:-I have installed like the following from the /usr/local/freeswitch
a)tar -xvzf unixODBC-2.2.12.tar.gz
step3:-In the path /usr/local/freeswitch/unixodbc-2.2.12 ,i have done
b)./configure --enable-gui=no
c)make
d)make install
step3:-In the path /usr/local/freeswitch,I have done
a)./configure --enable-core-odbc-support
b)make all install
when doing the above steps
a)./configure --enable-core-odbc-support
b)make all install, I am getting the lines
Making install in src
Making install in mod
is not a valid FreeSWITCH module dir, skipping it.....
is not a valid FreeSWITCH module dir, skipping it.....
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.
I am getting the following error:
freeswitch@localhost> 2008-09-29 17:44:12 [ERR] mod_spidermonkey.c:3303 js_api_use() Error loading ODBC
2008-09-29 17:44:12 [ERR] sample.js:11 mod_spidermonkey() ReferenceError: ODBC is not defined
please let me know where i am wrong here.
Thanks.
in the file conf/autoload_configs/spidermonkey.conf.xml
uncomment <load module="mod_spidermonkey_odbc"/>
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?
Mike
On Fri, Sep 26, 2008 at 3:16 PM, David Knell <dave@3c.co.uk> wrote:
Hi Preetha,
You've probably not compiled the module. Have a look in /usr/src/freeswitch (or wherever your source is); you'll
find a modules.conf there. Uncomment the line 'langages/mod_spidermonkey_odbc', rebuild, reinstall and things
might get better.
--Dave
yes, I did ./configure --enable-core-odbc-support && make && make install.When i gave make install during installation,i found the following error:
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
**/usr/local/freeswitch/mod/mod_spidermonkey_odbc.so: cannot open shared object file: No such file or directory**
Thanks
On 9/25/08, Raymond Chandler <intralanman@freeswitch.org> wrote:
if you built from source, make sure you use the --enable-core-odbc-support option on your ./configure
like so
./configure --enable-core-odbc-support && make && make install
-Ray
preetha Ayyappan wrote:
You mean i have to uncomment the line <load module="mod_spidermonkey_odbc"/>.?
yes.I have uncommented that line.eventhough the same error occurs
On Thu, Sep 25, 2008 at 2:33 PM, Michael Jerris <mike@jerris.com> wrote:
On Sep 25, 2008, at 4:47 AM, preetha wrote:
>
> Hi,
> when i try to run a sample odbc code from freeswitch console like
> freeswitch@localhost> jsrun odbc.js
>
> I found the following error:
> API CALL [jsrun(odbc.js)] output:
> OK
>
> freeswitch@localhost> 2008-09-25 19:44:35 [ERR] mod_spidermonkey.c:
> 3303
> js_api_use() Error loading ODBC
> 2008-09-25 19:44:35 [ERR] odbc.js:11 mod_spidermonkey()
> ReferenceError:
> ODBC is not defined
>
Make sure you have mod_spidermonkey_odbc loaded in your
spidermonkey.conf.xml file
Mike
_______________________________________________
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
--
Preetha.A
_______________________________________________
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
_______________________________________________
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
--
Preetha.A
--
Preetha.A
_______________________________________________
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