Re: Update virtual folders via doveadm?

2018-11-19 Thread Aki Tuomi


On 20.11.2018 2.51, Daniel Miller wrote:
> I'm trying to have my server maintain it's FTS indexes reasonably
> current at all times.  From prior threads, and based on my namespace
> configuration, I have the following hourly cronjob:
>
> doveadm index -A -q '*'
> doveadm index -A -q 'shared/*'
> doveadm index -A -q 'virtual/*'
>
> This seems to work just fine to maintain the FTS (Solr).  However - as
> I understand it Dovecot's virtual folders are not updated with new
> mails until they are accessed by a client.  Therefore the above
> command sequence would work fine for my default namespace and the
> shared - but the virtual namespace won't actually be current.  So...
>
> Would a command such as:
>
> doveadm mailbox status -A messages virtual/*
>
> Be appropriate to run prior to the virtual/* FTS indexing?
>
doveadm index should perform the same update.

Aki



Multi-server but small scale

2018-11-19 Thread Daniel Miller
I have a small but critical server that supports our group.  As a single 
server - it's obviously a single-point-of-failure for lots of things.  
As I just experienced...again.  It was a lot more fun building systems 
from components when I was younger...


Previously 3rd-party hosted solutions didn't look attractive for several 
reasons...but I'm seeing prices now for cloud virtual machines that are 
stupid cheap.  Even if they wind up being limited speed & availability - 
it would seem they'd be a lot better than nothing!


So I'm considering having at least one backup server for various 
services - obviously that includes mail.  So now I have to wonder about 
the backend.  And while I think I'm reasonably current with networked 
file systems (not distributed or cluster) I haven't played with 
replication for a quite a while.


For this particular usage (I'm envisioning two servers total) - is there 
a need/reason to use any form of networked/distributed/cluster file 
storage?  Or would this be accomplished via "pure" Dovecot - dsync 
replication would keep things updated between the servers and director 
would handle the connections?  So with identically configured SMTP 
servers, passing to the local LMTP agents, the file system would be 
"purely local" with no NFS or other interconnection?


--
Daniel



Update virtual folders via doveadm?

2018-11-19 Thread Daniel Miller
I'm trying to have my server maintain it's FTS indexes reasonably 
current at all times.  From prior threads, and based on my namespace 
configuration, I have the following hourly cronjob:


doveadm index -A -q '*'
doveadm index -A -q 'shared/*'
doveadm index -A -q 'virtual/*'

This seems to work just fine to maintain the FTS (Solr).  However - as I 
understand it Dovecot's virtual folders are not updated with new mails 
until they are accessed by a client.  Therefore the above command 
sequence would work fine for my default namespace and the shared - but 
the virtual namespace won't actually be current.  So...


Would a command such as:

doveadm mailbox status -A messages virtual/*

Be appropriate to run prior to the virtual/* FTS indexing?

--
Daniel



Re: IMAP Limitations with Outlook 2013?

2018-11-19 Thread Robert Schetterer

Am 19.11.18 um 18:49 schrieb Robert Adkins:

Good Day!

     I have a fairly new user on my network that has, over 
about 10 months, created in root inbox and nested sub-folders totaling 
over 900 individual folders.


     In the past few weeks, newly created folders will be 
visible in Outlook 2013, but when an email is moved into that folder, it 
is no longer visible. I can ssh into the server, drill down to that 
sub-folder and see the email in the folder AND it is also available to 
be seen without issue in Thunderbird.


     I know this is a longshot, but if there is some feature 
that I haven’t found in Dovecot to force Outlook to synchronize with all 
the folders/sub-folders, please let me know.


     Beyond that… With this particular users habits, over 
the next 5 years, there could be nearly 10,000 folders/sub-folders. Does 
anyone know if this will create any problems with Dovecot or is this 
JUST a Microsoft software problem?


--

Best Regards,

Robert Adkins

IT Manager/Tool Designer

Impel Industries, Inc.
586-254-5800



perhaps this helps

https://support.microsoft.com/en-gb/help/2768656/outlook-performance-issues-when-there-are-too-many-items-or-folders-in

--
[*] sys4 AG

http://sys4.de, +49 (89) 30 90 46 64
Schleißheimer Straße 26/MG, 80333 München

Sitz der Gesellschaft: München, Amtsgericht München: HRB 199263
Vorstand: Patrick Ben Koetter, Marc Schiffbauer
Aufsichtsratsvorsitzender: Florian Kirstein


Re: IMAP Limitations with Outlook 2013?

2018-11-19 Thread Odhiambo Washington
On Mon, 19 Nov 2018 at 20:52, Robert Adkins  wrote:

> Good Day!
>
>
>
> I have a fairly new user on my network that has, over
> about 10 months, created in root inbox and nested sub-folders totaling over
> 900 individual folders.
>
>
>
> In the past few weeks, newly created folders will be
> visible in Outlook 2013, but when an email is moved into that folder, it is
> no longer visible. I can ssh into the server, drill down to that sub-folder
> and see the email in the folder AND it is also available to be seen without
> issue in Thunderbird.
>
> I know this is a longshot, but if there is some feature
> that I haven’t found in Dovecot to force Outlook to synchronize with all
> the folders/sub-folders, please let me know.
>
>
>
> Beyond that… With this particular users habits, over the
> next 5 years, there could be nearly 10,000 folders/sub-folders. Does anyone
> know if this will create any problems with Dovecot or is this JUST a
> Microsoft software problem?
>
>
>
> --
>
>
>
> Best Regards,
>
> Robert Adkins
>
> IT Manager/Tool Designer
>
> Impel Industries, Inc.
> 586-254-5800
>
>
>

I am only marveling at 900 individual mailboxes!
That kind of situation tells me that the individual does not need to use
e-mail anymore for their work. Maybe a CRM system.
I am thinking along the lines of having 900+ labels on gmail

Anyway, I know Timo has a better answer for you.




-- 
Best regards,
Odhiambo WASHINGTON,
Nairobi,KE
+254 7 3200 0004/+254 7 2274 3223
"Oh, the cruft."


IMAP Limitations with Outlook 2013?

2018-11-19 Thread Robert Adkins
Good Day!

 

I have a fairly new user on my network that has, over about
10 months, created in root inbox and nested sub-folders totaling over 900
individual folders.

 

In the past few weeks, newly created folders will be visible
in Outlook 2013, but when an email is moved into that folder, it is no
longer visible. I can ssh into the server, drill down to that sub-folder and
see the email in the folder AND it is also available to be seen without
issue in Thunderbird.

I know this is a longshot, but if there is some feature that
I haven't found in Dovecot to force Outlook to synchronize with all the
folders/sub-folders, please let me know.

 

Beyond that. With this particular users habits, over the
next 5 years, there could be nearly 10,000 folders/sub-folders. Does anyone
know if this will create any problems with Dovecot or is this JUST a
Microsoft software problem?

 

--

 

Best Regards,

Robert Adkins

IT Manager/Tool Designer

Impel Industries, Inc.
586-254-5800

 


Re: Quota in MySql Dict not recalculate automatic

2018-11-19 Thread SUnsin

I have tested it on my old Installation with dovecot Version 2.2.22 and it
works.

When I set "quota = count:User quota:noenforcing", I receive E-Mails also
over the quota an get the warning E-Mails.

When I remove nonenforcing, I get the warning E-Mails and the received
E-Mails where bounced/rejected over the quota.

It looks like a Bug in the dovecot Version 2.2.33?

Stephan




Von:"Aki Tuomi" 
An: "Dovecot Mailing List" ,
sun...@gv-bayern.de
Datum:  16.11.2018 11:02
Betreff:Re: Antwort: Re: Quota in MySql Dict not recalculate automatic



It should work, I have to check why it's not working.


Aki


On 16.11.2018 11.47, sun...@gv-bayern.de wrote:


  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 {
  quota_warning = storage=95%% quota-warning 95 %u
  quota_warning2 = storage=80%% quota-warning 80 %u
  }

  I wouldn´t like reject an E-Mail although des quota ist over the
  limit.



Stephan

  Inaktiv: Details verbergen für "Aki Tuomi"
---15.11.2018
  20:15:48---dict quota is known to have this
problem that it is
  not alw"Aki Tuomi" ---15.11.2018 20:15:48---dict quota is known to
  have this problem that it is not always updated on time. You should
  use quota

  Von: "Aki Tuomi" 
  An: "Dovecot Mailing List" , sun...@gv-bayern.de
  Datum: 15.11.2018 20:15
  Betreff: Re: Quota in MySql Dict not recalculate automatic



  dict quota is known to have this problem that it is not always
  updated on time. You should use quota count with quota_clone plugin
  instead (might require upgrade).

  Please remember to change password for mysql user pfadmin, as you
  accidentically sent it to the list.

  Aki

  > On 15 November 2018 at 20:52 sun...@gv-bayern.de wrote:
  >
  >
  >
  >
  > 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
  > Doveot 2.2.33
  > MySQL 5.7.24
  > Postfixadmin 3.2
  > Apache 2.4.18
  > Rainloop 1.12.1
  >
  > The Problem is now: When I receive a E-Mail, the quota will not
  > Update (recalculate) automatical in the MySql-DB from Dovecot.
  >
  > In the old System there execute the SQL Statement after receiving a
  E-Mail,
  > for example:
  > UPDATE quota2 SET bytes=bytes+3076,messages=messages+1 WHERE
  username =
  > 
  >
  > On the new System with the newer Dovecot Version, the Statement
  never comes
  > after
  > receive an E-Mail.
  >
  > With Dovecot Version 2.3 on the old System with Ubuntu 16.04,
  everything
  > works fine
  > with the same config.
  >
  > Is a BUG in the Dovecot Version 2.2.33 possible?
  > Can everbody help me?
  >
  > Kind regards
  > Stephan
  >
  >
  > dovecot -n
  > # 2.2.33.2 (d6601f4ec): /etc/dovecot/dovecot.conf
  > # Pigeonhole version 0.4.21 (92477967)
  > # OS: Linux 4.15.0-39-generic x86_64 Ubuntu 18.04.1 LTS
  > auth_debug = yes
  > auth_debug_passwords = yes
  > auth_master_user_separator = *
  > auth_mechanisms = plain login
  > auth_verbose_passwords = yes
  > dict {
  >   sqldomainquota =
  mysql:/etc/dovecot/dovecot-dict-sql-domain.conf.ext
  >   sqluserquota = mysql:/etc/dovecot/dovecot-dict-sql-user.conf.ext
  > }
  > disable_plaintext_auth = no
  > login_greeting = Dovecot ready.
  > mail_debug = yes
  > mail_location = maildir:~/Maildir
  > mail_plugins = " quota"
  > managesieve_notify_capability = mailto
  > managesieve_sieve_capability = fileinto reject envelope
  encoded-character
  > vacation subaddress comparator-i;ascii-numeric relational regex
  imap4flags
  > copy include variables body enotify environment mailbox date index
  ihave
  > duplicate mime foreverypart extracttext
  > namespace inbox {
  >   inbox = yes
  >   location =
  >   mailbox Drafts {
  >     special_use = \Drafts
  >   }
  >   mailbox 

"Group doesn't exist: dovecot"

2018-11-19 Thread James Brown
No matter what I do, I always get this error when trying to start Dovecot:

$ sudo /usr/local/opt/dovecot/sbin/dovecot
Warning: fd limit (ulimit -n) is lower than required under max. load (256 < 
1000), because of default_client_limit
Fatal: service(stats) Group doesn't exist: dovecot (See service stats { 
unix_listener /usr/local/var/run/dovecot/stats-writer { group } } setting)

The user and group it should be using are _dovecot.

Config:

$ sudo /usr/local/opt/dovecot/sbin/dovecot -n
# 2.3.2.1 (0719df592): /usr/local/etc/dovecot/dovecot.conf
# OS: Darwin 18.2.0 x86_64  apfs
# Hostname: mailbordocomau-dr.local
doveconf: Error: t_readlink(/usr/local/var/run/dovecot/dovecot.conf) failed: 
readlink() failed: No such file or directory
default_internal_user = _dovenull
default_login_user = _dovecot
first_valid_gid = 0
first_valid_uid = 102
last_valid_gid = 500
last_valid_uid = 105
mail_gid = 102
mail_location = maildir:/usr/local/virtual/%d/%u
mail_uid = 102
namespace inbox {
  inbox = yes
  location = 
  mailbox Drafts {
special_use = \Drafts
  }
  mailbox Junk {
special_use = \Junk
  }
  mailbox Sent {
special_use = \Sent
  }
  mailbox "Sent Messages" {
special_use = \Sent
  }
  mailbox Trash {
special_use = \Trash
  }
  prefix = 
}
passdb {
  args = /usr/local/etc/dovecot/dovecot-sql.conf.ext
  driver = sql
}
protocols = imap pop3
service auth {
  unix_listener /var/spool/postfix/private/auth {
group = _postfix
mode = 0660
user = _postfix
  }
  unix_listener auth-userdb {
mode = 0660
user = _vmail
  }
}
ssl_cert =