Re: [Dovecot] domain quota in sql

2012-02-15 Thread Adam Szpakowski
On 15.02.2012 14:05, Timo Sirainen wrote: Is there a way to add domainname as another collumn in dbase? This will simplify the SQL query and the GROUP BY could be used. Not currently. Perhaps for v2.2 dict-sql redesign. It will be great feature. Well, yeah, it kind of works, but not 100% :) An

Re: [Dovecot] domain quota in sql

2012-02-15 Thread Timo Sirainen
On Wed, 2012-02-15 at 08:26 +0100, Adam Szpakowski wrote: > On 15.02.2012 02:55, Timo Sirainen wrote: > > On 15.2.2012, at 3.54, Timo Sirainen wrote: > > > >> Domain-quota support in Dovecot is only partial. Recalculating domain > >> quota would require more code. Last time when someone asked abou

Re: [Dovecot] domain quota in sql

2012-02-15 Thread Przemysław Orzechowski
Hi Im not an expert in Dovecot but what prohibits you adding a field to the table Dovecot will not use it thats all Im not sure what version of database You are using but postgres,oracle and never versions of mysql have something called views (could be used to hide the additional column from do

Re: [Dovecot] domain quota in sql

2012-02-15 Thread Adam Szpakowski
On 15.02.2012 09:19, Robert Schetterer wrote: as workaround it should be possible to calculate filllevel by domain with some bash script and cron sending an info mail to you might be not exact, but enough to see whats going on ( depends on your real domain/mailbox setup...maildir etc) [cut] I'm

Re: [Dovecot] domain quota in sql

2012-02-15 Thread Robert Schetterer
Am 15.02.2012 09:07, schrieb Adam Szpakowski: > On 15.02.2012 08:47, Robert Schetterer wrote: >> Hi i am not sure what are trying to goal >> with domain quota, if you setup your accounts i.e with postfixadmin etc >> then its up to the gui logic , stopping postmasters to setup more >> accounts ( wit

Re: [Dovecot] domain quota in sql

2012-02-15 Thread Adam Szpakowski
On 15.02.2012 08:47, Robert Schetterer wrote: Hi i am not sure what are trying to goal with domain quota, if you setup your accounts i.e with postfixadmin etc then its up to the gui logic , stopping postmasters to setup more accounts ( with quotas ) as you ( the superadmin ) want. My fault, I sh

Re: [Dovecot] domain quota in sql

2012-02-14 Thread Robert Schetterer
Am 15.02.2012 08:26, schrieb Adam Szpakowski: > On 15.02.2012 02:55, Timo Sirainen wrote: >> On 15.2.2012, at 3.54, Timo Sirainen wrote: >> >>> Domain-quota support in Dovecot is only partial. Recalculating domain >>> quota would require more code. Last time when someone asked about >>> this I wasn

Re: [Dovecot] domain quota in sql

2012-02-14 Thread Adam Szpakowski
On 15.02.2012 02:55, Timo Sirainen wrote: On 15.2.2012, at 3.54, Timo Sirainen wrote: Domain-quota support in Dovecot is only partial. Recalculating domain quota would require more code. Last time when someone asked about this I wasn't even sure how it could be implemented, but nowadays it ac

Re: [Dovecot] domain quota in sql

2012-02-14 Thread Timo Sirainen
On 15.2.2012, at 3.54, Timo Sirainen wrote: > Domain-quota support in Dovecot is only partial. Recalculating domain quota > would require more code. Last time when someone asked about this I wasn't > even sure how it could be implemented, but nowadays it actually would be > possible to do with:

Re: [Dovecot] domain quota in sql

2012-02-14 Thread Timo Sirainen
On 14.2.2012, at 23.29, Adam Szpakowski wrote: > Hi, > I have a problem with setting up quota usage tracking for domains. > Problem is, that domain quota is always based on only one user in domain, the > last one on whom behalf any operation was performed. > To recreate this situation, one has on