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) -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean.
