[ postfixadmin-Bugs-2852526 ] DOVECOT.TXT

[SourceForge.net <no...@so...>]

Bugs item #2852526, was opened at 2009-09-05 21:27
Message generated for change (Settings changed) made by christian_boltz
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=937964&aid=2852526&group_id=191583

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: None
Group: None
>Status: Closed
>Resolution: Duplicate
Priority: 5
Private: No
Submitted By: Tamas papp (sopmot)
Assigned to: Nobody/Anonymous (nobody)
Summary: DOVECOT.TXT

Initial Comment:
In the documentation for createing mysql table for quota you say:

create table quota (
  username varchar(255) not null,
  path varchar(100) not null,
  current integer,
  primary key (username, path)
);

It's wrong, check this out: http://bugs.mysql.com/bug.php?id=6604

I think, there sould be:

create table quota (
  username varchar(100) not null,
  path varchar(100) not null,
  current integer,
  primary key (username, path)
);

----------------------------------------------------------------------

>Comment By: Christian Boltz (christian_boltz)
Date: 2009-09-07 00:04

Message:
The utf-8 charset (which seems to be your default) causes problems on
multi-column indexes because it treats varchar(255) in utf-8 as 3x255
bytes, and a index may only have 1024 bytes in total.

That's a known problem in MySQL, and already known for the quota table
also:
https://sourceforge.net/tracker/?func=detail&aid=2794247&group_id=191583&atid=937964

The solution is to make the username and varchar columns latin1-encoded
instead of utf-8. I have updated the query in DOVECOT.txt, but the
long-term solution will be that update.php creates the quota table.

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=937964&aid=2852526&group_id=191583