[mapserver-users] Could not read data from MySQL database

[Murat Beyhan]

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.

[murat at 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-bounces at lists.osgeo.org [mailto:mapserver-users-bounces at lists.osgeo.org] On Behalf Of Murat Beyhan
> Sent: Thursday, September 16, 2010 5:18 PM
> To: mapserver-users at 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
> [murat at 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)
> [murat at localhost mapdata]$
> 
> 
> AND 
> my mapserver version info as follows
> 
> [murat at 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 
> [murat at 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 at 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:beyhan at deprem.gov.tr


-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.