[Mapserver-users] Error Parsing POSTGIS connection informatio n
Benjamin Wragg
bwragg at tpg.com.au
Wed Jan 29 18:09:10 PST 2003
This is a multi-part message in MIME format.
------=_NextPart_000_0003_01C2C85C.97169060
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit
Fire up cygwin and type the following:
psql myGIDdb
This should log you into the database using the default administrators
credentials. Now type:
\d
This sould list all the tables that are in the database. There should be
a geometry_columns, spatial_ref_sys table as a minimum. These are
installed by PostGIS. Now type:
select * from geometry_columns;
This should list the contents of the geometry_columns table.
If you've got this far without any problems it would seem that you've
PostgreSQL and PostGIS are installed and working. There's some other
things we can check e.g permissions, but let me know how you go with
these steps.
Cheers,
Benjamin Wragg
-----Original Message-----
From: mapserver-users-admin at lists.gis.umn.edu
[mailto:mapserver-users-admin at lists.gis.umn.edu] On Behalf Of
christian.schuster at rsag.ch
Sent: Thursday, 30 January 2003 3:38 AM
To: Swaminathan, Gayathri
Cc: mapserver-users at lists.gis.umn.edu
Subject: RE: [Mapserver-users] Error Parsing POSTGIS connection
informatio n
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/> 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
------=_NextPart_000_0003_01C2C85C.97169060
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Dus-ascii">
<TITLE>Message</TITLE>
<META content=3D"MSHTML 6.00.2800.1106" name=3DGENERATOR></HEAD>
<BODY>
<DIV><FONT face=3DArial size=3D2>
<DIV><SPAN class=3D796113020-29012003><FONT face=3DArial color=3D#0000ff =
size=3D2>Fire=20
up cygwin and type the following:</FONT></SPAN></DIV>
<DIV><SPAN class=3D796113020-29012003><FONT face=3DArial color=3D#0000ff =
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D796113020-29012003><FONT face=3DArial color=3D#0000ff =
size=3D2>psql=20
myGIDdb</FONT></SPAN></DIV>
<DIV><SPAN class=3D796113020-29012003></SPAN><SPAN =
class=3D796113020-29012003><FONT=20
face=3DArial color=3D#0000ff size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D796113020-29012003><FONT face=3DArial color=3D#0000ff =
size=3D2>This=20
should log you into the database using the default administrators =
credentials.=20
Now </FONT></SPAN><SPAN class=3D796113020-29012003><FONT face=3DArial =
color=3D#0000ff=20
size=3D2>type: </FONT></SPAN></DIV>
<DIV><SPAN class=3D796113020-29012003><FONT face=3DArial color=3D#0000ff =
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D796113020-29012003><FONT face=3DArial color=3D#0000ff =
size=3D2>\d</FONT></SPAN></DIV>
<DIV><SPAN class=3D796113020-29012003><FONT face=3DArial color=3D#0000ff =
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D796113020-29012003><FONT face=3DArial color=3D#0000ff =
size=3D2>This=20
sould list all the tables that are in the database. There should be a=20
geometry_columns, spatial_ref_sys table as a minimum. These are =
installed by=20
PostGIS. Now type:</FONT></SPAN></DIV>
<DIV><SPAN class=3D796113020-29012003><FONT face=3DArial color=3D#0000ff =
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D796113020-29012003><FONT face=3DArial color=3D#0000ff =
size=3D2>select=20
* from geometry_columns;</FONT></SPAN></DIV>
<DIV><SPAN class=3D796113020-29012003><FONT face=3DArial color=3D#0000ff =
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D796113020-29012003><FONT face=3DArial color=3D#0000ff =
size=3D2>This=20
should list the contents of the geometry_columns =
table.</FONT></SPAN></DIV>
<DIV><SPAN class=3D796113020-29012003><FONT face=3DArial color=3D#0000ff =
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D796113020-29012003><FONT face=3DArial color=3D#0000ff =
size=3D2>If=20
you've got this far without any problems it would seem that you've =
PostgreSQL=20
and PostGIS are installed and working. </FONT></SPAN><SPAN=20
class=3D796113020-29012003><FONT face=3DArial color=3D#0000ff =
size=3D2>There's some=20
other things we can check e.g permissions, but let me know how you go =
with these=20
steps.</FONT></SPAN></DIV>
<DIV><SPAN class=3D796113020-29012003><FONT face=3DArial color=3D#0000ff =
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D796113020-29012003><FONT face=3DArial color=3D#0000ff =
size=3D2>Cheers,</FONT></SPAN></DIV>
<DIV><SPAN class=3D796113020-29012003><FONT face=3DArial color=3D#0000ff =
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D796113020-29012003><FONT face=3DArial color=3D#0000ff =
size=3D2>Benjamin Wragg</FONT></SPAN></DIV>
<DIV><SPAN class=3D796113020-29012003><FONT face=3DArial color=3D#0000ff =
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D796113020-29012003><FONT face=3DArial color=3D#0000ff =
size=3D2></FONT></SPAN> </DIV>
<DIV></DIV>
<DIV><FONT face=3DTahoma size=3D2>-----Original =
Message-----<BR><B>From:</B>=20
mapserver-users-admin at lists.gis.umn.edu=20
[mailto:mapserver-users-admin at lists.gis.umn.edu] <B>On Behalf Of=20
</B>christian.schuster at rsag.ch<BR><B>Sent:</B> Thursday, 30 January 2003 =
3:38=20
AM<BR><B>To:</B> Swaminathan, Gayathri<BR><B>Cc:</B>=20
mapserver-users at lists.gis.umn.edu<BR><B>Subject:</B> RE: =
[Mapserver-users] Error=20
Parsing POSTGIS connection informatio n<BR><BR></DIV></FONT>
<BLOCKQUOTE style=3D"MARGIN-RIGHT: 0px"><BR><FONT face=3Dsans-serif =
size=3D2>I tried=20
now both connection settings</FONT> <BR><BR><FONT size=3D3><B>### =
Connect to a=20
remote spatial database</B> </FONT><BR><FONT size=3D3><B>CONNECTION =
"user=3D***=20
password=3D**** dbname=3DmyGISdb host=3Dlocalhost =
port=3D5432"</B> </FONT>=20
<BR><BR><FONT size=3D3><B>### Connect to a remote spatial database</B> =
</FONT><BR><FONT size=3D3><B>CONNECTION "user=3D*** password=3D**** =
dbname=3DmyGISdb=20
host=3D127.0.01 port=3D5432"</B> </FONT> <BR><BR><FONT =
face=3Dsans-serif=20
size=3D2>With the same error message.</FONT> <BR><BR><FONT =
face=3Dsans-serif=20
size=3D2>I am also not a Unix (Cygwin) expert. So, I am not absolutly =
sure if=20
the PostgreSQL server is running right. Is there a possibility to =
check=20
this?</FONT> <BR><FONT face=3Dsans-serif size=3D2>Well, if I type in =
ps at the=20
shell I get three processes for PostgreSQL.</FONT> =
<BR><BR><BR><BR><BR>
<TABLE width=3D"100%">
<TBODY>
<TR vAlign=3Dtop>
<TD width=3D"40%"><FONT face=3Dsans-serif =
size=3D1><B>"Swaminathan, Gayathri"=20
<gayathri at ou.edu></B> </FONT>
<P><FONT face=3Dsans-serif size=3D1>29.01.2003 17:58</FONT> </P>
<TD width=3D"59%">
<TABLE width=3D"100%">
<TBODY>
<TR>
<TD>
<DIV align=3Dright><FONT face=3Dsans-serif =
size=3D1>To</FONT></DIV>
<TD vAlign=3Dtop><FONT face=3Dsans-serif=20
size=3D1>"'christian.schuster at rsag.ch'"=20
<christian.schuster at rsag.ch></FONT>=20
<TR>
<TD>
<DIV align=3Dright><FONT face=3Dsans-serif =
size=3D1>cc</FONT></DIV>
<TD vAlign=3Dtop>
<TR>
<TD>
<DIV align=3Dright><FONT face=3Dsans-serif =
size=3D1>Subject</FONT></DIV>
<TD vAlign=3Dtop><FONT face=3Dsans-serif size=3D1>RE: =
[Mapserver-users]=20
Error Parsing POSTGIS connection informatio =
=20
n</FONT></TD></TR></TBODY></TABLE><BR>
<TABLE>
<TBODY>
<TR vAlign=3Dtop>
<TD>
=
<TD></TD></TR></TBODY></TABLE><BR></TD></TR></TBODY></TABLE><BR><BR><BR><=
BR><FONT=20
size=3D2>Try doing this instead...Hope that works for you</FONT> =
<BR><FONT=20
size=3D3> </FONT> <BR><FONT size=3D3><B>LAYER</B> </FONT> =
<BR><FONT=20
size=3D3><B> CONNECTIONTYPE postgis</B> </FONT><BR><FONT =
size=3D3><B> =20
NAME "points"</B> </FONT> <BR><BR><FONT size=3D3><B> ### =
Connect to=20
a remote spatial database</B> </FONT><BR><FONT size=3D3><B> =20
CONNECTION "user=3D*** password=3D**** dbname=3DmyGISdb =
host=3Dlocalhost=20
port=3D5432"</B> </FONT> <BR><BR><BR><BR><FONT =
size=3D3>Gayathri=20
Swaminathan</FONT><FONT size=3D2> </FONT><BR><FONT size=3D3>Geo =
Information=20
Systems</FONT><FONT size=3D2> </FONT><BR><FONT size=3D3>University Of=20
Oklahoma</FONT><FONT size=3D2> </FONT><BR><FONT size=3D3>(405) =
325 3131 x=20
237</FONT><FONT size=3D2> </FONT><BR><FONT size=3D3>(405) 904 =
4673</FONT><FONT=20
size=3D2> </FONT><BR><FONT size=3D3>visit us @ </FONT><A=20
href=3D"http://geo.ou.edu/"><FONT color=3Dblue=20
size=3D3><U>http://geo.ou.edu</U></FONT></A><FONT size=3D2> =
</FONT><BR><FONT=20
=
size=3D3>------------------------------------------------------</FONT><FO=
NT=20
size=3D2> </FONT> <BR><FONT size=3D3>Work like you don't need =
money,love=20
like</FONT><FONT size=3D2> </FONT><BR><FONT size=3D3>you've never been =
hurt and,=20
dance like</FONT><FONT size=3D2> </FONT><BR><FONT size=3D3>no one's=20
watching.</FONT><FONT size=3D2> </FONT><BR><FONT =
size=3D3>~Anon</FONT><FONT=20
size=3D2> </FONT> <BR><BR><FONT size=3D3> </FONT> =
<BR><BR><FONT=20
size=3D2>-----Original Message-----</FONT> <BR><FONT =
size=3D2><B>From:</B>=20
christian.schuster at rsag.ch =
[mailto:christian.schuster at rsag.ch]</FONT>=20
<BR><FONT size=3D2><B>Sent:</B> Wednesday, January 29, 2003 8:50 =
AM</FONT>=20
<BR><FONT size=3D2><B>To:</B> mapserver-users at lists.gis.umn.edu</FONT> =
<BR><FONT=20
size=3D2><B>Subject:</B> [Mapserver-users] Error Parsing POSTGIS =
connection information</FONT> <BR><BR><BR><FONT size=3D3>Hi =
list,=20
</FONT><BR><BR><FONT size=3D3>I am a newbie an struggeling with =
getting=20
GIS data from the database. I get the following error in the =
browser=20
</FONT><BR><BR><FONT size=3D3><B>msPOSTGISLayerOpen(): Query error. =
Error=20
parsing POSTGIS connection information.</B> </FONT><BR><BR><FONT =
size=3D3>This is my layer definition: </FONT><BR><BR><FONT=20
size=3D3><B>LAYER</B> </FONT><BR><FONT size=3D3><B> =
CONNECTIONTYPE=20
postgis</B> </FONT><BR><FONT size=3D3><B> NAME =
"points"</B>=20
</FONT><BR><BR><FONT size=3D3><B> ### Connect to a remote =
spatial=20
database</B> </FONT><BR><FONT size=3D3><B> CONNECTION =
"user=3D***=20
dbname=3DmyGISdb host=3D127.0.0.1"</B> </FONT><BR><BR><FONT =
size=3D3><B> ###=20
Get the points from the 'col1' column of the 't1' table</B>=20
</FONT><BR><FONT size=3D3><B> DATA "col1 from t1"</B> =
</FONT>=20
<BR><FONT size=3D3><B> STATUS ON</B> </FONT><BR><FONT =
size=3D3><B> =20
TYPE POINT</B> </FONT><BR><BR><FONT size=3D3><B> CLASS</B> =
</FONT> <BR><FONT size=3D3><B> COLOR 255 0 0 =
=20
</B> </FONT><BR><FONT size=3D3><B> END</B> =
</FONT><BR><FONT=20
size=3D3><B>END</B> </FONT><BR><FONT size=3D3><B>### end of layer=20
definitions</B> </FONT><BR><BR><FONT size=3D3>Any help is =
welcome.=20
</FONT> <BR><BR><FONT size=3D2>Christian Schuster</FONT> =
<BR><BR><FONT=20
size=3D2>Rudolf Schuster AG</FONT> <BR><FONT size=3D2>Postfach =
277</FONT>=20
<BR><FONT size=3D2>CH - 3000 Bern 11</FONT> <BR><BR><FONT=20
size=3D2>http://www.rsag.ch</FONT> <BR><FONT size=3D2>++41 31 =
348 05=20
30</FONT> <BR></BLOCKQUOTE></FONT></DIV></BODY></HTML>
------=_NextPart_000_0003_01C2C85C.97169060--
More information about the MapServer-users
mailing list