Christian Rößner wrote:
is it possible to ask Dovecot for a users quota by talking to the Dovecot
server over TCP? I know about doveadm quota -u user, but I would like to
know, if I can query for that over a network connection (on the Postfix ML
they suggested writing a policy service that
Hi
perl: IMAP::Admin-get_quotaroot
php: imap_get_quota
ruby: Net::IMAP::MailboxQuota
python-imaplib in my case ;)
If connecting from the policy service, can I use Dovecot master password to get
quota over IMAP?
Thanks again
Christian
Regards
Daniel
--
On 4.11.2012, at 22.34, Christian Rößner wrote:
is it possible to ask Dovecot for a users quota by talking to the Dovecot
server over TCP? I know about doveadm quota -u user, but I would like to
know, if I can query for that over a network connection (on the Postfix ML
they suggested
Christian Rößner wrote:
perl: IMAP::Admin-get_quotaroot
php: imap_get_quota
ruby: Net::IMAP::MailboxQuota
python-imaplib in my case ;)
If connecting from the policy service, can I use Dovecot master password to
get quota over IMAP?
Yes, I think a master user login should work as if
On 19.10.2012, at 10.40, tmihalicek wrote:
I have a strange errors in .err log file, but the postgres seem to be filling
with quota changes, i will also put configs in
Oct 19 09:23:52 mailstore-node-01 dovecot: imap(t...@example.net): Error:
read(/var/run/dovecot/dict) failed: Timeout
.nabble.com/Dovecot-quota-postgres-dictionary-problems-tp38234.html
Sent from the Dovecot mailing list archive at Nabble.com.
Hello,
I use dovecot 1.2 version with postfix virtual users and mysql. All
information about quota for every user is in mysql table.
How dovecot compare if quota in database is over quota in
/var/vmail/exampleuser directory ?
It uses something like du command ?
regards,
Wamp
@dovecot.org
Subject: [Dovecot] Quota - usage counting.
Hello,
I use dovecot 1.2 version with postfix virtual users and mysql. All
information about quota for every user is in mysql table.
How dovecot compare if quota in database is over quota in
/var/vmail/exampleuser directory ?
It uses something like
can't make it working - so need information about general idea how this
values should be compared. Where is info about actual size of maildir.
regards,
Thank you!
- Original Message -
From: w...@promax.media.pl
To: dovecot@dovecot.org
Subject: [Dovecot] Quota - usage counting
On 7.9.2012, at 13.43, Héctor Moreno Blanco wrote:
Currently we have dovecot 2.0.10 with Maildir as mailbox system. We want to
migrate to mdbox.
The migration is simple and easy, but there are some configuration settings
we cannot set to work properly.
In our dovecot with Maildir we
Good morning everyone,
I have a little doubt about setting a quotaless mailbox with mdbox.
Currently we have dovecot 2.0.10 with Maildir as mailbox system. We want to
migrate to mdbox.
The migration is simple and easy, but there are some configuration settings we
cannot set to work properly.
On 2012-09-07 6:43 AM, Héctor Moreno Blanco hmor...@gmv.com wrote:
Currently we have dovecot 2.0.10 with Maildir as mailbox system. We want to
migrate to mdbox.
If you're going to migrate to mdbox, you'd be much better off if you
upgraded to the latest 2.1.x...
Mdbox is much better
El 25/08/12 09:23, Timo Sirainen escribió:
On 25.8.2012, at 1.49, Sven Hartge wrote:
How about just disabling the quota enforcing and doing a nightly run
of some type of enforcing (sending notification email and/or disabling
new mail delivery until user has more quota again)?
As a last
Angel L. Mateo ama...@um.es wrote:
El 25/08/12 09:23, Timo Sirainen escribió:
On 25.8.2012, at 1.49, Sven Hartge wrote:
How about just disabling the quota enforcing and doing a nightly run
of some type of enforcing (sending notification email and/or disabling
new mail delivery until user has
On 25.8.2012, at 1.49, Sven Hartge wrote:
How about just disabling the quota enforcing and doing a nightly run
of some type of enforcing (sending notification email and/or disabling
new mail delivery until user has more quota again)?
As a last resort, yes. If possible, I'd like to keep the
Timo Sirainen t...@iki.fi wrote:
On 25.8.2012, at 1.49, Sven Hartge wrote:
How about just disabling the quota enforcing and doing a nightly run
of some type of enforcing (sending notification email and/or
disabling new mail delivery until user has more quota again)?
As a last resort, yes.
Hi!
I am currently in the process of preparing a migration of our old
Courier-based IMAP/POP server setup to a Dovecot-based one.
During this process I came across the following problem with the
difference Courier and Dovecot handle deleted messages and mail quota.
Quote from
On 24.8.2012, at 15.02, Sven Hartge wrote:
Ignoring the content (or increasing the quota) of the Trash folder is
easy and no problem, but ignoring deleted messages seems impossible
without changes to the code.
..
So I propose an additional flag for the quota_rule config option to be
able to
Timo Sirainen t...@iki.fi wrote:
On 24.8.2012, at 15.02, Sven Hartge wrote:
Ignoring the content (or increasing the quota) of the Trash folder is
easy and no problem, but ignoring deleted messages seems impossible
without changes to the code.
..
So I propose an additional flag for the
Am 24.08.2012 15:13, schrieb Sven Hartge:
Timo Sirainen t...@iki.fi wrote:
On 24.8.2012, at 15.02, Sven Hartge wrote:
Ignoring the content (or increasing the quota) of the Trash folder is
easy and no problem, but ignoring deleted messages seems impossible
without changes to the code.
..
Robert Schetterer rob...@schetterer.org wrote:
Am 24.08.2012 15:13, schrieb Sven Hartge:
Timo Sirainen t...@iki.fi wrote:
On 24.8.2012, at 15.02, Sven Hartge wrote:
Ignoring the content (or increasing the quota) of the Trash folder is
easy and no problem, but ignoring deleted messages seems
Sven Hartge s...@svenhartge.de wrote:
Robert Schetterer rob...@schetterer.org wrote:
Am 24.08.2012 15:13, schrieb Sven Hartge:
Is is possible to forcibly expunge a message at once, directly after
a client has marked it as deleted? Kind of the opposite of the
lazy_expunge plugin?
hm perhaps
On 24.8.2012, at 16.13, Sven Hartge wrote:
quota_rule = *:storage=1G:ignoredeleted
quota_rule2 = Trash:storage=+100M
This can't be implemented race-condition-free without huge changes to code.
Damn, too bad.
I know for sure either my users or my 1st level support team are going
to
Timo Sirainen t...@iki.fi wrote:
On 24.8.2012, at 16.13, Sven Hartge wrote:
quota_rule = *:storage=1G:ignoredeleted
quota_rule2 = Trash:storage=+100M
This can't be implemented race-condition-free without huge changes to code.
Damn, too bad.
I know for sure either my users or my 1st
Hi ALL:
my SQL:
user_query=select concat('*bytes=',trim(TRAILING 'S' FROM quota)) as
quota_rule,concat('/home/data/domains/',maildir) as mail ,conca
t('/home/data/domains/',homedir) as home,uidnumber as uid,gidnumber as gid from
mailbox where username='%u'
password_query= select username as user
On 2012-07-27 16:31, fy wrote:
my SQL:
user_query=select concat('*bytes=',trim(TRAILING 'S' FROM quota)) as
I think that should be '*:bytes=', not '*bytes=' (you're missing a
colon).
--
Med vennlig hilsen
Bård Johannessen
On Sun, 2012-07-08 at 09:42 +0200, Jan Friesse wrote:
Hi,
included is patch which adds support for calculating fs quota from hardlimit
where softlimit is unset. I'm usually not setting softlimit on my server
causing dovecot work incorrectly (not reporting quota at all).
Committed to v2.2:
Hi,
included is patch which adds support for calculating fs quota from hardlimit
where softlimit is unset. I'm usually not setting softlimit on my server
causing dovecot work incorrectly (not reporting quota at all).
Regards,
Jan Friesse
dovecot-0001-Support-for-fs-hard-limit.patch
I think i have quota setup correctly, but finally time arrived to check
that ;)
opensuse:/etc/dovecot # doveadm quota get -u luuk
Quota name Type Value Limit %
User quota STORAGE 571973 716800 79
User quota MESSAGE 4 - 0
It seems i am at 79% of my quota
so, i added a line to
On 12-05-2012 10:50, Luuk@dovecot wrote:
I think i have quota setup correctly, but finally time arrived to check
that ;)
...
But this message is never send, what am i missing (in my config)?
dovecot -n:
# 2.0.16: /etc/dovecot/dovecot.conf
# OS: Linux 3.1.10-1.9-desktop x86_64 openSUSE
On Saturday, May 12, 2012 at 12:37:25 UTC, dove...@vosslamber.nl confabulated:
On 12-05-2012 10:50, Luuk@dovecot wrote:
I think i have quota setup correctly, but finally time arrived to check
that ;)
...
But this message is never send, what am i missing (in my config)?
dovecot -n:
#
On 05/12/2012 04:50 AM, Luuk@dovecot wrote:
It seems i am at 79% of my quota
so, i added a line to conf.d/90-quota.conf, to get a wraning when quota
exceeds 10%:
Quota warnings are only sent when you _cross_ the limit, they are not
sent (again) when you are already over the limit.
So, in your
the suggestion form 'Duane Hill' and delete the path
before the quota-warning.sh. I hope he did mean that when he was
referring to the docs ;)
In the log, the following message showed:
2012-05-12 17:11:43 imap(luuk): Error: quota:
net_connect_unix(/var/run/dovecot/quota-warning.sh) failed
:
net_connect_unix(/var/run/dovecot/quota-warning.sh) failed: No such file
or directory
I think i have to revert the changes, and retest. ;)
2012-05-12 17:50:22 imap(luuk): Error: quota:
net_connect_unix(/usr/local/bin/quota-warning.sh) failed: Permission
denied (euid=1000(luuk) egid=100(users) missing
On 5/12/2012 11:42 AM, Luuk@dovecot wrote:
In the log, the following message showed:
2012-05-12 17:11:43 imap(luuk): Error: quota:
net_connect_unix(/var/run/dovecot/quota-warning.sh) failed: No such file
or directory
I think i have to revert the changes, and retest.;)
Wiki says
On 5/12/2012 11:59 AM, Luuk@dovecot wrote:
2012-05-12 17:50:22 imap(luuk): Error: quota:
net_connect_unix(/usr/local/bin/quota-warning.sh) failed: Permission
denied (euid=1000(luuk) egid=100(users) missing +w perm:
/usr/local/bin/quota-warning.sh, dir owned by 0:0 mode=0755)
This is
On 12-05-2012 18:02, Gedalya wrote:
On 5/12/2012 11:59 AM, Luuk@dovecot wrote:
2012-05-12 17:50:22 imap(luuk): Error: quota:
net_connect_unix(/usr/local/bin/quota-warning.sh) failed: Permission
denied (euid=1000(luuk) egid=100(users) missing +w perm:
/usr/local/bin/quota-warning.sh, dir owned
On 12-05-2012 18:00, Gedalya wrote:
On 5/12/2012 11:42 AM, Luuk@dovecot wrote:
In the log, the following message showed:
2012-05-12 17:11:43 imap(luuk): Error: quota:
net_connect_unix(/var/run/dovecot/quota-warning.sh) failed: No such file
or directory
I think i have to revert the changes
On 5/12/2012 12:21 PM, Luuk@dovecot wrote:
On 12-05-2012 18:00, Gedalya wrote:
On 5/12/2012 11:42 AM, Luuk@dovecot wrote:
In the log, the following message showed:
2012-05-12 17:11:43 imap(luuk): Error: quota:
net_connect_unix(/var/run/dovecot/quota-warning.sh) failed: No such file
On 12-05-2012 18:40, Gedalya wrote:
On 5/12/2012 12:21 PM, Luuk@dovecot wrote:
On 12-05-2012 18:00, Gedalya wrote:
On 5/12/2012 11:42 AM, Luuk@dovecot wrote:
In the log, the following message showed:
2012-05-12 17:11:43 imap(luuk): Error: quota:
net_connect_unix(/var/run/dovecot/quota
:
net_connect_unix(/var/run/dovecot/quota-warning.sh) failed: No such
file
or directory
I think i have to revert the changes, and retest.;)
Wiki says: quota_warning =limit configuration quota-warning socket
name parameters
You define a listening socket in the unix_listener line in the service
On 12-05-2012 19:48, Gedalya wrote:
I understand you sent an email to yourself?
If you gained one $message_size upon reception and lost 2*$message_size
upon deletion from Inbox+Sent, I would suspect quota plugin isn't active
when the message is being delivered. How are messages delivered?
Am 12.05.2012 20:35, schrieb Luuk@dovecot:
On 12-05-2012 19:48, Gedalya wrote:
I understand you sent an email to yourself?
If you gained one $message_size upon reception and lost 2*$message_size
upon deletion from Inbox+Sent, I would suspect quota plugin isn't active
when the message is
On 12-05-2012 20:42, Reindl Harald wrote:
Am 12.05.2012 20:35, schrieb Luuk@dovecot:
On 12-05-2012 19:48, Gedalya wrote:
I understand you sent an email to yourself?
If you gained one $message_size upon reception and lost 2*$message_size
upon deletion from Inbox+Sent, I would suspect quota
On 21.4.2012, at 13.42, Cor Bosman wrote:
On Apr 21, 2012, at 12:32 PM, Timo Sirainen wrote:
On 21.4.2012, at 11.01, Cor Bosman wrote:
prefix = Spam/
.
quota2 = dict:Spam Quota::ns=spam:file:%h/spam-quota
.
Apr 21 10:00:11 lmtp1 dovecot: imap(cor): Error: quota: Unknown namespace:
http://hg.dovecot.org/dovecot-2.1/rev/4c8f79d1f9f1 should fix it with dict
quota.
Thank you, this fixed it with dict quota.
Cor
It looks like my quota isnt being calculated properly after I started
setting quota to a specific folder. The quota in that folder is always
starting out at 0, and only new email is being added to the quota. If I
remove the maildirsize file, and recalculate, it still starts at 0. Once
On 21.4.2012, at 11.01, Cor Bosman wrote:
prefix = Spam/
..
quota2 = dict:Spam Quota::ns=spam:file:%h/spam-quota
..
Apr 21 10:00:11 lmtp1 dovecot: imap(cor): Error: quota: Unknown namespace:
spam
Oh. It would make more sense to have ns=spam, but unfortunately I hadn't
thought of
On Apr 21, 2012, at 12:32 PM, Timo Sirainen wrote:
On 21.4.2012, at 11.01, Cor Bosman wrote:
prefix = Spam/
.
quota2 = dict:Spam Quota::ns=spam:file:%h/spam-quota
.
Apr 21 10:00:11 lmtp1 dovecot: imap(cor): Error: quota: Unknown namespace:
spam
Oh. It would make more sense to have
It looks like my quota isnt being calculated properly after I started setting
quota to a specific folder. The quota in that folder is always starting out at
0, and only new email is being added to the quota. If I remove the maildirsize
file, and recalculate, it still starts at 0. Once email
On 20.4.2012, at 19.05, Cor Bosman wrote:
It looks like my quota isnt being calculated properly after I started setting
quota to a specific folder. The quota in that folder is always starting out
at 0, and only new email is being added to the quota. If I remove the
maildirsize file, and
On 23/3/2012 12:58 μμ, Alain DEFRANCE wrote:
so if i understand correctly i can mix the 2 quota_rule ?
the one who came from ldap user_attrs (quota_rule=*:bytes=%$)
and the other which from quota_rule2 = Trash:storage=+3%%
Actually, in user_attrs you define the applicable ldap attributes and
hello all,
i'm using quota + ldap with dovecot 2
in dovecot-ldap.conf.ext file i have the line :
user_attrs =
homeDirectory=home,uidNumber=uid,gidNumber=gid,quota=quota_rule=*:storage=%$B
how can i add Trash:storage= to have more place for deleting
messages like in
90-quota.conf file ?
On 23/3/2012 12:20 μμ, Alain DEFRANCE wrote:
how can i add Trash:storage= to have more place for deleting
messages like in
See, for example, my setup:
http://old.nabble.com/ldap-userdb-warning-in-v2.1.1-td33544211.html
I use a single conf file (because it's small and it's more intuitive
thanks Nick
so if i understand correctly i can mix the 2 quota_rule ?
the one who came from ldap user_attrs (quota_rule=*:bytes=%$)
and the other which from quota_rule2 = Trash:storage=+3%%
in your case you add 3% quota more for Trash ?
Am i write ?
regards
On 23/3/2012 12:20 μμ, Alain
3081 Feb 28 16:56 /usr/local/scripts/quota-warning2.1
But now I'm gettting this in my log:
Feb 28 19:19:03 postamt quota-warning2(phxxxpsu): writing message failed
Feb 28 19:19:03 postamt dovecot: quota-warning: Fatal: master:
service(quota-warning): child 15065 returned error 1
Feb 28 19:40:13
* Ralf Hildebrandt ralf.hildebra...@charite.de:
With 2.0.18 I was using a quota warning script like this:
Must have been a PEBKAC - I fixed my installation by harmonising
$PREFIX (seperate $PREFIX for 2.0 and 2.1, removig an old installation
along the way) as well as cleaning up some old scripts
On 17.2.2012, at 15.40, jos...@hybrid.pl wrote:
I have dovecot 2.0 configured with virtual users in MySQL, SMTP is
handled by exim which uses dovecot LMTP transport.
I'd like to test quota warning messages, but in wiki2 there is only
an example for delivering it with dovecot-lda. I tried
Hello,
I have dovecot 2.0 configured with virtual users in MySQL, SMTP is
handled by exim which uses dovecot LMTP transport.
I'd like to test quota warning messages, but in wiki2 there is only
an example for delivering it with dovecot-lda. I tried several ways
of using lmtp binary, but without
On 17.02.2012 14:40, jos...@hybrid.pl wrote:
Hello,
Hi,
I have dovecot 2.0 configured with virtual users in MySQL, SMTP is
handled by exim which uses dovecot LMTP transport.
I'd like to test quota warning messages, but in wiki2 there is only
an example for delivering it with dovecot-lda. I
On 12.2.2012, at 8.54, Thomas Leuxner wrote:
Indeed I did as it did not like the syntax:
$ dsync -u t...@leuxner.net backup dsync -o
mail=mdbox:/home/backups/tlx/mdbox -o plugin/quota=
backup: invalid option -- 'o'
doveadm backup [-u user|-A] [-S socket_path] [-fR] [-m mailbox] dest
Oh.
Am 11.02.2012 um 08:58 schrieb Thomas Leuxner:
$ doveadm backup -u t...@leuxner.net mdbox:/tmp/tlx/mdbox
dsync(t...@leuxner.net): Panic: file dsync-worker-local.c: line 1643
(local_worker_save_msg_continue): assertion failed: (ret == -1)
dsync(t...@leuxner.net): Error: Raw backtrace:
Some more coffee later revealed doveadm/dsync being picky on the order of
parameters. This works:
$ doveadm -o plugin/quota= backup -u t...@leuxner.net mdbox:/home/tlx/mdbox
$ doveadm -f table quota get -u t...@leuxner.net
Please look into the crash though.
Regards
Thomas
signature.asc
On 11.2.2012, at 12.59, Thomas Leuxner wrote:
Some more coffee later revealed doveadm/dsync being picky on the order of
parameters. This works:
$ doveadm -o plugin/quota= backup -u t...@leuxner.net mdbox:/home/tlx/mdbox
Now you have disabled quota entirely from dsync. I guess it doesn't
On 11.2.2012, at 9.58, Thomas Leuxner wrote:
$ doveadm backup -u t...@leuxner.net mdbox:/tmp/tlx/mdbox
dsync(t...@leuxner.net): Panic: file dsync-worker-local.c: line 1643
(local_worker_save_msg_continue): assertion failed: (ret == -1)
Fixed:
Am 12.02.2012 um 04:42 schrieb Timo Sirainen:
On 11.2.2012, at 12.59, Thomas Leuxner wrote:
Some more coffee later revealed doveadm/dsync being picky on the order of
parameters. This works:
$ doveadm -o plugin/quota= backup -u t...@leuxner.net mdbox:/home/tlx/mdbox
Now you have
Am 12.02.2012 um 04:45 schrieb Timo Sirainen:
On 11.2.2012, at 9.58, Thomas Leuxner wrote:
$ doveadm backup -u t...@leuxner.net mdbox:/tmp/tlx/mdbox
dsync(t...@leuxner.net): Panic: file dsync-worker-local.c: line 1643
(local_worker_save_msg_continue): assertion failed: (ret == -1)
Am 09.02.2012 um 19:24 schrieb Timo Sirainen:
So .. I'm not really sure what I can do about this. There are some
workarounds you could do, like:
dsync -u u...@domain.tld backup dsync -o mail=mdbox:/path to backup/mdbox
-o plugin/quota=
Thanks tried this morning. I think it has some
On Sat, 2010-12-25 at 10:08 +0100, Thomas Leuxner wrote:
plugin {
quota = dict:user::file:%h/mdbox/dovecot-quota
quota_rule = *:storage=1GB
quota_rule2 = Trash:storage=+10%%
}
Kick off a manual backup:
$ dsync -u u...@domain.tld backup mdbox:/path to backup/mdbox
This results
On 10.1.2012, at 11.34, l.chelchowski wrote:
Jan 10 10:15:06 lda: Debug: auth input: tes...@domain.eu
home=/home/vmail/domain.eu/tester/
mail=maildir:/home/vmail/domain.eu/tester/:INDEX=/var/mail/vmail/domain.eu/tes...@domain.eu/index/public
uid=101 gid=12 quota_rule=*:storage=2097
Anyone?
W dniu 2012-01-10 10:34, l.chelchowski napisał(a):
Hi!
Please help me with this.
The problem exists when
quota-warning is executing:
LOG:
Jan 10 10:15:06 lmtp(85973):
Debug: none: root=, index=, control=,
inbox=, alt=
Jan 10 10:15:06
lmtp(85973): Info: Connect from local
Il giorno Mer 18 Gen 2012 15:56:41 CET, Timo Sirainen ha scritto:
[...]
You're using SQL only for passdb lookup.
[...]
user_query isn't used, because you aren't using userdb sql.
Hi Timo,
thank you, I confirm everything you wrote. In order to help someone with
the same problem, when using
On Mon, 2012-01-16 at 11:42 +0100, RaSca wrote:
passdb sql {
args = /etc/dovecot/dovecot-sql.conf
}
userdb passwd {
}
userdb static {
args = uid=5000 gid=5000 home=/mail/mailboxes/%d/%n@%d
allow_all_users=yes
}
You're using SQL only for passdb lookup.
plugin {
I tried to set a quota setting. I installed dovecot with newest
version, patched it and started it.
dovecot -n:
# 1.2.15: /etc/dovecot/dovecot.conf
# OS: Linux 2.6.32-5-amd64 x86_64 Debian 6.0.3 ext4
log_timestamp: %Y-%m-%d %H:%M:%S
protocols: imap imaps pop3 pop3s
ssl_listen: 143
On 18.1.2012, at 22.41, Markus Fritz wrote:
passdb:
driver: sql
args: /etc/dovecot/dovecot-sql.conf
userdb:
driver: static
args: uid=5000 gid=5000 home=/var/vmail/%d/%n/Maildir allow_all_users=yes
You use sql as passdb, static as userdb.
password_query = SELECT email as
Hi all,
I'm trying to make quota work in Squeeze (Dovecot 1.2.15-7).
The quota module is correctly loaded and, when receiving a message, from
the log I see these messages:
Jan 16 11:20:04 mail-1 dovecot: deliver(testquota@mydomain): Loading
modules from directory: /usr/lib/dovecot/modules/lda
Jan
On 16/01/2012 11:42, RaSca wrote:
Hi all,
I'm trying to make quota work in Squeeze (Dovecot 1.2.15-7).
try auth_debug = yes
--
Simone Caruso
IT Consultant
+39 349 65 90 805
Il giorno Lun 16 Gen 2012 16:40:59 CET, Simone Caruso ha scritto:
On 16/01/2012 11:42, RaSca wrote:
Hi all,
I'm trying to make quota work in Squeeze (Dovecot 1.2.15-7).
try auth_debug = yes
In fact, enabling auth_debug gives me this:
Jan 16 17:21:06 mail-2 dovecot: auth(default): master
Hi!
Please help me with this.
The problem exists when quota-warning is executing:
LOG:
Jan 10 10:15:06 lmtp(85973): Debug: none: root=, index=, control=,
inbox=, alt=
Jan 10 10:15:06 lmtp(85973): Info: Connect from local
Jan 10 10:15:06 lmtp(85973): Debug: Loading modules from directory:
On Thu, 2011-12-15 at 09:37 +0100, Adis Nezirovic wrote:
Wiki instructions for creating insert trigger for PostgreSQL are wrong
http://wiki.dovecot.org/Quota/Dict
Calling INSERT on the table from within BEFORE INSERT trigger creates
cascading trigger.
Yes..
Instead, one should return
Wiki instructions for creating insert trigger for PostgreSQL are wrong
http://wiki.dovecot.org/Quota/Dict
Calling INSERT on the table from within BEFORE INSERT trigger creates
cascading trigger.
http://www.postgresql.org/docs/current/interactive/trigger-definition.html
Instead, one should
(imaptester): Error: quota:
net_connect_unix(/var/run/dovecot/quota-warning) failed: Permission
denied (euid=500(vmail) egid=500(vmail) missing +r perm:
/var/run/dovecot/quota-warning, euid is not dir owner)
Here is /var/run/dovecot/:
# ls -la /var/run/dovecot/
total 32
drwxr-xr-x 4 rootdovecot
On Wed, Dec 14, 2011 at 12:47:05PM +0200, Nikolaos Milas wrote:
For example, in the logs I get:
Dec 12 08:42:40 vmail dovecot: lda(imaptester): Error: quota:
net_connect_unix(/var/run/dovecot/quota-warning) failed: Permission
denied (euid=500(vmail) egid=500(vmail) missing +r perm:
/var/run
-warning {
}
}
and did a full restart:
# service dovecot restart
Again:
Dec 14 13:30:11 vmail dovecot: lda(tester): Error: quota:
net_connect_unix(/var/run/dovecot/quota-warning) failed: Permission
denied (euid=500(vmail) egid=500(v
mail) missing +r perm: /var/run/dovecot/quota-warning
Nikolaos Milas schrieb:
No, this did not solve the problem. I changed to vmail
service quota-warning {
executable = script /opt/mail1.sh
user = vmail
unix_listener quota-warning {
}
}
This is what works for me:
service quota-warning {
executable = script /usr/local/etc/dovecot/quota
Em 14/12/11 10:24, Patrick Westenberg escreveu:
This is what works for me:
service quota-warning {
executable = script /usr/local/etc/dovecot/quota-warning.sh
unix_listener quota-warning {
user = vmail
}
user = vmail
}
My configurations are similar to Patrick ones and works
On Wed, Dec 14, 2011 at 10:33:14AM -0200, Leonardo Rodrigues wrote:
service quota-warning {
executable = script /etc/dovecot/aviso-quota.sh
user = dovecot
unix_listener quota-warning {
user = mail
}
}
Right, looks like the Wiki Example needs to be revamped...
[ 90-quota.conf
Thank you all for your help.
Changing from:
unix_listener quota-warning {
}
to:
unix_listener quota-warning {
user = vmail
}
solved the problem!
Now my quota warning message is being sent successfully.
I think I'll now open a new thread on how to send rich/UTF-8 mail
Em 14/12/11 15:52, Nikolaos Milas escreveu:
I think I'll now open a new thread on how to send rich/UTF-8 mail
warnings.
Probably you just need to format/encode it properly ... no big deal
on that.
--
Atenciosamente / Sincerily,
Leonardo Rodrigues
Solutti
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,
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 INBOX
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 INBOX
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 is OK:
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 and
Is the quota in the database 1096 or2GB? 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
On Wed, 2011-11-09 at 20:44 +0200, Adrian Minta wrote:
Is the quota in the database 1096 or2GB? 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.
In
I'm able to consistently reproduce this problem/behavior, but not
workaround or fix it, yet.
Rich
On Wed, Oct 19, 2011 at 7:41 AM, Rich pgnet.dev+rich-dove...@gmail.com wrote:
I've made some progress, but quota 'Limit' is still not fully
functioning for me.
A couple of changes have helped:
Hi, I cant run quota warning or other script.
any suggestions? Oct 22 10:02:52 userseuac dovecot: imap(user4): Debug:
Effective uid=1002, gid=1002, home=/home/user4
Oct 22 10:02:52 userseuac dovecot: imap(user4): Debug: Quota root: name=User
quota backend=maildir args=
Oct 22 10:02:52
hi,
I'm having some difficulty understanding the connection between postfix,
dovecot and quota.
What is the best way to set up quotas? through the file system quota and
maildir? Need the dovecot lda working? The postfix needs a patch?
I was thinking about setting quotas on file system,
On Fri, 21 Oct 2011, nuno marques wrote:
hi,
I'm having some difficulty understanding the connection between postfix,
dovecot and quota.
What is the best way to set up quotas? through the file system quota and
maildir? Need the dovecot lda working? The postfix needs a patch?
I was thinking
101 - 200 of 722 matches
Mail list logo
