[Dovecot] Dovecot 2.0, mysql and quota

[Claudio Prono]

Il 30/06/2011 6.56, Timo Sirainen ha scritto:
> On Wed, 2011-06-29 at 18:02 +0200, Claudio Prono wrote:
> Are you sure you tested it correctly? It is executed only when a mail is
> delivered across the 79% -> 80% quota boundary.
>
> I don't see any error in your config.
>

Ok, fixing some things, the script is going to be executed:

Jun 30 10:44:07 lda(testquota at mediaservice.pri): Debug: quota: Executing
warning: quota-warning 80 testquota at mediaservice.pri

But, i have an error anyway. After is executed, i found an error on
dovecot-err.log:

Jun 30 10:44:07 quota-warning: Error: /usr/bin/quota_warning.sh: line 4:
/usr/lib/dovecot/dovecot-lda: Permission denied
Jun 30 10:44:07 quota-warning: Error: cat: write error: Broken pipe
Jun 30 10:44:07 master: Error: service(quota-warning): child 5627
returned error 126

That are the permissions of /usr/lib/dovecot-lda:

-rwsr-s--- 1 root nobody 23560 May 25 13:13 /usr/lib/dovecot/dovecot-lda

I report another time my dovecot -n, because i have made some changes..

dovecot -n
# 2.0.13: /etc/dovecot/dovecot.conf
# OS: Linux 2.6.37.6-0.5-desktop x86_64 openSUSE 11.4 (x86_64) ext3
auth_mechanisms = plain login
first_valid_gid = 51
first_valid_uid = 51
info_log_path = /var/log/dovecot-inf.log
last_valid_gid = 51
last_valid_uid = 51
log_path = /var/log/dovecot-err.log
mail_home = /var/mail/virtual/%d/%u/
mail_location = maildir:/var/mail/virtual/%d/%u
managesieve_notify_capability = mailto
managesieve_sieve_capability = fileinto reject envelope
encoded-character vacation subaddress comparator-i;ascii-numeric
relational regex imap4flags copy include variables body enotify
environment mailbox date
namespace {
  hidden = no
  inbox = yes
  list = yes
  location =
  prefix = INBOX.
  subscriptions = yes
  type = private
}
passdb {
  args = /etc/dovecot/dovecot-mysql.conf
  driver = sql
}
plugin {
  quota = maildir:User quota
  quota_warning = storage=95%% quota-warning 95 %u
  quota_warning2 = storage=80%% quota-warning 80 %u
  quota_warning3 = storage=70%% quota-warning 99 %u
  sieve = /var/mail/virtual/%d/%u/.dovecot.sieve
  sieve_storage = /var/mail/virtual/%d/%u/sieve
}
protocols = imap pop3 sieve
service auth {
  unix_listener /var/spool/postfix/private/auth {
    group = postfix
    mode = 0660
    user = postfix
  }
  unix_listener auth-master {
    mode = 0600
  }
  unix_listener auth-userdb {
    group = nobody
    mode = 0660
    user = postfix
  }
}
service imap-login {
  inet_listener imap {
    address = 127.0.0.1
    port = 143
  }
}
service managesieve-login {
  executable = /usr/lib/dovecot/managesieve-login
}
service managesieve {
  executable = /usr/lib/dovecot/managesieve
}
service quota-warning {
  executable = script /usr/bin/quota_warning.sh
  unix_listener quota-warning {
    group = postfix
    mode = 0660
    user = postfix
  }
  user = postfix
}
ssl = no
userdb {
  driver = passwd
}
userdb {
  args = /etc/dovecot/dovecot-mysql.conf
  driver = sql
}
protocol imap {
  imap_client_workarounds =
  mail_plugins = quota imap_quota
}
protocol sieve {
  managesieve_max_line_length = 65536
  plugin {
    sieve = /var/mail/virtual/%d/%u/.dovecot.sieve
    sieve_storage = /var/mail/virtual/%d/%u/sieve
  }
}
protocol pop3 {
  mail_plugins = quota
  pop3_uidl_format = UID%u-%v
}
protocol lda {
  auth_socket_path = /var/run/dovecot/auth-master
  log_path = /var/log/dovecot-lda.log
  mail_debug = yes
  mail_plugins = quota sieve
  postmaster_address = postmaster at mediaservice.net
}

Where is the problem?

Cordially,

Claudio Prono

-- 
--------------------------------------------------------------------------------
Claudio Prono                         OPST
System Developer               
                                      Gsm: +39-349-54.33.258
@PSS Srl                              Tel: +39-011-32.72.100
Via San Bernardino, 17                Fax: +39-011-32.46.497
10141 Torino - ITALY                  http://atpss.net/disclaimer
--------------------------------------------------------------------------------
PGP Key - http://keys.atpss.net/c_prono.asc