[Dovecot] dbox and quota question

[Benny Pedersen]

On Sat, July 12, 2008 13:29, Robert Schetterer wrote:

> i dont wanna use dict , i only wanna use the qutoas out of sql crated by
> postfixadmin
>
> has someone used this ever ?

driver = mysql
connect = host=localhost dbname=postfix user=postfix password=password
default_pass_scheme = MD5-CRYPT
password_query = SELECT password FROM mailbox WHERE username = '%u'
user_query = SELECT concat('/home/vmail/', maildir) AS home,
concat('/home/vmail/', maildir) AS maildir, 125 AS uid, 125 AS gid,
concat('maildir:storage=', floor(quota/1024)) AS quota FROM mailbox WHERE
username = '%u'

beware of line wraps, this works with postfixadmin here

i just need to solve the 2GB barrier :/


-- 
Benny Pedersen
Need more webspace ? http://www.servage.net/?coupon=cust37098