Re: [Dovecot] problem mysql and dovecot 1.2

2010-07-22 Thread Timo Sirainen
On 22.7.2010, at 22.20, mickael wrote: > I add this line in dovecot-sql.conf > user_query = SELECT concat('*:storage=', quota_kb, 'K') AS quota_rule FROM > virtual_users WHERE email = '%u' .. > I spent the quota value has 20K in mysql voluntarily on behalf > 'b...@domain.com' . But unfortunately

Re: [Dovecot] problem mysql and dovecot 1.2

2010-07-22 Thread mickael
Timo Sirainen wrote: On Thu, 2010-07-22 at 17:19 +0200, deb...@robertain.com wrote: On Thu, 22 Jul 2010 16:51:03 +0200, Simone Caruso wrote: yet but the quotas work through this option: > quota_rule: *:storage=100M > The problem is that quotas are not personalized. try usi

Re: [Dovecot] problem mysql and dovecot 1.2

2010-07-22 Thread Timo Sirainen
On Thu, 2010-07-22 at 17:19 +0200, deb...@robertain.com wrote: > On Thu, 22 Jul 2010 16:51:03 +0200, Simone Caruso > wrote: > >> yet but the quotas work through this option: > > > quota_rule: *:storage=100M > > > The problem is that quotas are not personalized. > > > > try using 'quota_rule2' i

Re: [Dovecot] problem mysql and dovecot 1.2

2010-07-22 Thread debian
On Thu, 22 Jul 2010 16:51:03 +0200, Simone Caruso wrote: >> yet but the quotas work through this option: > > quota_rule: *:storage=100M > > The problem is that quotas are not personalized. > > try using 'quota_rule2' in dovecot.conf and 'quota_rule' in user_query. the problem using the quotas_r

Re: [Dovecot] problem mysql and dovecot 1.2

2010-07-22 Thread Simone Caruso
> yet but the quotas work through this option: > quota_rule: *:storage=100M > The problem is that quotas are not personalized. try using 'quota_rule2' in dovecot.conf and 'quota_rule' in user_query. ps (i dont use cast in sql query) -- Simone Caruso IT Consultant

[Dovecot] problem mysql and dovecot 1.2

2010-07-22 Thread debian
Hi everybody , Since my version 1.2. I have a problem with the management of quotas. select * from virtual_users; ++---+--+---+--++ | id | domain_id | password | email