[Dovecot] dirsize quota in sql pass db?

[Timo Sirainen]

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?