- dovecot - dovecot.org

[Dovecot] LDA and POP3/IMAP user_query
by Michael 20 Jan '10

20 Jan '10

How do I get IMAP+POP3 vs. LDA to use different user_query statements? The problem is that the input fields are different. IMAP/POP3 is an email address LDA is a username I have written a long statement to try and cater for both however it still only works 99% of the time, and the remaining 1% fails. The 1% that fails sees the mail being delivered to the wrong mbox. In this particular case the same client owned both mboxes so it was ok, but if this had not been the case things could have gotten real embarrassing. Think of the following: abcwidgets(a)theirdomain.tld mailuser1 mailuser1(a)adomain.tld mailuser2 Now when using the Postfix LDA, email for each address is properly delivered to the specified mbox, however in this case because their is a matching name for the mbox and the email address lefthand content, the compound SQL query returns both results and the LDA will use the first one, which in this case was the wrong one. This is the query used: user_query = \ SELECT mailboxes.username AS user, mailboxes.uid, mailboxes.gid, \ concat('*:storage=',mailquota,'M') AS quota_rule \ FROM mailboxes JOIN accounts ON accounts.username = mailboxes.username \ WHERE ((mailboxes.username = '%n' AND accounts.active='1') || \ (mailboxes.email = '%u' AND mailboxes.active='1' AND accounts.active='1') || \ (mailboxes.email = CONCAT('@','%d') AND mailboxes.active='1' \ AND (SELECT COUNT(email) FROM mailboxes WHERE email='%u') = '0')) which additionally caters for the few catch alls our users have. I think this is a massive oversight in the design of Dovecot to use one query to for 2 separate and distinct processes, that both use different parameters. From what I can tell it seems to assume that a mail system will always use username@domain addresses, and never anything more arbitrary. Has anyone found a way around this? Michael

3 4

[Dovecot] shared namespaces with common prefix prefix
by Frank Cusack 19 Jan '10

19 Jan '10

Can shared/public namespaces' prefixes have a common prefix? :) namespace public { separator = / prefix = zz/shared/ location = maildir:/var/maildir/shared:INDEX=/var/maildir/%n/shared subscriptions = no } # to share other employees mailboxes (term'd or admin access) namespace shared { separator = / prefix = zz/shared/%%u/ location = maildir:/var/maildir/%%n:INDEX=/var/maildir/users/%%u subscriptions = no list = children } Since I added the shared namespace, I can no longer access the public namespace. The folders show up but then trying to access one gets the error that the mailbox doesn't exist. If they can't have a common part of the prefix, is that an IMAP limitation or could dovecot conceivably handle it? -frank

2 4

[Dovecot] Auto Discard Vacation Sieve in a date
by Andrés Yacopino 19 Jan '10

19 Jan '10

I have deploy an environment with pigeon sieve, managesieve, dovecot, squirrelmail and avelsieve plugin. The vacation messages are working fine. I am looking for a method to discard vacation messages in some date, when the user returns. ¿Has somebody looked in this feature? Thanks a lot, -- Andrés Fernando Yacopino Infraestructura - Dpto Sistemas AcaSalud Cooperativa de Prestaciones Médico Asistenciales Limitada Tel: 0341-4208726 ayacopino(a)acasalud.com.ar

2 1

[Dovecot] Auto discard sieve vacation messages
by Andrés Yacopino 19 Jan '10

19 Jan '10

I have deploy an environment with pigeon sieve, managesieve, dovecot, squirrelmail and avelsieve plugin. The vacation messages are working fine. I am looking for a method to discard vacation messages in some date, when the user returns. Has somebody looked in this feature? Thanks a lot, -- Andrés Fernando Yacopino Infraestructura - Dpto Sistemas AcaSalud Cooperativa de Prestaciones Médico Asistenciales Limitada Tel: 0341-4208726 ayacopino(a)acasalud.com.ar

2 1

[Dovecot] Virtual folder, Program terminated with signal 6
by Matthias Rieber 19 Jan '10

19 Jan '10

Hi, I've regularly crashes with a certain virtual folder. Erasing the dovecot-index.* files help just for few hours/days. Here are to backtraces: Core was generated by `imap'. Program terminated with signal 6, Aborted. [New process 25893] #0 0xf7df8556 in raise () from /lib/libc.so.6 #0 0xf7df8556 in raise () from /lib/libc.so.6 No symbol table info available. #1 0xf7df9d78 in abort () from /lib/libc.so.6 No symbol table info available. #2 0x080f2d25 in default_fatal_finish (type=<value optimized out>, status=0) at failures.c:160 backtrace = 0x88ee860 "imap [0x80f2d11] -> imap [0x80f2d92] -> imap [0x80f26e9] -> imap(index_search_result_update_flags+0x295) [0x80b2305] -> /usr/local/lib/dovecot/imap/lib20_virtual_plugin.so [0xf7da937d] -> /usr/local/l"... #3 0x080f2d92 in i_internal_fatal_handler (type=LOG_TYPE_PANIC, status=0, fmt=0x810b88c "file %s: line %d (%s): assertion failed: (%s)", args=0xff8b2ea4 "\\S\021\bW") at failures.c:443 No locals. #4 0x080f26e9 in i_panic (format=0x810b88c "file %s: line %d (%s): assertion failed: (%s)") at failures.c:207 No locals. #5 0x080b2305 in index_search_result_update_flags (result=0x9400cb0, uids=0xff8b3150) at index-search-result.c:87 search_arg = {next = 0x89024c0, type = SEARCH_UIDSET, value = {subargs = 0x0, seqset = {arr = {buffer = 0x88ee4a8, element_size = 8}, v = 0x88ee4a8, v_modifiable = 0x88ee4a8}, str = 0x0, time = 0, size = 0, flags = 0, search_flags = 0, thread_type = MAIL_THREAD_NONE, keywords = 0x0, modseq = 0x0, search_args = 0x0, search_result = 0x0}, context = 0x0, hdr_field_name = 0x0, not = 0, match_always = 0, result = -1} ret = <value optimized out> __PRETTY_FUNCTION__ = "index_search_result_update_flags" #6 0xf7da937d in virtual_sync_backend_boxes (ctx=0x93f6660) at virtual-sync.c:733 _data_stack_cur_id = 4 i = 0 ret = 155151376 #7 0xf7daa25b in virtual_storage_sync_init (box=0xb20e070, flags=65) at virtual-sync.c:1486 sync_ctx = <value optimized out> ret = <value optimized out> #8 0x080b6ab2 in mailbox_sync (box=0x6525, flags=65, status_items=239, status_r=0xff8b3338) at mail-storage.c:593 ctx = <value optimized out> #9 0x080651b8 in cmd_select_full (cmd=0x88fbc88, readonly=false) at cmd-select.c:273 client = (struct client *) 0x88fb9f8 box = (struct mailbox *) 0x0 ctx = (struct imap_select_context *) 0x88fbd28 args = (const struct imap_arg *) 0x88fe508 mailbox = 0x88ee2b8 "obfuscated" ret = <value optimized out> __PRETTY_FUNCTION__ = "cmd_select_full" #10 0x08065919 in cmd_select (cmd=0x88fbc88) at cmd-select.c:389 No locals. #11 0x08067bfc in client_command_input (cmd=0x88fbc88) at client.c:612 client = (struct client *) 0x88fb9f8 command = <value optimized out> __PRETTY_FUNCTION__ = "client_command_input" #12 0x08067c99 in client_command_input (cmd=0x88fbc88) at client.c:661 client = (struct client *) 0x88fb9f8 command = <value optimized out> __PRETTY_FUNCTION__ = "client_command_input" #13 0x08067e0d in client_handle_input (client=0x88fb9f8) at client.c:702 _data_stack_cur_id = 3 ret = false remove_io = <value optimized out> handled_commands = false __PRETTY_FUNCTION__ = "client_handle_input" #14 0x0806876f in client_input (client=0x88fb9f8) at client.c:753 cmd = <value optimized out> output = (struct ostream *) 0x88fbbac bytes = <value optimized out> __PRETTY_FUNCTION__ = "client_input" #15 0x080fbac0 in io_loop_handler_run (ioloop=0x88f61a8) at ioloop-epoll.c:208 ctx = (struct ioloop_handler_context *) 0x88f6c18 event = (const struct epoll_event *) 0x88f6c58 list = (struct io_list *) 0x88fbc30 io = (struct io_file *) 0x88fbc08 tv = {tv_sec = 1, tv_usec = 707102} t_id = 2 msecs = <value optimized out> ret = 1 i = 0 j = 0 call = <value optimized out> #16 0x080faf30 in io_loop_run (ioloop=0x88f61a8) at ioloop.c:335 No locals. #17 0x0807127a in main (argc=) at main.c:327 No locals. Core was generated by `imap'. Program terminated with signal 6, Aborted. [New process 26275] #0 0xf7ea4556 in raise () from /lib/libc.so.6 #0 0xf7ea4556 in raise () from /lib/libc.so.6 No symbol table info available. #1 0xf7ea5d78 in abort () from /lib/libc.so.6 No symbol table info available. #2 0x080f2d25 in default_fatal_finish (type=<value optimized out>, status=0) at failures.c:160 backtrace = 0x88d9860 "imap [0x80f2d11] -> imap [0x80f2d92] -> imap [0x80f26e9] -> imap(index_search_result_update_flags+0x295) [0x80b2305] -> /usr/local/lib/dovecot/imap/lib20_virtual_plugin.so [0xf7e5537d] -> /usr/local/l"... #3 0x080f2d92 in i_internal_fatal_handler (type=LOG_TYPE_PANIC, status=0, fmt=0x810b88c "file %s: line %d (%s): assertion failed: (%s)", args=0xffe03774 "\\S\021\bW") at failures.c:443 No locals. #4 0x080f26e9 in i_panic (format=0x810b88c "file %s: line %d (%s): assertion failed: (%s)") at failures.c:207 No locals. #5 0x080b2305 in index_search_result_update_flags (result=0x9318e10, uids=0xffe03a20) at index-search-result.c:87 search_arg = {next = 0x893dfe8, type = SEARCH_UIDSET, value = {subargs = 0x0, seqset = {arr = {buffer = 0x88d94a8, element_size = 8}, v = 0x88d94a8, v_modifiable = 0x88d94a8}, str = 0x0, time = 0, size = 0, flags = 0, search_flags = 0, thread_type = MAIL_THREAD_NONE, keywords = 0x0, modseq = 0x0, search_args = 0x0, search_result = 0x0}, context = 0x0, hdr_field_name = 0x0, not = 0, match_always = 0, result = -1} ret = <value optimized out> __PRETTY_FUNCTION__ = "index_search_result_update_flags" #6 0xf7e5537d in virtual_sync_backend_boxes (ctx=0x930e9e8) at virtual-sync.c:733 _data_stack_cur_id = 4 i = 0 ret = 154202008 #7 0xf7e5625b in virtual_storage_sync_init (box=0x88ebcf0, flags=65) at virtual-sync.c:1486 sync_ctx = <value optimized out> ret = <value optimized out> #8 0x080b6ab2 in mailbox_sync (box=0x66a3, flags=65, status_items=239, status_r=0xffe03c08) at mail-storage.c:593 ctx = <value optimized out> #9 0x080651b8 in cmd_select_full (cmd=0x88e6c88, readonly=false) at cmd-select.c:273 client = (struct client *) 0x88e69f8 box = (struct mailbox *) 0x0 ctx = (struct imap_select_context *) 0x88e6d28 args = (const struct imap_arg *) 0x88e9508 mailbox = 0x88d92b8 "obfuscated" ret = <value optimized out> __PRETTY_FUNCTION__ = "cmd_select_full" #10 0x08065919 in cmd_select (cmd=0x88e6c88) at cmd-select.c:389 No locals. #11 0x08067bfc in client_command_input (cmd=0x88e6c88) at client.c:612 client = (struct client *) 0x88e69f8 command = <value optimized out> __PRETTY_FUNCTION__ = "client_command_input" #12 0x08067c99 in client_command_input (cmd=0x88e6c88) at client.c:661 client = (struct client *) 0x88e69f8 command = <value optimized out> __PRETTY_FUNCTION__ = "client_command_input" #13 0x08067e0d in client_handle_input (client=0x88e69f8) at client.c:702 _data_stack_cur_id = 3 ret = false remove_io = <value optimized out> handled_commands = false __PRETTY_FUNCTION__ = "client_handle_input" #14 0x0806876f in client_input (client=0x88e69f8) at client.c:753 cmd = <value optimized out> output = (struct ostream *) 0x88e6bac bytes = <value optimized out> __PRETTY_FUNCTION__ = "client_input" #15 0x080fbac0 in io_loop_handler_run (ioloop=0x88e11a8) at ioloop-epoll.c:208 ctx = (struct ioloop_handler_context *) 0x88e1c18 event = (const struct epoll_event *) 0x88e1c58 list = (struct io_list *) 0x88e6c30 io = (struct io_file *) 0x88e6c08 tv = {tv_sec = 1, tv_usec = 627183} t_id = 2 msecs = <value optimized out> ret = 1 i = 0 j = 0 call = <value optimized out> #16 0x080faf30 in io_loop_run (ioloop=0x88e11a8) at ioloop.c:335 No locals. #17 0x0807127a in main (argc=) at main.c:327 No locals. kind regards, Matthias

2 4

[Dovecot] Log the virtual email address and not the local account - dovecot 1.2.2 w/ MySQL
by Bill 19 Jan '10

19 Jan '10

I recently started using dovecot and have it working well but I have one item I haven't been able to find an answer for. I am using MySQL with Dovecot for authentication with my virtual email customers. When the user logs in and checks email a log entry is recorded. Instead of the email address (bob(a)bob.net) being logged it records the local account (vemail101) in the POP3 log. How can I get dovecot to reflect the email address that the customer logged in with instead of the local account? Thx, Bill

2 2

[Dovecot] fts squat non-english search for 2 words
by vuser1＠test123.ru 19 Jan '10

19 Jan '10

Hello, It looks I encoutered a bug or misconfiguration. fts_squat search for subject and body works excellent for English mails. For non-English (in particular, Russian) it works only when query consists of 1 word. Phrases - 2 and more words - always returns nothing. Example: search for "planet" ("планета") returns results, search for "Earth" ("Земля") also returns results, but "planet Earth" ("планета Земля") returns nothing. But there are emails having exact phrase "planet Earth". This problem occurs only for non-English queries, both for search in subject and in email body. I tried web-mail Horde 3.2 and Thunderbird. I turned fts plugin off and it correctly finds phrases with 2 and more russian words! So problem is squat. Is it a bug or known config issue? OS: Debian 5.0, installed as openVZ container inside Ubuntu 8.04. Dovecot: 1.2.4, from backports.org Ext3 filesys dovecot -n -------------- # 1.2.4: /etc/dovecot/dovecot.conf # OS: Linux 2.6.24-24-openvz i686 Debian 5.0.3 simfs log_timestamp: %Y-%m-%d %H:%M:%S protocols: imap imaps pop3 pop3s ssl_cert_file: /etc/ssl/test123/test123.full.crt ssl_key_file: /etc/ssl/test123/priv/test123.key disable_plaintext_auth: no login_dir: /var/run/dovecot/login login_executable(default): /usr/lib/dovecot/imap-login login_executable(imap): /usr/lib/dovecot/imap-login login_executable(pop3): /usr/lib/dovecot/pop3-login last_valid_uid: 500 mail_privileged_group: mail mail_location: maildir:/var/mail/%u mbox_write_locks: fcntl dotlock mail_executable(default): /usr/lib/dovecot/imap mail_executable(imap): /usr/lib/dovecot/imap mail_executable(pop3): /usr/lib/dovecot/pop3 mail_plugins(default): quota imap_quota fts fts_squat mail_plugins(imap): quota imap_quota fts fts_squat mail_plugins(pop3): mail_plugin_dir(default): /usr/lib/dovecot/modules/imap mail_plugin_dir(imap): /usr/lib/dovecot/modules/imap mail_plugin_dir(pop3): /usr/lib/dovecot/modules/pop3 imap_client_workarounds(default): outlook-idle delay-newmail imap_client_workarounds(imap): outlook-idle delay-newmail imap_client_workarounds(pop3): pop3_client_workarounds(default): pop3_client_workarounds(imap): pop3_client_workarounds(pop3): outlook-no-nuls oe-ns-eoh lda: postmaster_address: postmaster(a)test123.ru hostname: test123.ru sendmail_path: /usr/sbin/sendmail auth_socket_path: /var/run/dovecot/auth-master mail_plugins: quota sieve log_path: info_log_path: auth default: mechanisms: plain login user: nobody passdb: driver: sql args: /etc/dovecot/dovecot-sql.conf userdb: driver: passwd userdb: driver: sql args: /etc/dovecot/dovecot-sql.conf userdb: driver: prefetch socket: type: listen client: path: /var/spool/postfix/private/auth mode: 432 user: postfix group: mail master: path: /var/run/dovecot/auth-master mode: 432 user: vmail group: mail plugin: acl: vfile:/etc/dovecot/acls trash: /etc/dovecot/trash.conf fts: squat fts_squat: partial=4 full=20 --------------- (with full=10 problem persists)

2 7

[Dovecot] virtual namespace question
by Josephus 19 Jan '10

19 Jan '10

Hi, I'm wondering if it is possible to create a virtual namespace on a prefix other than "virtual/". My goal is to mix IMAP folders with virtual folders on the same folder level (prefix = ""). mail_location = maildir:/data/mail/%d/%u/ # Virtual namespace private { prefix = separator = / location = virtual:/data/mail/%d/%u/virtual } # Default namespace private { separator = / prefix = inbox = yes } With this configuration the folders show up on the same level, but I'm unable to subscribe to them. When I change the prefix back to "virtual/" it works, but folders are still gruoped under "virtual". Funny thing is, when I use a prefix something like "vfolder/", the root folder is no longer greyed out in my MUA (TB3), and I get a "Mailbox doesn't exist: vfolder" error msg if I click on it. BR, Jos

2 1

[Dovecot] Best way of dealing with Case-Sensitive Issues in Dovecot
by Mario Antonio 19 Jan '10

19 Jan '10

In order to deal with case-sensitive issues, I am thinking to use the variable %L (adding it to my current configs --as suggested before by other users in this list) in the configuration files in this way: In Dovecot.conf: mail_location = maildir:/vmail/%Ld/%Ln/Maildir:INDEX=/indexes/%Ld/%Ln auth default: username_format: %Lu passdb: driver: sql args: /etc/dovecot/dovecot-sql.conf userdb: driver: sql args: /etc/dovecot/dovecot-sql.conf userdb: driver: static args: uid=5000 gid=5000 home=/vmail/%Ld/%Ln allow_all_users=yes In dovecot-sql.conf: password_query = select concat(virtual_users.user, '@', virtual_domains.name) AS user, virtual_users.password as password \ from virtual_users LEFT JOIN virtual_domains ON virtual_users.domain_id=virtual_domains.id \ where virtual_users.user='%Ln' and virtual_domains.name='%Ld' and virtual_users.status = 1 and virtual_domains.status = 1; user_query = SELECT 5000 AS uid,5000 AS gid,'/vmail/%Ld/%Ln' as home, \ concat('*:storage= ', virtual_users.quota_kb) AS quota_rule \ from virtual_users LEFT JOIN virtual_domains ON virtual_users.domain_id=virtual_domains.id \ where virtual_users.user='%Ln' and virtual_domains.name='%Ld' Is this the correct way of assuring lowercase use all over the place? Can I use the variable %L in where sql statements? Regards, Mario Antonio

2 1

[Dovecot] expire plugin doesn't find mail location
by Roland Rosenfeld 19 Jan '10

19 Jan '10

Hi! After searching for hours now, I give up and have to ask here. I try to use the expire plugin but it always tries to expire my mails instead of the mails of the user. I read about the "Mail location setting problem (v1.1-v1.2) and configured a "mail" extra field in the userdb, but that doesn't have the effect I want. I have not idea, what I could try out more, so I ask here. My setup is the following: # 1.2.9: /usr/local/dovecot/etc/dovecot.conf # OS: SunOS 5.10 sun4v zfs syslog_facility: local6 protocols: imap pop3 managesieve listen(default): * listen(imap): * listen(pop3): * listen(managesieve): *:2000, *:4190 ssl: no disable_plaintext_auth: no login_dir: /usr/local/dovecot/var/run/dovecot/login login_executable(default): /usr/local/dovecot/libexec/dovecot/imap-login login_executable(imap): /usr/local/dovecot/libexec/dovecot/imap-login login_executable(pop3): /usr/local/dovecot/libexec/dovecot/pop3-login login_executable(managesieve): /usr/local/dovecot/libexec/dovecot/managesieve-login mail_uid: 2001 mail_gid: 2001 mail_location: maildir:/var/mailstore/%2Mn/%n/mail mail_debug: yes mail_executable(default): /usr/local/dovecot/libexec/dovecot/imap mail_executable(imap): /usr/local/dovecot/libexec/dovecot/imap mail_executable(pop3): /usr/local/dovecot/libexec/dovecot/pop3 mail_executable(managesieve): /usr/local/dovecot/libexec/dovecot/managesieve mail_plugins(default): quota imap_quota expire mail_plugins(imap): quota imap_quota expire mail_plugins(pop3): quota expire mail_plugins(managesieve): mail_plugin_dir(default): /usr/local/dovecot/lib/dovecot/imap mail_plugin_dir(imap): /usr/local/dovecot/lib/dovecot/imap mail_plugin_dir(pop3): /usr/local/dovecot/lib/dovecot/pop3 mail_plugin_dir(managesieve): /usr/local/dovecot/lib/dovecot/managesieve pop3_uidl_format(default): %08Xu%08Xv pop3_uidl_format(imap): %08Xu%08Xv pop3_uidl_format(pop3): %v.%u pop3_uidl_format(managesieve): %08Xu%08Xv namespace: type: private separator: / inbox: yes list: yes subscriptions: yes lda: postmaster_address: postmaster(a)netcologne.de hostname: mailstore20.netcologne.de mail_plugins: sieve quota expire auth_socket_path: /usr/local/dovecot/var/run/dovecot/auth-master auth default: master_user_separator: * verbose: yes debug: yes passdb: driver: passwd-file args: /usr/local/dovecot/etc/passwd.master pass: yes master: yes passdb: driver: sql args: /usr/local/dovecot/etc/dovecot-sql.conf userdb: driver: prefetch userdb: driver: sql args: /usr/local/dovecot/etc/dovecot-sql.conf socket: type: listen master: path: /usr/local/dovecot/var/run/dovecot/auth-master mode: 384 user: vmail plugin: quota: maildir expire: INBOX 60 Spam 60 Papierkorb 60 Trash 1 expire_dict: proxy::expire dict: expire: mysql:/usr/local/dovecot/etc/dovecot-dict-expire.conf With the following dovecot-sql.conf: driver = mysql connect = host=localhost dbname=cyrus user=cyrus password=XXXX default_pass_scheme = CRYPT password_query = \ SELECT username, password, concat('*:storage=', quota) AS userdb_quota_rule, '/var/mailstore/%2Mn/%n' as userdb_home, 'maildir:/var/mailstore/%2Mn/%n/mail' as userdb_mail \ FROM passwd WHERE username='%n' user_query = \ SELECT concat('*:storage=', quota) AS quota_rule, '/var/mailstore/%2Mn/%n' as home, 'maildir:/var/mailstore/%2Mn/%n/mail' as mail \ FROM passwd WHERE username='%n' And this is dovecot-dict-expire.conf: connect = host=localhost dbname=dovecot user=dovecot password=XXXXXX map { pattern = shared/expire/$user/$mailbox table = expires value_field = expire_stamp fields { username = $user mailbox = $mailbox } } In user test's Trash folder there are mails that are older than 1 day and in dovecot.expires there is +----------+---------+--------------+ | username | mailbox | expire_stamp | +----------+---------+--------------+ | test | Trash | 1262779049 | +----------+---------+--------------+ But if I run /usr/local/dovecot/sbin/dovecot --exec-mail ext /usr/local/dovecot/libexec/dovecot/expire-tool.sh --test I get the following output: Info: Loading modules from directory: /usr/local/dovecot/lib/dovecot/imap Info: Module loaded: /usr/local/dovecot/lib/dovecot/imap/lib10_quota_plugin.so Info: Module loaded: /usr/local/dovecot/lib/dovecot/imap/lib20_expire_plugin.so Info: Quota root: name= backend=maildir args= Info: expire: pattern=INBOX type=expunge secs=5184000 Info: expire: pattern=Spam type=expunge secs=5184000 Info: expire: pattern=Papierkorb type=expunge secs=5184000 Info: expire: pattern=Trash type=expunge secs=86400 Info: auth input: quota_rule=*:storage=10000 Info: auth input: home=/var/mailstore/09/test Info: auth input: mail=maildir:/var/mailstore/09/test/mail Info: Namespace: type=private, prefix=, sep=/, inbox=yes, hidden=no, list=yes, subscriptions=yes Info: maildir: data=/var/mailstore/df/rrosenfeld/mail Info: maildir++: root=/var/mailstore/df/rrosenfeld/mail, index=, control=, inbox=/var/mailstore/df/rrosenfeld/mail Info: test/Trash: no messages left Info: test/Spam: stop, expire time in future: Sat Mar 6 12:35:10 2010 As you can see, it uses my username (rrosenfeld) instead of the username "test", whose mailbox should be expired. But while the above it printed to the console I get the following in the logfile: Jan 12 15:33:54 mailstore20 dovecot: [ID 583609 local6.info] dict: mysql: Connected to localhost (dovecot) Jan 12 15:33:54 mailstore20 dovecot: [ID 583609 local6.info] auth(default): master in: USER 1 test service=internal Jan 12 15:33:54 mailstore20 dovecot: [ID 583609 local6.info] auth(default): prefetch(test): passdb didn't return userdb entries, trying the next userdb Jan 12 15:33:54 mailstore20 dovecot: [ID 583609 local6.info] auth-worker(default): sql(test): SELECT concat('*:storage=', quota) AS quota_rule, '/var/mailstore/09/test' as home, 'maildir:/var/mailstore/09/test/mail' as mail FROM passwd WHERE username='test' Jan 12 15:33:54 mailstore20 dovecot: [ID 583609 local6.info] auth-worker(default): mysql: Connected to localhost (cyrus) Jan 12 15:33:54 mailstore20 dovecot: [ID 583609 local6.info] auth(default): master out: USER 1 test quota_rule=*:storage=10000 home=/var/mailstore/09/test mail=maildir:/var/mailstore/09/test/mail As you can see, the auth engine sees the request for the user "test". It also returns the correct home and mail attributes (the above messages were triggered by my expire call!). I tried out to comment out the mail_location from dovecot.conf to make sure that the mail attribute from userdb is used, but this has the effect, that dovecot expire does not know any mail location setting at all and tries some "home" directories and different mail storage formats while my setting mail=maildir:/var/mailstore/09/test/mail from the userdb is completely ignored: Info: Loading modules from directory: /usr/local/dovecot/lib/dovecot/imap Info: Module loaded: /usr/local/dovecot/lib/dovecot/imap/lib10_quota_plugin.so Info: Module loaded: /usr/local/dovecot/lib/dovecot/imap/lib20_expire_plugin.so Info: Quota root: name= backend=maildir args= Info: expire: pattern=INBOX type=expunge secs=5184000 Info: expire: pattern=Spam type=expunge secs=5184000 Info: expire: pattern=Papierkorb type=expunge secs=5184000 Info: expire: pattern=Trash type=expunge secs=86400 Info: auth input: quota_rule=*:storage=10000 Info: auth input: home=/var/mailstore/09/test Info: auth input: mail=maildir:/var/mailstore/09/test/mail Info: Namespace: type=private, prefix=, sep=/, inbox=yes, hidden=no, list=yes, subscriptions=yes Info: cydir: mailbox location not given Info: cydir: Couldn't create mail storage : Root mail directory not given Info: dbox: mailbox location not given Info: dbox: Couldn't create mail storage : Root mail directory not given Info: maildir: access(/var/mailstore/09/test/Maildir, rwx): failed: No such file or directory Info: maildir: couldn't find root dir Info: maildir: Couldn't create mail storage : Root mail directory not given Info: mbox: root exists (/var/mailstore/09/test/mail) Info: mbox: INBOX: access(/var/mail/test, rw) failed: No such file or directory Info: mbox: INBOX: access(/var/spool/mail/test, rw) failed: No such file or directory Info: mbox: INBOX defaulted to /var/mailstore/09/test/mail/inbox Info: fs: root=/var/mailstore/09/test/mail, index=, control=, inbox=/var/mailstore/09/test/mail/inbox Info: test/Trash: no messages left Info: test/Spam: stop, expire time in future: Sat Mar 6 12:35:10 2010 As you can see, expire tries to access different (default?) mailbox typies instead of simply using maildir:/var/mailstore/09/test/mail as defined in the userdb. So my main problem seems to be, that the mail attribute from the userdb is completely ignored in expire calls. But how do I fix this? Tschoeeee Roland -- Roland Rosenfeld - Content Delivery - NED - Technik NetCologne Gesellschaft für Telekommunikation mbH - HRB 25580, AG Köln Am Coloneum 9 50829 Köln Tel.: +49-221-2222-373 Fax: +49-221-2222-7373 Geschäftsführer: Werner Hanf, Karl-Heinz Zankel

2 2