[Mapserver-users] Error Parsing POSTGIS connection informatio n
christian.schuster at rsag.ch
christian.schuster at rsag.ch
Wed Jan 29 12:08:27 EST 2003
This is a multipart message in MIME format.
--=_alternative 005E28C8C1256CBD_=
Content-Type: text/plain; charset="US-ASCII"
I tried now both connection settings
### Connect to a remote spatial database
CONNECTION "user=*** password=**** dbname=myGISdb host=localhost
port=5432"
### Connect to a remote spatial database
CONNECTION "user=*** password=**** dbname=myGISdb host=127.0.01 port=5432"
With the same error message.
I am also not a Unix (Cygwin) expert. So, I am not absolutly sure if the
PostgreSQL server is running right. Is there a possibility to check this?
Well, if I type in ps at the shell I get three processes for PostgreSQL.
"Swaminathan, Gayathri" <gayathri at ou.edu>
29.01.2003 17:58
To
"'christian.schuster at rsag.ch'" <christian.schuster at rsag.ch>
cc
Subject
RE: [Mapserver-users] Error Parsing POSTGIS connection informatio n
Try doing this instead...Hope that works for you
LAYER
CONNECTIONTYPE postgis
NAME "points"
### Connect to a remote spatial database
CONNECTION "user=*** password=**** dbname=myGISdb host=localhost
port=5432"
Gayathri Swaminathan
Geo Information Systems
University Of Oklahoma
(405) 325 3131 x 237
(405) 904 4673
visit us @ http://geo.ou.edu
------------------------------------------------------
Work like you don't need money,love like
you've never been hurt and, dance like
no one's watching.
~Anon
-----Original Message-----
From: christian.schuster at rsag.ch [mailto:christian.schuster at rsag.ch]
Sent: Wednesday, January 29, 2003 8:50 AM
To: mapserver-users at lists.gis.umn.edu
Subject: [Mapserver-users] Error Parsing POSTGIS connection information
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 005E28C8C1256CBD_=
Content-Type: text/html; charset="US-ASCII"
<br><font size=2 face="sans-serif">I tried now both connection settings</font>
<br>
<br><font size=3><b>### Connect to a remote spatial database</b> </font>
<br><font size=3><b>CONNECTION "user=*** password=**** dbname=myGISdb
host=localhost port=5432"</b> </font>
<br>
<br><font size=3><b>### Connect to a remote spatial database</b> </font>
<br><font size=3><b>CONNECTION "user=*** password=**** dbname=myGISdb
host=127.0.01 port=5432"</b> </font>
<br>
<br><font size=2 face="sans-serif">With the same error message.</font>
<br>
<br><font size=2 face="sans-serif">I am also not a Unix (Cygwin) expert.
So, I am not absolutly sure if the PostgreSQL server is running right.
Is there a possibility to check this?</font>
<br><font size=2 face="sans-serif">Well, if I type in ps at the shell I
get three processes for PostgreSQL.</font>
<br>
<br>
<br>
<br>
<br>
<table width=100%>
<tr valign=top>
<td width=40%><font size=1 face="sans-serif"><b>"Swaminathan, Gayathri"
<gayathri at ou.edu></b> </font>
<p><font size=1 face="sans-serif">29.01.2003 17:58</font>
<td width=59%>
<table width=100%>
<tr>
<td>
<div align=right><font size=1 face="sans-serif">To</font></div>
<td valign=top><font size=1 face="sans-serif">"'christian.schuster at rsag.ch'"
<christian.schuster at rsag.ch></font>
<tr>
<td>
<div align=right><font size=1 face="sans-serif">cc</font></div>
<td valign=top>
<tr>
<td>
<div align=right><font size=1 face="sans-serif">Subject</font></div>
<td valign=top><font size=1 face="sans-serif">RE: [Mapserver-users] Error
Parsing POSTGIS connection informatio n</font></table>
<br>
<table>
<tr valign=top>
<td>
<td></table>
<br></table>
<br>
<br>
<br>
<br><font size=2>Try doing this instead...Hope that works for you</font>
<br><font size=3> </font>
<br><font size=3><b>LAYER</b> </font>
<br><font size=3><b> CONNECTIONTYPE postgis</b> </font>
<br><font size=3><b> NAME "points"</b> </font>
<br>
<br><font size=3><b> ### Connect to a remote spatial database</b>
</font>
<br><font size=3><b> CONNECTION "user=*** password=****
dbname=myGISdb host=localhost port=5432"</b> </font>
<br>
<br>
<br>
<br><font size=3>Gayathri Swaminathan</font><font size=2> </font>
<br><font size=3>Geo Information Systems</font><font size=2> </font>
<br><font size=3>University Of Oklahoma</font><font size=2> </font>
<br><font size=3>(405) 325 3131 x 237</font><font size=2> </font>
<br><font size=3>(405) 904 4673</font><font size=2> </font>
<br><font size=3>visit us @ </font><a href=http://geo.ou.edu/><font size=3 color=blue><u>http://geo.ou.edu</u></font></a><font size=2>
</font>
<br><font size=3>------------------------------------------------------</font><font size=2>
</font>
<br><font size=3>Work like you don't need money,love like</font><font size=2>
</font>
<br><font size=3>you've never been hurt and, dance like</font><font size=2>
</font>
<br><font size=3>no one's watching.</font><font size=2> </font>
<br><font size=3>~Anon</font><font size=2> </font>
<br>
<br><font size=3> </font>
<br>
<br><font size=2>-----Original Message-----</font>
<br><font size=2><b>From:</b> christian.schuster at rsag.ch [mailto:christian.schuster at rsag.ch]</font>
<br><font size=2><b>Sent:</b> Wednesday, January 29, 2003 8:50 AM</font>
<br><font size=2><b>To:</b> mapserver-users at lists.gis.umn.edu</font>
<br><font size=2><b>Subject:</b> [Mapserver-users] Error Parsing
POSTGIS connection information</font>
<br>
<br>
<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> CONNECTIONTYPE postgis</b> </font>
<br><font size=3><b> NAME "points"</b> </font>
<br>
<br><font size=3><b> ### Connect to a remote spatial database</b>
</font>
<br><font size=3><b> CONNECTION "user=*** dbname=myGISdb
host=127.0.0.1"</b> </font>
<br>
<br><font size=3><b> ### Get the points from the 'col1' column of
the 't1' table</b> </font>
<br><font size=3><b> DATA "col1 from t1"</b> </font>
<br><font size=3><b> STATUS ON</b> </font>
<br><font size=3><b> TYPE POINT</b> </font>
<br>
<br><font size=3><b> CLASS</b> </font>
<br><font size=3><b> COLOR 255 0 0 </b>
</font>
<br><font size=3><b> 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>
<br><font size=2>Christian Schuster</font>
<br>
<br><font size=2>Rudolf Schuster AG</font>
<br><font size=2>Postfach 277</font>
<br><font size=2>CH - 3000 Bern 11</font>
<br>
<br><font size=2>http://www.rsag.ch</font>
<br><font size=2>++41 31 348 05 30</font>
<br>
--=_alternative 005E28C8C1256CBD_=--
More information about the mapserver-users
mailing list