- dovecot - dovecot.org

[Dovecot] Compile trouble with mysql
by Tim Schaefer 26 Aug '05

26 Aug '05

Hi, I had a devil of a time compiling Dovecot with MySQL, but got it as follows: MYSQL=/usr export CPPFLAGS="-I${MYSQL}/include -I${MYSQL}/lib -I/usr/local/ssl/ -I/usr/local/ssl/include/ " export LDFLAGS="-L${MYSQL}/lib -R${MYSQL}/lib -I${MYSQL}/include -I${MYSQL}/lib -L/usr/local/lib -L/usr/local/ssl/lib" export SSL_FLAGS="-I/usr/local/ssl/ -I/usr/local/ssl/include/" export SSL_LIBS="-L/usr/local/lib -L/usr/local/ssl/lib" ./configure --localstatedir=/var --with-mysql=/usr ... Install prefix ...................... : /usr/local File offsets ........................ : 64bit I/O loop method ..................... : poll File change notification method ..... : dnotify Building with SSL support ........... : yes (OpenSSL) Building with IPv6 support .......... : yes Building with pop3 server ........... : yes Building with mail delivery agent .. : yes Building with user database modules . : static passdb passwd passwd-file checkpassword mysql (modules) Building with password lookup modules : passwd passwd-file shadow pam checkpassword mysql (modules) This is basically for somebody who RPM'd MySQL into /usr . I also figured out the less you give ./configure the better off you are. And...maybe you could help **me**.. :-) If you could post a few samples of how to actually connect to MySQL that would be great, for some reason I STILL cannot connect to MySQL even though I know the user/pass works for my dovecot userid. I know MySQL is compiled into dovecot but still cannot get the connect to work. I've tried: my dovecot.conf: auth default { mechanisms = plain passdb sql { args = /usr/local/etc/dovecot-mysql.conf } userdb sql { args = /usr/local/etc/dovecot-mysql.conf } } my dovecot-mysql.conf: driver = mysql connect = host=127.0.0.1 dbname=dovecot user=dovecot password=dovecot port=3306 connect = host=mydomain dbname=dovecot user=postfix password=postfix port=3306 connect = host=mydomain dbname=dovecot user=dovecot password=dovecot port=3306 connect = host=localhost dbname=dovecot user=dovecot password=dovecot port=3306 connect = host=/var/lib/mysql/mysql.sock dbname=dovecot user=dovecot password=dovecot port=3306 I get: Aug 26 10:45:35 dovecot: auth-worker(default_with_listener): mysql: Connect failed to (null) (dovecot): Access denied for user 'dovecot'@'localhost' (using password: YES) - waiting for 1 seconds before retry Aug 26 10:45:35 dovecot: auth-worker(default): mysql: Connect failed to (null) (dovecot): Access denied for user 'dovecot'@'localhost' (using password: YES) - waiting for 1 seconds before retry Aug 26 10:47:17 dovecot: Killed with signal 15 Aug 26 10:47:21 dovecot: auth-worker(default): mysql: Connect failed to (null) (dovecot): Access denied for user 'dovecot'@'localhost' (using password: YES) - waiting for 1 seconds before retry Help! Tim

1 0

[Dovecot] Compile trouble with mysql
by Tim Schaefer 26 Aug '05

26 Aug '05

1 0

[Dovecot] Dovecot.1.0.alpha1+mysql+mysql
by jigen 26 Aug '05

26 Aug '05

Hi, we are trying to track down the problem that prevents two mysql password databases from working. Instead of connecting to each database, it looks like dovecot tries to connect *twice* to the second specified. Do do this we just inserted some i_warning()s in the code. We noticed that passdb_sql_init (auth/passdb-sql.c) is called twice, once per configuration file, with the correct argument (path to config file). However, as you can see in the following maillog piece, this function calls sql_connect with the SAME parameters (the parameters of the second database). So the first call works and dovecot connects to the host correctly (lines 7-8), but in the second call dovecot finds the connection already up and obviously doesn't try again (last line). Could this be the origin of the problem? Now we are trying to understand why the argument to sql_connect isn't updated correctly. Maybe a bug in the linked list of sql_connection's? [...] dovecot: auth-worker(default): passdb_sql_init("/etc/dovecot/dovecot-mysql_django.conf") [...] dovecot: auth-worker(default): now calling sql_connect(passdb_sql_conn->db): [...] dovecot: auth-worker(default): passdb_sql_conn->config_path="/etc/dovecot/dovecot-mysql_debord.conf" [...] dovecot: auth-worker(default): passdb_sql_conn->set.connect="host=debord port=3306 dbname=posta_debord user=posta password=foobar" [...] dovecot: auth-worker(default): driver_mysql_connect: host=debord, user=posta, password=foobar. [...] dovecot: auth-worker(default): driver_mysql_connect: conn=0x3c00a6b0 [...] dovecot: auth-worker(default): actually connecting to debord [...] dovecot: auth-worker(default): mysql: Connected to debord (posta_debord) [...] dovecot: auth-worker(default): passdb_sql_init("/etc/dovecot/dovecot-mysql_debord.conf") [...] dovecot: auth-worker(default): now calling sql_connect(passdb_sql_conn->db): [...] dovecot: auth-worker(default): passdb_sql_conn->config_path="/etc/dovecot/dovecot-mysql_debord.conf" [...] dovecot: auth-worker(default): passdb_sql_conn->set.connect="host=debord port=3306 dbname=posta_debord user=posta password=foobar" [...] dovecot: auth-worker(default): driver_mysql_connect: host=debord, user=posta, password=foobar. [...] dovecot: auth-worker(default): driver_mysql_connect: conn=0x3c00a6b0 [...] dovecot: auth-worker(default): already connected to debord!!!! altivec & jigen

1 0

[Dovecot] Dovecot Virtual Users & Sendmail
by Chris Hogan 26 Aug '05

26 Aug '05

Not directly Dovecot, but a configuration problem. We have a working set-up with Dovecot+Procmail+Sendmail, using POP-before-SMTP. We want to be able to offer email accounts to some local schools, using SquirrelMail (keeps their costs & maintenance down). The whole arrangement is working, but we don't want to have to have 300+ School children as users of our Red Hat Enterprise server, so I've set up a passwd style file for authentication. This all works fine, they can access mailboxes & send emails, but to receive Sendmail is checking that they are unix users & bounces messages back if they aren't in /etc/passwd too. Has anybody ever got Sendmail working with Dovecot virtual users? Or is it time I switched to Postfix? Chris Hogan

3 2

[Dovecot] 1.0alpha1: assert and core
by Jeff A. Earickson 26 Aug '05

26 Aug '05

Hi, I've been running 1.0alpha1 in production since August 18, and got my first assert and core yesterday. Otherwise it has been running flawlessly. My setup: Sun E220R, Solaris 9, compiled dovecot with gcc 4.0.1, configured dovecot like so: #!/usr/bin/sh VERSION=1.0-alpha1 CC=gcc CFLAGS="-g -O" CPPFLAGS=-I/opt/openssl/include LDFLAGS=-L/opt/openssl/lib \ ./configure --prefix=/opt/dovecot.$VERSION --with-ssl=openssl \ --with-ssldir=/opt/openssl/ssl > configure.out The syslog message: Aug 25 04:15:43 emerald dovecot: [ID 107833 mail.error] IMAP(user): file mbox-sync-update.c: line 442 (mbox_sync_update_header_from): assertion failed: (ctx->mail.uid == 0 || ctx->mail.uid_broken || ctx->mail.uid == mail->uid) Gdb analysis of the resulting core file is attached, I hope this helps. The user's mailbox is 41003432 bytes in size. Jeff Earickson Colby College

1 0

[Dovecot] [Fwd: Re:Dovecot] Finally PEBKAC was Failed authentication to a mysql database (bug or PEBKAC?)]
by jigen 25 Aug '05

25 Aug '05

-----Forwarded Message----- From: jigen <jigen(a)metalabs.org> To: Timo Sirainen <tss(a)iki.fi> Subject: Re:Dovecot] Finally PEBKAC was Failed authentication to a mysql database (bug or PEBKAC?) Date: Sat, 20 Aug 2005 18:33:11 +0200 On Fri, 2005-08-19 at 16:56, Timo Sirainen wrote: > Dovecot just passes these values to Mysql library without doing anything > to them itself. So if it happens, it's Mysql library bug. It isn't a bug of mysql or dovecot. It's the most simple problem: mysql permissions :P In mysql 127.0.0.1 and localhost are differents things, and if you copy the user (posta in my case), it doesn't copy the password (and so it works without a password). And more: if you put password, you have to flush privileges. Finally PEBKAC :| > > One more question: how I can specify more different mysql-db conteining > > different users? > > I try in the following way: > > passdb sql { > > args = /etc/dovecot/dovecot-mysql_debord.conf > > } > > passdb sql { > > args = /etc/dovecot/dovecot-mysql_django.conf > > } > > This should work. After trying to authenticate against the first one it > should try the second. Although I'm not sure if I've tried two passdb > sqls before, maybe Dovecot has problems with that.. Well, I'll try once > I get home. I'm working on this problem, but at the moment it doesn't work. It always connects only to second db. Another PEBKAC? This is my configuration file, maybe there's something wrong. (i've cut out commented lines) ----dovecot.conf---- base_dir = /var/run/dovecot/ protocols = imap imaps pop3 pop3s ssl_disable = yes ssl_cert_file = /etc/ssl/django_posta.pem ssl_key_file = /etc/ssl/private/django_posta.pem verbose_proctitle = yes verbose_ssl = yes first_valid_uid = 507 last_valid_uid = 507 first_valid_gid = 507 last_valid_gid = 507 default_mail_env = maildir:/var/vmail/%d/%n@%d/ mail_full_filesystem_access = yes protocol imap { } protocol pop3 { } auth_verbose = yes auth_debug = yes auth default { mechanisms = plain passdb sql { args = /etc/dovecot/dovecot-mysql_debord.conf } passdb sql { args = /etc/dovecot/dovecot-mysql_django.conf } userdb static { args = uid=507 gid=507 } user = root count = 2 } --------------- ciao jigen

1 0

[Dovecot] Thread sorting problem
by Greg Trounson 24 Aug '05

24 Aug '05

I've just installed Dovecot on a Debian Sarge machine and am seeing some very strange thread sorting. In Mozilla Mail and Thunderbird on both Fedora and Debian clients my threads served up by Dovecot look like this (number denotes message time): |-11 | `-12 |-2 |-3 |-4 | `-5 | `-6 | `-7 | `-8 |-1 `-9 `-10 Where the exact same threads served by Sendmail/imap look like this: |-1 |-2 |-3 |-4 | `-5 | `-6 | `-7 | `-8 |-9 | `-10 |-11 | `-12 Squirrelmail shows the threads correctly in both cases too, so I suspect there might be something funny going on with how Thunderbird handles Maildir threads. I notice that Dovecot doesn't support the THREAD=ORDEREDSUBJECT capability, might that have something to do with it? thanks, Greg

3 2

[Dovecot] verbose imap logging
by Jens Laas 24 Aug '05

24 Aug '05

Implements more verbose imap logging (when client exits). Similar to existing logging in POP3. Due to the nature of imap and my incomplete understanding (of the dovecot code) the session statistics reported have varying accuracy. Much better than nothing IMO. Cheers, Jens ----------------------------------------------------------------------- 'This mail automatically becomes portable when carried.' ----------------------------------------------------------------------- Jens Låås Email: jens.laas(a)data.slu.se Department of Computer Services, SLU Phone: +46 18 67 35 15 Vindbrovägen 1 P.O. Box 7079 S-750 07 Uppsala SWEDEN -----------------------------------------------------------------------

1 0

[Dovecot] thunderbird pop3 delete bug workaround
by Jens Laas 24 Aug '05

24 Aug '05

Following is patch that allows tbird to download and redelete the last deleted message. Not particularily nice but for "normal" usage the bug/workaround is not triggered. Tested with huge inbox. --- src/pop3/client.h.orig 2005-08-23 15:00:48.000000000 +0200 +++ src/pop3/client.h 2005-08-23 15:02:18.000000000 +0200 @@ -35,6 +35,9 @@ unsigned int top_count; unsigned int retr_count; + unsigned int last_deleted; + int tbirdbug; + uoff_t *byte_counter; uoff_t byte_counter_offset; --- src/pop3/commands.c.orig 2005-08-24 13:24:33.000000000 +0200 +++ src/pop3/commands.c 2005-08-24 13:26:49.000000000 +0200 @@ -47,8 +47,15 @@ if (client->deleted) { if (client->deleted_bitmask[num / CHAR_BIT] & (1 << (num % CHAR_BIT))) { - client_send_line(client, "-ERR Message is deleted."); - return NULL; + if((client->tbirdbug<256) && (num == client->last_deleted)) + { + client->tbirdbug++; + } + else + { + client_send_line(client, "-ERR Message is deleted."); + return NULL; + } } } @@ -109,6 +116,7 @@ client->deleted_count++; client->deleted_size += client->message_sizes[msgnum]; client_send_line(client, "+OK Marked to be deleted."); + client->last_deleted = msgnum; return TRUE; } ----------------------------------------------------------------------- 'This mail automatically becomes portable when carried.' ----------------------------------------------------------------------- Jens Låås Email: jens.laas(a)data.slu.se Department of Computer Services, SLU Phone: +46 18 67 35 15 Vindbrovägen 1 P.O. Box 7079 S-750 07 Uppsala SWEDEN -----------------------------------------------------------------------

1 0

[Dovecot] Dovecot Deliver?
by Marc Perkel 24 Aug '05

24 Aug '05

I guess Dovecot has an LDA called deliver. What is it and how do I use it? Or is it ready to be used. can't find any docs on it. -- Marc Perkel - marc(a)perkel.com Spam Filter: http://www.junkemailfilter.com My Blog: http://marc.perkel.com

9 18