Forum OpenACS Q&A: nspostgres.so

Collapse
Posted by Ashish Pande on
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
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
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
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
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.