[Mapserver-users] postGIS problems

[Lowther, David W]

Any ideas from the mapserver list?

-----Original Message-----
From: Swaminathan, Gayathri [mailto:gayathri at ou.edu]
Sent: Tuesday, December 17, 2002 11:20 AM
To: 'postgis-users at postgis.refractions.net'
Subject: [postgis-users] postGIS problems


Hi:
I am having a problem accessing my postgres server from my webserver....

Both are in different IP ranges.,(the web server is remote and the Postgres
server is in my domain....)

The error am getting is as follows:

"msPOSTGISLayerOpen(): Query error. Error parsing POSTGIS connection
information. "
I have the map file with the following layer information:
### ROADS (QUERY) ###
LAYER
	GROUP "Selected"
	NAME "gradysqlRoads"
	CONNECTIONTYPE postgis
	CONNECTION "user=geopostgres password=***** dbname=ACCO_Data
host=129.15.172.* port=5432"
#	DATA is written on the fly from calling form.
	TYPE LINE
	STATUS OFF
	PROJECTION #GEOGRAPHIC NAD83
		proj=longlat
		ellps=GRS80 
		no_defs 
	END
	TEMPLATE "IDgradyRoads.htm"
	CLASS#
		NAME "Grady Roads (Selected)"
		SYMBOL "line"
		SIZE 2
		OUTLINECOLOR -1 -1 -1
		COLOR 245 10 10 
	END
	METADATA
		legend_order "1"
	END
END
I have tried the following things,
Grant select access to public,
Check the port 5432 is listening in my linux server

Thanks so much,
Gayathri Swaminathan
University Of Oklahoma
Geo Information Systems
(405) 325 3131 x 237
(405) 904 4673
visit us @ http://geo.ou.edu



_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users