Forum OpenACS Q&A: nspostgres.so

1: nspostgres.so

Posted by Ashish Pande on 02/26/01 11:24 AM

I am using
1.Red Hat Linux 6.2,
2.Postgres 6.5.3 for Linux that comes with Red Hat Linux 6.2 CD,
3.AOLServer Server 3.2 + ad patch 12, from Arsdigita.com,
4.PGDriver v 1.1.0 from openacs.org.
& following all the steps of OpenACS installation given openacs.org
site.
I am not able to complie the Postgres driver to make nspostgres.so.
Can any one point to a url from where I can download it?

<P.S.> For ACS 4.0 the Oracle Driver for AOLServer is avilable in
Binary from from arsdigita.com & that makes the installation process
very easy, do we have the same for Postgres & AOLServer also??

Thanks,
Ashish.

2: Response to nspostgres.so (response to 1)

Posted by Mohan Pakkurti on 02/26/01 11:54 AM

What is the actual error that you get when you try to compile the postgres driver?

maybe you want to post the error messages...

3: Response to nspostgres.so (response to 1)

Posted by Ashish Pande on 02/26/01 12:53 PM

This the error that I am getting:
**********************************************************************
[nsadmin@openacs pgdriver-1.1]$ pwd
/tmp/root/aolserver/pgdriver-1.1

[nsadmin@openacs pgdriver-1.1]$ ls -al
total 92
drwxrwxr-x 2 nsadmin nsadmin 4096 Aug 12 2000 .
drwxrwxr-x 23 nsadmin nsadmin 4096 Feb 26 16:49 ..
-rw-rwxr-- 1 nsadmin nsadmin 3094 Mar 25 2000 makefile
-rw-rw-r-- 1 nsadmin nsadmin 22972 Dec 7 1999 postgres-backup.c
-rw-rwxr-- 1 nsadmin nsadmin 52222 Jun 30 2000 postgres.c

[nsadmin@openacs pgdriver-1.1]$ make all
gcc -DFOR_ACS_USE -I/include -Wall -fpic -shared -I/usr/local/pgsql/include -I/h
ome/nsadmin/include -I-/usr/include -c -o postgres.o postgres.c
postgres.c:33: ns.h: No such file or directory
postgres.c:40: nsdb.h: No such file or directory
postgres.c:41: nstcl.h: No such file or directory
postgres.c:44: libpq-fe.h: No such file or directory
make: *** [postgres.o] Error 1

[nsadmin@openacs pgdriver-1.1]$ make install
gcc -DFOR_ACS_USE -I/include -Wall -fpic -shared -I/usr/local/pgsql/include -I/h
ome/nsadmin/include -I-/usr/include -c -o postgres.o postgres.c
postgres.c:33: ns.h: No such file or directory
postgres.c:40: nsdb.h: No such file or directory
postgres.c:41: nstcl.h: No such file or directory
postgres.c:44: libpq-fe.h: No such file or directory
make: *** [postgres.o] Error 1

**********************************************************************

Thanks for having a look
Ashish

4: Response to nspostgres.so (response to 1)

Posted by Roberto Mello on 02/26/01 03:30 PM

Ashish,

You need to edit the Makefile and set the variables in it to the correct places where you have AOLserver sources and PostgreSQL libraries.

I don't suppose you've read the OpenACS Installation Guide (http://openacs.org/doc/openacs/install/x83.html#AEN96) have you? It walks you through compiling your driver.

BTW, the Makefile needs some restructuring and better commenting IMHO. I tried doing it a while back but as I didn't know all the details and didn't want mess it up, I gave up on it.

5: Response to nspostgres.so (response to 1)

Posted by Janine Ohmer on 02/27/01 04:50 PM

Ashish, you need to use a newer version of Postgres. Either the
latest release, which I think is 7.0.2, or the 7.1 beta. I'm pretty
sure that 6.5.3 won't work with OpenACS.