Dovecot don't erase mails from storage.

[Carlos Baptista]

Hi,

I have a dovecot installation with a strange problem: all the mails stays
in storage after deleted from users mailbox. If user logon after the mails
are deleted, they don't receive them any more, but the m.## files aren’t
deleted. This happens with pop3 (default for this installation) and/or imap.

The dovecot is installed along postfix with mysql and multi-domains support

Here's the dovecot conf
########################


dovecot -n
# 2.1.7: /etc/dovecot/dovecot.conf
# OS: Linux 2.6.32-042stab111.11 x86_64 Debian 7.9
auth_mechanisms = plain login
first_valid_uid = 111
last_valid_uid = 111
lda_mailbox_autocreate = yes
mail_debug = yes
mail_gid = vmail
mail_plugins = " quota"
mail_privileged_group = vmail
mail_uid = vmail
namespace inbox {
 inbox = yes
 location =
 mailbox Drafts {
   special_use = \Drafts
 }
 mailbox Junk {
   special_use = \Junk
 }
 mailbox Sent {
   special_use = \Sent
 }
 mailbox "Sent Messages" {
   special_use = \Sent
 }
 mailbox Trash {
   special_use = \Trash
 }
 prefix =
}
passdb {
 args = /etc/dovecot/dovecot-sql.conf
 driver = sql
}
plugin {
 mail_log_events = delete undelete expunge copy mailbox_delete
mailbox_rename
 mail_log_fields = uid box msgid size
 quota = dict:User quota::file:%h/mail/dovecot-quota
 quota_rule = *:storage=500MB
}
postmaster_address = sysadmin at inside.pt
protocols = " imap pop3"
service auth {
 unix_listener /var/spool/postfix/private/auth {
   group = postfix
   mode = 0660
   user = postfix
 }
}
service lmtp {
 unix_listener /var/spool/postfix/private/dovecot-lmtp {
   group = postfix
   mode = 0660
   user = postfix
 }
}
ssl_cert = </etc/dovecot/dovecot.pem
ssl_key = </etc/dovecot/private/dovecot.pem
userdb {
 driver = prefetch
}
userdb {
 args = /etc/dovecot/dovecot-sql.conf
 driver = sql
}
protocol lmtp {
 mail_plugins = " quota sieve"
}
protocol lda {
 mail_plugins = " quota"
}
protocol imap {
 mail_plugins = " quota imap_quota"
}

###############################

Here is an example of log file with debug

Oct 02 17:50:38 auth: Debug: auth client connected (pid=11621)
Oct 02 17:50:38 auth: Debug: client in: AUTH    1       PLAIN
  service=pop3    secured session=Xiif9iEhmgBV80+u
       lip=xxx.xxx.xxx.xxx     rip=xxx.xxx.xxx.xxx       lport=995
      rport=53914     resp=<hidden>
Oct 02 17:50:38 auth-worker(11561): Debug:
sql(carla.franjoso at xxxxxxx.xx,xxx.xxx.xxx.xxx):
query: /* dovecot-sql.conf password_query */ SELECT
'/var/vmail/xxxxxx.xx/carla.franjoso' AS userdb_home, 'mdbox:~/mail' AS
userdb_mail, 111 AS userdb_uid, 114 AS userdb_gid, CONCAT('*:bytes=',
CAST(m.quota AS CHAR)) AS userdb_quota_rule, CONCAT(m.local_part, '@',
d.name) AS user, m.password AS password FROM mailboxes AS m LEFT JOIN
domains AS d ON m.domain_id = d.id WHERE m.local_part = 'carla.franjoso'
AND d.name = 'xxxxxxx.xx' AND m.is_active AND d.is_active
Oct 02 17:50:38 auth: Debug: client out: OK     1
      user=carla.franjoso at xxxxxx.xx
Oct 02 17:50:38 auth: Debug: master in: REQUEST 3537633281      11621   1
      41ef179d4a37a603ce38c43fab768f78
Oct 02 17:50:38 auth: Debug:
prefetch(carla.franjoso at xxxxxx.xx,xxx.xxx.xxx.xxx,<Xiif9iEhmgBV80+u>):
success
Oct 02 17:50:38 auth: Debug: master out: USER   3537633281
     carla.franjoso at xxxxx.xx home=/var/vmail/xxxxxxxx/carla.franjoso
mail=mdbox:~/mail       uid=1
11 gid=114 quota_rule=*:bytes=104857600
Oct 02 17:50:38 pop3: Debug: Loading modules from directory:
/usr/lib/dovecot/modules
Oct 02 17:50:38 pop3: Debug: Module loaded:
/usr/lib/dovecot/modules/lib10_quota_plugin.so
Oct 02 17:50:38 pop3: Debug: Added userdb setting: mail=mdbox:~/mail
Oct 02 17:50:38 pop3: Debug: Added userdb setting:
plugin/quota_rule=*:bytes=104857600
Oct 02 17:50:38 pop3(carla.franjoso at xxxxx.xx): Debug: Effective uid=111,
gid=114, home=/var/vmail/xxxxxxxx.xx/carla.franjoso
Oct 02 17:50:38 pop3(carla.franjoso at xxxxx.xx): Debug: Quota root: name=User
quota backend=dict
args=:file:/var/vmail/xxxxxxxxx.xx/carla.franjoso/mail/dovecot-quota
Oct 02 17:50:38 pop3(carla.franjoso at xxxxx.xx): Debug: Quota rule: root=User
quota mailbox=* bytes=104857600 messages=0
Oct 02 17:50:38 pop3(carla.franjoso at xxxxx.xx): Debug: dict quota:
user=carla.franjoso at xxxx.xx,
uri=file:/var/vmail/xxxxxx,xx/carla.franjoso/mail/dovecot-quot
a, noenforcing=0
Oct 02 17:50:38 pop3(carla.franjoso at xxxxx.xx): Debug: Namespace inbox:
type=private, prefix=, sep=, inbox=yes, hidden=no, list=yes,
subscriptions=yes locatio
n=mdbox:~/mail
Oct 02 17:50:38 pop3(carla.franjoso at xxxxx.xx): Debug: fs: root=/var/vmail/
assis.pt/carla.franjoso/mail, index=, control=, inbox=, alt=
Oct 02 17:50:38 pop3(carla.franjoso at xxxxx.xx): Debug: Namespace : Using
permissions from /var/vmail/xxxxxxx.xx/carla.franjoso/mail: mode=0700
gid=-1


What is "gid=-1" at the end of the log?

Can anyone help?

Thanks
Carlos Baptista