<div>Chris,</div>
<div> </div>
<div> Looking at your OGR output, it appears that you do not have MySQL connection support compiled in your MapServer binary. If you run the "mapserver -v" command, you should have see and "INPUT=MYSQL" statement listed. Your OGR support connection list output below should also have MySQL listed.
</div>
<div> </div>
<div> You should be able to find a Windows version of mapserver already precompiled with MySQL support. If you're running LINUX, you'l need to compile the source with MySQL support.</div>
<div> </div>
<div> Some additionaly info about your OS, version, MySQL version, etc would be of help.</div>
<div> </div>
<div> </div>
<div>Cheers,</div>
<div> </div>
<div>Karl</div>
<div>
<p>On Wed, 07 Feb 2007 14:12:45 -0500, Chris Beaart <<a href="mailto:beaart@XS4ALL.NL">beaart@XS4ALL.NL</a>> wrote:</p>
<p>> Hello,<br>><br>><br>> I'm running Mapserver and pMapper on a Linux-Debian system and I have<br>> installed MySQL, added a database called dop and a table called<br>> waarnemingen.<br>><br>>
<br>> I created a waarnemingen.ovf which looks like this:<br>><br>><br>> <OGRVRTDataSource><br>><br>> <OGRVRTLayer name="Waarnemingen"><br>><br>><SrcDataSource>MYSQL:dop,user=root,password=testje,host=
<a href="http://84.244.182.83">84.244.182.83</a>,port=3<br>> 306,tables=waarnemingen</SrcDataSource><br>><br>> <SrcSQL>SELECT * FROM waarnemingen</SrcSQL><br>><br>> <GeometryType>wkbPoint</GeometryType>
<br>><br>> <GeometryField encoding="PointFromColumns" x="x" y="y"/><br>><br>> </OGRVRTLayer><br>><br>> </OGRVRTDataSource><br>><br>><br>> When I run ogrinfo /var/www/data/maps/waarnemingen.ovf I get the
<br>> following<br>> message:<br>><br>><br>> ERROR 4: Update access not supported for VRT datasources.<br>><br>> ERROR 1: Failed to open datasource<br>> `MYSQL:dop,user=root,password=trashcan,host=
<a href="http://84.244.182.83">84.244.182.83</a>,port=3306,tables=w<br>> aarnemingen'.<br>><br>> FAILURE:<br>><br>> Unable to open datasource `/var/www/data/maps/waarnemingen.ovf' with the<br>> following drivers.
<br>><br>> -> ESRI Shapefile<br>><br>> -> UK .NTF<br>><br>> -> SDTS<br>><br>> -> TIGER<br>><br>> -> S57<br>><br>> -> MapInfo File<br>><br>> -> DGN
<br>><br>> -> VRT<br>><br>> -> AVCBin<br>><br>> -> REC<br>><br>> -> Memory<br>><br>> -> CSV<br>><br>> -> GML<br>><br>> -> ODBC<br>><br>> -> PostgreSQL
<br>><br>><br>> The host is the IP-number of the server where MySQL is running. Using<br>> localhost or <a href="http://127.0.0.1">127.0.0.1</a> results in the same errors.<br>><br>> Can somebody please help to connect to MySQL database. What could be
<br>> wrong?<br>><br>><br>> Thanks.<br>><br>> Chris Beaart</p></div>