Hi <br><div class="gmail_quote">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>
<p><span style="font-family: "Courier New";"><OGRVRTDataSource></span></p>
<p><span style="font-family: "Courier New";"><span> </span><OGRVRTLayer name="nsdb"> </span></p>
<p><span style="font-family: "Courier New";"><span>
</span><SrcDataSource>MYSQL:dispro,user=uuuuuu,password=pppp,host=192.170.1.100,port=3306,tables=STATION</SrcDataSource>
</span></p>
<p><span style="font-family: "Courier New";"><span> </span><SrcSQL>SELECT absnum, stlat,
stlon, stflag FROM STATION</SrcSQL> </span></p>
<p><span style="font-family: "Courier New";"><span> </span><GeometryType>wkbPoint</GeometryType></span></p>
<p><span style="font-family: "Courier New";"><span> </span><GeometryField
encoding="PointFromColumns" x="stlon"
y="stlat"/> </span></p>
<p><span style="font-family: "Courier New";"><span> </span></OGRVRTLayer></span></p>
<p><span style="font-family: "Courier New";"></OGRVRTDataSource></span></p>
--------------------------------------------------<br><br><br><br><br>When I run the command :<br>ogrinfo
/mnt/fritjof/wms/nsdb/con.ovf <br><br>ogrinfo returns :<br>
<br><p style="border: medium none ; padding: 0cm;"><span style="font-family: "Courier New";">ERROR 4: Update access not supported for VRT datasources.</span></p>
<p style="border: medium none ; padding: 0cm;"><span style="font-family: "Courier New";">Had to open data source read-only.</span></p>
<p style="border: medium none ; padding: 0cm;"><span style="font-family: "Courier New";">INFO: Open of `/mnt/fritjof/wms/nsdb/con.ovf'</span></p>
<p style="border: medium none ; padding: 0cm;"><span style="font-family: "Courier New";"><span> </span>using driver `VRT'
successful.</span></p>
<span style="font-family: "Courier New";">1: nsdb (Point)</span><br>.....................................................................................................................................<br>Version details of mapserver and GDAL as follows: <br>
<pre><font size="4">$ ./mapserv -v<br>MapServer version 4.10.3 OUTPUT=GIF OUTPUT=PNG OUTPUT=JPEG OUTPUT=WBMP <br>OUTPUT=PDF OUTPUT=SVG SUPPORTS=PROJ SUPPORTS=FREETYPE SUPPORTS=WMS_SERVER <br>SUPPORTS=WMS_CLIENT SUPPORTS=WFS_SERVER SUPPORTS=WFS_CLIENT <br>
SUPPORTS=WCS_SERVER SUPPORTS=THREADS INPUT=EPPL7 INPUT=OGR INPUT=GDAL <br>INPUT=SHAPEFILE DEBUG=MSDEBUG<br><br><br>$ gdal-config --version<br>1.5.3</font></pre>
<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 from where I am trying to display in browser the Latitude and longitude points which are stored in database. <br><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%5C07%5Cclip_filelist.xml"><link rel="Edit-Time-Data" href="file:///C:%5CDOCUME%7E1%5Cphapal%5CLOCALS%7E1%5CTemp%5Cmsohtml1%5C07%5Cclip_editdata.mso"><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>
<div style="border: 1pt solid windowtext; padding: 1pt 4pt;">
<p class="MsoNormal" style="border: medium none ; padding: 0cm;">MAPFILE <span style=""> </span><input size="40" name="MAP" value="/mnt/fritjof/wms/nsdb/con2.map" type="text"><span style=""> </span><br>
REQUEST<span style=""> </span><input size="40" name="REQUEST" value="GetMap" type="text">
<br>
SERVICE<span style=""> </span><input size="40" name="SERVICE" value="WMS" type="text">
<br>
VERSION<span style=""> </span><input size="40" name="VERSION" value="1.1.1" type="text">
<br>
LAYERS<span style=""> </span><input size="40" name="LAYERS" value="wind" type="text"><span style=""> </span> <br>
STYLES<span style=""> </span><input size="40" name="STYLES" value="default" type="text">
<br>
SRS<span style=""> </span><input size="40" name="SRS" value="EPSG:4326" type="text">
<br>
BBOX<span style=""> </span><input size="40" name="bbox" value="-4,51,14,64" type="text">
<br>
WIDTH<span style=""> </span><input size="40" name="WIDTH" value="800" type="text">
<br>
HEIGHT<span style=""> </span><input size="40" name="HEIGHT" value="600" type="text">
<br>
FORMAT<span style=""> </span><input size="40" name="FORMAT" value="image/png" type="text">
<br style="">
<br style="">
</p>
<p class="MsoNormal" style="border: medium none ; padding: 0cm;"><input action="http://mapserver.nersc.no/cgi-bin/mapserv?" method="get" type="submit"></p>
<p class="MsoNormal" style="border: medium none ; padding: 0cm;"> </p>
</div>
</div><br><br>=================================<br>But Mapserver is displaying nothing and does not giving any error. Just it's showing a blank map. Could you tell me Why??<br>What's the problem may be happen??<br>
Thanking you.<br>Regards,<br>Phalguni <br><br><pre><br><br><br></pre> <br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br>