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.
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?