Re: [Dovecot] Dict quota question

2013-04-15 Thread Antoine Nguyen
Up. Any idea about this? Does anybody ever try to build such a configuration? Thanks. 2013/4/13 Antoine Nguyen ngu.anto...@gmail.com Hi all, I'm using Dovecot 2.1.16 and I'd like to know if the following configuration is supported: * An SQL dictionary quota * A static userdb to get

Re: [Dovecot] Dict quota question

2013-04-15 Thread Timo Sirainen
On 13.4.2013, at 15.52, Antoine Nguyen ngu.anto...@gmail.com wrote: I'm using Dovecot 2.1.16 and I'd like to know if the following configuration is supported: * An SQL dictionary quota * A static userdb to get uid/gid/home information * An SQL userdb to get per-user quota limit

Re: [Dovecot] Dict quota question

2013-04-15 Thread Antoine Nguyen
2013/4/15 Timo Sirainen t...@iki.fi You can't have both static userdb and sql userdb. Create just one sql userdb, which returns something like: select quota_rule, 123 uid, 123 as gid, '/home/%u' as home from quota_limits where username = '%u' Ok. I didn't know it was possible to use

[Dovecot] Dict quota question

2013-04-13 Thread Antoine Nguyen
Hi all, I'm using Dovecot 2.1.16 and I'd like to know if the following configuration is supported: * An SQL dictionary quota * A static userdb to get uid/gid/home information * An SQL userdb to get per-user quota limit Currenlty, current quota usage are properly stored into the database but

Re: [Dovecot] Dict quota timeout error: Has anything changed in the latest versions?

2013-02-26 Thread Alessio Cecchi
Il 22/02/2013 12:52, Timo Sirainen ha scritto: On 12.2.2013, at 12.34, Alessio Cecchi ales...@skye.it wrote: Since dovecot 2.1.10-13 (but perhaps even before) when a new user log in via POP/IMAP or receive an email for the first time dovecot created the entry for the users in the table quota

Re: [Dovecot] Dict quota timeout error: Has anything changed in the latest versions?

2013-02-26 Thread Timo Sirainen
On 26.2.2013, at 18.40, Alessio Cecchi ales...@skye.it wrote: I don't see any recent changes in this code, so I think it has been broken for a long time. Anyway, this fixes it: http://hg.dovecot.org/dovecot-2.1/rev/225c64ed0439 Thanks Timo, I don't know if you read my email on ML

Re: [Dovecot] Dict quota timeout error: Has anything changed in the latest versions?

2013-02-22 Thread Timo Sirainen
On 12.2.2013, at 12.34, Alessio Cecchi ales...@skye.it wrote: Since dovecot 2.1.10-13 (but perhaps even before) when a new user log in via POP/IMAP or receive an email for the first time dovecot created the entry for the users in the table quota of dovecot database with quota usage and

Re: [Dovecot] Dict quota timeout error: Has anything changed in the latest versions?

2013-02-15 Thread Alessio Cecchi
Il 12/02/2013 11:34, Alessio Cecchi ha scritto: Hi, I'm using dict quota with mysql for track them via SQL query instead of read maildirsize file. Primary quota and enforcing is provided via userdb and is maildir type. Since dovecot 2.1.10-13 (but perhaps even before) when a new user log in

[Dovecot] Dict quota timeout error: Has anything changed in the latest versions?

2013-02-12 Thread Alessio Cecchi
Hi, I'm using dict quota with mysql for track them via SQL query instead of read maildirsize file. Primary quota and enforcing is provided via userdb and is maildir type. Since dovecot 2.1.10-13 (but perhaps even before) when a new user log in via POP/IMAP or receive an email for the first

Re: [Dovecot] dict quota problem

2011-05-01 Thread Papp Tamas
On 04/30/2011 10:21 PM, Sven Hartge wrote: Yes. You as admin have to deal with this. Buy a bigger disk, reduce the quota, etc. Or use a filesystem quota, which will (of course) only work with real users and not with virtual users. OK, thank you. Well, virtual users are needed:) tamas

Re: [Dovecot] dict quota problem

2011-04-30 Thread Papp Tamas
On 04/30/2011 01:36 AM, Sven Hartge wrote: So, there is no exact or something closer solution with normal maildirs? Define exact. I mean, how I can set a true quota usage for a user? Trust me, you don't want to include any meta data or filesystem overhead in the quota value presented to

Re: [Dovecot] dict quota problem

2011-04-30 Thread Sven Hartge
Papp Tamas tom...@martos.bme.hu wrote: On 04/30/2011 01:36 AM, Sven Hartge wrote: So, there is no exact or something closer solution with normal maildirs? Define exact. I mean, how I can set a true quota usage for a user? Define true quota usage. Trust me, you don't want to include any

Re: [Dovecot] dict quota problem

2011-04-30 Thread Papp Tamas
On 04/30/2011 02:24 PM, Sven Hartge wrote: I mean, how I can set a true quota usage for a user? Define true quota usage. Maximum usable space for a user on the disk. The current implementation just works. Where is your problem with that? You get the exact amount of bytes all mails of a

Re: [Dovecot] dict quota problem

2011-04-30 Thread Sven Hartge
Papp Tamas tom...@martos.bme.hu wrote: On 04/30/2011 02:24 PM, Sven Hartge wrote: I mean, how I can set a true quota usage for a user? Define true quota usage. Maximum usable space for a user on the disk. The current implementation just works. Where is your problem with that? You get

Re: [Dovecot] dict quota problem

2011-04-29 Thread Papp Tamas
On 04/20/2011 05:26 PM, Sven Hartge wrote: Papp Tamastom...@martos.bme.hu wrote: On 04/20/2011 01:47 PM, Sven Hartge wrote: du also accounts for the metadata of the filesystem. With Maildir++ you have many files per directory which causes the directory inode to increase in size. After mails

Re: [Dovecot] dict quota problem

2011-04-29 Thread Sven Hartge
Papp Tamas tom...@martos.bme.hu wrote: On 04/20/2011 05:26 PM, Sven Hartge wrote: Counting all meta-data is also very unintuitive for the user. Imagine a user with an INBOX containing 200,000 mails. This will result in a _huge_ directory inode for the INBOX folder (about 20MB for XFS). Now

[Dovecot] dict quota problem

2011-04-20 Thread Papp Tamas
hi! In table I see this: | papp.ta...@center.hu | 118671994 |20437 | du -sm says, the size of the maildir is 154M. I use xfs. I can't figure out, why is there a difference. Can you help me out? Thank you, tamas

Re: [Dovecot] dict quota problem

2011-04-20 Thread Sven Hartge
Papp Tamas tom...@martos.bme.hu wrote: In table I see this: | papp.ta...@center.hu | 118671994 |20437 | du -sm says, the size of the maildir is 154M. I use xfs. I can't figure out, why is there a difference. Can you help me out? du also accounts for the metadata of the filesystem.

Re: [Dovecot] dict quota problem

2011-04-20 Thread Papp Tamas
On 04/20/2011 01:47 PM, Sven Hartge wrote: du also accounts for the metadata of the filesystem. With Maildir++ you have many files per directory which causes the directory inode to increase in size. After mails are deleted, the now empty space inside the directory is not reclaimed (at least not

Re: [Dovecot] dict quota problem

2011-04-20 Thread Timo Sirainen
On Wed, 2011-04-20 at 16:43 +0200, Papp Tamas wrote: Why does dovecot count only the raw size? Does this mean, dict quota is not usable with maildirs? Is this true for sdbox also? Dovecot quota counts only message sizes, not including index files and other metadata. It works the same way with

Re: [Dovecot] dict quota problem

2011-04-20 Thread Sven Hartge
Papp Tamas tom...@martos.bme.hu wrote: On 04/20/2011 01:47 PM, Sven Hartge wrote: du also accounts for the metadata of the filesystem. With Maildir++ you have many files per directory which causes the directory inode to increase in size. After mails are deleted, the now empty space inside

[Dovecot] dict quota and quota recalculation

2010-04-13 Thread Alex
Hi I am trying to migrate my courier server to dovecot and I've run into some problems. One of the motive that I chose to migrate is quota reporting mechanism which in courier is a pain (if you need to display an accurate quota usage in the control panel). So I follow the instructions on

Re: [Dovecot] dict quota and quota recalculation

2010-04-13 Thread Steffen Kaiser
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Tue, 13 Apr 2010, Alex wrote: So basically if I execute the script as root the maildir is root the uid/gid is root I search and I found a trick for home : HOME=/home/sites/domain.net/mail/test/Maildir/; user=t...@domain.net; echo 1

Re: [Dovecot] dict quota

2009-02-20 Thread Timo Sirainen
On Thu, 2009-02-19 at 09:18 +0100, Osvaldo Alvarez Pozo wrote: Hi Actually I use quota. But I would like to use dict quota car with dict quota it is possible to view the used quota. But I do not understand the configuration off dict quota. if the quota is stored in mysql wich do I have to

[Dovecot] dict quota

2009-02-19 Thread Osvaldo Alvarez Pozo
Hi Actually I use quota. But I would like to use dict quota car with dict quota it is possible to view the used quota. But I do not understand the configuration off dict quota. if the quota is stored in mysql wich do I have to specify quota values in plugin section as chown in the dovecot web

Re: [Dovecot] dict, quota, mysql and postfixadmin

2009-02-03 Thread Timo Sirainen
On Feb 3, 2009, at 5:09 AM, Johan Hendriks wrote: plugin { quota = dict:::proxy::quotadict Here you set quota backend. quota_rule = *:storage=50M:messages=1 Here you set quota limits. CONCAT('dict:storage=',floor(quota/1000),' proxy::quotadict') as quota Here you're trying to use

Re: [Dovecot] dict, quota, mysql and postfixadmin

2009-02-03 Thread Johan Hendriks
Timo Sirainen schreef: On Feb 3, 2009, at 5:09 AM, Johan Hendriks wrote: plugin { quota = dict:::proxy::quotadict Here you set quota backend. quota_rule = *:storage=50M:messages=1 Here you set quota limits. CONCAT('dict:storage=',floor(quota/1000),' proxy::quotadict') as quota

[Dovecot] dict, quota, mysql and postfixadmin

2009-02-03 Thread Johan Hendriks
Hello all I am trying to get quota working with dict and mysql but i get an error. This is my dovecot.conf file ( relevant part ) i hope ;-) ## protocol imap { listen = *:143 imap_client_workarounds = delay-newmail outlook-idle netscape-eoh tb-extra-mailbox-sep

Re: [Dovecot] Dict quota negative values in MySql table?

2009-01-25 Thread mich...@lattari.pl
I have it :-) The values are negative because they are relative to the messages count and the used storage at the timepoint of Quota Plugin initialization. If I would have had x messages in my INBOX before quota initialization, then I would have started the Quota Plugin and I would have deleted

Re: [Dovecot] Dict quota negative values in MySql table?

2009-01-25 Thread Timo Sirainen
On Sat, 2009-01-24 at 13:00 +0100, mich...@lattari.pl wrote: Hi! I have a question about the dictionary quota :storage and :messages values in MySql quota table. How to interpret the following values? Why some values are negative? Are the values relative to something? You should treat

Re: [Dovecot] Dict quota negative values in MySql table?

2009-01-25 Thread mich...@lattari.pl
Thank you for the exhaustive explanation! Now I understand it and the quota is EXACT when I verify it running USER=wanted_user dovecot --exec-mail imap 1 GETQUOTAROOT INBOX as you suggested somewhere else in the mailing list Best regards michael lattari

[Dovecot] Dict quota negative values in MySql table?

2009-01-24 Thread mich...@lattari.pl
Hi! I have a question about the dictionary quota :storage and :messages values in MySql quota table. How to interpret the following values? Why some values are negative? Are the values relative to something? I would like to write a simple php application to check the user quota but I don't know