Hi Mapserver users,<br><br><div class="gmail_quote"><div class="Ih2E3d">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><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></div>
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>
<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><div><div><span id="q_11fa43dc9de607cf_3" class="WQ9l9c">- Show quoted text -</span></div>
<div class="Wj3C7c">
<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></div></div>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><div class="Ih2E3d"><br>========================================================<br>
<div style="border: 1pt solid windowtext; padding: 1pt 4pt;">
<p style="border: medium none ; padding: 0cm;">MAPFILE <span> </span><input size="40" name="MAP" value="/mnt/fritjof/wms/nsdb/con2.map" type="text"><span> </span><br>
REQUEST<span> </span><input size="40" name="REQUEST" value="GetMap" type="text">
<br>
SERVICE<span> </span><input size="40" name="SERVICE" value="WMS" type="text">
<br>
VERSION<span> </span><input size="40" name="VERSION" value="1.1.1" type="text">
<br>
LAYERS<span> </span><input size="40" name="LAYERS" value="wind" type="text"><span> </span> <br>
STYLES<span> </span><input size="40" name="STYLES" value="default" type="text">
<br>
SRS<span> </span><input size="40" name="SRS" value="EPSG:4326" type="text">
<br>
BBOX<span> </span><input size="40" name="bbox" value="-4,51,14,64" type="text">
<br>
WIDTH<span> </span><input size="40" name="WIDTH" value="800" type="text">
<br>
HEIGHT<span> </span><input size="40" name="HEIGHT" value="600" type="text">
<br>
FORMAT<span> </span><input size="40" name="FORMAT" value="image/png" type="text">
<br>
<br>
</p>
<p style="border: medium none ; padding: 0cm;"><input action="http://mapserver.nersc.no/cgi-bin/mapserv?" method="get" type="submit"></p>
<p style="border: medium none ; padding: 0cm;"> </p>
</div>
</div></div><br><br>=========================================<div id=":1hy" class="ArwC7c ckChnd"><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><font color="#888888">Phalguni <br></font></div>