[mapserver-users] Cannot read shp file from database

[Jeremy JK]

Hello all,
On my virtualbox linuxmint machine I can view a shp file with MapServer
when the shp file is on filesystem.
When I put it into the database, the browser returns an error message
but ogrinfo program can read the database well.
See below

And thanks for your assistance
J

*Error*: msLoadMap(): Unknown identifier. Parsing error near
(CONNECTIONTYPE):(line 9)
*Petition*:
http://localhost:8080/cgi-bin/mapserv?map=/opt/mapfile/mapserver_quickstart.map&SERVICE=WMS&REQUEST=Getmap&VERSION=1.1.1&LAYERS=Countries&SRS=EPSG:4326&BBOX=-137,29,-53,88&FORMAT=PNG&WIDTH=800&HEIGHT=600


*ogrinfo *PG:"host=127.0.0.1 user=postgres password=StrongAdminP at ssw0rd
dbname=news_test_shp port=5432" sample.admintable -summary
INFO: Open of `PG:host=127.0.0.1 user=postgres password=StrongAdminP at ssw0rd
dbname=news_test_shp port=5432'
      using driver `PostgreSQL' successful.

Layer name: sample.admintable
Geometry: Multi Polygon
Feature Count: 258
Extent: (-180.000000, -90.000000) - (180.000000, 83.634101)
Layer SRS WKT:
GEOGCRS["WGS 84",
    DATUM["World Geodetic System 1984",
        ELLIPSOID["WGS 84",6378137,298.257223563,
            LENGTHUNIT["metre",1]]],
    PRIMEM["Greenwich",0,
        ANGLEUNIT["degree",0.0174532925199433]],
    CS[ellipsoidal,2],
        AXIS["geodetic latitude (Lat)",north,
            ORDER[1],
            ANGLEUNIT["degree",0.0174532925199433]],
        AXIS["geodetic longitude (Lon)",east,
            ORDER[2],
            ANGLEUNIT["degree",0.0174532925199433]],
    ID["EPSG",4326]]
Data axis to CRS axis mapping: 2,1
...

+++++++++++++++++++++++++++++++++++++++++++++++++++
*MAP*
  NAME "MAPSERVER_QUICKSTART"
  EXTENT -137 29 -53 88
  UNITS DD
  SHAPEPATH "/opt/mapfile"
  SIZE 800 600

  IMAGETYPE PNG24
  CONNECTIONTYPE postgis
  CONNECTION "user=postgres password=StrongAdminP at ssw0rd
dbname=news_test_shp host=127.0.0.1 port=5432"
  DATA "geom from sample.admintable using unique gid using srid=9000913"


  PROJECTION
    "init=epsg:4326"
  END

  WEB
    METADATA
      ows_title "MapServer Quickstart"
      ows_enable_request "*"
      ows_srs "EPSG:4326 EPSG:25832 EPSG:25833"
    END
  END

  LAYER
    NAME "Countries"
    STATUS ON
    TYPE POLYGON
    DATA "ne_10m_admin_0_countries"
    CLASS
      STYLE
        COLOR 246 241 223
        OUTLINECOLOR 0 0 0
      END
    END
  END

END
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20220328/074d9e74/attachment.html>