[mapserver-users] problem compiling postgis support on linux

[John Cartwright]

Hello All,

I'm having trouble compiling version 5.6.1 with postgis support on
RHEL4.  "PQserverVersion" appears to be defined in
postgresql-8.4.1/include/libpq-fe.h and I've insured that the
environment variable CPPFLAGS includes that directory. Excerpt of
console log below.

Can someone please help me w/ this? 

Thanks!

--john





g++ -fPIC -fPIC -Wall     -DHAVE_VSNPRINTF -DNEED_STRLCAT
-DNEED_STRRSTR        -DUSE_WMS_LYR -DUSE_WFS_LYR -DUSE_SOS_SVR
-DUSE_LIBXML2 -DUSE_CURL -DUSE_WCS_SVR -DUSE_WFS_SVR -DUSE_WMS_SVR 
-DUSE_ORACLESPATIAL  -DUSE_POSTGIS -DUSE_TIFF -DUSE_GDAL -DUSE_OGR
-DUSE_GEOS -DGEOS_HAS_SIMPLIFY  -DUSE_THREAD -DUSE_PROJ -DUSE_EPPL 
-DUSE_AGG     -DUSE_GD_GIF -DUSE_GD_PNG -DUSE_GD_JPEG -DUSE_GD_WBMP
-DUSE_GD_FT -DGD_HAS_FTEX_XSHOW -DGD_HAS_GDIMAGEGIFPTR
-DGD_HAS_GETBITMAPFONTS -DUSE_ICONV -DUSE_ZLIB    
-I/usr/local/contrib/gd-2.0.35/include -I/usr/include/freetype2   
-I/usr/local/contrib/proj-4.7.0/include    
-I/usr/local/contrib/gdal-1.7.1/include
-I/nfs/contrib/rhel4/postgresql-8.4.1/include   
-I/opt/apps/oracle/product/10.2.0/db_1/rdbms/public
-I/opt/apps/oracle/product/10.2.0/db_1/rdbms/demo
-I/opt/apps/oracle/product/10.2.0/db_1/rdbms/public
-I/usr/local/contrib/geos-3.2.0/include    -I/usr/include/libxml2  
shp2img.o  -L. -lmapserver -L/usr/local/contrib/gd-2.0.35/lib -lgd
-ljpeg -L/usr/lib64 -Wl,--rpath -Wl,/usr/lib64 -lfreetype -lz -lpng
-lz       -ltiff -ljpeg -L/usr/lib64 -Wl,--rpath -Wl,/usr/lib64
-lfreetype -lz -lpng -lz   -L/usr/local/contrib/proj-4.7.0/lib -lproj
-ljpeg -lpng  -L/usr/local/contrib/gdal-1.7.1/lib -lgdal
-L/usr/local/contrib/geos-3.2.0/lib -lgeos_c
-L/opt/apps/oracle/product/10.2.0/db_1/lib
-L/opt/apps/oracle/product/10.2.0/db_1 -lclntsh -lnnz10 -lodbc
-lodbcinst -L/usr/local/contrib/expat-2.0.1/lib -lexpat -lpq
-L/usr/lib64 -lpq -lz -L/usr/local/contrib/libz-1.2.3
-L/usr/local/contrib/libz-1.2.3/lib -lm -lrt -ldl -L/extra/contrib/lib
-L/usr/lib64 -lcurl -L/usr/kerberos/lib -L/usr/kerberos/lib64 -lssl
-lcrypto -lgssapi_krb5 -lkrb5 -lcom_err -lk5crypto -lresolv -ldl -lz
-lgssapi_krb5 -lkrb5 -lk5crypto -lcom_err -lresolv -L/usr/kerberos/lib
-L/usr/kerberos/lib64 -lidn -lssl -lcrypto -lssl -lcrypto -lgssapi_krb5
-lkrb5 -lcom_err -lk5crypto -lresolv -ldl -lz -lz -L/usr/lib64/mysql
-lmysqlclient -lz -lcrypt -lnsl -lm -L/usr/lib64 -lssl -lcrypto 
-L/nfs/contrib/rhel4/postgresql-8.4.1/lib -lpq -lpgport -lz -lreadline
-ltermcap -lcrypt -ldl -lm   -L/usr/lib64 -lcurl -L/usr/kerberos/lib
-L/usr/kerberos/lib64 -lssl -lcrypto -lgssapi_krb5 -lkrb5 -lcom_err
-lk5crypto -lresolv -ldl -lz -lgssapi_krb5 -lkrb5 -lk5crypto -lcom_err
-lresolv -L/usr/kerberos/lib -L/usr/kerberos/lib64 -lidn -lssl -lcrypto
-lssl -lcrypto -lgssapi_krb5 -lkrb5 -lcom_err -lk5crypto -lresolv -ldl
-lz -lz -L/opt/apps/oracle/product/10.2.0/db_1/lib -lclntsh
-L/usr/local/contrib/geos-3.2.0/lib -lgeos_c -lpthread -lc  -lz -lxml2
-lz -lpthread -lm  -lm -lstdc++    -o shp2img
/usr/bin/ld: warning: libexpat.so.1, needed by
/usr/local/contrib/gdal-1.7.1/lib/libgdal.so, may conflict with
libexpat.so.0
./libmapserver.a(mappostgis.o)(.text+0xec2): In function
`msPostGISRetrievePK':
: undefined reference to `PQserverVersion'
collect2: ld returned 1 exit status
make: *** [shp2img] Error 1