- dovecot - dovecot.org

[Dovecot] Error: User doesn't have home dir set, disabling duplicate database
by fila＠pruda.com 30 Dec '10

30 Dec '10

Hello, I have found this message in logs. But delivering is working. Error: User peter(a)mydomain.cz doesn't have home dir set, disabling duplicate database doveconf -n # 2.0.8: /etc/dovecot/dovecot.conf # OS: Linux 2.6.32-lts i686 ext3 auth_mechanisms = plain login disable_plaintext_auth = no mail_location = maildir:/home/vmail/%u 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 passdb { args = /etc/dovecot/dovecot-sql.conf.ext driver = sql } plugin { home = /home/vmail/%u sieve = /home/vmail/%u/dovecot.sieve sieve_global_path = /home/vmail/dovecot-global.sieve } postmaster_address = postmaster(a)mydomain.cz protocols = imap pop3 service auth { unix_listener auth-userdb { group = vmail mode = 0660 user = vmail } } ssl_cert = </etc/ssl/dovecot/cert.pem ssl_key = </etc/ssl/dovecot/key.pem userdb { args = /etc/dovecot/dovecot-sql.conf.ext driver = sql } protocol lda { mail_plugins = sieve } I have googled little bit. According to this article http://wiki2.dovecot.org/VirtualUsers/Home I think the problem is: mail_location = maildir:/home/vmail/%u and plugin { home = /home/vmail/%u } is the same directory. Is it right? Is the solution to set mail_location = maildir:/home/vmail/mail/%u ? -- Best regards Filip

2 2

[Dovecot] IMAP messages not being marked read
by void372＠transientvoid.com 30 Dec '10

30 Dec '10

I recently moved from Fedora 13 to Fedora 14 and consequently to dovecot 2.0.8. Since then, I have observed that messages are not being marked as read in all cases. The general behavior is: 1. Use my mail client to read all unseen messages. All mail folders show no messages unread. 2. Tell mail client to check for new mail. 3. Mail client now says that some folders have new mail (1 or more messages) 4. Clicking on a folder with new mail (say with 6 unread) shows that there are no unread messages. I have observed this behavior using both kmail and squirrelmail so do not believe it is a mail client problem. I have maildir folders to which mail is delivered using procmail recipes directly to the appropriate dovecot folder. In these folders, I notice that the "cur" directory has a matching number of messages that do not have an "S" flag on the end of the file name. For example: # ls .fedora-list/ cur/ dovecot.index.log new/ dovecot.index.cache dovecot-uidlist tmp/ # ls .fedora-list/cur 1293379204.26554_1.nehalem.home.rainbowdreams.com:2,S 1293379206.26571_1.nehalem.home.rainbowdreams.com:2, 1293379207.26581_1.nehalem.home.rainbowdreams.com:2, 1293380106.26744_1.nehalem.home.rainbowdreams.com:2, 1293380106.26748_1.nehalem.home.rainbowdreams.com:2,S 1293381904.26876_1.nehalem.home.rainbowdreams.com:2,S 1293383704.26978_1.nehalem.home.rainbowdreams.com:2,S 1293384604.27005_1.nehalem.home.rainbowdreams.com:2,S 1293385504.27067_1.nehalem.home.rainbowdreams.com:2,S 1293386404.27105_1.nehalem.home.rainbowdreams.com:2,S 1293387305.27158_1.nehalem.home.rainbowdreams.com:2, 1293387305.27166_1.nehalem.home.rainbowdreams.com:2, 1293388204.27193_1.nehalem.home.rainbowdreams.com:2, 1293389105.27234_1.nehalem.home.rainbowdreams.com:2,S 1293390005.27292_1.nehalem.home.rainbowdreams.com:2,S 1293390006.27298_1.nehalem.home.rainbowdreams.com:2,S 1293392706.27400_1.nehalem.home.rainbowdreams.com:2,S 1293392706.27406_1.nehalem.home.rainbowdreams.com:2,S 1293393611.27515_1.nehalem.home.rainbowdreams.com:2,S 1293396304.27673_1.nehalem.home.rainbowdreams.com:2,S 1293396305.27675_1.nehalem.home.rainbowdreams.com:2,S 1293398104.27743_1.nehalem.home.rainbowdreams.com:2,S 1293399003.27966_1.nehalem.home.rainbowdreams.com:2,S I have so far been unable to observe a pattern as to which messages get affected. I made the assumption that perhaps the issue is a conversion issue in my existing maildir folders, but this does not appear to be the case. When I moved the existing directory out of the way and started with a fresh empty directory the issue has come back after a day or two. Unfortunately, my install of Fedora 14 overlaid the partition with Fedora 13, so I cannot confirm the version of dovecot I was using with no issues. (so very glad I use separate disk and partition for the OS!) I can say that all configuration was in one dovecot.conf file, not the multiple conf.d files I see on Fedora 14. Any assistance on what to troubleshoot next is greatly appreciated! The info about my dovecot is shown below. The maildir's are on local LVM/RAID and not remote. Thanks!! # dovecot -n # 2.0.8: /etc/dovecot/dovecot.conf # OS: Linux 2.6.35.10-72.fc14.x86_64 x86_64 Fedora release 14 (Laughlin) ext3 disable_plaintext_auth = no mail_debug = yes mail_location = maildir:/vg02/mail/%u mbox_write_locks = fcntl passdb { driver = pam } plugin { mail_log_events = delete undelete expunge copy mailbox_delete mailbox_rename flag_change append mail_log_fields = uid box msgid size flags } ssl_cert = </etc/pki/dovecot/certs/dovecot.pem ssl_key = </etc/pki/dovecot/private/dovecot.pem userdb { driver = passwd } # dovecot --version 2.0.8

2 2

[Dovecot] Dovecot consulting companies
by Timo Sirainen 30 Dec '10

30 Dec '10

Once in a while someone asks about companies who could help installing / running / etc. their mail server. I don't really know many, so I thought I'd add a wiki page about it. Feel free to add your company on the list if you offer some Dovecot related services. Write also a few words what type of services you offer. http://wiki2.dovecot.org/Consulting I'll add a link there once at least one company is listed. :) Oh and if it's not clear above, I don't mean that the list should contain companies that only offer email accounts (Dovecot or not).

1 0

[Dovecot] Reverting from 2.0. to 1.2
by Thomas Hummel 30 Dec '10

30 Dec '10

Hello Timo, I switched this morning from dovecot-1.2.12 to 2.0.8 with a basic setup (high performance login mode, Maildir, everyhing on NFS, one shared but unused namespace). No problem so far except that some Thunderbird users who wouldn't succeed in moving messages from some one folder to another. They'd get a message about some illegal character in the mailboxname (already existing mailbox of course). This is user input so I don't have any details nor sufficient element to consider it a real problem. A Thunderbird restart seems to solve the problem. My questions were : . is there a different handling in the hierarchy separator (internal or advertized for the namespace) ? (I use "/" for both namespaces and "." since in Maildir). . is there a different handling in the non-ASCII mailbox names ? Could it be related ? . if something goes really wrong, is it safe to revert to 1.2.12 ? Maybe some files has non-compatible format (dovecot-uidlist, indexes, ...) ? Thanks. -- Thomas Hummel | Institut Pasteur <hummel(a)pasteur.fr> | Pôle informatique - systèmes et réseau

3 14

[Dovecot] Fetch without setting flags
by Behrooz Afghahi 30 Dec '10

30 Dec '10

Hello, I'm customizing squirrelmail and I want to print a line from the message in front of the subject in mailbox listing (like gmail). the problem is, when I use 'FETCH {SOME_ID} BODY[]' the message gets marked as seen. How can I fetch without setting the senn flag ? Thanks Behrooz

3 2

[Dovecot] How incoming emails are routed to public shared mailboxes ?
by Frank Bonnet 30 Dec '10

30 Dec '10

Hello I'm setting up few public shared maiboxes ( maildir format ) but I'm wondering how are they routed into the right ? Does authorized users have to place them inside manually ? Could it be automated ? I'm stuck Thank for any infos

2 1

[Dovecot] over quota issue
by PA 30 Dec '10

30 Dec '10

I have a situation where if a user is over quota and sending through postfix I get an error, now this error only happens if the user is over quota, otherwise it works with no problem. However if sending using /usr/local/libexec/dovecot/dovecot-lda it works every time even if overquota, any ideas? I just can't seem to figure this one out. TIA, Paul Using mail command Dec 21 11:44:53 testip5 dovecot: lda(user2(a)virttest1.meganet.net): Panic: stream doesn't support seeking backwards Dec 21 11:44:53 testip5 dovecot: lda(user2(a)virttest1.meganet.net): Error: Raw backtrace: /usr/local/lib/dovecot/libdovecot.so.0 [0xe660c0] -> /usr/local/lib/dovecot/libdovecot.so.0(i_syslog_fatal_handler+0x34) [0xe66164] -> /usr/local/lib/dovecot/libdovecot.so.0 [0xe65704] -> /usr/local/lib/dovecot/libdovecot.so.0 [0xe6f600] -> /usr/local/lib/dovecot/libdovecot.so.0(i_stream_seek+0x68) [0xe6cb68] -> /usr/local/lib/dovecot/libdovecot.so.0 [0xe6fda8] -> /usr/local/lib/dovecot/libdovecot.so.0(i_stream_read+0x7a) [0xe6cc3a] -> /usr/local/lib/dovecot/libdovecot.so.0(i_stream_read_data+0x2b) [0xe6ceab] -> /usr/local/lib/dovecot/libdovecot.so.0(message_parse_header_next+0x87) [0xe504a7] -> /usr/local/lib/dovecot/libdovecot.so.0 [0xe51d5e] -> /usr/local/lib/dovecot/libdovecot.so.0(message_parser_parse_next_block+0x43) [0xe51543] -> /usr/local/lib/dovecot/libdovecot.so.0(message_parser_parse_header+0x2f) [0xe5175f] -> /usr/local/lib/dovecot/libdovecot-storage.so.0(index_mail_parse_headers+0x10 1) [0x14bb51] -> /usr/local Dec 21 11:44:53 testip5 postfix/pipe[20848]: D1F46958166: to=<user2(a)virttest1.meganet.net>, relay=dovecot, delay=0.03, delays=0.01/0/0/0.02, dsn=4.3.0, status=deferred (Command died with signal 6: "/usr/local/libexec/dovecot/dovecot-lda") Or Dec 21 11:44:35 testip5 dovecot: dict: mysql: Connected to localhost (dovecotquota) Dec 21 11:44:35 testip5 dovecot: lda(user2(a)virttest1.meganet.net): Panic: stream doesn't support seeking backwards Dec 21 11:44:35 testip5 dovecot: lda(user2(a)virttest1.meganet.net): Error: Raw backtrace: /usr/local/lib/dovecot/libdovecot.so.0 [0xc230c0] -> /usr/local/lib/dovecot/libdovecot.so.0(i_syslog_fatal_handler+0x34) [0xc23164] -> /usr/local/lib/dovecot/libdovecot.so.0 [0xc22704] -> /usr/local/lib/dovecot/libdovecot.so.0 [0xc2c600] -> /usr/local/lib/dovecot/libdovecot.so.0(i_stream_seek+0x68) [0xc29b68] -> /usr/local/lib/dovecot/libdovecot.so.0 [0xc2cda8] -> /usr/local/lib/dovecot/libdovecot.so.0(i_stream_read+0x7a) [0xc29c3a] -> /usr/local/lib/dovecot/libdovecot.so.0(i_stream_read_data+0x2b) [0xc29eab] -> /usr/local/lib/dovecot/libdovecot.so.0(message_parse_header_next+0x87) [0xc0d4a7] -> /usr/local/lib/dovecot/libdovecot.so.0 [0xc0ed5e] -> /usr/local/lib/dovecot/libdovecot.so.0(message_parser_parse_next_block+0x43) [0xc0e543] -> /usr/local/lib/dovecot/libdovecot.so.0(message_parser_parse_header+0x2f) [0xc0e75f] -> /usr/local/lib/dovecot/libdovecot-storage.so.0(index_mail_parse_headers+0x10 1) [0x1afb51] -> /usr/local Dec 21 11:44:35 testip5 postfix/pipe[20848]: A2739958163: to=<user2(a)virttest1.meganet.net>, relay=dovecot, delay=0.07, delays=0.03/0.01/0/0.03, dsn=4.3.0, status=deferred (Command died with signal 6: "/usr/local/libexec/dovecot/dovecot-lda") Using dovecot-lda to send Dec 21 11:48:23 testip5 dovecot: dict: mysql: Connected to localhost (dovecotquota) Dec 21 11:48:23 testip5 dovecot: lda(user2(a)virttest1.meganet.net): msgid=unspecified: save failed to INBOX: Quota exceed, please email support for further assistance. Dec 21 11:48:23 testip5 dovecot: lda(user2(a)virttest1.meganet.net): msgid=unspecified: rejected: Quota exceed, please email support for further assistance. Postfix master: # Dovecot LDA dovecot unix - n n - - pipe flags=DRhu user=vmail:vmail argv=/usr/local/libexec/dovecot/dovecot-lda -f ${sender} -a ${recipient} -d ${user}@${nexthop} dovecot --version 2.0.8

2 2

[Dovecot] Dovecot 1.2.12+Postfix+Active Directory: virtual domain name dropped.
by Ran Talbott 30 Dec '10

30 Dec '10

I have a Windoze-only client who wants to move their mail hosting from godaddy.com hosting to an in-house system. I'm pitching Linux as an alternative to Exchange, and trying to set up a demonstration system for them. While a long-time Linux user, my server admin experience has been in setting up front-ends (mostly Apache-based web interfaces) for the embedded systems I specialize in. The goal is to have an IMAP server where the users don't have Linux IDs, and only need to manually login to the Active Directory domain controller. The client has multiple Internet domains, but all users are in the same Active Directory realm internally. With the help of the how-tos at linuxmail.info, I got the system to the point of being able to authenticate logins for both IMAP and SMTP (usng dovecot-SASL). I tried using PAM first, but it didn't work: running kinit from the command line takes over 90 seconds to get a ticket, and Dovecot timed out after 60 on every login attempt. So I switched to LDAP. Note: I still don't understand why, but authentication through Active Directory didn't work until I changed the querying distinguished name from the "cn=,dc=,dc=" format to "user(a)xxxx.local" format. I have Postfix using dovecot-deliver as the LDA, but I hit a snag: deliver is not putting the domain name in the path to the maildir. I have the active directory query set as: user_filter = (&(objectClass=user)(samaccountname=%n)) user_attrs = =home=/var/mailstore/%d/%n. =uid=501, =gid=501, \ =mail=maildir:/var/mailstore/%d/%n/Maildir/ When I send mail to testing.testing(a)xxxx.xxx (real domain obscured), I see this in mail.log Dec 23 10:49:24 IBMUBUNTU1 dovecot: auth(default): master in: USER#0111#011testing.testing(a)xxxx.xxx#011service=deliver Dec 23 10:49:24 IBMUBUNTU1 dovecot: auth(default): ldap(testing.testing): user search: base=dc=lawley, dc=local scope=subtree filter=(&(objectClass=user) (samaccountname=testing.testing)) fields= Dec 23 10:49:24 IBMUBUNTU1 dovecot: auth(default): ldap(testing.testing): result: objectClass(?unknown?)= cn(?unknown?)= sn(?unknown?)= givenName(?unknown?)= distinguishedName(?unknown?)= instanceType(?unknown?)= whenCreated(?unknown?)= whenChanged(?unknown?)= displayName(?unknown?)= uSNCreated(?unknown?)= uSNChanged(?unknown?)= name(?unknown?)= objectGUID(?unknown?)= userAccountControl(?unknown?)= primaryGroupID(?unknown?)= objectSid(?unknown?)= sAMAccountName(?unknown?)= sAMAccountType(?unknown?)= userPrincipalName(?unknown?)= objectCategory(?unknown?)= Dec 23 10:49:24 IBMUBUNTU1 dovecot: auth(default): master out: USER#0111#011testing.testing#011home=/var/mailstore//testing.testing. =uid=501#011gid=501#011mail=maildir:/var/mailstore//testing.testing/Maildir/ i.e., the domain does not appear in the paths to the home directory or maildir. I found a bug report in the mailing list that looks like it might be the same problem (%d not supported in user_attrs), but the fix it references is for 2.0. Is this a known problem in 1.x? Is there a fix/workaround for it? E.g., could I have Postfix generate the maidir path and pass it to deliver as the "-m" parameter? Thanks, Ran

2 1

[Dovecot] 'Doveadm user' could use better error codes
by Thomas Leuxner 30 Dec '10

30 Dec '10

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 - -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 The error codes for' doveadm user' should be improved to avoid error handling workarounds when scripting commands: $ doveadm user doveadm user [-a <userdb socket path>] [-x <auth info>] <user mask> […] $ echo $? 1 $ doveadm user foo userdb lookup: user foo doesn't exist $ echo $? 0 Please compare to ID output: $ id foo id: foo: No such user $ echo $? 1 Regards Thomas - -----BEGIN PGP SIGNATURE----- Version: GnuPG/MacGPG2 v2.0.16 (Darwin) iEYEARECAAYFAk0Z6FkACgkQ+meF/S97aXgxnQCfWk1ECdMoCewbr1O6lAkdksoH 324AoLCTg0dFmFhumEkM936irpcG7YF5 =wuwz - -----END PGP SIGNATURE----- -----BEGIN PGP SIGNATURE----- Version: GnuPG/MacGPG2 v2.0.16 (Darwin) iEYEARECAAYFAk0Z6HQACgkQ+meF/S97aXgGdACfawa02hZxk71CjIsj64sW0xXv CW8AoJRQZLFi4QwbvcDg6rzqzUv/3mE8 =Rt1O -----END PGP SIGNATURE-----

4 9

[Dovecot] doveadm quota get -u segmentation fault
by subscriber＠viliar.net.ru 30 Dec '10

30 Dec '10

Hello! I'm trying move to dovecot2 (centos 5.5, dovecot 2.0.8, dovecot compiled/packaged via edited dovecot2.spec from fedora git). Almost all fine, I can login via imap/pop3 and work with mail. I get segfault error with "doveadm quota get -u user" Here backtrace and other info: # gdb `which doveadm` core.5202 GNU gdb (GDB) Red Hat Enterprise Linux (7.0.1-23.el5_5.2) Copyright (C) 2009 Free Software Foundation, Inc. License GPLv3+: GNU GPL version 3 or later <http://gnu.org/licenses/gpl.html> This is free software: you are free to change and redistribute it. There is NO WARRANTY, to the extent permitted by law. Type "show copying" and "show warranty" for details. This GDB was configured as "i386-redhat-linux-gnu". For bug reporting instructions, please see: <http://www.gnu.org/software/gdb/bugs/>... Reading symbols from /usr/bin/doveadm...Reading symbols from /usr/lib/debug/usr/bin/doveadm.debug...done. done. Reading symbols from /usr/lib/dovecot/libdovecot-storage.so.0...Reading symbols from /usr/lib/debug/usr/lib/dovecot/libdovecot-storage.so.0.0.0.debug...done. done. Loaded symbols for /usr/lib/dovecot/libdovecot-storage.so.0 Reading symbols from /lib/libcrypt.so.1...(no debugging symbols found)...done. Loaded symbols for /lib/libcrypt.so.1 Reading symbols from /lib/libpam.so.0...(no debugging symbols found)...done. Loaded symbols for /lib/libpam.so.0 Reading symbols from /usr/lib/dovecot/libdovecot.so.0...Reading symbols from /usr/lib/debug/usr/lib/dovecot/libdovecot.so.0.0.0.debug...done. done. Loaded symbols for /usr/lib/dovecot/libdovecot.so.0 Reading symbols from /lib/libdl.so.2...(no debugging symbols found)...done. Loaded symbols for /lib/libdl.so.2 Reading symbols from /lib/librt.so.1...(no debugging symbols found)...done. Loaded symbols for /lib/librt.so.1 Reading symbols from /lib/libc.so.6...(no debugging symbols found)...done. Loaded symbols for /lib/libc.so.6 Reading symbols from /lib/libaudit.so.0...(no debugging symbols found)...done. Loaded symbols for /lib/libaudit.so.0 Reading symbols from /lib/ld-linux.so.2...(no debugging symbols found)...done. Loaded symbols for /lib/ld-linux.so.2 Reading symbols from /lib/libpthread.so.0...(no debugging symbols found)...done. Loaded symbols for /lib/libpthread.so.0 Reading symbols from /usr/lib/dovecot/lib10_quota_plugin.so...Reading symbols from /usr/lib/debug/usr/lib/dovecot/lib10_quota_plugin.so.debug...done. done. Loaded symbols for /usr/lib/dovecot/lib10_quota_plugin.so Reading symbols from /usr/lib/dovecot/doveadm/lib10_doveadm_quota_plugin.so...Reading symbols from /usr/lib/debug/usr/lib/dovecot/doveadm/lib10_doveadm_quota_plugin.so.debug...done. done. Loaded symbols for /usr/lib/dovecot/doveadm/lib10_doveadm_quota_plugin.so Core was generated by `doveadm quota get -u xxx@xxx'. Program terminated with signal 11, Segmentation fault. #0 0x00cc2b95 in cmd_quota_get_run (ctx=0x94dd3a8, user=0x94ee098) at doveadm-quota.c:52 52 array_foreach(&quser->quota->roots, root) (gdb) bt full #0 0x00cc2b95 in cmd_quota_get_run (ctx=0x94dd3a8, user=0x94ee098) at doveadm-quota.c:52 root__foreach_end = 0x94cd548 root = 0x94dec90 #1 0x0804f079 in doveadm_mail_next_user (ctx=0x94dd3a8, input=<value optimized out>, error_r=0xbffdf4e8) at doveadm-mail.c:220 service_user = 0x94debe0 error = <value optimized out> ret = 1 #2 0x0804f18c in doveadm_mail_single_user (ctx=0x94dd3a8, argv=0x94d51d4, username=0x94d51ed "xxx@xxx", service_flags=130) at doveadm-mail.c:246 input = {module = 0x0, service = 0x0, username = 0x94d51ed "xxx@xxx", local_ip = {family = 0, u = {ip6 = {in6_u = {u6_addr8 = '\000' <repeats 15 times>, u6_addr16 = {0, 0, 0, 0, 0, 0, 0, 0}, u6_addr32 = {0, 0, 0, 0}}}, ip4 = {s_addr = 0}}}, remote_ip = {family = 0, u = {ip6 = {in6_u = { u6_addr8 = '\000' <repeats 15 times>, u6_addr16 = {0, 0, 0, 0, 0, 0, 0, 0}, u6_addr32 = {0, 0, 0, 0}}}, ip4 = {s_addr = 0}}}, userdb_fields = 0x0, no_userdb_lookup = 0} error = <value optimized out> ret = <value optimized out> #3 0x0804f379 in doveadm_mail_cmd (cmd=0x94dc0d0, argc=3, argv=0x94d51d4) at doveadm-mail.c:418 service_flags = <value optimized out> ctx = 0x94dd3a8 getopt_args = 0x94cd2d0 "As:u:" username = 0x94d51ed "xxx@xxx" wildcard_user = 0x0 c = <value optimized out> #4 0x0804f6f8 in doveadm_mail_try_run_multi_word (cmd=0x94dc0d0, cmdname=0xcc2f18 "get", argc=4, argv=0x94d51c4) at doveadm-mail.c:453 No locals. #5 0x0804f7b7 in doveadm_mail_try_run (cmd_name=0x94d51e0 "quota", argc=4, argv=0x94d51c4) at doveadm-mail.c:476 cmd__foreach_end = 0x94dc0e8 cmd = 0x94dc0d0 cmd_name_len = 5 __FUNCTION__ = "doveadm_mail_try_run" #6 0x08053e11 in main (argc=Cannot access memory at address 0x14 ) at doveadm.c:344 cmd_name = 0x94d51e0 "quota" i = 134626935 quick_init = false c = <value optimized out> # 2.0.8: /etc/dovecot/dovecot.conf # OS: Linux 2.6.18-194.17.1.el5.028stab073.1 i686 CentOS release 5.5 (Final) simfs auth_mechanisms = plain login digest-md5 cram-md5 apop auth_socket_path = /var/run/dovecot/auth-userdb first_valid_gid = 5000 listen = * mail_location = maildir:/mail/%d/%n/maildir:INDEX=/mail/%d/%n/indexes 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 passdb { args = /etc/dovecot/dovecot-sql.conf.ext driver = sql } plugin { autocreate2 = virus autocreate3 = spam sieve = ~/.dovecot.sieve sieve_dir = ~/sieve } protocols = imap pop3 lmtp sieve sieve service auth-worker { user = root } service auth { unix_listener /var/spool/postfix/private/auth { group = postfix mode = 0660 user = postfix } } service imap-login { inet_listener imap { port = 143 } inet_listener imaps { port = 993 ssl = yes } } service lmtp { unix_listener /var/spool/postfix/private/dovecot-lmtp { group = postfix mode = 0660 user = postfix } } service managesieve-login { inet_listener sieve { port = 4190 } inet_listener sieve_deprecated { port = 2000 } } service pop3-login { inet_listener pop3 { port = 110 } inet_listener pop3s { port = 995 ssl = yes } } ssl_cert = </etc/pki/dovecot/certs/dovecot.pem ssl_key = </etc/pki/dovecot/private/dovecot.pem userdb { driver = prefetch } userdb { args = /etc/dovecot/dovecot-sql.conf.ext driver = sql } verbose_proctitle = yes protocol lmtp { mail_plugins = quota sieve } protocol lda { mail_plugins = quota sieve } protocol imap { mail_max_userip_connections = 10 mail_plugins = quota imap_quota autocreate } protocol sieve { mail_max_userip_connections = 3 } protocol pop3 { mail_max_userip_connections = 3 mail_plugins = quota } # grep -v '^ *$#.*$\?$' /etc/dovecot/dovecot-sql.conf.ext driver=sqlite connect = /etc/mailserver/mail.db default_pass_scheme = PLAIN user_query = SELECT '/mail/' || domain || '/' || mail || '/maildir' as home, uid, gid, '*:storage=' || quota || 'B' AS quota_rule FROM users WHERE mail || '@' || domain = '%u' password_query = SELECT mail || '@' || domain as user, password as password, '/mail/' || domain || '/' || mail || '/maildir' as userdb_home, uid as userdb_uid, gid as userdb_gid, 'maildir:storage=' || (quota/1024) as userdb_quota, nice as userdb_nice, hosts as allow_nets FROM users WHERE mail = '%n' and domain = '%d' and access = 'Y' and %Ls = 'Y';

2 1