Hi everybody,
I have a server works good but the quota calculation includes trash, what i
have to do in order to ignore trash in quota calculation?
My server imap is dovecot 1.0, my smtp server is postfix 2.3.8-2 and my webmail
is horde 3.1.3 and imp 4.1.3.
my dovecot.conf :
base_dir: /var/run/dovecot/
log_path: /var/log/mail.log
log_timestamp: %Y-%m-%d %H:%M:%S
protocols: pop3 imap
disable_plaintext_auth: no
login_dir: /var/run/dovecot/login
login_executable(default): /usr/lib/dovecot/imap-login
login_executable(imap): /usr/lib/dovecot/imap-login
login_executable(pop3): /usr/lib/dovecot/pop3-login
login_process_size: 64
login_processes_count: 5
login_max_processes_count: 256
login_max_connections: 512
first_valid_uid: 5000
last_valid_uid: 5000
first_valid_gid: 5000
mail_extra_groups: vmail
mail_location: maildir:/home/vmail/%d/%n
maildir_copy_with_hardlinks: yes
maildir_copy_preserve_filename: yes
mail_executable(default): /usr/lib/dovecot/imap
mail_executable(imap): /usr/lib/dovecot/imap
mail_executable(pop3): /usr/lib/dovecot/pop3
mail_plugins(default): quota trash imap_quota
mail_plugins(imap): quota trash imap_quota
mail_plugins(pop3): quota
mail_plugin_dir(default): /usr/lib/dovecot/modules/imap
mail_plugin_dir(imap): /usr/lib/dovecot/modules/imap
mail_plugin_dir(pop3): /usr/lib/dovecot/modules/pop3
imap_client_workarounds(default): outlook-idle delay-newmail
imap_client_workarounds(imap): outlook-idle delay-newmail
imap_client_workarounds(pop3): outlook-idle
pop3_uidl_format(default):
pop3_uidl_format(imap):
pop3_uidl_format(pop3): %08Xu%08Xv
pop3_client_workarounds(default):
pop3_client_workarounds(imap):
pop3_client_workarounds(pop3): outlook-no-nuls oe-ns-eoh
namespace:
type: private
separator: .
prefix: INBOX.
inbox: yes
auth default:
mechanisms: plain login
user: vmail
passdb:
driver: sql
args: /etc/dovecot/dovecot-sql.conf
userdb:
driver: sql
args: /etc/dovecot/dovecot-sql.conf
userdb:
driver: prefetch
socket:
type: listen
client:
path: /var/spool/postfix/private/auth
mode: 432
user: postfix
group: vmail
master:
path: /var/run/dovecot/auth-master
mode: 432
user: vmail
group: vmail
plugin:
quota: maildir:storage=10240:messages=1000:ignore=Trash
trash: /etc/dovecot/dovecot-trash.conf
my 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 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'
On 23.9.2007, at 20.09, JC wrote:> passdb: > driver: sql > args: /etc/dovecot/dovecot-sql.conf > userdb: > driver: sql > args: /etc/dovecot/dovecot-sql.conf > userdb: > driver: prefetchYour prefetch userdb is after userdb sql, which means that it's never used.> 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 FROM users WHERE email = '%u'So these userdb_* fields here are pointless. If you moved prefetch before sql, it would be used. But if you do that, you'll have to make password_query return also userdb_quota field.> 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'Since you're returning quota here, it overrides completely what you have in plugin {}. So make the quota field returned by this SQL lookup include the :ignore=Trash. -------------- next part -------------- A non-text attachment was scrubbed... Name: PGP.sig Type: application/pgp-signature Size: 186 bytes Desc: This is a digitally signed message part URL: <http://dovecot.org/pipermail/dovecot/attachments/20070923/27cb0f11/attachment-0002.bin>