<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 5.50.4134.600" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Hello users,</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I saw a few messages/questions posted with problems
i encountered installing postgis.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>After one sleepless night is it now working
beautifully here.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>The first problem was that i could not compile
postgis. This was </FONT><FONT face=Arial size=2>solved by the simple
solution to set USE_PG72 to 1 in the </FONT><FONT face=Arial size=2>makefile.
Just after the version check i inserted this setting. Problem
solved.</FONT></DIV>
<DIV><FONT face=Arial size=2>Then I could insert shapefiles into the database
just fine. Then i wanted to query my database</FONT></DIV>
<DIV><FONT face=Arial size=2>using mapserver. The first message mapserver gave
me was something like:</FONT></DIV>
<DIV><FONT face=Arial size=2><FONT face=Arial size=2></FONT></FONT> </DIV>
<DIV><FONT face=Arial size=2><FONT face="Times New Roman"
size=3>msPOSTGISLayerOpen(): Query error. msPOSTGISLayerOpen called
but<BR>unimplemented!</FONT></FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>T</FONT><FONT face=Arial size=2>his was solved by
using a mapserver </FONT><FONT face=Arial size=2>binary that had postgis support
compiled into it (duh!). But then i got another fine error message, something
like:</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2><FONT face="Times New Roman"
size=3>msPOSTGISLayerOpen(): Error parsing POSTGIS connection
information</FONT><BR></FONT><FONT face=Arial size=2></DIV></FONT>
<DIV><FONT face=Arial size=2>This was more difficult because the error is not
very specific. </FONT></DIV>
<DIV><FONT face=Arial size=2>I thought i could solve i by granting
a specific user read only access to the specific data but it </FONT></DIV>
<DIV><FONT face=Arial size=2>did not do the trick. A</FONT><FONT face=Arial
size=2>fter a lot of reading and trying the </FONT><FONT face=Arial
size=2>problem was solved by executing mapserver from the same server that
had postgis installed on it. It worked fine using the localhost host
setting. So it was a host problem!!!! </FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Then I changed the configuration of postgresql
in the pg_hba.conf file to accept connections from other computers in my
home network ip-range. That did the trick. After that everything worked just
fine. Maybe this step should be added to the windows installation file if
someone is using mapserver</FONT></DIV>
<DIV><FONT face=Arial size=2>from another computer........</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Regards,</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Wim Blanken</FONT></DIV>
<DIV><FONT face=Arial size=2>The Netherlands</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2> </DIV></FONT>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV></BODY></HTML>