- dovecot - dovecot.org

[Dovecot] SQL passdb lookups not working
by Benjamin Montgomery 14 Aug '11

14 Aug '11

Hello everyone, I'm trying to make dovecot do user authentication against a SQL database. The passwords (managed by Django) are stored as salted SHA1 encoded in hex. I monkey patched Django's password method so that the password hash is made with <password><salt> (Django does <salt><password>, the patched method was verified to return same value as dovecotpw) and the passwords are stored in the database separately as the salted hash and the salt. When I query the values out of the database, I'm using MySQL's concat function to return the password as {SSHA.hex}<sha1 hash><salt>. Dovecot is not able to verify any passwords right now. I've scoured the wiki and I think my setup is correct...config info is below. Any advice on where to look for debugging or setup of my passwords would be appreciated! Ben dovecot-sql.conf: default_pass_scheme = SSHA.hex password_query = \ SELECT emailmanager_emailaddresses.account AS username, \ emailmanager_domain.name AS domain, \ CONCAT('{SSHA.hex}', \ emailmanager_userprofile.shadigest, \ emailmanager_userprofile.salt \ ) AS password \ FROM emailmanager_emailaddresses \ JOIN emailmanager_domain ON emailmanager_emailaddresses.id = emailmanager_domain.id \ JOIN emailmanager_userprofile ON emailmanager_emailaddresses.id = emailmanager_userprofile.id \ WHERE emailmanager_emailaddresses.account = '%n' \ AND emailmanager_domain.name = '%d'

1 1

[Dovecot] Clients can't retrieve new emails
by Jeff Van Epps 12 Aug '11

12 Aug '11

In a formerly working environment suddenly clients aren't notified of new emails and can't retrieve new emails. Server is Ubuntu 11.04 dovecot 1.2.15. Clients which fail are a Pre2 webOS 2.1 and TouchPad webOS 3.0 (those are OS versions, I don't know which particular flavor/version the IMAP clients are); there is also a Thunderbird 3.1.11 client on the same system as the server which works properly. The clients never report an error. I got as far as configuring rawlog: in: ~A2 NAMESPACE ~A3 SELECT "INBOX" ~A4 LIST "" * ~A5 UID STORE 0 +FLAGS.SILENT (\Seen) ~A6 UID STORE 0 +FLAGS.SILENT (\Seen) out: * OK [RAWLOG TIMESTAMP] 2011-08-01 08:28:33 ~A1 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 LIST-STATUS] Logged in * NAMESPACE (("" "/")) NIL NIL ~A2 OK Namespace completed. * FLAGS (\Answered \Flagged \Deleted \Seen \Draft NonJunk Junk) * OK [PERMANENTFLAGS (\Answered \Flagged \Deleted \Seen \Draft NonJunk Junk \*)] Flags permitted. * 101 EXISTS * 0 RECENT * OK [UNSEEN 63] First unseen. * OK [UIDVALIDITY 1222650706] UIDs valid * OK [UIDNEXT 863] Predicted next UID * OK [HIGHESTMODSEQ 1903] Highest ~A3 OK [READ-WRITE] Select completed. * LIST (\NoInferiors \UnMarked) "/" "Trash" * LIST (\NoInferiors \UnMarked) "/" "Sent" * LIST (\NoInferiors \UnMarked) "/" "INBOX" ~A4 OK List completed. ~A5 BAD Error in IMAP command UID STORE: Invalid uidset ~A6 BAD Error in IMAP command UID STORE: Invalid uidset I've searched and read messages saying that there is no such thing as UID 0. Okay. Why are the clients suddenly trying to use it? Why doesn't the server just ignore it? (it seems like it may be terminating the connection) What can I do about it? (I'll nag HP about the client side but I don't expect quick action. The server on the other hand is in my house.) dovecot -n output: # 1.2.15: /etc/dovecot/dovecot.conf # OS: Linux 2.6.38-11-generic i686 Ubuntu 11.04 log_timestamp: %Y-%m-%d %H:%M:%S ssl_cert_file: /etc/ssl/certs/lordbah.com.crt ssl_key_file: /etc/ssl/private/lordbah.com.key ssl_key_password: --redacted-- disable_plaintext_auth: no verbose_ssl: yes login_dir: /var/run/dovecot/login login_executable: /usr/lib/dovecot/imap-login login_process_per_connection: no login_processes_count: 5 login_max_processes_count: 20 verbose_proctitle: yes mail_privileged_group: mail mail_location: mbox:~*/mail:INBOX=/var/mail/*%u mail_debug: yes mbox_write_locks: fcntl dotlock mail_executable: /usr/lib/dovecot/rawlog /usr/lib/dovecot/imap imap_client_workarounds: tb-extra-mailbox-sep auth default: verbose: yes debug: yes passdb: driver: pam userdb: driver: passwd -- Jeff Van Epps

3 5

Re: [Dovecot] Unknown setting: service
by Patrick Westenberg 12 Aug '11

12 Aug '11

On Thu, 11 Aug 2011 17:23:38 -0400, Patrick Domack <patrickdk(a)patrickdk.com> wrote: > Ya, would have to be one of the namespace }'s is missing, as they are > right before mail_uid/gid I really missed to uncomment the namespace ending curly bracket even though I triple checked this file. Thank you guys.

1 0

[Dovecot] commercial use
by New Coder 12 Aug '11

12 Aug '11

I was wondering if it was possible to use Dovecot as part of a commercial solution. For example, I mean charging for an email service which uses Dovecot.Thanks.

2 1

[Dovecot] Unknown setting: service
by Patrick Westenberg 12 Aug '11

12 Aug '11

Hi guys, I setup a new box with Debian Squeeze 64bit and installed dovecot from the sources. However, I can't start dovecot or even use doveconf: root@imap01:~# doveconf -n # 2.0.13: /usr/local/etc/dovecot/dovecot.conf doveconf: Fatal: Error in configuration file /usr/local/etc/dovecot/conf.d/10-mail.conf line 111: Unknown setting: mail_uid Why is mail_uid and mail_gid an unknown setting? On my other box the configuration is identical (but Dovecot is upgraded from early 2.0.x versions to the current one) If I comment the mail_uid and mail_gid lines, I get another error: root@imap01:~# doveconf -n doveconf: Fatal: Error in configuration file /usr/local/etc/dovecot/conf.d/10-master.conf line 17: Unknown setting: service doveconf: Error: managesieve-login: dump-capability process returned 89 doveconf: Fatal: Error in configuration file /usr/local/etc/dovecot/conf.d/10-master.conf line 17: Unknown setting: service Everything I could find on Google are problems after upgrading from 1.x to 2.x What went wrong? Regards Patrick

3 2

[Dovecot] Thunderbird Will Not Download Email Until Computer Is Rebooted
by Jay Welch 11 Aug '11

11 Aug '11

Hey Guys, Have any of you seen an issue with Thunderbird in which the computer has to be rebooted for email to be downloaded? I have been looking over the InterWebs and I cannot find anything. I can see new email on the server as well. Where would be a good place to start for troubleshooting this issue? Thanks

3 2

Re: [Dovecot] How to make dovecot-lda/deliver mark a message as seen
by Stefan Piegsa 10 Aug '11

10 Aug '11

On 08/08/2011 11:46 AM, Andrzej Adam Filip wrote: > On 08/08/2011 09:43 AM, Stefan Piegsa wrote: >> Thanks for your reply! >> >> On 08/08/2011 08:36 AM, Andrzej Adam Filip wrote: >>> Have you considered using sieve for the task? >>> [Using imap4flags extension] >> Yes, but I think it's not the optimal solution for what I want to do: >> >> Basically, I don't want emails to be sent first to the MTA and then >> again to dovecot to be stored in "Sent Messages". >> So I made a script that puts an email received from the MTA by an >> authenticated user into his local Maildir/Sent folder, using: >> dovecot-lda -d $user -m Sent. Such emails should be marked as seen. >> >> Sieve would be an option if it were possible to have a global sieve >> script that is always executed, not only when there's no user script. >> >> Best Regards, >> Stefan >> > Could not you use sieve_before? > http://wiki.dovecot.org/LDA/Sieve > > You may consider using sieve_after if you want to allow users to > overwrite your choice of "self copy" handling. > sieve_after sounds interesting! Is there a way to match the destination mailbox in a sieve script? The email comes in by dovecot-lda -d $user -m Sent Now the sieve script should somehow match the mailbox "Sent".

1 1

[Dovecot] mbox problems on CentOS 6
by DT 10 Aug '11

10 Aug '11

Hello, I migrated yesterday to Dovecot 2, and I managed to "convert" all the settings I had in dovecot.conf, but I run into a strange problem. I am curently using Dovecot 2.0.13 and bellow is my dovecot.conf current content: # 2.0.13: //etc/dovecot/dovecot.conf # OS: Linux 2.6.32-71.29.1.el6.x86_64 x86_64 CentOS Linux release 6.0 (Final) ext4 auth_mechanisms = plain login auth_verbose = yes base_dir = /var/run/dovecot/ disable_plaintext_auth = no first_valid_uid = 901 last_valid_uid = 901 log_path = /var/log/dovecot.log log_timestamp = "%Y-%m-%d %H:%M:%S " login_greeting = IMAP/POP3 server ready. mail_access_groups = mail mail_debug = yes mail_location = mbox:/vmail/%d/%n:INDEX=/var/indexes/%u mail_max_userip_connections = 16 mail_privileged_group = mail passdb { args = /etc/dovecot/dovecot-mysql.conf driver = sql } protocols = imap pop3 service auth { unix_listener auth-userdb { mode = 0600 } user = $default_internal_user } service imap-login { inet_listener imap { port = 143 } } service imap { process_limit = 16 } service pop3-login { inet_listener pop3 { port = 110 } } service pop3 { process_limit = 16 } ssl = no userdb { args = /etc/dovecot/dovecot-mysql.conf driver = sql } protocol pop3 { pop3_client_workarounds = outlook-no-nuls oe-ns-eoh pop3_uidl_format = %08Xu%08Xv } protocol imap { imap_client_workarounds = delay-newmail tb-extra-mailbox-sep } I am running along with Dovecot, Postfix and MySQL - oh SASL is of course installed as I want to make use of user auth. On the simplest check - "surprise" ta-daaaa /telnet localhost 143 Trying ::1... Connected to localhost. Escape character is '^]'. * OK [CAPABILITY IMAP4rev1 LITERAL+ SASL-IR LOGIN-REFERRALS ID ENABLE IDLE AUTH=PLAIN AUTH=LOGIN] IMAP/POP3 server ready. a login contact(a)mydomain.com mypassword * BYE Internal error occurred. Refer to server log for more information. Connection closed by foreign host. I activated debug and looked in the dovecot logs and here is the most intriguing part I found: auth: Info: mysql(localhost): Connected to database postfix imap-login: Info: Login: user=<contact(a)mydomain.com>, method=PLAIN, rip=::1, lip=::1, mpid=5821, secured imap: Debug: Added userdb setting: mail=maildir:/vmail/mydomain.com/contact imap: Debug: Added userdb setting: plugin/quota=dirsize:storage=0 imap(contact(a)mydomain.com): Debug: Effective uid=901, gid=12, home=/vmail/mydomain.com/contact imap(contact(a)mydomain.com): Error: user contact(a)mydomain.com: Initialization failed: Initializing mail storage from mail_location setting failed: Unknown mail storage driver maildir imap(contact(a)mydomain.com): Error: Invalid user settings. Refer to server log for more information. I double checked paths - all is ok - postfix is actually receiving and saving in that /vmail... folder # uid=901 coresponds to <vmail> user # gid=12 corresponds to <mail> group # rights on /vmail are vmail.mail I think there is actually a problem with mail_location - but I couldnt solve it at all. If anyone can help me with this - please do guys. I googled those terms and found nothing, so this is my last resort, I tried solving this in the last 36hrs but nothing so far. Thanks to anyone who can assist me.

3 8

[Dovecot] How do I change the date format displayed on webmail?
by huntson 10 Aug '11

10 Aug '11

I am running Dovecot on OS X Lion and the webmail displays the date in a European style format - day of the month and then month number. How can I reverse this? -- View this message in context: http://old.nabble.com/How-do-I-change-the-date-format-displayed-on-webmail-… Sent from the Dovecot mailing list archive at Nabble.com.

3 2

[Dovecot] Dovecot quota dict
by Juan Bernhard 10 Aug '11

10 Aug '11

Hi, Im using dovecot with maildir++ quota and I have this problem, maybe some of you already solve this and can helpme. I want to use some flat file to tell exim and dovecot the quota limit for each user, i tried to work with exim and maildirsize file, but exim just ignores the limits there. I need a way (a really simple one, i dont want to create a database or an ldap server just for this) to tell exim and dovecot to lookup some file to get the quota limits. I know how to doit with exim, now i need to know how to tell dovecot to read the quota limits from this file. I know that dovecot can read the quota limit from the userdb, but im using pam and i dont want to change the entire auth schema. Can I configure dovecot to get the quota limit from a file using pam as userdb? Thanks, Juan. pd: here is my doveconf -n # 2.0.13: /usr/local/etc/dovecot/dovecot.conf # OS: Linux 2.6.18-238.9.1.el5 x86_64 CentOS release 5.6 (Final) ext3 auth_cache_size = 10 M auth_debug = yes auth_verbose = yes base_dir = /var/run/dovecot/ default_client_limit = 5000 default_process_limit = 1000 disable_plaintext_auth = no listen = * login_greeting = Server ready. mail_debug = yes mail_location = maildir:/var/mail/%u:INDEX=~/ mail_plugins = quota maildir_very_dirty_syncs = yes passdb { args = failure_show_msg=yes %s driver = pam } plugin { mail_log_events = delete undelete expunge copy mailbox_delete mailbox_rename mail_log_fields = uid box msgid size subject quota = maildir:Cuota de correo quota_rule = *:storage=1G quota_rule2 = Trash:storage=+100M } protocols = imap pop3 service auth { client_limit = 12000 } service imap { process_limit = 5000 } service pop3 { process_limit = 5000 } ssl = no ssl_cert = </etc/ssl/certs/dovecot.pem ssl_key = </etc/ssl/private/dovecot.pem userdb { driver = passwd } protocol imap { imap_client_workarounds = tb-extra-mailbox-sep tb-lsub-flags mail_plugins = quota imap_quota } protocol pop3 { pop3_client_workarounds = outlook-no-nuls oe-ns-eoh pop3_lock_session = yes pop3_uidl_format = %08Xv%08Xu }

2 4