search for: quota_rule2

...> > > 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_rul...

...ery-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 whereas /var/s...

...h-test.com auth-worker(2195): Debug: dict(hammer at rp-auth-test.com): result: {"uid":"8","fts":"solr","quota_rule4":"Spam:ignore","_session":"talk15_590ec6d100042","quota_rule3":"Trash:ignore","quota_rule2":"*:messages=2684354","quota_rule":"*:storage=5242880k","mail":"maildir:/mail/mailstore01/215/573/hammer at rp-auth-test.com/:INDEX=/mail/index01/215/573/hammer at rp-auth-test.com/","fts_solr":"debug url=http://ftsvs01:8080/solr...

Hi, I'm about getting to know dovecot in details, I am about the command "doveadm user". The man page shows this example: userdb: jane uid : 8001 gid : 8001 home : /home/jane mail : sdbox:~/sdbox plugins : sieve quota_rule: *:storage=150M It seems to be nice, however I never got this only: ~# doveadm

On 05.09.2017 11:28, Steffen Kaiser wrote: > On Fri, 1 Sep 2017, ????? ????? wrote: > > > plugin { > > quota = maildir:"User quota" > > quota_rule = *:storage=10M > > quota_rule3 = INBOX.Trash:storage=+10%% > ^^ this should spell quota_rule2 > but is not the issue right now > actually dovecot probably stops looking after it fails to see quota_rule2. Aki

...Qe9J0fTgBfWD+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=Trash:storage=+100...

...ievec) failed Oct 13 10:31:53 h8h1 deliver(ml at sd2i.com): msgid=<8a24c15885037554724ff966f5458592 at newsletter.RedSquare.com.au >: saved mail to INBOX Ay idea ? another question : I use virtual users only, they all have a quota_rule from mysql with different quota size, but I put a quota_rule2 globally to ignore Trash since the ignore= doesn't work anymore with 1.1, is that valid or do I need to add the quota_rule2 to mysql results too ? Thanks, David. ------------------------------------------------------- # dovecot -n # 1.1.3: /usr/local/etc/dovecot.conf protocols: imap pop3...

...= =home=/var/vmail/%Ln/Maildir,=mail=maildir:/var/vmail/%Ln/Maildir/,otherPager=quota_rule=*:storage=%$ I configured the quota plugin in the following way: plugin { quota = maildir:User quota:ns= quota2 = maildir:Archive quota:ns=Archives. quota_rule = *:storage=1G quota_rule2 = ns=Archives.:ignore } unfortunately this does not give the desired result. Folders under the Archives namespace use the same quota as INBOX. Does anyone have an idea how to fix this ? Thank you for your kind help Andreas

...The doquotawarning.py script is working okay -- meaning that the user gets a warning. My SQL backend uses the following query: user_query = \ SELECT m.maildir AS home, 1001 AS uid, 1001 AS gid, \ CONCAT('*:bytes=', m.quota, 'M') AS quota_rule, \ 'Trash:ignore' AS quota_rule2 \ FROM mailbox m \ INNER JOIN domain d \ ON d.id = m.domainid \ WHERE d.domain = '%d' \ AND m.user = '%n' Where m.quota is the user's personal quota (in MB). As you can see, we ignore the 'Trash' box, when considering the usage data. We are using the dict...

...P directory. We allow login and LDA with both full mail address and an internal username, so the mailbox directory is based on a LDAP attribute user_attrs = xxxMailbox=mail=maildir:/home/mailstore/%U$/Maildir:INDEX=/home/mailstore/indexes/%1U$/%U$, uidNumber=vmail, gidNumber=vmail, xxxMailQuota=quota_rule2=*:storage=%$B this worked just fine until we introduced sieve, which made us realize we did not have the home directory set at all. The obvious and easy fix (we thought) was to set the home directory based on the xxxMailbox variable as well: user_attrs = xxxMailbox=mail=maildir:/home/mailstore/...

...9539 (95%) messages=0 command=/opt/email/bin/dovecot-quota-warning.sh 95 q56 at t.com Sep 12 10:14:16 auth(default): Info: 1111111111111111111111111111!:id:22 OK q148 at t.com username=q148 at t.com password={CRYPT}$1$711536ed$Q4xYrsYOS6bVq9mJvNoc40 home=/opt/mail mail=maildir:/opt/mail/t.com/q148/ quota_rule2=*:messages=1111 quota_rule=*:bytes=1164967936 line: OK q148 at t.com username=q148 at t.com password={CRYPT}$1$711536ed$Q4xYrsYOS6bVq9mJvNoc40 home=/opt/email mail=maildir:/opt/email/t.com/q148/ quota_rule2=*:messages=1111 quota_rule=*:bytes=1164967936 request:23 Sep 12 10:14:16 auth(default): Erro...

...is global mail_plugins). So what is that default global mail_plugins ? Is it the one coming from 10-mail.conf ? 2) I tried both use this mail_plugins = $mail_plugins quota in 20-imap.conf or comment it. And restarted dovecot each time Then commented out in 90-quota.conf quota_rule = *:storage=1G quota_rule2 = Trash:storage=+100M quota_grace = 10%% } But I have this message # doveadm quota recalc -u user at mydomain.org doveadm(user at mydomain.org): Error: Quota not enabled Does anyone knows why ?

...sers 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 mailbox WHERE usernam...

...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=Trash:s...

Hello I am trying to setup dovecot maildir quota, but even though it seems to be working fine, I am still receiving emails into my inbox even though I have exceeded my quota. Here is my dovecot config: plugin { quota = maildir:User Quota quota_rule2 = Trash:storage=+100M } And my SQL config file for Dovecot (dovecot-sql.conf): user_query = SELECT '/var/vmail/%d/%n' as home, 'maildir:/var/vmail/%d/%n' as mail, 150 AS uid, 8 AS gid, CONCAT('*:storage=', quota) AS quota_rule FROM mailbox WHERE username = '%u'...

Hallo. Sorry for may bad english. I'm running dovecot 1.0.15 on a debian lenny system. I've set quota plugin and, under section plugin, I've set: quota = maildir quota_rule = *:storage=50M quota_rule2 = Trash:storage=10%% quota_warning = storage=95%% /usr/local/bin/quota-warning.sh 95 quota_warning2 = storage=80%% /usr/local/bin/quota-warning.sh 80. For some accounts the quota limit works well. When I send mail I receive a rejected mail for quota exceeded. For some other accounts it doesn'wo...

...path for dovecot-quota file location from LDAP like from mail variable (/mailboxes/storage_01/domain.org/u/us/use/user/dbox/dovecot-quota)? /etc/dovecot/dovecot-ldap.conf user_attrs = storageBase=home,mailMessageStore=mail=dbox:~/%$/dbox/,mailQuota=quota_rule=*:bytes=%$,mailQuotaMessageLimit=quota_rule2=*:messages=%$ Also is it also possible the same for sieve location? I can solve the problem by adding in dovecot.conf sieve = /var/sieve/%Ld/%Ln/dovecot.sieve but i would like to have it all in one place ... t -- View this message in context: http://old.nabble.com/Dovecot-1.2.%2B-tp26803721p...

Hello! I activated quota plugin { quota = maildir:User quota quota_rule = *:storage=1GB # 10% of 1GB = 100MB quota_rule2 = Trash:storage=+10%% } But when I want to do per user quota in the passwd-file ...vhosts/anup.de/anmeyer::userdb_mail=maildir:~/userdb_quota_rule=*:bytes=10G I get this in the logfile and can't login: Jun 08 22:25:52 imap(anmeyer at anup.de): Error: user anmeyer at anup.de: Initialization f...

...ure specific mailboxes to have a bit more space available for them, such as Trash or Spam. The configuration has also changed. Normally you'd use something like this: quota = maildir # 1GB quota in general quota_rule = *:storage=1048576 # Trash mailbox gets 100MB more (so max. 1,1GB) quota_rule2 = Trash:storage=102400 # Spam mailbox gets also +100MB (still maxes at 1,1GB, not 1,2GB) quota_rule3 = Spam:storage=102400 You can place all the above into plugin { .. } section in dovecot.conf. In userdb if users have different quotas you'd then need to override only quota_rule (not quota...

...t;mMJrGzOMWVtTAQAALagawQ>: <20180726105407.7b9cbf8d at muffycake> lenny@***/lenny@*** pop3 test mail #2 -> lenny@*** 2651: saved mail to INBOX Jul 26 10:54:11 mda11 dovecot: doveadm(jakub@***)<2172><>: Debug: auth USER input: jakub@*** uid=65534 quota_rule=*:bytes=3221225472 quota_rule2=*:messages=0 Jul 26 10:54:11 mda11 dovecot: doveadm(jakub@***)<2172><>: Debug: Added userdb setting: plugin/quota_rule=*:bytes=3221225472 Jul 26 10:54:11 mda11 dovecot: doveadm(jakub@***)<2172><>: Debug: Added userdb setting: plugin/quota_rule2=*:messages=0 Jul 26 10:54:11 m...