Re: [Dovecot] dbox and quota question

2008-07-15 Thread 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 p

Re: [Dovecot] dbox and quota question

2008-07-12 Thread Robert Schetterer
Timo Sirainen schrieb: On Jul 12, 2008, at 7:08 PM, Robert Schetterer wrote: concat('*:storage=', ROUND( mailbox.quota / 1024 ) ) AS quota, \ cant work with dict, working on it It doesn't work with v1.1 in general. Use "AS quota_rule". Also an easier way to use bytes quota is: concat('*:by

Re: [Dovecot] dbox and quota question

2008-07-12 Thread Timo Sirainen
On Jul 12, 2008, at 7:08 PM, Robert Schetterer wrote: concat('*:storage=', ROUND( mailbox.quota / 1024 ) ) AS quota, \ cant work with dict, working on it It doesn't work with v1.1 in general. Use "AS quota_rule". Also an easier way to use bytes quota is: concat('*:bytes=', mailbox.quota)

Re: [Dovecot] dbox and quota question

2008-07-12 Thread Robert Schetterer
Robert Schetterer schrieb: Timo Sirainen schrieb: On Sat, 2008-07-12 at 17:07 +0200, Robert Schetterer wrote: sorry i read dict stuff and i dont understand it i have no idea to make this work out of the wiki .. ok i allready have my quota tables from postfix admin and i am unclear about the q

Re: [Dovecot] dbox and quota question

2008-07-12 Thread Robert Schetterer
Timo Sirainen schrieb: On Sat, 2008-07-12 at 17:07 +0200, Robert Schetterer wrote: sorry i read dict stuff and i dont understand it i have no idea to make this work out of the wiki .. ok i allready have my quota tables from postfix admin and i am unclear about the query i need as well how to s

Re: [Dovecot] dbox and quota question

2008-07-12 Thread Timo Sirainen
On Sat, 2008-07-12 at 17:07 +0200, Robert Schetterer wrote: > sorry i read dict stuff > and i dont understand it > i have no idea to make this work out of the wiki .. > ok i allready have my quota tables > from postfix admin > and i am unclear about the query i need > as well how to set this in plu

Re: [Dovecot] dbox and quota question

2008-07-12 Thread Robert Schetterer
Timo Sirainen schrieb: On Sat, 2008-07-12 at 16:38 +0200, Robert Schetterer wrote: Timo Sirainen schrieb: On Sat, 2008-07-12 at 16:12 +0200, Robert Schetterer wrote: I think existing quotas in sql could be used if dovecot would ignore that no maildir storage is used and simply interpretes exis

Re: [Dovecot] dbox and quota question

2008-07-12 Thread Timo Sirainen
On Sat, 2008-07-12 at 16:38 +0200, Robert Schetterer wrote: > Timo Sirainen schrieb: > > On Sat, 2008-07-12 at 16:12 +0200, Robert Schetterer wrote: > I think existing quotas in sql could be used > if dovecot would ignore that no > maildir storage is used and simply > interprete

Re: [Dovecot] dbox and quota question

2008-07-12 Thread Robert Schetterer
Timo Sirainen schrieb: On Sat, 2008-07-12 at 16:12 +0200, Robert Schetterer wrote: 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

Re: [Dovecot] dbox and quota question

2008-07-12 Thread Timo Sirainen
On Sat, 2008-07-12 at 16:12 +0200, Robert Schetterer wrote: > >> 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 > >> (

Re: [Dovecot] dbox and quota question

2008-07-12 Thread Robert Schetterer
Timo Sirainen schrieb: On Sat, 2008-07-12 at 14:10 +0200, Robert Schetterer wrote: 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 uncle

Re: [Dovecot] dbox and quota question

2008-07-12 Thread Timo Sirainen
On Sat, 2008-07-12 at 14:10 +0200, Robert Schetterer wrote: > >> 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 uncl

Re: [Dovecot] dbox and quota question

2008-07-12 Thread Robert Schetterer
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,

Re: [Dovecot] dbox and quota question

2008-07-12 Thread Timo Sirainen
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