Discussion:
[Freeswitch-users] Error loading ODBC
preetha
2008-09-25 08:47:50 UTC
Permalink
Hi,
when i try to run a sample odbc code from freeswitch console like
freeswitch at localhost> jsrun odbc.js

I found the following error:
API CALL [jsrun(odbc.js)] output:
OK

freeswitch at 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

code is:
use("ODBC");

var people = {};
people["authur"] = 30;
people["ford"] = 42;
people["trillian"] = 29;
people["zaphod"] = 304;
people["marvin"] = 1000001;


db = new ODBC("freeswitchdb", "freeswitch", "1234");
db.connect();

db.exec("create table demo (name varchar(255), age varchar(80));");

for (var i in people) {
sql = "insert into demo values('" + i + "', " + people[i] + ");";
console_log("debug", sql + "\n");
db.exec(sql);
}

sql = "select * from demo;";
var line = "==============================\n";

console_log("notice", line);

db.exec(sql);

console_log("debug", "row count: " + db.numRows() + "\n");

while(db.nextRow()) {
var row = db.getData();

for (var i in row) {
console_log("debug", "[" + i + "] = [" + row[i] + "]\n");
}

console_log("debug", "\n");
}



console_log("notice", line);

what should i specify in DSN.here i gave freeswitchdb which is a database
name.please assist me to solve this problem

Thanks
--
View this message in context: http://www.nabble.com/Error-loading-ODBC-tp19665456p19665456.html
Sent from the Freeswitch-users mailing list archive at Nabble.com.
Michael Jerris
2008-09-25 09:03:25 UTC
Permalink
Post by preetha
Hi,
when i try to run a sample odbc code from freeswitch console like
freeswitch at localhost> jsrun odbc.js
OK
3303
js_api_use() Error loading ODBC
2008-09-25 19:44:35 [ERR] odbc.js:11 mod_spidermonkey()
ODBC is not defined
Make sure you have mod_spidermonkey_odbc loaded in your
spidermonkey.conf.xml file

Mike
preetha Ayyappan
2008-09-25 12:08:12 UTC
Permalink
You mean i have to uncomment the line <load
module="mod_spidermonkey_odbc"/>.?
yes.I have uncommented that line.eventhough the same error occurs
Post by Michael Jerris
Post by preetha
Hi,
when i try to run a sample odbc code from freeswitch console like
freeswitch at localhost> jsrun odbc.js
OK
3303
js_api_use() Error loading ODBC
2008-09-25 19:44:35 [ERR] odbc.js:11 mod_spidermonkey()
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 at 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20080925/640e4b75/attachment.html
Raymond Chandler
2008-09-25 14:50:19 UTC
Permalink
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
Post by preetha Ayyappan
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 at jerris.com
Post by preetha
Hi,
when i try to run a sample odbc code from freeswitch console like
freeswitch at localhost> jsrun odbc.js
OK
3303
js_api_use() Error loading ODBC
2008-09-25 19:44:35 [ERR] odbc.js:11 mod_spidermonkey()
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 at lists.freeswitch.org
<mailto:Freeswitch-users at 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 at lists.freeswitch.org
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
http://www.freeswitch.org
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20080925/fd96377b/attachment.html
preetha Ayyappan
2008-09-26 09:27:24 UTC
Permalink
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
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
You mean i have to uncomment the line <load
module="mod_spidermonkey_odbc"/>.?
yes.I have uncommented that line.eventhough the same error occurs
Post by Michael Jerris
Post by preetha
Hi,
when i try to run a sample odbc code from freeswitch console like
freeswitch at localhost> jsrun odbc.js
OK
3303
js_api_use() Error loading ODBC
2008-09-25 19:44:35 [ERR] odbc.js:11 mod_spidermonkey()
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 at 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 listFreeswitch-users at lists.freeswitch.orghttp://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-usershttp://www.freeswitch.org
_______________________________________________
Freeswitch-users mailing list
Freeswitch-users at 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20080926/1c5c026b/attachment.html
David Knell
2008-09-26 09:46:33 UTC
Permalink
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
Post by preetha Ayyappan
yes, I did ./configure --enable-core-odbc-support && make && make
install.When i gave make install during installation,i found the
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 at freeswitch.org
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
Post by preetha Ayyappan
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 at jerris.com
Post by preetha
Hi,
when i try to run a sample odbc code from freeswitch console
like
Post by preetha
freeswitch at localhost> jsrun odbc.js
OK
freeswitch at localhost> 2008-09-25 19:44:35 [ERR]
3303
js_api_use() Error loading ODBC
2008-09-25 19:44:35 [ERR] odbc.js:11 mod_spidermonkey()
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 at lists.freeswitch.org
<mailto:Freeswitch-users at lists.freeswitch.org>
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
http://www.freeswitch.org <http://www.freeswitch.org/>
--
Preetha.A
------------------------------------------------------------------------
_______________________________________________
Freeswitch-users mailing list
Freeswitch-users at lists.freeswitch.org <mailto:Freeswitch-users at lists.freeswitch.org>
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
http://www.freeswitch.org <http://www.freeswitch.org/>
_______________________________________________
Freeswitch-users mailing list
Freeswitch-users at lists.freeswitch.org
<mailto:Freeswitch-users at lists.freeswitch.org>
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
http://www.freeswitch.org <http://www.freeswitch.org/>
--
Preetha.A
------------------------------------------------------------------------
_______________________________________________
Freeswitch-users mailing list
Freeswitch-users at lists.freeswitch.org
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
http://www.freeswitch.org
--
David Knell, Director, 3C Limited
T: 020 8114 8901 F: 020 3002 7257 M: 001 415 630 3031
http://www.3c.co.uk

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20080926/16bab796/attachment-0001.html
preetha Ayyappan
2008-09-29 06:45:13 UTC
Permalink
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 at 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.
Post by David Knell
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
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
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
You mean i have to uncomment the line <load
module="mod_spidermonkey_odbc"/>.?
yes.I have uncommented that line.eventhough the same error occurs
Post by Michael Jerris
Post by preetha
Hi,
when i try to run a sample odbc code from freeswitch console like
freeswitch at localhost> jsrun odbc.js
OK
3303
js_api_use() Error loading ODBC
2008-09-25 19:44:35 [ERR] odbc.js:11 mod_spidermonkey()
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 at 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 listFreeswitch-users at lists.freeswitch.orghttp://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-usershttp://www.freeswitch.org
_______________________________________________
Freeswitch-users mailing list
Freeswitch-users at 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 listFreeswitch-users at lists.freeswitch.orghttp://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-usershttp://www.freeswitch.org
--
David Knell, Director, 3C Limited
T: 020 8114 8901 F: 020 3002 7257 M: 001 415 630 3031http://www.3c.co.uk
_______________________________________________
Freeswitch-users mailing list
Freeswitch-users at 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20080929/77fe37fa/attachment-0001.html
Michael Jerris
2008-09-29 06:59:27 UTC
Permalink
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.
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
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
Post by preetha Ayyappan
yes, I did ./configure --enable-core-odbc-support && make && make
install.When i gave make install during installation,i found the
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
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
Post by preetha Ayyappan
You mean i have to uncomment the line <load
module="mod_spidermonkey_odbc"/>.?
yes.I have uncommented that line.eventhough the same error occurs
Post by preetha
Hi,
when i try to run a sample odbc code from freeswitch console like
freeswitch at localhost> jsrun odbc.js
OK
freeswitch at localhost> 2008-09-25 19:44:35 [ERR]
3303
js_api_use() Error loading ODBC
2008-09-25 19:44:35 [ERR] odbc.js:11 mod_spidermonkey()
ODBC is not defined
Make sure you have mod_spidermonkey_odbc loaded in your
spidermonkey.conf.xml file
Mike
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20080929/4e3f301a/attachment.html
preetha Ayyappan
2008-09-29 07:14:40 UTC
Permalink
Thanks.I have uncommented the line yoy specified and run the program
sample.js from the freeswitch console.It shows the following error:
freeswitch at 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
Post by preetha Ayyappan
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.
freeswitch at 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
Post by David Knell
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
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
Post by Raymond Chandler
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
You mean i have to uncomment the line <load
module="mod_spidermonkey_odbc"/>.?
yes.I have uncommented that line.eventhough the same error occurs
Post by Michael Jerris
Post by preetha
Hi,
when i try to run a sample odbc code from freeswitch console like
freeswitch at localhost> jsrun odbc.js
OK
3303
js_api_use() Error loading ODBC
2008-09-25 19:44:35 [ERR] odbc.js:11 mod_spidermonkey()
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 at 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20080929/50ae1209/attachment.html
Michael Jerris
2008-09-29 07:31:56 UTC
Permalink
Post by preetha Ayyappan
Thanks.I have uncommented the line yoy specified and run the program
freeswitch at 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
The error above is from odbc your specifying a data source that is not
configured in odbc.
Post by preetha Ayyappan
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!
Ken Rice
2008-09-29 07:30:52 UTC
Permalink
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 at gmail.com>
Reply-To: <freeswitch-users at lists.freeswitch.org>
Date: Mon, 29 Sep 2008 12:44:40 +0530
To: <freeswitch-users at 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 at 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
Post by Michael Jerris
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.
freeswitch at localhost> 2008-09-29 17:44:12 [ERR] mod_spidermonkey.c:3303
js_api_use() Error loading ODBC
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
Post by David Knell
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
Post by preetha Ayyappan
yes, I did ./configure --enable-core-odbc-support && make && make
install.When i gave make install during installation,i found the following
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
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
Post by preetha Ayyappan
You mean i have to uncomment the line <load
module="mod_spidermonkey_odbc"/>.?
yes.I have uncommented that line.eventhough the same error occurs
Post by Michael Jerris
Post by preetha
Hi,
when i try to run a sample odbc code from freeswitch console like
freeswitch at localhost> jsrun odbc.js
OK
3303
js_api_use() Error loading ODBC
2008-09-25 19:44:35 [ERR] odbc.js:11 mod_spidermonkey()
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 at 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 at lists.freeswitch.org
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
http://www.freeswitch.org
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20080929/ee5abbf5/attachment-0001.html
preetha Ayyappan
2008-09-29 07:35:41 UTC
Permalink
Yes. I have uncommented that line before installing itself.Even though i am
getting the same error.
Post by Ken Rice
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 at gmail.com>
*Reply-To: *<freeswitch-users at lists.freeswitch.org>
*Date: *Mon, 29 Sep 2008 12:44:40 +0530
*To: *<freeswitch-users at lists.freeswitch.org>
*Subject: *Re: [Freeswitch-users] Error loading ODBC
Thanks.I have uncommented the line yoy specified and run the program
freeswitch at 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
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.
freeswitch at localhost> 2008-09-29 17:44:12 [ERR] mod_spidermonkey.c:3303
js_api_use() Error loading ODBC
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
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
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
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
You mean i have to uncomment the line <load
module="mod_spidermonkey_odbc"/>.?
yes.I have uncommented that line.eventhough the same error occurs
Post by preetha
Hi,
when i try to run a sample odbc code from freeswitch console like
freeswitch at localhost> jsrun odbc.js
OK
3303
js_api_use() Error loading ODBC
2008-09-25 19:44:35 [ERR] odbc.js:11 mod_spidermonkey()
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 at 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 at 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 at 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20080929/207cab06/attachment.html
preetha Ayyappan
2008-09-29 07:36:51 UTC
Permalink
Where should i configure the data source name in odbc?

On Mon, Sep 29, 2008 at 1:05 PM, preetha Ayyappan <
Post by preetha Ayyappan
Yes. I have uncommented that line before installing itself.Even though i am
getting the same error.
Post by Ken Rice
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 at gmail.com>
*Reply-To: *<freeswitch-users at lists.freeswitch.org>
*Date: *Mon, 29 Sep 2008 12:44:40 +0530
*To: *<freeswitch-users at lists.freeswitch.org>
*Subject: *Re: [Freeswitch-users] Error loading ODBC
Thanks.I have uncommented the line yoy specified and run the program
freeswitch at 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
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.
freeswitch at localhost> 2008-09-29 17:44:12 [ERR] mod_spidermonkey.c:3303
js_api_use() Error loading ODBC
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
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
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
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
You mean i have to uncomment the line <load
module="mod_spidermonkey_odbc"/>.?
yes.I have uncommented that line.eventhough the same error occurs
Post by preetha
Hi,
when i try to run a sample odbc code from freeswitch console like
freeswitch at localhost> jsrun odbc.js
OK
3303
js_api_use() Error loading ODBC
2008-09-25 19:44:35 [ERR] odbc.js:11 mod_spidermonkey()
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 at 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 at 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 at 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20080929/014688a4/attachment-0001.html
Ken Rice
2008-09-29 07:31:51 UTC
Permalink
Actually on closer look... Theres your problem looks like you don?t have a
DSN configured in your odbc.ini... Make sure your unixODBC installtion is
correctly configured and isql can connect to the dsn



From: preetha Ayyappan <preetha.ayyappan at gmail.com>
Reply-To: <freeswitch-users at lists.freeswitch.org>
Date: Mon, 29 Sep 2008 12:44:40 +0530
To: <freeswitch-users at 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 at 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
Post by Michael Jerris
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.
freeswitch at localhost> 2008-09-29 17:44:12 [ERR] mod_spidermonkey.c:3303
js_api_use() Error loading ODBC
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
Post by David Knell
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
Post by preetha Ayyappan
yes, I did ./configure --enable-core-odbc-support && make && make
install.When i gave make install during installation,i found the following
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
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
Post by preetha Ayyappan
You mean i have to uncomment the line <load
module="mod_spidermonkey_odbc"/>.?
yes.I have uncommented that line.eventhough the same error occurs
Post by Michael Jerris
Post by preetha
Hi,
when i try to run a sample odbc code from freeswitch console like
freeswitch at localhost> jsrun odbc.js
OK
3303
js_api_use() Error loading ODBC
2008-09-25 19:44:35 [ERR] odbc.js:11 mod_spidermonkey()
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 at 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 at lists.freeswitch.org
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
http://www.freeswitch.org
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20080929/c57c18d4/attachment.html
Ken Rice
2008-09-29 08:32:55 UTC
Permalink
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 at gmail.com>
Reply-To: <freeswitch-users at lists.freeswitch.org>
Date: Mon, 29 Sep 2008 13:06:51 +0530
To: <freeswitch-users at 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
Post by preetha Ayyappan
Yes. I have uncommented that line before installing itself.Even though i am
getting the same error.
Post by Ken Rice
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 at gmail.com>
Reply-To: <freeswitch-users at lists.freeswitch.org>
Date: Mon, 29 Sep 2008 12:44:40 +0530
To: <freeswitch-users at lists.freeswitch.org>
Subject: Re: [Freeswitch-users] Error loading ODBC
Thanks.I have uncommented the line yoy specified and run the program
freeswitch at 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
Post by Michael Jerris
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.
freeswitch at localhost> 2008-09-29 17:44:12 [ERR] mod_spidermonkey.c:3303
js_api_use() Error loading ODBC
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
Post by David Knell
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
Post by preetha Ayyappan
yes, I did ./configure --enable-core-odbc-support && make && make
install.When i gave make install during installation,i found the
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
Post by Raymond Chandler
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
You mean i have to uncomment the line <load
module="mod_spidermonkey_odbc"/>.?
yes.I have uncommented that line.eventhough the same error occurs
Post by preetha
Hi,
when i try to run a sample odbc code from freeswitch console like
freeswitch at localhost> jsrun odbc.js
OK
3303
js_api_use() Error loading ODBC
2008-09-25 19:44:35 [ERR] odbc.js:11 mod_spidermonkey()
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 at 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 at 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 at 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 at lists.freeswitch.org
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
http://www.freeswitch.org
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20080929/73361984/attachment-0001.html
B Karthik
2008-09-29 08:38:43 UTC
Permalink
This link should help you through that. It did for me :)

http://www.debian-administration.org/articles/496

B Karthik



On Mon, Sep 29, 2008 at 2:03 PM, <
Send Freeswitch-users mailing list submissions to
freeswitch-users at lists.freeswitch.org
To subscribe or unsubscribe via the World Wide Web, visit
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
or, via email, send a message with subject or body 'help' to
freeswitch-users-request at lists.freeswitch.org
You can reach the person managing the list at
freeswitch-users-owner at lists.freeswitch.org
When replying, please edit your Subject line so it is more specific
than "Re: Contents of Freeswitch-users digest..."
1. Re: Load test - performance not even matching Asterisk (Ken Rice)
2. Re: Error loading ODBC (Ken Rice)
---------- Forwarded message ----------
From: Ken Rice <krice at suspicious.org>
To: <freeswitch-users at lists.freeswitch.org>
Date: Mon, 29 Sep 2008 02:40:10 -0500
Subject: Re: [Freeswitch-users] Load test - performance not even matching
Asterisk
What he means by 64bit is are you using a 64bit of fedora? If not grab
the centos5 64bit iso and try that...
Also, several things upto and including hard disk access times can greatly
affect the number of calls/sec and other things...
And yes freeswitch can greatly outperform asterisk by an order of
magnitude... We routinely route 2000 concurrent calls
------------------------------
*From: *Jon Bruel <jbr at consiglia.dk>
*Reply-To: *<freeswitch-users at lists.freeswitch.org>
*Date: *Mon, 29 Sep 2008 09:31:54 +0200
*To: *<freeswitch-users at lists.freeswitch.org>
*Subject: *Re: [Freeswitch-users] Load test - performance not even
matching Asterisk
Regarding the 32bit vs. 64bit questions, I'm a bit uncertain about how I
cpu family : 6
model : 15
flags : fpu vme de pse tsc msr pae mce cx8 apic mtrr pge mca cmov
pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe nx lm constant_tsc
arch_perfmon pebs bts pni monitor ds_cpl est tm2 ssse3 cx16 xtpr lahf_lm
uname ?ar gives: Linux econel2.everdance.com 2.6.25.9-40.fc8 #1 SMP Fri
Jun 27 16:25:53 EDT 2008 i686 i686 i386 GNU/Linux.
With respect to compiling the FS, I have not been aware of any options, so
I just did the standard: bootstrap.sh, configure, make and make install.
I have tried to configure with some 64bit flags: CFLAGS="-m64 -fast"
CXXFLAGS="-m64 -fast" LDFLAGS="-m64" ./configure --prefix=/opt/freeswitch
--enable-core-odbc-support --enable-core-libedit-support --enable-64
checking for C compiler default output file name...
configure: error: C compiler cannot create executables
so I may need to install some 64bit libraries? If so some hints would be
great! /Jon
------------------------------
_______________________________________________
Freeswitch-users mailing list
Freeswitch-users at lists.freeswitch.org
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
http://www.freeswitch.org
---------- Forwarded message ----------
From: Ken Rice <krice at suspicious.org>
To: <freeswitch-users at lists.freeswitch.org>
Date: Mon, 29 Sep 2008 03:32:55 -0500
Subject: Re: [Freeswitch-users] Error loading ODBC
Refer to one of the many unixODBC howtos like the one found here
http://developer.mimer.com/howto/howto_57.htm
------------------------------
*From: *preetha Ayyappan <preetha.ayyappan at gmail.com>
*Reply-To: *<freeswitch-users at lists.freeswitch.org>
*Date: *Mon, 29 Sep 2008 13:06:51 +0530
*To: *<freeswitch-users at 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 <
Yes. I have uncommented that line before installing itself.Even though i am
getting the same error.
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 at gmail.com>
*Reply-To: *<freeswitch-users at lists.freeswitch.org>
*Date: *Mon, 29 Sep 2008 12:44:40 +0530
*To: *<freeswitch-users at lists.freeswitch.org>
*Subject: *Re: [Freeswitch-users] Error loading ODBC
Thanks.I have uncommented the line yoy specified and run the program
freeswitch at 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
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.
freeswitch at localhost> 2008-09-29 17:44:12 [ERR] mod_spidermonkey.c:3303
js_api_use() Error loading ODBC
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
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
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
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
You mean i have to uncomment the line <load
module="mod_spidermonkey_odbc"/>.?
yes.I have uncommented that line.eventhough the same error occurs
Post by preetha
Hi,
when i try to run a sample odbc code from freeswitch console like
freeswitch at localhost> jsrun odbc.js
OK
3303
js_api_use() Error loading ODBC
2008-09-25 19:44:35 [ERR] odbc.js:11 mod_spidermonkey()
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 at 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 at 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 at 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 at 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 at lists.freeswitch.org
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
http://www.freeswitch.org
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20080929/91a0c6a7/attachment-0001.html
Loading...