search for: quota_trash

...like this: > > > > password_query = SELECT username AS username, password FROM mailbox > > WHERE username = '%u' AND active = 1 > > user_query = SELECT maildir, uid, gid, concat('*:storage=', quota) AS > > quota_rule, concat('Trash:storage=+', quota_trash) AS quota_rule2 FROM > > mailbox WHERE username = '%u' > > what about > user_query = SELECT CONCAT(maildir, SUBSTRING_INDEX(username,'@',+1)) as > mail, uid, gid, concat('*:storage=', quota) AS quota_rule, > concat('Trash:storage=+', quota_tra...

.../Maildir The query-strings for virtual users look like this: password_query = SELECT username AS username, password FROM mailbox WHERE username = '%u' AND active = 1 user_query = SELECT maildir, uid, gid, concat('*:storage=', quota) AS quota_rule, concat('Trash:storage=+', quota_trash) AS quota_rule2 FROM mailbox WHERE username = '%u' There is no mail_loation defined. I thought if maildir is queried, the %u would expand to the mail_location of the user. Where the users only with the local part of the address exist in the filesystem. /var/spool/vhosts/nimmini.de/a.meyer...

...gs for virtual users look like this: > > password_query = SELECT username AS username, password FROM mailbox > WHERE username = '%u' AND active = 1 > user_query = SELECT maildir, uid, gid, concat('*:storage=', quota) AS > quota_rule, concat('Trash:storage=+', quota_trash) AS quota_rule2 FROM > mailbox WHERE username = '%u' what about user_query = SELECT CONCAT(maildir, SUBSTRING_INDEX(username,'@',+1)) as mail, uid, gid, concat('*:storage=', quota) AS quota_rule, concat('Trash:storage=+', quota_trash) AS quota_rule2 FROM mailbo...

...88.63.177,<R7Qe9J0fTgBfWD+x>): lookup: user=a.meyer at nimmini.de file=/etc/dovecot/passwd Sep 13 11:55:49 auth-worker(30822): Debug: passwd-file(a.meyer at nimmini.de,95.88.63.177): SELECT maildir, uid, gid, concat('*:storage=', quota) AS quota_rule, concat('Trash:storage=+', quota_trash) AS quota_rule2 FROM mailbox WHERE username = 'a.meyer at nimmini.de' Sep 13 11:55:49 auth: Debug: master userdb out: USER 997457921 a.meyer at nimmini.de maildir=/var/spool/vhosts/nimmini.de/ uid=5000 gid=5000 quota_rule=*:storage=5242880 quota_rule2=Tras...

...fWD+x>): > lookup: user=a.meyer at nimmini.de file=/etc/dovecot/passwd > Sep 13 11:55:49 auth-worker(30822): Debug: > passwd-file(a.meyer at nimmini.de,95.88.63.177): SELECT maildir, uid, > gid, concat('*:storage=', quota) AS quota_rule, > concat('Trash:storage=+', quota_trash) AS quota_rule2 FROM mailbox > WHERE username = 'a.meyer at nimmini.de' > Sep 13 11:55:49 auth: Debug: master userdb out: USER 997457921 > a.meyer at nimmini.de maildir=/var/spool/vhosts/nimmini.de/ > uid=5000 gid=5000 quota_rule=*:storage=5242880 > quo...

I use dovecot version 1.2.15 and i put quota for all users , now i want to give more size for some emails , i already added the quota to user database , and i added the queries from http://wiki.dovecot.org/Quota/1.1 MySQL: user_query = select uid, gid, home, \ concat('*:bytes=', quota_bytes) as quota_rule \ from users where userid = '%u' # MySQL with userdb prefetch: Remember