Forum OpenACS Q&A: nspostgres.so

Collapse
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.

Collapse
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...

Collapse
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

Collapse
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  (https://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.

Collapse
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.