[mapserver-users] Mysql Ogr Error

Even Rouault even.rouault at mines-paris.org
Sat Feb 15 01:02:39 PST 2014


Le samedi 15 février 2014 09:58:02, rkrojero a écrit :
> Hi guys im getting an error on mapserver version 6.2.1 on ogr connection
> 
> msDrawMap(): Image handling error. Failed to draw layer named 'govt'.
> msOGRLayerInitItemInfo(): OGR error. Invalid Field name: name
> 
> ogrinfo -ro -al
> MYSQL:mapresearch,user=devuser,password=devpwd,tables=establishment -sql
> 'SELECT name, longlat_x, longlat_y FROM establishment WHERE layer_type =
> "BANK"'

This is rather obvious from the below error message. Your version of GDAL/OGR 
has not been built with mysql support (it doesn't appear in the driver list).

> 
> FAILURE:
> Unable to open datasource
> `MYSQL:mapresearch,user=devuser,password=devpassword,t ables=establishment'
> with the following drivers.
> -> ESRI Shapefile
> -> MapInfo File
> -> UK .NTF
> -> SDTS
> -> TIGER
> -> S57
> -> DGN
> -> VRT
> -> REC
> -> Memory
> -> BNA
> -> CSV
> -> GML
> -> GPX
> -> KML
> -> GeoJSON
> -> GMT
> -> PCIDSK
> -> XPlane
> -> AVCBin
> -> AVCE00
> -> DXF
> -> Geoconcept
> -> GeoRSS
> -> GPSTrackMaker
> -> VFK
> -> PGDump
> -> GPSBabel
> -> SUA
> -> OpenAir
> -> PDS
> -> WFS
> -> HTF
> -> AeronavFAA
> -> EDIGEO
> -> GFT
> -> SVG
> -> CouchDB
> -> Idrisi
> -> ARCGEN
> -> SEGUKOOA
> -> SEGY
> 
> Installed apps as follows
> MapServer version 6.2.1 OUTPUT=GIF OUTPUT=PNG OUTPUT=JPEG SUPPORTS=PROJ
> SUPPORTS=GD SUPPORTS=AGG SUPPORTS=FREETYPE SUPPORTS=ICONV
> SUPPORTS=WMS_SERVER SUPPORTS=WMS_CLIENT SUPPORTS=WFS_SERVER
> SUPPORTS=WFS_CLIENT SUPPORTS=WCS_SERVER SUPPORTS=SOS_SERVER
> SUPPORTS=THREADS SUPPORTS=GEOS INPUT=JPEG INPUT=OGR INPUT=GDAL
> INPUT=SHAPEFILE
> mysql version 5.6.13
> apache 2.4.6
> php 5.4.7
> 
> This is working on the old server
> MapServer version 5.0.3 OUTPUT=GIF OUTPUT=PNG OUTPUT=JPEG OUTPUT=WBMP
> OUTPUT=SVG SUPPORTS=PROJ SUPPORTS=FREETYPE SUPPORTS=WMS_SERVER
> SUPPORTS=WMS_CLIENT SUPPORTS=WFS_SERVER SUPPORTS=GEOS INPUT=EPPL7
> INPUT=POSTGIS INPUT=OGR INPUT=GDAL INPUT=SHAPEFILE
> Php 5.2.1
> MySQL 5.5.10
> Apache/2.0.55
> 
> I hope you can help me guys.. Thanks
> 
> 
> 
> 
> --
> View this message in context:
> http://osgeo-org.1560.x6.nabble.com/Mysql-Ogr-Error-tp5103949.html Sent
> from the Mapserver - User mailing list archive at Nabble.com.
> _______________________________________________
> mapserver-users mailing list
> mapserver-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users

-- 
Geospatial professional services
http://even.rouault.free.fr/services.html


More information about the mapserver-users mailing list