- dovecot - dovecot.org

[Dovecot] Strange Mysql connect problem
by Craig Jackson 11 Oct '06

11 Oct '06

Hi, I compiled Dovecot and Mysql on two different servers each with the same options. Dovecot connects successfully on Server B. Server A has this error in Dovecot trying to connect to Mysql: dovecot: auth-worker(default): mysql: Connect failed to /tmp/mysql.sock (exim_db): Access denied for user 'user'@'localhost' (using password: YES) - waiting for 5 seconds before Passwords are plain text. Server A (64 bit amd with Ubuntu Hoary) info: ./mysql -V mysql Ver 14.7 Distrib 4.1.11, for unknown-linux-gnu (x86_64) ldd dovecot libmysqlclient.so.14 => /usr/local/mysql/lib/mysql/libmysqlclient.so.14 (0x0000002a9566c000) libc.so.6 => /lib/libc.so.6 (0x0000002a95881000) libcrypt.so.1 => /lib/libcrypt.so.1 (0x0000002a95ac0000) libnsl.so.1 => /lib/libnsl.so.1 (0x0000002a95bf3000) libm.so.6 => /lib/libm.so.6 (0x0000002a95d09000) libz.so.0 => /usr/local/mysql/lib/mysql/libz.so.0 (0x0000002a95e90000) /lib64/ld-linux-x86-64.so.2 => /lib64/ld-linux-x86-64.so.2 (0x0000002a95556000) libpthread.so.0 => /lib/libpthread.so.0 (0x0000002a95fa4000) ./dovecot --version 1.0.rc7 More info -- The Mysql user name on A and B are the same and are correct. Other applications are connecting on A using the same credentials. Server B info (Debian PIII): mysql Ver 14.7 Distrib 4.1.21, for pc-linux-gnu (i686) using EditLine wrapper ldd dovecot linux-gate.so.1 => (0xffffe000) libc.so.6 => /lib/tls/libc.so.6 (0x40020000) /lib/ld-linux.so.2 (0x40000000) ./dovecot --version 1.0.rc7 I have Googled and see lots of people having the same problem. I would rather not downgrade Mysql. Why doesn't Dovecot connect on A? Thanks. Craig

5 6

[Dovecot] POP +OK CR LF Question
by Phil Udel 11 Oct '06

11 Oct '06

HI. I just finished installing a new mail server running CentOS Ver 4. and I am running sendmail with devecot 0.99.11. Everything is working fine except for a customer of mine is using a tool that does pop requests. And his tool is failing waiting on a CR LF in the +OK. I did a small hex dump of my old pop and the dovecot pop and he is right. Docevot POP does not end its +OK with a CR LF. I looked around but I don't see where I can make that change. Can anyone please help. Thanks

4 4

Re: [Dovecot] POP3 - Mark messages as read
by Jose Gervasio Gomiz 11 Oct '06

11 Oct '06

>>----- Original Message ----- >>From: "Timo Sirainen" <tss(a)iki.fi> >>To: "Jose Gervasio Gomiz" <goma(a)bblanca.com.ar> >>Cc: <dovecot(a)dovecot.org> >>Sent: Tuesday, October 10, 2006 2:05 PM >>Subject: Re: [Dovecot] POP3 - Mark messages as read >>On Tue, 2006-10-10 at 12:28 -0300, Jose Gervasio Gomiz wrote: >> Hi all. I have a little problem with Dovecot. >> My POP3 users can retrieve their emails without problem, but if they have >> "Leave mail in server" (or similar) active in their clients, their mboxes >> doesn't get updated marking those messages as read. >>.. >> Should I upgrade to dovecot-1.x to solve this? >Yes. I've upgraded to dovecot-1.0-0_24.rc8, problem solved. Thanks for you help! Jose

1 0

[Dovecot] Problems with LDA and vitual mailboxes
by Daniel Frickemeier 11 Oct '06

11 Oct '06

Hello, I try to set up dovecot LDA with virtual domains/mailboxes to use sieve. I use dovecot 1.0_rc7 with sieve dovecot-sieve-20060726 . All datas about the virtual domains and mailboxes are stored in a mysql-database. And without using the LDA delifer agent, everything works fine. But when I try to use LDA (even without sieve), I got a delivery failture. I followed the wiki-howto http://wiki.dovecot.org/LDA to set up LDA support and added /etc/postfix/maser.cf: # Dovecot LDA dovecot unix - n n - - pipe flags=DRhu user=vmail:vmail argv=/usr/local/libexec/dovecot/deliver -d ${recipient} /etc/postfix/main.cf: dovecot_destination_recipient_limit = 1 virtual_transport = dovecot for postfix. In dovecot.conf I added: auth default { # Space separated list of wanted authentication mechanisms: # plain login digest-md5 cram-md5 ntlm rpa apop anonymous gssapi mechanisms = plain login # SQL database passdb sql { # Path for SQL configuration file, see doc/dovecot-sql.conf for example args = /etc/dovecot/dovecot-sql.conf } # SQL database userdb sql { # Path for SQL configuration file, see doc/dovecot-sql.conf for example args = /etc/dovecot/dovecot-sql.conf } socket listen { master { path = /var/run/dovecot-auth-master # use this for LDA, the dovecot-auth will NOT work mode = 0600 user = virtual #group = mail # Or alternatively mode 0660 + LDA user in this group } client { path = /var/run/dovecot-auth # use this for postfix mode = 0600 user = posfix # postfix user #group = mail # Or alternatively mode 0660 + postfix user in this group } } } protocol lda { log_path = /var/tmp/dovecot-lda.log { And in dovecot-sql # Dataabase driver: mysql, pgsql driver = mysql # Currently supported schemes include PLAIN, PLAIN-MD5, DIGEST-MD5, and CRYPT. default_pass_scheme = CRYPT #default_pass_scheme = PLAIN-MD5 # Database options connect = host=localhost dbname=$DB user=$USER password=$PASSWD password_query = SELECT password FROM mailbox WHERE username = '%u' AND active = '1' user_query = SELECT maildir, 1002 AS uid, 1004 AS gid FROM mailbox WHERE username = '%u' AND active = '1' # eof But when I send a mail to a vitual user, I got the following log entries in mail.log: Oct 11 08:40:38 server postfix/pipe[11673]: D39A5664420: to=<zigulle(a)zigulle.de>, relay=dovecot, delay=0.08, delays=0.06/0/0/0.03, dsn=4.3.0, status=deferred (temporary failure) and in /var/tmp/dovecot-lda.log: deliver(zigulle(a)zigulle.de): Error: userdb(zigulle(a)zigulle.de) didn't return a home directory has anyone here a hint, where the Problem ist? cu Daniel -- TELEKOM-Mitarbeiter, die keine TELEKOM-Aktien kaufen, sollten wegen Verwendung von Insider-Wissen bestraft werden. (Azkin Kaden)

2 4

[Dovecot] RC8 - Creating maildir
by Luigi Rosa 11 Oct '06

11 Oct '06

I just setup a new mail server with maildir and Dovecot RC 8 I noticed that when I login via POP3 with a username that do not have a maildir yet Dovecot logs this line: Oct 11 11:46:52 gw dovecot: stat(/var/spool/mail/xxxx/) failed: No such file or directory After that Dovecot correctly creates the maildir structure Wouldn't it be better to log a message like "Creating maildir structure for user xxxxxx"? Ciao, luigi -- / +--[Luigi Rosa]-- \ I didn't know it was impossible when I did it.

2 1

Re: [Dovecot] Strange Mysql connect problem
by Craig Jackson 11 Oct '06

11 Oct '06

> -----Original Message----- > From: "M. Tolga Özses" [mailto:mtozses@sabanciuniv.edu] > Sent: Wednesday, October 11, 2006 12:52 AM > To: Craig Jackson > Subject: Re: [Dovecot] Strange Mysql connect problem > > > Hi, > > Is MySQL even running? > > Yes. Other applications are using it. It is a production mail server.

1 0

[Dovecot] sieve deliver and sun cc compilers
by lenny＠edpausa.com 10 Oct '06

10 Oct '06

sieve deliver still doesn't build with Sun cc. any suggestions ? thank you. cc -DHAVE_CONFIG_H -I. -I. -I../.. -I/export/home/sho/src/dovecot/rc8/dovecot-1.0.rc8 -I/export/home/sho/src/dovecot/rc8/dovecot-1.0.rc8/src/lib -I../../src -I/opt/SUNWconn/crypto/include -xjobs=4 -c comparator.c -KPIC -DPIC -o .libs/comparator.o "comparator.c", line 149: syntax error before or at: __attribute__ "comparator.c", line 149: warning: undefined or missing type for: __attribute__ "comparator.c", line 212: warning: statement not reached "comparator.c", line 213: cannot recover from previous errors cc: acomp failed for comparator.c *** Error code 1 make: Fatal error: Command failed for target `comparator.lo' Current working directory /mnt/sho/src/dovecot/rc8/dovecot-sieve/src/libsieve *** Error code 1 make: Fatal error: Command failed for target `all-recursive' Current working directory /mnt/sho/src/dovecot/rc8/dovecot-sieve/src *** Error code 1 make: Fatal error: Command failed for target `all-recursive' Current working directory /mnt/sho/src/dovecot/rc8/dovecot-sieve *** Error code 1 make: Fatal error: Command failed for target `all'

3 5

[Dovecot] Executing SQL update upon login
by Tom Sommer 10 Oct '06

10 Oct '06

Hi, I'm using SQL authentication in dovecot, and was wondering if anyone had any ideas as to how I could run an UPDATE statement upon each login, to set time of last login (and other interesting stuff) in the database table. -- Tom

4 8

[Dovecot] How Dovecot handles email changed by file operations
by Craig Jackson 10 Oct '06

10 Oct '06

Hi, We have been using Courier-imap for a few years. I am always in the process of reviewing competing software, and hence my interest in Dovecot. Question: If email files are moved between IMAP folders (on the same IMAP server or a different one) or deleted using shell scripts, how does this impact Dovecot's indexes or its method of keeping track of the email? How likely is index or file corruption or race condition? An example, is the centralized removal of mail in all users' Junk folder older than 30 days. We use Maildir format and Dovecot 1.0-RC7 with Mysql. We have about 150 users. Thanks. Craig

3 2

Re: [Dovecot] Out of memory errors
by Bill Boebel 10 Oct '06

10 Oct '06

On Tue, October 10, 2006 1:44 am, Timo Sirainen <tss(a)iki.fi> said: > On Mon, 2006-10-09 at 21:32 -0400, Bill Boebel wrote: >> Do these errors indicate a memory leak? I see them in the logs a few times per >> day on each of our servers, running CVS dovecot-20060924... >> >> Oct 8 22:21:30 mail38b dovecot: auth(default): block_alloc(): Out of memory >> Oct 8 22:21:30 mail38b dovecot: child 6391 (auth) returned error 83 (Out of >> memory) >> Oct 9 20:05:05 mail38b dovecot: auth(default): pool_system_realloc(): Out of >> memory >> Oct 9 20:05:05 mail38b dovecot: child 655 (auth) returned error 83 (Out of >> memory) > > Could be. What passdb and userdb are you using? Are you using anything > else than plaintext auth? > We are using ldap and passwd: passdb ldap { args = /etc/dovecot-ldap.conf } userdb ldap { args = /etc/dovecot-ldap.conf } passdb passwd-file { args = /etc/dovecot-master.passwd master = yes } And we are only using plain-text auth. Bill

2 1