Mapserv looking for libpq.so.3 for postgresql 8.1.2

Tue Feb 7 16:20:28 EST 2006

I just installed postgresql 8.1.2 and Postgis 1.1.1. I completely deleted my
/usr/local/pgsql directory prior to installing postgresql 8.1.2 and only
/usr/local/pgsql/lib/libpq.so.4 was build. No libpq.so.3 was built like in
postgresql 7.X. I tried both mapserver 4.4.2 and 4.6.2 which give me the
following error message in the httpd error_log when trying to run mapscript
in perl:

Can't load
'/usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/auto/mapscript/mapsc
ript.so' for
module mapscript: libpq.so.3: cannot open shared object file: No such file
or
directory at /usr/lib/perl5/5.8.0/i386-linux-thread-multi/DynaLoader.pm line
229.
[Wed Feb 01 18:11:00 2006] [error] [client 192.168.119.112]  at
/usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/mapscript.pm line 7

When I look at what  libraries that are required for mapserv I see libpq.3
is
trying to be loaded:
[root at WIRH90 mapserver-4.6.2]# ldd mapserv
        libgd.so.2 => /usr/local/lib/libgd.so.2 (0x4002a000)
        libjpeg.so.62 => /usr/local/lib/libjpeg.so.62 (0x40062000)
        libfreetype.so.6 => /usr/lib/libfreetype.so.6 (0x4007f000)
        libpng12.so.0 => /usr/lib/libpng12.so.0 (0x400d0000)
        libz.so.1 => /usr/lib/libz.so.1 (0x400f3000)
        libpdf.so.1 => /usr/local/lib/libpdf.so.1 (0x40101000)
        libproj.so.0 => /usr/local/lib/libproj.so.0 (0x40190000)
        libgdal.1.1.so => /usr/local/lib/libgdal.1.1.so (0x401c4000)
        libpq.so.4 => /usr/local/pgsql/lib/libpq.so.4 (0x40467000)
        libcurl.so.2 => /usr/local/lib/libcurl.so.2 (0x4047e000)
        libssl.so.4 => /lib/libssl.so.4 (0x404a7000)
        libcrypto.so.4 => /lib/libcrypto.so.4 (0x404dc000)
        libdl.so.2 => /lib/libdl.so.2 (0x405ce000)
        libgssapi_krb5.so.2 => /usr/kerberos/lib/libgssapi_krb5.so.2
(0x405d2000)
        libkrb5.so.3 => /usr/kerberos/lib/libkrb5.so.3 (0x405e5000)
        libcom_err.so.3 => /usr/kerberos/lib/libcom_err.so.3 (0x40643000)
        libk5crypto.so.3 => /usr/kerberos/lib/libk5crypto.so.3 (0x40645000)
        libresolv.so.2 => /lib/libresolv.so.2 (0x40655000)
        libc.so.6 => /lib/tls/libc.so.6 (0x42000000)
        libm.so.6 => /lib/tls/libm.so.6 (0x40668000)
        libstdc++.so.5 => /usr/lib/libstdc++.so.5 (0x4068a000)
        libpthread.so.0 => /lib/tls/libpthread.so.0 (0x4073d000)
        libXpm.so.4 => /usr/X11R6/lib/libXpm.so.4 (0x4074b000)
        libX11.so.6 => /usr/X11R6/lib/libX11.so.6 (0x4075a000)
        libpq.so.3 => not found
        libclntsh.so.9.0 => /usr/local/lib/libclntsh.so.9.0 (0x4083a000)
        libungif.so.4 => /usr/lib/libungif.so.4 (0x41147000)
        libgcc_s.so.1 => /lib/libgcc_s.so.1 (0x4114f000)
        libcrypt.so.1 => /lib/libcrypt.so.1 (0x41157000)
        libnsl.so.1 => /lib/libnsl.so.1 (0x41185000)
        /lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0x40000000)
        libXext.so.6 => /usr/X11R6/lib/libXext.so.6 (0x4119a000)
        libwtc9.so => /oracle/9.2.0/lib/libwtc9.so (0x411a8000)

Here is my DBD_pg test of the install and I'm using DBI 1.50
        [root at WIRH90 DBD-Pg-1.43]# make test
PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e"
"test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
t/00basic...........ok
t/01connect.........ok 1/8#
# Program               Version
# Perl                  5.8.0 (linux)
# DBD::Pg               1.43
# PostgreSQL (compiled) 80102
# PostgreSQL (target)   80102
# PostgreSQL (reported) PostgreSQL 8.1.2 on i686-pc-linux-gnu, compiled by
GCC gcc (GCC) 3.2.2 20030222 (Red Hat Linux 3.2.2-5)
# DBI                   1.50
# DBI_DSN               dbi:Pg:dbname=gisdb
t/01connect.........ok
t/01constants.......ok
t/01setup...........ok
t/02attribs.........ok
t/03dbmethod........ok
t/03smethod.........ok
t/04misc............ok
t/05arrays..........ok
        15/17 skipped: Array support not implemented
t/06bytea...........ok
t/07copy............ok
t/12placeholders....ok
t/20savepoints......ok
t/99_pod............skipped
        all skipped: Test::Pod 0.95 required for testing POD
t/99cleanup.........ok
All tests successful, 1 test and 15 subtests skipped.
Files=15, Tests=417,  9 wallclock secs ( 5.64 cusr +  0.42 csys =  6.06 CPU)
[root at WIRH90 DBD-Pg-1.43]#

Postgis test out fine in the install and I wrote a perl script to test some
of the functionality like "GeometryFromText" an d"AsText" function and they
work fine.
[postgres at WIRH90 postgis-1.1.1]$ make test
make -C regress test
make[1]: Entering directory
`/usr/local/src/postgresql-8.1.2/contrib/postgis-1.1.1/regress'

 PostgreSQL 8.1.2 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2.2
20030222 (Red Hat Linux 3.2.2-5)
 Postgis 1.1.1 - 2006-02-07 14:30:47
   GEOS: 2.2.1-CAPI-1.0.1
   PROJ: Rel. 4.4.9, 29 Oct 2004

Running tests

           regress: Ok.
     regress_index: Ok.
    lwgeom_regress: Ok.
       regress_lrs: Ok.
       removepoint: Ok.
          setpoint: Ok.
          simplify: Ok.
       regress_ogc: Ok.
    regress_bdpoly: Ok.
      regress_proj: Ok.

Run tests: 10
Successful: 10
Failed: 0
make[1]: Leaving directory
`/usr/local/src/postgresql-8.1.2/contrib/postgis-1.1.1/regress'
[postgres at WIRH90 postgis-1.1.1]$
  I tried building mapserver with
"./configure --with-postgis=/usr/local/pgsql/bin/pg_config" or
"./configure --with-postgis" and in both cases it says it fines my pg_config
file. Why is mapserv trying to load libpq.so.3 when it's not used anymore in
postgresql 8.X? I don't know where it can be picking up this name. If I do a
"locate libpq.so.3" nothing is found even after I do an "updatedb" or do a
"ldconfig -v". I even added in my env variables just to be sure:

  POSTGRES_HOME=    /usr/local/pgsql

  POSTGRES_LIB=    /usr/local/pgsql/lib

  POSTGRES_INCLUDE=    /usr/local/pgsql/include

  Has anyone else experienced this? Thanks in advance.

  Tom

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapserver-users/attachments/20060207/dd89a324/attachment.html