[postgis-users] Problems whileloadinglwpostgis.sql...Pleaseprovide your inputs / help

ahmadbasha.shaik at wipro.com ahmadbasha.shaik at wipro.com
Wed Jan 30 22:15:12 PST 2008


Hi,

I tried changing ownership to the user being run and hardcoded the path
as below in the test.sql file (which has just the create function and
create type statements for histogram2d), I get the following error:
/***********************************************************************
*************************************/
could not load library "/usr/lib/pgsql/liblwgeom.so.1.2":
/usr/lib/pgsql/liblwgeom.so.1.2: undefined symbol: nth
/***********************************************************************
*************************************/

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 load library
"/usr/lib/pgsql/liblwgeom.so.1.2": /usr/lib/pgsql/liblwgeom.so.1.2:
undefined symbol: nth
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

Regards
Ahmad

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Paul
Ramsey
Sent: Thursday, January 31, 2008 9:50 AM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] Problems
whileloadinglwpostgis.sql...Pleaseprovide your inputs / help

Sorry, it's a black box from here. Your description of what you've tried
below does not leave me with any obvious solutions I can ascertain
without working on the box directly.  You have tried all the obvious
things, which only leaves the non-obvious things.

P

On Jan 30, 2008, at 7:59 PM, <ahmadbasha.shaik at wipro.com>
<ahmadbasha.shaik at wipro.com  > wrote:

> Hey Paul
>
> 	Please give me your inputs as to what could be the problem with 
> regards to the environment.
>
> Yes this liblwgeom.so.1.2 file actually exists. Following is the ls - 
> ltr listing of /usr/lib/pgsql
>
> lrwxrwxrwx  1 root root      16 Jan 30 16:24 liblwgeom.so ->
> liblwgeom.so.1.2
> lrwxrwxrwx  1 root root      16 Jan 30 16:24 liblwgeom.so.1 ->
> liblwgeom.so.1.2
> -rwxrwxrwx  1 root root  894867 Jan 30 16:24 liblwgeom.so.1.2
>
> Please provide your inputs.
>
> Regards
> Ahmad
>
> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net
> [mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of 
> Paul Ramsey
> Sent: Wednesday, January 30, 2008 9:59 PM
> To: PostGIS Users Discussion
> Subject: Re: [postgis-users] Problems while 
> loadinglwpostgis.sql...Pleaseprovide your inputs / help
>
> This is certainly an environment problem, not a software problem...
>
> You have confirmed that liblwgeom.so.1.2 actually exists?
>
> On Jan 30, 2008, at 6:22 AM, <ahmadbasha.shaik at wipro.com> 
> <ahmadbasha.shaik at wipro.com  > wrote:
>
>> Hey Tim
>>
>> 	That entry also is there in /etc/ld.so.conf file. Please let me
> know
>> if there is any other way out.
>>
>> 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: Wednesday, January 30, 2008 7:27 PM
>> To: PostGIS Users Discussion
>> Subject: RE: [postgis-users] Problems while loading 
>> lwpostgis.sql...Pleaseprovide your inputs / help
>>
>>
>> On Wed, 2008-01-30 at 19:05 +0530, ahmadbasha.shaik at wipro.com wrote:
>>> Yes andy
>>>
>>>   a) /usr/local/lib was already present in /etc/ld.so.conf
>>>   b) ldconfig was also performed
>>
>> If you've used the default source install of postgresql, you'll need 
>> /usr/local/pgsql/lib
>>
>> HTH,
>> Tim Bowden
>>
>>>
>>>   Can you please let me know what else might be the problem as I am 
>>> in a urgency to load GIS data in PostgreSQL (with Post GIS).
>>>
>>> Regards
>>> Ahmad
>>>
>>>
>>>
> ______________________________________________________________________
>>> From: postgis-users-bounces at postgis.refractions.net
>>> [mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of 
>>> Andy Dale
>>> Sent: Wednesday, January 30, 2008 6:53 PM
>>> To: PostGIS Users Discussion
>>> Subject: Re: [postgis-users] Problems while loading lwpostgis.sql...
>>> Pleaseprovide your inputs / help
>>>
>>>
>>>
>>> Hi,
>>>
>>> Have you added /usr/local/lib to /etc/ld.so.conf and then performed 
>>> a ldconfig ?
>>>
>>> Cheers,
>>>
>>> Andy
>>>
>>> On 30/01/2008, ahmadbasha.shaik at wipro.com 
>>> <ahmadbasha.shaik at wipro.com>
>>> wrote:
>>>       Hi
>>>
>>>       I am facing problems while loading lwpostgis.sql in PostGIS.
>>>       Below is a detailed explanation.
>>>       psql -d test -f /usr/share/lwpostgis.sql
>>>
>>>
>> /
>>
> **********************************************************************
> *
>> *******/
>>>       ERROR:  could not access file "$libdir/liblwgeom.so.1.2": No
>>>       such file or directory
>>>       ERROR:  current transaction is aborted, commands ignored until
>>>       end of transaction block
>>>
>>> /
>>> ********************************************************************
>>> *
>>> *********/
>>>
>>>       Hence , I tried creating a simple test.sql which has the
>>>       create replace functions for histogram. I have detailed the
>>>       environmnent that we are
>>>       using, the statement of lwpostgis.sql we executed and the
>>>       error encountered
>>>
>>>       Environment:
>>>       ============
>>>       Operationg System : Red Hat Linux 3.4.5-2
>>>       Database : PostgreSQL 8.2.6
>>>       Extensions : geos-3.0.0, proj-4.6.0, postgis-1.2.1
>>>
>>>       test.sql (three sql commands that I have taken from
>>>       lwpostgis.sql to check)
>>>       ========
>>>
>>>       BEGIN;
>>>
>>>       CREATE OR REPLACE FUNCTION histogram2d_in(cstring)
>>>               RETURNS histogram2d
>>>               AS '$libdir/liblwgeom.so.1.2', 'lwhistogram2d_in'
>>>               LANGUAGE 'C' IMMUTABLE STRICT; -- WITH (isstrict);
>>>
>>>       CREATE OR REPLACE FUNCTION histogram2d_out(histogram2d)
>>>               RETURNS cstring
>>>               AS '$libdir/liblwgeom.so.1.2', 'lwhistogram2d_out'
>>>               LANGUAGE 'C' IMMUTABLE STRICT; -- WITH (isstrict);
>>>
>>>       CREATE TYPE histogram2d (
>>>               alignment = double,
>>>               internallength = variable,
>>>               input = histogram2d_in,
>>>               output = histogram2d_out,
>>>               storage = main
>>>       );
>>>
>>>       COMMIT;
>>>
>>>
>>>       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) Changed the permissions $libdir i.e. /usr/lib/pgsl to 777
>>>       b) Hardcoded the path /usr/lib/pgsql in this test.sql
>>>       c) 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
>>>
>>>
>>>       Can somebody please guide us or give directions what can be
>>>       done.
>>>
>>>       Regards
>>>       Ahmad
>>>       P 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
>>>
>>>
>>>
>>>
>>> P 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
>>
>> _______________________________________________
>> 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
>
> _______________________________________________
> 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

_______________________________________________
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



More information about the postgis-users mailing list