[Dovecot] Quota, Postgres + Postfixadmin
Hi everybody,
i am currently testing dovecot-1.2.9 together with postfix, postgres and postfixadmin.
After setting up the basics, i wanted to get the quotas working...
So i edited the dovecot.conf:
mail_plugins = quota imap_quota mail_plugins = sieve quota quotadict = pgsql:/etc/dovecot/dovecot-dict-quota.conf quota = dict:user::proxy::quotadict
and dovecot-dict-quota.conf: connect = host=localhost dbname=postfix user=yyy password=xxx map { pattern = priv/quota/storage table = quota2 username_field = username value_field = bytes } map { pattern = priv/quota/messages table = quota2 username_field = username value_field = messages }
After moving some mail on and off the account and finally cleaning out any mail (verified via console) quota2 looks like this:
username bytes messages test@testdomain.de -1009339 -1
So it seems to me its calculating sth. wrong? Or am i doing sth. wrong?
greetings, Roman
printk(KERN_ERR "happy meal: Transceiver and a coke please."); linux-2.6.6/drivers/net/sunhme.c
On Thu, 2010-10-14 at 13:55 +0200, Roman wrote:
quotadict = pgsql:/etc/dovecot/dovecot-dict-quota.conf
After moving some mail on and off the account and finally cleaning out any mail (verified via console) quota2 looks like this:
username bytes messages test@testdomain.de -1009339 -1
It looks like you didn't create the PostgreSQL trigger as instructed in the wiki page. http://wiki.dovecot.org/Quota/Dict
On Thursday 14 October 2010 17:26:08 Timo Sirainen wrote:
On Thu, 2010-10-14 at 13:55 +0200, Roman wrote:
quotadict = pgsql:/etc/dovecot/dovecot-dict-quota.conf
After moving some mail on and off the account and finally cleaning out any mail (verified via console) quota2 looks like this:
username bytes messages test@testdomain.de -1009339 -1
It looks like you didn't create the PostgreSQL trigger as instructed in the wiki page. http://wiki.dovecot.org/Quota/Dict
I did... or so i thought, it looks like there was already a function called merge_quota / merge_quota2, but sth. went wrong there... after removing both and recreating it like documented it seems to work, i will keep an eye on it.
thx for the help!
greetings, Roman
-- When a woman gives me a present I have always two surprises: first is the present, and afterward, having to pay for it. -- Donnay
participants (2)
-
Roman
-
Timo Sirainen