Problem with connecting to MySQL with OVF-file

[Karl Suiter]

Chris Beaart <beaart <at> XS4ALL.NL> writes:

> Hello,
> 
> I’m running Mapserver and pMapper on a Linux-Debian system and I
> have installed MySQL, added a database called dop and a table called
> waarnemingen.
>
> deleted stuff ....
>
> FAILURE:
> Unable to open datasource
> `/var/www/data/maps/waarnemingen.ovf' with the following drivers.
>   -> ESRI Shapefile
>   -> UK .NTF
>   -> SDTS
>   -> TIGER
>   -> S57
>   -> MapInfo File
>   -> DGN
>   -> VRT
>   -> AVCBin
>   -> REC
>   -> Memory
>   -> CSV
>   -> GML
>   -> ODBC
>   -> PostgreSQL
>
> Can somebody please help to connect to
> MySQL database. What could be wrong?
>
> Thanks.
>
> Chris Beaart

Chris,

  Your OGR output error indicates that your Mapserver binary has not been
compiled with MySQL connectivity enabled.  You can also run "mapserv -v" and the
output should include the "INPUT=MYSQL" statement.

  On Linux, you'll need to run the configure command with "--with-mysql= ..." to
set this option before running make.  I needed to have the mysql client and
development libraries installed before I could get the connection to work.  You
may not need to do this.

  FYI - my configuration is Fedora Core 5, Mapserver 4.10, MySQL 5.01.

Cheers,

Karl