[Exim] Exim Quota-SQL

Top Page
Delete this message
Reply to this message
Author: Abaddon
Date:  
To: exim-users
Subject: [Exim] Exim Quota-SQL
The Facts:

FreeBSD 4.4

helo x
mail from: sksks@???
rcpt to: blah@???
DATA
test
test
.
quit


  username  domain       alias  is_alias  password  quota
  blah      domain.com          no        blah      1


QUOTA_MYSQL = select quota from mail where
username='${quote_mysql:$local_part}' and domain='${quote_mysql:$domain}'


virtual_delivery:
   driver = appendfile
   file = /var/spool/mail/${domain}/${local_part}
   quota = ${lookup mysql {QUOTA_MYSQL}{$value}}
   quota_warn_threshold = 100%
   quota_warn_message = "\
                 To: $local_part@$domain\n\
                 Subject: Your mailbox\n\n\
                 This message is automatically created \
                 by mail delivery software.\n\n\
                 The size of your mailbox has exceeded \
                 a warning threshold that is\n\
                 set by the system administrator.\n"


user = mail
group = mail
mode = 0660

2002-01-11 21:59:01 16P9hU-000120-00 == blah@??? T=virtual_delivery
defer (-23): mailbox is full (MTA-i
mposed quota exceeded while writing to file /var/spool/mail/domain.com/blah)


Writing retry data for T:blah@???
first failed=1010786051 last try=1010786786 next try=1010787686 expired=0
error -23 0: mailbox is full (MTA-imposed quota exceeded while writing
to file /var/spool/mail/domain.com/blah)
dbfn_write: key=T:blah@???
end of retry processing

bash-2.05# strings retry
mailbox is full (MTA-imposed quota exceeded while writing to file
/var/spool/mail/domain.com/blah)
T:blah@???

bash-2.05# ls
16P9te-00013I-00-D      16P9te-00013I-00-H





The Questions:

I am trying to put up a quota-peruser (mysql table) on my system.

1. The "1" on my quota table will be understand as bytes, kbyte ou mega ?
(I know if i put 1M it will be understand as 1 mega)
2. Why dosent the exim send the quota_warn_message immediately ?
3. How can i make the exim to send the quota_warn_message immediately ?

Philip, just keep the good jog ! :)