[postgis-users] facing problems while loading lwpostgis.sql inPostGIS

[Tim Bowden]

On Fri, 2008-02-01 at 12:20 +0530, ahmadbasha.shaik at wipro.com wrote:
> Tim,
> 
> 	Thanks for your inputs, We had installed Postgresql using the
> following switches
> 
> 	./configure
> 	make
> 	make install	
1.  I suspect you actually have postrgesql installed and running from an
RHES rpm.  Please post results of pg_config.

2.  Does the /usr/local/pgsql/ directory exist, and does it have
anything in it?

Tim Bowden

> 
> 	Secondly, the results of ldd /usr/local/pgsql/lib/liblwgeom.so
> gives no such file or directory
> 	
> 	Then I did ldd on the /usr/lib/pgsql/liblwgeom.so (as this file
> was in this directory) 
> 
>         libgeos_c.so.1 => /usr/local/lib/libgeos_c.so.1 (0x00d6e000)
>         libproj.so.0 => /usr/local/lib/libproj.so.0 (0x005ac000)
>         libc.so.6 => /lib/tls/libc.so.6 (0x001dd000)
>         libgeos-3.0.0.so => /usr/local/lib/libgeos-3.0.0.so (0x00621000)
>         libstdc++.so.6 => /usr/lib/libstdc++.so.6 (0x00dae000)
>         libm.so.6 => /lib/tls/libm.so.6 (0x00111000)
>         libgcc_s.so.1 => /lib/libgcc_s.so.1 (0x0058e000)
>         /lib/ld-linux.so.2 (0x003fa000)
> 
> Additionally wanted to provide you the following information, maybe you
> might give us some inputs on the installation
> /*******************************************************************/
> SUMMARY
>  -------------------------------------------------------
> 
>  HOST_OS: linux-gnu
> 
>    PGSQL: /usr/bin/pg_config
>     GEOS: /usr/local/bin/geos-config (with C-API)
>           (ldflags: -L/usr/local/lib)
>     PROJ: prefix=/usr/local libdir=/usr/local/lib
>    ICONV: 1
> 
>  PORTNAME: linux
>    PREFIX: /usr
>   EPREFIX: ${prefix}
>       DOC: /usr/share/doc/postgresql/contrib
>      DATA: ${datarootdir}
>       MAN: ${datarootdir}/man
>       BIN: /usr/bin
>       EXT: /usr/lib/pgsql (\$$libdir)
> /*******************************************************************/
> 
> Regards
> Ahmad 
> 
> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net
> [mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Tim
> Bowden
> Sent: Friday, February 01, 2008 11:46 AM
> To: PostGIS Users Discussion
> Subject: Re: [postgis-users] facing problems while loading lwpostgis.sql
> inPostGIS
> 
> First some questions:
> How have you installed postgresql (source/rpm)?
> 
> If source, what command line switches did you use?
> 
> How have you installed postgis/geos?
> 
> could you please post the result of
> ldd /usr/local/pgsql/lib/liblwgeom.so
> 
> More inline...
> On Fri, 2008-02-01 at 11:08 +0530, ahmadbasha.shaik at wipro.com wrote:
> > Hi
> >  
> 
> <snip>
> >  
> > Environment:
> > ============
> > Operationg System : Red Hat Linux 3.4.5-2
> 
> I assume you mean Red Hat *Enterprise* Linux 3.4.5-2?  Red Hat Linux 3
> came out in May 1996 and was superseded in Oct 1996 by Red Hat Linux 4.
> Sorry, but I'm being pedantic about the details.  Solving elusive
> problems is hard enough without the added complication of being loose
> with details.
> 
> > Database : PostgreSQL 8.2.6 
> > Extensions : geos-3.0.0, proj-4.6.0, postgis-1.2.1
> >  
> <snip>
> > ERROR Encountered
> > ================
> >  
> > BEGIN
> > psql:test.sql:6: NOTICE:  type "histogram2d" is not yet defined
> > DETAIL:  Creating a shell type definition.
> > psql:test.sql:6: ERROR:  could not access file
> > "$libdir/liblwgeom.so.1.2": No such file or directory
> > psql:test.sql:11: ERROR:  current transaction is aborted, commands
> > ignored until end of transaction block
> > psql:test.sql:19: ERROR:  current transaction is aborted, commands
> > ignored until end of transaction block
> > ROLLBACK
> >  
> > Varions Options we tried:
> > ==================
> > a) /usr/local/lib is present in /etc/ld.so.conf
> 
> What about /usr/local/pgsql/lib which is where postgresql libs get
> installed to in a default source install?
> 
> > b) ldconfig was executed
> > c) Changed the permissions $libdir i.e. /usr/lib/pgsql to 777
> 
> *NEVER* do this.  If you must temporarily make permissions lax for
> testing, you're much better off using 555.  There should never be any
> reason for an application to have write permission on libs.  Also
> remember to change the permissions back when the test doesn't work.
> 
> > d) Hardcoded the path /usr/lib/pgsql in this test.sql
> 
> Does this path exist?  If you've installed from source it shouldn't.
> 
> > e) We also tried hardcoding the path /usr/lib/pgsql instead of $libdir
> > in lwpostgis.sql when we tried loading functions and types in
> > lwpostgis.sql
> > f) When I hardcode the path /usr/lib/pgsql - it gives the following
> > error - could not load library
> > "/usr/lib/pgsql/liblwgeom.so.1.2": /usr/lib/pgsql/liblwgeom.so.1.2:
> > undefined symbol: nth
> >  
> 
> Tim Bowden
> 
> 
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
> 
> Please do not print this email unless it is absolutely necessary. Spread environmental awareness.
> 
> The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments. 
> 
> WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. 
> 
> www.wipro.com
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users