- dovecot - dovecot.org

[Dovecot] Archiving mail
by Koenraad Lelong 18 Jul '13

18 Jul '13

Hi, I'm going to migrate my company-mailserver to new hardware. I would like to take the opportunity to archive some older mail. But I would like to have it still accessible, would this be possible with dovecot ? I mean, I would like to put that older mail from different users (I got about 50 users) on some read-only media but mount that media in the users mail-dirs. That way I will have less to backup after I backup that old mail and store it safely away. I can't convince my users to really clean up their mailboxes, so I backup more than 100GB mail while the total backup is a bit more than 300GB. Writing this I realise I could give each user a folder oldmail and symlink that to a read-only oldmail folder. Would this work ? I will have to find out how my backup-software can ignore the oldmail-folder. Thanks for any suggestions, Koenraad Lelong

3 2

[Dovecot] Password encryption type for dovecot & postfix saslauthd with mysql
by Simon 18 Jul '13

18 Jul '13

Hi There, We are using dovecot v2.2.4 (compiled from source) and postfix (yum install) on Centos 6.4. We are storing our virtual user config in mysql. Server 1 has dovecot/postfix and accepts incoming mail from our mail filter servers - this is purely for IMAP/POP services. Server 2 has postfix for our clients to send email via TLS/saslauthd. Both use the same (separate) mysql server for config. One issue is that we have a requirement to merge user / passwords for sending clients from two sources: 1) the dovecot mailbox list 2). another list. The dovecot user list is email + password. The other list is username + password. To that end we have created a view table in mysql that merges the two.. tables + view look a little like this: table: mail_users (for dovecot) email,password test(a)test1.com,CRAM-MD5_PASSWORD test2(a)test1.com,CRAM-MD5_PASSWORD bla(a)bla.com,CRAM-MD5_PASSWORD table: mail_senders_other username,password username1,CRAM-MD5_PASSWORD something_else,CRAM-MD5_PASSWORD view: mail_senders (for postfix) username,password test(a)test1.com,CRAM-MD5_PASSWORD test2(a)test1.com,CRAM-MD5_PASSWORD bla(a)bla.com,CRAM-MD5_PASSWORD username1,CRAM-MD5_PASSWORD something_else,CRAM-MD5_PASSWORD I have dovecot working fine, but just need a little push in the correct direction (please) to figure out the correct settings and password encryption scheme to make the above work. Many thanks! Simon

1 0

[Dovecot] Dovecot 2.2.4 does not create home directory?
by Dmitry . 17 Jul '13

17 Jul '13

Hi, Does not create, or something I did wrong? Here http://wiki2.dovecot.org/VirtualUsers/Home it is written Home vs. mail directory Home directory shouldn't be the same as mail directory. It's possible to do that, but you might run into trouble with it sooner or later. Some problems with this are: and Ways to set up home directory The home directory is the same as the mail directory. If for example home=/var/vmail/domain/user/ mail=/var/vmail/domain/user/mail/, set: mail_home = /var/vmail/%d/%n mail_location = maildir:~/mail I think I've done it so. And yet, here http://wiki.dovecot.org/HowTo/SimpleVirtualInstall it is written Users can be added by editing this file. Dovecot automatically notices the new users immediately after they're added. It also creates their home directories when the user logs in. However, the directory is not created. My config: # dovecot -n # 2.2.4: /etc/dovecot/dovecot.conf # OS: Linux 3.9.6 x86_64 Slackware 14.0 auth_debug = yes auth_debug_passwords = yes auth_mechanisms = plain login digest-md5 cram-md5 rpa apop auth_verbose = yes auth_verbose_passwords = plain debug_log_path = /var/log/dovecot/dovecot.debug.log disable_plaintext_auth = no info_log_path = /var/log/dovecot/dovecot.info.log lda_mailbox_autocreate = yes listen = 192.168.1.1 log_path = /var/log/dovecot/dovecot.log mail_debug = yes mail_gid = dovecot mail_uid = dovecot 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 ihave namespace inbox { inbox = yes location = mailbox Drafts { auto = subscribe special_use = \Drafts } mailbox Sent { auto = subscribe special_use = \Sent } mailbox Spam { auto = subscribe special_use = \Junk } mailbox Trash { auto = subscribe special_use = \Trash } prefix = } passdb { args = /etc/dovecot/dovecot-sql.conf driver = sql } plugin { antispam_allow_append_to_spam = NO antispam_backend = dspam antispam_debug_target = syslog antispam_dspam_args = --user;%Lu;--deliver=;--source=error;--signature=%%s antispam_dspam_binary = /usr/bin/dspam antispam_dspam_notspam = --class=innocent antispam_dspam_result_blacklist = Virus;Blocklisted;Blacklisted antispam_dspam_result_header = X-DSPAM-Result antispam_dspam_spam = --class=spam antispam_signature = X-DSPAM-Signature antispam_signature_missing = move antispam_skip_from_line = NO antispam_spam = Spam;spam;SPAM;Junk;junk;JUNK; antispam_trash = Trash;trash;Deleted;deleted;Deleted Items;Deleted Messages; antispam_verbose_debug = 1 sieve = ~/.dovecot.sieve sieve_default = /etc/dovecot/sieve/default.sieve sieve_dir = ~/sieve sieve_global_dir = /etc/dovecot/sieve/ } protocols = imap pop3 lmtp sieve service lmtp { inet_listener lmtp { address = 127.0.0.1 port = 24 } } service managesieve-login { inet_listener sieve { port = 4190 } } ssl_cert = </etc/dovecot/ssl/key.pem ssl_key = </etc/dovecot/ssl/key.pem userdb { args = /etc/dovecot/dovecot-sql.conf driver = sql } verbose_ssl = yes protocol lmtp { mail_plugins = " sieve" } protocol lda { mail_plugins = " sieve" } protocol imap { mail_max_userip_connections = 15 mail_plugins = " antispam" } protocol imaps { mail_max_userip_connections = 15 mail_plugins = " antispam" } # grep -v '^ *$#.*$\?$' dovecot-sql.conf driver = pgsql connect = host=localhost dbname=dbname user=user password=password default_pass_scheme = PLAIN password_query = SELECT password FROM users WHERE email = '%u' AND enabled = 1 user_query = SELECT \ concat('/var/spool/vmail/', home) AS home, \ concat('maildir:', maildir) AS mail \ FROM users WHERE email = '%u' AND enabled = 1 where in db home = "example.com/test/" maildir = "Maildir/" /etc/passwd dovecot:x:1202:202:Dovecot:/dev/null:/bin/bash dovenull:x:1203:203:Dovenull:/dev/null:/bin/false /etc/group dovecot:x:202: dovenull:x:203: cd /var/spool # ls -l drwxrwxr-x 4 dovecot dovecot 4096 Jul 17 12:41 vmail /var/log/dovecot/dovecot.debug.log Jul 17 12:49:41 auth: Debug: Loading modules from directory: /usr/lib64/dovecot/auth Jul 17 12:49:41 auth: Debug: Read auth token secret from /var/run/dovecot/auth-token-secret.dat Jul 17 12:49:41 auth: Debug: auth client connected (pid=10501) Jul 17 12:49:41 auth: Debug: client in: AUTH 1 CRAM-MD5 service=imap session=RONGFqLhrgDAqAPO lip=192.168.1.1 rip=192.168.1.2 lport=143 rport=50094 Jul 17 12:49:41 auth: Debug: client passdb out: CONT 1 PDk3MDcyMzA1OTYxMTU0MzguMTM3Mzk4NjE4MUBtYWlsPg== Jul 17 12:49:41 auth: Debug: client in: CONT 1 dGVzdEBoYXJkcmV2aWV3LnJ1IDFhOTE0NDBmZDk1OGE5ZWI0MWVkN2Q4ZDdhOGIzNzFi (previous base64 data may contain sensitive data) Jul 17 12:49:41 auth: Debug: sql(test(a)example.com,192.168.1.2,<RONGFqLhrgDAqAPO>): query: SELECT password FROM users WHERE email = 'test(a)example.com' AND enabled = 1 Jul 17 12:49:41 auth: Debug: password(test(a)example.com,192.168.1.2,<RONGFqLhrgDAqAPO>): Generating CRAM-MD5 from user 'test@example.com@', password 'test' Jul 17 12:49:41 auth: Debug: password(test(a)example.com,192.168.1.2,<RONGFqLhrgDAqAPO>): Credentials: 6062bc903ac97de43f0b5d33ebe8c1a63bb9ae1a88ec39cf6fd85a645de8c63a Jul 17 12:49:41 auth: Debug: client passdb out: OK 1 user= test(a)example.com Jul 17 12:49:41 auth: Debug: master in: REQUEST 2206334977 10501 1 49e1fcdcc5e1c2becb50c3b47d31cdeb session_pid=10506 Jul 17 12:49:41 auth: Debug: sql(test(a)example.com,192.168.1.2,<RONGFqLhrgDAqAPO>): SELECT concat('/var/spool/vmail/', home) AS home, concat('maildir:', maildir) AS mail FROM users WHERE email = 'test(a)example.com' AND enabled = 1 Jul 17 12:49:41 auth: Debug: master userdb out: USER 2206334977 test(a)example.com home=/var/spool/vmail/example.com/test/ mail=maildir:Maildir/ auth_token=670c839af976e3c0c74db1754e28ff40a2557095 Jul 17 12:49:41 imap: Debug: Loading modules from directory: /usr/lib64/dovecot Jul 17 12:49:41 imap: Debug: Module loaded: /usr/lib64/dovecot/lib90_antispam_plugin.so Jul 17 12:49:41 imap: Debug: Added userdb setting: mail=maildir:Maildir/ Jul 17 12:49:41 imap(test(a)example.com): Debug: Effective uid=1202, gid=202, home=/var/spool/vmail/example.com/test/ Jul 17 12:49:41 imap(test(a)example.com): Debug: Home dir not found: /var/spool/vmail/example.com/test/ Jul 17 12:49:41 imap(test(a)example.com): Debug: Namespace inbox: type=private, prefix=, sep=, inbox=yes, hidden=no, list=yes, subscriptions=yes location=maildir:Maildir/ Jul 17 12:49:41 imap(test(a)example.com): Debug: maildir++: root=Maildir, index=, indexpvt=, control=, inbox=Maildir, alt= Jul 17 12:49:41 imap(test(a)example.com): Debug: Namespace : Maildir doesn't exist yet, using default permissions Jul 17 12:49:41 imap(test(a)example.com): Debug: Namespace : Using permissions from Maildir: mode=0700 gid=default Thank you! Regards, Dmitry

4 6

[Dovecot] Variable similar to %u but providing the username changed by a database lookup?
by Axel Luttgens 17 Jul '13

17 Jul '13

Hello, Variable %u may be used in dovecot.conf whenever the "full username" is needed. But the expansion of %u returns the username before a possible change performed thru a password or user database lookup (e.g., in the case of a SQL database, thru as "AS user" clause). Is there a variable that would expand to the changed name when used in the configuration file? TIA, Axel

2 3

[Dovecot] Fail2ban and logging
by Paul van der Vlis 17 Jul '13

17 Jul '13

Hello, Dovecot is logging authentication failures this way: ------ Jul 12 18:07:19 vps0 dovecot: imap-login: Disconnected (auth failed, 22 attempts in 172 secs): user=<info>, method=PLAIN, rip=82.95.148.152, lip=1.2.3.4, TLS, session=<QylMqlLhVwBSX5SY> ------ Fail2ban is trying to catch them with this regex: ------ failregex = .*(?:pop3-login|imap-login):.*(?:Authentication failure|Aborted login \(auth failed|Aborted login \(tried to use disabled|Disconnected \(auth failed).*rip=(?P<host>\S*),.* ------ This way fail2ban is counting 22 attempts as 1 attempt... I expect I need to change something on the logging, so that every attempt is seperate logged. But I don't know how. Is here somebody who knows how to get fail2ban correct working? No help on this on the wiki's: http://wiki1.dovecot.org/HowTo/Fail2Ban http://wiki1.dovecot.org/Logging http://www.fail2ban.org/wiki/index.php/Dovecot With regards, Paul van der Vlis. -- Paul van der Vlis Linux systeembeheer, Groningen http://www.vandervlis.nl/

2 4

[Dovecot] plugin expire
by Felix Rubio Dalmau 17 Jul '13

17 Jul '13

Hi everybody, I'm trying to configure the expire plugin, unsuccessfully. This is my configuration, the part related to this plugin. Could somebody give a look to it? I can not figure out why is not working :-S. Thank you, and regards! Felix ############ doveconf output dict { expire = mysql:/etc/dovecot/dovecot-dict-expire.conf.ext } plugin { expire = Trash 15 Junk 15 expire_dict = proxy::expire } protocol imap { mail_plugins = " zlib expire" } ########### dovecot-dict-expire.conf.ext # CREATE TABLE virtual_expires ( # username varchar(100) not null, # mailbox varchar(255) not null, # expire_stamp integer not null, # primary key (username, mailbox) # ); map { pattern = shared/expire/$user/$mailbox table = virtual_expires value_field = expire_stamp fields { username = $user mailbox = $mailbox } }

1 0

[Dovecot] courier to dovecot
by J Gao 16 Jul '13

16 Jul '13

Hi, All, I am new here and I need your advises. Here is my story: I have a mail server like this: - CentOS 5 32 bit (LAMP) - Postfix 2.3 - Courier - MailScanner Courier use maildir to save emails in /home/vmail/<virtual domain>/<user> / Now I want to build a new system on CentOS 6.4 64bit with postfix, dovecot and migrate all user accounts and their emails. I already installed CentOS 6.4, postfix and mysql. Also just installed Dovecot v2.2.4 from the RPM. Now I am looking into how to Is there a good instruction on how to do this kind of migration? I still prefer using the maildir system. If I just copy all users email from old server to new dovecot user maildir, will dovecot see these mails (and sub-folders) ? Do I need do anything extra? Thanks in advance. Gao -- __ _|==|_ ('')__/ >--(`^^') (`^'^'`) `======'

3 2

[Dovecot] reload without shutting imap connections down
by Hajo Locke 16 Jul '13

16 Jul '13

Hello, we have some problems with users who report connectionproblems to dovecot sometimes. According to the logs there are dovecot reloads at this times. Seems that a reload also causes dovecot to shut all imapconnections down: Jul 16 13:31:40 myhostname dovecot: master: Warning: SIGHUP received - reloading configuration Jul 16 13:31:40 myhostname dovecot: imap: Server shutting down. bytes=251/675 I tried to reload by initscript or sending -HUP manually to pid, dovecot is shutting down imapconnections and i think this is the reason for users to report this problems with some clients. This seems to be new with versions 2.x, i have some old 1.2.x dovecots running and cant find "Server shutting down" in their logs after reload. I have still potential to reduce reloads, but cant avoid them completely. Is there a workaround? Thanks, Hajo

4 6

[Dovecot] Difference between using auth_realms and setting up virtual mailboxes in postfix?
by Gab IIpop 16 Jul '13

16 Jul '13

Hi, there is a possibility in the future that I might have to support multiple domain names(but using the same IP address). Postfix has something called 'virtual mailboxes' to help handle this. But I also noticed that dovecot has a setting "auth_realms" where I can specify domains separated by a space. What is the relationship between the two?

2 1

[Dovecot] mail not reject when the mailbox is full (Dovecot-LDAP-Imap_quota)
by Victor Oñate 16 Jul '13

16 Jul '13

Hello List. Currently I have configured the share of users through the LDAP query as shown #dovecot.conf protocol imap { mail_plugins = quota imap_quota } plugin { quota = dirsize } userdb ldap { args = /etc/dovecot/dovecot-ldap.conf } #dovecot-ldap.conf auth_bind = yes ldap_version = 3 base = dc=XXX,dc=YY,dc=ZZ deref = never scope = subtree user_attrs = homeDirectory=home,uidNumber=uid,gidNumber=gid,mail=Maildir,mailQuotaSize=quota_rule=*:storage=%$ user_filter = (&(objectClass=posixAccount)(uid=%u)) pass_attrs = uid=user,userPassword=password,homeDirectory=userdb_home,uidNumber=userdb_uid,gidNumber=userdb_gid pass_filter = (&(objectClass=posixAccount)(uid=%u)) Additionally in thunderbird customers have the plug so they can see the share. This works perfect! However, when the mailbox exceeds 100% users continue to receive mail which makes the risk set allocated disk space, the idea is that when full the mail reject with a message "mailbox XXX full" . As always appreciate the ideas. Victor Oñate

4 4