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
