[postgis-users] Problems while loadinglwpostgis.sql...Pleaseprovide your inputs / help
Paul Ramsey
pramsey at refractions.net
Wed Jan 30 20:20:21 PST 2008
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
More information about the postgis-users
mailing list