[Mapserver-users] postgis data statement

[Zamil Murji]

hi,

Maybe it isn't the data statement that is hooped. Maybe you don't have the proper permissions set for the database. Does the user/password that you supply to your connection string work? Is it a TRUSTed user? Maybe you need to give the box that mapserver is installed on TRUSTed access to that postgres db. Take a look at your pg_conf.hba file (i think that is what it is called).

Hope this helps.
Zamil

-----Original Message-----
From: mapserver-users-admin at lists.gis.umn.edu
[mailto:mapserver-users-admin at lists.gis.umn.edu]On Behalf Of knozi
Sent: Thursday, March 25, 2004 4:34 AM
To: mapserver-users at lists.gis.umn.edu
Subject: [Mapserver-users] postgis data statement


hi list,
i've some problems with a postgis data statement.

DATA "the_geom from 
    	(select gd_world_samplesite.the_geom,td_samplesite.maxdepth,case
		when td_samplesite.maxdepth > 1000 then 1 
		when td_samplesite.maxdepth > 500 then 2 
		else 3 
		end as myclass 
	from gd_world_samplesite,td_samplesite where
gd_world_samplesite.ssid = td_samplesite.samplesiteid)
	as foo using unique gd_world_samplesite.oid using SRID=4326"

when I execute the statement in postgres it works fine, but mapserver cannot
handle it.
The funny thing is that a similar statement on the same server, but
accessing another database, works.

I'm using linux, postgresql 7.3.4, postgis 8.1 and Mapserver 4.1. 

any hints?

thanks,
gernot




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