Re: [Dovecot] dirsize quota in sql pass db?

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?