[Dovecot] Dovecot quota with MySQL - username issue

[Axel Luttgens]

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