- dovecot - dovecot.org

[Dovecot] Re: Dovecot not starting
by Antonin Karasek 06 Sep '03

06 Sep '03

Thanks for fast response :) This is copy of syslog: Sep 5 17:58:40 cernunnos dovecot: Dovecot starting up Sep 5 17:58:41 cernunnos dovecot: Auth process died too early - shutting down Sep 5 17:58:41 cernunnos dovecot: child 4327 (auth) returned error 11 Sep 5 17:58:41 cernunnos pop3-login: fd_send(-1) failed: Broken pipe Alejandro Martinez writes: > Did you see the logs ? > > -----Mensaje original----- > De: Antonin Karasek [mailto:lists@ceskyserver.cz] > Enviado el: viernes, 05 de septiembre de 2003 12:46 > Para: dovecot(a)procontrol.fi > Asunto: [Dovecot] Dovecot not starting > > > Hello everybody, > sorry for stupid qustion, but I have following problem: > I succesfully installed Dovecot on Debian (from source). Now I want to > run > it. I tryed: > # /usr/local/dovecot/sbin/dovecot > # > but nothing happened: > # ps -Af | grep dove > ....... ps -Af | grep dove > # > > What is wrong? > > I want Dovecot to serve POP3 over SSL. > > Many thanks and sorry again :o)

2 1

[Dovecot] still getting weird .{inbox} folder creations with latest -test7
by Charlie Allom 06 Sep '03

06 Sep '03

Hi, I am still getting strange creation and mailbox lookups from 0.99.11-test7. dovecot creates in ~/Maildir/ .INBOX/ .imap.index .imap.index.cache .imap.index.log .customflags dovecot-uidlist .INBOX seems to be a reference to ~/Maildir/{cur,new,tmp} yet I cannot get an IMAP client uo pick up my other maildir, located at ~/Maildir/mi/{cur,new,tmp}. In Apple's Mail.app, it picks up a file called ~/Maildir/.procmaillog as if it were a maildir directory! This is with the Mail.app preference for "IMAP Path Prefix" set to null. mutt just seems plain confused. I have these settings: # imap styleee set folder=imap://yeled@lazy.spodder.com/ set mbox=imap://yeled@lazy.spodder.com/mbox set record=imap://yeled@lazy.spodder.com/sent set postponed=imap://yeled@lazy.spodder.com/postponed set spoolfile=imap://yeled@lazy.spodder.com/ set certificate_file=~/.mutt/certificates set mail_check=10 set timeout=10 set imap_home_namespace="" set imap_pass="foo" I have included the tcpflow files to show what the clients are doing.. Is it normal to search for folders starting with "." ? Why won't it just pick up my normally nested maildir folders? C. -- charlie(a)rubberduck.com - http://rubberduck.com/~yeled/

4 4

[Dovecot] dovecot, vpopmail and djb's tcpserver
by Lasse Danielsen 06 Sep '03

06 Sep '03

Hello! I've tried to set up dovecot in conjuction with vpopmail, and running it under djb's tcpserver instead of (x)inetd. Btw - there was no reference to setting dovecot up using (x)inetd either in the manuals/faqs i read, though I didn't search all that hard. Anyway, back to my Q: vpopmail uses vchkpw as an authentication mechanism, and with tcpserver I can do relaycontrol (based on vchkpw) with roaming users. Is there anyone who have tried this, and succeeded? Right now I use two imap services to accomplish this (bincimap has support for vchkpw). Thank you for any response. - Lasse Danielsen Never argue with an idiot. He'll drag you down to his level, then beat you with experience.

4 5

[Dovecot] pine, INBOX, and dovecot
by Jethro R Binks 04 Sep '03

04 Sep '03

Hi all, I've been experimenting with Dovecot; tests with Maildir seemed to work fine. However, now I'm trying with mbox folders, and I'm having a problem where I do not get an INBOX listed using pine. Outlook Express and IMP show it fine. I snooped part of the session, which appears to go like this (it is slightly garbled, sorry -- I couldn't get rawlog to work by creating dovecot.rawlog in the mail home directory): 00000002 CAPABILITY\r\n * CAPABILITY IMAP4rev1 SORT THREAD=REFERENCES MULTIAPPEND UN 00000003 LIST "" %\r\n" * LIST (\NoInferiors) "/" INBOX * LIST (\NoInferiors \UnMarked) "/" "test" * LIST (\NoInferiors \UnMarked) ""/" "Sent Items" * LIST (\NoInferiors \UnMarked) "/" "Drafts" 0000000a OK List .completed.. Pine just displays "test", "Sent Items", and "Drafts". OE happily downloads mail from the inbox I put there, and IMP can see it and read it. Perhaps there is something there that IMAP protocol people might see. Or else, perhaps there is a known reason why pine does this? Any clues would be appreciated - I browsed the list archives but couldn't spot anything very relevant. Pine version is very recent - I updated today to 4.56. Incidentally, is mbox support still broken in the CVS version? Is there an expected timescale for the next release, preferably with mbox fixed again?! Thanks for any advice. Jethro. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Jethro R Binks Computing Officer, IT Services University Of Strathclyde, Glasgow, UK

2 2

Re: [Dovecot] How do i load a configfile ?
by Tweek 01 Sep '03

01 Sep '03

>which does everything itself without loading the config file it dosen't do anything - i can connect to the server but thats all. how should the server know where i store my mboxes etc. i must load the config file - but how ? ----- Original Message ----- From: "Timo Sirainen" <tss(a)iki.fi> To: <dovecot(a)procontrol.fi> Sent: Monday, September 01, 2003 8:07 PM Subject: Re: [Dovecot] How do i load a configfile ? > On Mon, 2003-09-01 at 20:57, Tweek wrote: > > hello, > > > > this may be a very stupid question but how do i load a config file? > > i didn't find the docs part which explains how to start the imapserver at > > all. > > There's two possibilities: Run the "dovecot" binary which does > everything itself, or start imap-login from inetd. > > > server = /usr/local/dovecot/imap > > So imap-login here :) > > -- E-Mail by http://www.jesus.ch/ and http://www.livenet.ch/ News, Magazin, Events, Forum, Chat, Free E-Mail, Dialin, Jobs, Top-Newsletter

2 2

[Dovecot] How do i load a configfile ?
by Tweek 01 Sep '03

01 Sep '03

hello, this may be a very stupid question but how do i load a config file? i didn't find the docs part which explains how to start the imapserver at all. i have put this in my xinetd.conf: service imap { disable = no socket_type = stream protocol = tcp wait = no user = root server = /usr/local/dovecot/imap flags = IPv4 } and the server is running, but thats all. as u can see i have installed the server in /usr/local/dovecot and i have put the config file in /etc, /usr/local/etc and the programmdir itself - nothing worked. what commands must i write in the xinetd.conf to get the server running ? thanks -- E-Mail by http://www.jesus.ch/ and http://www.livenet.ch/ News, Magazin, Events, Forum, Chat, Free E-Mail, Dialin, Jobs, Top-Newsletter

2 1

[Dovecot] observations about delays
by Eric S. Johansson 01 Sep '03

01 Sep '03

I've tried two imap clients (mahogany and Mozilla) and they both have strange delays and weird failures. As a reminder, I am using mbox format mailboxes on the server and client side filtering of messages from the inbox. In both cases when the client fetches messages from the inbox and starts redistributing them, CPU utilization on the imap server goes to around 40 percent for Mozilla and around 90 percent for mahogany. There are long delays on the order of two minutes when filtering messages. or 30 to 50 seconds when opening a mailbox. Other than the performance problems, Mozilla is relatively well-behaved. Mahogany on the other hand is a bit more rough and (not) ready. It uses c-client for its imap code and during the filter driven message redistribution process, it all of a sudden started started complaining about unexpected EOF and I found one corrupted message: on 31/8/03 7:36 pm, Morten Christensen at ipcop-d(a)indbakke.dk wrote: >> These bugs might keep many people from trying a new alpha with >> interesting improvements. >> >> A more detailed help for fixing them after install is needed. OK, I'll have a From esj(a)harvee.org Sun Aug 31 16:01:21 2003 Return-Path: <ipcop-devel-admin(a)lists.sourceforge.net> Received: from red.harvee.home (red [192.168.25.1] (may be forged)) by harvee.org (8.12.8/8.12.8) with ESMTP id h7VK1KiE029762 for <esj(a)harvee.billerica.ma.us>; Sun, 31 Aug 2003 16:01:20 -0400 Received: from sc8-sf-list2.sourceforge.net (lists.sourceforge.net [66.35.250.206]) by red.harvee.home (8.11.6/8.11.6) with ESMTP id h7VK1I111902 for <esj(a)harvee.billerica.ma.us>; Sun, 31 Aug 2003 16:01:19 -0400 Received: from sc8-sf-list1-b.sourceforge.net ([10.3.1.13] helo=sc8-sf-list1.sourceforge.net) I had read this message before it was filtered and moved to the right mailbox. It was complete then. Now it's not so happy. How can I gather more data to make it possible to debug these problems. ---eric

2 2

[Dovecot] Crash when searching messages
by Nicolas STRANSKY 01 Sep '03

01 Sep '03

Hi, I've been encountering a crash when trying to use the "Search messages" function with mozilla on a newly indexed/subscribed mailbox. I tryed to search something in "To or CC" and got the following : Sep 1 09:07:13 aster imap(nico): file message-address.c: line 255 (message_address_write): assertion failed: (addr->domain != NULL) Sep 1 09:07:13 aster dovecot: child 15674 (imap) killed with signal 6 In addition, mozilla gives the following message : "Server mail.neo-lan.net has disconnected. The server may have gone down or there may be a network problem" and the search fails. But there was no problem when doing other searches. After trying several different types of searches, the initial one (on TO or CC) worked fine, but the crash is reproducible on an other newly subscribed mbox. -- Nico Si cela fonctionne, c'est obsolète. Marshall McLuhan

2 1

[Dovecot] conversion to maildir
by Eric S. Johansson 30 Aug '03

30 Aug '03

is really a royal pain in the butt. most of the conversion tools only do a partial job. mb2md seems to be the best but it does not convert the from line correctly unless you are using exim for an MTA. It also does not get the file status right so everything is written to the new maildir directory. something else that makes the process painful is when you have folders containing mailboxes. And the process is *slow* when you have 2 GB of mail (yes, I will be deleting some soon). looks like I will be debugging and rewrapping this package real soon now.. to relate this to dovecot: this is probably not the job of the imap server but it would be real nice to be able to fit in some sort of a plug-in that could automatically do the conversion on a mailbox as it is opened. it would make migrations trivial easy. give me the ability to use python for plug-ins and I will write such a tool. ---eric

11 15

[Dovecot] PATCH: mysql authentication
by Matthew Reimer 30 Aug '03

30 Aug '03

Here's a patch that implements mysql authentication. I started with the pgsql files and tweaked them to use mysql instead. It works for me, but there might be a couple of memory leaks. I'm welcome to suggestions on how to clean it up so it can be committed. Enjoy! Matt diff -u -r --new-file work/dovecot-0.99.10/doc/dovecot-mysql.conf work.patched/dovecot-0.99.10/doc/dovecot-mysql.conf --- work/dovecot-0.99.10/doc/dovecot-mysql.conf Wed Dec 31 18:00:00 1969 +++ work.patched/dovecot-0.99.10/doc/dovecot-mysql.conf Fri Aug 15 13:43:05 2003 @@ -0,0 +1,70 @@ +# For the mysql passdb module, you'll need a database with a table that +# contains fields for at least the userid and password. If you want to +# use the user@domain syntax, you might want to have a separate domain +# field as well. +# +# If your users all have the same uig/gid, and have predictable home +# directories, you can use the static userdb module to generate the home +# dir based on the userid and domain. In this case, you won't need fields +# for home, uid, or gid in the database. +# +# If you prefer to use the mysql userdb module, you'll want to add fields +# for home, uid, and gid. Here is an example table: +# +# CREATE TABLE users ( +# userid VARCHAR(128) NOT NULL, +# password VARCHAR(64) NOT NULL, +# home VARCHAR(256) NOT NULL, +# uid INTEGER NOT NULL, +# gid INTEGER NOT NULL, +# active CHAR(1) DEFAULT 'Y' NOT NULL +# ); + +db_host = localhost +db_port = 3306 +#db_unix_socket = /var/tmp/mysql.sock +db = users +db_user = dovecot-db +db_passwd = opensesame +db_client_flags = 0 + +# Default password scheme. +# +# Currently supported schemes include PLAIN, PLAIN-MD5, DIGEST-MD5, and CRYPT. +# +#default_pass_scheme = PLAIN-MD5 + +# Query to retrieve the password. +# +# The query should return one row, one column. If more than one row or column +# is returned, authentication will automatically fail. +# +# Available substitutions: +# %u = entire userid +# %n = user part of user@domain +# %d = domain part of user@domain +# +# Example: +# password_query = SELECT password FROM users WHERE userid = '%n' AND domain = '%d' +# password_query = SELECT password FROM users WHERE userid = '%u' AND active = 'Y' +# +#password_query = SELECT password FROM users WHERE userid = '%u' + +# Query to retrieve the user information. +# +# The query must return only one row. The columns to return are: +# home - Home directory +# mail - MAIL environment +# system_user - System user name (for initgroups()) +# uid - System UID +# gid - System GID +# +# Either home or mail is required. uid and gid are required. If more than one +# row is returned or there's missing fields, login will automatically fail. +# +# Examples +# user_query = SELECT home, uid, gid FROM users WHERE userid = '%n' AND domain = '%d' +# user_query = SELECT dir AS home, user AS uid, group AS gid FROM users where userid = '%u' +# user_query = SELECT home, 501 AS uid, 501 AS gid FROM users WHERE userid = '%u' +# +#user_query = SELECT home, uid, gid FROM users WHERE userid = '%u' diff -u -r --new-file work/dovecot-0.99.10/src/auth/Makefile.am work.patched/dovecot-0.99.10/src/auth/Makefile.am --- work/dovecot-0.99.10/src/auth/Makefile.am Sun May 18 07:26:28 2003 +++ work.patched/dovecot-0.99.10/src/auth/Makefile.am Fri Aug 15 16:47:21 2003 @@ -19,6 +19,7 @@ auth-module.c \ db-ldap.c \ db-pgsql.c \ + db-mysql.c \ db-passwd-file.c \ login-connection.c \ main.c \ @@ -38,6 +39,7 @@ passdb-shadow.c \ passdb-vpopmail.c \ passdb-pgsql.c \ + passdb-mysql.c \ password-scheme.c \ userdb.c \ userdb-ldap.c \ @@ -45,7 +47,8 @@ userdb-passwd-file.c \ userdb-static.c \ userdb-vpopmail.c \ - userdb-pgsql.c + userdb-pgsql.c \ + userdb-mysql.c noinst_HEADERS = \ auth-login-interface.h \ @@ -54,6 +57,7 @@ auth-module.h \ db-ldap.h \ db-pgsql.h \ + db-mysql.h \ db-passwd-file.h \ common.h \ login-connection.h \ diff -u -r --new-file work/dovecot-0.99.10/src/auth/db-mysql.c work.patched/dovecot-0.99.10/src/auth/db-mysql.c --- work/dovecot-0.99.10/src/auth/db-mysql.c Wed Dec 31 18:00:00 1969 +++ work.patched/dovecot-0.99.10/src/auth/db-mysql.c Fri Aug 22 17:56:44 2003 @@ -0,0 +1,181 @@ +/* Copyright (C) 2003 Alex Howansky, Timo Sirainen */ + +#include "config.h" +#undef HAVE_CONFIG_H + +#if defined(PASSDB_MYSQL) || defined(USERDB_MYSQL) + +#include "common.h" +#include "network.h" +#include "str.h" +#include "settings.h" +#include "db-mysql.h" + +#include <limits.h> +#include <stddef.h> +#include <stdlib.h> + +#define DEF(type, name) { type, #name, offsetof(struct mysql_settings, name) } + +static struct setting_def setting_defs[] = { + DEF(SET_STR, db_host), + DEF(SET_STR, db_port), + DEF(SET_STR, db_unix_socket), + DEF(SET_STR, db), + DEF(SET_STR, db_user), + DEF(SET_STR, db_passwd), + DEF(SET_STR, db_client_flags), + DEF(SET_STR, password_query), + DEF(SET_STR, user_query), + DEF(SET_STR, default_pass_scheme) +}; + +struct mysql_settings default_mysql_settings = { + MEMBER(db_host) "localhost", + MEMBER(db_port) "0", + MEMBER(db_unix_socket) "/var/tmp/mysql.sock", + MEMBER(db) "email_accounts", + MEMBER(db_user) "dovecot", + MEMBER(db_passwd) "changeme", + MEMBER(db_client_flags) "0", + MEMBER(password_query) "SELECT password FROM users WHERE userid = '%u'", + MEMBER(user_query) "SELECT home, uid, gid FROM users WHERE userid = '%u'", + MEMBER(default_pass_scheme) "PLAIN-MD5" +}; + +static struct mysql_connection *mysql_connections = NULL; + +static int mysql_conn_open(struct mysql_connection *conn); +static void mysql_conn_close(struct mysql_connection *conn); + +void db_mysql_query(struct mysql_connection *conn, const char *query, + struct mysql_request *request) +{ + MYSQL_RES *res; + int failed; + + if (!conn->connected) { + if (!mysql_conn_open(conn)) { + request->callback(conn, request, NULL); + return; + } + } + + if (verbose_debug) + i_info("MYSQL: Performing query: %s", query); + + if (mysql_query(conn->mysql, query)) + i_info("MYSQL: Error executing query \"%s\": %s", query, + mysql_error(conn->mysql)); + + if ((res = mysql_store_result(conn->mysql))) + failed = FALSE; + else { + i_info("MYSQL: Error retrieving results: %s", + mysql_error(conn->mysql)); + failed = TRUE; + } + + request->callback(conn, request, failed ? NULL : res); + mysql_free_result(res); + i_free(request); +} + +static int mysql_conn_open(struct mysql_connection *conn) +{ + if (conn->connected) + return TRUE; + + if (conn->mysql == NULL) { + conn->mysql = mysql_init(NULL); + if (conn->mysql == NULL) { + i_error("MYSQL: mysql_init failed"); + return FALSE; + } + + if (!mysql_real_connect(conn->mysql, conn->set.db_host, + conn->set.db_user, conn->set.db_passwd, + conn->set.db, + atoi(conn->set.db_port), + conn->set.db_unix_socket, + strtoul(conn->set.db_client_flags, + NULL, 10))) { + i_error("MYSQL: Can't connect to database %s: %s", + conn->set.db, mysql_error(conn->mysql)); + return FALSE; + } + } + + conn->connected = TRUE; + return TRUE; +} + +static void mysql_conn_close(struct mysql_connection *conn) +{ + conn->connected = FALSE; + + if (conn->mysql != NULL) { + mysql_close(conn->mysql); + conn->mysql = NULL; + } +} + +static struct mysql_connection *mysql_conn_find(const char *config_path) +{ + struct mysql_connection *conn; + + for (conn = mysql_connections; conn != NULL; conn = conn->next) { + if (strcmp(conn->config_path, config_path) == 0) + return conn; + } + + return NULL; +} + +static const char *parse_setting(const char *key, const char *value, + void *context) +{ + struct mysql_connection *conn = context; + + return parse_setting_from_defs(conn->pool, setting_defs, + &conn->set, key, value); +} + +struct mysql_connection *db_mysql_init(const char *config_path) +{ + struct mysql_connection *conn; + pool_t pool; + + conn = mysql_conn_find(config_path); + if (conn != NULL) { + conn->refcount++; + return conn; + } + + pool = pool_alloconly_create("mysql_connection", 1024); + conn = p_new(pool, struct mysql_connection, 1); + conn->pool = pool; + + conn->refcount = 1; + + conn->config_path = p_strdup(pool, config_path); + conn->set = default_mysql_settings; + settings_read(config_path, parse_setting, conn); + + (void)mysql_conn_open(conn); + + conn->next = mysql_connections; + mysql_connections = conn; + return conn; +} + +void db_mysql_unref(struct mysql_connection *conn) +{ + if (--conn->refcount > 0) + return; + + mysql_conn_close(conn); + pool_unref(conn->pool); +} + +#endif diff -u -r --new-file work/dovecot-0.99.10/src/auth/db-mysql.h work.patched/dovecot-0.99.10/src/auth/db-mysql.h --- work/dovecot-0.99.10/src/auth/db-mysql.h Wed Dec 31 18:00:00 1969 +++ work.patched/dovecot-0.99.10/src/auth/db-mysql.h Fri Aug 15 13:40:56 2003 @@ -0,0 +1,51 @@ +#ifndef __DB_MYSQL_H +#define __DB_MYSQL_H + +#include <mysql.h> + +struct mysql_connection; +struct mysql_request; + +typedef void mysql_query_callback_t(struct mysql_connection *conn, + struct mysql_request *request, + MYSQL_RES *res); + +struct mysql_settings { + const char *db_host; + const char *db_port; + const char *db_unix_socket; + const char *db; + const char *db_user; + const char *db_passwd; + const char *db_client_flags; + const char *password_query; + const char *user_query; + const char *default_pass_scheme; +}; + +struct mysql_connection { + struct mysql_connection *next; + + pool_t pool; + int refcount; + + char *config_path; + struct mysql_settings set; + + MYSQL *mysql; + + unsigned int connected:1; +}; + +struct mysql_request { + mysql_query_callback_t *callback; + void *context; +}; + +void db_mysql_query(struct mysql_connection *conn, const char *query, + struct mysql_request *request); + +struct mysql_connection *db_mysql_init(const char *config_path); +void db_mysql_unref(struct mysql_connection *conn); + +#endif diff -u -r --new-file work/dovecot-0.99.10/src/auth/master-connection.c work.patched/dovecot-0.99.10/src/auth/master-connection.c --- work/dovecot-0.99.10/src/auth/master-connection.c Mon May 26 10:27:13 2003 +++ work.patched/dovecot-0.99.10/src/auth/master-connection.c Fri Aug 22 17:56:18 2003 @@ -55,7 +55,7 @@ reply.virtual_user_idx = reply_add(buf, user->virtual_user); reply.mail_idx = reply_add(buf, user->mail); - p = strstr(user->home, "/./"); + p = user->home ? strstr(user->home, "/./") : NULL; if (p == NULL) { reply.home_idx = reply_add(buf, user->home); reply.chroot_idx = reply_add(buf, NULL); diff -u -r --new-file work/dovecot-0.99.10/src/auth/passdb-mysql.c work.patched/dovecot-0.99.10/src/auth/passdb-mysql.c --- work/dovecot-0.99.10/src/auth/passdb-mysql.c Wed Dec 31 18:00:00 1969 +++ work.patched/dovecot-0.99.10/src/auth/passdb-mysql.c Fri Aug 15 14:24:44 2003 @@ -0,0 +1,171 @@ +/* Copyright (C) 2003 Alex Howansky, Timo Sirainen */ + +#include "config.h" +#undef HAVE_CONFIG_H + +#ifdef PASSDB_MYSQL + +#include "common.h" +#include "str.h" +#include "strescape.h" +#include "var-expand.h" +#include "password-scheme.h" +#include "db-mysql.h" +#include "passdb.h" + +#include <mysql.h> +#include <stdlib.h> +#include <string.h> + +struct passdb_mysql_connection { + struct mysql_connection *conn; +}; + +struct passdb_mysql_request { + struct mysql_request request; + + enum passdb_credentials credentials; + union { + verify_plain_callback_t *verify_plain; + lookup_credentials_callback_t *lookup_credentials; + } callback; + + char password[1]; +}; + +static struct passdb_mysql_connection *passdb_mysql_conn; + +static void mysql_handle_request(struct mysql_connection *conn, + struct mysql_request *request, MYSQL_RES *res) +{ + struct passdb_mysql_request *mysql_request = + (struct passdb_mysql_request *) request; + struct auth_request *auth_request = request->context; + const char *user, *password, *scheme; + int ret = 0; + + user = auth_request->user; + password = NULL; + + if (res != NULL) { + if (mysql_num_rows(res) == 0) { + if (verbose) + i_info("mysql(%s): Unknown user", user); + } else if (mysql_num_rows(res) > 1) { + i_error("mysql(%s): Multiple matches for user", user); + } else if (mysql_num_fields(res) != 1) { + i_error("mysql(%s): Password query returned " + "more than one field", user); + } else { + MYSQL_ROW row; + + row = mysql_fetch_row(res); + if (row) + password = t_strdup(row[0]); /* XXX binary? */ + } + } + + scheme = password_get_scheme(&password); + if (scheme == NULL) { + scheme = conn->set.default_pass_scheme; + i_assert(scheme != NULL); + } + + if (mysql_request->credentials != -1) { + passdb_handle_credentials(mysql_request->credentials, + user, password, scheme, + mysql_request->callback.lookup_credentials, + auth_request); + return; + } + + /* verify plain */ + if (password == NULL) { + mysql_request->callback.verify_plain(PASSDB_RESULT_USER_UNKNOWN, + auth_request); + return; + } + + ret = password_verify(mysql_request->password, password, + scheme, user); + if (ret < 0) + i_error("mysql(%s): Unknown password scheme %s", user, scheme); + else if (ret == 0) { + if (verbose) + i_info("mysql(%s): Password mismatch", user); + } + + mysql_request->callback.verify_plain(ret > 0 ? PASSDB_RESULT_OK : + PASSDB_RESULT_PASSWORD_MISMATCH, + auth_request); +} + +static void mysql_lookup_pass(struct auth_request *auth_request, + struct mysql_request *mysql_request) +{ + struct mysql_connection *conn = passdb_mysql_conn->conn; + const char *query; + string_t *str; + + str = t_str_new(512); + var_expand(str, conn->set.password_query, + str_escape(auth_request->user), NULL); + query = str_c(str); + + mysql_request->callback = mysql_handle_request; + mysql_request->context = auth_request; + + db_mysql_query(conn, query, mysql_request); +} + +static void +mysql_verify_plain(struct auth_request *request, const char *password, + verify_plain_callback_t *callback) +{ + struct passdb_mysql_request *mysql_request; + + mysql_request = i_malloc(sizeof(struct passdb_mysql_request) + + strlen(password)); + mysql_request->credentials = -1; + mysql_request->callback.verify_plain = callback; + strcpy(mysql_request->password, password); + + mysql_lookup_pass(request, &mysql_request->request); +} + +static void mysql_lookup_credentials(struct auth_request *request, + enum passdb_credentials credentials, + lookup_credentials_callback_t *callback) +{ + struct passdb_mysql_request *mysql_request; + + mysql_request = i_new(struct passdb_mysql_request, 1); + mysql_request->credentials = credentials; + mysql_request->callback.lookup_credentials = callback; + + mysql_lookup_pass(request, &mysql_request->request); +} + +static void passdb_mysql_init(const char *args) +{ + struct mysql_connection *conn; + + passdb_mysql_conn = i_new(struct passdb_mysql_connection, 1); + passdb_mysql_conn->conn = conn = db_mysql_init(args); +} + +static void passdb_mysql_deinit(void) +{ + db_mysql_unref(passdb_mysql_conn->conn); + i_free(passdb_mysql_conn); +} + +struct passdb_module passdb_mysql = { + passdb_mysql_init, + passdb_mysql_deinit, + + mysql_verify_plain, + mysql_lookup_credentials +}; + +#endif diff -u -r --new-file work/dovecot-0.99.10/src/auth/passdb.c work.patched/dovecot-0.99.10/src/auth/passdb.c --- work/dovecot-0.99.10/src/auth/passdb.c Sun May 18 07:26:28 2003 +++ work.patched/dovecot-0.99.10/src/auth/passdb.c Fri Aug 15 11:39:31 2003 @@ -110,6 +110,10 @@ if (strcasecmp(name, "pgsql") == 0) passdb = &passdb_pgsql; #endif +#ifdef PASSDB_MYSQL + if (strcasecmp(name, "mysql") == 0) + passdb = &passdb_mysql; +#endif #ifdef HAVE_MODULES passdb_module = passdb != NULL ? NULL : auth_module_open(name); if (passdb_module != NULL) { diff -u -r --new-file work/dovecot-0.99.10/src/auth/passdb.h work.patched/dovecot-0.99.10/src/auth/passdb.h --- work/dovecot-0.99.10/src/auth/passdb.h Thu Mar 20 09:46:33 2003 +++ work.patched/dovecot-0.99.10/src/auth/passdb.h Fri Aug 15 16:45:43 2003 @@ -58,6 +58,7 @@ extern struct passdb_module passdb_vpopmail; extern struct passdb_module passdb_ldap; extern struct passdb_module passdb_pgsql; +extern struct passdb_module passdb_mysql; void passdb_init(void); void passdb_deinit(void); diff -u -r --new-file work/dovecot-0.99.10/src/auth/userdb-mysql.c work.patched/dovecot-0.99.10/src/auth/userdb-mysql.c --- work/dovecot-0.99.10/src/auth/userdb-mysql.c Wed Dec 31 18:00:00 1969 +++ work.patched/dovecot-0.99.10/src/auth/userdb-mysql.c Fri Aug 22 17:53:56 2003 @@ -0,0 +1,148 @@ +/* Copyright (C) 2003 Alex Howansky, Timo Sirainen */ + +#include "config.h" +#undef HAVE_CONFIG_H + +#ifdef USERDB_MYSQL + +#include "common.h" +#include "str.h" +#include "strescape.h" +#include "var-expand.h" +#include "db-mysql.h" +#include "userdb.h" + +#include <mysql.h> +#include <stdlib.h> +#include <string.h> + +struct userdb_mysql_connection { + struct mysql_connection *conn; +}; + +struct userdb_mysql_request { + struct mysql_request request; + userdb_callback_t *userdb_callback; + + char username[1]; /* variable width */ +}; + +static struct userdb_mysql_connection *userdb_mysql_conn; + +static int is_result_valid(MYSQL_RES *res) +{ + + if (res == NULL) { + i_error("MYSQL: Query failed"); + return FALSE; + } + + if (mysql_num_rows(res) == 0) { + if (verbose) + i_error("MYSQL: Authenticated user not found"); + return FALSE; + } + + /* XXX */ + if (mysql_num_fields(res) < 3) { + i_error("MYSQL: Not enough fields returned"); + return FALSE; + } +/* XXX + if (PQfnumber(res, "uid") == -1) { + i_error("MYSQL: User query did not return 'uid' field"); + return FALSE; + } + + if (PQfnumber(res, "gid") == -1) { + i_error("MYSQL: User query did not return 'gid' field"); + return FALSE; + } +*/ + + return TRUE; +} + +static const char *my_get_str(MYSQL_RES *res, MYSQL_ROW row, const char *field) +{ + int i, n_fields; + unsigned long *lengths; + MYSQL_FIELD *fields; + + n_fields = mysql_num_fields(res); + lengths = mysql_fetch_lengths(res); + fields = mysql_fetch_fields(res); + for (i = 0; i < n_fields; i++) + if (strcmp(field, fields[i].name) == 0) + return (const char *) lengths[i] == 0 ? + NULL : t_strdup(row[i]); + + return NULL; +} + +static void mysql_handle_request(struct mysql_connection *conn __attr_unused__, + struct mysql_request *request, MYSQL_RES *res) +{ + struct userdb_mysql_request *urequest = + (struct userdb_mysql_request *) request; + struct user_data user; + MYSQL_ROW row; + + if (res != NULL && is_result_valid(res) && + (row = mysql_fetch_row(res))) { + memset(&user, 0, sizeof(user)); + user.virtual_user = urequest->username; + user.system_user = my_get_str(res, row, "system_user"); + user.home = my_get_str(res, row, "home"); + user.mail = my_get_str(res, row, "mail"); + user.uid = atoi(my_get_str(res, row, "uid")); /* XXX leak */ + user.gid = atoi(my_get_str(res, row, "gid")); /* XXX leak */ + urequest->userdb_callback(&user, request->context); + } else { + urequest->userdb_callback(NULL, request->context); + } +} + +static void userdb_mysql_lookup(const char *user, userdb_callback_t *callback, + void *context) +{ + struct mysql_connection *conn = userdb_mysql_conn->conn; + struct userdb_mysql_request *request; + const char *query; + string_t *str; + + str = t_str_new(512); + var_expand(str, conn->set.user_query, str_escape(user), NULL); + query = str_c(str); + + request = i_malloc(sizeof(struct userdb_mysql_request) + strlen(user)); + request->request.callback = mysql_handle_request; + request->request.context = context; + request->userdb_callback = callback; + strcpy(request->username, user); + + db_mysql_query(conn, query, &request->request); +} + +static void userdb_mysql_init(const char *args) +{ + struct mysql_connection *conn; + + userdb_mysql_conn = i_new(struct userdb_mysql_connection, 1); + userdb_mysql_conn->conn = conn = db_mysql_init(args); +} + +static void userdb_mysql_deinit(void) +{ + db_mysql_unref(userdb_mysql_conn->conn); + i_free(userdb_mysql_conn); +} + +struct userdb_module userdb_mysql = { + userdb_mysql_init, + userdb_mysql_deinit, + + userdb_mysql_lookup +}; + +#endif diff -u -r --new-file work/dovecot-0.99.10/src/auth/userdb.c work.patched/dovecot-0.99.10/src/auth/userdb.c --- work/dovecot-0.99.10/src/auth/userdb.c Sun May 18 07:26:28 2003 +++ work.patched/dovecot-0.99.10/src/auth/userdb.c Fri Aug 22 13:07:21 2003 @@ -49,6 +49,10 @@ if (strcasecmp(name, "pgsql") == 0) userdb = &userdb_pgsql; #endif +#ifdef USERDB_MYSQL + if (strcasecmp(name, "mysql") == 0) + userdb = &userdb_mysql; +#endif #ifdef HAVE_MODULES userdb_module = userdb != NULL ? NULL : auth_module_open(name); if (userdb_module != NULL) { diff -u -r --new-file work/dovecot-0.99.10/src/auth/userdb.h work.patched/dovecot-0.99.10/src/auth/userdb.h --- work/dovecot-0.99.10/src/auth/userdb.h Sun May 18 07:26:28 2003 +++ work.patched/dovecot-0.99.10/src/auth/userdb.h Fri Aug 22 13:07:53 2003 @@ -29,6 +29,7 @@ extern struct userdb_module userdb_vpopmail; extern struct userdb_module userdb_ldap; extern struct userdb_module userdb_pgsql; +extern struct userdb_module userdb_mysql; void userdb_init(void); void userdb_deinit(void);

2 1

[Dovecot] converting from courier-imap
by Emily 30 Aug '03

30 Aug '03

Hello. I apologize if there is a simple answer to this question, but I haven't been able to figure it out. Our people use various clients (pine 4.50 with maildir patch, eudora, messenger, outlook, squirrelmail), and all of them work with courier-imap. But I've become very interested in dovecot after reading about it, so I'm trying it out on another server. The results are mixed. Strangely enough, squirrelmail 1.4.1 works wonderfully. For some reason, it duplicates Sent, Drafts, and Trash, but I deleted the duplicates and it was fine. Mozilla messenger is also fine, but with the same duplication of those special folders. Everything seems nice and fast. But some of our users still cling to pine, which works with courier-imap using these three lines in .pinerc: inbox-path={our.server.edu/ssl/novalidate-cert/user=emily}INBOX default-fcc={our.server.edu/ssl/novalidate-cert/user=emily}INBOX.Sent folder-collections="IMAP Folders" {our.server.edu/user=emily/ssl/novalidate-cert}INBOX.[] On the test server I'm using dovecot-0.99.10 compiled against openssl-0.9.7b in Redhat 9. This pine configuration worked in courier, but when I try pine with dovecot, I can't see any folders under "Folder Collection" other than those special three (Drafts, Sent, Trash). I'm sure there's just something I'm doing wrong, but I couldn't find anything in the dovecot list archives. I would appreciate any advice on what I'm doing wrong in getting pine to see the whole collection. Thanks, -- Emily

2 1

[Dovecot] No localhost after reboot
by Bob Hall 30 Aug '03

30 Aug '03

Rebooted the server box today. Now Dovecot doesn't listen at localhost. It does listen at the LAN interface, so it is perfectly usable, but... Does anyone have any idea why it has stopped listening at localhost? Bob Hall

4 15

[Dovecot] Postgresql and Dovecot
by Michael Ducy 29 Aug '03

29 Aug '03

I am having some issues getting dovecot to work with postgres. Dovecot starts up and runs fine without using postgres (ie passwd and pam). There is nothing in /var/log/messages other than: Aug 28 12:44:05 mail dovecot: dovecot startup succeeded Then ps -A shows no running dovecot processes (or the imap-login or pop-login). I have tried with both the RPMs that are on the download page and buidling it myself on 2 different boxes (yes I configured with --with-pgsql - Red Hat 7.3 and Red Hat 9.0). Any suggestions would be appreciated as this is the only imap/pop server with pgsql support and flatfile support I can find. Michael

3 7

[Dovecot] better body and text search?
by Mark Anderson 29 Aug '03

29 Aug '03

(this is a resend, sorry if duplicate but my first post didn't get through). I was wondering what plans dovecot has for text and body search? This is one of those issues that *no* imap implementation ever seems to document :(. Not cyrus, courier, bincimap, or dovecot.... i speed-read some of the sources and found src/lib-mail/message-body-search.c After a quick scan, it seems: - it uses no text index at all, but does a linear search over the folder. - it searches only messages with content-type starting with "text/" or "message/" - it does no special parsing of "text/html", so tags and attributes would match - it appears to exclude any mime messages, since it skips "multipart/mixed" for example. - it does deal with content encoding and charset. There is a lucene-based text indexing utility for IMAP stores here: http://www.tropo.com/techno/java/lucene/imap.html But ideally there would be pluggable text indexing builtin.... -mda

2 3

[Dovecot] Custom flags.
by Maheshkumar Sabhnani 29 Aug '03

29 Aug '03

How do I define custom flags? What are added features of IMAP apart from Online access and Hierarchy folders. I created a new folder and copied couple of messages from incoming file. Where is this new folder created? Also Microsoft Outlook still shows the messages in incoming as deleted. How do I refresh list to permanently delete the messages that I have already transferred to a different folder. Mahesh

2 1

[Dovecot] Conf problems ??
by maheshkumar sabhnani 29 Aug '03

29 Aug '03

Hello, I am having problems with configuring dovecit. The imap directory was correctly made in ~/mail/.imap But I can't see any mail headers. My mbox path is ~/mail/incoming Currently I am trying to use "mbox:~/mail/:INBOX=~/mail/incoming" for configuration but it complains about missing value. Can someone send me more information on configuration directives especially mbox and INBOX. Early reply shall be appreciated. Regards, Mahesh

2 1

[Dovecot] Squirrelmail & Dovecot
by Alex 29 Aug '03

29 Aug '03

What are the optimum IMAP settings for Squirelmail on dovecot? I am having good luck with the Cyrus settings, but I would prefer to know the real truth... Thanks -Alex

3 2

[Dovecot] better body and text search?
by Mark Anderson 28 Aug '03

28 Aug '03

I was wondering what plans dovecot has for text and body search? This is one of those issues that *no* imap implementation ever seems to document :(. Not cyrus, courier, bincimap, or dovecot.... i speed-read some of the sources and found src/lib-mail/message-body-search.c After a quick scan, it seems: - it uses no text index at all, but does a linear search over the folder. - it searches only messages with content-type starting with "text/" or "message/" - it does no special parsing of "text/html", so tags and attributes would match - it appears to exclude any mime messages, since it skips "multipart/mixed" for example. - it does deal with content encoding and charset. There is a lucene-based text indexing utility for IMAP stores here: http://www.tropo.com/techno/java/lucene/imap.html But ideally there would be pluggable text indexing builtin.... -mda

1 0

[Dovecot] mail accounts for users without home dirs
by Gunter Ohrner 28 Aug '03

28 Aug '03

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi! I use dovecot on a machine where users without an existing home directory (Not my idea...) need to access their mailboxes. Unfortunately dovecot tries to chdir to the users home directory before allowing IMAP access - is there anything I can do about that besides creating a dummy-homedirectory for these users? Greetings, Gunter - -- +-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+ + PGP-verschlüsselte Mails bevorzugt! + +-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+ Chain-mail isn't much defence against an arrow. It certainly isn't when the arrow is being aimed between your eyes. -- (Terry Pratchett, Lords and Ladies) +-+-+-+-+-+-+-+-+-+-+-+-+ http://www.lspace.org +-+-+-+-+-+-+-+-+-+-+-+-+ -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.2 (GNU/Linux) iD8DBQE/SpA/0ORHvREo8l8RAvFcAJ0ZsnnRTmBUzQEuon6QLDSOWMB2lgCfVFJw C/6nmMXb8cyvOWog0cfmi6E= =iO/e -----END PGP SIGNATURE-----

4 9

[Dovecot] 0.99.11-test6
by Timo Sirainen 28 Aug '03

28 Aug '03

http://dovecot.procontrol.fi/test/ I think I've fixed the problems that were corrupting indexes with the new code. It happened every time you had expunged some messages and new messages arrived. I think this release might actually work :) disable_plaintext_auth = yes will be default from now on. It allows plaintext authentication from localhost (127.*, ::1) however. I just figured out that the lockless cache file reading prevents me from fixing the mbox code to work the same way it used to. I'm not sure actually how this would be best fixed.. Problem is that headers in mails change and move the messages around in the mailbox, so I have to keep track of them. Previously I just updated the header size in index files.. but without read locks this can't be done safely. One possibility would be to parse the whole mbox file every time when the mailbox is opened (or when it needs to be read) and save the header sizes in memory. That'd make it slower than it is today though.. Or maybe it'd work if I just grabbed exclusive lock whenever reading header sizes. They could be then copied into memory to avoid locking more than once. But that still creates locking contention if lots of clients are reading the mailbox. Exactly in the situation where I'd mostly use mboxes.. I could also save it in .imap.index file which still currently uses read-locks. But I'd rather want to get rid of them in there too.

6 14

[Dovecot] IMAP error after login
by Nicolas STRANSKY 28 Aug '03

28 Aug '03

Hello, I'm having a slight problem with Dovecot (0.99.10-0.rc2, on Debian woody). When using mozilla 1.4, there is an error message from the mailer just after login, but nothing in dovecot logs. "Alert The current command did not succeed. The mail server responded: Error in IMAP command UID: Too long argument.." How could I fix this problem ? Thanks, -- Nico J'ai une panne de micro et les parasites me brouillent l'écoute

3 3

[Dovecot] Chrooting the Mail processes
by Bert Koelewijn 25 Aug '03

25 Aug '03

Hello! Could somebody give some feedback on this configuration: - OpenBSD box with local ssh users. - /home directory mounted with nosuid,noexec. - postfix dropping mail in /home/username/mail/INBOX, with the UID/GID of the user. - dovecot: valid_chroot_dirs = /home default_mail_env = mbox:/home/%u/mail/:INBOX=/home/%u/mail/INBOX Are there any obvious ways for a local user to help dovecot escape the chroot jail? How can I check that dovecot is REALLY using /home as chroot jail for the imap process? Thanks! Bert Koelewijn

2 5

[Dovecot] Docs on the wiki
by Bob Hall 25 Aug '03

25 Aug '03

I went to the Dove Wiki page and added a couple of docs. There's a DoveWikiMainPage link at the top of the first page now. Click on that and the next page has links to the two docs. Someone who knows more than I do about wiki formatting should make this look good. The two docs are for Dovecot/OpenLDAP installation. The first is detailed instructions and the second is a cheat sheet. You don't need to contact me if you find errors; just click "Edit this page" at the bottom. Anyone who wants to use parts of my docs to use in documenting other types of installation should feel free. There's no mention of copyright policy, but I assume everthing is GPL copyleft. Bob Hall

1 0

[Dovecot] Postfix and Maildirs
by Steve Sloan 24 Aug '03

24 Aug '03

Hope someone can help me with this as I am presently stuck I am setting up a new server with Dovecot 0.99.10, Redhat 9.0, Postfix, Amavisd-new and maildir's in the users home drive. I am using Netscape mail 7.1 as the main client to access the mail store via imap which works fine and various other imap clients can access the maildirs Ok as well. The problem is when Postfix delivers a message is insists on making a second Maildir directory in the user's home drive and put the message in there. The Maildir's are being created automatically ie. I didn't use maildirmake. Even if I delete one of the Maildir's it just gets recreated again. ie. this is the test user's home drive drwx------ 10 test2 test2 4096 Aug 23 20:53 Maildir drwx------ 6 test2 test2 4096 Aug 24 11:05 Maildir This is the Maildir that the clients are using and being accessed by Dovecot drwx------ 10 test2 test2 4096 Aug 23 20:53 . drwx------ 4 test2 test2 4096 Aug 24 11:05 .. drwx------ 2 test2 test2 4096 Aug 23 19:58 cur -rw------- 1 test2 test2 5 Aug 23 19:58 .customflags drwx------ 5 test2 test2 4096 Aug 23 19:59 .Drafts drwx------ 2 test2 test2 4096 Aug 23 19:58 .INBOX drwx------ 2 test2 test2 4096 Aug 23 19:58 new drwx------ 5 test2 test2 4096 Aug 23 20:15 .Sent -rw------- 1 test2 test2 29 Aug 23 20:13 .subscriptions drwx------ 5 test2 test2 4096 Aug 23 20:11 .test drwx------ 2 test2 test2 4096 Aug 23 19:58 tmp drwx------ 5 test2 test2 4096 Aug 23 20:11 .Trash and the other one which Postfix user's drwx------ 6 test2 test2 4096 Aug 24 11:05 . drwx------ 4 test2 test2 4096 Aug 24 11:05 .. drwx------ 2 test2 test2 4096 Aug 24 11:05 cur -rw------- 1 test2 test2 5 Aug 24 11:05 .customflags drwx------ 2 test2 test2 4096 Aug 24 11:05 .INBOX drwx------ 2 test2 test2 4096 Aug 24 11:05 new drwx------ 2 test2 test2 4096 Aug 24 11:05 tmp This one has no index files and looks just like a courier Maildir For Postfix main.cf I have set home_mailbox = Maildir/ and /etc/dovecot.conf default_mail_env = maildir:/home/%u/Maildir Hope this make sense to someone Steve -- _____________________________________________ LanSol Computers 283 Sir Donald Bradman Drv. Brooklyn Park SA 5032 Ph 618 8238 3406 Fax 618 83538479 Mobile 0414 398166 Email steve(a)lansol.com.au URL www.lansol.com.au _____________________________________________

3 3

[Dovecot] Three oddities
by Bob Hall 24 Aug '03

24 Aug '03

FBSD 4.8, Dovecot-0.99.10 1) I have mail accounts for people who use Macs and Windows, so their mail is stored on a Unix box where they don't have accounts. When their mail comes in, it is stored in /var/mail/<accountname>. When I was setting this up, I used my own Unix account for testing, and that works fine. But for the other mail accounts, which don't correspond to Unix accounts, I want to give ownership of the /var/mail/* files to another account that doesn't have my privileges. However, no one can access their mail unless I own their files. As long as I own all the /var/mail/* files, everything works fine. But if I shift ownership to another account, users can log on to Dovecot but attempts to access an IMAP folder return an error. >From maillog: Aug 18 16:39:46 kongemord imap(philrodrigues): mkdir_parents(/var/mail/philrodri gues/.imap/INBOX) failed: Permission denied All files and directories in /var/mail/* are in the mail group. I tried adding dovecot to that group, but that didn't help. Since everyone can log on to Dovecot, but can't access their mail unless I own their files, I'm assuming that there's some simple ownership setting that I'm overlooking. But I haven't a clue what it is. Can someone tell me what I need to change? 2) The Macs have Eudora 4.2 installed, and the Win boxes have Eudora 5.1. The Macs can delete mail, put it in the trash, and empty the trash. The Win clients can mark mail deleted, but they can't remove it. The mail stays in the IMAP folder until the same user accesses their mail from a Mac and deletes it. If a user drags a message to another folder, a copy is created in the new folder but the old copy remains in the original folder. I'm not having this problem with Mutt, so it the problem seems to be specific to the Windows verson of Eudora. Is there a fix? 3) We're pulling our e-mail off our ISP's POP server and loading it into Dovecot to allow people to work with their mail from different machines. I'm using getmail to make the transfer. Is anyone else doing POP to IMAP, and how are they doing it? Any suggestions? TIA, Bob Hall

3 24