[Mapserver-users] Fwd:

[Steve Lime]

--=_85DAB651.0D6C1BC2
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

 
--=_85DAB651.0D6C1BC2
Content-Type: message/rfc822

Received: from mail.state.mn.us
	(state.mn.us [156.99.125.109])
	by co5.dnr.state.mn.us; Tue, 17 Dec 2002 10:05:20 -0600
Return-Path: <gayathri at ou.edu>
Received: from hubmail.oulan.ou.edu by mail.state.mn.us with ESMTP for steve.lime at dnr.state.mn.us; Tue, 17 Dec 2002 09:57:04 -0600
Received: by hubmail.oulan.ou.edu with Internet Mail Service (5.5.2656.59)
	id <YPGWZ4M8>; Tue, 17 Dec 2002 09:57:02 -0600
Message-Id: <FC0CEBD77311DA499A67ADB355A24FA2C59D97 at mail4.oulan.ou.edu>
From: "Swaminathan, Gayathri" <gayathri at ou.edu>
To: "'steve.lime at dnr.state.mn.us'" <steve.lime at dnr.state.mn.us>
Subject: 
Date: Tue, 17 Dec 2002 09:55:57 -0600
X-Mailer: Internet Mail Service (5.5.2656.59)
MIME-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"

Hi:
I am trying to connect to a Postgres Linux server from a windows NT web
server...

I am having problems with PostGIS connection....Both these servers are in
different IP ranges., (the web server is remote) and am trying to make it
access a Linux box in my domain.


Mapserver comes with this error message
"msPOSTGISLayerOpen(): Query error. Error parsing POSTGIS connection
information. "
can you help me on this?
I have defined my layer like this.,
### ROADS ###
LAYER
	GROUP "Selected"
	NAME "gradyRoads"
	CONNECTIONTYPE postgis
	CONNECTION "user=geopostgres password=**** dbname=ACCO_Data
host=129.15.172.*"
	DATA "the_geom from (select oid,* from roads) as foo"
	TYPE LINE
	STATUS DEFAULT
	PROJECTION #GEOGRAPHIC NAD83
		proj=longlat
		ellps=GRS80 
		no_defs 
	END
	TEMPLATE "IDgradyRoads.htm"
	CLASS#
		NAME "Grady Roads"
		SYMBOL "line"
		SIZE 2
		OUTLINECOLOR -1 -1 -1
		COLOR 10 200 100 
	END
	METADATA
		legend_order "5"
	END
END
thanks,
Gayathri Swaminathan
University Of Oklahoma
Geo Information Systems
(405) 325 3131 x 237
(405) 904 4673
visit us @ http://geo.ou.edu



--=_85DAB651.0D6C1BC2--