- dovecot - dovecot.org

[Dovecot] Dovecot 2.0.rc4 (a30a30d1e25a): LMTP dies intermittently
by Thomas Leuxner 06 Aug '10

06 Aug '10

Hi, not sure what change caused this but it first appeared when building HG a30a30d1e25a. LMTP dies intermittently. Aug 6 16:00:57 spectre dovecot: lmtp(5509, alias(a)domain.tld) b9ESKJkVXEyFFQAAqZii3w: sieve: msgid=<1281102852.6211.447.camel(a)kurkku.sapo.corppt.com>: stored mail into mailbox 'Public/Mailing-Lists/Dovecot' Aug 6 16:00:57 spectre dovecot: lmtp(5509): Disconnect from local: Client quit Aug 6 16:17:05 spectre dovecot: master: Error: service(lmtp): child 5509 killed with signal 11 (core not dumped) Let me know if you need more details. Regards Thomas

2 6

[Dovecot] assertion failure with 2.0rc4
by Ryan Murray 06 Aug '10

06 Aug '10

Ran into an assertion error on login with 2.0rc4, with kmail and the N900 mail client: OS: Ubuntu Lucid 10.04.1 LTS FS: ext4 arch: x86-64 dovecot: imap-login: Login: user=<rmurray>, method=PLAIN, rip=192.168.1.9, lip=192.168.1.1, mpid=31843, TLS dovecot: imap(rmurray): Panic: file istream-header-filter.c: line 85 (read_mixed): assertion failed: (pos > 0) dovecot: master: Error: service(imap): child 31843 killed with signal 6 (core dumped) #0 0x0000003e9fa33a75 in raise () from /lib/libc.so.6 No symbol table info available. #1 0x0000003e9fa375c0 in abort () from /lib/libc.so.6 No symbol table info available. #2 0x00007f419e3bdd34 in default_fatal_finish (type=LOG_TYPE_PANIC, status=0) at failures.c:164 backtrace = 0x1542898 "ot.so.0(+0x26793) [0x7f900d292793] -> /usr/lib/dovecot/libdovecot.so.0(i_stream_read+0xbb) [0x7f900d2b6979] -> /usr/lib/dovecot/libdovecot.so.0(i_stream_read_data+0x61) [0x7f900d2b7676] -> /usr/lib/do"... #3 0x00007f419e3bf01c in i_internal_fatal_handler (type=LOG_TYPE_PANIC, status=0, fmt=0x7f419e3e9778 "file %s: line %d (%s): assertion failed: (%s)", args=0x7fff6244c100) at failures.c:593 No locals. #4 0x00007f419e3be05c in i_panic ( format=0x7f419e3e9778 "file %s: line %d (%s): assertion failed: (%s)") at failures.c:230 args = {{gp_offset = 0, fp_offset = 0, overflow_arg_area = 0x0, reg_save_area = 0x0}} #5 0x00007f419e3a1a4d in read_mixed (mstream=0x1598d20, body_highwater_size=0) at istream-header-filter.c:81 data = 0x0 pos = 0 ret = -1 __FUNCTION__ = "read_mixed" #6 0x00007f419e3a1e92 in read_header (mstream=0x1598d20) at istream-header-filter.c:164 body_highwater_size = 0 hdr = 0x0 highwater_offset = 0 pos = 0 ret = 0 matched = false hdr_ret = 0 __FUNCTION__ = "read_header" #7 0x00007f419e3a2793 in i_stream_header_filter_read (stream=0x1598d20) at istream-header-filter.c:351 mstream = 0x1598d20 v_offset = 22292552 ret = 22634928 #8 0x00007f419e3c6979 in i_stream_read (stream=0x1598d80) at istream.c:115 _stream = 0x1598d20 old_size = 1 ret = 140734842061776 __FUNCTION__ = "i_stream_read" #9 0x00007f419e3c7676 in i_stream_read_data (stream=0x1598d80, data_r=0x7fff6244c3b0, size_r=0x7fff6244c3a0, threshold=1) at istream.c:417 ret = 0 read_more = false __FUNCTION__ = "i_stream_read_data" #10 0x00007f419e3a7c91 in message_parse_header_next (ctx=0x159b440, hdr_r=0x7fff6244c408) at message-header-parser.c:89 line = 0x0 msg = 0x0 i = 0 size = 0 startpos = 0 colon_pos = 0 parse_size = 0 ret = 32767 continued = false continues = false last_no_newline = 127 last_crlf = 65 no_newline = false crlf_newline = false __FUNCTION__ = "message_parse_header_next" #11 0x00007f419e3a9e3c in parse_next_header (ctx=0x159b078, block_r=0x7fff6244c480) at message-parser.c:480 part = 0x1591558 hdr = 0x0 size = 22613672 ret = -1 __FUNCTION__ = "parse_next_header" #12 0x00007f419e3aaa05 in message_parser_parse_next_block (ctx=0x159b078, block_r=0x7fff6244c480) at message-parser.c:768 ret = 22615384 eof = false full = false __FUNCTION__ = "message_parser_parse_next_block" #13 0x00007f419e3aabc6 in message_parser_parse_header (ctx=0x159b078, hdr_size=0x1590f60, callback=0x7f419e68e1f8 <index_mail_parse_part_header_cb>, context=0x1590d48) at message-parser.c:807 block = {part = 0x0, hdr = 0x0, data = 0x0, size = 0} ret = 0 __FUNCTION__ = "message_parser_parse_header" #14 0x00007f419e68e575 in index_mail_parse_headers (mail=0x1590d48, headers=0x0) at index-mail-headers.c:437 data = 0x1590ea8 input = 0x1598d80 old_offset = 0 #15 0x00007f419e68b648 in index_mail_init_stream (mail=0x1590d48, hdr_size=0x7fff6244c640, body_size=0x7fff6244c620, stream_r=0x7fff6244c668) at index-mail.c:849 data = 0x1590ea8 input = 0x0 ret = 1 #16 0x00007f419e6b8377 in mbox_mail_get_stream (_mail=0x1590d48, hdr_size=0x7fff6244c640, body_size=0x7fff6244c620, stream_r=0x7fff6244c668) at mbox-mail.c:363 mail = 0x1590d48 #17 0x00007f419e62fb06 in mail_get_stream (mail=0x1590d48, hdr_size=0x7fff6244c640, body_size=0x7fff6244c620, stream_r=0x7fff6244c668) at mail.c:179 p = 0x1590d48 #18 0x00007f419e68a4b6 in index_mail_get_virtual_size (_mail=0x1590d48, size_r=0x7fff6244c6f8) at index-mail.c:389 mail = 0x0 data = 0x0 hdr_size = {physical_size = 0, virtual_size = 0, lines = 0} body_size = {physical_size = 4333341, virtual_size = 22595280, lines = 51875} input = 0x0 old_offset = 0 __FUNCTION__ = "index_mail_get_virtual_size" #19 0x00007f419e62f8cc in mail_get_virtual_size (mail=0x1590d48, size_r=0x7fff6244c6f8) at mail.c:114 p = 0x1590d48 #20 0x0000000000419d85 in fetch_rfc822_size (ctx=0x157d388, mail=0x1590d48, context=0x0) at imap-fetch-body.c:888 size = 22595280 #21 0x0000000000416af6 in imap_fetch_more_int (ctx=0x157d388) at imap-fetch.c:471 h = 0x157d708 _data_stack_cur_id = 4 client = 0x157cb78 handlers = 0x157d6e0 count = 5 ret = 1 __FUNCTION__ = "imap_fetch_more_int" #22 0x0000000000416d4d in imap_fetch_more (ctx=0x157d388) at imap-fetch.c:523 ret = 0 __FUNCTION__ = "imap_fetch_more" #23 0x000000000040b964 in cmd_fetch (cmd=0x157d238) at cmd-fetch.c:227 client = 0x0 ctx = 0x0 args = 0x0 next_arg = 0x0 list_arg = 0x0 search_args = 0x158b708 messageset = 0x157fb88 "51875:51896" ret = 0 #24 0x000000000041187e in cmd_uid (cmd=0x157d238) at cmd-uid.c:27 command = 0x154b710 cmd_name = 0x157fb80 "FETCH" #25 0x0000000000413507 in client_command_input (cmd=0x157d238) at imap-client.c:660 client = 0x157cb78 command = 0x7fff6244c870 __FUNCTION__ = "client_command_input" #26 0x0000000000413766 in client_command_input (cmd=0x157d238) at imap-client.c:710 client = 0x157cb78 command = 0x154b6c8 __FUNCTION__ = "client_command_input" #27 0x0000000000413891 in client_handle_next_command (client=0x157cb78, remove_io_r=0x7fff6244c90e) at imap-client.c:751 size = 92 #28 0x0000000000413911 in client_handle_input (client=0x157cb78) at imap-client.c:763 _data_stack_cur_id = 3 ret = false remove_io = false handled_commands = false __FUNCTION__ = "client_handle_input" #29 0x0000000000413a87 in client_input (client=0x157cb78) at imap-client.c:802 cmd = 0x154a7e8 output = 0x157d158 bytes = 92 __FUNCTION__ = "client_input" #30 0x00007f419e3cef4a in io_loop_handler_run (ioloop=0x154a5c0) at ioloop-epoll.c:212 ctx = 0x0 events = 0x0 event = 0x0 list = 0x0 io = 0x0 tv = {tv_sec = 1799, tv_usec = 999898} events_count = 6 t_id = 2 msecs = 1800000 ret = 0 i = 0 j = 0 call = true #31 0x00007f419e3cdb31 in io_loop_run (ioloop=0x154a5c0) at ioloop.c:350 No locals. #32 0x00007f419e3b635c in master_service_run (service=0x154a490, callback=0x41f592 <client_connected>) at master-service.c:496 No locals. #33 0x000000000041f7fc in main (argc=1, argv=0x154a370) at main.c:358 set_roots = {0x422ee0, 0x0} service_flags = 0 storage_service_flags = 0 postlogin_socket_path = 0x0 username = 0x0 c = 0

2 1

[Dovecot] Strange behaviour when add new mailbox to IMAP (v 1.2.13)
by Alexander Chekalin 06 Aug '10

06 Aug '10

Hi, I think I need to ask you for advice. Personally I face that for the first time and hardly imagine this could be possible at all, but... My setup is simple: I have one mail server where all of my mail accounts are stored, and another one to store backup of all mailings. The scheme is simple, SMTP on first server forwards a copy of each message to address catchall(a)secondserver.my-domain. So whenever I need to restore any message I'll simple search for it on second server. Both servers are have Dovecot 1.2.13 as IMAP servers. First server's Dovecot is sql-backed one, the second server's (in fact it serving just one box) is using passwd-style text file auth. Other than this, setup is pretty similiar, and everything is well, but here is the mystery: I use Thunderbird (yesterday it was 3.1.1 and now it is 3.1.2) as my IMAP client. When I connect to my IMAP account on second server, and create mailbox, I see that there appears greyed folder named #virtual^Sent , and my new mailbox is in it. When I do the same thing on first server, everything works just as I expect it (new mailbox created right under root of my IMAP account). If I create on second server new mailbox right under any existing (say, under Inbox) everything is fine also. To check the problem I simplified my Dovecot config to the bare minimum, and it also won't work (#virtual^Sent still there). When I see on server disk, I see there .#virtual^Sent.NewTestMailbox dir (NewTestMailbox is the test mailbox I created), but there is no .#virtual^Sent dir. I rebuilt Dovecot, and also tried to build 1.2.12, none worked. May there be any solution for that? Yours, Alexander Chekalin

2 1

[Dovecot] Problem creating sockets after Solaris Live Upgrade
by Jürgen Obermann 06 Aug '10

06 Aug '10

Hello, I use Solaris Live Upgrade to install solaris patches in an alternate boot environment. Unfortunately the dovecot sockets /opt/local/var/run/dovecot/dict-server and /opt/local/var/run/dovecot/login/default are created as normal files in the ABE. After switching to the ABE dovecot will not start because of the existence of these two files. After removing these files dovecot starts normally. I think that dovecot should create the sockets even if there exist files with the same names. Here is the protocol of this: Dovecot uses two sockets in the running system: # ls -al /opt/local/var/run/dovecot/login/default /opt/local/var/run/dovecot/dict-server srwxrwxrwx 1 root root 0 Aug 4 10:07 /opt/local/var/run/dovecot/dict-server srw-rw---- 1 root dovecot 0 Aug 4 10:07 /opt/local/var/run/dovecot/login/default In the Alternate Boot Environment created with Solaris Live Upgrade there are normal files instead of the sockets: # ls -al /a/opt/local/var/run/dovecot/login/default /a/opt/local/var/run/dovecot/login/default -rw-rw---- 1 root dovecot 0 Jul 7 17:01 /a/opt/local/var/run/dovecot/login/default -rw-rw---- 1 root dovecot 0 Jul 7 17:01 /a/opt/local/var/run/dovecot/login/default During booting this ABE dovecot will not start, unless both files are removed: Aug 6 06:55:30 hostname dovecot: Fatal: Socket already exists: /opt/local/var/run/dovecot/dict-server # ls -al /opt/local/var/run/dovecot/dict-server -rwxrwxrwx 1 root root 0 Aug 4 10:09 /opt/local/var/run/dovecot/dict-server # rm /opt/local/var/run/dovecot/dict-server # /etc/init.d/dovecot start Last died with error (see error log for more information): Socket already exists: /opt/local/var/run/dovecot/dict-server Aug 6 06:57:50 hostname dovecot: [ID 583609 local0.info] Dovecot v1.2.12 starting up Aug 6 06:57:50 hostname dovecot: [ID 583609 local0.error] net_listen_unix(/opt/local/var/run/dovecot/login/default) failed: Address already in use Aug 6 06:57:50 hostname dovecot: [ID 583609 local0.crit] Fatal: Couldn't create auth process listener # ls -al /opt/local/var/run/dovecot/dict-server srwxrwxrwx 1 root other 0 Aug 6 06:57 /opt/local/var/run/dovecot/dict-server # ls -al /opt/local/var/run/dovecot/login/default -rw-rw---- 1 root dovecot 0 Aug 4 10:09 /opt/local/var/run/dovecot/login/default # rm /opt/local/var/run/dovecot/login/default # /etc/init.d/dovecot start # ls -al /opt/local/var/run/dovecot/login/default srw-rw---- 1 root dovecot 0 Aug 6 07:00 /opt/local/var/run/dovecot/login/default Both sockets are created by dovecot if they don't exist. Greetings, Jürgen Obermann -- Hochschulrechenzentrum der | Mail: Juergen.Obermann(a)hrz.uni-giessen.de Justus-Liebig-Universitaet | WWW: http://www.uni-giessen.de/obermann/ Heinrich-Buff-Ring 44 | Tel: 0641-99-13054 (0641-99-13001) D-35392 Giessen, Germany | Fax: 0641-99-13009 ---------------------------------------------------------------- This message was sent using IMP, the Internet Messaging Program.

2 1

[Dovecot] dovecot 2.0 rc4, expire, sqlite
by Burckhard Schmidt 06 Aug '10

06 Aug '10

Hello, I will use expire like described within wiki2.dovecot.org/Plugins/Expire with sqlite for a folder AutoCleanSpam. If I copy a message (with TB) into that folder, I get an error if there exists no entry for that user and that folder within the database: dict: Error: sqlite: exec(INSERT INTO expires (expire_stamp,username,mailbox) VALUES ('1281016832','userx','AutoCleanSpam')) failed: unable to open database file (14) dict: Error: sql dict: commit failed: If I make an initial entry manually first no error occurs. Anymore there is a problem concerning acl of the base directory of the expires.db: dict: Error: sqlite: open(/addons/expire/expires.db) failed: unable to open database file dict: Error: dict sql lookup failed: out of memory It was necessary to give "other" r-x permissions for directory /addons/expire. I use mail_uid = sysdov and mail_gid = sysdov. That is uid 29. Furthermore I work with userdb ldap and uid/gid mapping: user_attrs = homeDirectory=home,uidNumber=29,gidNumber=29 So usually it was sufficient using acl like this drwxr-x--- 2 sysdov sysdov 5 Aug 5 16:00 /addons/expire As which user expire, dict, sqlite access are running? -- Regards --- Burckhard Schmidt

2 2

[Dovecot] Write a c program to access a mailbox as a system user using dovecot version 2 includes/libs
by Jonathan Siegle 06 Aug '10

06 Aug '10

Should this be doable with the current design? Is there a good reference to do this? Thanks, Jonathan

3 6

[Dovecot] dovecot-auth process crashed during pam login
by Elmar Rudigier 06 Aug '10

06 Aug '10

Hello! We experienced crashes of the dovecot-auth process during user verification with pam_ssh. After a little debugging I saw that pam_ssh and dovecot both provide a buffer_free() function. During cleanup of pam_ssh the buffer_free() from dovecot was called. The members of the buffer had all "out of bound" addresses. After rename the buffer_free() in dovecot the pam login works fine. Cheer, Elmar

3 2

[Dovecot] Configure Dovecot to move read mails to another folder?
by Steven Weiß 06 Aug '10

06 Aug '10

Hallo, is it possible (with dovecot sieve?) to deliver incoming mails to the default INBOX and then, when I have read the mail with Thunderbird, automatically move it to another folder? I know I could create filters in my mail client. But that has the disadvantage that I would need to create these filters everywhere: on my office PC, at home, webmail, ... Also moving a mail from one folder to another marks the original mail as deleted, at least in Thunderbird. Maybe other clients finally delete the mail. Therefore that would be really cool. Another related problem for me is: how can I automatically move outgoing mails to another folder? I created sieve-rules but it doesn't work - the mails remain in the folder "sent-mail". For example: if address :domain :is "to" "somedomain.de" { fileinto "sent-mail.Somedomain"; stop; } Greetings, Steven

2 1

[Dovecot] Double logging problem
by Nikolaos Milas 06 Aug '10

06 Aug '10

Hi, I have a relatively new installation with LDAP and Postfix, running smoothly on CentOS but it logs dovecot messages both in /var/log/messages and in /var/log/dovecot.log. I have configured it to log in /var/log/dovecot.log (with syslog_facility: local1 and a respective line in syslog.conf, see below) but it also logs in /var/log/messages. As a result, I would expect it to only log into /var/log/dovecot.log. Can someone suggest why this happens and help me stop logging dovecot messages in /var/log/messages ? Could it be because the following directive (in syslog.conf) does not capture dovecot messages to exclude them? *.info;mail.none;authpriv.none;cron.none /var/log/messages Could I use something like (in syslog.conf): *.info;mail.none;authpriv.none;cron.none;dovecot.none /var/log/messages to capture dovecot messages and *exclude* them from /var/log/messages ? I am not sure if syslog understands "dovecot.none". Please explain how this could be done. Here is the configuration (I've changed real domain name with example.com) # dovecot --version 1.2.11 # dovecot -n # 1.2.11: /etc/dovecot.conf # OS: Linux 2.6.18-194.3.1.el5.centos.plus x86_64 CentOS release 5.5 (Final) syslog_facility: local1 ssl_ca_file: /etc/pki/CA/certs/cert-xxx.pem ssl_cert_file: /etc/pki/CA/certs/cert-xxx.pem ssl_key_file: /etc/pki/CA/private/key-xxx.pem login_dir: /var/run/dovecot/login login_executable(default): /usr/libexec/dovecot/imap-login login_executable(imap): /usr/libexec/dovecot/imap-login login_executable(pop3): /usr/libexec/dovecot/pop3-login mail_max_userip_connections(default): 10 mail_max_userip_connections(imap): 10 mail_max_userip_connections(pop3): 3 mail_location: maildir:~/Maildir/ mail_executable(default): /usr/libexec/dovecot/imap mail_executable(imap): /usr/libexec/dovecot/imap mail_executable(pop3): /usr/libexec/dovecot/pop3 mail_plugins(default): quota imap_quota mail_plugins(imap): quota imap_quota mail_plugins(pop3): quota mail_plugin_dir(default): /usr/lib64/dovecot/imap mail_plugin_dir(imap): /usr/lib64/dovecot/imap mail_plugin_dir(pop3): /usr/lib64/dovecot/pop3 imap_client_workarounds(default): delay-newmail outlook-idle netscape-eoh imap_client_workarounds(imap): delay-newmail outlook-idle netscape-eoh 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)example.com auth default: mechanisms: plain login username_format: %Lu verbose: yes debug: yes passdb: driver: ldap args: /etc/dovecot-ldap.conf userdb: driver: static args: uid=500 gid=500 home=/home/vmail/%u socket: type: listen client: path: /var/spool/postfix/private/auth mode: 432 user: postfix group: postfix plugin: quota: maildir:User quota quota_rule: *:storage=307200 quota_warning: storage=75%% /opt/mail.sh 75 %u # grep -v '^ *$#.*$\?$' /etc/dovecot-ldap.conf hosts = ldap.example.com tls = yes base = ou=people, dc=example, dc=com scope = subtree ldap_version = 3 auth_bind = yes pass_attrs = uid=user,userPassword=password auth_bind_userdn = uid=%u,ou=people,dc=example,dc=com pass_filter = (uid=%u) And the content of /etc/syslog.conf # cat /etc/syslog.conf # Log all kernel messages to the console. # Logging much else clutters up the screen. #kern.* /dev/console # Log anything (except mail) of level info or higher. # Don't log private authentication messages! *.info;mail.none;authpriv.none;cron.none /var/log/messages # The authpriv file has restricted access. authpriv.* /var/log/secure # Log all the mail messages in one place. mail.* -/var/log/maillog # Log cron stuff cron.* /var/log/cron # Everybody gets emergency messages *.emerg * # Save news errors of level crit and higher in a special file. uucp,news.crit /var/log/spooler # Save boot messages also to boot.log local7.* /var/log/boot.log # Dovecot messages will be using local1 local1.* /var/log/dovecot.log #local2.* /var/log/php.log local3.* /var/log/sympa.log Thanks, Nick Milas Greece P.S. I sent this message earlier (a few hours ago), but I didn't see it coming in the dovecot list, so I've decided to send it again.

1 1

[Dovecot] Panic: file ioloop-iolist.c: line 25 (ioloop_iolist_add): assertion failed
by Computer Department (Watchtower South Africa Branch) 06 Aug '10

06 Aug '10

Hi, I receive the following message after running "/etc/init.d/dovecot reload": Aug 06 02:00:11 dovecot: Warning: SIGHUP received - reloading configuration Aug 06 02:00:11 dovecot: Panic: file ioloop-iolist.c: line 25 (ioloop_iolist_add): assertion failed: (list->ios[idx] == NULL) I'm running dovecot version 1.2.13, compiled against uclibc on the Alpine Linux distro, version 1.10.6. This problem started to occur since upgrading to dovecot 1.2.12 from dovecot 1.2.11. No configuration has been changed in between these versions. # 1.2.13: /etc/dovecot/dovecot.conf # OS: Linux 2.6.32.16-grsec i686 rootfs log_path: /var/log/dovecot.log info_log_path: /var/log/dovecot-info.log protocols: imap imaps pop3 pop3s ssl_cert_file: /etc/lighttpd/server-bundle.pem ssl_key_file: /etc/lighttpd/server-bundle.pem disable_plaintext_auth: no login_dir: /var/run/dovecot/login login_executable(default): /usr/libexec/dovecot/imap-login login_executable(imap): /usr/libexec/dovecot/imap-login login_executable(pop3): /usr/libexec/dovecot/pop3-login mail_location: maildir:/var/mail/domains/%d/%n mail_executable(default): /usr/libexec/dovecot/imap mail_executable(imap): /usr/libexec/dovecot/imap mail_executable(pop3): /usr/libexec/dovecot/pop3 mail_plugins(default): quota imap_quota mail_plugins(imap): quota imap_quota mail_plugins(pop3): quota mail_plugin_dir(default): /usr/lib/dovecot/imap mail_plugin_dir(imap): /usr/lib/dovecot/imap mail_plugin_dir(pop3): /usr/lib/dovecot/pop3 lda: postmaster_address: admin(a)windhoek.zaf.wtbts.net mail_plugins: quota auth_socket_path: /var/run/dovecot/auth-master sendmail_path: /usr/sbin/sendmail auth default: verbose: yes passdb: driver: sql args: /etc/dovecot/dovecot-sql.conf userdb: driver: prefetch userdb: driver: sql args: /etc/dovecot/dovecot-sql.conf socket: type: listen master: path: /var/run/dovecot/auth-master mode: 432 user: vmail group: vmail plugin: quota: dict:user::proxy::quotadict dict: quotadict: pgsql:/etc/dovecot/dovecot-dict-quota.conf The init.d script can be found here: http://git.alpinelinux.org/cgit/aports/tree/main/dovecot/dovecot.initd?h =1.10-stable&id=a3087eff06dff4a69b2914cdc1bbe76dce29b448 Any ideas? Thanks for any help you can provide. Duane Hughes

1 0

Re: [Dovecot] AntiSpam Plugin
by Daryl Richards 06 Aug '10

06 Aug '10

On 05/08/10 10:37 AM, Leander S. wrote: > Am 28.07.2010 21:34, schrieb Daryl Richards: >> I've also had this problem in the past. I wrote a wrapper script to >> try to log what is happening. Funny thing is, when run through this >> script it works fine. Without the script it fails. Not sure where to >> look next, I've just kept the script. >> >> #!/usr/local/bin/bash >> >> ( >> id -a >> echo $@ >> /usr/local/bin/sa-learn $@ >> rc=$? >> echo "exit code $rc" >> exit $rc >> ) > /tmp/antispam.out.$$ 2> /tmp/antispam.err.$$ >> >> On 7/28/2010 3:12 PM, Leander S. wrote: >>> >>> >>> >>> >>> >>> On 07/28/2010 07:24 PM Leander S. wrote: >>> >>>> > … >>>> > Jul 28 18:51:40 server imap: antispam: running mailtrain backend >>>> program >>>> > /usr/local/bin/sa-learn >>>> > Jul 28 18:51:40 server imap: antispam: running mailtrain backend >>>> program >>>> > /usr/local/bin/sa-learn >>>> > Jul 28 18:51:41 server imap: antispam: run program failed with exit >>>> code 9 >>>> > > > > "run program failed with exit code 9" --> unfortunately is >>>> nothing >>>> > mentioned in the dovecot antspam man. >>>> > Antispam >>>> manual:http://johannes.sipsolutions.net/files/antispam.html#lbAL >>>> > > > > > > Could anybody give me a hint where to look up this exit >>>> code? Or is >>>> > there a general meaning for exit codes? >>>> > i.e.: 0 means normal ; 5 internal error ; and 9 maybe means syntax >>>> issue >>>> > ... or whatever ?! >>> /usr/local/bin/sa-learn returned exit code 9. So, check the fine >>> spamassassin documentation. >>> >>> ^^ I did - there is nothing mentioned about exit codes at all - except >>> in the spamc manual. But the spamc manual doesn't represent exit code 9. >>> >>> Do you guys maybe have any idea what this could mean? How does your >>> config for antispam looks like - but I doubt there could be anything >>> wrong in mine. >>> >>> ... very weired ... >>> >>> >>> >>> Regards, >>> Leander >>> >>> >>> >>> >>> >>> Regards, >>> Pascal >>> -- The trapper recommends today: f007ba11.1020919(a)localdomain.org >>> >>> > Thanks for the script hint - exactly the same on my side - I also use a > script now - but mine is more simple than yours: > > server [~]# cat /script.sh > #!/usr/local/bin/bash > > /usr/local/bin/sa-learn $1 $2 $3 $4 &> /DoveDamnAntispam.log > exit 0 ; > server [~]# > > > > > Antispam part of dovecot.conf: > > ### Dovecot AntiSpam ### > # mail signature (used with any backend requiring a signature) > #antispam_signature = X-Spam-Status > #antispam_signature_missing = move > > antispam_mail_sendmail = /script.sh > #antispam_mail_sendmail = /usr/local/bin/sa-learn > antispam_mail_sendmail_args = --username=%u;--debug;all > antispam_mail_spam = --spam > antispam_mail_notspam = --ham > antispam_mail_tmpdir = /tmp > antispam_spam = Spam > antispam_unsure = Virus > antispam_trash = Trash > > > Works fine for me now - but it's really weired ... > > Anyway - lots of thx, hey! ;) > > regards I added the extra debugging to show exactly what was happening - what user was calling sa-learn, what the exit code was, etc... But, as I said, it didn't help as it runs perfectly through that script! -- Daryl Richards Isle Technical Services Inc.

1 0

[Dovecot] Cyrus to Dovecot migration (OS X Server): Backup + restore messages, live "standby server" and delayed expunge and…
by Thomas von Eyben 05 Aug '10

05 Aug '10

Hi List, I am very close to migrating from Cyrus to Dovecot (to be more precise from Mac OS X Server 10.5.8 to 10.6.4). The latter is reporting the dovecotd version to be 1.1.20apple0.5. All I have read about dovecot is extremely positive so I am exited to make the switch. BACKUP: BUT I would like to be sure that I can make a sound backup strategy. For Cyrus i used topicdesk's mailbfr (a script that stops the mailservice and then rsync's the mailstore to a backup location incrementing daily and restarting a complete backup weekly). This script is not yet ready for Dovecot, but from what I have read it should be as easy as "just" backing up the mail-data (/var/spool/imap/dovecot/mail in OS X), eg. with rsync. Our current setup is requiring ca. 11 hours for a full (200+ GB) backup (weekly) this is not good for uptime… RESTORE: Restore should be the same (well reverse) "just" restoring the files and making sure the get the correct permissions. What I am not sure about is the (cyrus specific) need for reconstructing the database, as I have read (on this list) it seems that dovecot is designed better and will "automatically" recognised the restored messages without the need to reconstruct any databases or stopping+restarting the service. Is this really true ,-)? NB.: For restores I plan to always restore to a specific subfolder for the user (eg RESTORED MAIL) as opposed to placing the mails within the folder hierachy LIVE BACKUP SERVER I have been told, that dovecot provides clever mechanisms for making it possible to synchronise the data to a "hot-spare" server. Both for being able to provide access to the data during breakdown or planned maintenance, but perhaps also to make backups easier (perhaps not needed?) DELAYED DELETION OF MESSAGES I believe that the feature is called "delayed expunge", a way of not deleting the messages until after an additional delay from the time the user deletes the message. Is this possible in dovecot? DOCUMENTATION Where would the best FAQ/KB for getting to know dovecot better be, perhaps there have even been written good books (I know old fashioned, but I really like the physical hands on a real book provides ;-) It's a lot of questions and I hope for good pointers to where I can find more documentation and good feedback from the list. BR Thomas von Eyben

3 2

[Dovecot] v2.0.rc4 released
by Timo Sirainen 05 Aug '10

05 Aug '10

http://dovecot.org/releases/2.0/rc/dovecot-2.0.rc4.tar.gz http://dovecot.org/releases/2.0/rc/dovecot-2.0.rc4.tar.gz.sig I'm planning to release rc5 maybe this Friday or weekend, and if there are no serious bugs just change the version number to v2.0.0 a day or two later. Largest changes since rc3: + director: Added director_doveadm_port for accepting doveadm TCP connections. + doveadm: Added client/server architecture support for running mail commands. Enable this by setting doveadm_worker_count to non-zero. + mail-log: Added support for mailbox_create event. + imap_capability = +XFOO BAR can be used to add capabilities instead of replacing the whole capability string. + virtual storage: Added support for IDLE notifications. - doveadm mailbox status: Fixed listing non-ASCII mailbox names. - doveadm fetch: Fixed output when fetching message header or body - doveadm director map/add/remove: Fixed handling IP address as parameter. - dsync: A few more fixes

3 10

[Dovecot] "listen=*, ::" broken?
by Peer Heinlein 05 Aug '10

05 Aug '10

Hi, the default: listen = *, :: should work and should open port 143 on IPv4 and IPv6. In my setup it looks broken: root@mail-archiv:/etc/dovecot# doveconf | grep ^listen listen = *, :: root@mail-archiv:/etc/dovecot# /etc/init.d/dovecot restart Restarting mail server: dovecotError: service(imap-login): listen(::, 143) failed: Address already in use Fatal: Failed to start listeners root@mail-archiv:/etc/dovecot# But it's working with "listen = *": root@mail-archiv:/etc/dovecot# doveconf | grep ^listen listen = * root@mail-archiv:/etc/dovecot# /etc/init.d/dovecot restart Restarting mail server: dovecot. root@mail-archiv:/etc/dovecot# Peer Heinlein -- Heinlein Professional Linux Support GmbH Linux: Akademie - Support - Hosting http://www.heinlein-support.de Tel: 030-405051-42 Fax: 030-405051-19 Zwangsangaben lt. §35a GmbHG: HRB 93818 B / Amtsgericht Berlin-Charlottenburg, Geschäftsführer: Peer Heinlein -- Sitz: Berlin

5 6

[Dovecot] 2.0...
by Ralf Hildebrandt 05 Aug '10

05 Aug '10

Hi I'm running 1.2.13 with sieve & managesieve; no problems whatsoever, but the patching & compilation process is a PITA. So I thought, why not try out 2.0rc4 for a change. But: I don't find sieve & managesieve mentioned there - what do I need to enable those? -- Ralf Hildebrandt Geschäftsbereich IT | Abteilung Netzwerk Charité - Universitätsmedizin Berlin Campus Benjamin Franklin Hindenburgdamm 30 | D-12203 Berlin Tel. +49 30 450 570 155 | Fax: +49 30 450 570 962 ralf.hildebrandt(a)charite.de | http://www.charite.de

3 6

[Dovecot] IMAP IDLE, Virtual mailboxes
by Patrick Nagel 05 Aug '10

05 Aug '10

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi, K-9 Mail (on Android) has been mentioned on this list multiple times recently, I think it's definitely an IMAP client "on the rise". :) It supports IMAP IDLE, and so brings "push mail" to Android mobile phone users. To bring this into the context of this mailing list: I guess a lot of people on this list are making use of server-side filtering (using sieve), so that mails from certain persons or mailing lists end up in the right mailboxes, right on delivery. Now, this is all great, but there are issues when server-side filtering and IMAP IDLE come together: Only one mailbox can be "watched" with one IMAP IDLE connection. So, people who have set up elaborate server-side filtering with say, 50 different sieve "fileinto" calls, will constantly have a *lot* of IMAP IDLE connections open, if they really want to get informed of any mail arriving in any of their mailboxes. Keeping those 50 IMAP connections open wouldn't cost much bandwidth, and who cares about the Internet router's connection tables getting unnecessarily big, anyway? But then there is the "problem" of a mobile phone being carried around constantly, switching physical connections (from WLAN access point 1 to WLAN access point 2 to 3G to 2G to no connection at all and back), every time needing to terminate* those 50 IMAP connections, and then establish 50 new ones (with SSL handshake overhead and all). So, all in all, not an optimal solution. *) (which does not always happen the way it should, see http://code.google.com/p/k9mail/issues/detail?id=1255) I see two ways to improve the situation (one of them quite dovecot-centric): 1) A new extension of the IMAP protocol: IMAP MULTI-IDLE, which somehow allows a client to get notified of changes to more than one mailbox within one IMAP connection. This conflicts with the basic IMAP design though, AFAIK, and is thus not likely to be feasible. 2) Enhancing dovecot's Virtual plugin, so virtual mailboxes do not only get updated on select and expunge, but also when anything changes that affects the set of messages shown in the virtual mailbox. I guess that would have an impact on performance, and thus should be optional. Let me explain the second one: With the help of the Virtual plugin, it is possible to pull all those 50 mailboxes that receive incoming mail together again, just like the INBOX of the pre-server-side-filtering times - the user could configure a virtual mailbox to show all unread mails from those 50 mailboxes. Now the mobile IMAP IDLE users could just watch that one virtual mailbox, needing only one IMAP IDLE connection. After having read the mail (directly in the virtual mailbox), it would disappear, but of course still be in the "real" mailbox, determined by the sieve filter on delivery. Patrick. - -- STAR Software (Shanghai) Co., Ltd. http://www.star-group.net/ Phone: +86 (21) 3462 7688 x 826 Fax: +86 (21) 3462 7779 PGP key E883A005 https://stshacom1.star-china.net/keys/patrick_nagel.asc Fingerprint: E09A D65E 855F B334 E5C3 5386 EF23 20FC E883 A005 -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.12 (GNU/Linux) Comment: Using GnuPG with SUSE - http://enigmail.mozdev.org/ iEYEARECAAYFAku+ydsACgkQ7yMg/OiDoAXV9ACdF+BEstnjfUeJlR/JQKFf6N7n yxYAnAnuD2popWYLfZNCCtlpkAP4SQww =L33A -----END PGP SIGNATURE-----

7 19

[Dovecot] sender address of sieve vacation script
by Wolfgang Burger 05 Aug '10

05 Aug '10

Hi, not entirerly sure wether this is the right place to ask. Sorry if not. I´m running dovecot on a Mac OS X Server (10.6.4). Everything works fine. When I try to enable a vacation message, I get the following error in the log: delays=0/0.01/0.09/0.1, dsn=5.0.0, status=bounced (host XXX[x.x.x.x] said: 553 Mail to <name(a)domain.tld> not allowed; missing domain name in MAIL FROM (in reply to RCPT TO command)) Where host is the mail relay. The logs on the mail relay show matching entries. Sending mails is generally working. I´ve sniffed the network traffic and the FROM Field in the SMTP transfer contains only the following text: <> I´ve allready set the value of myorigin in /private/etc/postfix/ main.cf but to no avail. Can somebody tell me where I can set the sender address of the vacation mail? Or is there something else wrong? Thank you very much. Best regards Wolfgang

3 2

[Dovecot] mobile phone access to dovecot
by casanova99 05 Aug '10

05 Aug '10

I didn't find anything interesting in the search, so I just wanted to see what other people have done (or thought about doing). I'd like to be able to access my dovecot server via IMAP, from the Internet, using the integrated e-mail client from a smart phone. I'm very concerned about security and don't feel comfortable just poking holes into the firewall for direct access from the Internet. Is there a better way to do this? Thanks. -- View this message in context: http://old.nabble.com/mobile-phone-access-to-dovecot-tp29342338p29342338.ht… Sent from the Dovecot mailing list archive at Nabble.com.

3 3

[Dovecot] IMAP access to dovecot list archives?
by Charles Marcus 05 Aug '10

05 Aug '10

Hi Timo, Before I go file a bug for Thunderbird, can you confirm that IMAP access to the dovecot mail list archives should still be working? TB is getting stuck in the account creation screen, and this may be confirmation of a bug they are having trouble isolating in the New Account Wizard. Thanks, -- Best regards, Charles

3 11

[Dovecot] LMTP: Rejecting unknown users
by Peer Heinlein 04 Aug '10

04 Aug '10

Hi! I'm using static results in LDAP-lookups: uris = ldap://127.0.0.1 dn = xxxxxxxxxxxxx dnpass = xxxxxxxxxxxx tls = no ldap_version = 3 base = xxxxxxxxxxxxxxxxx user_attrs = =home=/mail/%d/%n,=uid=10000,=gid=10000,jpberlinMailQuota=quota_rule=*:storage=%$B user_filter = (email=%u) pass_attrs = userPassword=password pass_filter = (email=%u) default_pass_scheme = PLAIN Unfortunately, LMTP accepts mail for *all* users, even for those users, that doesn't exist in LDAP at all: 010-08-04 12:27:58 auth: Debug: Loading modules from directory: /usr/lib/dovecot/modules/auth 2010-08-04 12:27:58 auth: Debug: auth client connected (pid=10049) 2010-08-04 12:27:58 lmtp(10054): Debug: none: root=, index=, control=, inbox= 2010-08-04 12:27:58 auth: Debug: master in: USER 1 tessdfdfgdsft(a)example.org service=lmtp lip=(null) r ip=(null) 2010-08-04 12:27:58 auth: Debug: ldap(tessdfdfgdsft(a)example.org,0.0.0.0): user search: base=xxxxxxxxxxxxxxxxxxx 2010-08-04 12:27:58 auth: Debug: ldap(tessdfdfgdsft(a)example.org,0.0.0.0): no fields returned by the server 2010-08-04 12:27:58 auth: Debug: master out: USER 1 tessdfdfgdsft(a)example.org home=/mail/example.org/tessdfdfgd sft uid=10000 gid=10000 2010-08-04 12:27:58 lmtp(10054): Debug: auth input: tessdfdfgdsft(a)example.org home=/mail/example.org/tessdfdfgdsft uid=10000 gid= 10000 2010-08-04 12:27:58 lmtp(10054, tessdfdfgdsft(a)example.org) Debug: Effective uid=10000, gid=10000, home=/mail/example.org/tessdfd fgdsft 2010-08-04 12:27:58 lmtp(10054, tessdfdfgdsft(a)example.org) Debug: Namespace : type=private, prefix=, sep=/, inbox=yes, hidden=no , list=yes, subscriptions=yes 2010-08-04 12:27:58 lmtp(10054, tessdfdfgdsft(a)example.org) Debug: maildir++: root=/mail/example.org/tessdfdfgdsft/Maildir, index =, control=, inbox=/mail/example.org/tessdfdfgdsft/Maildir 2010-08-04 12:27:58 lmtp(10054, tessdfdfgdsft(a)example.org) Debug: Namespace : type=shared, prefix=shared/%u/, sep=/, inbox=no, h idden=no, list=children, subscriptions=no 2010-08-04 12:27:58 lmtp(10054, tessdfdfgdsft(a)example.org) Debug: shared: root=/var/run/dovecot, index=, control=, inbox= Looks like the "allow_all_users"-Problem from the static database. :-) How can I tell LMTP do reject Mails to users, that doesn't exist in the database/LDAP? It's much better to do this in Dovecot/LMTP then in Postfix-Relay (which can then use LMTP for dynamic address verification). Peer -- Heinlein Professional Linux Support GmbH Linux: Akademie - Support - Hosting http://www.heinlein-support.de Tel: 030-405051-42 Fax: 030-405051-19 Zwangsangaben lt. §35a GmbHG: HRB 93818 B / Amtsgericht Berlin-Charlottenburg, Geschäftsführer: Peer Heinlein -- Sitz: Berlin

4 7

Re: [Dovecot] Shared mailboxes errors
by Nikita Koshikov 04 Aug '10

04 Aug '10

On Tue, 03 Aug 2010 23:16:38 +0200 Leander S. wrote: > Hi Nikita Koshikov, > > when I googled for my SERVERBUG which I'm having right now I found your > configuration. > I'm trying to make use of the antispam plugin as you do. Unfortunately > I'm always getting a [SERVERBUG] error mesage with my MTC when I try > moving mails. The antispam debug.log doesn't really tell a lot of more: > > > ### Dovecot AntiSpam ### > # mail signature (used with any backend requiring a signature) > #antispam_signature = X-Spam-Status > #antispam_signature_missing = move > > antispam_mail_sendmail = /usr/local/bin/sa-learn > antispam_mail_sendmail_args = --username=%u;--debug;all > antispam_mail_spam = --spam > antispam_mail_notspam = --ham > antispam_mail_tmpdir = /tmp > antispam_spam = Spam > antispam_unsure = Virus > antispam_trash = Trash > First of all - what OS is this ? BSD ? And how did you install your spamassassin (ports\compiling from source)? Show your local.cf file (/etc/mail/spamassassin or /usr/local/etc/mail/spamassasin). After reading perldoc Mail::SpamAssassin::Conf add to your local.cf for debugging: bayes_file_mode 0777 bayes_path /tmp/.spamassassin/bayes Create folder /tmp/.spamassassin and set permitions 777. Restart spamd with dovecot and try it. > I also read through the sa-learn script but wasn't able to figure out > where this number 9 is coming from ;/ > ... SIGKILL 9 Term Kill signal - but where from ?! > sa-learn has lots of die() function, this should be enough for raising SIGKILL. > > > Do you maybe have any idea? I tried different Dovecot versions already - > alwys the same ... Might there maybe somethign wrong with my syntax? > > > > Any way - thanks a lot in advance & regards > If you stuck after all, remember that sa-learn has -D key, it generate tons of output. Create wrapper and run sa-learn with -D keyword from dovecot, save result and have fun.

2 1

[Dovecot] Dovecot 1.2.13 intermittent authentication failures
by C. Bensend 04 Aug '10

04 Aug '10

Hey folks, I recently upgraded my mail server from an older OpenBSD -CURRENT snapshot to the latest (Aug 1). As part of this upgrade, I updated all of my packages to their latest versions. Since this upgrade, dovecot has begun failing to authenticate intermittently. I use it primarily for web mail (Squirrelmail 1.4.20) and leave myself logged in during the day. This problem manifests itself by kicking me back to the "Username or password incorrect" screen occasionally (several times an hour) when the page refreshes. I am not using sieve, and while I have the PostgreSQL version of the OpenBSD package installed, I do not currently use it for authentication. I am authenticating against the OpenBSD system. The only error I get in the mail log is: Aug 3 11:00:09 fusion dovecot: imap-login: Aborted login (auth failed, 1 attempts): user=<benny>, method=PLAIN, rip=127.0.0.1, lip=127.0.0.1, secured There are no errors in the Apache error log... Squirrelmail's version wasn't upgraded, so I don't think this is a Squirrelmail problem as far as I can tell. My config is pretty simple: # 1.2.13: /etc/dovecot.conf Warning: fd limit 128 is lower than what Dovecot can use under full load (more than 640). Either grow the limit or change login_max_processes_count and max_mail_processes settings # OS: OpenBSD 4.8 i386 base_dir: /var/dovecot/ listen: *, [::1] ssl_cert_file: /etc/ssl/webmail.crt ssl_key_file: /etc/ssl/private/webmail.key login_dir: /var/dovecot/login login_executable: /usr/local/libexec/dovecot/imap-login login_user: _dovecot mail_location: maildir:~/Maildir mbox_write_locks: fcntl imap_client_workarounds: delay-newmail netscape-eoh tb-extra-mailbox-sep namespace: type: private prefix: INBOX. inbox: yes list: yes subscriptions: yes lda: postmaster_address: postmaster(a)example.com auth default: mechanisms: plain login passdb: driver: bsdauth userdb: driver: passwd socket: type: listen client: path: /var/spool/postfix/private/auth mode: 432 user: _postfix group: _postfix Everything seems to be working just fine (ie, I don't get any other IMAP errors or see any problems), it's just that it will spontaneously fail to authenticate. When this happens, it may take more than one try to get logged back in. I checked with the OpenBSD port's maintainer, and he hadn't heard of any similar issues (and he uses it himself). Can anyone please help? Thank you so much! Benny -- "Something's going on in this house - last night, I saw a face!" "Did it have a nose?" "Yes!" "That sounds like a face all right." -- Scary Movie 4

2 10

[Dovecot] error 89 when loading plugin
by John O'Brien 04 Aug '10

04 Aug '10

Hi, I'm very confused - that's not too difficult for me. I have written a small plugin change_passwd_plugin.c I would like this custom IMAP command to be available to all users. The code contains the following. void change_passwd_plugin_init(void) { command_register("XCHANGEPASSWORD", cmd_xchangepasswd, 0); str_append(capability_string, " XCHANGEPASSWORD"); } void change_passwd_plugin_deinit(void) { command_unregister("XCHANGEPASSWORD"); } % nm 0000000000000920 T change_passwd_plugin_deinit 00000000000008ec T change_passwd_plugin_init 0000000000201248 D change_passwd_plugin_version dovecot.conf mail_plugins = change_passwd_plugin mail_plugin_dir = /usr/lib/dovecot/imap imap_capability = XCHANGEPASSWORD %ls -la /usr/lib/dovecot/imap ls -la /usr/lib/dovecot/imap total 28 drwxr-xr-x 2 root root 4096 Aug 1 16:03 . drwxr-xr-x 3 root root 4096 Aug 1 10:51 .. -rwxr-xr-x 1 root root 16969 Aug 1 16:03 change_passwd_plugin.so During login I see the following /var/log/maillog Aug 1 16:13:00 development dovecot: IMAP(test): Loading modules from directory: /usr/lib/dovecot/imap Aug 1 16:13:00 development dovecot: IMAP(test): Plugin change_passwd_plugin not found from directory /usr/lib/dovecot/imap Aug 1 16:13:00 development dovecot: child 29715 (imap) returned error 89 I don't understand why I'm getting an "error 89" reported. The login session is terminated by dovecot when the error occurs. Any assistance or ideas would be appreciated. Regards, John

4 4

[Dovecot] IMAP/POP3 Proxy Redundancy
by Cory 04 Aug '10

04 Aug '10

Looking over the list archives and Wiki there doesn't seem to be any sort of built-in host redundancy with the proxy. I would prefer to use a built in though it doesn't look like this is possible. One of the suggestions that I found in the list archives was to write a script which checks the health of the hosts and adjusts the MySQL table accordingly. Has anyone done anything like this in production? Thanks, Cory Here is a sample of what I'm testing the proxy with. CREATE TABLE `users` ( `user` varchar(255) NOT NULL, `filesystem` varchar(5) NOT NULL, PRIMARY KEY (`user`), UNIQUE KEY `idx_user` (`user`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 CREATE TABLE `hostmap` ( `id` int(11) NOT NULL auto_increment, `filesystem` varchar(5) NOT NULL COMMENT 'Filesystem identifier', `ip` int(10) unsigned NOT NULL, `alive` tinyint(1) NOT NULL default '1', PRIMARY KEY (`id`), UNIQUE KEY `idx_hostmap` (`filesystem`,`ip`) ) ENGINE=MyISAM AUTO_INCREMENT=103 DEFAULT CHARSET=latin1 password_query = SELECT user,NULL as password, INET_NTOA(hostmap.ip) as host, 'Y' AS proxy_maybe from users left join hostmap on users.filesystem=hostmap.filesystem where hostmap.alive=1 and users.user='%u' limit 1;

2 1

[Dovecot] expire plugin
by Arnaud2 bali 04 Aug '10

04 Aug '10

Hi I try to use expire plugin with mysql When i use my thunderbird client to delete a message, nothing is write in the mysql database. My maildir is look like /home/vmail/homes/arnaud2(a)xxx.xxxx.xxx/ and /etc/dovecot/dovecot-dict-expire.conf : connect = host=localhost user=xxxxxx password=xxxxxxxxx dbname=postfixadmin map { pattern = /home/vmail/homes/$user/$mailbox #shared/expire/$user/$mailbox table = dovecot_expires value_field = expire_stamp fields { username = $user mailbox = $mailbox } } Is pattern ok ? My detail configuration : # dovecot --version 1.2.11 # dovecot -n # 1.2.11: /etc/dovecot/dovecot.conf # OS: Linux 2.6.26-2-amd64 x86_64 Debian 5.0.5 log_timestamp: %Y-%m-%d %H:%M:%S protocols: imap imaps pop3s managesieve 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 login_executable(managesieve): /usr/lib/dovecot/managesieve-login mail_privileged_group: mail mail_location: maildir:/%h 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_executable(managesieve): /usr/lib/dovecot/managesieve mail_plugins(default): quota expire imap_quota autocreate mail_plugins(imap): quota expire imap_quota autocreate mail_plugins(pop3): quota expire autocreate mail_plugins(managesieve): 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 mail_plugin_dir(managesieve): /usr/lib/dovecot/modules/managesieve lda: postmaster_address: xxx(a)xxxxxxxx.xx mail_plugins: quota expire sieve autocreate auth_socket_path: /var/run/dovecot/auth-master auth default: mechanisms: plain login verbose: yes debug: yes debug_passwords: yes passdb: driver: sql args: /etc/dovecot/dovecot-sql.conf userdb: driver: sql args: /etc/dovecot/dovecot-sql.conf 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 plugin: quota: maildir expire: .Trash 1 .Trash/* 1 .Spam 2 expire_dict: proxy::expire sieve: ~/.dovecot.sieve sieve_after: /home/vmail/sieve/default.sieve autocreate: Trash autocreate2: Spam autocreate3: Sent autocreate4: Inbox autocreate5: Drafts autocreate6: Templates autosubscribe: Trash autosubscribe2: Spam autosubscribe3: Sent autosubscribe4: Inbox autosubscribe5: Drafts autosubscribe6: Templates dict: expire: mysql:/etc/dovecot/dovecot-dict-expire.conf # cat /etc/dovecot/dovecot-dict-expire.conf connect = host=localhost user=xxxxxx password=xxxxxxxxx dbname=postfixadmin map { pattern = /home/vmail/homes/$user/$mailbox #shared/expire/$user/$mailbox table = dovecot_expires value_field = expire_stamp fields { username = $user mailbox = $mailbox } } mysql> desc dovecot_expires; +--------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +--------------+--------------+------+-----+---------+-------+ | username | varchar(255) | NO | PRI | NULL | | | mailbox | varchar(255) | NO | PRI | NULL | | | expire_stamp | int(11) | NO | | NULL | | +--------------+--------------+------+-----+---------+-------+ # cat /etc/dovecot/dovecot-sql.conf driver = mysql connect = host=localhost user=xxxxxxx password=xxxxxxx dbname=postfixadmin user_query = SELECT CONCAT('/home/vmail/homes/',maildir) AS home, 65500 AS uid, 65500 AS gid, \ CONCAT('*:bytes=', CAST(quota AS CHAR)) AS quota_rule \ FROM mailbox WHERE username = "%u" AND active=1 password_query = SELECT username as user, password, maildir as userdb_home, 65500 as userdb_uid, 65500 as userdb_gid FROM mailbox WHERE username = '%u' AND active=1 Thank you

2 4