Hi all, i am asking myself how quota is done with dbox in a virtual setup with having quotas in sql dove 1.1.1 says quota maildir: No maildir storages, ignoring quota lda means quota maildir: No maildir storages, ignoring quota which is right i dont wanna use dict , i only wanna use the qutoas out of sql crated by postfixadmin has someone used this ever ? -- Best Regards MfG Robert Schetterer Germany/Munich/Bavaria
On Sat, 2008-07-12 at 13:29 +0200, Robert Schetterer wrote:> Hi all, > i am asking myself > how quota is done with dbox in a virtual setup > with having quotas in sql > > dove 1.1.1 > says quota maildir: No maildir storages, ignoring quota > lda means quota maildir: No maildir storages, ignoring quota > which is right > > i dont wanna use dict ,?Maildir++ quota can be used only with Maildir. It would be possible to keep quota in Maildir++ compatible maildirsize file, but there's no code to do that yet and I wasn't planning on implementing it anytime soon.> i only wanna use the qutoas out of sql crated by > postfixadminWhat does this mean? Does it create the maildirsize files? Can't you have Dovecot look up the limits from SQL itself in user_query? -------------- next part -------------- A non-text attachment was scrubbed... Name: signature.asc Type: application/pgp-signature Size: 197 bytes Desc: This is a digitally signed message part URL: <http://dovecot.org/pipermail/dovecot/attachments/20080712/58aec4eb/attachment-0002.bin>
Timo Sirainen schrieb:> On Sat, 2008-07-12 at 13:29 +0200, Robert Schetterer wrote: >> Hi all, >> i am asking myself >> how quota is done with dbox in a virtual setup >> with having quotas in sql >> >> dove 1.1.1 >> says quota maildir: No maildir storages, ignoring quota >> lda means quota maildir: No maildir storages, ignoring quota >> which is right >> >> i dont wanna use dict , > > ?Maildir++ quota can be used only with Maildir. It would be possible to > keep quota in Maildir++ compatible maildirsize file, but there's no code > to do that yet and I wasn't planning on implementing it anytime soon. > >> i only wanna use the qutoas out of sql crated by >> postfixadmin > > What does this mean? Does it create the maildirsize files? Can't you > have Dovecot look up the limits from SQL itself in user_query?sorry i was unclear here, quotas are created from http postfixadmin gui in a sql table which i like to use with dbox. It works nice with maildir as documented I thought somehow workaround dbox quota with a dict quota sql... but as i understood examples with dict ,it should be used to update static quotas to a sql table , not read dynamic quotas out of sql ( am i right here? ) I think existing quotas in sql could be used if dovecot would ignore that no maildir storage is used and simply interpretes existing maildirsize files, which maybe created out of existing sql quota entries ( but thats speculate ) -- Best Regards MfG Robert Schetterer Germany/Munich/Bavaria
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