[mapserver-dev] Map server

Phalguni Pal phalguni.pal at gmail.com
Mon Feb 23 12:25:48 EST 2009


Hi
I am trying to display few points on the browser using Mapserver. I have
created MySQL database and created connection with mapserver by the help of
.ovf xml file.
-------------------------------------------------

<OGRVRTDataSource>

    <OGRVRTLayer name="nsdb">

             <SrcDataSource>MYSQL:dispro,user=uuuuuu,password=pppp,host=192.170.1.100,port=3306,tables=STATION</SrcDataSource>


        <SrcSQL>SELECT absnum, stlat, stlon, stflag FROM STATION</SrcSQL>

        <GeometryType>wkbPoint</GeometryType>

        <GeometryField encoding="PointFromColumns" x="stlon" y="stlat"/>

    </OGRVRTLayer>

</OGRVRTDataSource>
--------------------------------------------------




When I run the command :
ogrinfo  /mnt/fritjof/wms/nsdb/con.ovf

ogrinfo returns :

ERROR 4: Update access not supported for VRT datasources.

Had to open data source read-only.

INFO: Open of `/mnt/fritjof/wms/nsdb/con.ovf'

      using driver `VRT' successful.
1: nsdb (Point)
.....................................................................................................................................
Version details of mapserver and GDAL as follows:

$ ./mapserv -v
MapServer version 4.10.3 OUTPUT=GIF OUTPUT=PNG OUTPUT=JPEG OUTPUT=WBMP
OUTPUT=PDF OUTPUT=SVG SUPPORTS=PROJ SUPPORTS=FREETYPE SUPPORTS=WMS_SERVER
SUPPORTS=WMS_CLIENT SUPPORTS=WFS_SERVER SUPPORTS=WFS_CLIENT
SUPPORTS=WCS_SERVER SUPPORTS=THREADS INPUT=EPPL7 INPUT=OGR INPUT=GDAL
INPUT=SHAPEFILE DEBUG=MSDEBUG


$ gdal-config --version
1.5.3


I have a map file con.map as follows:
-------------------------------------------------------------
MAP
  NAME "MYSQL-TEST"
  EXTENT  -180 -90 180 90
  UNITS dd
  CONFIG "CPL_DEBUG" "ON"

  PROJECTION
  "init=epsg:4326"
  END

  SHAPEPATH "/mnt/fritjof/wms/nsdb"

  LAYER
    DEBUG ON
    METADATA
      "wms_title" "nsdb"
      "wms_srs" "EPSG:4326"
      "wms_extent" "-57.768 64.1842 -51.6283 64.3645"
    END
    NAME "stations"
    STATUS DEFAULT
    TYPE POINT
    CONNECTIONTYPE OGR
    CONNECTION "con.ovf"
    DATA "nsdb"
    PROJECTION
      "init=epsg:4326"
    END
    EXTENT -57.768 64.1842 -51.6283 64.3645
    CLASS
      NAME "MyClass"
      STYLE
        SYMBOL 1
        SIZE 15
        COLOR 255 0 0
          END
    END
 END

END
........................................
And I have another html form from where I am trying to display in browser
the Latitude and longitude points which are stored in database.

========================================================

MAPFILE
REQUEST
SERVICE
VERSION
LAYERS
STYLES
SRS
BBOX
WIDTH
HEIGHT
FORMAT




=================================
But Mapserver is displaying nothing and does not giving any error. Just it's
showing a blank map. Could you tell me Why??
What's the problem may be happen??
Thanking you.
Regards,
Phalguni
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapserver-dev/attachments/20090223/6b92f022/attachment.html


More information about the mapserver-dev mailing list