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, <[EMAIL PROTECTED]> <[EMAIL PROTECTED]
> 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: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] 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, <[EMAIL PROTECTED]>
<[EMAIL PROTECTED] > 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: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] 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, [EMAIL PROTECTED] 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: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] 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, [EMAIL PROTECTED]
<[EMAIL PROTECTED]>
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
[email protected]
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
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________
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
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
