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

[ahmadbasha.shaik at wipro.com]

Tim,

	Thanks for your inputs, We had installed Postgresql using the
following switches

	./configure
	make
	make install	

	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