[OSM-talk-nl] Mapserver installatie

[Peter Peterse]

Hallo,

Ik probeer een mapserver met postgis aan de praat te krijgen. Alleen de
configuratie hiervan is mij nog onduidelijk.

LAYER
  NAME "Wegen"
  TYPE line
  STATUS on
  CONNECTIONTYPE postgis
  CONNECTION "host=localhost dbname=gis user={gebruikersnaam} password={ww}"
  DATA "way from planet_osm_roads"
  TRANSPARENCY 30
  FILTER "highway = 'secondary'"
  CLASS
    STYLE
      COLOR 128 255 255
      OUTLINECOLOR 0 255 0
      WIDTH 2
    END
  END
  METADATA
    "wms_title"  "Wegen"
    "wms_srs"   "EPSG:28992"
  END
  PROJECTION
       "init=epsg:28992"
  END
END
Ik probeer hier alle wegen te vinden welke in de tabel planet_osm_roads,
kolom highway als secondary genoteerd staan.

Vervolgens komt er een foutmelding:
<ServiceExceptionReport version="1.1.1">
  <ServiceException>msDrawMap(): Image handling error. Failed to draw
layer named 'Wegen'. prepare_database(): Query error. Error executing
POSTGIS DECLARE (the actual query) statement: 'DECLARE mycursor BINARY
CURSOR FOR SELECT
asbinary(force_collection(force_2d(way)),'NDR'),OID::text from
planet_osm_roads WHERE (highway = 'secondary') and (way && setSRID(
'BOX3D(119500.416666667 485500.416666667,119999.583333333
485999.583333333)'::BOX3D,find_srid('','planet_osm_roads','way') ))'
Postgresql reports the error as 'ERROR: column "oid" does not exist LINE
1: ...T asbinary(force_collection(force_2d(way)),'NDR'),OID::text ... ^
' More Help: Error with POSTGIS data variable. You specified 'check your
.map file'. Standard ways of specifiying are : (1) 'geometry_column from
geometry_table' (2) 'geometry_column from (sub query) as foo using
unique column name using SRID=srid#' Make sure you put in the 'using
unique column name' and 'using SRID=#' clauses in. For more help, please
see http://postgis.refractions.net/documentation/ Mappostgis.c - version
of Jan 23/2004.</ServiceException>
  </ServiceExceptionReport>

Is er iemand die een idee heeft wat ik fout doe en hoe ik het kan oplossen?

Alvast bedankt.

Peter