SOLVED add mail=user in user_attrs user_attrs = mail=user,homeDirectory=home,mailQuotaSize=quota_rule=*:bytes=%$
Tomislav Mihalicek wrote: > > I have the same problem but with LDAP, how to fix this on LDAP backed? > > scope = subtree > deref = never > pass_attrs = userPassword=password > base = ou=accounts,dc=globalnet,dc=hr > user_filter = > (&(|(objectClass=qmailUser)(objectClass=mailUser))(accountService=mail)(accountService=%Ls%Lc)(|(mail=%u)(mailAlternateAddress=%u))) > pass_filter = > (&(|(objectClass=qmailUser)(objectClass=mailUser))(accountService=mail)(accountService=%Ls%Lc)(|(mail=%u)(mailAlternateAddress=%u))) > pass_attrs = userPassword=password > default_pass_scheme = MD5 > user_attrs = homeDirectory=home,mailQuotaSize=quota_rule=*:bytes=%$ > > > > Jacek Osiecki wrote: >> >> Hello, >> >> I have a small server running dovecot 1.2 (still not balsy enough to >> switch to 2.0 - virtual sql accounts, managesieve etc.). There are no >> local users - only ones defined in the SQL database, and everything else >> (including quota) is defined in SQL db too. Dovecot is used as IMAP >> daemon, and dovecot-lda is responsible for delivery (in order to make use >> of sieve and managesieve). I know that my configuration might be a bit >> ancient, but this is not referring to any bug (at least I think so) and >> rather to errors I've made in configuration. >> >> Several users have reported, that they are running out of quota even >> though their mailboxes are empty. I thought these were some single cases, >> but recently I discovered that this situation occurs when: >> - user [email protected] has a mail alias, eg. [email protected] >> - he logs in to the imap account (using MUA or webmail) using his alias >> ([email protected]). >> >> In effect, all incoming emails for [email protected] are increasing the >> counters (both "bytes" and "messages"), but since user logs in using >> [email protected] - anything he deletes from the mailbox decreases >> the records for [email protected]. Finally, John has two records: >> >> +---------------------------+-----------+----------+ >> | username | bytes | messages | >> +---------------------------+-----------+----------+ >> | [email protected] | -5488133 | -13 | >> | [email protected] | 341411029 | 1111 | >> +---------------------------+-----------+----------+ >> >> The record for [email protected] finaly reaches the quota limit - and even >> removing all emails does not help. >> >> My /etc/dovecot/dovecot-dict-quota.conf looks like this: >> >> map { >> pattern = priv/quota/storage >> table = quota >> username_field = username >> value_field = bytes >> } >> map { >> pattern = priv/quota/messages >> table = quota >> username_field = username >> value_field = messages >> } >> >> And my question is: what is used as "username"? Always the username given >> wher user logs in? Is there a way to provide some dictionary to translate >> all aliases to the real username? >> >> Best regards, >> -- >> Jacek Osiecki [email protected] GG:3828944 >> I don't want something I need. I want something I want. >> >> > > -- View this message in context: http://old.nabble.com/Dovecot-1.2%2C-problem-with-SQL-quota-and-mail-aliases-tp30949509p32503822.html Sent from the Dovecot mailing list archive at Nabble.com.
