Le 26 déc. 2013 à 10:04, michael a écrit :
> Hi all,
>
> I'm using Dovecot 2.2.8 with quota using a MySQL backend. The Quota plugin is
> listed for POP3, IMAP and LDA.
>
> When it is enabled for LDA, it populates the "username" field in the MySQL
> table with e mail addresses. I end up with a mixture of email addresses and
> usernames, which causes things to not fully work. It *should* be just
> usernames. the LDA SQL statement is:
>
> [...]
>
> Can this be fixed?
>
> Michael
>
Hello Michael,
I'm a bit late on this one...
I guess your SELECT should return a quota column, probably something like:
CONCAT('dict:user:', mailboxes.username, ':proxy::quotadict') AS quota
because your quota definition in dovecot.conf will be filled with the username
as known by the service currently making use of it.
HTH,
Axel
