James fails to create mysql tables with mysql-4.1.

• Key: JAMES-524
• Type: Bug
• Status: Closed
• Resolution: Fixed
• Priority: Major
• Assignee: Norman Maurer
• Reporter: Norman Maurer
• Fix Version/s: 2.3.0

Description

From Maillinglist:

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: [e-mail]
For additional commands, e-mail: [e-mail]