Hi Heikki.
Thanks for your answer, I added this option to the jdbc url, but without success.
Just now, I have found that the problem was in the MySQL engine I was using (MyISAM).
When I've changed it to InnoDB the GAST "SETUP" has worked correctly.
Kind regards.
Alberto Amaro
________________________________
De: heikki [mailto:tropicano@anonymised.com]
Enviado el: miércoles, 21 de mayo de 2008 14:48
Para: Amaro Cormenzana, Alberto
CC: geonetwork-users@lists.sourceforge.net
Asunto: Re: [GeoNetwork-users] Error using MySQL with Geonetwork v2.2.0
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 
<url>jdbc:mysql://localhost/geonetwork?useUnicode=true&characterEncoding=utf-8&mysqlEncoding=utf8&jdbcCompliantTruncation=false</url>
The last part ("&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..402...> 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