Hi,<br><br>Have you added /usr/local/lib to /etc/ld.so.conf and then performed a ldconfig ?<br><br>Cheers,<br><br>Andy<br><br><div><span class="gmail_quote">On 30/01/2008, <b class="gmail_sendername"><a href="mailto:ahmadbasha.shaik@wipro.com">ahmadbasha.shaik@wipro.com</a></b> <<a href="mailto:ahmadbasha.shaik@wipro.com">ahmadbasha.shaik@wipro.com</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div>
<div><font face="Arial" size="2">Hi </font></div>
<div> </div>
<div><font face="Arial" size="2">I am facing problems while loading lwpostgis.sql in
PostGIS. Below is a detailed explanation.<br>psql -d test -f
/usr/share/lwpostgis.sql</font></div>
<div> </div>
<div><font face="Arial" size="2">/******************************************************************************/<br>ERROR:
could not access file "$libdir/liblwgeom.so.1.2": No such file or
directory<br>ERROR: current transaction is aborted, commands ignored until
end of transaction
block<br>/******************************************************************************/</font></div>
<div><font face="Arial" size="2"></font> </div><font face="Arial" size="2">
</font><div><font face="Arial" size="2">Hence , I tried creating a simple test.sql which has the create replace
functions for histogram. I have detailed the environmnent that we are </font></div>
<div><font face="Arial" size="2">using, the statement of lwpostgis.sql we executed and the error encountered
</font></div>
<div><font face="Arial" size="2"> </font></div>
<div><font face="Arial" size="2">Environment:<br>============</font></div>
<div><font face="Arial" size="2">Operationg System : Red Hat Linux 3.4.5-2</font></div>
<div><font face="Arial" size="2">Database : PostgreSQL 8.2.6 </font></div>
<div><font face="Arial" size="2">Extensions : geos-3.0.0, proj-4.6.0, postgis-1.2.1</font></div>
<div><font face="Arial" size="2"> </font></div>
<div><font face="Arial" size="2">test.sql (three sql commands that I have taken from lwpostgis.sql to
check)<br>========</font></div>
<div><font face="Arial" size="2"><br>BEGIN;</font></div>
<div><font face="Arial" size="2"> </font></div>
<div><font face="Arial" size="2">CREATE OR REPLACE FUNCTION
histogram2d_in(cstring)<br> RETURNS
histogram2d<br> AS
'$libdir/liblwgeom.so.1.2',
'lwhistogram2d_in'<br> LANGUAGE 'C'
IMMUTABLE STRICT; -- WITH (isstrict);</font></div>
<div><font face="Arial" size="2"> </font></div>
<div><font face="Arial" size="2">CREATE OR REPLACE FUNCTION
histogram2d_out(histogram2d)<br>
RETURNS cstring<br> AS
'$libdir/liblwgeom.so.1.2',
'lwhistogram2d_out'<br> LANGUAGE 'C'
IMMUTABLE STRICT; -- WITH (isstrict);</font></div>
<div><font face="Arial" size="2"> </font></div>
<div><font face="Arial" size="2">CREATE TYPE histogram2d (<br>
alignment = double,<br> internallength
= variable,<br> input =
histogram2d_in,<br> output =
histogram2d_out,<br> storage =
main<br>);</font></div>
<div><font face="Arial" size="2"> </font></div>
<div><font face="Arial" size="2">COMMIT;</font></div>
<div><font face="Arial" size="2"> </font></div>
<div><font face="Arial" size="2"> </font></div>
<div><font face="Arial" size="2">ERROR Encountered<br>================</font></div>
<div><font face="Arial" size="2"> </font></div>
<div><font face="Arial" size="2">BEGIN<br>psql:test.sql:6: NOTICE: type "histogram2d" is not yet
defined<br>DETAIL: Creating a shell type definition.<br>psql:test.sql:6:
ERROR: could not access file "$libdir/liblwgeom.so.1.2": No such file or
directory<br>psql:test.sql:11: ERROR: current transaction is aborted,
commands ignored until end of transaction block<br>psql:test.sql:19:
ERROR: current transaction is aborted, commands ignored until end of
transaction block<br>ROLLBACK</font></div>
<div><font face="Arial" size="2"> </font></div>
<div><font face="Arial" size="2">Varions Options we tried:<br>==================<br>a) Changed the
permissions $libdir i.e. /usr/lib/pgsl to 777<br>b) Hardcoded the path
/usr/lib/pgsql in this test.sql<br>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</font></div>
<div><font face="Arial" size="2"> </font></div>
<div><font face="Arial" size="2"><br>Can somebody please guide us or give directions what can be done.
</font></div>
<div><font face="Arial" size="2"> </font></div>
<div><font face="Arial" size="2">Regards<br>Ahmad</font></div></div><p><strong><span style="font-size: 24pt; font-family: Webdings; color: green;">P</span></strong><strong><span style="font-size: 10pt; color: green;"> Please do not print this email unless it is absolutely necessary. Spread environmental awareness.</span></strong><span></span></p>
<p> 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. </p>
<p>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. </p>
<p>
<a href="http://www.wipro.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">www.wipro.com</a>
</p>
<br>_______________________________________________<br>postgis-users mailing list<br><a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>
<a onclick="return top.js.OpenExtLink(window,event,this)" href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br><br></blockquote>
</div><br>