database authentication table, to include per user quota's. Only then
will the query I specified really work. In your present database, add
the quota field and insert a KB value. This value will then be used when
the authentication query is executed. In the example SQL query I posted,
I used a tabled called quota_kb.
One way to test the whole setup is to enable all the debug and verbose
option in your config file, and then check the logs to see what its
doing.
Maybe including your sql.conf file will help solve your problem. From
what I see your quota config is correct, you just need to add the quota
field in to your DB, and it should work for you.
Regards
Richard
-----Original Message-----
From: dovecot-bounces at dovecot.org [mailto:dovecot-bounces at dovecot.org]
On Behalf Of Kenny Dail
Sent: 13 December 2006 08:04 PM
To: dovecot at dovecot.org
Subject: Re: [Dovecot] Trash and quota
> Have you tried concat'ng the data in yourMySQL statement?
>=20
> Eg.
> user_query =3D SELECT home, uid, gid, concat('maildir:storage=3D',
> quota_kb,':ignore=3DTrash') AS quota FROM users WHERE userid =3D
'%u'
An interesting thought indeed. I gave it a shot, but from what I can
tell, setting quota in the query has no effect on the quota setting from
the plugin block.
so that leaves me with 3 questions:
1. Is there a way define per user quotas?
and the original question:
2. Is Dovecot's maildir quota support currently broken, or am I setting
it up wrong? I am frequently getting quotas returned that do not match
reality.
Current dovecot.conf:
protocols =3D imap imaps pop3 pop3s
disable_plaintext_auth =3D no
login_greeting =3D amigo.net ready.
mail_location =3D maildir:%h/Maildir
namespace private {
separator =3D .
prefix =3D INBOX.
inbox =3D yes
hidden =3D no
}
mail_extra_groups =3D mail
mmap_disable =3D yes
lock_method =3D dotlock
first_valid_uid =3D 465
valid_chroot_dirs =3D /var/mail/virtual
maildir_copy_with_hardlinks =3D yes
protocol imap {
mail_plugins =3D quota imap_quota
login_greeting_capability =3D yes
imap_client_workarounds =3D outlook-idle } protocol pop3 {
pop3_uidl_format =3D %08Xu%08Xv
mail_plugins =3D quota
pop3_client_workarounds =3D outlook-no-nuls oe-ns-eoh } protocol lda {
postmaster_address =3D postmaster at amigo.net } auth_default_realm =3D
amigo.net auth_username_translation =3D %@ auth_username_format =3D %Ln@%d
auth_worker_max_count =3D 60 auth default {
mechanisms =3D plain login apop digest-md5 cram-md5
passdb sql {
args =3D /etc/dovecot/dovecot-sql.conf
}
userdb prefetch {
}
user =3D vmail
count =3D 1
socket listen {
master {
path =3D /var/run/dovecot/auth-master
mode =3D 0660
user =3D postfix
group =3D mail
}
client {
path =3D /var/run/dovecot/auth-client
mode =3D 0660
}
}
}
plugin {
quota =3D maildir
}
--
Kenny Dail <kend at amigo.net>
