- dovecot - dovecot.org

[Dovecot] Authentication problems with mysql 5
by Gianfranco Bartolini 22 Jun '06

22 Jun '06

Hello, this is my first post here, so hi to all! I've just configured a new Suse Linux 10.1 distribution that comes with: - postfix 2.2.9 + mysql tables - dovecot 1.0.beta3 - mysql 5.0.18 - kernel 2.6.16.13-4-bigsmp i386 on a Intel Xeon 2.0Ghz with 3Gb RAM I've also added postfixadmin 2.1.0 to build an IMAP server with virtual users/virtual hosts management, and ran the script DATABASE_MYSQL.TXT to build correctly database/tables and user/permissions. The problem is that dovecot fail to access to mysql tables with the following error: =================== dovecot: Jun 12 18:40:28 Info: Dovecot v1.0.beta3 starting up dovecot: Jun 12 18:40:29 Error: auth-worker(default): mysql: Connect failed to 127.0.0.1 (postfix): Access denied for user 'postfix'@'localhost' (using password: YES) - waiting for 1 seconds before retry =================== I've tried to connect to mysql using the socket instead of the local ip address, but i've got the same error: =================== dovecot: Jun 12 18:55:19 Info: Dovecot v1.0.beta3 starting up dovecot: Jun 12 18:55:20 Error: auth-worker(default): mysql: Connect failed to (null) (postfix): Access denied for user 'postfix'@'localhost' (using password: YES) - waiting for 1 seconds before retry =================== In mysql the user "postfix" is correctly created with access granted from either localhost and 127.0.0.1 If i do the same from the command line it works perfectly: =================== server01:/ # mysql -h localhost -u postfix -p Enter password: secret Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 136 to server version: 5.0.18 Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> =================== Here is my dovecot.conf: =================== default_mail_env = maildir:/home/mbox/%d/%n protocols = imap pop3 auth default { mechanisms = plain userdb sql { args = /etc/dovecot/dovecot-sql.conf } passdb sql { args = /etc/dovecot/dovecot-sql.conf } } first_valid_uid = 51 ssl_disable = yes listen = * log_path = /var/log/dovecot.log info_log_path = /var/log/dovecot.log =================== And my dovecot-sql.conf: =================== driver = mysql connect = host=/var/lib/mysql/mysql.sock dbname=postfix user=postfix password=secret default_pass_scheme = PLAIN password_query = SELECT password FROM mailbox WHERE username = '%u' AND active = '1' user_query = SELECT maildir AS mail, 51 AS uid, 51 AS gid FROM mailbox WHERE username = '%u' AND active = '1' =================== I'v tried also all the password mechanisms (PLAIN, PLAIN-MD5, MD5, CRYPT) with no success. My google searches ended with no results. Btw, the same configuration on a Suse 9.3 professional works perfectly :( Please anyone can help me? Thanks in advance for all the kindly support Saluti G.Bartolini Linux User #333064

4 8

[Dovecot] Re: entered bc_action_emit with filelen:
by Alex Pimperton 21 Jun '06

21 Jun '06

Hi, I'm still getting the errors below on Debian Etch with Dovecot 1.0.8-4 and Dovecot LDA. Is this something that's fixed in 1.0.9? It doesn't seem to have an effect but I'm wary of messages I don't recognise! Regards, Alex Jun 20 14:13:04 server01 deliver: entered bc_action_emit with filelen: 16 Jun 20 14:13:04 server01 deliver: entered bc_action_emit with filelen: 112 Jun 20 14:13:04 server01 deliver: entered bc_action_emit with filelen: 240 Jun 20 14:13:04 server01 deliver: entered bc_action_emit with filelen: 368 Jun 20 14:13:04 server01 deliver: entered bc_action_emit with filelen: -- This message has been scanned for viruses and dangerous content by the MailScanner at Placet.co.uk, and is believed to be clean.

5 7

[Dovecot] problem with kqueue
by Alessandro de Manzano 21 Jun '06

21 Jun '06

Hello, I'm a new user of Dovecot (since 1.0b8) and I'ld report about a possible bug. Situation: Dovecot 1.0beta9 with kqueue support FreeBSD 6.1-Release x86 machine (IBM x206, P4 3.2 Ghz) local filesystem UFS2 This is an internal, experimental, mail server running Postfix and Dovecot configured with Maildirs e IMAP-only access. Clients are quite few, now, just because it's an experiment. However are near all Outlook Express 6. Running with dovecot 1.0 beta8 _without_ kqueue support for few weeks was fine, no problems at all. A couple of days ago I updated to beta9 (using FreeBSD's portupgrade tools) and in the _same_time_ I enabled the kqueue support. Since then I've seen about 3-4 of these in the log: (note that process traps apparently after reporting the unrecognized event) Jun 20 10:38:53 bigblue dovecot: imap-login: Login: user=<laura2>, method=PLAIN, rip=192.168.9.31, lip=192.168.9.68 Jun 20 10:38:54 bigblue dovecot: IMAP(laura2): Disconnected in IDLE Jun 20 10:38:54 bigblue dovecot: IMAP(laura2): Unrecognized event: kevent {.ident = 1, .filter = 0xfffffffe, .flags = 0x0000, .fflags = 0x00000000, .data = 0x00008322} Jun 20 10:38:54 bigblue dovecot: IMAP(laura2): mode: 0x004x Jun 20 10:38:54 bigblue kernel: pid 18426 (imap), uid 1004: exited on signal 6 Jun 20 10:38:54 bigblue dovecot: imap-login: Login: user=<laura2>, method=PLAIN, rip=192.168.9.31, lip=192.168.9.68 Jun 20 10:38:54 bigblue dovecot: child 18426 (imap) killed with signal 6 Jun 20 10:38:54 bigblue dovecot: IMAP(laura2): Disconnected Jun 20 10:38:54 bigblue dovecot: imap-login: Login: user=<laura2>, method=PLAIN, rip=192.168.9.31, lip=192.168.9.68 Jun 20 10:38:54 bigblue dovecot: IMAP(laura2): Disconnected in IDLE Jun 20 10:38:54 bigblue dovecot: imap-login: Login: user=<laura2>, method=PLAIN, rip=192.168.9.31, lip=192.168.9.68 Jun 20 10:39:54 bigblue dovecot: imap-login: Login: user=<laura2>, method=PLAIN, rip=192.168.9.31, lip=192.168.9.68 Jun 20 10:39:54 bigblue dovecot: IMAP(laura2): Disconnected in IDLE Jun 20 10:39:54 bigblue dovecot: imap-login: Login: user=<laura2>, method=PLAIN, rip=192.168.9.31, lip=192.168.9.68 Jun 20 10:39:54 bigblue dovecot: IMAP(laura2): Disconnected in IDLE Jun 20 10:39:54 bigblue dovecot: imap-login: Login: user=<laura2>, method=PLAIN, rip=192.168.9.31, lip=192.168.9.68 Jun 20 10:39:54 bigblue dovecot: IMAP(laura2): Disconnected in IDLE Jun 20 10:39:54 bigblue dovecot: imap-login: Login: user=<laura2>, method=PLAIN, rip=192.168.9.31, lip=192.168.9.68 Jun 20 10:39:54 bigblue dovecot: IMAP(laura2): Disconnected Jun 20 10:39:54 bigblue dovecot: imap-login: Login: user=<laura2>, method=PLAIN, rip=192.168.9.31, lip=192.168.9.68 Jun 20 10:39:54 bigblue dovecot: IMAP(laura2): Disconnected in IDLE Any ideas ? Any one else got these messages ? I'ld try recompiling beta9 without kqueue support, probably the issue would disappear, but IMHO is not the best way to "correct" things :) Many thanks in advance! -- Alessandro de Manzano System & Network Administrator Playstos - TIMA S.p.A. Corso Sempione 63 20149 Milano, Italy tel.: +39-023314153 fax : +39-02315678 email: demanzano(a)playstos.com http://www.playstos.com

1 0

[Dovecot] Dovecot servers / SAN
by Dean Manners 21 Jun '06

21 Jun '06

Hey guys, Wondering if anyone out there has any input on running Dovecot with SAN storage. Its coming to the time where we need to run load balanced servers, and past experiences steer us away from a NAS. Tips / pitfalls ? Regards __________________________________________ Dean Manners

3 4

RE: [Dovecot] imap - mailbox in an inconsistant state
by Patrick Carney 20 Jun '06

20 Jun '06

So how do I delete his indexes? Is there somewhere a step by step procedure? Timo, please help? Forgive me, I am new to all this. Thanks much, Patrick -----Original Message----- From: Jeff Graves [mailto:jeff@image-src.com] Sent: Tuesday, June 20, 2006 11:34 AM To: 'Patrick Carney' Subject: RE: [Dovecot] imap - mailbox in an inconsistant state I haven't used 0.99 in a while but it shouldn't destroy the subscriptions. I think the next login may be delayed some while the index is rebuilt. Might want to check with Timo. -- Jeff Graves, MCSA Image Source, Inc. 508.966.5200 x31 www.image-src.com -----Original Message----- From: Patrick Carney [mailto:patrick@castandcrew.com] Sent: Tuesday, June 20, 2006 2:23 PM To: 'Jeff Graves'; dovecot(a)dovecot.org Subject: RE: [Dovecot] imap - mailbox in an inconsistant state Will that destroy his folder subscriptions? Will I loose anything? Thanks PAtrick -----Original Message----- From: dovecot-bounces(a)dovecot.org [mailto:dovecot-bounces@dovecot.org] On Behalf Of Jeff Graves Sent: Tuesday, June 20, 2006 11:18 AM To: dovecot(a)dovecot.org Subject: RE: [Dovecot] imap - mailbox in an inconsistant state The only quick and easy band-aid I can think of is to delete the indexes and let dovecot recreate them. -- Jeff Graves, MCSA Image Source, Inc. 508.966.5200 x31 www.image-src.com -----Original Message----- From: dovecot-bounces(a)dovecot.org [mailto:dovecot-bounces@dovecot.org] On Behalf Of Patrick Carney Sent: Tuesday, June 20, 2006 12:44 PM To: 'Timo Sirainen' Cc: dovecot(a)dovecot.org Subject: RE: [Dovecot] imap - mailbox in an inconsistant state Yes. I was afraid of that. But the weird thing is it only happens with One particular user. And at that, it wasn't doing it for the longest time. It just started recently. Is there a band-aid for this. I ask because we are not in a place to upgrade at the moment. Thanks Patrick -----Original Message----- From: dovecot-bounces(a)dovecot.org [mailto:dovecot-bounces@dovecot.org] On Behalf Of Timo Sirainen Sent: Tuesday, June 20, 2006 9:37 AM To: Patrick Carney Cc: dovecot(a)dovecot.org Subject: Re: [Dovecot] imap - mailbox in an inconsistant state On Tue, 2006-06-20 at 09:07 -0700, Patrick Carney wrote: > "Jun 19 08:08:34 burmail imap(ed): Corrupted binary tree > file /home/ed/mail/.imap/INBOX/.imap.index.tree: UID to be inserted > isn't higher than existing (2 <= 504)" > Can someone tell me what that means?? I have been assigned to take > over for a departed sys admin and have never used or administered > Dovecot before. You're using 0.99.x Dovecot and there's not much point anymore in trying to figure out why it's broken. I'd suggest upgrading to 1.0beta versions as the first step. If it still breaks after that I can help debug it further. Also see http://wiki.dovecot.org/UpgradingDovecot

3 4

[Dovecot] Reading the index / log files
by Raymond Lillard 20 Jun '06

20 Jun '06

Dear Dovecot, I have a user who claims his mail is being lost. I can find the message marked as having been accepted for delivery in the maillog. I am hoping there is a tool which will let me read his IMAP transactions. We are delivering the messages with procmail and storing them as Maildir files. I read mail on this very same server and process about 500 mails per day. (Its the machine where all of my mail lists are collected.) I use T-bird, he uses LookOut. My working theory is that he (or his MUA) is somehow deleting some of his mail. Being able to read a log of his IMAP transactions would be most helpful. I see nothing about this in the Wiki. Regards, Ray

2 1

[Dovecot] Dovecot --IMAP
by Clovis Tristao 20 Jun '06

20 Jun '06

Hi, I am using dovecot-0.99.14-8.fc4 in Fedora Core release 4 (Stentz), and is appears this message: maillog -------- imap(testelabin): file mbox-rewrite.c: line 429 (mbox_write_header): assertion failed: (hdr_parsed_size.physical_size == hdr_size) When I try to have access a very great mailbox(mbox) (99 MB) via Webmail SquirrelMail. My quota of record is of 250 MB, some suggestion? Thanks a lot, Clóvis -- Clovis Tristao - UNICAMP/Faculdade de Engenharia Agricola Administrador de Redes - Secao de Informatica (SINFO) E-mail: clovis(a)agr.unicamp.br http://www.agr.unicamp.br Fone(0xx19) 37881031-37881038 ou FAX(55xx19) 37881005/37881010

4 8

[Dovecot] repairing mbox files
by Dominic Lepiane 20 Jun '06

20 Jun '06

Hi folks, Is there a good tool for repairing/working with mbox files? I'm trying to get a user moved off of Entourage (Outlook for Mac). Entourage actually exports the mail (was pop, will be imap) as mbox files, however, I can't just drop them in place even after fixing the line-endings. many of the messages with attachments come up with the correct header info but no message body or attachment. But some work so it's clearly a problem that a lot the messages are malformed somehow. Server is RHEL 4, dovecot-0.99.11-2.EL4.1 Current client is Mozilla Thunderbird (1.5.0.4) in Mac OS X 10.4.6 using IMAP. Previous client was MS Entourage (OS x 10.4.6) using POP. Thanks in advance. -- Dominic Lepiane Simon Fraser University/IRMACS dlepiane(a)irmacs.sfu.ca (604)268-7369

2 2

[Dovecot] strange behaviour: connecting to mysql, but no queries after upgrade on ubuntu...
by dstrayer＠sadt.com 20 Jun '06

20 Jun '06

> hi all, > > I'm having trouble using dovecot with mysql after upgrading to 1.0.beta3 on > ubuntu. according to the mysql log, dovecot connects but doesn't issue any > queries.. > > any hints what might be wrong or where I should look? > -- > Cheers, > > Nikl I'm seeing the same behavior under Debian Sid. (First time I've tried it, so I don't know whether the problem is connected to a particular update.) I can make an imap connection using passwd-file authentication. When I switch to mysql, the mysql log shows a connection when dovecot starts but no further activity. The reply to the imap client is NO Temporary authentication failure. In the mail.log, I see: Jun 16 06:25:57 server dovecot: auth(default): client in: AUTH^I1^IPLAIN^Iservice=IMAP^Ilip=192.168.1.2^Irip=192.168.1.3^Iresp=AGd1ZXN0QHNhZHQuY29tAGZvbw== Jun 16 06:25:57 server dovecot: child 4951 (auth-worker) killed with signal 11 Jun 16 06:25:57 server dovecot: auth(default): client out: FAIL^I1^Iuser=foo(a)sample.com^Itemp Jun 16 06:25:57 server dovecot: imap-login: Aborted login: user=<foo(a)sample.com>, method=PLAIN, rip=192.168.1.2, lip=192.168.1.3 Any clues?

4 5

[Dovecot] Problem compile dovecot-sieve under Debian
by Dominique Feyer 20 Jun '06

20 Jun '06

I get the source from CVS: # cvs -d :pserver:anonymous@dovecot.org:/home/cvs co dovecot-sieve Edit configure.in to change - AC_CONFIG_HEADERS([dsieve-config.h]) + AC_CONFIG_HEADERS(dsieve-config.h) Launch autogen.sh, and I have some errors: configure.in: 4: `automake requires `AM_CONFIG_HEADER', not `AC_CONFIG_HEADER' configure.in: 11: automake requires `AM_PROG_LEX', not `AC_PROG_LEX' automake: src/libsieve/Makefile.am: not supported: source file `../map.c' is in subdirectory automake: src/libsieve/Makefile.am: not supported: source file `../imparse.c' is in subdirectory automake: src/libsieve/Makefile.am: lex source seen but `AC_DECL_YYTEXT' not in `configure.in' If i try to build: # ./configure --with-dovecot=../dovecot-1.0.beta9 No error: ... configure: creating ./config.status config.status: creating Makefile config.status: creating src/Makefile config.status: creating src/libsieve/Makefile config.status: creating stamp.h config.status: creating dsieve-config.h config.status: dsieve-config.h is unchanged # make gcc -std=gnu99 -g -O2 -Wall -W -Wmissing-prototypes -Wmissing-declarations -Wpointer-arith -Wchar-subscripts -Wformat=2 -Wbad-function-cast -o sievec sievec.o libsieve.a /usr/src/dovecot-1.0.beta9/src/lib/liblib.a libsieve.a(script.o)(.text+0xa23): In function `sieve_script_load': /usr/src/dovecot-sieve/src/libsieve/script.c:435: undefined reference to `map_refresh' libsieve.a(script.o)(.text+0xaf0): In function `sieve_script_unload': /usr/src/dovecot-sieve/src/libsieve/script.c:462: undefined reference to `map_free' libsieve.a(sieve.o)(.text+0x1e6e): In function `verify_flag': /usr/src/dovecot-sieve/src/libsieve/sieve.y:951: undefined reference to `imparse_isatom' collect2: ld returned 1 exit status make[3]: *** [sievec] Erreur 1 make[3]: Leaving directory `/usr/src/dovecot-sieve/src/libsieve' make[2]: *** [all-recursive] Erreur 1 make[2]: Leaving directory `/usr/src/dovecot-sieve/src' make[1]: *** [all-recursive] Erreur 1 make[1]: Leaving directory `/usr/src/dovecot-sieve' make: *** [all-recursive-am] Erreur 2 I try to install cyrus-dev or cyrus21-dev with apt-get, but nothing change, always the same error. Does someone have success with plugin dovecot-sieve ? Thanks -- Dominique Feyer Administrateur Système Ch. de la Colline 5bis CH-1007 Lausanne dfeyer(a)net4all.ch

3 10