- dovecot - dovecot.org

[Dovecot] MySQL Configuration
by Gerard Seibert 04 Nov '06

04 Nov '06

Dovecot 1.0.rc10 FreeBSD 6.1 This is probably a dumb question; however, I have never let a little thing like that bother me in the past. In the 'dovecot.conf' file there are the follow two sections: # SQL database passdb sql { # Path for SQL configuration file, see doc/dovecot-sql.conf for example args = /usr/local/etc/dovecot-sql.conf } userdb sql { # Path for SQL configuration file, see doc/dovecot-sql.conf for example args = /usr/local/etc/dovecot-sql.conf } I keep the 'users' and their respective 'passwords' in the same MySQL database. I am not sure why I wouldn't. Therefore, would it not make more sense to have just one MySQL configuration line in the 'dovecot.conf' file rather than two, or am I missing something here? -- Gerard Seibert gerard(a)seibercom.net Laws are like sausages. It's better not to see them being made. Otto von Bismarck

2 1

[Dovecot] auth-req-handler.c adds spurious tab
by Chris Laif 04 Nov '06

04 Nov '06

If the auth backend (postgresql in my case) returns extra fields, and all of these extra_fields begin with 'userdb_', the auth_callback functions adds an unwanted extra tab at the end of the response: auth(default): client out: OK^I8^Iuser=foo@bar^I This extra tab at the end confuses exim's dovecot-auth handler (the exim-dovecot auth handler does not correctly count the number of returned fields then (side note: the code on exim's side should probably be cleaned up as well)). A quick fix is attached below. Chris --- src/auth/auth-request-handler.c.orig 2006-11-03 13:10:35.000000000 +0100 +++ src/auth/auth-request-handler.c 2006-11-03 13:08:32.000000000 +0100 @@ -139,6 +139,10 @@ str_append(str, fields[src]); } } + + if (str_len(str) == 0) + return NULL; + return str_c(str); }

2 1

[Dovecot] mbox sync: Expunged message reappeared in mailbox
by Jim Garrison 04 Nov '06

04 Nov '06

Starting at 05:32 this morning, one user on my dovecot server is receiving hundreds of copies of old email. This is a short excerpt from my dovecot.log showing the problem: > dovecot: Nov 03 05:27:02 Info: pop3-login: Login: > user=<howard(a)obfusca.ted>, method=PLAIN, rip=::ffff:81.44.31.210, > lip=::ffff:zz.zz.zz.zz, TLS > dovecot: Nov 03 05:27:02 Info: POP3(howard(a)obfusca.ted): Disconnected: > Logged out top=0/0, retr=0/0, del=0/0, size=0 > dovecot: Nov 03 05:32:01 Error: POP3(joyce(a)obfusca.ted): mbox sync: > Expunged message reappeared in mailbox > /var/mail/vhosts/obfusca.ted/joyce (UID 1443 < 1446, seq=2, idx_msgs=0) > dovecot: Nov 03 05:32:01 Info: pop3-login: Login: > user=<joyce(a)obfusca.ted>, method=PLAIN, rip=::ffff:67.9.149.201, > lip=::ffff:zz.zz.zz.zz, TLS > dovecot: Nov 03 05:32:02 Info: pop3-login: Login: > user=<howard(a)obfusca.ted>, method=PLAIN, rip=::ffff:81.44.31.210, > lip=::ffff:zz.zz.zz.zz, TLS > dovecot: Nov 03 05:32:03 Info: POP3(joyce(a)obfusca.ted): Disconnected: > Logged out top=0/0, retr=3/163473, del=3/3, size=163419 > dovecot: Nov 03 05:32:03 Error: POP3(joyce(a)obfusca.ted): mbox sync: > Expunged message reappeared in mailbox > /var/mail/vhosts/obfusca.ted/joyce (UID 1443 < 1449, seq=2, idx_msgs=0) > dovecot: Nov 03 05:32:03 Info: POP3(howard(a)obfusca.ted): Disconnected: > Logged out top=0/0, retr=0/0, del=0/0, size=0 > dovecot: Nov 03 05:37:02 Info: pop3-login: Login: > user=<howard(a)obfusca.ted>, method=PLAIN, rip=::ffff:81.44.31.210, > lip=::ffff:zz.zz.zz.zz, TLS > dovecot: Nov 03 05:37:03 Info: POP3(howard(a)obfusca.ted): Disconnected: > Logged out top=0/0, retr=0/0, del=0/3, size=0 > dovecot: Nov 03 05:42:01 Info: pop3-login: Login: > user=<joyce(a)obfusca.ted>, method=PLAIN, rip=::ffff:67.9.149.201, > lip=::ffff:zz.zz.zz.zz, TLS > dovecot: Nov 03 05:42:02 Info: pop3-login: Login: > user=<howard(a)obfusca.ted>, method=PLAIN, rip=::ffff:81.44.31.210, > lip=::ffff:zz.zz.zz.zz, TLS > dovecot: Nov 03 05:42:02 Info: POP3(howard(a)obfusca.ted): Disconnected: > Logged out top=0/0, retr=0/0, del=0/0, size=0 > dovecot: Nov 03 05:42:03 Info: POP3(joyce(a)obfusca.ted): Disconnected: > Logged out top=0/0, retr=3/163461, del=3/3, size=0 > dovecot: Nov 03 05:47:02 Info: pop3-login: Login: > user=<howard(a)obfusca.ted>, method=PLAIN, rip=::ffff:81.44.31.210, > lip=::ffff:zz.zz.zz.zz, TLS > dovecot: Nov 03 05:47:02 Info: POP3(howard(a)obfusca.ted): Disconnected: > Logged out top=0/0, retr=0/0, del=0/0, size=0 > dovecot: Nov 03 05:52:01 Error: POP3(joyce(a)obfusca.ted): mbox sync: > Expunged message reappeared in mailbox > /var/mail/vhosts/obfusca.ted/joyce (UID 1449 < 1452, seq=2, idx_msgs=0) > dovecot: Nov 03 05:52:01 Info: pop3-login: Login: > user=<joyce(a)obfusca.ted>, method=PLAIN, rip=::ffff:67.9.149.201, > lip=::ffff:zz.zz.zz.zz, TLS > dovecot: Nov 03 05:52:02 Info: pop3-login: Login: > user=<howard(a)obfusca.ted>, method=PLAIN, rip=::ffff:81.44.31.210, > lip=::ffff:zz.zz.zz.zz, TLS > dovecot: Nov 03 05:52:02 Info: POP3(howard(a)obfusca.ted): Disconnected: > Logged out top=0/0, retr=0/0, del=0/0, size=0 > dovecot: Nov 03 05:52:03 Info: POP3(joyce(a)obfusca.ted): Disconnected: > Logged out top=0/0, retr=3/163473, del=3/3, size=163419 > dovecot: Nov 03 05:52:03 Error: POP3(joyce(a)obfusca.ted): mbox sync: > Expunged message reappeared in mailbox > /var/mail/vhosts/obfusca.ted/joyce (UID 1449 < 1455, seq=2, idx_msgs=0) > dovecot: Nov 03 05:57:02 Info: pop3-login: Login: > user=<howard(a)obfusca.ted>, method=PLAIN, rip=::ffff:81.44.31.210, > lip=::ffff:zz.zz.zz.zz, TLS > dovecot: Nov 03 05:57:03 Info: POP3(howard(a)obfusca.ted): Disconnected: > Logged out top=0/0, retr=0/0, del=0/3, size=0 > dovecot: Nov 03 06:02:01 Info: pop3-login: Login: > user=<joyce(a)obfusca.ted>, method=PLAIN, rip=::ffff:67.9.149.201, > lip=::ffff:zz.zz.zz.zz, TLS > dovecot: Nov 03 06:02:02 Info: pop3-login: Login: > user=<howard(a)obfusca.ted>, method=PLAIN, rip=::ffff:81.44.31.210, > lip=::ffff:zz.zz.zz.zz, TLS > dovecot: Nov 03 06:02:02 Info: POP3(howard(a)obfusca.ted): Disconnected: > Logged out top=0/0, retr=0/0, del=0/0, size=0 > dovecot: Nov 03 06:02:02 Info: POP3(joyce(a)obfusca.ted): Disconnected: > Logged out top=0/0, retr=3/163461, del=3/3, size=0 > dovecot: Nov 03 06:07:02 Info: pop3-login: Login: > user=<howard(a)obfusca.ted>, method=PLAIN, rip=::ffff:81.44.31.210, > lip=::ffff:zz.zz.zz.zz, TLS > dovecot: Nov 03 06:07:02 Info: POP3(howard(a)obfusca.ted): Disconnected: > Logged out top=0/0, retr=0/0, del=0/0, size=0 > dovecot: Nov 03 06:12:01 Error: POP3(joyce(a)obfusca.ted): mbox sync: > Expunged message reappeared in mailbox > /var/mail/vhosts/obfusca.ted/joyce (UID 1455 < 1458, seq=2, idx_msgs=0) Dovecot version: [jhg@helios ~]$ rpm -q dovecot dovecot-1.0-0.beta8.2.fc5 The MTA is postfix, and this is the first time this has ever happened. I made a copy of the mbox file, and find that it's over a megabyte long. Checking the postfix maillog I find that only three messages arrived for that user in the hour preceding the start of this behavior (all SPAM). No other users are affected, and I can't see anything obviously wrong in the mbox file. Could a bad message cause this?

2 2

[Dovecot] Server-side mail archiving - possible dovecot lda feature?
by Charles Marcus 03 Nov '06

03 Nov '06

Hi Timo, I have a question on the feasibility of adding the capability directly in dovecot LDA (or maybe this wouldn't be the correct place?) to provide a server-side mail archiving feature. What I'd like is a simple way to define a maildir, ie: vmail/archive/$user/Inbox and vmail/archive/$user/Inbox.Sent And then have the dovecot LDA deliver a copy of all mail (incoming and outgoing) to this archive folder. Is the dovecot LDA the best place for this to go? Or would an entirely new plug-in be more appropriate? My boss may be willing to pay to have this capability added. I have investigated other third party solutions, but I would prefer something that is tightly integrated with dovecot. I look forward to your response... -- Best regards, Charles

5 9

[Dovecot] Authentication in outlook
by Paul Aguirre 03 Nov '06

03 Nov '06

Hi all, I have instaled dovecot 1.0.rc10, and my configuration works fine if I get the mail with Evolution mail client, bu if I try to use outlook to get mails the authentication fail and I can't pass through the logon window. The maillog appear this message: dovecot: pop3-login: Disconnected: rip=192.168.0.22, lip=192.168.0.1 My dovecot configuration is: protocols = pop3 ssl_disable = yes mail_extra_groups = mail protocol imap { } protocol pop3 { pop3_uidl_format = %v.%u } protocol lda { postmaster_address = postmaster(a)example.com } auth_username_translation = "@." auth default { mechanisms = plain passdb pam { } userdb passwd { } user = root } dict { } plugin { } any idea to solve. thanks Paul

6 7

Re: [Dovecot] installation problem
by jaysen＠emtjaysen.net 03 Nov '06

03 Nov '06

2 1

[Dovecot] Last connection date/time
by Luigi Rosa 03 Nov '06

03 Nov '06

Hi, in an installation of Dovecot I need to know when each user made his/her last POP3 connection in a maildir environment. The date of which of the index files maintained by Dovecot can I use to get this information? Thanks. Ciao, luigi -- / +--[Luigi Rosa]-- \ Left-Handers have rights too.

2 1

[Dovecot] any idea why the mail downloading is slow?
by LeVA 03 Nov '06

03 Nov '06

Hi! I'm using rc10, but had this problem with previous releases too. Not sure if this is a dovecot problem, but I can not think of anything else. The mail downloading with pop3 is ~very slow, approx. 20 Kbyte / sec. no matter how many mails I've got in my mailbox, or how big are the mails. My ISP provides me a dedicated 100mbit line, and everything else works as fast as expected eg. http, ftp, scp... The OS is OpenBSD 3.9-stable and the system is not under heavy load at all. I've tried to turn off TLS but there was no change. Is the pop3 protocol this slow by design or there is something wrong with my setup? Thanks! Daniel -- LeVA

2 4

[Dovecot] installation problem
by jaysen＠emtjaysen.net 03 Nov '06

03 Nov '06

2 1

[Dovecot] CRAM-MD5 auth broken with postgresql passdb?
by Chris Laif 03 Nov '06

03 Nov '06

I'm currently experiencing a problem which has already been described by Jonathan in http://www.dovecot.org/list/dovecot/2006-August/015501.html If I use CRAM-MD5 auth with passwd-file as a backend (Thunderbird client) everything works fine (MD5-hashes have been shortened for readability): dovecot: auth(default): password(bob(a)foo.bar,10.0.0.123): Credentials: f12c884ba3cc82.. dovecot: imap-login: Login: user=<bob(a)foo.bar>, method=CRAM-MD5, rip=10.0.0.123, lip=10.0.0.234 My passwd file contains a line like this: bob@foo.bar:{HMAC-MD5}f12c884ba3cc82.. If I change to postgresql-based passdb, PLAIN auth works (!) and CRAM-MD5 does not work: dovecot: auth(default): sql(bob(a)foo.bar,10.0.0.123): query: SELECT 'bob(a)foo.bar' AS user, '{HMAC-MD5}f12c884ba3cc82..' AS password dovecot: auth(default): password(bob(a)foo.bar,10.0.0.123): Credentials: dovecot: auth(default): cram-md5(bob(a)foo.bar,10.0.0.123): password mismatch Please note the ultra-simple SELECT-statement (I've tried other combinations as well - no success). sql.conf setting is "default_pass_scheme = HMAC-MD5". Dovecot version 1.0.rc10. In the postgresql-based example the "Credentials:" variable is empty. I wonder if this is a bug in dovecot. Please let me know if you need any further information to resolve this issue. Thanks, Chris (As a side not I still do not understand how CRAM-MD5 auth is able to work without a plain text password, but that's another story. If it works with an HMAC-MD5 hash in a passwd-file backend it should work with the postgresql-db backend as well.)

2 3