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 > [email protected] > http://lists.osgeo.org/mailman/listinfo/mapserver-users -- Geospatial professional services http://even.rouault.free.fr/services.html _______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
