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

        Attachments

          Activity

            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: