2013/4/15 Timo Sirainen
>
> 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 variables
On 13.4.2013, at 15.52, Antoine Nguyen 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
>
> Currenlty, current quo
Up.
Any idea about this? Does anybody ever try to build such a configuration?
Thanks.
2013/4/13 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 infor
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
per-
On 26.2.2013, at 18.40, Alessio Cecchi 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 about 2.
Il 22/02/2013 12:52, Timo Sirainen ha scritto:
On 12.2.2013, at 12.34, Alessio Cecchi 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 da
On 12.2.2013, at 12.34, Alessio Cecchi 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
> number of mes
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
v
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
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
Papp Tamas 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 the exact a
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 us
Papp Tamas 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 meta
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
Papp Tamas 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
>> he deletes al
On 04/20/2011 05:26 PM, Sven Hartge wrote:
Papp Tamas 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 n
Papp Tamas 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
>> the director
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 wit
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 no
Papp Tamas 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. With Maildir
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
-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
getquotaro
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 migrat
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
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 site
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
Her
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 v
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
imap_max_li
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
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 trea
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
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 h
32 matches
Mail list logo