Displaying 20 results from an estimated 20000 matches similar to: "Please help with Quota dict mysql configuration"
2013 Sep 08
2
Postfixadmin/MySQL/Dovecot 2 and quota
Hi all,
I'm setting up a new email server based on the softwares list below:
* Postfix
* Dovecot 2.0.9
* MySQL
* Postfixadmin 2.3.6
My current problem is I'm unsure whether quota feature is well
configured or not.
In order to test and validate, I use Roundcubemail GUI which provides
percentage of the space used by the mailbox (quota should be applied per
mailbox).
Here, my
2015 Oct 06
4
More information about - Dovecot 2.2.x quota mysql and dict
I some add information about bug...
Dovecot 2.2.19 version on server FreeBSD 10.2 Release.
Config quota (dict + mysql)
Database create Postfixadmin 2.3.7
Old version Dovecot 2.2.13 use method UPDATE in MySQL base + dict
example mysql.log
-----------------
Connect postfix at localhost on postfix
134 Query SELECT bytes FROM quota2 WHERE username =
'user at mydomain.lan'
2017 Mar 17
2
Understanding quotas
Just to level-set, I am using Centos7-arm which supplies Dovecot
2.2.10. I don't have access to a arm build or mock environment and use
what is available (I DID try to install them but had dependency issues).
Much of what I have is from campworld, but some I have picked up from
other Centos mailserver builders.
Also I am using Postfixadmin which provides quotas per user in mysql
2019 Feb 14
1
Quota count and clone questions
all this almost reads like I can drop maintaining the quota2 table?
From https://wiki.dovecot.org/Quota/Count
mailbox_list_index = yes
# Avoid spending excessive time waiting for the quota calculation to
finish when
# mails' vsizes aren't already cached. If this many mails are opened,
finish the
# quota calculation on background in indexer-worker process. Mail
deliveries will
# be
2015 Sep 03
4
disable quota for all users
Dear all,
On a new server (postfix dovecot postfixadmin Centos)
I did define quota=0 in postfixadmin
However suddenly a user with more than 9Gb of mail got his mailbox new/cur
empty and maillog shows:
Sep 3 15:43:56 mail16 dovecot: lda(brouwerb at scholarium.nl): Error: sieve:
msgid=<alpine.LRH.2.20.1509031543050.16381 at streaming2.antenna.nl>: failed
to store into mailbox
2018 Aug 16
2
Does domain quota work and how?
Hello,
I'm in the process of moving users from an old dovecot setup with system
users to a modern virtual user setup.
I can't find good documentation on domain quota.
It is mentioned in the docs as
quota2 = dict:domain:%d:proxy::quota_domain
but not much more.
Searching the mailing list or Google doesn't reveal much more info.
Searching the German mailing list at jpberlin finds
2012 Oct 10
1
I need a quota expert
I'm having problems with dovecot quota configuration.
If I Include the driver mysql in dovecot-sql.conf I'm getting this error:
dovecot: dict: Error in configuration file /etc/dovecot/dovecot-sql.conf line 1: Unknown setting: driver
dovecot: dict: Failed to initialize dictionary 'quotadict'
If I Don't include it:
dovecot: auth(default): Fatal: sql: driver not set in
2015 Feb 09
2
Geting mail quota exceeded with plenty of space
> that was it. Emptied trash and mail flowing. How is the message #
> quota managed? I never encountered it before.
>
> But don't have time today to dig into it. conference call coming up.
You might have messages quota configured somewhere.
And for :
> doveadm(root): Fatal: Unknown command 'quota', but plugin quota
>exists. Try to set mail_plugins=quota
See
2010 Jul 14
2
domain quota dictionary
Hi
I just configure dovecot with the second dictionary for the domain quota
dict {
quotadict = mysql:/usr/local/etc/dovecot-quota.conf
quota_domain = mysql:/usr/local/etc/dovecot-quota-domain.conf
}
plugin {
quota = dict:user::proxy::quotadict
quota2 = dict:domain:%d:proxy::quota_domain
}
and the dovecot-quota-domain.conf looks like this :
connect = host=xxx dbname=xxx
2018 Nov 15
2
Quota in MySql Dict not recalculate automatic
Hi,
I have a working Installation with:
Ubuntu 16.04 LTS
Dovecot 2.2.22
MySql 5.7.24
Postfixadmin 3.2
Apache 2.4.18
Rainloop 1.12.1
I manage the E-Mail Accounts with postfixadmin in a MySql-DB.
Also I use quotas with Quota Backend postfixadmin-DB (dict).
Everything works fine.
Now I installed a new Server with the following Versions and
migrate the Configs to the new System.
Ubuntu 18.04 LTS
2018 Nov 16
3
Antwort: Re: Quota in MySql Dict not recalculate automatic
With quota count and quota_clone it works, but can I use noenforcing with
quota count?
quota = count:User quota:noenforcing
When I test this config, I receive no quota-warning E-Mail:
service quota-warning {
executable = script /usr/local/bin/quota-warning.sh
# user = dovecot
user = vmail
unix_listener quota-warning {
user = vmail
group = vmail
mode = 0660
}
}
plugin {
2019 Feb 12
2
Maintaining table quota2
Does dovecot compute that values for quota2 with each email it updates
for the user?? Or only an incremental change?
I ask because I am looking at migrating all the user mail from the old
server to the new and building a new sql database.? All I see is:
dovecot-dict-sql.conf.ext: connect = host=/var/lib/mysql/mysql.sock
dbname=postfix user=postfix password=$Postfix_Database_Password map {
2019 Feb 12
2
Maintaining table quota2
On 2/12/19 12:38 PM, Aki Tuomi via dovecot wrote:
>> On 12 February 2019 at 18:23 Robert Moskowitz via dovecot <dovecot at dovecot.org> wrote:
>>
>>
>> Does dovecot compute that values for quota2 with each email it updates
>> for the user?? Or only an incremental change?
>>
>> I ask because I am looking at migrating all the user mail from the old
2011 Dec 08
1
Per-User MySQL Quota (postfixadmin)
Hi,
?
need some help setting per-user quota and postfixadmin.?Setup is working on 1.2
dovecot. Tryin 2.1 dovecot now,? quota is working but overriden quota rule set
by 'user_query =' in /etc/dovecot/dovecot-sql.conf.ext takes no efffekt. What's
wrong here?
?
Greets
?
Haris
-------------- next part --------------
# 2.1.rc1: /etc/dovecot/dovecot.conf
# OS: Linux 2.6.32-5-amd64 x86_64
2012 Oct 16
1
Problem with quota update in dovecot 1.2
Hi
A have a problem with quota2 table, working under postfixadmin. When I
login into imap server with thunderbird client everything works fine,
quota is update when i receive a message, but when I move message to
trash or any other folder value for messages field in table quota2
increases +1 instead decreases or have still this same value. Only if I
close my imap client value descending -2.
2010 Oct 14
1
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
2018 Mar 28
1
Dovecot quota
Hello,
I'm running Dovecot on a FreeBSD system with Postfix in a virtual user
setup, with Mysql. I am trying to understand the quota configuration.
I've got a Mysql database with an accounts table with a quota field.
I've also got two other tables one quota (currently has nothing in it
an empty set), and quota2 messages and bytes which has one entry. My
goal is to have different
2009 Feb 03
1
dict, quota, mysql and postfixadmin
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_line_length = 65536
mail_plugins = quota imap_quota
}
protocol pop3 {
listen = *:110
2013 May 19
3
Error: dict client sent broken reply
I've been mucking about, experimenting with the expire plugin and using a
dictionary. I've got the iteration query working when I do a normal
expunge using:
doveadm expunge -A mailbox "INBOX.Trash" savedbefore 1w
and expunging works as expected. However, I've got over 12,000 accounts
on this server, so I was hoping using the expire plugin to could help out.
I've
2012 Oct 19
4
still having difficulties with per-user quotas
Hello,
I am trying to get per-user quotas working. My thanks to all who have
helped so far.
To recap I am running Dovecot 2.1 and Mysql where I've got my virtual
users. All virtual users are under the system user vmail with a UID
and GID of 5000. Looking over the wiki docs I've added a quota table
and got the dict service working, I am not having problems with
permissions or the login