- dovecot - dovecot.org

[Dovecot] MySQL auth issues?
by Matthias Saou 03 Apr '06

03 Apr '06

Hi, Since my last email about RHEL4 problems on x86_64, I've kept trying to figure out what the problem might be, and just ran into a reply to an old email I sent to the list, which I had missed. It suggests that the issue might be in the MySQL authentication that I'm using. Here is a more detailed log entry, with auto debugging on : Apr 3 13:13:02 s1 dovecot: auth(default): client in: AUTH 1 PLAIN service=POP3 lip=::ffff:195.x.x.x rip=::ffff:195.x.x.x resp=AHBhcnRuZXJzQdNvbW1lcm3lZ2F0ZS5jb20Aa2F2YWthdmE= Apr 3 13:13:02 s1 dovecot: auth(default): client out: OK 1 user=x(a)domain.com Apr 3 13:13:02 s1 dovecot: auth(default): master in: REQUEST 70 22190 1 Apr 3 13:13:02 s1 dovecot: auth-worker(default): sql(x@domain.com,::ffff:195.x.x.x): SELECT maildir, 101 AS uid, 103 AS gid FROM mailbox WHERE username = 'x(a)domain.com' Apr 3 13:13:02 s1 dovecot: auth(default): master out: USER 70 x(a)domain.com maildir=domain.com/x/ uid=101 gid=103 Apr 3 13:13:02 s1 dovecot: pop3-login: Login: user=<x(a)domain.com>, method=PLAIN, rip=::ffff:195.x.x.x, lip=::ffff:195.x.x.x Apr 3 13:13:02 s1 dovecot: pop3(x(a)domain.com): ^GUnexpected eof found when reading file 'UNOPENED' (Errcode: 0) Apr 3 13:13:02 s1 last message repeated 2 times Apr 3 13:13:02 s1 dovecot: pop3(x(a)domain.com): Disconnected: Logged out top=0/0, retr=0/0, del=0/2, size=17174 Those "Unexpected eof found when reading file 'fileName'" messages are apparently from MySQL, as one can see here for instance : http://www.mysqlfreaks.com/errors/49.php Here is my relevant configuration (all the rest is the default) : login_greeting = Ready. verbose_proctitle = yes first_valid_uid = 101 default_mail_env = maildir:/home/vmail/%d/%n:INDEX=MEMORY auth_cache_size = 512 auth_verbose = yes auth_debug = yes auth_debug_passwords = yes auth default { mechanisms = plain passdb sql { args = /etc/dovecot-mysql.conf } userdb sql { args = /etc/dovecot-mysql.conf } } The INDEX=MEMORY was added because of similar errors with the indexes : Apr 3 12:56:44 s1 dovecot: pop3-login: Login: user=<x(a)domain.com>, method=PLAIN, rip=::ffff:195.x.x.x, lip=::ffff:195.x.x.x, TLS Apr 3 12:56:44 s1 dovecot: pop3(x(a)domaine.com): Corrupted transaction log file /home/vmail/domain.com/x/dovecot.index.log: unexpected end of file while reading header Apr 3 12:56:44 s1 dovecot: pop3(x(a)domain.com): Corrupted transaction log file /home/vmail/domain.com/x/dovecot.index.log: unexpected end of file while reading header Apr 3 12:56:44 s1 dovecot: pop3(x(a)domain.com): Disconnected: Logged out top=0/0, retr=0/0, del=0/0, size=0 (this was when the auth_debug wasn't enabled) Here is my /etc/dovecot-mysql.conf file : driver = mysql connect = host=/var/lib/mysql/mysql.sock dbname=postfix user=postfix password=xxx default_pass_scheme = PLAIN password_query = SELECT password FROM mailbox WHERE username = '%u' user_query = SELECT maildir, 101 AS uid, 103 AS gid FROM mailbox WHERE username = '%u' I'm using MySQL 4.1.12-3.RHEL4.1 (the original RHEL4 packages), with the server on the same machine (hence the socket access). I was seeing this also with 0.9, not just 1.0 betas. With x86_64 packages, any slight change to the main dovecot.conf file can prevent dovecot from starting (segfault with "Unexpected eof found when reading file 'UNOPENED' (Errcode: 0)" message), whereas i386 packages work somewhat better. This is on the same machine with an i386 compatibility layer. Is anyone using MySQL auth successfully? Any help or pointers would be more than welcome. Matthias -- Clean custom Red Hat Linux rpm packages : http://freshrpms.net/ Fedora Core release 5 (Bordeaux) - Linux kernel 2.6.16-1.2080_FC5 Load : 0.38 0.33 0.34

1 1

[Dovecot] mbox-sync-update.c error
by Carlos Vicente 03 Apr '06

03 Apr '06

Hi, I think the problem is in Dovecot. I'm using both Evolution and Thunderbird on a Gentoo box. One of my folders keeps locking up and the clients can't retrieve the messages. The situation appears to be triggered by trying to move a message into that folder. Deleting the index files (under /var/log/dovecot/xxx/) solves the problem (temporarily). I get these error messages in the logs: Mar 31 15:10:34 dovecot: imap(cvicente): mbox sync: UID inserted in the middle of mailbox /home/xxx/Mail/xxx (93 > 3, seq=93, idx_msgs=3455) Mar 31 15:10:34 dovecot: imap(cvicente): file mbox-sync-update.c: line 55 (mbox_sync_move_buffer): assertion failed: (ctx->mail.offset + ctx->mail.space <= ctx->hdr_offset + pos || ctx->mail.offset > ctx->hdr_offset + pos + have) Mar 31 15:10:35 dovecot: child 32373 (imap) killed with signal 6 M I'm running dovecot-1.0_beta3 Hope this gets some attention from the developers. cv >In the maillog I get > > Mar 29 09:17:25 bree dovecot: imap-login: Login: user=<hartr>, > method=plain, rip=::ffff:127.0.0.1, lip=::ffff:127.0.0.1, secured > Mar 29 09:17:25 bree dovecot: imap(hartr): mbox sync: UID inserted > in the middle of mailbox /var/mail/hartr (8 > 1, seq=2, idx_msgs=4) > Mar 29 09:17:25 bree dovecot: imap(hartr): file mbox-sync-update.c: > line 55 (mbox_sync_move_buffer): assertion failed: (ctx->mail.offset > + ctx->mail.space <= ctx->hdr_offset + pos || ctx->mail.offset > > ctx->hdr_offset + pos + have) > Mar 29 09:17:26 bree dove

3 4

[Dovecot] Dovecot-news mailing list created
by Timo Sirainen 02 Apr '06

02 Apr '06

New low-traffic list created for people who only wish to see new release announcements and possibly some other rare important announcements. Also from now on no-one can send mails to either of these lists with From-field containing "tss(a)iki.fi" or "Timo Sirainen", unless it also contains a valid PGP signature from me. If someone wants to see the script (and please check if there are any bugs in it, thanks :), it's here: http://iki.fi/tss/gpgcheck.pl

1 0

[Dovecot] Dovecot road-map
by Kupor Laszlo 02 Apr '06

02 Apr '06

Hello, I track dovecot m-list, and i wan't migrate to dovecot, but now dovecot has no maildir++ quota in public release(beta etc). Without quota support dovcot not a solution for me. Please if dovecot have a release plan, post to me. Thanks. Udv.: Willy -- PGP GNUPG/1.0 ID = 5BFA0D36 Kupor Laszlo Attila <willy(a)dunanet.hu> Key fingerprint = 3F68 9483 5B65 8E2F CD30 5326 50F9 5A33 5BFA 0D36

5 5

[Dovecot] imap processes remaing after dovecot shutdown
by Marten Lehmann 02 Apr '06

02 Apr '06

Hello, I'm using dovecot-1.0.beta3. When I shutdown dovecot (kill -term on the master-pid) the main process disappears, but all the child processes still remain. Why doesn't dovecot kill them as I shutdown the master-process? When I shutdown mysql, all child processes will be shutdown, too. When I shutdown apache, all child processes willbe shutdown, too. Thats what I expect on every application. Usually there is no need to shutdown dovecot. But for some reasons, from time to time 50 and more processes of one user are running and I don't know how else to get rid of them. I don't like to kill the child processes always manually. Regards Marten

4 5

[Dovecot] Auth user from sasldb with dovecot
by kami Nonstop 02 Apr '06

02 Apr '06

Hi I configured my postfix that i can access the file /etc/sasl2/sasldb2 and authorize the users how are added in this database. My smtpd.conf looks like this: mech_list: PLAIN LOGIN pwcheck_method: auxprop auxprop_plugin: sasldb My saslauthd is not running. And when i telnet to port 25 i can authorize my self like this: telnet localhost 25 Trying 127.0.0.1... Connected to localhost. Escape character is '^]'. 220 localhost ESMTP Postfix ehlo localhost 250-localhost 250-PIPELINING 250-SIZE 10240000 250-VRFY 250-ETRN 250-STARTTLS 250-AUTH LOGIN PLAIN 250-AUTH=LOGIN PLAIN 250 8BITMIME auth plain dGVzdEBtaWNyb3NlcnZ== 235 Authentication successful But my problem is now that i dont know how to configure dovecot that i can login to my system with squirrelmail or something else? Dovecot should use the user added in sasldb2. I read this Howto but can find a solution for this: http://postfix.hostingzero.com/SASL_README.html I hope someone here can help me? Thx a lot Cu kami

2 1

[Dovecot] file lock on 1.0 stable
by Obantec Support 02 Apr '06

02 Apr '06

Hi I have the lock file back on 2 customer accounts. i am using mbox under /var/spool/mail/%u and of the 300 pop3 accounts i only have the odd random issue with the file locks. some are 1 byte (containing 0) other correct in that they have a pid (average 26 bytes). mbox & lock files owned by userUID.mail Mark

1 0

[Dovecot] How to use trash plugin?
by hshh 02 Apr '06

02 Apr '06

Hi, I can't found any document about this plugin. How can I setup a trash for deleted mail in imap? And remove them after some day like Courier IMAP.

1 0

Re: [Dovecot] Quick question. Thunderbird/Outlook = no love.
by Charlie Davis 02 Apr '06

02 Apr '06

Ok, it worked once, then stopped working. To get away from maybe it being a thunderbird setup issue, I made a little php script. And now I have an error that didn't show up in the dovecot log even though I have auth_debug and auth_verbose set to yes. Here's what the imap socket returned to the php script: Array ( [0] => Certificate failure for 10.0.0.208: self signed certificate: /OU=IMAP server/CN=imap.example.com/emailAddress=postmaster@example.com ) So, I gotta setup my certificate stuff which I can do, But couldn't this have shown up in the dovecot log somehow? -Charlie ----- On Saturday, April 1, 2006 fishgills(a)fishgills.net wrote: > Turns out some Anti-Virus email scanners don't support TLS. > > Sorry again! Not dovecot's fault. Disabled my anti-virus' email scanner > and it worked with TLS only. > > Good to know for anyone else that ever has this problem. :) > > -Charlie > > Timo Sirainen wrote: >> On Fri, 2006-03-31 at 18:56 -0800, Charlie Davis wrote: >> >>> 1.0 Beta 3. >>> >>> Plain authentication works. But not TLS. >>> >>> I don't see anything in the configuration file that seems obvious to deny > TLS authentication. >>> >> >> Set auth_verbose=yes and auth_debug=yes in dovecot.conf, maybe it shows >> then why it's failing? >> >>

2 1

[Dovecot] User data over Mysql
by Andew Velikorechanin 01 Apr '06

01 Apr '06

Hi, all! What I need set in dovecot config (dovecot-mysql.conf) for get home dir and mailbox file path from mysql DB? dovecot 0.99.11 Thanks.

1 0