dovecot 1.0.15
Hello,
i try to set quota settings for my users.
currentyl i use a mysql table for auth process and now i want to add
quotasettings for each individual user.
at the moment i have the problem that only global quota is effective and no
userquota which is stored in usertable.
This is my mysql-usertable:
login varchar(255)
password varchar(64)
home varchar(128)
uid int(11)
gid int(11)
quota_kb varchar(10)
active char(1)
In my main-dovecot.conf i have quota/imap_quota activated for pop/imap and
protocol lda
This is the auth-section which contains passdb/userdb
auth default {
mechanisms = plain login
passdb sql {
args = /etc/dovecot-sql.conf
}
userdb sql {
args = /etc/dovecot-sql.conf
}
user = root
socket listen {
client {
path = /var/spool/postfix/private/auth
mode = 0660
user = postfix
group = postfix
}
}
socket listen {
client {
path = /var/run/dovecot/auth-master
mode = 0755
user = nobody
}
}
}
SQL-queries in /etc/dovecot-sql.conf (connection itselfs is ok, auth per
mysql is working already)
password_query = SELECT login as user, password, home as userdb_home, uid as
userdb_uid, gid as userdb_gid FROM mail_users WHERE login = '%u' AND
active='Y'
user_query = SELECT login as user, home, uid, gid,
concat('dirsize:storage=', quota_kb) AS quota FROM mail_users WHERE
login =
'%u'
I think there is something missing in my conf but have no idea what it could
be.
I need a little hint please.
Thanks,
Andre
Em 16/02/2010 09:18, Andre H?bner escreveu:> dovecot 1.0.15 > > Hello, > > i try to set quota settings for my users. > currentyl i use a mysql table for auth process and now i want to add > quotasettings for each individual user.Mine is working flawlesslly with the following configuration .... but i think that's only 1.1+ compatible, because of the Trash thing. Anyway, seems the big difference from my conf to your is that you're using concat('dirsize:storage=', quota_kb) while i'm using concat('*:storage=', quota) try to change that 'dirsize' to '*' and see what happens ... my actual working conf for dovecot 1.2.10 # Get the mailbox user_query = select '/var/spool/mail/%u' as home, 'maildir:/var/spool/mail/%u' as mail, 8 as uid, 12 as gid, concat('*:storage=', quota) as quota_rule, 'Trash:storage=100M' as quota_rule2 from emails where endereco = '%u' and ativa = '1' # Get the password password_query = select endereco as user, password, '/var/spool/mail/%u' as userdb_home, 'maildir:/var/spool/mail/%u' as userdb_mail, 8 as userdb_uid, 12 as userdb_gid, concat('*:storage=', quota) as userdb_quota_rule, 'Trash:storage=100M' as userdb_quota_rule2 from emails where endereco = '%u' and ativa = '1' -- Atenciosamente / Sincerily, Leonardo Rodrigues Solutti Tecnologia http://www.solutti.com.br Minha armadilha de SPAM, N?O mandem email gertrudes at solutti.com.br My SPAMTRAP, do not email it
Hello, thanks for your help :)>> so seems your quota is working !!!! What are you using as your Local >> Delivery Agent (LDA) ?? Is it dovecot LDA ? Is it some MTA LDA, like >> Postfix ?>> Maybe quota is not working on your LDA ... not on IMAP4/POP3.i switched from procmail to deliver in my postfix main.cf is: mailbox_command = /usr/libexec/dovecot/deliver in dovecot.conf: protocol lda { postmaster_address = postmaster at example.com sendmail_path = /usr/sbin/sendmail auth_socket_path = /var/run/dovecot/auth-master mail_plugins = quota } the configured socket is listening: srwxrwxrwx 1 nobody root 0 2010-02-16 14:53 /var/run/dovecot/auth-master "deliver" is delivering the mail. here a log-line: Feb 16 14:53:49 myhostname deliver(m01204c5): msgid=<26D0A508EF3641EE9F79DCEC887753EF at me.local>: saved mail to INBOX There are no errors etc. logged. but quota ist still working only when logged in into mailaccounts but not on incoming mails. If there would be some errors i could do anything but there is nothing special in the logs... Thanks, Andre