[mapserver-users] Problem with PostGIS layer

[Thomas Haechler]

hello list,

I just start to use postgis with mapserver and can't seem to make it
work. I get a blank browser window and in the source code the following
error message:

MapServer Error in msPOSTGISLayerOpen(): Error parsing POSTGIS
connection information.

Can anyone please tell me what I am missing?

Thank you in advance,

Thomy


P.S.:
I am using php/mapscript version 3.6.1 and this is what I did:

test=# \! createlang plpgsql test 
test=# \! psql -d test -f postgis.sql
test=# \! shp2pgsql borderline.shp borderline test | psql test

test=# CREATE INDEX gist_index
test-# ON borderline
test-# USING GIST ( the_geom GIST_GEOMETRY_OPS );
 
test=# CREATE INDEX oid_index ON borderline ( oid );

test=# VACUUM ANALYZE;  


Mapfile:
# ***********************************
# testlayer postgresql
# ***********************************

LAYER
	NAME "borderline2"
	CONNECTIONTYPE postgis
	CONNECTION "user=thaechl password=***** dbname=test host=localhost
port=5432"
	DATA "the_geom from borderline"
	STATUS DEFAULT
	TYPE LINE
	METADATA
  		"TITLE"	"Grenze SNP"
	END #Metadata
	CLASS
		NAME 'Grenze SNP'
		COLOR 220 20 60 
		SYMBOL 13
		SIZE 2
	END #Class
END #Layer






-- 

THOMAS HAECHLER

Geographic Information Systems Division
Institute of Geography
University of Zurich
Switzerland

thomas.haechler at geo.unizh.ch