On 11/04/2009 04:21 PM juan carlos wrote:
Do you have an example with different quotas using mysql. These are my config files:
dovecot-sql.conf password_query = SELECT email AS user, password, '/home/vmail/%d/%n' AS userdb_home, 'maildir:/home/vmail/%d/%n' AS userdb_mail, 5000 AS userdb_uid, 5000 AS userdb_gid, CONCAT('maildir:storage=', ROUND(quota/1000) ) AS userdb_quota FROM users WHERE email = '%u'
user_query = SELECT '/home/vmail/%d/%n' AS home, 'maildir:/home/vmail/%d/%n' AS mail, 5000 AS uid, 5000 AS gid, CONCAT('maildir:storage=', ROUND(quota/1000) ) AS quota FROM users WHERE email = '%u'
dovecot.conf
plugin: quota: maildir:storage=51200:messages=1000:ignore=Trash trash: /etc/dovecot/dovecot-trash.conf
Your dovecot -n output¹ does not show 'prefetch user database' settings. Please check your password_query. There is an example² in the wiki. How to configure global quota rules and overwrite it per user, is also described³ in the wiki (including examples).
Regards, Pascal
1 = http://dovecot.org/list/dovecot/2009-November/044199.html 2 = http://wiki.dovecot.org/AuthDatabase/SQL#MySQL 3 = http://wiki.dovecot.org/Quota/1.1
The trapper recommends today: beeffeed.0930817@localdomain.org