On Fri, 2008-02-01 at 12:20 +0530, [EMAIL PROTECTED] 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: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] 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, [EMAIL PROTECTED] 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
> [email protected]
> 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
> [email protected]
> http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
