Dear David and friends, I have install rpm package of Mapserver and MySql. But When I use gdal I compiled source code. Because rpm package of gdal doesn't support MySQl formats. Then I checked ogrinfo file it was under /usr/local/bin and when I use whereis ogrinfo command it says same place for ogrinfo.
[mu...@localhost apps]$ whereis ogrinfo ogrinfo: /usr/local/bin/ogrinfo So I updated MySQL table by using ogr2ogr for update the data stored in MySQL database. But still same problem is continuing. I can't catch the problem where it is. So, do you have any idea? Murat On Fri, 2010-09-17 at 09:14 -0500, Fawcett, David (MPCA) wrote: > I don't know if this applies to your case at all. In other cases where > people have had mysql connections fail, it has sometimes been due to the lack > of mysql support in ogr. One question to figure out is whether the ogr being > used by MapServer is the same ogr that you are hitting when you run ogrinfo. > > David. > > -----Original Message----- > From: mapserver-users-boun...@lists.osgeo.org > [mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of Murat Beyhan > Sent: Thursday, September 16, 2010 5:18 PM > To: mapserver-users@lists.osgeo.org > Subject: [mapserver-users] Could not read data from MySQL database > > Dear Friends, > > I was succeeded to read and draw data from MySQL database using OGR > connection until upgrade mapserver and gdal. > > Now I use the same codes but could not read data form MySql database. > I have created tables using ogr2ogr again. > but still When I open webpage the following error message occurred. > > msDrawMap(): Image handling error. Failed to draw layer named 'sea'. > msOGRFileOpen(): OGR error. Open failed for OGR connection in layer > `sea'. File not found or unsupported format. > > What is wrong for that, please help. > > When I try ogrinfo as follows it works > [mu...@localhost mapdata]$ ogrinfo > "MySQL:testogr,user=root,password=mysql_123" > INFO: Open of `MySQL:testogr,user=root,password=mysql_pass' > using driver `MySQL' successful. > 1: deniz (Polygon) > 2: il_merkezleri (Point) > 3: il_sinirlari (Polygon) > 4: ilce_merkezleri (Point) > 5: ilce_sinirlari (Polygon) > 6: iller (Polygon) > 7: iller_sil (Polygon) > 8: komsular (Polygon) > [mu...@localhost mapdata]$ > > > AND > my mapserver version info as follows > > [mu...@localhost mapdata]$ mapserv -v > MapServer version 5.2.1 OUTPUT=GIF OUTPUT=PNG OUTPUT=JPEG OUTPUT=WBMP > OUTPUT=SVG SUPPORTS=PROJ SUPPORTS=FREETYPE SUPPORTS=ICONV > SUPPORTS=WMS_SERVER SUPPORTS=WMS_CLIENT SUPPORTS=WFS_SERVER > SUPPORTS=WFS_CLIENT SUPPORTS=WCS_SERVER SUPPORTS=THREADS SUPPORTS=GEOS > INPUT=EPPL7 INPUT=POSTGIS INPUT=OGR INPUT=GDAL INPUT=SHAPEFILE > > and > [mu...@localhost mapdata]$ ogrinfo > --formats > Supported > Formats: > > -> "ESRI > Shapefile" (read/write) > > -> "MapInfo > File" (read/write) > > -> > "UK .NTF" (readonly) > > -> "SDTS" (readonly) > -> "TIGER" (read/write) > -> "S57" (read/write) > -> "DGN" (read/write) > -> "VRT" (readonly) > -> "REC" (readonly) > -> "Memory" (read/write) > -> "BNA" (read/write) > -> "CSV" (read/write) > -> "GML" (read/write) > -> "GPX" (read/write) > -> "KML" (read/write) > -> "GeoJSON" (read/write) > -> "Interlis 1" (read/write) > -> "Interlis 2" (read/write) > -> "GMT" (read/write) > -> "SQLite" (read/write) > -> "ODBC" (read/write) > -> "PGeo" (readonly) > -> "OGDI" (readonly) > -> "MySQL" (read/write) > -> "PCIDSK" (readonly) > -> "XPlane" (readonly) > -> "AVCBin" (readonly) > -> "AVCE00" (readonly) > -> "DXF" (read/write) > -> "GRASS" (readonly) > -> "Geoconcept" (read/write) > -> "GeoRSS" (read/write) > -> "GPSTrackMaker" (read/write) > -> "VFK" (readonly) > > > > > > > > > -- > This message has been scanned for viruses and > dangerous content by MailScanner, and is > believed to be clean. > > _______________________________________________ > mapserver-users mailing list > mapserver-users@lists.osgeo.org > http://lists.osgeo.org/mailman/listinfo/mapserver-users > > -- Murat BEYHAN Jeofizik Y.Müh. T.C. Başbakanlık Afet ve Acil Durum Yönetimi Başkanlığı Deprem Dairesi Başkanlığı Eskişehir Yolu 12. Km. Lodumlu/ANKARA Tel: 312 2872680-1556 email:bey...@deprem.gov.tr -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. _______________________________________________ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users