Re: [Dovecot] Dovecot quota with MySQL - username issue

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