Re: [Geoserver-users] Can't connect to MySQL

[Cameron S. <cam...@gm...>]

Thanks Chris,
I'm using MySQL because my client develops on Drupal, which is usually 
installed with MySQL.

I think I might have hit one of MySQL's limitations.  I want to 
determine what political district a person lives in, so I'm testing 
whether a point is within a polygon using:

SELECT ID, STATE, CD FROM cd99_109 WHERE Contains(ogc_geom, 
GeomFromText('POINT(-87.395053 30.6159)'));

However, it seems that MySQL is using a BBox test for it's Contains 
function so I often get multiple districts returned instead of just one.
Do you know if this is a MySQL limitation, or have I corrupted my 
shapefile data during the import process?

Chris Holmes wrote:
> Quoting Cameron Shorter <cam...@gm...>:
> 
> 
>>I'm trying unsucessfully to create a MySQL datasource from the
>>Geoserver Configuration Web page.
>>
>>I select Config->Data->Store->New
>>I set DataStore ID=MySQL and all the other parameters.
>>
>>I'm using Geoserver 1.0RC7 and have copied the MySQL jars from
>>geoserver-mysql-ext-beta2.zip
> 
> I'm pretty sure you don't need to copy the mysql jars, as I believe RC7
> comes with updated MySQL jars.  The beta2 stuff is against 1.2.x, and
> I'm sorta surprised you get this far.
> 
> The error itself sounds more like a mysql configuration problem, not
> being configured for tcp/ip connections, or perhaps not having proper
> permissions.  But perhaps just using the 1.3.0 mysql stuff will fix the
> problem.
> 
> Also note that we don't really recommend mysql, postgis is a far
> superior database and geotools datastore.  Mysql's fine for basic
> querying, but that's about it.
> 
> Chris

--
Cameron Shorter
http://cameron.shorter.net