<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Messaggio</TITLE>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-15">
<META content="MSHTML 6.00.2900.2523" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT face=Verdana size=2><SPAN class=635462913-21062006>Hello
everybody.</SPAN></FONT></DIV>
<DIV><FONT face=Verdana size=2><SPAN
class=635462913-21062006></SPAN></FONT> </DIV>
<DIV><FONT face=Verdana size=2><SPAN class=635462913-21062006>I'm doing a fresh
new PostGIS installation and I encountered a simple but blocking
problem.</SPAN></FONT></DIV>
<DIV><FONT face=Verdana size=2><SPAN class=635462913-21062006>I'm using Fedora
Core 4 (fresh install, just updated with yum) on x86 architecture and the rpm
PostgreSQL and PostGIS distribution.</SPAN></FONT></DIV>
<DIV><FONT face=Verdana size=2><SPAN class=635462913-21062006>The packages I've
installed are:</SPAN></FONT></DIV>
<DIV><FONT face=Verdana size=2><SPAN
class=635462913-21062006></SPAN></FONT> </DIV>
<DIV><FONT face=Verdana size=2><SPAN
class=635462913-21062006>postgis-1.1.0-2.i686.rpm<BR>postgis-utils-1.1.0-2.i686.rpm<BR>postgresql-8.1.1-1PGDG.i686.rpm<BR>postgresql-docs-8.1.1-1PGDG.i686.rpm<BR>postgresql-jdbc-8.1.1-1PGDG.i686.rpm<BR>postgresql-libs-8.1.1-1PGDG.i686.rpm<BR>postgresql-server-8.1.1-1PGDG.i686.rpm</SPAN></FONT></DIV>
<DIV><FONT face=Verdana size=2><SPAN
class=635462913-21062006></SPAN></FONT> </DIV>
<DIV><FONT><SPAN class=635462913-21062006><FONT size=2><FONT face=Verdana>and
(from fedora official repository with yum) the packages geos,
geos-devel<SPAN style="BACKGROUND: #e6e6e6"><FONT
style="BACKGROUND-COLOR: #ffffff">, </FONT></SPAN>proj,
proj-devel.</FONT></FONT></SPAN></FONT></DIV>
<DIV><FONT face=Verdana size=2><SPAN
class=635462913-21062006></SPAN></FONT> </DIV>
<DIV><FONT face=Verdana size=2><SPAN class=635462913-21062006>PostgreSQL works
perfectly, so I followed what is explained in the PostGIS online docs in the
Chapter 2.2 (<A
href="http://postgis.refractions.net/docs/ch02.html#PGInstall">http://postgis.refractions.net/docs/ch02.html#PGInstall</A>).</SPAN></FONT></DIV>
<DIV><FONT face=Verdana size=2><SPAN
class=635462913-21062006></SPAN></FONT> </DIV>
<DIV><FONT face=Verdana size=2><SPAN class=635462913-21062006>When I came to the
point of executing the SQL file lwpostgis.sql (as postgreSQL superuser), I get
this error:</SPAN></FONT></DIV>
<DIV><FONT face=Verdana size=2><SPAN
class=635462913-21062006></SPAN></FONT> </DIV>
<DIV><FONT face="Courier New"
size=2>psql:/usr/share/pgsql/postgresql/contrib/lwpostgis.sql:39: ERROR:
could not access file "/postgis.so": No such file or directory</FONT></DIV>
<DIV><FONT face=Verdana size=2></FONT> </DIV>
<DIV><SPAN class=635462913-21062006><FONT face=Verdana size=2>Of course, after
this error, the transaction become invalid and the rest of the file is discarded
by psql.</FONT></SPAN></DIV>
<DIV><SPAN class=635462913-21062006><FONT face=Verdana
size=2></FONT></SPAN> </DIV>
<DIV><FONT face=Verdana size=2><SPAN class=635462913-21062006>I verified and I
have all PostGIS libraries in the right place
(/usr/lib/pgsql).</SPAN></FONT></DIV>
<DIV><FONT face=Verdana size=2><SPAN
class=635462913-21062006></SPAN></FONT> </DIV>
<DIV><FONT face=Verdana size=2><SPAN class=635462913-21062006>I tried a stupid
thing: to remove that slash characted from the string '/postgis.so' in the sql
file, and voilą! The SQL script works fine now and all things seem
ok.</SPAN></FONT></DIV>
<DIV><FONT face=Verdana size=2><SPAN class=635462913-21062006>May I hope to have
resolved the problem correctly? Could someone say why that slash was
there?</SPAN></FONT></DIV>
<DIV><FONT face=Verdana size=2><SPAN
class=635462913-21062006></SPAN></FONT> </DIV>
<DIV><FONT face=Verdana size=2><SPAN class=635462913-21062006>Thank you for any
interest.</SPAN></FONT></DIV>
<DIV><FONT face=Verdana size=2><SPAN
class=635462913-21062006></SPAN></FONT> </DIV>
<DIV><FONT face=Verdana size=2><SPAN
class=635462913-21062006>Cheers,</SPAN></FONT></DIV>
<DIV><FONT face=Verdana size=2><SPAN
class=635462913-21062006></SPAN></FONT> </DIV>
<DIV><FONT face=Verdana size=2><SPAN
class=635462913-21062006>Fabio</SPAN></FONT></DIV>
<DIV> </DIV>
<P class=MsoNormal align=left><STRONG><SPAN
style="FONT-SIZE: 7.5pt; BACKGROUND: #dfdfdf; FONT-FAMILY: Verdana">Fabio Da
Soghe</SPAN></STRONG><SPAN
style="FONT-SIZE: 7.5pt; BACKGROUND: #dfdfdf; FONT-FAMILY: Verdana"> <FONT
style="BACKGROUND-COLOR: #ffffff"><BR></FONT></SPAN><SPAN
style="FONT-SIZE: 7.5pt; FONT-FAMILY: Verdana">Sysgroup srl - Lungo Dora
Colletta 113/14 - 10153 <SPAN class=GramE>Torino<BR></SPAN></SPAN><SPAN
class=GramE><EM><SPAN
style="FONT-SIZE: 7.5pt; FONT-FAMILY: Verdana">tel</SPAN></EM></SPAN><SPAN
style="FONT-SIZE: 7.5pt; FONT-FAMILY: Verdana"> 011.244.09.83
011.247.68.63 <EM> <SPAN style="FONT-FAMILY: Verdana">fax
</SPAN></EM>0112406561<BR></SPAN><SPAN class=GramE><EM><SPAN
style="FONT-SIZE: 7.5pt; FONT-FAMILY: Verdana">e-mail</SPAN></EM></SPAN><SPAN
style="FONT-SIZE: 7.5pt; FONT-FAMILY: Verdana"> fabio</SPAN><SPAN
style="COLOR: black"><A href="mailto:fabio.dasoghe@sysgroup.it"><SPAN
style="FONT-SIZE: 7.5pt; COLOR: black; FONT-FAMILY: Verdana; TEXT-DECORATION: none; text-underline: none">.dasoghe@sysgroup.it</SPAN></A></SPAN><SPAN
style="FONT-SIZE: 7.5pt; COLOR: black; FONT-FAMILY: Verdana"> </SPAN><SPAN
style="FONT-SIZE: 7.5pt; FONT-FAMILY: Verdana"><EM>web</EM>
www.sysgroup.it</SPAN></P>
<DIV> </DIV></BODY></HTML>