maildrop 2.0.2 mysql postix quota maildir

[Dusan Sys]

ja jsem quoty poresil primo pres postfix.

staci jej opatchovat ptachem z  http://web.onda.com.br/nadal/postfix/VDA/


do main.cf pridat 

virtual_create_maildirsize = yes
virtual_mailbox_extended = yes
virtual_mailbox_limit_override = yes
virtual_mailbox_limit_maps = mysql:/etc/postfix/quota.cf
virtual_overquota_bounce = yes
virtual_maildir_limit_message = "Mailbox quota reached / Uzivatel ma plnou
schranku"
virtual_mailbox_limit_inbox = yes


quota.cf vypada asi takto 

user = xxx
password = xxx
dbname = system
table = users
select_field = quota
where_field = user
hosts = localhost

Funguje to bezvadne a zda se mi to jako cistejsi reseni. Pres maidrop jsem s
tim take nehnul.

Zdravi Dusan Sys


-----Original Message-----
From: Mgr. Miroslav Baranko [mailto:miroslav.baranko na upjs.sk] 
Sent: Thursday, July 06, 2006 8:31 AM
To: linux na linux.cz
Subject: maildrop 2.0.2 mysql postix quota maildir

zdravim,
precital som si kopec veci (google)
zvacsa su popisovane starsie (archaicke verzie maildropu)

Maildrop stale dorucuje, aj ked je quota prekrocena (quota v mysql je
nastavena napr. na 1000S)

courier-auth s debug rezimom:
Jul  6 02:13:41 dev2 authdaemond: authmysql: sysusername=, sysuserid=208,
sysgroupid=12, homedir=/mailroot, address=destinqo na test, fullname=,
maildir=test/destinqo/, quota=1000, options=

uz som stravil hodiny nad tym. Mozno niekoho nieco napadne vdaka.
Opatchoval som aj postfix aby mi fungovaly quoty na maildiry, ale tiez to
nejde.

POSTFIX 2.1.5/COURIER-IMAP 4.1.1 /MAILDROP 2.0.2/ MYSQL 4.1.20

main.cf:
mailbox_command = /usr/bin/maildrop -w 90 -d ${USER}
maildrop_destination_concurrency_limit = 1
maildrop_destination_recipient_limit   = 1
virtual_create_maildirsize = yes
virtual_overquota_bounce = yes
virtual_mailbox_limit_maps =
mysql:/etc/postfix/mysql-virtual_mailbox_limit_maps.cf

atd.

master.cf:
maildrop  unix  -       n       n       -       -       pipe
  flags=R user=vmail argv=/usr/bin/maildrop -w 90 -d ${recipient}