Mail Quota with Dovecot (User + Domain)

[kouga]

(01-25-2010 07:50 PM)TheCry Wrote:  

Code:

as home, '3001' as uid, '12'

Is this correct on your system?
This are the uid and gid of the user vmail!
Please check this in your passwd!

Here's my passwd.

Quote:mail:x:8:12:mail:/var/spool/mail:/sbin/nologin
vmail:x:3001:12:vmail-user:/home/vmail:/bin/false

Quote:Check the path of deliver
This is my config

Code:

dovecot unix - n n - - pipe
  flags=DRhu user=vmail:mail argv=/usr/local/libexec/dovecot/deliver -f ${sender} -d ${recipient}

The path to deliver is correct in my environment.

BTW:

Quote:If you have different emailadresses eg "info@..." you will get more than one line in this query.

You were right!! I made correction in my dovecot-sql-*.conf.
Thanks for your advise.

[TheCry]

(01-25-2010 07:59 PM)kouga Wrote:  BTW:

Quote:If you have different emailadresses eg "info@..." you will get more than one line in this query.

You were right!! I made correction in my dovecot-sql-*.conf.
Thanks for your advise.

OK...
So i will change the wiki next time!
Thanks for the testing!

[kouga]

(01-25-2010 08:04 PM)TheCry Wrote:  OK...
So i will change the wiki next time!
Thanks for the testing!

No problem. I tested because I needed to know.

Meanwhile, did you try [per domain quota] for mail??

[aseques]

Hi, I just spotted the mistake on the wiki, I changed the WHERE into:

mail_acc='%n' and domain.domain_name='%d'

I didn't spot that mistake on the wiki config (I have my local copy already fixed)

[TheCry]

(01-25-2010 08:17 PM)kouga Wrote:  Meanwhile, did you try [per domain quota] for mail??

Sorry.. No...

[kouga]

(01-25-2010 08:34 PM)TheCry Wrote:  Sorry.. No...

Someone give me some FRISK or a perfect solution.

[TheCry]

I remember we had a patch inside the german corner: http://www.isp-control.net/forum/thread-...age-3.html

But... Diskspace quota and mailbox quota are 2 different table entries...
It is not so simple what you want!

[kouga]

(01-25-2010 08:56 PM)TheCry Wrote:  I remember we had a patch inside the german corner: http://www.isp-control.net/forum/thread-...age-3.html

But... Diskspace quota and mailbox quota are 2 different table entries...
It is not so simple what you want!

German....Can't understand what everybody is talking about...
But I'll check more.

I was thinking, if domain quota size (quota/used) calculated by proftpd
be included in table of mail_users, and find a way to query both
user/domain quota with Dovecot while receiving mail, maybe it's possible??

[kouga]

(01-26-2010 10:07 AM)kouga Wrote:  I was thinking, if domain quota size (quota/used) calculated by proftpd
be included in table of mail_users, and find a way to query both
user/domain quota with Dovecot while receiving mail, maybe it's possible??

OR, how about enabling postfix virtual quota using VDA and check the
domain quota only, when passed, give it to Dovecot LDA and check the
user quota.

I'll give it a try.

----------------------------------

Nope, didn't work.
Now what.....

[kilburn]

Domain quotas and mail quotas are different beasts. Mail quotas (which ispcp doesn't directly support as of now) are to be checked each time a mail is delivered, whereas domain disk quotas are updated just overnight.

Thus, integrating them both in the mail delivery is a fairly stupid thing to do, because if the domain is ever detected over-quota, all the users would be unable to receive e-mails for a whole day, even if they free the overused space.

That said, the short answer is: trying to check domain quotas when delivering mail is currently a stupid thing to do, so just make sure that sum(mail_quotas) < domain_quota and you'll be fine.