Hi Norman,
I use the Gentoo dist.
The SQL error is "Specified key was too long; max key length is 1000 bytes". Unfortunately I don't
have the stack track right now, however, I think this problem has been mentioned before, without
being resolved:
http://mail-archives.apache.org/mod_mbox/james-server-user/200503.mbox/[EMAIL
PROTECTED]
JAMES-485 does not appear to be the same issue - the problem I am experiencing occurs when creating
the tables on starting James for the first time with a new database.
ciao,
Craig
Norman Maurer wrote:
What for a dist you use ? ubuntu or debian ? What for a error you get
Is it the same as : http://issues.apache.org/jira/browse/JAMES-485
bye
Norman
Am Mittwoch, den 07.06.2006, 15:25 +0200 schrieb Craig Raw:
Hi,
I'd like to point out to the list a problem with James and MySQL 4.1. The
character set support was
revamped from MySQL 4.0 to MySQL 4.1, and as a result on some systems (in my
case, Gentoo) UTF-8 is
now the default character set on install.
This is a problem when creating the spool, inbox and deadletter tables. The
primary key for these
tables is (message_name, repository_name). On my system MySQL allows for 3
bytes per UTF-8
character, and has a maximum key length of 1000 bytes. Since message_name is
200 chars and
repository_name is 255 chars by default, the key length exceeds 1000 bytes and
the table cannot be
created.
The key length issue in MySQL is better described here:
http://www.xaprb.com/blog/2006/04/17/max-key-length-in-mysql/
I managed to solve the problem by reducing the length of repository_name to 128
chars.
Ciao,
Craig
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
