<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE></TITLE>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2900.2802" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT size=2>I just installed postgresql 8.1.2 and Postgis 1.1.1. I
completely deleted my<BR>/usr/local/pgsql directory prior to installing
postgresql 8.1.2 and only<BR>/usr/local/pgsql/lib/libpq.so.4 was build. No
libpq.so.3 was built like in<BR>postgresql 7.X. I tried both mapserver 4.4.2 and
4.6.2 which give me the<BR>following error message in the httpd error_log when
trying to run mapscript in perl:<BR><BR></FONT><FONT size=2><FONT
color=#0000ff>Can't load
'/usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/auto/mapscript/mapscript.so'
for<BR>module mapscript: libpq.so.3: cannot open shared object file: No such
file or<BR>directory at
/usr/lib/perl5/5.8.0/i386-linux-thread-multi/DynaLoader.pm line 229.<BR>[Wed Feb
01 18:11:00 2006] [error] [client 192.168.119.112]
at<BR>/usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/mapscript.pm line
7<BR></FONT><BR>When I look at what libraries that are required for
mapserv I see libpq.3 is<BR>trying to be loaded:<BR></FONT><FONT size=2><FONT
color=#0000ff>[root@WIRH90 mapserver-4.6.2]# ldd
mapserv<BR> libgd.so.2 =>
/usr/local/lib/libgd.so.2
(0x4002a000)<BR> libjpeg.so.62 =>
/usr/local/lib/libjpeg.so.62
(0x40062000)<BR> libfreetype.so.6
=> /usr/lib/libfreetype.so.6
(0x4007f000)<BR> libpng12.so.0 =>
/usr/lib/libpng12.so.0
(0x400d0000)<BR> libz.so.1 =>
/usr/lib/libz.so.1 (0x400f3000)<BR>
libpdf.so.1 => /usr/local/lib/libpdf.so.1
(0x40101000)<BR> libproj.so.0 =>
/usr/local/lib/libproj.so.0
(0x40190000)<BR> libgdal.1.1.so =>
/usr/local/lib/libgdal.1.1.so
(0x401c4000)<BR> libpq.so.4 =>
/usr/local/pgsql/lib/libpq.so.4
(0x40467000)<BR> libcurl.so.2 =>
/usr/local/lib/libcurl.so.2
(0x4047e000)<BR> libssl.so.4 =>
/lib/libssl.so.4 (0x404a7000)<BR>
libcrypto.so.4 => /lib/libcrypto.so.4
(0x404dc000)<BR> libdl.so.2 =>
/lib/libdl.so.2 (0x405ce000)<BR>
libgssapi_krb5.so.2 => /usr/kerberos/lib/libgssapi_krb5.so.2
(0x405d2000)<BR> libkrb5.so.3 =>
/usr/kerberos/lib/libkrb5.so.3
(0x405e5000)<BR> libcom_err.so.3 =>
/usr/kerberos/lib/libcom_err.so.3
(0x40643000)<BR> libk5crypto.so.3
=> /usr/kerberos/lib/libk5crypto.so.3
(0x40645000)<BR> libresolv.so.2 =>
/lib/libresolv.so.2 (0x40655000)<BR>
libc.so.6 => /lib/tls/libc.so.6
(0x42000000)<BR> libm.so.6 =>
/lib/tls/libm.so.6 (0x40668000)<BR>
libstdc++.so.5 => /usr/lib/libstdc++.so.5
(0x4068a000)<BR> libpthread.so.0 =>
/lib/tls/libpthread.so.0
(0x4073d000)<BR> libXpm.so.4 =>
/usr/X11R6/lib/libXpm.so.4
(0x4074b000)<BR> libX11.so.6 =>
/usr/X11R6/lib/libX11.so.6
(0x4075a000)<BR> libpq.so.3 => not
found<BR> libclntsh.so.9.0 =>
/usr/local/lib/libclntsh.so.9.0
(0x4083a000)<BR> libungif.so.4 =>
/usr/lib/libungif.so.4
(0x41147000)<BR> libgcc_s.so.1 =>
/lib/libgcc_s.so.1 (0x4114f000)<BR>
libcrypt.so.1 => /lib/libcrypt.so.1
(0x41157000)<BR> libnsl.so.1 =>
/lib/libnsl.so.1 (0x41185000)<BR>
/lib/ld-linux.so.2 => /lib/ld-linux.so.2
(0x40000000)<BR> libXext.so.6 =>
/usr/X11R6/lib/libXext.so.6
(0x4119a000)<BR> libwtc9.so =>
/oracle/9.2.0/lib/libwtc9.so (0x411a8000)<BR></FONT><BR>Here is my DBD_pg test
of the install and I'm using DBI
1.50<BR> </FONT><FONT size=2><FONT
color=#0000ff> [root@WIRH90 DBD-Pg-1.43]# make test<BR>PERL_DL_NONLAZY=1
/usr/bin/perl "-MExtUtils::Command::MM" "-e" "test_harness(0, 'blib/lib',
'blib/arch')" t/*.t<BR>t/00basic...........ok<BR>t/01connect.........ok
1/8#<BR>#
Program
Version<BR>#
Perl
5.8.0 (linux)<BR>#
DBD::Pg
1.43<BR># PostgreSQL (compiled) 80102<BR># PostgreSQL (target)
80102<BR># 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)<BR>#
DBI
1.50<BR>#
DBI_DSN
dbi:Pg:dbname=gisdb<BR>t/01connect.........ok<BR>t/01constants.......ok<BR>t/01setup...........ok<BR>t/02attribs.........ok<BR>t/03dbmethod........ok<BR>t/03smethod.........ok<BR>t/04misc............ok<BR>t/05arrays..........ok<BR>
15/17 skipped: Array support not
implemented<BR>t/06bytea...........ok<BR>t/07copy............ok<BR>t/12placeholders....ok<BR>t/20savepoints......ok<BR>t/99_pod............skipped<BR>
all skipped: Test::Pod 0.95 required for testing
POD<BR>t/99cleanup.........ok<BR>All tests successful, 1 test and 15 subtests
skipped.<BR>Files=15, Tests=417, 9 wallclock secs ( 5.64 cusr + 0.42
csys = 6.06 CPU)<BR>[root@WIRH90 DBD-Pg-1.43]#<BR></FONT><BR>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.<BR></FONT><FONT color=#0000ff size=2>[postgres@WIRH90 postgis-1.1.1]$ make
test<BR>make -C regress test<BR>make[1]: Entering directory
`/usr/local/src/postgresql-8.1.2/contrib/postgis-1.1.1/regress'<BR><BR> 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)<BR> Postgis 1.1.1 - 2006-02-07 14:30:47<BR>
GEOS: 2.2.1-CAPI-1.0.1<BR> PROJ: Rel. 4.4.9, 29 Oct
2004<BR><BR>Running
tests<BR><BR>
regress: Ok.<BR> regress_index:
Ok.<BR> lwgeom_regress:
Ok.<BR> regress_lrs:
Ok.<BR> removepoint:
Ok.<BR> setpoint:
Ok.<BR> simplify:
Ok.<BR> regress_ogc:
Ok.<BR> regress_bdpoly: Ok.<BR>
regress_proj: Ok.<BR><BR>Run tests: 10<BR>Successful: 10<BR>Failed:
0<BR>make[1]: Leaving directory
`/usr/local/src/postgresql-8.1.2/contrib/postgis-1.1.1/regress'<BR>[postgres@WIRH90
postgis-1.1.1]$</FONT> </DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<P><FONT face=Arial size=2>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:</FONT></P>
<P><FONT face=Arial size=2>POSTGRES_HOME=
/usr/local/pgsql</FONT></P>
<P><FONT face=Arial size=2>POSTGRES_LIB=
/usr/local/pgsql/lib</FONT></P>
<P><FONT face=Arial size=2>POSTGRES_INCLUDE=
/usr/local/pgsql/include</FONT></P>
<P><FONT face=Arial size=2>Has anyone else experienced this? Thanks in
advance.</FONT></P>
<P><FONT face=Arial size=2>Tom</FONT></P>
<P><FONT face=Arial size=2></FONT> </P></BLOCKQUOTE></BODY></HTML>