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, > [EMAIL PROTECTED] 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:[EMAIL PROTECTED] > > Sent: Monday, August 21, 2006 4:57 PM > > To: [email protected] > > 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- > > [EMAIL PROTECTED] On Behalf Of Murat BEYHAN Sent: Monday, August > > 21, 2006 7:42 AM To: [email protected] 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. > > > > [EMAIL PROTECTED] 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)
