Hi <br>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.<br>-------------------------------------------------<br>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"><meta name="ProgId" content="Word.Document"><meta name="Generator" content="Microsoft Word 11"><meta name="Originator" content="Microsoft Word 11"><link rel="File-List" href="file:///C:%5CDOCUME%7E1%5Cphapal%5CLOCALS%7E1%5CTemp%5Cmsohtml1%5C05%5Cclip_filelist.xml"><style>
<!--
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
        {mso-style-parent:"";
        margin:0cm;
        margin-bottom:.0001pt;
        mso-pagination:widow-orphan;
        font-size:12.0pt;
        font-family:"Times New Roman";
        mso-fareast-font-family:"Times New Roman";}
@page Section1
        {size:612.0pt 792.0pt;
        margin:72.0pt 90.0pt 72.0pt 90.0pt;
        mso-header-margin:36.0pt;
        mso-footer-margin:36.0pt;
        mso-paper-source:0;}
div.Section1
        {page:Section1;}
-->
</style>
<p class="MsoNormal"><span style="font-family: "Courier New";"><OGRVRTDataSource></span></p>
<p class="MsoNormal"><span style="font-family: "Courier New";"><span style=""> </span><OGRVRTLayer name="nsdb"> </span></p>
<p class="MsoNormal"><span style="font-family: "Courier New";"><span style="">
</span><SrcDataSource>MYSQL:dispro,user=uuuuuu,password=pppp,host=192.170.1.100,port=3306,tables=STATION</SrcDataSource>
</span></p>
<p class="MsoNormal"><span style="font-family: "Courier New";"><span style=""> </span><SrcSQL>SELECT absnum, stlat,
stlon, stflag FROM STATION</SrcSQL> </span></p>
<p class="MsoNormal"><span style="font-family: "Courier New";"><span style=""> </span><GeometryType>wkbPoint</GeometryType></span></p>
<p class="MsoNormal"><span style="font-family: "Courier New";"><span style=""> </span><GeometryField
encoding="PointFromColumns" x="stlon"
y="stlat"/> </span></p>
<p class="MsoNormal"><span style="font-family: "Courier New";"><span style=""> </span></OGRVRTLayer></span></p>
<p class="MsoNormal"><span style="font-family: "Courier New";"></OGRVRTDataSource></span></p>
--------------------------------------------------<br><br><br><br><br>When I run the command :<br><meta http-equiv="Content-Type" content="text/html; charset=utf-8"><meta name="ProgId" content="Word.Document"><meta name="Generator" content="Microsoft Word 11"><meta name="Originator" content="Microsoft Word 11"><link rel="File-List" href="file:///C:%5CDOCUME%7E1%5Cphapal%5CLOCALS%7E1%5CTemp%5Cmsohtml1%5C01%5Cclip_filelist.xml"><style>
<!--
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
        {mso-style-parent:"";
        margin:0cm;
        margin-bottom:.0001pt;
        mso-pagination:widow-orphan;
        font-size:12.0pt;
        font-family:"Times New Roman";
        mso-fareast-font-family:"Times New Roman";}
@page Section1
        {size:612.0pt 792.0pt;
        margin:72.0pt 90.0pt 72.0pt 90.0pt;
        mso-header-margin:36.0pt;
        mso-footer-margin:36.0pt;
        mso-paper-source:0;}
div.Section1
        {page:Section1;}
-->
</style>ogrinfo
/mnt/fritjof/wms/nsdb/con.ovf <br><br>ogrinfo returns :<br><meta http-equiv="Content-Type" content="text/html; charset=utf-8"><meta name="ProgId" content="Word.Document"><meta name="Generator" content="Microsoft Word 11"><meta name="Originator" content="Microsoft Word 11"><link rel="File-List" href="file:///C:%5CDOCUME%7E1%5Cphapal%5CLOCALS%7E1%5CTemp%5Cmsohtml1%5C03%5Cclip_filelist.xml"><style>
<!--
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
        {mso-style-parent:"";
        margin:0cm;
        margin-bottom:.0001pt;
        mso-pagination:widow-orphan;
        font-size:12.0pt;
        font-family:"Times New Roman";
        mso-fareast-font-family:"Times New Roman";}
@page Section1
        {size:612.0pt 792.0pt;
        margin:72.0pt 90.0pt 72.0pt 90.0pt;
        mso-header-margin:36.0pt;
        mso-footer-margin:36.0pt;
        mso-paper-source:0;}
div.Section1
        {page:Section1;}
-->
</style>
<br><p class="MsoNormal" style="border: medium none ; padding: 0cm;"><span style="font-family: "Courier New";">ERROR 4: Update access not supported for VRT datasources.</span></p>
<p class="MsoNormal" style="border: medium none ; padding: 0cm;"><span style="font-family: "Courier New";">Had to open data source read-only.</span></p>
<p class="MsoNormal" style="border: medium none ; padding: 0cm;"><span style="font-family: "Courier New";">INFO: Open of `/mnt/fritjof/wms/nsdb/con.ovf'</span></p>
<p class="MsoNormal" style="border: medium none ; padding: 0cm;"><span style="font-family: "Courier New";"><span style=""> </span>using driver `VRT'
successful.</span></p>
<span style="font-family: "Courier New";">1: nsdb (Point)</span><br>.....................................................................................................................................<br><br>I have a map file con.map as follows:<br>
-------------------------------------------------------------<br>MAP<br> NAME "MYSQL-TEST"<br> EXTENT -180 -90 180 90 <br> UNITS dd<br> CONFIG "CPL_DEBUG" "ON"<br><br> PROJECTION<br> "init=epsg:4326"<br>
END<br><br> SHAPEPATH "/mnt/fritjof/wms/nsdb"<br><br> LAYER<br> DEBUG ON<br> METADATA<br> "wms_title" "nsdb"<br> "wms_srs" "EPSG:4326"<br> "wms_extent" "-57.768 64.1842 -51.6283 64.3645"<br>
END<br> NAME "stations" <br> STATUS DEFAULT <br> TYPE POINT<br> CONNECTIONTYPE OGR<br> CONNECTION "con.ovf"<br> DATA "nsdb"<br> PROJECTION<br> "init=epsg:4326"<br>
END<br> EXTENT -57.768 64.1842 -51.6283 64.3645<br> CLASS<br> NAME "MyClass"<br> STYLE<br> SYMBOL 1<br> SIZE 15<br> COLOR 255 0 0<br> END<br> END<br> END<br><br>
END<br>........................................<br>And I have another html form: <br><br>========================================================<br><br>MAPFILE <input name="MAP" value="/Data/wms/test/test1.map" size="40" type="text">
<br>REQUEST <input name="REQUEST" value="GetMap" size="40" type="text">
<br>SERVICE<input name="SERVICE" value="WMS" size="40" type="text">
<br>VERSION<input name="VERSION" value="1.1.1" size="40" type="text">
<br>LAYERS<input name="LAYERS" value="coastline" size="40" type="text">
<br>STYLES<input name="STYLES" value="default" size="40" type="text">
<br>SRS<input name="SRS" value="EPSG:4326" size="40" type="text">
<br>BBOX<input name="bbox" value="-4,51,14,64" size="40" type="text">
<br>WIDTH<input name="WIDTH" value="800" size="40" type="text">
<br>HEIGHT<input name="HEIGHT" value="600" size="40" type="text">
<br>FORMAT<input name="FORMAT" value="image/png" size="40" type="text">
<br><br><br><br>