[Dovecot] Dovecot quota with MySQL - username issue

Axel Luttgens AxelLuttgens at swing.be
Sat Jan 11 10:29:18 EET 2014


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



More information about the dovecot mailing list