Forum OpenACS Q&A: AOLserver3.2 /Postgres.so load problem

Collapse
Posted by Jamie Ross on
 
well.. finally making the upgrade to AOLserver 3.2 on my new server and while Postgres installed just fine, I am having problems with the driver.   When it tries to load the postgres.so driver it fails saying it cant find the library file , libpq.so.2.1.   I have double check environment but no joy. Anyway,  I would certainly appreciate any ideas anyone has...  The error I keep getting is as follows: 
 
[28/Nov/2000:01:07:20][6012.1024][-main-] Warning: modload: failed to load '/usr/local/aolserver3_2/bin/postgres.so': 'libpq.so.2.1: 
 cannot open shared object file: No such file or directory' 
[28/Nov/2000:01:07:20][6012.1024][-main-] Error: dbdrv: failed to load driver 'postgres' 
 
I checked to make sure PGLIB is defined for nsadmin and libpq.so.2.1 does exist and symbolic links all exist etc. and they do.  LD_LIBRARY_PATH is also defined for /usr/local/pgsql/lib etc.. I also recompiled the driver several times makig sure the right path was defined in the makefile 
 
I know I am missing something obvious.  This was working fine on my other server. I am running 2.2.13 
 
lexx:/usr/local$ ls -l $PGLIB 
total 1768 
-r--r--r--   1 postgres users         628 Nov  1 15:16 global1.bki.source 
-r--r--r--   1 postgres users           0 Nov  1 15:16 global1.description 
-rw-r--r--   1 postgres users       37422 Nov  1 15:16 libecpg.a 
lrwxrwxrwx   1 postgres users          16 Nov  1 15:16 libecpg.so -> libecpg.so.3.1.1 
lrwxrwxrwx   1 postgres users          16 Nov  1 15:16 libecpg.so.3 -> libecpg.so.3.1.1 
-rw-r--r--   1 postgres users       28681 Nov  1 15:16 libecpg.so.3.1.1 
-rw-r--r--   1 postgres users        6432 Nov  1 15:16 libpgeasy.a 
lrwxrwxrwx   1 postgres users          16 Nov  1 15:16 libpgeasy.so -> libpgeasy.so.2.1 
lrwxrwxrwx   1 postgres users          16 Nov  1 15:16 libpgeasy.so.2 -> libpgeasy.so.2.1 
-rw-r--r--   1 postgres users        7450 Nov  1 15:16 libpgeasy.so.2.1 
-rw-r--r--   1 postgres users       27316 Nov  1 15:16 libpgtcl.a 
lrwxrwxrwx   1 postgres users          15 Nov  1 15:16 libpgtcl.so -> libpgtcl.so.2.1 
lrwxrwxrwx   1 postgres users          15 Nov  1 15:16 libpgtcl.so.2 -> libpgtcl.so.2.1 
-rw-r--r--   1 postgres users       28491 Nov  1 15:16 libpgtcl.so.2.1 
-rw-r--r--   1 postgres users      497368 Nov  1 15:16 libpq++.a 
lrwxrwxrwx   1 postgres users          14 Nov  1 15:16 libpq++.so -> libpq++.so.3.1 
lrwxrwxrwx   1 postgres users          14 Nov  1 15:16 libpq++.so.3 -> libpq++.so.3.1 
-rw-r--r--   1 postgres users      277704 Nov  1 15:16 libpq++.so.3.1 
-rw-r--r--   1 postgres users       65826 Nov  1 15:16 libpq.a 
lrwxrwxrwx   1 postgres users          12 Nov  1 15:16 libpq.so -> libpq.so.2.1 
lrwxrwxrwx   1 postgres users          12 Nov  1 15:16 libpq.so.2 -> libpq.so.2.1 
lrwxrwxrwx   1 postgres users          12 Nov 27 19:05 libpq.so.2.0 -> libpq.so.2.1 
-rw-r--r--   1 postgres users       57276 Nov  1 15:16 libpq.so.2.1 
-rw-r--r--   1 postgres users      209190 Nov  1 15:16 libpsqlodbc.a 
lrwxrwxrwx   1 postgres users          19 Nov  1 15:16 libpsqlodbc.so -> libpsqlodbc.so.0.26 
lrwxrwxrwx   1 postgres users          19 Nov  1 15:16 libpsqlodbc.so.0 -> libpsqlodbc.so.0.26 
-rw-r--r--   1 postgres users      155990 Nov  1 15:16 libpsqlodbc.so.0.26 
-r--r--r--   1 postgres users      183974 Nov  1 15:16 local1_template1.bki.source 
-r--r--r--   1 postgres users       24692 Nov  1 15:16 local1_template1.description 
-r--r--r--   1 postgres users        3407 Nov  1 15:16 pg_geqo.sample 
-r--r--r--   1 postgres users        5729 Nov  1 15:16 pg_hba.conf.sample 
-r--r--r--   1 postgres users         882 Nov  1 15:16 pg_ident.conf.sample 
-r--r--r--   1 postgres users        7643 Nov  1 15:16 pg_options.sample 
-rw-r--r--   1 postgres users       71706 Nov  1 15:16 plpgsql.so 
-rw-r--r--   1 postgres users       30569 Nov  1 15:16 pltcl.so 
-r--r--r--   1 postgres users           1 Nov  1 15:16 postmaster.opts.default.sample 
 
printenv is as follows: 
 
PWD=/usr/local 
REMOTEHOST=arthur.starboundtech.com 
HZ=100 
HOSTNAME=lexx.starboundtech.com 
MOZILLA_HOME=/usr/lib/netscape 
LD_LIBRARY_PATH=/usr/local/pgsql/lib 
ignoreeof=10 
LS_OPTIONS= --color=auto -F -b -T 0 
QTDIR=/usr/lib/qt 
OPENWINHOME=/usr/openwin 
MITSCHEME_6001_DIRECTORY=/usr/local/courses/6.001 
MANPATH=/usr/local/man:/usr/man/preformat:/usr/man:/usr/X11R6/man:/usr/openwin/man:/usr/share/texmf/man 
LESSOPEN=|lesspipe.sh %s 
PS1=h:w$ 
PGINC=/usr/local/pgsql/include 
PS2=> 
KDEDIR=/opt/kde 
LESS=-M 
USER=nsadmin 
LS_COLORS= 
CPLUS_INCLUDE_PATH=/usr/lib/qt/include: 
MACHTYPE=i386-slackware-linux-gnu 
MAIL=/var/spool/mail/nsadmin 
OLDPWD=/home/nsadmin 
ORACLE_HOME=/ora8/m01/app/oracle/product/8.1.6 
LOGNAME=nsadmin 
SHLVL=1 
HUSHLOGIN=FALSE 
MINICOM=-c on 
POSTGRESQL_HOME=/usr/local/pgsql 
SHELL=/bin/bash 
PGLIB=/usr/local/pgsql/lib 
HOSTTYPE=i386 
OSTYPE=linux-gnu 
TERM=vt220 
HOME=/home/nsadmin 
PATH=/usr/local/bin:/usr/bin:/bin:/usr/X11R6/bin:/usr/openwin/bin:/usr/local/pgsql/bin:/usr/games:.:/opt/kde/bin:/usr/share/texmf/bi 
n