[GeoNetwork-users] Error using MySQL with Geonetwork v2.2.0

Hello.

I have tried to install the Geonetwork v2.2.0 using MySQL v.5.0.45 in Windows XP.

1) If I use GAST, when I "SETUP" the Database, I've got 2 error messages:

"Cyclic Reference found", then I press OK and the process go on, till the second error appears:

"Specified key was too long; max key length is 1000 bytes""

2) On the other hand, to see other options, I have tried with PHPMyAdmin, to import directly the file:

D:\geonetwork\gast\setup\sql\create-db-mysql.sql

In a database created manually with charset: "UTF-8" and collation: "UTF8_unicode_CI"

And now I've got the second error:

"#1071 - Specified key was too long; max key length is 1000 bytes" in the "Metadata" table creating process.

Can anybody help me?

Alberto Amaro

Jefe de Servicio de Sistemas Informáticos
Secretaría General
C/Almansa 105
28040 Madrid (España)
915 837 118

Hi Alberto,

I'm not sure if it's related, but I found that I needed the following jdbc
string for MySQL on Linux to get things to work :

(in <install-dir>/web/geonetwork/WEB-INF/config.xml :slight_smile:

<url>jdbc:mysql://localhost/geonetwork?useUnicode=true&amp;characterEncoding=utf-8&amp;mysqlEncoding=utf8&amp;jdbcCompliantTruncation=false</url>

The last part ("&amp;jdbcCompliantTruncation=false") I needed to add. You
might give it a try...

kind regards
Heikki Doeleman

On Wed, May 21, 2008 at 2:31 PM, Amaro Cormenzana, Alberto <
Alberto.Amaro@anonymised.com> wrote:

Hello.

I have tried to install the Geonetwork v2.2.0 using MySQL v.5.0.45 in
Windows XP.

1) If I use GAST, when I "SETUP" the Database, I've got 2 error
messages:

"Cyclic Reference found", then I press OK and the process go on, till the
second error appears:

"Specified key was too long; max key length is 1000 bytes""

2) On the other hand, to see other options, I have tried with PHPMyAdmin,
to import directly the file:

D:\geonetwork\gast\setup\sql\create-db-mysql.sql

In a database created manually with charset: "UTF-8" and collation:
"UTF8_unicode_CI"

And now I've got the second error:

"#1071 - Specified key was too long; max key length is 1000 bytes" in the
"Metadata" table creating process.

Can anybody help me?

Alberto Amaro

Jefe de Servicio de Sistemas Informáticos
Secretaría General
C/Almansa 105
28040 Madrid (España)
915 837 118

-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
GeoNetwork-users mailing list
GeoNetwork-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geonetwork-users
GeoNetwork OpenSource is maintained at
http://sourceforge.net/projects/geonetwork

--
Inventions cannot, in nature, be a subject of property. -- Thomas Jefferson