[mapserver-users] MapServer 3.5 & Postgis

Wed May 15 10:13:52 EDT 2002

Hi

I'm a newbie with GIS, so please have patience :)

I have installed the PostGIS 0.7 extension with Postgresql 7.2 (RedHat 
7.3), and PostGIS seems fine. I have managed to convert and input shp file 
data.

I have also compiled mapserver 3.5 and the itasca demo works fine.
I compiled mapserver with this ./configure :

./configure --with-proj=/usr/local/lib --with-postgis=yes --with-wmsclient

I then wrote a simple map file for the data I had input into postgres. 
This is the abandoned mine land data from http://www.nationalatlas.gov/atlasftp.html

When reading directly from shp files, this .map file works :

NAME EX1
EXTENT -159.6 28.77 -71.4667 70.5
SIZE 400 300
SHAPEPATH "../data"
LAYER # start of the "mines" layer object
  NAME "mines"
  DATA abnminx020
  STATUS DEFAULT
  TYPE POINT
  CLASS
    COLOR 120 120 220
    OUTLINECOLOR 10 10 0
  END # end of class object
END # end of layer object
END # end of map file

However, if I add :
  CONNECTIONTYPE local
into the LAYER section, I get this error :

<HTML>
<HEAD><TITLE>MapServer Message</TITLE></HEAD>

<BODY BGCOLOR="#FFFFFF">
getSymbol(): Symbol definition error. (local):(5)
</BODY></HTML>

If I change the map file to read from the database :

NAME EX2
EXTENT -159.6 28.77 -71.4667 70.5
SIZE 400 300
LAYER # start of the "mines" layer object
  CONNECTIONTYPE postgis
  NAME "mines"
  CONNECTION "user=xxx password=xxx dbname=mines host=localhost port=5432"
  DATA "the_geom from themines"
  STATUS ON
  TYPE POINT
  CLASS
    COLOR 120 120 220
    OUTLINECOLOR 10 10 0
  END # end of class object
END # end of layer object
END # end of map file

then I get a plain white .png with no detail at all.

Any help would be much appreciated - I'm rather stumped at the moment !

Regards and thanks in advance

Arif Saleem