Uploaded image for project: 'James Server'
  1. James Server
  2. JAMES-524

James fails to create mysql tables with mysql-4.1.

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 2.3.0
    • Component/s: None
    • Labels:
      None

      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: server-user-unsubscribe@james.apache.org
      For additional commands, e-mail: server-user-help@james.apache.org

        Activity

        Hide
        danny@apache.org Danny Angus added a comment -

        Closing issue fixed in released version.

        Show
        danny@apache.org Danny Angus added a comment - Closing issue fixed in released version.

          People

          • Assignee:
            norman Norman Maurer
            Reporter:
            norman Norman Maurer
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development