james-server-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Norman Maurer (JIRA)" <server-...@james.apache.org>
Subject [jira] Created: (JAMES-524) James fails to create mysql tables with mysql-4.1.
Date Thu, 08 Jun 2006 11:45:01 GMT
James fails to create mysql tables with mysql-4.1.

         Key: JAMES-524
         URL: http://issues.apache.org/jira/browse/JAMES-524
     Project: James
        Type: Bug

    Reporter: Norman Maurer
 Assigned to: Norman Maurer 

>From Maillinglist:


I'd like to point out to the list a problem with James and MySQL 4.1. The character set support
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
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

The key length issue in MySQL is better described here:

I managed to solve the problem by reducing the length of repository_name to 128 chars.


To unsubscribe, e-mail: server-user-unsubscribe@james.apache.org
For additional commands, e-mail: server-user-help@james.apache.org

This message is automatically generated by JIRA.
If you think it was sent incorrectly contact one of the administrators:
For more information on JIRA, see:

To unsubscribe, e-mail: server-dev-unsubscribe@james.apache.org
For additional commands, e-mail: server-dev-help@james.apache.org

View raw message