Hello,

this is unfortunately not compatible with dovecot 1.0, is not working

i switched now to dovecot 1.2.10, which  is current stable release.
unfortunately my userquoata is not working, just global quota ist active and is not overwritten by userquota from userdb I cannot go on with my setup, the devil's in the detail but i dont find it...
I repeat my setup, maybe somebody is seeing something.

this is my mysql-table i use for auth and quota:

login varchar(255)
password varchar(64)
home varchar(128)
uid int(11)
gid int(11)
quota_bytes varchar(15)
active char(1)

typical dataset:
username| 027c57a0bda1922cb475b39817e08c0514651a03| /home/popuser/username |508| 500| 10| Y

my password_query:
password_query = SELECT login as user, password FROM mail_users WHERE login = '%u' AND active='Y'

my user_query:
user_query = SELECT home, uid, gid, concat('*:storage=', quota_bytes,'M') AS quota_rule FROM mail_users WHERE login = '%u'

quota/imap_quota is activated for pop/imap/lda
lda is used to deliver mails:
plugin-section is:

plugin {
   quota = dirsize:user
   quota_rule = *:storage=1000G
}

I have no idea why its not working. Quota is only effective if i decrease global quota lower values, it gets not overwritten with data from userdb. in verbose mailog i can see queries to mysql, i double checked format etc. but have no solution.

Thanks,
Andre

Reply via email to