using OGR to connect MySQL

[Jacolin Yves]

Hi,
there is no earlier version. You have to build your ogr command with 
--with-mysql and --with-xerces options !

Y.
Le Lundi 21 Août 2006 16:16, Murat BEYHAN a écrit :
> Dear Friends,
> [root at sakura murat]# mapserv -v
> MapServer version 4.8.4 OUTPUT=GIF OUTPUT=PNG OUTPUT=JPEG OUTPUT=WBMP
> OUTPUT=PDF OUTPUT=SVG SUPPORTS=PROJ SUPPORTS=FREETYPE SUPPORTS=WMS_SERVER
> SUPPORTS=WMS_CLIENT SUPPORTS=WFS_CLIENT SUPPORTS=THREADS INPUT=TIFF
> INPUT=EPPL7 INPUT=OGR INPUT=GDAL INPUT=SHAPEFILE DEBUG=MSDEBUG
>
>
> By the consider command mapserv -v I have already installed mapserver with
> ogr functionality. Is it true?
>
> Any way I will try to find newest version of OGR.
> Thanks
>
> On Mon, 21 Aug 2006 17:09:34 +0300, Volkan Ulukut wrote
>
> > Murat,
> > Even if you had the newest ogr version you have to configure it with
> > mysql option to be able to connect directly to mysql, cause it's off
> > by default.
> >
> > -----Original Message-----
> > From: Fawcett, David [mailto:David.Fawcett at STATE.MN.US]
> > Sent: Monday, August 21, 2006 4:57 PM
> > To: MAPSERVER-USERS at LISTS.UMN.EDU
> > Subject: Re: [UMN_MAPSERVER-USERS] using OGR to connect MySQL
> >
> > Murat,
> >
> > The MySQL direct connect functionality is relatively new to OGR.  You
> > will need a relatively recent release of OGR, particularly if you are
> > running Linux.  You will then need to re-compile MapServer with the new
> > OGR.
> >
> > Based on your error message, it doesn't appear that you have a
> > version of OGR that supports direct connections to MySQL.
> >
> > On somewhat older versions, you can set up a ODBC connection to MySQL
> > and then use OGR to connect to that, but I don't see ODBC support listed
> > in your error message either.
> >
> > Essentially, you will need a newer version of OGR/MapServer.
> >
> > David.
> >
> > -----Original Message-----
> > From: UMN MapServer Users List [mailto:MAPSERVER-
> > USERS at LISTS.UMN.EDU] On Behalf Of Murat BEYHAN Sent: Monday, August
> > 21, 2006 7:42 AM To: MAPSERVER-USERS at LISTS.UMN.EDU Subject:
> > [UMN_MAPSERVER-USERS] using OGR to connect MySQL
> >
> > Dear Friends,
> >
> > I'm trying to connect MySQL database to draw earthquake epicenters on
> > the map that the data are stored in mysql like
> >
> > ID, Latitude, Longitude, magnitude
> > 1 30 40 3.5
> > 2 31 41 5.5
> > .
> > .
> > .
> > I have tried to test ogr with the following command as explaeined in
> > the Document on Webpages' Mapserver.
> >
> > ogrinfo /var/www/html/map/agidata.ovf
> > The agidata.ovf file is as follow.
> >
> > <OGRVRTDataSource>
> >     <OGRVRTLayer name="aqidata">
> >
> > <SrcDataSource>MYSQL:eqinfo,user=root,password=mysql_123,
> > host=localhost, port=3306,tables=deneme</SrcDataSource>
> > <SrcSQL>SELECT ID,Lat,Lon,Mag FROM deneme</SrcSQL>
>
> <GeometryType>wkbPoint</GeometryType>
>
> >         <GeometryField encoding="PointFromColumns" x="lat" y="lon"/>
> >     </OGRVRTLayer>
> > </OGRVRTDataSource>
> >
> > But I haven't achieved. The following messages is appearing on the
> > screen.
> >
> > [murat at sakura mapdata]$ ogrinfo /var/www/html/map/agidata.ovf ERROR
> > 1: Unable to create Xerces C++ based GML reader, Xerces support not
> > configured into GDAL/OGR. ERROR 1: File
> > /var/www/html/map/agidata.ovf appears to be GML but the GML reader
> > can't be instantiated, likely because Xerces support wasn't
> > configured in. FAILURE: Unable to open datasource
> > `/var/www/html/map/agidata.ovf' with the following drivers.  -> ESRI
> > Shapefile  -> UK .NTF  -> SDTS  -> TIGER  -> IHO S-57 (ENC)  ->
> > MapInfo File  -> DGN  -> GML  -> AVCBin  -> REC  -> Memory  -> PostgreSQL
> >
> > How can I fix this problem...
> > Thank You....
> > Murat
> >
> > --
> > This message has been scanned for viruses and
> > dangerous content by MailScanner, and is
> > believed to be clean.
> >
> > --
> > This message has been scanned for viruses and
> > dangerous content by MailScanner, and is
> > believed to be clean.
>
> --
> Open WebMail Project (http://openwebmail.org)

-- 
Yves Jacolin
http://yjacolin.gloobe.org
----
Stagiaire Conservatoire Régional des Espaces Naturels de la région Centre
http://cahiersnaturalistes.free.fr/cpnrc/
----
- Qu'est-ce que cela peut faire que je lutte pour la mauvaise cause 
puisque je suis de bonne foi?
- Et qu'est-ce que ça peut faire que je sois de mauvaise foi
puisque c'est pour la bonne cause. (Jacques Prévert)