- dovecot - dovecot.org

[Dovecot] Autobuilder packages for Debian stable/i386 now available
by Stephan Bosch 20 Jan '10

20 Jan '10

Hi, A few days back I started the first automated slave builder that produces bleeding edge Debian stable packages for Dovecot v1.2 and v2.0. It uses the source packages already provided by the automated master repository (which builds binary packages for Debian testing), so that the version numbers and content are equal throughout all Debian releases. The repository is available as follows: deb http://xi.rename-it.nl/debian/ stable-auto/dovecot-1.2 main Or, for Dovecot v2.0: deb http://xi.rename-it.nl/debian/ stable-auto/dovecot-2.0 main Read this for more information: http://wiki.dovecot.org/PrebuiltBinaries#Automatically_Built_Packages I hope to add amd64 binary support soon. Regards, Stephan.

1 0

Re: [Dovecot] Oracle SQL driver
by Alexander Bukharov 20 Jan '10

20 Jan '10

> The transaction handling doesn't look correct to me. The sql_update()s > just add the change to a linked list and commit() is then supposed to > run them in one transaction and either everything should succeed or > fail. Your commit appears to ignore errors and just commit everything > that goes through? Also since nothing is actually sent before commit(), > your rollback() shouldn't need to send ROLLBACK. You right. I've corrected the transaction handling mechanism. The only thing I couldn't understand: why rollback() shouldn't need to make real ROLLBACK? In case when whole transaction was failed succeded statements will remain uncommited. Then they will be commited later on next successful transaction. May be ROLLBACK is still needed? > The "VARCHAR sqltext[2048]" seems like an unnecessary restriction on the > query length. Wasn't there a way to do this without the limit? Or in AFAIK there is no possibility to use C types in PREPARE statement. Also Oracle cannot handle unsized VARCHARs. I've increased VARCHAR size to 65535. > test_connection() seems unnecessary. Right you are. > Couldn't driver_oracle_generate_name() be simply: > static unsigned int counter = 0; > return i_strdup_printf("ORACONN_%x", ++counter); =) Right. > driver_oracle_escape_string() really should be escaping the string. I made this function to replace single quote in string with two single quotes. IMHO this should be enough. How do you think? > Kind of annoying that each query needs a cursor, even though nearly all > queries are expected to return only a single row, but I guess that can't > be helped with the current API.. Yes. There are no other ways to work with untyped statements in OCI. But Oracle claims that all these statements shouldn't produce significant performance impact. The new version attached.

2 3

[Dovecot] ManageSieve doe not work
by Mike Werner 20 Jan '10

20 Jan '10

Hi, I use MailScanner 4.74.16 (Ubuntu karmic). I convigured ManageSieve as discribed in http://wiki.dovecot.org/ManageSieve/Configuration. But sieve scripts are not applied to incoming mail. How can I determin what went wrong? -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean.

2 1

[Dovecot] Dovecot 2.0 beta imap session crash report
by wenjie zheng 20 Jan '10

20 Jan '10

System config: RHEL 5.3, 64 bit Dovecot 2.0 beta (changeset "2882650531e0", 10 days old) installed with lda and lmtp Symptom: IMAP session crashed when I tried to delete a non-exist mailbox, e.g., Trash in my test [root@mail4a LocalIntegrationTest]# telnet localhost 143 * OK [CAPABILITY IMAP4rev1 LITERAL+ SASL-IR LOGIN-REFERRALS ID ENABLE AUTH=PLAIN] Dovecot ready. a login testmail4a2(a)dev.p4nt5.com xxxxxx a OK [CAPABILITY IMAP4rev1 LITERAL+ SASL-IR LOGIN-REFERRALS ID ENABLE SORT SORT=DISPLAY THREAD=REFERENCES THREAD=REFS MULTIAPPEND UNSELECT IDLE CHILDREN NAMESPACE UIDPLUS LIST-EXTENDED I18NLEVEL=1 CONDSTORE QRESYNC ESEARCH ESORT SEARCHRES WITHIN CONTEXT=SEARCH QUOTA] Logged in a delete Trash Connection closed by foreign host. Error log: Jan 12 12:33:26 mail4a dovecot: imap(testmail4a2(a)dev.p4nt5.com): maildir++: root=/data/mail/de/dev.p4nt5.com/te/testmail4a2, index=, control=, inbox= Jan 12 12:33:31 mail4a dovecot: imap(testmail4a2(a)dev.p4nt5.com): open() failed with index file (null): Bad address Jan 12 12:33:31 mail4a dovecot: master: service(imap): child 20867 killed with signal 11 (core dumps disabled) How to reproduce: Delete a non-exist mailbox after login Thanks, Wenjie

2 3

Re: [Dovecot] ManageSieve doe not work
by Nick Rosier 20 Jan '10

20 Jan '10

Mike Werner wrote: > Hi, > > I use MailScanner 4.74.16 (Ubuntu karmic). I convigured ManageSieve as > discribed in http://wiki.dovecot.org/ManageSieve/Configuration. But sieve > scripts are not applied to incoming mail. How can I determin what went > wrong? ManageSieve is to manage sieve filters. Your MDA does the filtering. Have you configured Dovecot deliver as your MDA? See: http://wiki.dovecot.org/LDA N.

1 0

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

[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

[Dovecot] Dovecot-deliver sometimes fails when message set to discard via sieve
by Steve Wagner 19 Jan '10

19 Jan '10

Hi, sometimes mails that i discard via sieve gets delivered to my inbox and i can not figure out why. So i hope you can give me a hint. My setup is: I use a self compiled dovecot 1.2.4 with installed sieve and managesieve plugin. Incoming mails a processed by Postfix and the delivered to Procmail. Procmail invokes Spamassassin and discard all mails marked as spam. The other mails are passed to Dovecot deliver this way: :0 w | /opt/dovecot/libexec/dovecot/deliver For moving mails to subdirectorys this works always, but not for mails that are discard via Sieve. Examples are: if header :contains "List-Id" "git.vger.kernel.org" { if header :contains "Subject" "[ANNOUNCE]" { fileinto "Announce"; stop; } if header :contains "Subject" "[ANN]" { fileinto "Announce"; stop; } if header :contains "Subject" "[PATCH" { discard; stop; } fileinto "Lists.Git"; stop; } or if header :contains "Organization" "web.de" { discard; stop; } This often works, but sometimes it fails. Procmail reports then that deliver reported an error (but not which) and delivers them to my inbox. There are also no message in dovecots or dovecot delivers log file. Dose anybody have an idea? Steve

3 12

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

19 Jan '10

Hi, I want to configure dovecot as gmail imap proxy. If any system in my network wants to connect to imap.gmail.com,993 it has to go through the dovecot proxy. Is it possible to setup such environment with dovecot? If yes, can you please help me to configure my dovecot server. Warm Regards Supratik

3 2

[Dovecot] Update Dovecot index files on maildrop delivery?
by Kārlis Repsons 19 Jan '10

19 Jan '10

Hi all, is there some easy way to inform Dovecot about a new delivery, which has happened after postfix invoked maildrop, so the index files would be updated?

3 5

[Dovecot] Socket permission 432/384 and dovecot.conf
by Seba 19 Jan '10

19 Jan '10

Sorry for that question but: when you set in dovecot.conf this for example: socket listen { client { path = /var/spool/postfix/private/auth mode = 0660 user = postfix group = postfix } } and you run "dovecot -n" you'll see client: path: /var/spool/postfix/private/auth mode: 432 I'm wondering about the mode "432" - how is this value calculated? Same for the auth/master socket socket - the value ist "384" and in dovecot.conf it's 0600. Thanks for any info. Seba

3 2

[Dovecot] Dovecot Proxy and environment variables
by BaQs 19 Jan '10

19 Jan '10

Dear list, First of all, I am French so excuse my bad english. I am currently using dovecot proxy feature, using sql backend. I "proxy" the imap/pop requests to another server, let's say server2. On server2, I use a script to keep up to date a "pop before smtp auth" database. I used mail_executable = /path/to/this/script.sh ... My problem is: the $IP environment variable on server2 is the proxy's IP. How could I give a variable from proxy to server2, or simply get the real client public IP ? Thanks a lot in advance for your answers Pierre. PS: let me also thank very much dovecot developers and community !

3 7

[Dovecot] No filelocking at "shared-mailboxes" dictionary?
by Peer Heinlein 19 Jan '10

19 Jan '10

Using imapsync I changed many ACLs on many accounts simultaneously in four concurrent IMAP-sessions. I started with an empty file "shared-mailboxes". But after the sync the file "shared-mailboxes" has been crashed. I found broken lines and I'm missing some entrys. Is it possible that there's no filelocking on that file? I used the ext3 filesystem. That's what shred-mailboxes looks like at the moment: shared/shared-box 1 shared/shared-boxes/user/user1.example.com/user2.example.com 1 .example.com/user5.example.com 1 hared/shared-boxes/user/user6.example.com/user4.example.c2442203233424^? 1 ser/user7.example.com/user2.example.com Peer dovecot -n: # 1.2.9: /etc/dovecot/dovecot.conf # OS: Linux 2.6.27.39-0.2-default x86_64 openSUSE 11.1 (x86_64) protocols: imap imaps managesieve ssl_cert_file: /etc/ssl/old.pem ssl_key_file: /etc/ssl/old.pem shutdown_clients: 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(managesieve): /usr/lib/dovecot/managesieve-login login_process_per_connection: no login_max_processes_count: 512 max_mail_processes: 1024 mail_max_userip_connections(default): 40 mail_max_userip_connections(imap): 40 mail_max_userip_connections(managesieve): 10 verbose_proctitle: yes mail_uid: vmail mail_gid: vmail mail_location: maildir:~/Maildir mail_executable(default): /usr/lib/dovecot/imap-usernamenmigration mail_executable(imap): /usr/lib/dovecot/imap-usernamenmigration mail_executable(managesieve): /usr/lib/dovecot/managesieve mail_plugins(default): quota imap_quota acl imap_acl mail_plugins(imap): quota imap_quota acl imap_acl mail_plugins(managesieve): mail_plugin_dir(default): /usr/lib64/dovecot/modules/imap mail_plugin_dir(imap): /usr/lib64/dovecot/modules/imap mail_plugin_dir(managesieve): /usr/lib64/dovecot/modules/managesieve namespace: type: private separator: / inbox: yes list: yes subscriptions: yes namespace: type: shared separator: / prefix: zz_SHARED_ACCOUNTS/%%u/ location: maildir:%%h/Maildir:INDEX=~/Maildir/shared/%%u list: yes lda: postmaster_address: postmaster(a)iea-dpc.org mail_plugins: quota acl sieve mail_plugin_dir: /usr/lib64/dovecot/modules/lda quota_full_tempfail: yes auth default: mechanisms: plain login digest-md5 cram-md5 verbose: yes debug: yes debug_passwords: yes passdb: driver: passwd-file args: /etc/dovecot/userdb userdb: driver: passwd-file args: /etc/dovecot/userdb userdb: driver: static args: uid=5001 gid=5001 socket: type: listen client: path: /var/spool/postfix/private/auth mode: 432 user: postfix group: postfix master: path: /var/run/dovecot/auth-master mode: 432 user: vmail group: vmail plugin: quota: maildir quota_rule: *:storage=102400 acl: vfile acl_shared_dict: file:/var/lib/dovecot/shared-mailboxes sieve: ~/.dovecot.sieve sieve_dir: ~/sieve -- Heinlein Professional Linux Support GmbH Linux: Akademie - Support - Hosting http://www.heinlein-support.de Tel: 030 / 40 50 51 - 0 Fax: 030 / 40 50 51 - 19 Zwangsangaben lt. §35a GmbHG: HRB 93818 B / Amtsgericht Berlin-Charlottenburg, Geschäftsführer: Peer Heinlein -- Sitz: Berlin

2 1

[Dovecot] Fail to handle . and - in mailaddresses
by Mika 18 Jan '10

18 Jan '10

Hi, I seem to have run into a bug. Dot and dash is allowed chars in mail addresses, so a ...---...@ should work. Filtered out domainname and IP's for security reasons. And yes this works with MDaemon as example. Setup is postfix using Dovecot for deliver. Version: 1.2.9 OS: Linux ADM64 (Ubuntu 8.04LTS) Tried to deliver mail to rfc compliant mail address ...---...@domain. # 1.2.9: /opt/dovecot/etc/dovecot.conf # OS: Linux 2.6.24-25-server i686 Ubuntu 8.04.3 LTS ext3 log_path: /var/log/dovecot protocols: imaps imap listen: 127.0.0.1 ssl_listen: :943 ssl_cert_file: /etc/ssl/certs/secure.crt ssl_key_file: /etc/ssl/private/secure.key login_dir: /opt/dovecot/var/run/dovecot/login login_executable: /opt/dovecot/libexec/dovecot/imap-login mail_gid: 1005 mail_location: maildir:/opt/vmail/%d/%n/Maildir lda: postmaster_address: postmaster(a)domain.com sendmail_path: /usr/sbin/sendmail auth_socket_path: /var/run/dovecot/auth-master log_path: /opt/vmail/dovecot-deliver.log auth default: mechanisms: plain login passdb: driver: pam passdb: driver: sql args: /opt/dovecot/etc/dovecot-sql.conf userdb: driver: passwd userdb: driver: static args: uid=5000 gid=5000 home=/opt/vmail/%d/%n allow_all_users=yes socket: type: listen client: path: /var/spool/postfix/private/auth mode: 432 user: postfix group: postfix master: path: /var/run/dovecot/auth-master mode: 384 user: vmail >From Deliver logfile: deliver(...---...(a)domain.com): Jan 14 08:18:24 Info: msgid=<798c378b1001132318y4a027757m37a668f48730e6c(a)mail.gmail.com>: saved mail to INBOX # Does not seem to end up in any of the files in Maildir, new/tmp folders are empty. Maildir/cur# grep ...---...(a)domain.com * Maildir/cur# //Mika

2 2

[Dovecot] sieve: discarding vacation response
by wenjie zheng 18 Jan '10

18 Jan '10

Configuration: RHEL 5.3, Dovecot 2.0 beta1, dovecot-2.0-sieve (1week old) [wenjie@build dovecot2-2.0.beta1]$ telnet mail4a 24 Trying 172.19.1.74... Connected to mail4a.cloud.dev.mlsrvr.com (172.19.1.74). Escape character is '^]'. 220 mail4a Dovecot LMTP ready mail from:<testmail4a50(a)dev.p4nt5.com> 250 2.1.0 OK rcpt to:<testmail4a2(a)dev.p4nt5.com> 250 2.1.5 OK DATA 354 OK From: <testmail4a50(a)dev.p4nt5.com> To: foo Subject: hello Hello there . 250 2.0.0 <testmail4a2(a)dev.p4nt5.com> eMcYKg7gUEt8ewAA0TR52A Saved quit 221 2.0.0 Client quit Connection closed by foreign host. testmail4a2(a)dev.p4nt5.com has a local .dovecot.sieve file, which contains a vacation auto response. #begin require ["fileinto", "body", "vacation"]; vacation :days 1 text: I am away. . ; keep; #end In the log: Jan 15 15:38:07 mail4a dovecot: lmtp(31612, testmail4a2(a)dev.p4nt5.com) eMcYKg7gUEt8ewAA0TR52A: sieve: msgid=unspecified: discarding vacation response for message implicitly delivered to <testmail4a2(a)dev.p4nt5.com> Jan 15 15:38:07 mail4a dovecot: lmtp(31612, testmail4a2(a)dev.p4nt5.com) eMcYKg7gUEt8ewAA0TR52A: sieve: msgid=unspecified: stored mail into mailbox 'INBOX' Thanks, Wenjie

2 2

[Dovecot] Upgrade path questions
by Thomas M Goerger 18 Jan '10

18 Jan '10

Hi, We are currently running Dovecot v1.1.6 on our servers, and are contemplating an upgrade to 1.2, or 2.0 soon. We are wondering how many organizations are still running a 1.1 version of Dovecot, and if anyone has any thoughts on this transition. Have you upgraded from 1.1 to 1.2? What are your experiences with this? Have you upgraded from 1.1 to 2.0 directly? What are your experiences this way? We are also running an environment with both mbox and maildir formats. How many of you are running similarly, or are running solely maildir or mbox? We're just looking to gather information going forward, and anything you might be able to contribute would be very helpful. Thanks! ************************************************************************* * Tom Goerger - Email/Unix System Administrator * * * * University of Minnesota Email: tmg(a)umn.edu * * Operations, Infrastructure and Architecture Phone: 4-5804 * * Internet Services Office: 626J WBOB * * * *************************************************************************

4 3