- dovecot - dovecot.org

[Dovecot] A few dovecot 1.1 bugs - sort, flag reset and etc.
by wenjie zheng 07 Aug '07

07 Aug '07

I installed dovecot 1.1 on our system yesterday, and found a few bugs so far. Here is the list: BUG #1: can't access some folders Details: a select "RSS.A List Apart" * FLAGS (\Answered \Flagged \Deleted \Seen \Draft $$$INDEXED###) * OK [PERMANENTFLAGS (\Answered \Flagged \Deleted \Seen \Draft $$$INDEXED### \*)] Flags permitted. * 52 EXISTS * 0 RECENT * OK [UNSEEN 50] First unseen. * OK [UIDVALIDITY 1166644056] UIDs valid * OK [UIDNEXT 65] Predicted next UID a OK [READ-WRITE] Select completed. a SORT (DATE) UTF-8 UNSEEN imap(jing(a)webmail.us <javascript:void(0);>): Panic: file mail-cache-lookup.c: line 70: unreached imap(jing(a)webmail.us <javascript:void(0);>): Error: Raw backtrace: /usr/libexec/dovecot/imap [0x80be647] -> /usr/libexec/dovecot/imap [0x80be82f] -> /usr/libexec/dovecot/imap [0x809849b] -> /usr/libexec/dovecot/imap(mail_cache_lookup_iter_init+0x6c) [0x809857c] -> /usr/libexec/dovecot/imap(mail_cache_lookup_headers+0xf7) [0x8098c77] -> /usr/libexec/dovecot/imap [0x8091ac7] -> /usr/libexec/dovecot/imap(index_mail_get_first_header+0x17) [0x8091dff] -> /usr/libexec/dovecot/imap(mail_get_first_header+0x12) [0x80b054a] -> /usr/libexec/dovecot/imap [0x8093b5a] -> /usr/libexec/dovecot/imap [0x8093cee] -> /usr/libexec/dovecot/imap [0x8093eff] -> /usr/libexec/dovecot/imap(bsearch_insert_pos+0x40) [0x80bd794] -> /usr/libexec/dovecot/imap [0x8094660] -> /usr/libexec/dovecot/imap [0x8094759] -> /usr/libexec/dovecot/imap(index_sort_list_finish+0x2f) [0x8094a27] -> /usr/libexec/dovecot/imap(index_storage_search_next_nonblock+0x119) [0x8093819] -> /usr/libexec/dovecot/imap(mailbox_search_next_nonblock+0x17) [0x80b21f3] -> /usr/libexec/dovecot/imap(mailbox_search_next+0x1d) [0x80b21c5] -> /usr/libexec/dovecot/imap(imap_sort+0xb5) [0x8064529] -> /usr/libexec/dovecot/imap(cmd_sort+0x10e) [0x805e356] -> /usr/libexec/dovecot/imap [0x805fe82] -> /usr/libexec/dovecot/imap [0x805fda1] -> /usr/libexec/dovecot/imap [0x805ff11] -> /usr/libexec/dovecot/imap(_client_input+0x56) [0x805ffce] -> /usr/libexec/dovecot/imap(io_loop_handler_run+0x100) [0x80c3e38] -> /usr/libexec/dovecot/imap(io_loop_run+0x2d) [0x8069339] -> /usr/libexec/dovecot/imap(main+0x64) [0x8068d30] -> /lib/tls/libc.so.6(__libc_start_main+0xda) [0x73978a] Program received signal SIGABRT, Aborted. 0x0074bcdf in raise () from /lib/tls/libc.so.6 (gdb) bt full #0 0x0074bcdf in raise () from /lib/tls/libc.so.6 No symbol table info available. #1 0x0074d4e5 in abort () from /lib/tls/libc.so.6 No symbol table info available. #2 0x080be666 in default_panic_handler (format=0x80cdbdd "file %s: line %d: unreached", args=0xbfff9cb4 "MP\r\bF") at failures.c:136 backtrace = 0x8d2ac38 "/usr/libexec/dovecot/imap [0x80be647] -> /usr/libexec/dovecot/imap [0x80be82f] -> /usr/libexec/dovecot/imap [0x809849b] -> /usr/libexec/dovecot/imap(mail_cache_lookup_iter_init+0x6c) [0x809857c] -> /u"... #3 0x080be82f in i_panic (format=0x80cdbdd "file %s: line %d: unreached") at failures.c:213 No locals. #4 0x0809849b in mail_cache_lookup_offset (cache=0x8d4a9b8, view=0x8d4d460, seq=18, offset_r=0x0) at mail-cache-lookup.c:70 map = (struct mail_index_map *) 0x8d4a898 data = (const void *) 0x8d4f4a4 idx = 148024040 i = -1073767072 ret = 0 #5 0x0809857c in mail_cache_lookup_iter_init (view=0x8d4d558, seq=18, ctx_r=0xbfff9d60) at mail-cache-lookup.c:125 ctx = (struct mail_cache_lookup_iterate_ctx *) 0xbfff9d60 ret = 0 #6 0x08098c77 in mail_cache_lookup_headers (view=0x8d4d558, dest=0x8d52038, seq=18, field_idxs=0xbfff9de4, fields_count=1) at mail-cache-lookup.c:470 cache = (struct mail_cache *) 0x8d4a9b8 iter = {view = 0x8d4d558, remap_counter = 0, seq = 18, rec = 0x0, pos = 0, rec_size = 0, offset = 0, stop = 0, failed = 0, appends_checked = 0} field = {field_idx = 12, data = 0x8d4dbc0, size = 0} ctx = {view = 0x8d4d558, lines = {arr = {buffer = 0x8d2aae8, element_size = 8}, v = 0x8d2aae8, v_modifiable = 0x8d2aae8}} lines = (struct header_lookup_line *) 0x1 p = (const unsigned char *) 0x0 start = (const unsigned char *) 0xbfff9d60 "XÕÔ\b" end = (const unsigned char *) 0x42a5 <Address 0x42a5 out of bounds> field_state = (uint8_t *) 0x8d2aab8 "" i = 1 max_field = 10 hdr_size = 3221200208 want = 1 '\001' buf = (buffer_t *) 0xbfff9d50 ret = 0 #7 0x08091ac7 in index_mail_get_raw_headers (mail=0x8d3d3b8, field=0x80ce56b "Subject") at index-mail-headers.c:568 headers = {0xbfff9e18 "8\236ÿ¿J\005\v\b¸ÓÓ\bkå\f\b", 0x809059c "\213\216(\001"} value = 0x0 headers_ctx = (struct mailbox_header_lookup_ctx *) 0x8d3d3b8 data = (unsigned char *) 0x8d4b1a8 "h³Ô\b *Ó\b\224X\t\b¬X\t\bÐ\200\006\b\204Å\006\b°2\a\b¤3\a\büÇ\006\bÌÈ\006\bTÉ\006\b" field_idx = 10 dest = (string_t *) 0x8d52038 i = 148100024 len = 148100132 ret = 148156840 header_values = {arr = {buffer = 0xac, element_size = 3221200392}, v = 0xac, v_modifiable = 0xac} #8 0x08091dff in index_mail_get_first_header (_mail=0x8d3d3b8, field=0x80ce56b "Subject", decode_to_utf8=false) at index-mail-headers.c:673 list = (const char * const *) 0x6 #9 0x080b054a in mail_get_first_header (mail=0x0, field=0x80ce56b "Subject") at mail.c:96 No locals. #10 0x08093b5a in sort_header_get (sort_type=MAIL_SORT_SUBJECT, mail=0x8d3d3b8, seq=18) at index-sort.c:180 str = 0x8d3d3b8 "¨±Ô\b8ÇÔ\b\022" buf = (string_t *) 0x20 #11 0x08093cee in sort_node_cmp_type (ctx=0x80e62e0, sort_program=0x8d3d334, n1=0xbfff9f20, n2=0x8d3d850) at index-sort.c:223 sort_type = MAIL_SORT_SUBJECT str1 = 0x8d2aa50 "NEVER USE A WARNING WHEN YOU MEAN UNDO" str2 = 0x0 time1 = 32 time2 = 6 size1 = 148023856 size2 = 73276437037062 ret = 148023888 #12 0x08093eff in sort_node_cmp_no_sort_id (p1=0xbfff9f20, p2=0x8d3d850) at index-sort.c:309 No locals. ---Type <return> to continue, or q <return> to quit--- #13 0x080bd794 in bsearch_insert_pos (key=0xbfff9f20, base=0x8d3d798, nmemb=46, size=8, cmp=0x8093ee0 <sort_node_cmp_no_sort_id>, idx_r=0xbfff9f1c) at bsearch-insert-pos.c:20 p = (const void *) 0x0 idx = 23 left_idx = 0 right_idx = 46 ret = 0 #14 0x08094660 in index_sort_headers (program=0x8d3d330, last_seq=52) at index-sort.c:590 node = {seq = 47, sort_id = 0} count = 46 idx = 15 #15 0x08094759 in index_sort_build (program=0x8d3d330, last_seq=52) at index-sort.c:637 ibox = (struct index_mailbox *) 0x8d4b1a8 node = {seq = 1, sort_id = 0} data = (const void *) 0x0 i = 6 #16 0x08094a27 in index_sort_list_finish (program=0x8d3d330) at index-sort.c:743 No locals. #17 0x08093819 in index_storage_search_next_nonblock (_ctx=0x8d3d2c8, mail=0x8d50440, tryagain_r=0xbfffa01b) at index-search.c:1058 box = (struct mailbox *) 0x8d4b1a8 count = 12 ret = 0 #18 0x080b21f3 in mailbox_search_next_nonblock (ctx=0x6, mail=0x8d50440, tryagain_r=0xbfffa01b) at mail-storage.c:598 No locals. #19 0x080b21c5 in mailbox_search_next (ctx=0x8d3d2c8, mail=0x8d50440) at mail-storage.c:589 tryagain = false ret = 0 #20 0x08064529 in imap_sort (cmd=0x8d35f40, charset=0x8d3a2e0 "UTF-8", args=0x8d4b7b0, sort_program=0x8d292c0) at imap-sort.c:90 client = (struct client *) 0x8d345d0 wanted_headers = {0x80ce56b "Subject", 0x0} wanted_fields = 0 search_ctx = (struct mail_search_context *) 0x8d3d2c8 t = (struct mailbox_transaction_context *) 0x8d4c738 headers_ctx = (struct mailbox_header_lookup_ctx *) 0x8d3c9b0 mail = (struct mail *) 0x8d50440 str = (string_t *) 0x8d292c0 written = false ret = 148070208 #21 0x0805e356 in cmd_sort (cmd=0x8d35f40) at cmd-sort.c:134 client = (struct client *) 0x8d345d0 sargs = (struct mail_search_arg *) 0x0 sorting = {MAIL_SORT_SUBJECT, MAIL_SORT_END, 3221201096, 7656935, 148070264, 135062878, 20, 18} args = (const struct imap_arg *) 0x8d3a1e8 args_count = 0 pool = 0x8d4b798 error = 0x0 charset = 0x8d3a2e0 "UTF-8" #22 0x0805fe82 in client_command_input (cmd=0x8d35f40) at client.c:488 client = (struct client *) 0x8d345d0 #23 0x0805fda1 in client_command_input (cmd=0x8d35f40) at client.c:545 client = (struct client *) 0x8d345d0 #24 0x0805ff11 in client_handle_next_command (client=0x8d345d0) at client.c:556 size = 27 #25 0x0805ffce in _client_input (client=0x8d345d0) at client.c:616 cmd = (struct client_command_context *) 0x2 ret = 2 #26 0x080c3e38 in io_loop_handler_run (ioloop=0x8d31a68) at ioloop-poll.c:200 ctx = (struct ioloop_handler_context *) 0x8d31aa8 pollfd = (struct pollfd *) 0x2 tv = {tv_sec = 4, tv_usec = 199377} io = (struct io_file *) 0x8d340c8 t_id = 2 msecs = 0 ret = 0 ---Type <return> to continue, or q <return> to quit--- call = 165 #27 0x08069339 in io_loop_run (ioloop=0x8d31a68) at ../../src/lib/ioloop.c:351 No locals. #28 0x08068d30 in main (argc=1, argv=0xbfffa264, envp=0xbfffa26c) at main.c:301 No locals. BUG #2: Some flags are reset after they were set a while ago, like messages that has been read are randomly becoming unread again. Bug #3: CRLF in the email file on disk is shown like "=0A", which causes display problem in wireless access. =0A =0A =0A =0A =0AHey all, =0A=C2=A0 Thanks, Wenjie

3 3

[Dovecot] Subfolders
by Azher Amin 07 Aug '07

07 Aug '07

Hi, Does dovecot supports sub folders ?? I tried creating a subfolder for a folder under the main tree .... Thunderbird allows you creating but doesn't show up ... Plz suggest how it can be enabled. Regards -Azher -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean.

5 5

[Dovecot] [PATCH] Split sql drivers from lib-sql to plugins
by Tomas Janousek 07 Aug '07

07 Aug '07

Hi, in order to solve rhbz#170960 [1], I split the sql drivers to plugins so that they are loaded dynamically and can be split to separate packages. [1] https://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=170960 The patches are here: [2] http://people.redhat.com/tjanouse/dovecot/145241/dovecot-1.0-split.patch [3] http://people.redhat.com/tjanouse/dovecot/145241/dovecot-trunk-split.patch (mv src/lib-sql/driver-mysql.c src/plugins/sql-mysql/, etc., afterwards) I'd like to ask for your comments and whether it's ok for inclusion or at least ok to use in the Fedora package. Regards, -- Tomas Janousek, SW Engineer, Red Hat, Inc.

2 6

[Dovecot] cache questions
by Daniel Watts 06 Aug '07

06 Aug '07

Hi Guys, We have: auth_cache_size = 2048 #Kb auth_cache_ttl = 900 #life of the cache Seems to work well (though haven't tried looking at stats). Only problem is that every so often, one of our new users tries to log in quickly before the account is marked (in a db) as 'active'. They use the right password but the sql query fails because the active flag is not yet set. This results in their trying to log in and failing for 15 minutes (900 seconds) until the cache clears. Is this dovecot caching negative results? Is this a good idea and can it be disabled? Some more questions: 1. Is the expire time on a per-login basis or for the entire cache? If someone logs in 14 minutes after the last expiry is their data cached for just 1 minute? 2. If it is per-login, is the time reset after every hit? If someone is using webmail and hitting the cache every 5 minutes, will the cache keep the information? 3. How does the cache size relate to number of distinct logins? Roughly how many auth datasets cached per 1MB of cache? Thanks! Daniel tg3 dovecot # dovecot --version 1.0.rc27 p.s. please CC my email so I know when this has been replied to. I will respond to group!

2 4

[Dovecot] dovecot-1.1-alpha1 prefetch appears broken
by David Favor 06 Aug '07

06 Aug '07

Config shows... # 1.1.alpha1: /usr/local/conf/dovecot.conf protocols: imaps ssl_listen: 69.94.137.124:10943 login_dir: /common/pkgs/dovecot-1.1-alpha1/var/run/dovecot/login login_executable: /common/pkgs/dovecot-1.1-alpha1/libexec/dovecot/imap-login mail_debug: yes auth default: verbose: yes debug: yes debug_passwords: yes passdb: driver: sql args: /usr/local/conf/dovecot-sql.conf userdb: driver: prefetch userdb: driver: sql args: /usr/local/conf/dovecot-sql.conf Log shows... auth(default): client in: AUTH 1 PLAIN service=imap secured lip=69.94.137.124 rip=71.155.185.14 auth(default): client out: CONT 1 auth(default): client in: CONT 1 AGRvZGExAGZpcmUyM2JyaWNr auth-worker(default): sql(doda1,71.155.185.14): query: SELECT password, home AS userdb_home,\ uid AS userdb_uid, gid AS userdb_gid FROM users WHERE user = 'doda1' auth(default): client out: OK 1 user=doda1 auth(default): master in: REQUEST 1 12491 1 auth(default): prefetch(doda1,71.155.185.14): passdb didn't return userdb entries auth-worker(default): sql(doda1,71.155.185.14): SELECT home, uid, gid FROM users WHERE \ user = 'doda1' auth(default): master out: USER 1 doda1 \ home=/common/vhost/coolsurf.com/users/david uid=503 gid=501 imap-login: Login: user=<doda1>, method=PLAIN, rip=71.155.185.14, lip=69.94.137.124, TLS IMAP(doda1): Effective uid=503, gid=501, home=/common/vhost/coolsurf.com/users/david IMAP(doda1): maildir: root exists (/common/vhost/coolsurf.com/users/david/Maildir) IMAP(doda1): maildir++: root=/common/vhost/coolsurf.com/users/david/Maildir, index=,\ control=, inbox=/common/vhost/coolsurf.com/users/david/Maildir The passdb query returns expected data directly from sqlite and apparently (from the logs) to dovecot also. Problem is dovecot seems to be missing all the data returned as userdb_* field names. Suggestions? -- Like feeling your best ever, all day, every day? Email join(a)RadicalHealth.com for the easy way.

2 1

[Dovecot] Resend: How do I configure sendmail to accept emails for dovecot when dovecot has sql auth/user db.
by Joseph Silverman 06 Aug '07

06 Aug '07

Apologies for resending this, I am not sure it made it through the first time.. --- Included below are my config files: sendmail.mc, dovecot.m4, dovecot.conf, dovecot-sql.conf. Whenever I try to send email into this system, it rejects it with user does not exist, however, the user does exist as far as dovecot (imap) is concerned, it is in the database. THANKS - Yossie # for i in /etc/dovecot/dovecot.conf /etc/dovecot/dovecot-sql.conf / usr/share/sendmail-cf/mailer/dovecot.m4 /etc/mail/sendmail.mc; do echo "FILE: $i"; echo ===; echo ""; egrep -v '^ *(#|$)' $i; echo ""; echo ""; done FILE: /etc/dovecot/dovecot.conf === listen = [::] disable_plaintext_auth = no ssl_disable = yes ssl_cert_file = /etc/ssl/dovecot/server.pem ssl_key_file = /etc/ssl/dovecot/server.key mail_location = maildir:~/.maildir namespace private { separator = . inbox = yes hidden = no } namespace private { separator = . prefix = INBOX. inbox = no hidden = yes } first_valid_uid = 0 protocol imap { } protocol pop3 { } protocol lda { postmaster_address = postmaster(a)example.com main_plugin_dir = /usr/lib/dovecot/lda mail_plugins = cmusieve quota } auth default { mechanisms = plain passdb sql { args = /etc/dovecot/dovecot-sql.conf } userdb sql { args = /etc/dovecot/dovecot-sql.conf } user = root socket listen { master { path = /var/run/dovecot/auth-master mode = 0666 } client { path = /var/run/dovecot/auth-client mode = 0666 } } } dict { } plugin { } FILE: /etc/dovecot/dovecot-sql.conf === driver = mysql connect = host=localhost dbname=dovecot user=root default_pass_scheme = PLAIN password_query = SELECT userPassword as password, user, concat("/var/ spool/dovecot/",substr(user,1,1),"/user/",user) as userdb_home, 97 as userdb_uid, 97 as userdb_gid FROM authdb WHERE user = '%n' and userPassword = '%w' user_query = SELECT concat("/var/spool/imap/",substr(user,1,1),"/ user/",user) as home, 97 as uid, 97 as gid FROM authdb WHERE user = '%n' FILE: /usr/share/sendmail-cf/mailer/dovecot.m4 === Mdovecot, P=/usr/libexec/dovecot/deliver, F=DFMPhnu9, S=EnvFromSMTP/HdrFromSMTP, R=EnvToSMTP/HdrFromSMTP, T=DNS/RFC822/X-Unix, A=deliver -d $u FILE: /etc/mail/sendmail.mc === divert(-1) dnl This is the macro config file used to generate the /etc/sendmail.cf dnl file. If you modify the file you will have to regenerate the dnl /etc/sendmail.cf by running this macro config through the m4 dnl preprocessor: dnl dnl m4 /etc/mail/sendmail.mc > /etc/mail/sendmail.cf dnl dnl You will need to have the sendmail-cf package installed for this to dnl work. include(`/usr/share/sendmail-cf/m4/cf.m4')dnl define(`confDEF_USER_ID',``mail:mail'')dnl OSTYPE(`linux')dnl undefine(`UUCP_RELAY')dnl undefine(`BITNET_RELAY')dnl define(`confALIAS_WAIT', `30')dnl define(`confTO_CONNECT', `1m')dnl define(`confTRY_NULL_MX_LIST',true)dnl define(`confDONT_PROBE_INTERFACES',true)dnl define(`PROCMAIL_MAILER_PATH',`/usr/bin/procmail')dnl dnl define delivery mode: interactive, background, or queued dnl define(`confDELIVERY_MODE', `i') MASQUERADE_AS(`ford.qa.laszlosystems.com')dnl FEATURE(`limited_masquerade')dnl FEATURE(`masquerade_envelope')dnl FEATURE(`smrsh',`/usr/sbin/smrsh')dnl FEATURE(mailertable)dnl dnl virtusertable: redirect incoming mail to virtual domain to particular user or domain FEATURE(`virtusertable',`hash -o /etc/mail/virtusertable')dnl dnl genericstable: rewrite sender address for outgoing mail FEATURE(genericstable)dnl FEATURE(always_add_domain)dnl FEATURE(redirect)dnl FEATURE(use_cw_file)dnl FEATURE(local_procmail)dnl FEATURE(`access_db')dnl FEATURE(`blacklist_recipients')dnl FEATURE(`relay_based_on_MX')dnl dnl FEATURE(dnsbl, `blackholes.mail-abuse.org', `Rejected - see http://www.mail-abuse.org/rbl/')dnl dnl FEATURE(dnsbl, `dialups.mail-abuse.org', `Dialup - see http:// www.mail-abuse.org/dul/')dnl dnl FEATURE(dnsbl, `relays.mail-abuse.org', `Open spam relay - see http://www.mail-abuse.org/rss/')dnl FEATURE(`delay_checks')dnl FEATURE(`stickyhost')dnl dnl SASL Configuration dnl extract from http://www.sendmail.org/~ca/email/auth.html dnl dnl Next two lines are for SMTP Authentication TRUST_AUTH_MECH(`LOGIN PLAIN')dnl define(`confAUTH_MECHANISMS', `LOGIN PLAIN')dnl dnl dnl Next line stops sendmail from allowing auth without encryption define(`confAUTH_OPTIONS', `Apy')dnl dnl dnl STARTTLS configuration dnl extract from http://www.sendmail.org/~ca/email/starttls.html dnl define(`CERT_DIR', `/etc/ssl/sendmail')dnl define(`confCACERT_PATH', `CERT_DIR')dnl define(`confCACERT', `CERT_DIR/CAcert.pem')dnl define(`confSERVER_CERT', `CERT_DIR/MYcert.pem')dnl define(`confSERVER_KEY', `CERT_DIR/MYkey.pem')dnl define(`confCLIENT_CERT', `CERT_DIR/MYcert.pem')dnl define(`confCLIENT_KEY', `CERT_DIR/MYkey.pem')dnl dnl dnl Uncomment next lines to hide identity of mail serve define(`confPRIVACY_FLAGS',`goaway,restrictqrun,restrictmailq')dnl dnl define(`confSMTP_LOGIN_MSG', `$j server ready at $b')dnl MAILER(smtp)dnl MAILER(procmail)dnl MAILER(dovecot)dnl ford dovecot #

4 3

[Dovecot] How do I configure sendmail to accept emails for dovecot when dovecot has sql auth/user db.
by Yossie Silverman 06 Aug '07

06 Aug '07

Included below are my config files: sendmail.mc, dovecot.m4, dovecot.conf, dovecot-sql.conf. Whenever I try to send email into this system, it rejects it with user does not exist, however, the user does exist as far as dovecot (imap) is concerned, it is in the database. THANKS - Yossie # for i in /etc/dovecot/dovecot.conf /etc/dovecot/dovecot-sql.conf / usr/share/sendmail-cf/mailer/dovecot.m4 /etc/mail/sendmail.mc; do echo "FILE: $i"; echo ===; echo ""; egrep -v '^ *(#|$)' $i; echo ""; echo ""; done FILE: /etc/dovecot/dovecot.conf === listen = [::] disable_plaintext_auth = no ssl_disable = yes ssl_cert_file = /etc/ssl/dovecot/server.pem ssl_key_file = /etc/ssl/dovecot/server.key mail_location = maildir:~/.maildir namespace private { separator = . inbox = yes hidden = no } namespace private { separator = . prefix = INBOX. inbox = no hidden = yes } first_valid_uid = 0 protocol imap { } protocol pop3 { } protocol lda { postmaster_address = postmaster(a)example.com main_plugin_dir = /usr/lib/dovecot/lda mail_plugins = cmusieve quota } auth default { mechanisms = plain passdb sql { args = /etc/dovecot/dovecot-sql.conf } userdb sql { args = /etc/dovecot/dovecot-sql.conf } user = root socket listen { master { path = /var/run/dovecot/auth-master mode = 0666 } client { path = /var/run/dovecot/auth-client mode = 0666 } } } dict { } plugin { } FILE: /etc/dovecot/dovecot-sql.conf === driver = mysql connect = host=localhost dbname=dovecot user=root default_pass_scheme = PLAIN password_query = SELECT userPassword as password, user, concat("/var/ spool/dovecot/",substr(user,1,1),"/user/",user) as userdb_home, 97 as userdb_uid, 97 as userdb_gid FROM authdb WHERE user = '%n' and userPassword = '%w' user_query = SELECT concat("/var/spool/imap/",substr(user,1,1),"/ user/",user) as home, 97 as uid, 97 as gid FROM authdb WHERE user = '%n' FILE: /usr/share/sendmail-cf/mailer/dovecot.m4 === Mdovecot, P=/usr/libexec/dovecot/deliver, F=DFMPhnu9, S=EnvFromSMTP/HdrFromSMTP, R=EnvToSMTP/HdrFromSMTP, T=DNS/RFC822/X-Unix, A=deliver -d $u FILE: /etc/mail/sendmail.mc === divert(-1) dnl This is the macro config file used to generate the /etc/sendmail.cf dnl file. If you modify the file you will have to regenerate the dnl /etc/sendmail.cf by running this macro config through the m4 dnl preprocessor: dnl dnl m4 /etc/mail/sendmail.mc > /etc/mail/sendmail.cf dnl dnl You will need to have the sendmail-cf package installed for this to dnl work. include(`/usr/share/sendmail-cf/m4/cf.m4')dnl define(`confDEF_USER_ID',``mail:mail'')dnl OSTYPE(`linux')dnl undefine(`UUCP_RELAY')dnl undefine(`BITNET_RELAY')dnl define(`confALIAS_WAIT', `30')dnl define(`confTO_CONNECT', `1m')dnl define(`confTRY_NULL_MX_LIST',true)dnl define(`confDONT_PROBE_INTERFACES',true)dnl define(`PROCMAIL_MAILER_PATH',`/usr/bin/procmail')dnl dnl define delivery mode: interactive, background, or queued dnl define(`confDELIVERY_MODE', `i') MASQUERADE_AS(`ford.qa.laszlosystems.com')dnl FEATURE(`limited_masquerade')dnl FEATURE(`masquerade_envelope')dnl FEATURE(`smrsh',`/usr/sbin/smrsh')dnl FEATURE(mailertable)dnl dnl virtusertable: redirect incoming mail to virtual domain to particular user or domain FEATURE(`virtusertable',`hash -o /etc/mail/virtusertable')dnl dnl genericstable: rewrite sender address for outgoing mail FEATURE(genericstable)dnl FEATURE(always_add_domain)dnl FEATURE(redirect)dnl FEATURE(use_cw_file)dnl FEATURE(local_procmail)dnl FEATURE(`access_db')dnl FEATURE(`blacklist_recipients')dnl FEATURE(`relay_based_on_MX')dnl dnl FEATURE(dnsbl, `blackholes.mail-abuse.org', `Rejected - see http://www.mail-abuse.org/rbl/')dnl dnl FEATURE(dnsbl, `dialups.mail-abuse.org', `Dialup - see http:// www.mail-abuse.org/dul/')dnl dnl FEATURE(dnsbl, `relays.mail-abuse.org', `Open spam relay - see http://www.mail-abuse.org/rss/')dnl FEATURE(`delay_checks')dnl FEATURE(`stickyhost')dnl dnl SASL Configuration dnl extract from http://www.sendmail.org/~ca/email/auth.html dnl dnl Next two lines are for SMTP Authentication TRUST_AUTH_MECH(`LOGIN PLAIN')dnl define(`confAUTH_MECHANISMS', `LOGIN PLAIN')dnl dnl dnl Next line stops sendmail from allowing auth without encryption define(`confAUTH_OPTIONS', `Apy')dnl dnl dnl STARTTLS configuration dnl extract from http://www.sendmail.org/~ca/email/starttls.html dnl define(`CERT_DIR', `/etc/ssl/sendmail')dnl define(`confCACERT_PATH', `CERT_DIR')dnl define(`confCACERT', `CERT_DIR/CAcert.pem')dnl define(`confSERVER_CERT', `CERT_DIR/MYcert.pem')dnl define(`confSERVER_KEY', `CERT_DIR/MYkey.pem')dnl define(`confCLIENT_CERT', `CERT_DIR/MYcert.pem')dnl define(`confCLIENT_KEY', `CERT_DIR/MYkey.pem')dnl dnl dnl Uncomment next lines to hide identity of mail serve define(`confPRIVACY_FLAGS',`goaway,restrictqrun,restrictmailq')dnl dnl define(`confSMTP_LOGIN_MSG', `$j server ready at $b')dnl MAILER(smtp)dnl MAILER(procmail)dnl MAILER(dovecot)dnl ford dovecot #

2 1

[Dovecot] Benchmark: Appending 250k messages
by Timo Sirainen 06 Aug '07

06 Aug '07

I just changed Dovecot v1.1 code to work much more nicely when appending new messages to large mailboxes. Dovecot hg (cydir format, fsync_disable=yes): ./imaptest secs=1 ./imaptest - append=100,0 logout=0 msgs=10000000 clients=1 seed=1 secs=300 Logi Sele Appe 100% 100% 100% 1 1 2322 1/ 1 0 0 1998 1/ 1 0 0 2293 1/ 1 0 0 2009 1/ 1 0 0 1789 1/ 1 0 0 1245 1/ 1 0 0 43 1/ 1 0 0 32 1/ 1 0 0 881 1/ 1 0 0 2137 1/ 1 .. 0 0 704 1/ 1 0 0 771 1/ 1 0 0 388 1/ 1 0 0 831 1/ 1 0 0 572 1/ 1 0 0 766 1/ 1 Totals: 1 1 251397 Averaging 837/sec. The append speed jumps around quite a lot. Typically it's around 800-1000/sec, but it jumps between 0-500/sec also quite often. I'm not sure why that is. Cyrus v2.3.8 (fsync and fdatasync calls disabled from code): ./imaptest - append=100,0 logout=0 msgs=10000000 clients=1 seed=1 secs=300 Logi Sele Appe 100% 100% 100% 1 1 2587 1/ 1 0 0 1907 1/ 1 0 0 1597 1/ 1 0 0 1260 1/ 1 0 0 1220 1/ 1 0 0 1151 1/ 1 0 0 1068 1/ 1 .. 0 0 121 1/ 1 0 0 127 1/ 1 0 0 128 1/ 1 0 0 126 1/ 1 Totals: 1 1 79613 Averaging 265/sec. The speed slows down pretty consistently, there's no jumping like with Dovecot.

1 0

[Dovecot] Disable IMAP for certain users, but not Webmailer
by FORMER 03 | Baltasar Cevc 06 Aug '07

06 Aug '07

Hi everybody, I'm planning to set up our new mail system using the Dovecot mailbox server. It mostly works fine yet (it's quite straigt forward to set up, I'd say), but there's a thing I haven't been able to find out yet. We provide POP3 access for all users, but want to restrict IMAP access to some of them (because IMAP users tend to leave more messages on the server, thus increasing storage needs). I used to do it by providing two services. One provided the public imap and checked a database flag during authentication, the other just provided IMAP on localhost and did not check the "allowed to use IMAP" flag. What I've found for Dovecot is http://wiki.dovecot.org/Authentication/RestrictAccess While this allows me to provide full POP3 to everybody and in the same time restricting IMAP, I don't see a possibility Is there any possibility to achieve what I need without having two completely separated instances of Dovecot running? I'd appreciate any hints, pointers to documents etc. Thanx, Baltasar -- _____ FORMER 03 GmbH _____ infanteriestra§e 19 haus 6 eg _____ 80797 muenchen _____ baltasar.cevc(a)former03.de _____ www.former03.de _____ fon 089.322112.29 _____ fax 089.322112.11 _____ mobil 0178.691.2233 _____ geschftsfhrer _____ sebastian fiedler _____ gert zellentin _____ handelsregister _____ HRB Mnchen 148468 _____ steuer _____ ust.-id DE 2291076876

6 12

[Dovecot] dovecot.index.cache weirdness
by Tan Shao Yi 06 Aug '07

06 Aug '07

Hi Timo, Just a quick check, may I know if the following output of idxview is normal? (see bottom of e-mail) I am running dovecot-1.0.3 on a Solaris 10 SPARC box. Deleting dovecot.index.cache does not seem to help for this user; it keeps getting regenerated with these same lines. I seems that I have to set mmap_disable=yes on this box to have a "clean-looking" dovecot.index.cache. Is it mmap related? Or it just happens to be a coincidence? Cheers, Tan Shao Yi /usr/local/libexec/dovecot/idxview dovecot.index dovecot.index.cache (... normal looking stuff ...) RECORD: offset=408, seq=22, uid=126, flags=0 - ext cache(0): 0 (00000000) RECORD: offset=420, seq=23, uid=127, flags=0 - ext cache(0): 0 (00000000) RECORD: offset=432, seq=24, uid=128, flags=0 - ext cache(0): 0 (00000000) RECORD: offset=444, seq=25, uid=129, flags=0 - ext cache(0): 0 (00000000) RECORD: offset=456, seq=26, uid=130, flags=0 - ext cache(0): 0 (00000000) RECORD: offset=468, seq=27, uid=131, flags=0 - ext cache(0): 0 (00000000) RECORD: offset=480, seq=28, uid=132, flags=0 - ext cache(0): 0 (00000000) RECORD: offset=492, seq=29, uid=133, flags=0 - ext cache(0): 0 (00000000) RECORD: offset=504, seq=30, uid=134, flags=0 - ext cache(0): 0 (00000000) RECORD: offset=516, seq=31, uid=135, flags=0 - ext cache(0): 0 (00000000) RECORD: offset=528, seq=32, uid=136, flags=0 - ext cache(0): 0 (00000000) RECORD: offset=540, seq=33, uid=137, flags=0 - ext cache(0): 0 (00000000) RECORD: offset=552, seq=34, uid=138, flags=0 - ext cache(0): 0 (00000000) RECORD: offset=564, seq=35, uid=139, flags=0 - ext cache(0): 0 (00000000)

2 1