[Mapserver-users] Error Parsing POSTGIS connection informatio n

Thu Jan 30 02:10:08 PST 2003

This is a multi-part message in MIME format.

------_=_NextPart_001_01C2C847.C44F5784
Content-Type: text/plain;
	charset="US-ASCII"
Content-Transfer-Encoding: quoted-printable

Hi Christian,
=20
Have you enabled TCP/IP connections in your copy of postgresql? To check
this, fire up cygwin and go to /usr/local/pgsql/data. Load the file
postgresql.conf into a text editor and change the line reading
'#tcpip_socket=3Dfalse' to 'tcpip_socket=3Dtrue'.
=20
Secondly, load up pg_hba.conf into a text editor and make sure there are
two entries for your machine in there:
=20
host       all         127.0.0.1     255.255.255.255    trust
host      all         x.x.x.x              255.255.255.255 trust
(where x.x.x.x is the IP of your machine on your LAN)
=20
=20
Finally, restart postgresql and see if you can then connect to the db
using mapserver. If you've done it right, typing 'netstat -an' from a
command prompt should give an entry similar to:
=20
TCP      0.0.0.0:5432      0.0.0.0:0           LISTENING
or
TCP      x.x.x.x:5432      0.0.0.0:0           LISTENING
=20
where 5432 is the port used by postgresql....
=20
=20
Hope this helps,
=20
Mark.
=20
---

Mark Cave-Ayland
Webbased Ltd.
Tamar Science Park
Derriford
Plymouth
PL6 8BX
England

Tel: +44 (0)1752 764445
Fax: +44 (0)1752 764446

This email and any attachments are confidential to the intended
recipient and may also be privileged. If you are not the intended
recipient please delete it from your system and notify the sender. You
should not copy it or use it for any purpose nor disclose or distribute
its contents to any other person.
-----Original Message-----
From: christian.schuster at rsag.ch [mailto:christian.schuster at rsag.ch]=20
Sent: 29 January 2003 17:08
To: Swaminathan, Gayathri
Cc: mapserver-users at lists.gis.umn.edu
Subject: RE: [Mapserver-users] Error Parsing POSTGIS connection
informatio n
=20

I tried now both connection settings=20

### Connect to a remote spatial database=20
CONNECTION "user=3D*** password=3D**** dbname=3DmyGISdb host=3Dlocalhost
port=3D5432" =20

### Connect to a remote spatial database=20
CONNECTION "user=3D*** password=3D**** dbname=3DmyGISdb host=3D127.0.01
port=3D5432" =20

With the same error message.=20

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?=20
Well, if I type in ps at the shell I get three processes for PostgreSQL.

"Swaminathan, Gayathri" <gayathri at ou.edu>=20
29.01.2003 17:58=20
To
"'christian.schuster at rsag.ch'" <christian.schuster at rsag.ch>=20
cc
=20
Subject
RE: [Mapserver-users] Error Parsing POSTGIS connection informatio
n
=20
=20
=20

Try  doing this instead...Hope that works for you=20
 =20
LAYER  =20
  CONNECTIONTYPE postgis=20
  NAME "points"  =20

  ### Connect to a remote spatial database=20
   CONNECTION "user=3D*** password=3D**** dbname=3DmyGISdb =
host=3Dlocalhost
port=3D5432" =20

Gayathri Swaminathan=20
Geo Information Systems=20
University Of  Oklahoma=20
(405) 325 3131 x 237=20
(405) 904 4673=20
visit us @ http://geo.ou.edu <http://geo.ou.edu/> =20
------------------------------------------------------  =20
Work like you don't need money,love like=20
you've never been hurt and, dance like=20
no one's watching.=20
~Anon  =20

 =20

-----Original Message-----=20
From: christian.schuster at rsag.ch  [mailto:christian.schuster at rsag.ch]=20
Sent: Wednesday, January 29, 2003  8:50 AM=20
To: mapserver-users at lists.gis.umn.edu=20
Subject:  [Mapserver-users] Error Parsing POSTGIS connection
information=20

Hi list,=20

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

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

This is my layer  definition:=20

LAYER=20
  CONNECTIONTYPE postgis=20
   NAME "points"=20

  ### Connect to a  remote spatial database=20
  CONNECTION  "user=3D*** dbname=3DmyGISdb host=3D127.0.0.1"=20

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

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

Any help is welcome.  =20

Christian Schuster=20

Rudolf Schuster  AG=20
Postfach 277=20
CH - 3000 Bern 11=20

http://www.rsag.ch=20
++41 31  348 05 30=20

------_=_NextPart_001_01C2C847.C44F5784
Content-Type: text/html;
	charset="US-ASCII"
Content-Transfer-Encoding: quoted-printable

<html xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:st1=3D"urn:schemas-microsoft-com:office:smarttags" =
xmlns=3D"http://www.w3.org/TR/REC-html40">

<head>
<meta http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dus-ascii">
<meta name=3DProgId content=3DWord.Document>
<meta name=3DGenerator content=3D"Microsoft Word 10">
<meta name=3DOriginator content=3D"Microsoft Word 10">
<link rel=3DFile-List href=3D"cid:filelist.xml at 01C2C847.111C3650">
<o:SmartTagType =
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
 name=3D"country-region"/>
<o:SmartTagType =
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
 name=3D"City"/>
<o:SmartTagType =
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
 name=3D"PlaceType"/>
<o:SmartTagType =
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
 name=3D"PlaceName"/>
<o:SmartTagType =
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
 name=3D"place"/>
<o:SmartTagType =
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
 name=3D"PersonName"/>
<!--[if gte mso 9]><xml>
 <o:OfficeDocumentSettings>
  <o:DoNotRelyOnCSS/>
 </o:OfficeDocumentSettings>
</xml><![endif]--><!--[if gte mso 9]><xml>
 <w:WordDocument>
  <w:SpellingState>Clean</w:SpellingState>
  <w:GrammarState>Clean</w:GrammarState>
  <w:DocumentKind>DocumentEmail</w:DocumentKind>
  <w:EnvelopeVis/>
  <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel>
 </w:WordDocument>
</xml><![endif]--><!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--
 /* Font Definitions */
 @font-face
	{font-family:Tahoma;
	panose-1:2 11 6 4 3 5 4 4 2 4;
	mso-font-charset:0;
	mso-generic-font-family:swiss;
	mso-font-pitch:variable;
	mso-font-signature:553679495 -2147483648 8 0 66047 0;}
@font-face
	{font-family:sans-serif;
	panose-1:0 0 0 0 0 0 0 0 0 0;
	mso-font-alt:"Times New Roman";
	mso-font-charset:0;
	mso-generic-font-family:roman;
	mso-font-format:other;
	mso-font-pitch:auto;
	mso-font-signature:0 0 0 0 0 0;}
 /* Style Definitions */
 p.MsoNormal, li.MsoNormal, div.MsoNormal
	{mso-style-parent:"";
	margin:0cm;
	margin-bottom:.0001pt;
	mso-pagination:widow-orphan;
	font-size:12.0pt;
	font-family:"Times New Roman";
	mso-fareast-font-family:"Times New Roman";}
a:link, span.MsoHyperlink
	{color:blue;
	text-decoration:underline;
	text-underline:single;}
a:visited, span.MsoHyperlinkFollowed
	{color:blue;
	text-decoration:underline;
	text-underline:single;}
p
	{mso-margin-top-alt:auto;
	margin-right:0cm;
	mso-margin-bottom-alt:auto;
	margin-left:0cm;
	mso-pagination:widow-orphan;
	font-size:12.0pt;
	font-family:"Times New Roman";
	mso-fareast-font-family:"Times New Roman";}
span.EmailStyle18
	{mso-style-type:personal-reply;
	mso-style-noshow:yes;
	mso-ansi-font-size:10.0pt;
	mso-bidi-font-size:10.0pt;
	font-family:Arial;
	mso-ascii-font-family:Arial;
	mso-hansi-font-family:Arial;
	mso-bidi-font-family:Arial;
	color:navy;}
span.SpellE
	{mso-style-name:"";
	mso-spl-e:yes;}
span.GramE
	{mso-style-name:"";
	mso-gram-e:yes;}
@page Section1
	{size:612.0pt 792.0pt;
	margin:72.0pt 90.0pt 72.0pt 90.0pt;
	mso-header-margin:35.4pt;
	mso-footer-margin:35.4pt;
	mso-paper-source:0;}
div.Section1
	{page:Section1;}
-->
</style>
<!--[if gte mso 10]>
<style>
 /* Style Definitions */=20
 table.MsoNormalTable
	{mso-style-name:"Table Normal";
	mso-tstyle-rowband-size:0;
	mso-tstyle-colband-size:0;
	mso-style-noshow:yes;
	mso-style-parent:"";
	mso-padding-alt:0cm 5.4pt 0cm 5.4pt;
	mso-para-margin:0cm;
	mso-para-margin-bottom:.0001pt;
	mso-pagination:widow-orphan;
	font-size:10.0pt;
	font-family:"Times New Roman";}
</style>
<![endif]-->
</head>

<body lang=3DEN-US link=3Dblue vlink=3Dblue =
style=3D'tab-interval:36.0pt'>

<div class=3DSection1>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>Hi =
Christian,<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>Have you enabled TCP/IP connections =
in
your copy of <span class=3DSpellE>postgresql</span>? To check this, fire =
up <span
class=3DSpellE>cygwin</span> and go to /<span =
class=3DSpellE>usr/local/pgsql/data</span>.
Load the file <span class=3DSpellE>postgresql.conf</span> into a text =
editor and
change the line reading ‘#<span =
class=3DSpellE>tcpip_socket</span>=3Dfalse’
to ‘<span =
class=3DSpellE>tcpip_socket</span>=3Dtrue’.<o:p></o:p></span></font=
></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>Secondly, load up <span =
class=3DSpellE>pg_hba.conf</span>
into a text editor and make sure there are two entries for your machine =
in
there:<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>

<p class=3DMsoNormal><span class=3DGramE><font size=3D2 color=3Dnavy =
face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial;color:navy'>host</span></font=
></span><font
size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial;
color:navy'><span =
style=3D'mso-spacerun:yes'>      
</span>all<span
style=3D'mso-spacerun:yes'>       &nbs=
p;
</span>127.0.0.1<span =
style=3D'mso-spacerun:yes'>    
</span>255.255.255.255<span =
style=3D'mso-spacerun:yes'>   
</span>trust<o:p></o:p></span></font></p>

<p class=3DMsoNormal><span class=3DGramE><font size=3D2 color=3Dnavy =
face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial;color:navy'>host</span></font=
></span><font
size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial;
color:navy'><span =
style=3D'mso-tab-count:1'>      </span>all<span
style=3D'mso-tab-count:1'>       &nbsp=
; </span><span
class=3DSpellE>x.x.x.x</span><span =
style=3D'mso-tab-count:2'>       &nbsp=
;      </span>255.255.255.255
trust<span =
style=3D'mso-tab-count:2'>       &nbsp=
;         </span>(where
<span class=3DSpellE>x.x.x.x</span> is the IP of your machine on your =
LAN)<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>

Finally, restart postgresql
and see if you can then connect to the db using mapserver.
If you’ve done it right, typing ‘netstat –an’
from a command prompt should give an entry similar =
to:<o:p></o:p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>TCP<span =
style=3D'mso-tab-count:1'>      =
</span>0.0.0.0:5432<span
style=3D'mso-tab-count:1'>      =
</span>0.0.0.0:0<span
style=3D'mso-tab-count:1'>       &nbsp=
;   </span>LISTENING<span
style=3D'mso-tab-count:2'>       &nbsp=
;            =
</span>or<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>TCP<span =
style=3D'mso-tab-count:1'>      =
</span>x.x.x.x:5432<span
style=3D'mso-tab-count:1'>      =
</span>0.0.0.0:0<span
style=3D'mso-tab-count:1'>       &nbsp=
;   </span>LISTENING<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>where 5432 is the port used by =
<span
class=3DSpellE>postgresql</span>….<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>Hope this =
helps,<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>Mark.<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>

<div>

<p><font size=3D2 color=3Dnavy face=3D"Times New Roman"><span =
style=3D'font-size:10.0pt;
color:navy;mso-no-proof:yes'>---<br>
<br>
</span></font><st1:PersonName><font size=3D2 color=3Dnavy><span =
style=3D'font-size:
 10.0pt;color:navy;mso-no-proof:yes'>Mark =
Cave-Ayland</span></font></st1:PersonName><font
size=3D2 color=3Dnavy><span =
style=3D'font-size:10.0pt;color:navy;mso-no-proof:yes'><br>
Webbased Ltd.<br>
</span></font><st1:place><st1:PlaceName><font size=3D2 =
color=3Dnavy><span
  =
style=3D'font-size:10.0pt;color:navy;mso-no-proof:yes'>Tamar</span></font=
></st1:PlaceName><font
 size=3D2 color=3Dnavy><span =
style=3D'font-size:10.0pt;color:navy;mso-no-proof:yes'> =
</span></font><st1:PlaceName><font
  size=3D2 color=3Dnavy><span =
style=3D'font-size:10.0pt;color:navy;mso-no-proof:yes'>Science</span></fo=
nt></st1:PlaceName><font
 size=3D2 color=3Dnavy><span =
style=3D'font-size:10.0pt;color:navy;mso-no-proof:yes'> =
</span></font><st1:PlaceType><font
  size=3D2 color=3Dnavy><span =
style=3D'font-size:10.0pt;color:navy;mso-no-proof:yes'>Park</span></font>=
</st1:PlaceType></st1:place><font
size=3D2 color=3Dnavy><span =
style=3D'font-size:10.0pt;color:navy;mso-no-proof:yes'><br>
Derriford<br>
</span></font><st1:City><st1:place><font size=3D2 color=3Dnavy><span
  =
style=3D'font-size:10.0pt;color:navy;mso-no-proof:yes'>Plymouth</span></f=
ont></st1:place></st1:City><font
size=3D2 color=3Dnavy><span =
style=3D'font-size:10.0pt;color:navy;mso-no-proof:yes'><br>
PL6 8BX<br>
</span></font><st1:country-region><st1:place><font size=3D2 =
color=3Dnavy><span
  =
style=3D'font-size:10.0pt;color:navy;mso-no-proof:yes'>England</span></fo=
nt></st1:place></st1:country-region><font
size=3D2 color=3Dnavy><span =
style=3D'font-size:10.0pt;color:navy;mso-no-proof:yes'><br>
<br>
Tel: +44 (0)1752 764445<br>
Fax: +44 (0)1752 764446<br>
<br>
<br>
This email and any attachments are confidential to the intended =
recipient and
may also be privileged. If you are not the intended recipient please =
delete it
from your system and notify the sender. You should not copy it or use it =
for
any purpose nor disclose or distribute its contents to any other =
person.</span></font><o:p></o:p></p>

</div>

<div style=3D'border:none;border-left:solid blue 1.5pt;padding:0cm 0cm =
0cm 4.0pt'>

<p class=3DMsoNormal><font size=3D2 face=3DTahoma><span =
style=3D'font-size:10.0pt;
font-family:Tahoma'>-----Original Message-----<br>
<b><span style=3D'font-weight:bold'>From:</span></b> =
christian.schuster at rsag.ch
[mailto:christian.schuster at rsag.ch<span class=3DGramE>] <br>
<b><span style=3D'font-weight:bold'>Sent</span></b></span><b><span
style=3D'font-weight:bold'>:</span></b> 29 =
</span></font><st1:PersonName><font
 size=3D2 face=3DTahoma><span =
style=3D'font-size:10.0pt;font-family:Tahoma'>Jan</span></font></st1:Pers=
onName><font
size=3D2 face=3DTahoma><span =
style=3D'font-size:10.0pt;font-family:Tahoma'>uary 2003
17:08<br>
<b><span style=3D'font-weight:bold'>To:</span></b> Swaminathan, =
Gayathri<br>
<b><span style=3D'font-weight:bold'>Cc:</span></b> =
</span></font><st1:PersonName><font
 size=3D2 face=3DTahoma><span =
style=3D'font-size:10.0pt;font-family:Tahoma'>mapserver-users at lists.gis.u=
mn.edu</span></font></st1:PersonName><font
size=3D2 face=3DTahoma><span =
style=3D'font-size:10.0pt;font-family:Tahoma'><br>
<b><span style=3D'font-weight:bold'>Subject:</span></b> RE: =
[Mapserver-users]
Error Parsing POSTGIS connection informatio n</span></font></p>

<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'><o:p> </o:p></span></font></p>

I tried now both connection =
settings 
 
### Connect to a remote spatial =
database
 
CONNECTION "user=3D*** =
password=3D****
dbname=3DmyGISdb host=3Dlocalhost =
 port=3D5432"  
 
### Connect to a remote spatial =
database
 
CONNECTION "user=3D*** =
password=3D****
dbname=3DmyGISdb host=3D127.0.01 =
 port=3D5432"  
 
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.
 
 
 
<![if !supportLineBreakNewLine]> 
<![endif]><o:p></o:p>

<table class=3DMsoNormalTable border=3D0 cellpadding=3D0 width=3D"100%"
 style=3D'width:100.0%;mso-cellspacing:1.5pt'>
 <tr style=3D'mso-yfti-irow:0;mso-yfti-lastrow:yes'>
  <td width=3D"40%" valign=3Dtop style=3D'width:40.0%;padding:.75pt =
.75pt .75pt .75pt'>
  <p class=3DMsoNormal><b><font size=3D1 face=3Dsans-serif><span =
style=3D'font-size:
  7.5pt;font-family:sans-serif;font-weight:bold'>"Swaminathan,
  Gayathri" <gayathri at ou.edu></span></font></b><font size=3D1
  face=3Dsans-serif><span =
style=3D'font-size:7.5pt;font-family:sans-serif'> =
</span></font><o:p></o:p></p>
  <p><font size=3D1 face=3Dsans-serif><span =
style=3D'font-size:7.5pt;font-family:
  sans-serif'>29.01.2003 17:58</span></font> <o:p></o:p></p>
  </td>
  <td width=3D"59%" valign=3Dtop style=3D'width:59.0%;padding:.75pt =
.75pt .75pt .75pt'>
  <table class=3DMsoNormalTable border=3D0 cellpadding=3D0 =
width=3D"100%"
   style=3D'width:100.0%;mso-cellspacing:1.5pt'>
   <tr style=3D'mso-yfti-irow:0'>
    <td style=3D'padding:.75pt .75pt .75pt .75pt'>
    <p class=3DMsoNormal align=3Dright style=3D'text-align:right'><font =
size=3D1
    face=3Dsans-serif><span =
style=3D'font-size:7.5pt;font-family:sans-serif'>To</span></font><o:p></o=
:p></p>
    </td>
    <td valign=3Dtop style=3D'padding:.75pt .75pt .75pt .75pt'>
    <p class=3DMsoNormal><font size=3D1 face=3Dsans-serif><span =
style=3D'font-size:
    =
7.5pt;font-family:sans-serif'>"'christian.schuster at rsag.ch'"
    <christian.schuster at rsag.ch></span></font> <o:p></o:p></p>
    </td>
   </tr>
   <tr style=3D'mso-yfti-irow:1'>
    <td style=3D'padding:.75pt .75pt .75pt .75pt'>
    <p class=3DMsoNormal align=3Dright style=3D'text-align:right'><font =
size=3D1
    face=3Dsans-serif><span =
style=3D'font-size:7.5pt;font-family:sans-serif'>cc</span></font><o:p></o=
:p></p>
    </td>
    <td valign=3Dtop style=3D'padding:.75pt .75pt .75pt .75pt'>
    <p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span
    style=3D'font-size:12.0pt'><o:p> </o:p></span></font></p>
    </td>
   </tr>
   <tr style=3D'mso-yfti-irow:2;mso-yfti-lastrow:yes'>
    <td style=3D'padding:.75pt .75pt .75pt .75pt'>
    <p class=3DMsoNormal align=3Dright style=3D'text-align:right'><font =
size=3D1
    face=3Dsans-serif><span =
style=3D'font-size:7.5pt;font-family:sans-serif'>Subject</span></font><o:=
p></o:p></p>
    </td>
    <td valign=3Dtop style=3D'padding:.75pt .75pt .75pt .75pt'>
    <p class=3DMsoNormal><font size=3D1 face=3Dsans-serif><span =
style=3D'font-size:
    7.5pt;font-family:sans-serif'>RE: [Mapserver-users] Error Parsing =
POSTGIS
    connection informatio       =
 n</span></font><o:p></o:p></p>
    </td>
   </tr>
  </table>
  <p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span
  style=3D'font-size:12.0pt'><o:p> </o:p></span></font></p>
  <table class=3DMsoNormalTable border=3D0 cellpadding=3D0 =
style=3D'mso-cellspacing:
   1.5pt'>
   <tr style=3D'mso-yfti-irow:0;mso-yfti-lastrow:yes'>
    <td valign=3Dtop style=3D'padding:.75pt .75pt .75pt .75pt'>
    <p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span
    style=3D'font-size:12.0pt'><o:p> </o:p></span></font></p>
    </td>
    <td valign=3Dtop style=3D'padding:.75pt .75pt .75pt .75pt'>
    <p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span
    style=3D'font-size:12.0pt'><o:p> </o:p></span></font></p>
    </td>
   </tr>
  </table>
  <p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span
  style=3D'font-size:12.0pt'><o:p></o:p></span></font></p>
  </td>
 </tr>
</table>

<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'><br>
<br>
<br>
<br>
</span></font><font size=3D2><span style=3D'font-size:10.0pt'>Try =
 doing this
instead...Hope that works for you</span></font> <br>
  <br>
<b><span style=3D'font-weight:bold'>LAYER</span></b>   <br>
<b><span style=3D'font-weight:bold'>  CONNECTIONTYPE =
postgis</span></b> <br>
<b><span style=3D'font-weight:bold'>  NAME =
"points"</span></b>
  <br>
<br>
<b><span style=3D'font-weight:bold'>  ### Connect to a remote =
spatial
database</span></b> <br>
<b><span style=3D'font-weight:bold'>   CONNECTION =
"user=3D***
password=3D**** dbname=3DmyGISdb host=3Dlocalhost =
 port=3D5432"</span></b> 
<br>
<br>
<br>
<br>
Gayathri Swaminathan<font size=3D2><span style=3D'font-size:10.0pt'> =
</span></font><br>
Geo Information Systems<font size=3D2><span style=3D'font-size:10.0pt'> =
</span></font><br>
University Of  Oklahoma<font size=3D2><span =
style=3D'font-size:10.0pt'> </span></font><br>
(405) 325 3131 x 237<font size=3D2><span style=3D'font-size:10.0pt'> =
</span></font><br>
(405) 904 4673<font size=3D2><span style=3D'font-size:10.0pt'> =
</span></font><br>
visit us @ <a href=3D"http://geo.ou.edu/">http://geo.ou.edu</a><font =
size=3D2><span
style=3D'font-size:10.0pt'> </span></font><br>
------------------------------------------------------<font =
size=3D2><span
style=3D'font-size:10.0pt'>  </span></font> <br>
Work like you don't need money,love like<font size=3D2><span =
style=3D'font-size:
10.0pt'> </span></font><br>
you've never been hurt and, dance like<font size=3D2><span =
style=3D'font-size:10.0pt'>
</span></font><br>
no one's watching.<font size=3D2><span style=3D'font-size:10.0pt'> =
</span></font><br>
~Anon<font size=3D2><span style=3D'font-size:10.0pt'> =
 </span></font> <br>
<br>
  <br>
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>-----Original =
Message-----</span></font>
<br>
<b><font size=3D2><span =
style=3D'font-size:10.0pt;font-weight:bold'>From:</span></font></b><font
size=3D2><span style=3D'font-size:10.0pt'> christian.schuster at rsag.ch
 [mailto:christian.schuster at rsag.ch]</span></font> <br>
<b><font size=3D2><span =
style=3D'font-size:10.0pt;font-weight:bold'>Sent:</span></font></b><font
size=3D2><span style=3D'font-size:10.0pt'> Wednesday, January 29, 2003 =
 8:50 AM</span></font>
<br>
<b><font size=3D2><span =
style=3D'font-size:10.0pt;font-weight:bold'>To:</span></font></b><font
size=3D2><span style=3D'font-size:10.0pt'> =
mapserver-users at lists.gis.umn.edu</span></font>
<br>
<b><font size=3D2><span =
style=3D'font-size:10.0pt;font-weight:bold'>Subject:</span></font></b><fo=
nt
size=3D2><span style=3D'font-size:10.0pt'>  [Mapserver-users] Error =
Parsing
POSTGIS connection  information</span></font> <br>
<br>
<br>
Hi list, <br>
<br>
I am a  newbie an struggeling with getting GIS data from the =
database. I
get the  following error in the browser <br>
<br>
<b><span style=3D'font-weight:bold'>msPOSTGISLayerOpen(): Query error. =
Error
parsing POSTGIS connection  information.</span></b> <br>
<br>
This is my layer  definition: <br>
<br>
<b><span style=3D'font-weight:bold'>LAYER</span></b> <br>
<b><span style=3D'font-weight:bold'>  CONNECTIONTYPE =
postgis</span></b> <br>
<b><span style=3D'font-weight:bold'>   NAME =
"points"</span></b>
<br>
<br>
<b><span style=3D'font-weight:bold'>  ### Connect to a  remote =
spatial
database</span></b> <br>
<b><span style=3D'font-weight:bold'>  CONNECTION =
 "user=3D***
dbname=3DmyGISdb host=3D127.0.0.1"</span></b> <br>
<br>
<b><span style=3D'font-weight:bold'>  ### Get the points from the =
'col1'
column of the 't1'  table</span></b> <br>
<b><span style=3D'font-weight:bold'>  DATA "col1 from =
t1"</span></b>
  <br>
<b><span style=3D'font-weight:bold'>  STATUS ON</span></b> <br>
<b><span style=3D'font-weight:bold'>   TYPE POINT</span></b> =
<br>
<br>
<b><span style=3D'font-weight:bold'>  CLASS</span></b>   <br>
<b><span style=3D'font-weight:bold'>    COLOR 255 0 0   =

  </span></b> <br>
<b><span style=3D'font-weight:bold'>  END</span></b> <br>
<b><span style=3D'font-weight:bold'>END</span></b> <br>
<b><span style=3D'font-weight:bold'>### end of layer =
 definitions</span></b>
<br>
<br>
Any help is welcome.   <br>
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>Christian =
Schuster</span></font> <br>
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>Rudolf Schuster =
 AG</span></font>
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>Postfach =
277</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>CH - 3000 Bern =
11</span></font> <br>
<br>
<font size=3D2><span =
style=3D'font-size:10.0pt'>http://www.rsag.ch</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>++41 31  348 05 =
30</span></font>
<o:p></o:p></p>

</div>

</div>

</body>

</html>
=00
------_=_NextPart_001_01C2C847.C44F5784--