[Mapserver-users] Error Parsing POSTGIS connection information

[christian.schuster at rsag.ch]

This is a multipart message in MIME format.
--=_alternative 005C7B54C1256CBD_=
Content-Type: text/plain; charset="US-ASCII"

Hi list,

I am a newbie an struggeling with getting GIS data from the database. I 
get the following error in the browser

msPOSTGISLayerOpen(): Query error. Error parsing POSTGIS connection 
information.

This is my layer definition:

LAYER
  CONNECTIONTYPE postgis
  NAME "points"

  ### Connect to a remote spatial database
  CONNECTION "user=*** dbname=myGISdb host=127.0.0.1"

  ### Get the points from the 'col1' column of the 't1' table
  DATA "col1 from t1"
  STATUS ON
  TYPE POINT

  CLASS
    COLOR 255 0 0 
  END
END
### end of layer definitions

Any help is welcome.

Christian Schuster

Rudolf Schuster AG
Postfach 277
CH - 3000 Bern 11

http://www.rsag.ch
++41 31 348 05 30
--=_alternative 005C7B54C1256CBD_=
Content-Type: text/html; charset="US-ASCII"


<br><font size=3>Hi list,</font>
<br>
<br><font size=3>I am a newbie an struggeling with getting GIS data from
the database. I get the following error in the browser</font>
<br>
<br><font size=3><b>msPOSTGISLayerOpen(): Query error. Error parsing POSTGIS
connection information.</b></font>
<br>
<br><font size=3>This is my layer definition:</font>
<br>
<br><font size=3><b>LAYER</b></font>
<br><font size=3><b>&nbsp; CONNECTIONTYPE postgis</b></font>
<br><font size=3><b>&nbsp; NAME &quot;points&quot;</b></font>
<br>
<br><font size=3><b>&nbsp; ### Connect to a remote spatial database</b></font>
<br><font size=3><b>&nbsp; CONNECTION &quot;user=*** dbname=myGISdb host=127.0.0.1&quot;</b></font>
<br>
<br><font size=3><b>&nbsp; ### Get the points from the 'col1' column of
the 't1' table</b></font>
<br><font size=3><b>&nbsp; DATA &quot;col1 from t1&quot;</b></font>
<br><font size=3><b>&nbsp; STATUS ON</b></font>
<br><font size=3><b>&nbsp; TYPE POINT</b></font>
<br>
<br><font size=3><b>&nbsp; CLASS</b></font>
<br><font size=3><b>&nbsp; &nbsp; COLOR 255 0 0 &nbsp; &nbsp; &nbsp;</b></font>
<br><font size=3><b>&nbsp; END</b></font>
<br><font size=3><b>END</b></font>
<br><font size=3><b>### end of layer definitions</b></font>
<br>
<br><font size=3>Any help is welcome.</font>
<br><font size=2 face="sans-serif"><br>
Christian Schuster<br>
<br>
Rudolf Schuster AG<br>
Postfach 277<br>
CH - 3000 Bern 11<br>
<br>
http://www.rsag.ch<br>
++41 31 348 05 30</font>
--=_alternative 005C7B54C1256CBD_=--