- dovecot - dovecot.org

[Dovecot] Post-logoff script
by Aaron Roberts 07 Jan '10

07 Jan '10

Hi, Is it possible with dovecot to run a script on user logoff event - something like post-login script? What I want to achieve is updating a SQL table with online/offline status. Thanks in advance, Aaron

2 2

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

06 Jan '10

> There wouldn't be any uncommitted statements. The only such statements are > sent inside commit(), the others are SELECTs and such that don't modify > anything. Ok. I made things this way. > Well, that also wastes memory :) I thought I remembered using VARCHAR > pointers about 10 years ago. I think I still have that code around, but I > currently don't have a computer where I could put that hard drive. Maybe in > a few days. No need for this. I found a way to handle VARCHAR pointers. Now all ok. There is always a time to learn =) > Does Oracle handle \ specially? I don't have Oracle installed currently or > access to any installations. No unless an escape clause is specified in SQL-statement. > I'll check the updated patch later. Here is a fixed one.

1 0

[Dovecot] problem with uidlist
by Cor Bosman 06 Jan '10

06 Jan '10

In both 1.2.6 and 1.2.7 (probably also before that, but dont have logs) im seeing quite a few of these: Nov 17 12:45:12 userimap10.xs4all.nl dovecot: IMAP(xxxxxxx): /var/spool/mail/dovecot-control/c/c0/xxxxxxx/INBOX/.INBOX/dovecot-uidlist: Duplicate file entry at line 2650: 1257768394._smtp.mxdrop238.41874,S=17304:2,Sad (uid 34270 -> 37166) I never really looked at it because it doesnt seem to be causing many problems, but i just noticed something that probably hints at the cause.. Nov 17 12:45:12 userimap10.xs4all.nl dovecot: IMAP(xxxxxxx): /var/spool/mail/dovecot-control/c/c0/xxxxxxx/INBOX/.INBOX/dovecot-uidlist: Duplicate file entry at line 2650: 1257768394._smtp.mxdrop238.41874,S=17304:2,Sad (uid 34270 -> 37166) Nov 17 12:45:12 userimap10.xs4all.nl dovecot: IMAP(xxxxxxx): /var/spool/mail/dovecot-control/c/c0/xxxxxxx/INBOX/.INBOX/dovecot-uidlist: Duplicate file entry at line 2651: 1257769385._smtp.mxdrop155.53889,S=305996:2,Sad (uid 34271 -> 37167) Nov 17 12:45:12 userimap10.xs4all.nl dovecot: IMAP(xxxxxxx): /var/spool/mail/dovecot-control/c/c0/xxxxxxx/INBOX/.INBOX/dovecot-uidlist: Duplicate file entry at line 2652: 1257769984._smtp.mxdrop107.23815,S=320781:2,Sabd (uid 34272 -> 37168) Nov 17 12:45:12 userimap10.xs4all.nl dovecot: IMAP(xxxxxxx): /var/spool/mail/dovecot-control/c/c0/xxxxxxx/INBOX/.INBOX/dovecot-uidlist: Duplicate file entry at line 2670: 1257858287._smtp.mxdrop131.43563,S=26827:2,Sad (uid 34311 -> 37186) Nov 17 12:45:12 userimap10.xs4all.nl dovecot: IMAP(xxxxxxx): /var/spool/mail/dovecot-control/c/c0/xxxxxxx/INBOX/.INBOX/dovecot-uidlist: Duplicate file entry at line 2671: 1257858303._smtp.mxdrop238.88513,S=2143:2,Sad (uid 34312 -> 37187) Nov 17 12:45:12 userimap10.xs4all.nl dovecot: IMAP(xxxxxxx): /var/spool/mail/dovecot-control/c/c0/xxxxxxx/INBOX/.INBOX/dovecot-uidlist: Duplicate file entry at line 2672: 1257858868._smtp.mxdrop217.21298,S=8548:2,Sad (uid 34314 -> 37188) Nov 17 12:45:12 userimap7.xs4all.nl dovecot: IMAP(xxxxxxx): /var/spool/mail/dovecot-control/c/c0/xxxxxxx/INBOX/.INBOX/dovecot-uidlist: Duplicate file entry at line 994: 1244800736._smtp.mxdrop237.59318,S=4573:2,Sad (uid 32467 -> 35510) Nov 17 12:45:12 userimap7.xs4all.nl dovecot: IMAP(xxxxxxx): /var/spool/mail/dovecot-control/c/c0/xxxxxxx/INBOX/.INBOX/dovecot-uidlist: Duplicate file entry at line 995: 1244807927._smtp.mxdrop215.53275,S=439887:2,Sad (uid 32468 -> 35511) Nov 17 12:45:12 userimap7.xs4all.nl dovecot: IMAP(xxxxxxx): /var/spool/mail/dovecot-control/c/c0/xxxxxxx/INBOX/.INBOX/dovecot-uidlist: Duplicate file entry at line 996: 1244828590._smtp.mxdrop111.81795,S=3606:2,RSabd (uid 32469 -> 35512) This customer seems to be using our IMAP service from 2 machines at the same time. Possibly a webmail service and a desktop imap client. It may be that both machines are trying to manipulate the uidlist at the same time, causing who knows that kind of corruption. This could maybe explain some of the coredumps im seeing in 1.2.7? This is on Debian/Lenny, using NFS spool and NFS control/indexes. Timo, you asked in private mail a few days ago if we're sure the filenames are forever unique. Im sure. I double checked it in the source code. The above filenames are timestamp_hostname.pid, and that seems pretty unique right? Regards, Cor

3 2

Re: [Dovecot] dovecot-1.2.8 imap crash (with backtrace)
by David Halik 06 Jan '10

06 Jan '10

I found this post from a couple of weeks ago: http://www.mail-archive.com/dovecot@dovecot.org/msg24127.html Any update on this? I'm experiencing the same issue. Out of a user population of 4000, I get about 20 of these dumps a day, so it's not major issue, but I thought I'd follow up. Here is an example: http://pastebin.com/f29c55de5 I can provide a more detailed debug log from teh core dump if necessary, but since the above email already had it I figured I'd wait. Note this is *not* the same issue as: - maildir: v1.2.7 and v1.2.8 caused assert-crashes in maildir_uidlist_records_drop_expunges() I applied those patches to my 1.2.8 installation before 1.2.9 was released and that immediately fixed the expunge crash, but the array_delete bug is still there. dovecot -n --------------- bash-3.2# /usr/sbin/dovecot -n # 1.2.8: /etc/dovecot.conf # OS: Linux 2.6.18-164.6.1.el5 x86_64 CentOS release 5.4 (Final) listen: * ssl_cert_file: /rci/local/certs/imapd-pop3d.pem ssl_key_file: /rci/local/certs/imapd-pop3d.pem disable_plaintext_auth: yes 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 login_max_processes_count: 2048 max_mail_processes: 2048 first_valid_uid: 100 mail_location: maildir:~/Maildir:INDEX=/rci/nqu%h/dovecot:CONTROL=/rci/nqu%h/dovecot mmap_disable: yes mail_nfs_storage: yes mail_nfs_index: yes mail_drop_priv_before_exec: yes mail_executable(default): /rci/local/etc/convert-courier-imap.sh mail_executable(imap): /rci/local/etc/convert-courier-imap.sh mail_executable(pop3): /rci/local/etc/convert-courier-pop.sh mail_plugin_dir(default): /usr/lib64/dovecot/imap mail_plugin_dir(imap): /usr/lib64/dovecot/imap mail_plugin_dir(pop3): /usr/lib64/dovecot/pop3 pop3_uidl_format(default): %08Xu%08Xv pop3_uidl_format(imap): %08Xu%08Xv pop3_uidl_format(pop3): UID%u-%v namespace: type: private separator: . prefix: INBOX. inbox: yes list: yes subscriptions: yes auth default: passdb: driver: pam args: dovecot userdb: driver: passwd -- ================================ David Halik System Administrator OIT-CSS Rutgers University dhalik(a)jla.rutgers.edu ================================

3 22

Re: [Dovecot] Sieve > Pigeonhole > external storage with LDAP or other data source available to dovecot
by Martin F. Foster 06 Jan '10

06 Jan '10

> On 5.1.2010, at 10.02, Martin F. Foster wrote: > > >> I am looking at porting and generalizing an old in-house patch that I'm using for the CMU Sieve plugin. It allows sieve script to test& lookup arguments from LDAP. >> > .. > >> Related work: >> >> 1. Pigeonhole low priority TODO would like to implement alternate >> script storage, eg: LDAP& SQL. I'm not immediately interested in >> alternate types of script storage, but for what I want to acheive, >> I need to sanely access at least an LDAP directory. >> 2. draft-ietf-sieve-external-lists >> (http://tools.ietf.org/html/draft-ietf-sieve-external-lists-01) >> proposes a mechanism to pull mailing list addresses from external >> storage mechanisms such as LDAP, ACAP or relational databases. I'm interested in this, but would like to extend this >> functionality beyond just lists as the example above demonstrates. >> > I haven't looked into that draft or thought much about this, but would doing the lookups via Dovecot's lib-dict be ok? That would of course need a dict-ldap backend implemented, but it would be a generic way to solve this, if its API is good enough. > After another day of looking into this, I believe that there are two concerns to be addressed: 1. dovecot implementation: how dovecot/pigeonhole provides access to these external sources in a sane way. I do like the dict interface for this, which could keep LDAP url's (or SQL queries, etc) out of sieve scripts, and into nicely compartementalized configuration files. Being very ldap focussed at my site, I hadn't looked at dict before today. 2. sieve language: an extension which would allow scripts to get information from an external source. I'm asking the draft-ietf-sieve-external-lists authors a few questions about this. The end result would be something like what follows: Dovecot implementation (proposed): ------------------------------------- <dovecot.conf> dict { dict_sieve = ldap:/etc/dovecot/dovecot-sieve-ldap.conf } plugin { # TODO: proxy this dict? sieve_extsrc = dict } </dovecot.conf> then I'm not sure how you specify multiple hosts with the dict-sql format, so I'm using the postfix convention. there's probably a better way for dovecot. <dovecot-sieve-ldap.conf> map { name = responder_mode server_host = ldap://server1.mycorp.com, ldap://server2.mycorp.com search_base = o=mailstuff query_filter = (&(objectclass=mailschema)(uid=%u)) result_attribute = responder_mode result_scope = sub bind = no version = 3 } map { name = responder_text server_host = ldap://server1.mycorp.com, ldap://server2.mycorp.com search_base = o=mailstuff query_filter = (&(objectclass=mailschema)(uid=%u)) result_attribute = responder_text result_scope = sub bind = no version = 3 } map { name = forward_keep server_host = ldap://server1.mycorp.com, ldap://server2.mycorp.com search_base = o=mailstuff query_filter = (&(objectclass=mailschema)(uid=%u)) result_attribute = mailForwardKeep result_scope = sub bind = no version = 3 } map { # in this case we can have many responses name = forward_addresses server_host = ldap://server1.mycorp.com, ldap://server2.mycorp.com search_base = o=mailstuff query_filter = (&(objectclass=mailschema)(uid=%u)) result_attribute = mailForwardAddress result_scope = sub bind = no version = 3 } </dovecot-sieve-ldap.conf> Sieve language: --------------------- then with proposed new functions of the sieve language (all names plucked out of my head 2hrs ago, would have to think about the semantics some more): 1. a “:list” argument that expects a string-list 2. a “:extsrc” argument that expects an <ext-name: string> and returns a string-list 3. a “:extsrc1” argument that expects an <ext-name: string> and returns a string 4. a new test that uses information that is not in the message, say “arbitrary [comparator] string string” (syntax needs work) sample uses in scripts are then: 1. redirect to a mailing list sourced from ldap (or wheverver): # mailForwardAddress attribute can be present >=0 times redirect :list :extsrc “dict:forward_addresses” 2. decide whether to keep or discard forwarded messages (eg: after the above rule) # mailForwardKeep attribute should only be present once, if at all if arbitrary :is :extsrc1 “dict:forward_keep” “TRUE” { keep; } 3. decide vacation action and text based in information in an ldap dir: # mailResponderMode & mailResponderText attrs should only be present once, if at all if arbitrary :is :extsrc1 “dict:responder_mode” “alwaysreply” { vacation :days 1 :extsrc1 “dict:responder_text"; } if arbitrary :is :extsrc1 “dict:responder_mode” “holiday” { vacation :days 30 :extsrc1 “dict:responder_text”; } ... where the "dict:mapname" syntax would be dovecot implementation specific. could also support the URL & TAG-URI schemes as proposed by draft-ietf-sieve-external-lists. This would allow query URLs as a more general case, using whatever's configured in /etc/ldap/ldap.conf (or whatever the platform's ldap client lib uses). Doing this does raise some resource consumption concerns, hence there should probably be a means of restricting external queries to global scripts only (or sieve_before, sieve_after), and a means of providing timeout values, etc. eg: if arbitrary :is :extsrc1 “ldap:///o=myorg?mailForwardKeep” “TRUE” { keep; } I'll keep on thinking about the design, staring intently at the dovecot sources and http://wiki.dovecot.org/Design for another couple days before attempting to write some code to test this. Feedback on the design of both the sieve language extension, & dovecot interface very appreciated. Cheers, -Martin Foster

1 0

[Dovecot] Failed IMAP Login Attempts in Logs
by Carlos Williams 06 Jan '10

06 Jan '10

I had a user telling me that they can't login to the Postfix email server via Webmail (RoundCube) and I decided to see if I could locate this issue in the logs and understand if the user was simply using a wrong password credential and or something more serious. More than likely the person is just using a wrong password but in search of this on my logs, I don't understand why Dovecot doesn't log failed login attempts. When I attempted to login with a wrong password, I show the following in my logs: [root@mail log]# cat /var/log/maillog | grep 'Jan 5' | grep -i 'dovecot' | grep -i 'carlos' Jan 5 11:00:13 mail dovecot: imap-login: Disconnected: user=<carlos>, method=PLAIN, rip=::ffff:192.168.0.10, lip=::ffff:192.168.0.10 Is there a log level or something I am not searching for that will allow me to see failed or invalid logins for Dovecot (IMAP)? Thanks!

3 2

[Dovecot] Sorting in IMAP list command?
by Ronald Johnson 06 Jan '10

06 Jan '10

Hi All, I'm running Dovecot 1.2.9 and have noticed the IMAP list command does not appear to send a sorted list of folders with list command. For example on our Cyrus server I get a sorted list of folders (with INBOX listed first): 2 list "" "*" * LIST (\Noinferiors) "/" "INBOX" * LIST (\HasNoChildren) "/" "CalProject" * LIST (\HasNoChildren) "/" "Deleted Messages" * LIST (\HasNoChildren) "/" "Drafts" ... while on our Dovecot server I get seemingly random listing: 2 list "" "*" * LIST (\HasNoChildren) "/" "lsf" * LIST (\HasNoChildren) "/" "mrg" * LIST (\HasNoChildren) "/" "studiosysadmins" * LIST (\HasNoChildren) "/" "Deleted Messages" * LIST (\HasNoChildren) "/" "TriTeam" * LIST (\HasNoChildren) "/" "systemupdates" * LIST (\HasNoChildren) "/" "bb" * LIST (\HasNoChildren) "/" "nagios" * LIST (\HasNoChildren) "/" "server" ... Is this intentional, or have I done something wrong? I didn't see any option in the dovecot.conf to set the behavior of the list output. Here is `dovecot -n`: # 1.2.9: /usr/local/etc/dovecot.conf # OS: Linux 2.6.18-164.6.1.el5 x86_64 Red Hat Enterprise Linux Server release 5.4 (Tikanga) nfs protocols: imap imaps managesieve ssl_cert_file: /etc/pki/dovecot/certs/dovecot.pem ssl_key_file: /etc/pki/dovecot/private/dovecot.pem disable_plaintext_auth: no login_dir: /usr/local/var/run/dovecot/login login_executable(default): /usr/local/libexec/dovecot/imap-login login_executable(imap): /usr/local/libexec/dovecot/imap-login login_executable(managesieve): /usr/local/libexec/dovecot/managesieve-login mail_access_groups: BOLT mail_location: maildir:/var/dovecot/imap/%u/Maildir mmap_disable: yes mail_nfs_storage: yes mail_nfs_index: yes mail_executable(default): /usr/local/libexec/dovecot/imap mail_executable(imap): /usr/local/libexec/dovecot/imap mail_executable(managesieve): /usr/local/libexec/dovecot/managesieve mail_plugins(default): acl imap_acl autocreate mail_plugins(imap): acl imap_acl autocreate mail_plugins(managesieve): mail_plugin_dir(default): /usr/local/lib/dovecot/imap mail_plugin_dir(imap): /usr/local/lib/dovecot/imap mail_plugin_dir(managesieve): /usr/local/lib/dovecot/managesieve namespace: type: private separator: / inbox: yes list: yes subscriptions: yes namespace: type: public separator: / prefix: Public/ location: maildir:/var/dovecot/imap/public:CONTROL=/var/dovecot/imap/%u/Maildir/public:INDEX=/var/dovecot/imap/%u/Maildir/public list: yes namespace: type: public separator: / prefix: Boltlogs/ location: maildir:/var/dovecot/imap/boltlogs/Maildir/:CONTROL=/var/dovecot/imap/%u/Maildir/public-boltlogs:INDEX=/var/dovecot/imap/%u/Maildir/public-boltlogs list: yes lda: postmaster_address: postmaster(a)example.com mail_plugins: sieve acl mail_plugin_dir: /usr/local/lib/dovecot/lda/ auth default: passdb: driver: pam userdb: driver: passwd plugin: acl: vfile sieve: /var/dovecot/imap/%u/home/.dovecot.sieve sieve_dir: /var/dovecot/imap/%u/home/sieve home: /var/dovecot/imap/%u/home autocreate: Trash autosubscribe: Trash Cheers, Ron

3 3

[Dovecot] Dovecot quota not working
by Bruno Guimarães Sousa 05 Jan '10

05 Jan '10

Hi everyone, I'm trying to make quota to work in dovecot 1.0.rc15 in a Debian machine. Setting the limit to 1GB and starting to fill up the mailbox and nothing stopped me. It just kept growing and nothing happened. Restarted the service and nothing. I had already exceeded the 1 GB limit and nothing happens, the mailbox still goes bigger and bigger... The *"check_quota"* plugin for squirrelmail shows "0.0% of 1.0GB" in my browser. 1GB is exactly what it is defined in dovecot.conf by maildir. Is it necessary to configure something in postfix? Details: # dovecot --version 1.0.rc15 # dovecot -n # /etc/dovecot/dovecot.conf IEffective uid=65534, gid=65534 ILoading modules from directory: /usr/lib/dovecot/modules/imap IModule loaded: /usr/lib/dovecot/modules/imap/lib01_quota_plugin.so IModule loaded: /usr/lib/dovecot/modules/imap/lib02_imap_quota_plugin.so log_timestamp: %Y-%m-%d %H:%M:%S protocols: imap pop3 ssl_disable: yes 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 first_valid_uid: 0 first_valid_gid: 0 mail_privileged_group: users mail_location: mbox:/home/%u:INBOX=/var/mail/%u mail_debug: yes mmap_disable: yes mbox_read_locks: flock mbox_write_locks: flock 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 mail_plugins(imap): quota imap_quota mail_plugins(pop3): quota 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 pop3_uidl_format(default): pop3_uidl_format(imap): pop3_uidl_format(pop3): %08Xu%08Xv auth default: passdb: driver: pam userdb: driver: passwd regards, -- Bruno Guimarães Sousa www.ifba.edu.br PONTONET - DGTI - IFBA Ciência da Computação UFBA Registered Linux user #465914

3 3

[Dovecot] Managesieve and Dovecot from ATRPM - Still no luck
by Oli Schacher 05 Jan '10

05 Jan '10

Hi list I'm still trying to get managesieve running on centos x64 with the packages from atrpm. I used the 1.2.9 rpms (also rebuilt with the lastet managesieve patches) but I'm always getting the same error when trying to compile managesieve: ./configure --with-dovecot=/usr/lib64/dovecot/ --with-dovecot-sieve=/work/dovecot-1.2-sieve-0.1.14 (no errors) make gcc -DHAVE_CONFIG_H -I. -I../.. -I/usr/include/dovecot -I/usr/include/dovecot/src/lib -I/usr/include/dovecot/src/lib-dict -I/usr/include/dovecot/src/lib-mail -I/usr/include/dovecot/src/lib-auth -I/usr/include/dovecot/src/lib-index -I/usr/include/dovecot/src/lib-storage -DMODULEDIR=\""/usr/lib64/dovecot"\" -I../../src/lib-managesieve -I../../src/lib-sievestorage -I/work/dovecot-1.2-sieve-0.1.14 -I/work/dovecot-1.2-sieve-0.1.14/src/lib-sieve -std=gnu99 -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector --param=ssp-buffer-size=4 -m64 -mtune=generic -Wall -W -Wmissing-prototypes -Wmissing-declarations -Wpointer-arith -Wchar-subscripts -Wformat=2 -Wbad-function-cast -Wstrict-aliasing=2 -I/usr/kerberos/include -MT main.o -MD -MP -MF .deps/main.Tpo -c -o main.o main.c mv -f .deps/main.Tpo .deps/main.Po make[3]: *** No rule to make target `/usr/include/dovecot/src/lib-storage/libstorage.a', needed by `managesieve'. Stop. make[3]: Leaving directory `/work/dovecot-1.2-managesieve-0.11.10/src/managesieve' make[2]: *** [all-recursive] Error 1 make[2]: Leaving directory `/work/dovecot-1.2-managesieve-0.11.10/src' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/work/dovecot-1.2-managesieve-0.11.10' make: *** [all] Error 2 I probably need a hit with the cluebat here... could someone give me step-by-step instructions or is it a bad idea to use those rpms in the first place or...? Thanks and happy new year! Oli

4 4

[Dovecot] fedora rpm for 2.0 beta?
by joakim＠verona.se 05 Jan '10

05 Jan '10

I'm looking for a spec/rpm file suitable for fedora 11/12, for dovecot and pidgenhole sieve. Has anyone done this yet? Otherwise I will attempt to the dovecot 1.2 spec files for f11. -- Joakim Verona

1 1