Re: [Dovecot] Quota BUG - fixed

2011-11-10 Thread Adrian Minta
After some deep investigations I manage to solve the problem. I was only reading quota in user_querry. Now I read it in user_querry and in password_query and all seems fine: --dovecot-sql.conf--- user_query = SELECT '/home/%d/%n' as home, 'maildir:/home/%d/%n' as mail, 150 AS uid, 8 AS gid, C

Re: [Dovecot] Quota BUG ?

2011-11-09 Thread Adrian Minta
On 11/09/11 20:46, Timo Sirainen wrote: On Wed, 2011-11-09 at 20:44 +0200, Adrian Minta wrote: Is the quota in the database 1096 or>2GB? i.e. is the problem with reading it, or updating it? In general the quota code uses 64bit integers everywhere so this shouldn't be happening. In the databas

Re: [Dovecot] Quota BUG ?

2011-11-09 Thread Timo Sirainen
On Wed, 2011-11-09 at 20:44 +0200, Adrian Minta wrote: > > Is the quota in the database 1096 or>2GB? i.e. is the problem with > > reading it, or updating it? In general the quota code uses 64bit > > integers everywhere so this shouldn't be happening. > > > > > In the database quota field is 2048000

Re: [Dovecot] Quota BUG ?

2011-11-09 Thread Adrian Minta
Is the quota in the database 1096 or>2GB? i.e. is the problem with reading it, or updating it? In general the quota code uses 64bit integers everywhere so this shouldn't be happening. In the database quota field is 204800. -- Best regards, Adrian MintaMA3173-RIPE, www.minta.ro

Re: [Dovecot] Quota BUG ?

2011-11-09 Thread Timo Sirainen
On Wed, 2011-11-09 at 20:35 +0200, Adrian Minta wrote: > On 11/09/11 19:59, Timo Sirainen wrote: > > Anyway, here's a guess: the quota is stored in mysql in "integer", which > > has a maximum value of 2 GB. Actually looks like Dovecot wiki pages also > > use "integer". Replace that with "bigint" an

Re: [Dovecot] Quota BUG ?

2011-11-09 Thread Adrian Minta
On 11/09/11 19:59, Timo Sirainen wrote: Anyway, here's a guess: the quota is stored in mysql in "integer", which has a maximum value of 2 GB. Actually looks like Dovecot wiki pages also use "integer". Replace that with "bigint" and recalculate quota and it should work. Actually the mysql part i

Re: [Dovecot] Quota BUG ?

2011-11-09 Thread Timo Sirainen
On Wed, 2011-11-09 at 14:59 +0200, Adrian M wrote: > Hello list, > I believe I found a bug with quota. > The dovecot quota replies with incorrect values when the mailbox is above 2GB. > > du -ks returns 2005764bytes > > dovecot IMAP on the same user/directory: > 1 getquotaroot inbox > * QUOTAROOT

[Dovecot] Quota BUG ?

2011-11-09 Thread Adrian M
Hello list, I believe I found a bug with quota. The dovecot quota replies with incorrect values when the mailbox is above 2GB. du -ks returns 2005764bytes dovecot IMAP on the same user/directory: 1 getquotaroot inbox * QUOTAROOT "INBOX" "user" * QUOTA "user" (STORAGE 1096 200)* QUOTAROOT "INB

Re: [Dovecot] quota bug

2009-08-24 Thread Timo Sirainen
On Wed, 2009-08-19 at 09:25 +0300, Amr Shahin wrote: > Hello > i use dovecot for our mail server, it's installed on about 8 servers and > it's doing really good, thanks for the great effort :-) > however, i have been facing a quota problem recently, dovecot says that some > users are using for exam

Re: [Dovecot] quota bug

2009-08-18 Thread Wouter van der Schagt
i use dovecot for our mail server, it's installed on about 8 servers and it's doing really good, thanks for the great effort :-) however, i have been facing a quota problem recently, dovecot says that some users are using for example (700MB) while they are actually using (10MB), i solve this by

[Dovecot] quota bug

2009-08-18 Thread Amr Shahin
Hello i use dovecot for our mail server, it's installed on about 8 servers and it's doing really good, thanks for the great effort :-) however, i have been facing a quota problem recently, dovecot says that some users are using for example (700MB) while they are actually using (10MB), i solve this

Re: [Dovecot] quota bug

2009-07-21 Thread Amr Shahin
oh, my bad the user has unlimited quota that's why the response is different from what im used to get ( but it still complies to the RFC ) thanks for the help On Mon, Jul 20, 2009 at 9:33 AM, Amr Shahin wrote: > Hello, > please find this log from dovecot server > * OK Dovecot ready. > 1 login a

Re: [Dovecot] quota bug

2009-07-19 Thread Noel Butler
On Mon, 2009-07-20 at 09:33 +0300, Amr Shahin wrote: > Hello, > please find this log from dovecot server > * OK Dovecot ready. > 1 login amrtest3 * > 1 OK Logged in. > 1 getquotaroot inbox > * QUOTAROOT "inbox" > 1 OK Getquotaroot completed. > 1 logout > * BYE Logging out > 1 OK Logout com

[Dovecot] quota bug

2009-07-19 Thread Amr Shahin
Hello, please find this log from dovecot server * OK Dovecot ready. 1 login amrtest3 * 1 OK Logged in. 1 getquotaroot inbox * QUOTAROOT "inbox" 1 OK Getquotaroot completed. 1 logout * BYE Logging out 1 OK Logout completed. the user has unlimited quota, the back end authentication is mysql

Re: [Dovecot] Quota bug in deliver?

2007-09-06 Thread Doug Council
On Thu, 6 Sep 2007, Marcin Michal Jessa wrote: I do use prefetch, I have an separate query, too. Without that the quota fails completely. Having both statements and prefetch, the quota works fine with IMAP and deliver when I have no quota line in the plugin section, when I add the line (see !!MA

Re: [Dovecot] Quota bug in deliver?

2007-09-05 Thread Marcin Michal Jessa
FORMER 03 | Baltasar Cevc wrote: > Hi, > > On 05.09.2007, at 22:19, WJCarpenter wrote: > >> bc> When I put a standard quota into the config as follows, the >> bc> delivery succeeds (apparently deliver checks the standard quota, >> bc> while IMAP correctly checks the quota from the database if it is

Re: [Dovecot] Quota bug in deliver?

2007-09-05 Thread FORMER 03 | Baltasar Cevc
Hi, On 05.09.2007, at 22:19, WJCarpenter wrote: bc> When I put a standard quota into the config as follows, the bc> delivery succeeds (apparently deliver checks the standard quota, bc> while IMAP correctly checks the quota from the database if it is bc> returned. Sep 5 21:46:11 ms4 bc> The ma

Re: [Dovecot] Quota bug in deliver?

2007-09-05 Thread WJCarpenter
bc> When I put a standard quota into the config as follows, the bc> delivery succeeds (apparently deliver checks the standard quota, bc> while IMAP correctly checks the quota from the database if it is bc> returned. Sep 5 21:46:11 ms4 bc> The mailbox is still over quota here, but deliver does not

[Dovecot] Quota bug in deliver?

2007-09-05 Thread FORMER 03 | Baltasar Cevc
Hi, I may be wrong, but I suspect a bug in dovecot deliver when using quotas. I've put some mails into a mailbox and then reduced the quota, to have the mailbox be over quota - here's the quota informaiton: [...] 2 getquotaroot INBOX * QUOTAROOT "INBOX" "" * QUOTA "" (STORAGE 880 5) 2 OK G