January 2010 - dovecot

Re: [Dovecot] How can I configure dovecot as gmail imap proxy
by Supratik Goswami 20 Jan '10

20 Jan '10

Here the proxy server should authenticate the user. If the user is in the list of authenticated users then dovecot will allow to connect to imap.gmail.com. Consider a scenario where a client tries to read his mailbox from imap.gmail.com:993. Client executes the command "mutt -f imaps://imap.gmail.com", the request is first authenticated at the proxy server. If the request is coming from a valid user, dovecot will allow to connect to imap.gmail.com and fetch mails for that user. Can you please help me with the steps to configure the server. Warm Regards Supratik

2 1

[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