[Mapserver-users] Mapserver Postgis connection issues

[IMD Listuser]

Greetings

I have a question regarding PostGIS & Postgresql.

Ive downloaded & unzipped the same version as cited below. Do I also need to download and install cygwin, etc. as per the guidance on the postgres web site, or am I good to go with just pgsql75win.zip?

Thanks

PS: Any other guidance for a newcomer to postgres would be appreciated.

Charlie

-----Original Message-----
From: mapserver-users-admin at lists.gis.umn.edu [mailto:mapserver-users-admin at lists.gis.umn.edu] On Behalf Of Swaminathan, Gayathri
Sent: Friday, July 16, 2004 4:08 PM
To: Vladimir Guzmán; Kathi Koebke
Cc: mapserver-users at lists.gis.umn.edu
Subject: [Mapserver-users] Mapserver Postgis connection issues

Hi:

I downloaded the latest version of mapserver (4.2.1) from mapserver's site

I am using it a windows 2000 server running IIS...

Postgresql version 7.5 from Mark Ayland's snapshot...http://www.webbased.co.uk/mca/pgsql75win.zip

I have been able to compile install and run just shapefiles fine on this newer version..

If I added a Postgis layer however..I am having the mapserver cgi run indefinetely and locking up.

I have checked/tried the following:

1) Checked for multiple instances of dlls and verified.
2) Checked if my query ran fine with psql and it works fine
3) I am able to connect to my postgresql database using PGADMIN AND EMS2 POSTGRESQL MANAGER.
4) Checked for my data statement issues...

Here is the layer I am trying to get mapserver work on

### SEWERLINES (SELECTED) ###
LAYER 
	GROUP "CIP Features"
	CONNECTIONTYPE postgis
	CONNECTION "user=postgres dbname=mydb host=myhostname"
#	Data is written on the fly from calling form.
	DATA "the_geom from (select oid,* from sewerline where GEO_CIP='SEWL001') as foo using unique gid using srid=4326"

	NAME sqlSewerline
	TYPE LINE
	STATUS OFF
	PROJECTION #GEOGRAPHIC NAD83
		proj=longlat
		ellps=GRS80 
		no_defs 
	END
	CLASS#
		NAME "Sewer lines (Selected)"
	    COLOR 200 0 0 
		#COLOR 200 251 187
		SIZE 2
	END
	METADATA
		legend_order "200"
		"NoID" "1"
		"NoLabels" "1"
	END

Am I missing something obvious? Thanks for all the help in advance.

Gayathri

_______________________________________________
Mapserver-users mailing list
Mapserver-users at lists.gis.umn.edu
http://lists.gis.umn.edu/mailman/listinfo/mapserver-users