[Dovecot] vpopmail/mysql/quota

[Timo Sirainen]

On Mon, 2009-12-14 at 08:11 -0600, Marty Diesburg wrote:
> I'm new to the list and have a quota question.  I am building a new server
> with dovecot/qmail/vpopmail/mysql and
> emails are sending and recieving fine when the quota is set to NOQUOTA, but
> when the quota is changed qmail
> doesn't deliver any messages.

Logs probably would have told you why it failed.

>   passdb:
>     driver: sql
>     args: /home/vpopmail/dovecotsql.conf
>   passdb:
>     driver: vpopmail
>     args: webmail=127.0.0.1
>   userdb:
>     driver: sql
>     args: /home/vpopmail/dovecotsql.conf
>   userdb:
>     driver: vpopmaildriver = mysql
>     args: quota_template=quota_rule=*:backend=%q

Something's weird above. You probably should have only passdb sql and
userdb sql, nothing else.

> user_query = SELECT CONCAT(pw_name, '@', pw_domain) AS user, pw_dir as home,
> 508 AS uid, 503 AS gid, concat('maildir:backend=%q', pw_shell) AS quota_rule

The %q is for userdb vpopmail, not for userdb sql. Just remove it and it
should work (assuming pw_shell contains the quota).
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 197 bytes
Desc: This is a digitally signed message part
Url : http://dovecot.org/pipermail/dovecot/attachments/20091215/eea29f3a/attachment.bin