VoIP Mailing List Archives

[xtpl.gayatri at gmail.com]

Hi all,

I want to connect to a remote database using javascript.
When i searched the WIki I got this page: http://wiki.freeswitch.org/wiki/Mod_spidermonkey_odbc#SpiderMonkey_ODBC
I did the steps what are mentioned there, namely:

1. First download and install unixodbc. See below if you are struggling with this step. Make sure to install headers, libraries and source for the unixodbc library set.
2. In the FreeSWITCH source directory, uncomment the languages/mod_spidermonkey_odbc line within the build/modules.conf file.
3. Compile core odbc support into freeswitch.

[miconda at gmail.com]

Hello,

On 10/06/08 16:42, Gayatri Kulkarni wrote:

[mike at jerris.com]

Your missing enable the module in spidermonkey.conf.xml


On Oct 6, 2008, at 9:42 AM, Gayatri Kulkarni wrote:

[xtpl.gayatri at gmail.com]

I did that too
I missed to mention it here

On Mon, Oct 6, 2008 at 9:03 PM, Michael Jerris <mike@jerris.com (mike@jerris.com)> wrote:

[xtpl.gayatri at gmail.com]

Thanks for pointing out Daniel,

It's not in modules.conf.xml
it's in the source directory's build/modules.conf.in - which source to compile to create the mod_spidermonkey_odbc.so, i.e. languages/mod_spidermonkey_odbc
The problem is, when i run make all install, it's not creating the .so

See the error message:
2008-10-06 19:01:43 [ERR] mod_spidermonkey.c:928 sm_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**

is there a way to compile and install this module separately?

--
Regards,
Gayatri Kulkarni

On Mon, Oct 6, 2008 at 9:01 PM, Daniel-Constantin Mierla <miconda@gmail.com (miconda@gmail.com)> wrote:

[brian at freeswitch.org]

Make sure in your root src folder modules.conf has it uncommented its built from build/modules.conf.in when you configure. Then "make mod_spidermonkey_odbc-install" also don't use make all install... use just "make install" or "make current" if you're updating.

/b

On Oct 7, 2008, at 12:35 AM, Gayatri Kulkarni wrote:

[xtpl.gayatri at gmail.com]

Still the same
It builds installs the shard library at {prefix}/freeswitch/lib directory
while all the modules .so files are in {prefix}/freeswitch/mod directory
If i copy the shared library to the mod directory, i get an error saying Invalid ELF Header !!

--
Regards,
Gayatri Kulkarni


On Tue, Oct 7, 2008 at 11:11 AM, Brian West <brian@freeswitch.org (brian@freeswitch.org)> wrote:

[xtpl.gayatri at gmail.com]

Thanks Brian!
make install worked


--
Regards,
Gayatri Kulkarni

On Tue, Oct 7, 2008 at 11:11 AM, Brian West <brian@freeswitch.org (brian@freeswitch.org)> wrote:

[brian at freeswitch.org]

thats because you don't load it in modules.conf.xml you load it in conf/autoload_configs/spidermonkey.conf.xml

/b

On Oct 7, 2008, at 12:52 AM, Gayatri Kulkarni wrote:

[xtpl.gayatri at gmail.com]

Guys,
I am now having this problem:
when i run my script i get this error -

freeswitch@fedora> 2008-10-07 17:27:24 [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
my ../etc/odbc.ini looks like this:[postgres]Driver = PostgreSQL SERVER = localhostPORT = 5432 DATABASE = postgresUserName = <username> Password = <password>
and ../etc/odbcinst.ini:
[ODBC] Trace = yesTraceFile = /tmp/trace.log [PostgreSQL]Description = PostgreSQL driver Driver = /usr/local/lib/libodbpsql.soSetup = /usr/local/lib/libodbpsqlS.so UsageCount = 1000000
--
Regards,
Gayatri Kulkarni

On Tue, Oct 7, 2008 at 11:32 AM, Brian West <brian@freeswitch.org (brian@freeswitch.org)> wrote:

[xtpl.gayatri at gmail.com]

If i have to run my script on Windows m/c, will i still need unixODBC?
Is unixODBC available for windows???

i know i am sounding stupid
But i need to get this done

[mike at jerris.com]

On Oct 7, 2008, at 9:34 AM, Gayatri Kulkarni wrote:

[xtpl.gayatri at gmail.com]

Well,
it didnt work as i hoped
first i had to add the DSN on my machine too for the remote database
then, when i did, it gave me this error:


freeswitch@Comp36> 2008-10-08 00:38:25 [ERR] switch_odbc.c:160 switch_odbc_handl e_connect() STATE: HY000 CODE 63 ERROR: [Microsoft][ODBC Microsoft Access Driver]General error Not enough information to connect to this DSN with SQLConnect. Use SQLDriverConnect.2008-10-08 00:38:25 [ERR] mod_spidermonkey_odbc.c:233 odbc_exec() Database is no t connected!2008-10-08 00:38:26 [ERR] mod_spidermonkey_odbc.c:289 odbc_next_row() Database i s not connected!
Any idea - what's happening?

Appreciating all your help,
--
Regards,
Gayatri Kulkarni

On Tue, Oct 7, 2008 at 7:23 AM, Michael Jerris <mike@jerris.com (mike@jerris.com)> wrote:

[xtpl.gayatri at gmail.com]

Guys please help me on this
I am still getting that error

freeswitch@fedora> 2008-10-07 17:27:24 [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

I can connect to the database successfully using isql -v commandI can't figure out whats going on Here's my script:

use("ODBC");

var DSN="PostgreSQL";
var DB_USER="<username>";
var DB_PASS="<password>";

var db = new ODBC(DSN, DB_USER, DB_PASS);
//console_log("notice",DB.path+"\n");
if(db.connect()){
console_log("notice","Connected to DB");
}
else{
console_log("notice","Still probs");
}

Here's the output:
freeswitch@fedora> 2008-10-10 15:41:32 [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-10-10 15:41:32 [NOTICE] testdb.js:1 console_log() Still probs

Please Help me Regards,Gayatri Kulkarni
On Tue, Oct 7, 2008 at 5:37 PM, Gayatri Kulkarni <xtpl.gayatri@gmail.com (xtpl.gayatri@gmail.com)> wrote:

[jonas.gauffin at gmail...]

your DSN name is "postgres" and not "PostgreSQL"

On Fri, Oct 10, 2008 at 12:34 PM, Gayatri Kulkarni <xtpl.gayatri@gmail.com (xtpl.gayatri@gmail.com)> wrote: