similar to: More information about - Dovecot 2.2.x quota mysql and dict

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

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 {

On 2/12/19 1:03 PM, Aki Tuomi via dovecot wrote: >> On 12 February 2019 at 19:55 Robert Moskowitz via dovecot <dovecot at dovecot.org> wrote: >> >> >> >> >> 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: >>>> >>>>

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

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

On 17 Oct 2015, at 12:41, Timo Sirainen <tss at iki.fi> wrote: > >> Connect postfix at localhost on postfix >> 134 Query SELECT bytes FROM quota2 WHERE username = >> 'user at mydomain.lan' >> 135 Query SELECT bytes FROM quota2 WHERE username = >> 'user at mydomain.lan' >> 135 Query BEGIN

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

Hello So what i have: centos 5.6 postfix 2.3.3 dovecot 2.0.13 postfixadmin 2.3.3 roundcube 0.5.3 All general things are working right now i can send receive email with ssl connections etc... Now i'm trying to configure additional options like quota and some other plugins like sieve, trash, expire and deleted-to-trash. Configuration of quota is on first place. I have read wiki regarding quota

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

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

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

Hello, after upgrade my mailsystem to dovecot version 2.1.7, dovecot doesn't work properly. something went wrong in dict service connecting the postgres backend. that happens not on every connection. the db connection data are correct, no difference connecting via tcp or linux socket. dovecot log entries: Jun 23 23:19:10 mx dovecot: dict: Panic: file driver-pgsql.c: line 84

> 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

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.

On 19/05/2019 22:45, John Fawcett via dovecot wrote: > On 19/05/2019 22:37, John Fawcett via dovecot wrote: >> On 19/05/2019 20:31, mabi via dovecot wrote: >>> >>> ??????? Original Message ??????? >>> On Sunday, May 19, 2019 7:36 PM, John Fawcett via dovecot >>> <dovecot at dovecot.org> wrote: >>>> >>>> Attached is a

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

On 07 Oct 2015, at 01:34, Simon <semfly at gmail.com> wrote: > > 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

Hi, I have setup the latest Dovecot and Sieve with dict in order to read rules from MySQL and works fine: sieve_before = dict:proxy::sieve;name=activesql;bindir=~/.sieve-bin dict { sieve = mysql:/etc/dovecot/dovecot-dict-sieve-sql.conf.ext } # cat /etc/dovecot/dovecot-dict-sieve-sql.conf.ext connect = host=10.1.1.1 dbname=dovecot user=dovecot password=Ciao map { pattern =

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hello, I find this in the logs: 2009-06-25 14:10:37 IMAP(dvtest) [29566]: Error: net_connect_unix(/usr/local/dovecot-1.2.rc6acl-hook2/var/run/dovecot/dict-server) failed: Permission denied 2009-06-25 14:10:37 IMAP(dvtest) [29566]: Error: acl: dict iteration failed, can't update dict although base_dir is just /var/run/dovecot/ . Dovecot v1.2

https://bugzilla.netfilter.org/show_bug.cgi?id=866 Summary: Missing newline with --list-rules Product: iptables Version: 1.4.x Platform: arm OS/Version: other Status: NEW Severity: normal Priority: P4 Component: iptables AssignedTo: netfilter-buglog at lists.netfilter.org ReportedBy: