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> 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