You are viewing a plain text version of this content. The canonical link for it is here.
Posted to server-dev@james.apache.org by "Norman Maurer (JIRA)" <se...@james.apache.org> on 2006/06/08 13:45:01 UTC
[jira] Created: (JAMES-524) James fails to create mysql tables with
mysql-4.1.
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:
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: 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:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
---------------------------------------------------------------------
To unsubscribe, e-mail: server-dev-unsubscribe@james.apache.org
For additional commands, e-mail: server-dev-help@james.apache.org
[jira] Updated: (JAMES-524) James fails to create mysql tables with
mysql-4.1.
Posted by "Stefano Bagnara (JIRA)" <se...@james.apache.org>.
[ http://issues.apache.org/jira/browse/JAMES-524?page=all ]
Stefano Bagnara updated JAMES-524:
----------------------------------
Fix Version/s: (was: 3.0)
> James fails to create mysql tables with mysql-4.1.
> --------------------------------------------------
>
> Key: JAMES-524
> URL: http://issues.apache.org/jira/browse/JAMES-524
> Project: James
> Issue Type: Bug
> Reporter: Norman Maurer
> Assigned To: Norman Maurer
> Fix For: 2.3.0b1
>
>
> 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: 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: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
---------------------------------------------------------------------
To unsubscribe, e-mail: server-dev-unsubscribe@james.apache.org
For additional commands, e-mail: server-dev-help@james.apache.org
[jira] Resolved: (JAMES-524) James fails to create mysql tables
with mysql-4.1.
Posted by "Norman Maurer (JIRA)" <se...@james.apache.org>.
[ http://issues.apache.org/jira/browse/JAMES-524?page=all ]
Norman Maurer resolved JAMES-524:
---------------------------------
Fix Version: 2.3.0
2.4.0
Resolution: Fixed
> 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
> Assignee: Norman Maurer
> Fix For: 2.3.0, 2.4.0
>
> 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: 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:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
---------------------------------------------------------------------
To unsubscribe, e-mail: server-dev-unsubscribe@james.apache.org
For additional commands, e-mail: server-dev-help@james.apache.org
[jira] Updated: (JAMES-524) James fails to create mysql tables with
mysql-4.1.
Posted by "Stefano Bagnara (JIRA)" <se...@james.apache.org>.
[ http://issues.apache.org/jira/browse/JAMES-524?page=all ]
Stefano Bagnara updated JAMES-524:
----------------------------------
Fix Version: 2.3.0b1
(was: 2.3.0)
> 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
> Assignee: Norman Maurer
> Fix For: 2.4.0, 2.3.0b1
>
> 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: 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:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
---------------------------------------------------------------------
To unsubscribe, e-mail: server-dev-unsubscribe@james.apache.org
For additional commands, e-mail: server-dev-help@james.apache.org