[postgis-users] problems building postgis-1.3.1 on SLES10

[Mark Cave-Ayland]

On Mon, 2007-08-20 at 23:06 +0200, Christian.Strobl at dlr.de wrote:
> dear list,
> 
> i am building postgis 1.3.1 with geos-3.0.0rc4, proj-4.5.0, postgresql-8.2.4 on suse enterprise server 10
> 
> ./configure --with-pgsql=/usr/local/PGSQL/bin/pg_config --with-geos=/usr/local/GEOS-3.0.0RC4/bin/geos-config --with-proj=/usr/local/PROJ4-4.5.0
> 
> with make check i get the following error message
> 
> ########################################
> make -C regress test
> make[1]: Entering directory `/usr/src/postgis-1.3.1/regress'
> Creating spatial db postgis_reg
> ERROR: function postgis_lib_version() does not exist
> LINE 1: select postgis_lib_version()
> ^
> HINT: No function matches the given name and argument types. You may need to add explicit type casts.
> 
> Something went wrong (no postgis installed in postgis_reg).
> For details, check /tmp/pgis_reg_10097/regress_log
> 
> make[1]: *** [test] Fehler 1
> make[1]: Leaving directory `/usr/src/postgis-1.3.1/regress'
> make: *** [check] Fehler 2
> ###############################################
> 
> looking at the /tmp/pgis_reg_10097/regress_log
> 
> i see the following message
> 
> ###############################################
> 
> CREATE DATABASE
> BEGIN
> psql:lwpostgis.sql:44: NOTICE: type "histogram2d" is not yet defined
> DETAIL: Creating a shell type definition.
> psql:lwpostgis.sql:44: ERROR: could not load library "/usr/src/postgis-1.3.1/lwgeom/liblwgeom.so.1.3": libproj.so.0: cannot open shared object file: No such file or directory
> psql:lwpostgis.sql:50: ERROR: current transaction is aborted, commands ignored until end of transaction block
> psql:lwpostgis.sql:56: ERROR: current transaction is aborted, commands ignored until end of transaction block
> psql:lwpostgis.sql:62: ERROR: current transaction is aborted, commands ignored until end of transaction block
> psql:lwpostgis.sql:70: ERROR: current transaction is aborted, commands ignored until end of transaction block
> psql:lwpostgis.sql:88: ERROR: current transaction is aborted, commands ignored until end of transaction block
> psql:lwpostgis.sql:94: ERROR: current transaction is aborted, commands ignored until end of transaction block
> ....................
> 
> ###############################################
> 
> both libraries exist and also setting the LD_LIBRARY_PATH explicitly brings no help. the regress_log remains unchanged.
> 
> export LD_LIBRARY_PATH=/usr/src/postgis-1.3.1/lwgeom:/usr/local/PROJ4-4.5.0/lib
> 
> i am grateful for every help
> christian


Hi Christian,

Have you remembered that it is the server that is loading the shared
library and not the client? In other words, you need to make sure that
your LD_LIBRARY_PATH is set for the user under which the PostgreSQL
server runs (normally postgres) and restart PostgreSQL so it can see the
environment changes. Also don't forget to check basic file permissions
and your SELinux settings if you have it enabled.


HTH,

Mark.

-- 
ILande - Open Source Consultancy
http://www.ilande.co.uk