[Featureserver] MySQL access error

[Matt Priour]

Thanks Chris,
Only if I use the FWTools shell not the straight command line.

MYSQL is not listed as a driver in normal command line but is shown in 
FWTools shell.

Is it possible to set the correct path settings for:
PATH & PYTHONPATH to use the OGR driver from FWTools?

Or do I need to build GDAL/OGR myself with MYSQL driver enabled?

Matt Priour

----- Original Message ----- 
From: "Christopher Schmidt" <crschmidt at metacarta.com>
To: "Matt Priour" <mpriour at kestrelcomputer.com>
Cc: <featureserver at openlayers.org>
Sent: Tuesday, August 21, 2007 1:44 PM
Subject: Re: [Featureserver] MySQL access error


On Tue, Aug 21, 2007 at 12:11:08PM -0500, Matt Priour wrote:
> I am attempting to read geometries from a remote MySQL database that I 
> have read-only privileges on.
>
> Here is what I have in my config file:
> [county]
>
> type=OGR
>
> dsn=MYSQL:remap,user=XX,password=XX,host=XX.XX.XX.XX,port=3306
>
> layer=county_data
>
> And here is the error I get when attempting to fetch a resource from there 
> with FS
>
> An error occurred: Unable to open: 
> MYSQL:remap,user=XX,password=XX,host=XX.XX.XX.XX,port=3306


This error message is passed up directly from ogr. Can you use ogrinfo
to access this datasource on the command line?

Regards,
-- 
Christopher Schmidt
MetaCarta