[Mapserver-users] PostGIS questions - help with mapserver

[Zamil Murji]

Hi David,

I tried your data string. It comes back really fast but with the exact same result, the following error message:
msDrawMap(): Image handling error. Failed to draw layer named 'oilwells'. 

I downloaded this from the mapserver website. Here is some interesting stuff:
I'm using PostgreSQL 7.3.3 and PostGIS 0.7.5
Both are fairly new, do you think there is a problem with this? If so what versions are supported?

mapserv -v results in the following:
MapServer version 4.0-beta1 OUTPUT=GIF OUTPUT=PNG OUTPUT=JPEG OUTPUT=WBMP OUTPUT
=PDF OUTPUT=SWF SUPPORTS=PROJ SUPPORTS=FREETYPE SUPPORTS=WMS_SERVER SUPPORTS=WMS
_CLIENT SUPPORTS=WFS_SERVER SUPPORTS=WFS_CLIENT INPUT=EPPL7 INPUT=POSTGIS INPUT=
OGR INPUT=GDAL INPUT=SHAPEFILE

Thanks,
Zamil
-----Original Message-----
From: David Blasby [mailto:dblasby at refractions.net]
Sent: Monday, July 07, 2003 4:50 PM
To: Zamil Murji
Cc: mapserver-users at lists.gis.umn.edu
Subject: Re: [Mapserver-users] PostGIS questions - help with mapserver


Zamil Murji wrote:

>    CONNECTIONTYPE postgis
>    CONNECTION "user=idc dbname=idc host=sdb2 port=5432" 
>    DATA "GEOM FROM OILWELLS" 

Try using:

DATA "geom from (select * from oilwells) as foo using unique id using 
SRID=4326"

If that doesnt help, it sound like it might be a problem upstream from 
the postgis connector.  What version of mapserver are you using?

dave