#1239: GeoNetwork unusable on case sensitive DBMS (ie MySQL on Linux)
------------------------+---------------------------------------------------
Reporter: gaellafond | Owner: geonetwork-devel@…
Type: defect | Status: new
Priority: blocker | Milestone: v2.8.1
Component: General | Version: v2.8.0
Keywords: |
------------------------+---------------------------------------------------
GeoNetwork setup the database with capitalised table name (Groups,
Requests, etc.) but some requests are done with lower case table name
(groups, requests, etc.)
----
Example of errors / Warnings shown in the logs:
{{{
ERROR [geonetwork.datamanager] - The metadata document index with id=29 is
corrupt/invalid - ignoring it. Error: Table 'geonetwork.groups' doesn't
exist
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table
'geonetwork.groups' doesn't exist
WARN [geonetwork.search-logger] - an error occuring during QueryRequest
database storage. Aborting :Table 'geonetwork.requests' doesn't exist
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table
'geonetwork.requests' doesn't exist
}}}
Queries executes on the DB, using lower case table names:
{{{
mysql> SELECT * FROM geonetwork.requests;
ERROR 1146 (42S02): Table 'geonetwork.requests' doesn't exist
mysql> SELECT * FROM geonetwork.groups;
ERROR 1146 (42S02): Table 'geonetwork.groups' doesn't exist
}}}
Queries executes on the DB, using capitalised table names:
{{{
mysql> SELECT * FROM geonetwork.Requests;
Empty set (0.00 sec)
mysql> SELECT * FROM geonetwork.Groups;
+----+----------+-----------------------+-------+----------+
| id | name | description | email | referrer |
+----+----------+-----------------------+-------+----------+
| -1 | GUEST | self-registered users | NULL | NULL |
| 0 | intranet | NULL | NULL | NULL |
| 1 | all | NULL | NULL | NULL |
| 2 | sample | NULL | NULL | NULL |
+----+----------+-----------------------+-------+----------+
4 rows in set (0.00 sec)
}}}
--
Ticket URL: <http://trac.osgeo.org/geonetwork/ticket/1239>
GeoNetwork opensource Developer website <http://sourceforge.net/projects/geonetwork/>
GeoNetwork opensource is a standards based, Free and Open Source catalog application to manage spatially referenced resources through the web. It provides powerful metadata editing and search functions as well as an embedded interactive web map viewer. This website contains information related to the development of the software.