[Mapserver-users] PostGIS questions - help with mapserver

[Zamil Murji]

Hi All,

I found the error! I didn't have an entry in my pg_hba.conf file to allow the mapserver host to connect to the postgis server. Oops! Maybe someone should add this to the WIKI.

Thanks for all your help.
Zamil

-----Original Message-----
From: Zamil Murji 
Sent: Monday, July 07, 2003 5:04 PM
To: David Blasby
Cc: mapserver-users at lists.gis.umn.edu
Subject: RE: [Mapserver-users] PostGIS questions - help with mapserver


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





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