[Dovecot] Dovecot + virtual users

[bichumo]

bichumo wrote:
> Hi,
>
> I'm running FreeBSD, Dovecot, Postfix (virtual users), MySQL, 
> Squirrelmail. I have installed squirrelmail-quota_usage-plugin, but I 
> cannot make it work. It mentions "If you have an IMAP server with 
> QUOTA Extension capability...". In dovecot.conf I have enabled 
> "mail_plugins = quota" near protocol pop3 and protocol lda, near 
> protocol imap I have "mail_plugins = quota imap_quota". Near " plugin 
> { ..." I have "quota = maildir:storage=204800". I think that the 
> problem of why I don't see quota in Squirrelmail is in file 
> dovecot-sql near user_query. I have my users mailboxes in such format: 
> /usr/local/virtual/domain.tld/username and my user_query looks like this:
> user_query = SELECT maildir, 125 AS uid, 125 AS gid, 
> concat('maildir:storage=', quota) AS quota FROM mailbox WHERE username 
> = '%u' AND active = '1', I think that in my user_query I'm missing 
> something. I do not get any errors in the dovecot and dovecot-debug 
> logs, everything works fine, but I still can't see quota.
>
Solved.