Timo Sirainen wrote:
On Feb 4, 2009, at 11:21 PM, Ken Anderson wrote:
Is there a way to return a per user dirsize quota from a passdb sql lookup? If so, what is the syntax?
Yes, but only if you use prefetch userdb. Do you? If not, you'll need to return it from userdb.
So, prefetch userdb is all or none. My userdb is currently /etc/passwd to keep sendmail and other legacy stuff happy. I used fs quota, but am now moving INBOX to a different (faster) partition, which breaks fs quota reporting in things like squirrelmail. Dovecot is 1.0.5 What would you suggest? Thanks, Ken
maybe "select quota as userdb_quota"?
..and in mysql table, quota column would be: "quota=dirsize:storage=10240" ?
"dirsize:storage=10240" actuall. Or more easily keep the quota number in SQL and use:
select concat('dirsize:storage=', quota) as userdb_quota
I'm using mbox, with /etc/passwd userdb, and mysql passdb.
What Dovecot version?