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
