September 2009 - dovecot

[Dovecot] inotify_init() failed: Function not implemented
by franc walter 09 Sep '09

09 Sep '09

Hello, i have in my mail.log some warnings: Sep 2 08:21:49 myserver dovecot: IMAP(me(a)myserver.tld): inotify_init() failed: Function not implemented how can i fix this? Thank you in advance, franc walter

2 1

[Dovecot] Server load while using Zlib compression
by Laurent CARON 09 Sep '09

09 Sep '09

Hi, I wonder if some users are using this plugin on production setups. If yes, how does it perform in terms of cpu load compared with the same setup without compression ? Thanks Laurent

2 1

[Dovecot] Using Dovecot code in a non-LGPL package
by Asheesh Laroia 08 Sep '09

08 Sep '09

Hi Timo (and all!), Venaktesh is a friend of mine working on a patch to the venerable Alpine mail reader so it can read Maildir format mailboxes on disk. Venkatesh wanted to know if he could use some code from Dovecot's lib-storage (safely opening/reading Maildirs, including accounting for NFS and ESTALE) and the UID->message mapping code. This way, Dovecot and Alpine would agree on how to handle UIDs for a given Maildir-format mailbox. Plus Alpine could benefit from the thought you've put into the safety of Maildirs on IMAP (which is *not* trivial!). But there are some possible licensing issues. Alpine (formerly known as PINE) is now licensed under the Apache License 2.0. As far as I can tell, if he wants to contribute a patch back to Alpine upstream, he should use use the Apache License 2.0. But Dovecot is licensed under LGPL 2.1; if he takes Dovecot code, modifies it, and mixes it with Alpine, that would not be allowed by the licenses together (as I understand it). The Apache License 2.0 is a permissive, non-copyleft license like the MIT License, but it adds a patent retaliation clause. See http://www.apache.org/licenses/LICENSE-2.0.html for its text and http://www.gnu.org/philosophy/license-list.html for a short statement of its compatibility with GPLv3; http://en.wikipedia.org/wiki/Apache_License#GPL_compatibility has a little more. License-wise, there are two choices, if you're willing Timo: the modified Dovecot code could be released under GPLv3, which *is* compatible with the Alpine license - it would just mean Alpine+Maildir would be GPLv3 when put together. Or you could grant a special permission to Venkatesh to distribute the modified Dovecot code under the Apache License 2.0. Timo (and others), what do you think? The past of least resistance is to say that a derivative work of Dovecot can be made using GPLv3; the most convenient would be to say that particular portions can be used under the Apache License 2.0. -- Asheesh. -- Why do we have two eyes? To watch 3-D movies with.

2 1

[Dovecot] Unusual IMAP config.
by S. A. Woltering 08 Sep '09

08 Sep '09

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi all, perhaps a silly question, perhaps an unusual one, I don't know. I'm trying to suss out how to set up Dovecot in such a way as to have two separate IMAP services running on the same system. To explain. We have an "internally-facing" IMAP and an "externally-facing" one. It's policy that anyone connecting to IMAP from outside uses a stronger authentication method than the default internal one. The current system uses the standard imap/imaps ports for internal auth, but a different port-pair for external access. (actually it's a bit more complex than that, but that's all I really need to go into for this exercise!) So, for example, I'd like to kick off a test rig that uses IMAP on port 143 using a standard password (file or NIS) auth and to set up another on port, say 144 using PAM. Can this be done within one single dovecot.conf, or should I be running two separate daemons? Thanks, SAW - -- Steven-Ashley Woltering, MBCS, Systems Analyst, ECMWF, Shinfield Park, Reading, RG2 9AX, UK Tel.: +44 1189 499473 (internal x2473) Email: Steven.Woltering(a)ecmwf.int -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.4-svn0 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iD8DBQFKpjdxh854NVK99FMRAse8AJ4q75TxZtCUNk1jN8cTty15a33jQwCePV+i YU8JCcM9rSsQ86Xfu4Zwe1A= =lB1D -----END PGP SIGNATURE-----

2 2

Re: [Dovecot] Solr Plugin make only INBOX able to search
by rui.carneiro＠portugalmail.net 07 Sep '09

07 Sep '09

Hi again, Anyone could help me?

1 0

[Dovecot] Problems with Dovecot 1.1.16 and MS A.D.
by Vinicius Abrahao 07 Sep '09

07 Sep '09

Hello dear fellows, I'm trying to integrate my dovecot (version 1.1.16) but it's not working anyway. The test that I'm doing is simple: # telnet mail.unimetro.net 110 Trying 192.168.20.4... Connected to mail.unimetro.net. Escape character is '^]'. +OK Unimetro Mailserver Ready. user bindmail +OK pass xxxxxxx123 Connection closed by foreign host. At /var/log/dovecot.log I see these lines: dovecot: Aug 12 14:55:43 Info: dovecot v1.1.16 starting up dovecot: Aug 12 14:59:46 Error: auth(default): re_encode_request new request is: dovecot: Aug 12 14:59:46 Error: auth(default): re_encode_request new request is: dovecot: Aug 12 14:59:46 Error: auth(default): re_encode_request new request is: dovecot: Aug 12 15:02:46 Info: pop3-login: Disconnected: Inactivity (auth failed, 1 attempts): method=PLAIN, rip=192.168.20.4, lip=192.168.20.4, secured dovecot: Aug 12 15:06:57 Error: auth(default): ldap(postmaster): Connection appears to be hanging, reconnecting dovecot: Aug 12 15:06:57 Error: auth(default): re_encode_request new request is: dovecot: Aug 12 15:06:57 Error: auth(default): re_encode_request new request is: dovecot: Aug 12 15:06:57 Error: auth(default): re_encode_request new request is: dovecot: Aug 12 15:06:57 Error: auth(default): ldap(postmaster): Connection appears to be hanging, reconnecting dovecot: Aug 12 15:06:57 Error: auth(default): re_encode_request new request is: dovecot: Aug 12 15:06:57 Error: auth(default): re_encode_request new request is: dovecot: Aug 12 15:06:57 Error: auth(default): re_encode_request new request is: dovecot: Aug 12 15:06:57 Error: auth(default): ldap(bindmail,192.168.20.4): ldap_search((&(ObjectClass=person)(sAMAccountName=bindmail)(memberOf=CN=UMAMAIL,OU=Groups,DC=unimetro,DC=net))) failed: Operations error dovecot: Aug 12 15:06:57 Error: auth(default): re_encode_request new request is: dovecot: Aug 12 15:06:57 Error: auth(default): re_encode_request new request is: dovecot: Aug 12 15:06:57 Error: auth(default): re_encode_request new request is: Some times, with the same test these lines appears: dovecot: Aug 11 10:31:04 Error: auth(default): re_encode_request new request is: dovecot: Aug 11 10:31:04 Error: auth(default): re_encode_request new request is: dovecot: Aug 11 10:31:04 Error: auth(default): ldap(bindmail,192.168.20.4): ldap_search((&(ObjectClass=person)(sAMAccountName=bindmail) (memberOf=CN=UMAMAIL,OU=Groups,DC=unimetro,DC=net))) failed: Operations error dovecot: Aug 11 10:31:04 Error: auth(default): re_encode_request new request is: dovecot: Aug 11 10:31:04 Error: auth(default): re_encode_request new request is: dovecot: Aug 11 10:31:04 Error: auth(default): re_encode_request new request is: dovecot: Aug 11 10:31:06 Info: pop3-login: Disconnected (auth failed, 1 attempts): user=<bindmail>, method=PLAIN, rip=192.168.20.4, lip=192.168.20.4, secured dovecot: Aug 11 10:34:10 Info: pop3-login: Disconnected: Inactivity (auth failed, 1 attempts): user=<bindmail>, method=PLAIN, rip=192.168.20.4, lip=192.168.20.4, secured dovecot: Aug 11 10:35:17 Panic: auth(default): file aqueue.c: line 69 (aqueue_delete): assertion failed: (n < count) dovecot: Aug 11 10:35:17 Error: child 1579 (auth) killed with signal 6 (core not dumped) dovecot: Aug 11 10:38:17 Info: pop3-login: Disconnected: Inactivity (auth failed, 1 attempts): method=PLAIN, rip=192.168.20.4, lip=192.168.20.4, secured dovecot: Aug 11 10:50:32 Error: auth(default): ber_get_next failed. dovecot: Aug 11 10:50:32 Error: auth(default): LDAP: Connection lost to LDAP server, reconnecting dovecot: Aug 11 10:54:53 Error: auth(default): re_encode_request new request is: dovecot: Aug 11 10:54:53 Error: auth(default): re_encode_request new request is: dovecot: Aug 11 10:54:53 Error: auth(default): re_encode_request new request is: Attached are my confs. I'm running at a FreeBSD 7.2 BOX. # pkg_info | egrep "dovecot|postfix|ldap" apr-ipv6-gdbm-db42-ldap-mysql-pgsql-1.3.8.1.3.9 Apache Portability Library dovecot-1.1.16 Secure and compact IMAP and POP3 servers dovecot-sieve-1.1.6 A Sieve plugin for the Dovecot 'deliver' LDA openldap-client-2.4.17 Open source LDAP client implementation postfix-2.6.2_1,1 A secure alternative to widely-used Sendmail And I have success using ldapsearch to access the MS A.D with: /usr/local/bin/ldapsearch -v -x -h 192.168.20.3 -D "CN=bindmail,CN=Users,DC=unimetro,DC=net" -w xxxxx123 -b "dc=unimetro, dc=net" Thanks for your time! Best regards, Vinícius Schmidt

2 1

[Dovecot] avoiding DoS
by David Halik 07 Sep '09

07 Sep '09

Hi, I was just looking for some advice on avoiding getting DoS'd from brute force log in attempts. We came in this morning to find that one of our Solaris 9 dovecot severs had wedged overnight due to a brute force connection attempt to pop3 from Brasil. In the span of about 15 seconds we received 342 connection auth attempts from the same IP: Sep 3 00:10:51 xxxxx dovecot: [ID 583609 mail.info] auth(default): new auth connection: pid=16862 Sep 3 00:10:51 xxxxx dovecot: [ID 583609 mail.info] auth(default): new auth connection: pid=16863 Sep 3 00:10:51 xxxxx dovecot: [ID 583609 mail.info] pop3-login: Login failed: Plaintext authentication disabled: rip=189.99.178.15, lip=xxxxx Sep 3 00:10:51 xxxxx dovecot: [ID 583609 mail.info] pop3-login: Aborted login (tried to use disabled plaintext auth): rip=189.99.178.15, lip=xxxxx Dovecot finally wedged silently and without complaint, becoming completely unresponsive. I had to kill -9 it this morning in order to restart the service. Once possibility I considered was that the dovecot user process limit was reached, but this is set to 1024, and I didn't see any errors or warnings anywhere in the logs. login_max_processes_count = 256 max_mail_processes = 1024 With the above I would think it would have been able to handle it gracefully, but apparently it did not. ulimit -n 2048 is also set on dovecot startup for the fd limit. Any suggestions on what I could tweak to prevent this from happening in the future? dovecot -n output: Note I upgraded to 1.2.4 this morning while it was already down. We were running either 1.2.0 or 1.2.1 last night, sorry didn't think to check first. ;) bash-2.05# ulimit -n 2048; dovecot -n # 1.2.4: /usr/local/etc/dovecot.conf # OS: SunOS 5.9 sun4u protocols: imap imaps pop3 pop3s ssl_cert_file: /usr/local/ssl/certs/nbcs.key+crt.pem ssl_key_file: /usr/local/ssl/certs/nbcs.key+crt.pem login_dir: /usr/local/var/run/dovecot/login login_executable(default): /usr/local/libexec/dovecot/imap-login login_executable(imap): /usr/local/libexec/dovecot/imap-login login_executable(pop3): /usr/local/libexec/dovecot/pop3-login login_max_processes_count: 256 max_mail_processes: 1024 mail_location: maildir:~/Maildir:INDEX=/toolbox/nqu%h/dovecot:CONTROL=/toolbox/nqu%h/dovecot mmap_disable: yes mail_nfs_storage: yes mail_nfs_index: yes mail_executable(default): /usr/local/libexec/dovecot/imap mail_executable(imap): /usr/local/libexec/dovecot/imap mail_executable(pop3): /usr/local/libexec/dovecot/pop3 mail_plugins(default): quota imap_quota fts fts_squat mail_plugins(imap): quota imap_quota fts fts_squat mail_plugins(pop3): quota mail_plugin_dir(default): /usr/local/lib/dovecot/imap mail_plugin_dir(imap): /usr/local/lib/dovecot/imap mail_plugin_dir(pop3): /usr/local/lib/dovecot/pop3 pop3_uidl_format(default): %08Xu%08Xv pop3_uidl_format(imap): %08Xu%08Xv pop3_uidl_format(pop3): UID%u-%v namespace: type: private separator: . prefix: INBOX. inbox: yes list: yes subscriptions: yes lda: postmaster_address: postmaster(a)jla.rutgers.edu auth default: verbose: yes debug: yes passdb: driver: pam args: * userdb: driver: passwd plugin: quota: fs fts: squat fts_squat: partial=4 full=4 -- ================================ David Halik System Administrator OIT-CSS Rutgers University dhalik(a)jla.rutgers.edu ================================

4 3

[Dovecot] assertion failed while using sieve
by Maciej Uhlig 07 Sep '09

07 Sep '09

Hi, there is a line in TODO: "- sieve-cmu.c crash: i_assert(buf->used - 1 == part->body_size.physical_size); ". Yes, we've really seen this crash. Therefore we upgraded to dovecot-1.2.3 with dovecot-1.2-sieve-0.1.11 in order to use sieve plugin (i.e. not cmu-sieve). We use Solaris 10 on Sun servers, we don't use NFS. However, unfortunately, dovecot with sieve crashes too. Here is dovecot log excerpt: 2009-09-01T02:40:57+02:00 prac/prac dovecot: [ID 583609 mail.crit] deliver(id@domain): Panic: file ext-body-common.c: line 149: assertion failed: (buf->used - 1 == part->body_size.physical_size) 2009-09-01T02:40:57+02:00 prac/prac dovecot: [ID 583609 mail.crit] deliver(id@domain): Panic: file ext-body-common.c: line 149: assertion failed: (buf->used - 1 == part->body_size.physical_size) 2009-09-01T02:40:57+02:00 prac/prac dovecot: [ID 583609 mail.error] deliver(id@domain): Raw backtrace: 0xbd27c -> 0xfead33b0 -> 0xfead358c -> 0xfead396c -> 0xfead4a78 -> 0xfeaa19dc -> 0xfeaa1abc -> 0xfeaa1c38 -> 0xfeabf22c -> 0xfeabf520 -> 0xfea90b20 -> 0xfea91048 -> 0xfea91404 -> 0x26e58 -> 0x23778 Now, some background. We use a sieve script with >>require "body"<<. This script compiles correctly and more, it works correctly while named as >>id(a)domain.sieve<< or >>id(a)domain.svbin". Nevertheless while the very same script is defined in plugin section of dovecot conf as "sieve = script" or "sieve_before = script" or "sieve_after = script" then dovecot crashes. I consider it as an important hint for problem resolution. Moreover, not every mail is affected, but we didn't investigate which mails are correctly saved to inbox and which crash. The effect is, we're not able to implement global sieve policies which is bad because we really need them :-). We'd than be happy to test fixes, if any. Best regards, MU

2 4

[Dovecot] dovecot-auth segfault with vpopmail 5.5.0 on amd64
by Lawrence 07 Sep '09

07 Sep '09

Seeing dovecot-auth segfault on amd64 dovecot is 1.2.4 pertinent details below: ldd /usr/local/libexec/dovecot/dovecot-auth linux-vdso.so.1 => (0x00007fffef1fe000) libcrypt.so.1 => /lib/libcrypt.so.1 (0x00007fe8e6bae000) libvpopmail.so => /usr/lib/libvpopmail.so (0x00007fe8e6986000) libdl.so.2 => /lib/libdl.so.2 (0x00007fe8e6782000) librt.so.1 => /lib/librt.so.1 (0x00007fe8e657a000) libc.so.6 => /lib/libc.so.6 (0x00007fe8e6229000) /lib64/ld-linux-x86-64.so.2 (0x00007fe8e6de6000) libpthread.so.0 => /lib/libpthread.so.0 (0x00007fe8e600e000) dovecot -n # 1.2.4: /etc/dovecot/dovecot.conf # OS: Linux 2.6.26-1-amd64 x86_64 Debian squeeze/sid base_dir: /var/run/dovecot log_path: /var/log/dovecot.log listen: 127.0.0.1:143 ssl_listen: *:993 ssl_cert_file: /var/qmail/control/servercert.pem ssl_key_file: /var/qmail/control/clientcert.pem disable_plaintext_auth: no login_dir: /var/run/dovecot/login login_executable: /usr/local/libexec/dovecot/imap-login login_greeting: Computer Solutions IMAP Server login_max_connections: 4096 mail_max_userip_connections: 50 first_valid_uid: 89 first_valid_gid: 89 mail_debug: yes mail_drop_priv_before_exec: yes mail_plugins: quota imap_quota imap_client_workarounds: outlook-idle namespace: type: private prefix: INBOX. inbox: yes list: yes subscriptions: yes auth default: user: vpopmail passdb: driver: vpopmail userdb: driver: vpopmail plugin: quota: maildir this is the strace 16:59:30.529067 epoll_wait(7, {}, 7, 1788) = 0 16:59:32.317110 epoll_wait(7, {{EPOLLIN, {u32=17196288, u64=17196288}}}, 7, 5000) = 1 16:59:34.777612 read(8, "AUTH\t1\tPLAIN\tservice=imap\tsecured"..., 4074) = 134 16:59:34.777750 --- SIGSEGV (Segmentation fault) @ 0 (0) --- and from a core dump gdb /usr/local/libexec/dovecot/dovecot-auth ./core GNU gdb (GDB) 6.8.50.20090628-cvs-debian 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 "x86_64-linux-gnu". For bug reporting instructions, please see: <http://www.gnu.org/software/gdb/bugs/>... warning: Can't read pathname for load map: Input/output error. Reading symbols from /lib/libcrypt.so.1...done. Loaded symbols for /lib/libcrypt.so.1 Reading symbols from /usr/lib/libvpopmail.so...done. Loaded symbols for /usr/lib/libvpopmail.so Reading symbols from /lib/libdl.so.2...done. Loaded symbols for /lib/libdl.so.2 Reading symbols from /lib/librt.so.1...done. Loaded symbols for /lib/librt.so.1 Reading symbols from /lib/libc.so.6...done. Loaded symbols for /lib/libc.so.6 Reading symbols from /lib64/ld-linux-x86-64.so.2...done. Loaded symbols for /lib64/ld-linux-x86-64.so.2 Reading symbols from /lib/libpthread.so.0...done. Loaded symbols for /lib/libpthread.so.0 Reading symbols from /lib/libnss_compat.so.2...done. Loaded symbols for /lib/libnss_compat.so.2 Reading symbols from /lib/libnsl.so.1...done. Loaded symbols for /lib/libnsl.so.1 Reading symbols from /lib/libnss_nis.so.2...done. Loaded symbols for /lib/libnss_nis.so.2 Reading symbols from /lib/libnss_files.so.2...done. Loaded symbols for /lib/libnss_files.so.2 Core was generated by `dovecot-auth'. Program terminated with signal 11, Segmentation fault. #0 0x0000000000000000 in ?? () (gdb) (gdb) bt full #0 0x0000000000000000 in ?? () No symbol table info available. #1 0x000000000041eb2d in vpopmail_lookup_vqp (request=0x1ae6548, vpop_user=0x7fff7a044830 "lawrence", vpop_domain=0x7fff7a0447d0 "shanghaiguide.com") at userdb-vpopmail.c:43 vpw = <value optimized out> #2 0x000000000041c9c6 in vpopmail_password_lookup (auth_request=0x7fff7a044830, cleartext=false, result_r=0x7fff7a0448d4) at passdb-vpopmail.c:65 vpop_user = "lawrence", '\0' <repeats 72 times> vpop_domain = "shanghaiguide.com", '\0' <repeats 63 times> vpw = <value optimized out> password = <value optimized out> #3 0x000000000041cc0d in vpopmail_verify_plain (request=0x7fff7a044830, password=0x1ad1278 "123", callback=0x412390 <auth_request_verify_plain_callback>) at passdb-vpopmail.c:119 result = <value optimized out> scheme = <value optimized out> tmp_pass = <value optimized out> crypted_pass = <value optimized out> ret = <value optimized out> #4 0x000000000041221d in auth_request_verify_plain (request=0x1ae6548, password=0x1ad1278 "123", callback=0x41ab00 <plain_verify_callback>) at auth-request.c:507 passdb = 0x1ad9a10 result = <value optimized out> cache_key = <value optimized out> __PRETTY_FUNCTION__ = "auth_request_verify_plain" #5 0x000000000041726e in mech_plain_auth_continue (request=0x1ae6548, data=0x1ad1250 "", data_size=<value optimized out>) at mech-plain.c:58 authid = 0x1ad1250 "" authenid = 0x1ad1251 "lawrence(a)shanghaiguide.com" error = <value optimized out> pass = 0x1ad1278 "123" i = <value optimized out> count = <value optimized out> #6 0x0000000000412c12 in auth_request_handler_auth_begin (handler=0x1ae18a8, args=<value optimized out>) at auth-request- handler.c:388 mech = <value optimized out> request = 0x1ae6548 list = 0x1ad1110 name = <value optimized out> arg = 0x1ad1218 "P\22\255\1" initial_resp = 0x1ad109c "AGxhd3JlbmNlQHNoYW5naGFpZ3VpZGUuY29tADEyMw==" initial_resp_len = 4428754 id = <value optimized out> buf = 0x1ad1218 #7 0x000000000040e2d6 in auth_client_handle_line (conn=0x1ae01f0) at auth-client-connection.c:174 No locals. #8 auth_client_input (conn=0x1ae01f0) at auth-client-connection.c:250 ---Type <return> to continue, or q <return> to quit--- _data_stack_cur_id = 3 line = 0x1ae0866 "AUTH\t1\tPLAIN\tservice=imap\tsecured \tlip = 127.0.0.1 \trip = 127.0.0.1 \tlport =993\trport=42735\tresp=AGxhd3JlbmNlQHNoYW5naGFpZ3VpZGUuY29tADEyMw==" ret = 2 #9 0x0000000000429e8b in io_loop_handler_run (ioloop=<value optimized out>) at ioloop-epoll.c:208 ctx = 0x1ad9fe0 event = 0x1adca40 list = 0x1ae0500 io = 0x1ae04c0 tv = {tv_sec = 4, tv_usec = 999952} t_id = 2 msecs = <value optimized out> ret = 1 call = <value optimized out> #10 0x0000000000429318 in io_loop_run (ioloop=0x1ad9350) at ioloop.c:335 No locals. #11 0x0000000000416aae in main (argc=<value optimized out>, argv=<value optimized out>) at main.c:347 foreground = false

2 2

[Dovecot] local delivery agent
by legionaer85 07 Sep '09

07 Sep '09

Hey, i've got a problem with my lda and exim, probably i assume that it's dovecot. I think that, because i get an error in exim: T=dovecot_delivery: Child process of dovecot_delivery transport returned 67 (could mean user nonexistent) from command: /usr/lib/dovecot/deliver in exim i use /usr/lib/dovecot/deliver -d <name>@<domain>.<tld> -f <name>@<domain>.<tld> So, i tried to focus the error and thought there is not the right argument for delivery. But i couldn't get any hints about the arguments for the deliver agent. Exim gives me a complete string which is 'name(a)domain.ltd' Now my question. How parses the deliver agent this string? Splits it into variables? If yes... to which ones? name and domain? Thanks a lot for any answers. =>dovecot --version 1.0.rc15 ------ =>dovecot -n # /etc/dovecot/dovecot.conf log_path: /var/log/dovecot/main.log info_log_path: /var/log/dovecot/info.log log_timestamp: %Y-%m-%d %H:%M:%S ssl_cert_file: /etc/ssl/certs/ssl_cert.crt ssl_key_file: /etc/ssl/certs/ssl.key login_dir: /var/run/dovecot/login login_executable: /usr/lib/dovecot/imap-login login_user: vmail login_greeting: <servername> Mailserver ready. verbose_proctitle: yes first_valid_uid: 8 last_valid_uid: 8 mail_privileged_group: mail mail_location: dbox:/var/spool/mail/%d/%n mail_debug: yes auth default: user: mail passdb: driver: sql args: /etc/dovecot/dovecot-sql.conf userdb: driver: prefetch socket: type: listen client: path: /var/run/dovecot/auth-client mode: 384 user: mail group: mail master: path: /var/run/dovecot/auth-master mode: 384 user: mail group: mail --------- =>grep -v '^ *$#.*$\?$' /etc/dovecot/dovecot-sql.conf driver = mysql connect = host=<host> dbname=<dbname> user=<user> password=<pass> default_pass_scheme = PLAIN password_query = SELECT password, '/var/mail/%d/%n' AS userdb_home, 'mail' AS userdb_uid, 'mail' AS userdb_gid FROM user WHERE username = '%n' AND domain = '%d' AND IMAP_allowed = 'YES' user_query = SELECT username, uid, gid FROM user WHERE username = '%n' AND domain = '%d' --------- in the db i have the user table columns: username, domain, password

3 2