Hi
I'm having quite a difficult time getting the nspostgres 3.5 driver to
load in AOLServer 3.5.1.
I am admittedly new to AOLServer, postgres and OACS, but have been
using various opensource packages on unix for ages.
I have lots of details on my problem and the steps I have been going
through to try to work it out. I don't know how much detail is needed
to get help so I'll try to keep it short on first pass and let you
helpful souls ask for details as it goes on. And I hope it doesn't go
on much longer!
I compile my nspostgres just fine ( if you don't count warnings about
"enc_one" and "get_one" with "different width due to prototype" -- just
warnings after all;( ) and it installs.
It doesn't link with nsdb as I notice is mentioned in an earlier
posting regarding another module:
As the other poster has mentioned, you'll need to explicitly link with
the
nsdb library. Hmmm. I need to check nspostgres for that linkage, too.
If I do "ldd nspostgres.so" however, libnsdb is not listed.
But when I run my AOLServer, I get the following errors in my log file:
[30/Dec/2002:15:08:59][28103.1024][-main-] Notice: modload: loading
'/usr/local/aolserver/bin/nspostgres.so'
[30/Dec/2002:15:08:59][28103.1024][-main-] Warning: modload: failed to
load '/usr/local/aolserver/bin/nspostgres.so': 'libpq.so.2: cannot
open shared object file: No such file or directory'
[30/Dec/2002:15:08:59][28103.1024][-main-] Error: dbdrv: failed to
load driver 'postgres'
[30/Dec/2002:15:08:59][28103.1024][-main-] Error: dbinit: no such
default pool 'pool1'
[30/Dec/2002:15:08:59][28103.1024][-main-] Debug: dbinit: no
configured pools
Now the libpq.so does exist and is readable by all.
Other info that supports the libpq.so is alright:
ldconfig -v | grep libpq
libpq.so.3 -> libpq.so.3.0
ldconfig sees libpq and it is also set in the shell script that starts
AOLServer (though it shouldn't need to be).
My nspostgres looks alright to me:
# ldd nspostgres.so
ldd /usr/local/aolserver/bin/nspostgres.so
libpq.so.3 => /usr/local/pgsql/lib/libpq.so.3 (0x4001e000)
libnsthread.so => /usr/local/aolserver/lib/libnsthread.so
(0x40030000)
libnsd.so => /usr/local/aolserver/lib/libnsd.so (0x40037000)
libtcl8.4.so => /usr/local/tcl/lib/libtcl8.4.so (0x40081000)
libdl.so.2 => /lib/libdl.so.2 (0x4011d000)
libpthread.so.0 => /lib/i686/libpthread.so.0 (0x40120000)
libm.so.6 => /lib/i686/libm.so.6 (0x40134000)
libc.so.6 => /lib/i686/libc.so.6 (0x42000000)
libcrypt.so.1 => /lib/libcrypt.so.1 (0x40157000)
libresolv.so.2 => /lib/libresolv.so.2 (0x40184000)
libnsl.so.1 => /lib/libnsl.so.1 (0x40195000)
/lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0x80000000)
# ls -l /usr/local/pgsql/lib/libpq.so.3
lrwxrwxrwx 1 root root 12 Jan 14 13:12
/usr/local/pgsql/lib/libpq.so.3 -> libpq.so.3.0
# ls -l /usr/local/pgsql/lib/libpq.so.3.0
-rwxr-xr-x 1 root root 81818 Jan 14 13:12
/usr/local/pgsql/lib/libpq.so.3.0
Executing "su nsadmin -c " nm /usr/local/pgsql/lib/libpq.so.3" returns
valid output so the library is not corrupted.
Linkage for my AOLServer:
LD_TRACE_LOADED_OBJECTS=true /usr/local/aolserver/bin/nsd -u nsadmin -t
~nsadmin/OpenACS4-config.tcl
libnsd.so => /usr/local/aolserver/lib/libnsd.so (0x40014000)
libnsthread.so => /usr/local/aolserver/lib/libnsthread.so
(0x4005f000)
libtcl8.4.so => /usr/local/tcl/lib/libtcl8.4.so (0x40066000)
libdl.so.2 => /lib/libdl.so.2 (0x40119000)
libpthread.so.0 => /lib/i686/libpthread.so.0 (0x4011c000)
libm.so.6 => /lib/i686/libm.so.6 (0x40130000)
libc.so.6 => /lib/i686/libc.so.6 (0x42000000)
/lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0x40000000)
Downloading and running a libpq test program from postgres
documentation online yields success using libpq!
Running a test using pqlib has no problems:
cc pq-test.c -I/usr/local/pgsql/include -o pq-test
-L/usr/local/pgsql/lib
-lpq
Links and runs, successfully finding and using the libpq shared library.
What am I missing about installing nspostgres with AOLServer?!
I just have to mention how much I hate seeing flippant quotes (in my
searches for help with this) from philg with arsdigita of late
mentioning how a "10 year old" can have a website up and running with
acs in few hours (or less). Argh:(
Thanks for ANY help!!! :)
t
btw, i'm over 10.
[EMAIL PROTECTED]
Subverge LLC
www.subverge.com
