[Featureserver] MySQL access error

Matt Priour mpriour at kestrelcomputer.com
Tue Aug 21 13:11:08 EDT 2007


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
  File "./FeatureServer\Server.py", line 200, in cgiHandler
    service = Server.load(*cfgfiles)
  File "./FeatureServer\Server.py", line 44, in _load
    datasources[section] = cls.loadFromSection(
  File "./FeatureServer\Server.py", line 28, in _loadFromSection
    return objclass(section, **objargs)
  File "./FeatureServer\DataSource\OGR.py", line 37, in __init__
    self.ds     = ogr.Open( dsn, int(writable) )
  File "C:\Python24\Lib\site-packages\ogr.py", line 127, in Open
    raise OGRError, 'Unable to open: ' + filename


I can access this database directly from the same box as FS via MySQL Administrator

Matt Priour
Kestrel Computer Consulting
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/featureserver/attachments/20070821/668ca529/attachment.html


More information about the Featureserver mailing list