December 2010 - dovecot

[Dovecot] Migrate from Maildir to mdbox
by Odhiambo Washington 28 Dec '10

28 Dec '10

Looking at http://wiki2.dovecot.org/Migration/MailFormat, I do not see much on how to do a migration from Maildir to mdbox. That page isn't quite updated it looks. I have several domains (virtual) with the following storage layout: /var/spool/virtual/$domain. So the users have their mail stored as follows: /var/spool/virtual/domain1/$user/Maildir /var/spool/virtual/domain2/$user/Maildir /var/spool/virtual/domain3/$user/Maildir /var/spool/virtual/domainN/$user/Maildir >From the wiki, I am told the steps to take are: 1. Set mail_location=mdbox:~/mdbox 2. Run "doveadm mirror -u username maildir:~/Maildir" The instruction above confuses me because in my situation, I don't have a "username" per se. dovecot-deliver knows how to figure out my usernames and their mail_location settings. How do I derive my "username" when users are virtual, stored in MySQL back end? Again, the right command seems to rely on dsync, not "doveadm mirror". I could manually get all the values for the users for each domain and run: dysnc -u $u -o "mail_location=maildir:/var/spool/virtual/domain1/$u/Maildir" mirror "mdbox:/var/spool/virtual/domain1/$u/mdbox" This is so manual, especially because I have to (if I remember well) create /var/spool/virtual/domain1/$u/mdbox (and have the permissions right) before running dysnc. Is there an easier way out, perhaps?? -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254733744121/+254722743223 _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ Damn!!

5 11

[Dovecot] Postfix - deliver problem.
by Mark Bronstein 28 Dec '10

28 Dec '10

I really could use some help. I have been using dovecot and qmail on Debian for years with no problems. I just replaced qmail with Postfix and have not been able to get messages to dovecot via deliver. I have tried to set it up as a virtual mailbox only "no lookup necessary" system following the vaious help pages. I am using just a single user vmail:mail to execute postfix and deliver. My Dovecot.conf is: ----------------------- # 1.2.16: /etc/dovecot/dovecot.conf # OS: Linux 2.6.18-194.17.1.el5.028stab070.7 i686 Debian 5.0.7 simfs log_path: /var/log/dovecot/dovecot.log info_log_path: /var/log/dovecot/dovecot_info.log log_timestamp: %Y-%m-%d %H:%M:%S protocols: imap pop3 imaps pop3s disable_plaintext_auth: no verbose_ssl: yes 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: 112 last_valid_uid: 112 first_valid_gid: 8 last_valid_gid: 8 mail_location: maildir:/var/mail/domains/%d/%n/Maildir mail_debug: yes mail_full_filesystem_access: yes 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_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 lda: postmaster_address: mark(a)bronsteinlaw.com mail_plugins: sieve log_path: /var/log/dovecot/dovecot-local-deliver.log auth_socket_path: var/run/dovecot/auth-master auth default: user: vmail verbose: yes debug: yes debug_passwords: yes passdb: driver: passwd-file args: /etc/dovecot/passwd userdb: driver: static args: uid=vmail gid=mail home=/var/mail/domains/%d/%n allow_all_users=yes socket: type: connect master: path: /var/run/dovecot/auth-master mode: 384 user: vmail group: mail plugin: sieve_global_dir: /etc/dovecot/sieve/global/ -------------------------------- I have the dovecot deliver line in postfix's master.cf according to the docs: --------------- dovecot unix - n n - - pipe flags=DRhu user=vmail argv=/usr/lib/dovecot/deliver -f ${sender} -d ${recipient} ------------------ Incoming emails are being saved to the Postfix queue but then delivery is unsuccessful with an error message of: 2010-12-26 23:11:09 deliver(mark(a)bronsteinlaw.com): Error: userdb lookup: connect(var/run/dovecot/auth-master) failed: No such file or directory Any help would be appreciated. Thanks, Mark B

6 6

[Dovecot] Kicking by dovecot as proxy?
by Antonio Perez-Aranda 27 Dec '10

27 Dec '10

I'm using dovecot 2.0 as proxy to make easy the migration from Courier to Dovecot. ¿Is it possible to use doveadm kick on a proxy connection? Example: telnet (login as user1) -> dovecot (proxy) (user1) -> courier (user1) If I exec doveadm who on "dovecot", any user are connected. -- Antonio Pérez-Aranda Alcaide aperezaranda(a)yaco.es Yaco Sistemas S.L. http://www.yaco.es/ C/ Rioja 5, 41001 Sevilla Teléfono +34 954 50 00 57 Fax +34 954 50 09 29

2 2

[Dovecot] Status update
by Timo Sirainen 27 Dec '10

27 Dec '10

Just in case you're wondering: I should hopefully soon get back to answering all the pending mails and start coding. I moved back to Finland a week ago. I should get my proper internet connection on Wednesday, although this 3.5G isn't too bad either. I couldn't get my old Mac Mini to work properly anymore so I went and bought a new machine. Dovecot recompiles in 43 seconds now. :)

1 0

[Dovecot] passwd, gid and uid
by Mauricio Tavares 25 Dec '10

25 Dec '10

I forgot the answer for this: in http://wiki.dovecot.org/AuthDatabase/PasswdFile, we have the passwd file defined as user:password:uid:gid:(gecos):home:(shell):extra_fields What should the uid and gid be associated with? In my setup I told postfix to use Dovecot LDA's deliver, which then is saving files as uid:gid of 1500:1500. How would that affect the uid:gid used in the passwd file? From what I read in the dovecot's wiki, you want them *not* to be anything that has the rights to access the emails. So, does that mean any value for them will do?

2 1

[Dovecot] Maildir feature I'd like to see - SSD for newer messages
by Marc Perkel 24 Dec '10

24 Dec '10

SSD drives are very fast but expensive. So I have a crude idea that I'd like to see. May not be practical but would like to get some thoughts on it. Some new SSDs use SATA 3 (6gb/sec) with 355/mb/sec read speeds and 215MB/sec write. Put these in raid 0 and it screams! Can you imagine how fast that would be? What would be nice is if new email were on faster drives with old email being migrated to larger mechanical cheaper storage. Perhaps messages over a month old? From dovecot's perspective it would sort of all look the same but maybe one a week a script would run migrating older messages to slower media. It would also make backups easier. The faster newer messages could be archived hourly. On the weekend after the archiving script was run the older message could be backed up once a week. I'm not sure what it would take to make dovecot seamlessly access email from two different locations or if this is practical. Just wanted to throw the idea out there to see if something sticks.

6 7

[Dovecot] Is this an index problem?
by Chris Barnes 23 Dec '10

23 Dec '10

This is my first post to this list/gmane newsgroup, so please be gentle with me.... :-) Here's my situation: I have a user (the "main boss secretary") who uses MS Outlook 2007 as her email client. She has over 46,000 messages in her inbox, with nobody knows how many more in 75+ different folders & subfolders. Surprisingly, her response time wasn't too terrible up until we had to reboot our mail server the other day (actually, restoring the entire server from a backup). Now it takes anywhere from 10 to 60 seconds for her to switch from 1 folder to another. Details: * Server is Debian running Postfix and Dovecot (both the current release). Using Maildir format stored in the user's ~/Maildir folder. * User connects to server via Imaps. Connection is local using gigabit network (ie. it ain't the network). * Yes, we did all the things on the Outlook side -thinking that is where the problem lays. Rebuild the .pst file, had Outlook re-index, compacted the .pst file, etc. So now I'm thinking that maybe I need to just wipe out all of the ~/Mailder/dovecot* files (including all those in sub-directories) and let it all reindex. Which begets 3 questions: (1) will this help? (2) anyone have a shell script that will remove all those dovecot* files from the user's directory AND all the sub-directories? (3) Any other suggestions I might be missing? -- Chris Barnes

1 1

[Dovecot] Deliver limit based of number of destination recipients and size of mails, any option to do that?
by Andrés Yacopino 23 Dec '10

23 Dec '10

I have a mail server with postfix, dovecot (1.2.15) and deliver lda (dovecot) with 350 users. I have the problem that in this christmas the employees are sending some big files (mainly powerpoints files) to a lot of recipients, because of that the server get a lot of charge (is a Xeon quad core 5405 with 4GB of Ram), i have four disks in Raid 5 configuration (HP E200 controller, not very fast) Is there any option to limit this type of delivery, the total size of the mails delivered to each user (total recipients * size of mail), in dovecot deliver. I don't want to limit the concurrent delivery more lower than 350 recipients and the max size of the mail we can send is 15M. Thanks a lot, -- Andrés Fernando Yacopino

2 1

[Dovecot] trying to make cmusieve happen globally
by Phil Howard 22 Dec '10

22 Dec '10

In Dovecot 1.1.11 cmusieve is apparently integrated in the Ubuntu 9.10 package "dovecot-common" since the files are there. I am wanting to right now just do a very basic test of the setup to see how it runs before doing more sophisticated steps that could obscure any errors or bugs (e.g. unit testing). So I took the following example sieve script from the wiki1 documentation: require "fileinto"; if header :contains "X-Spam-Flag" "YES" { fileinto "spam"; } and recoded it to skip the test and just always do the fileinto step like so: require "fileinto"; fileinto "spamtest"; Then I configured my dovecot.conf file (via dovecot-postfix.conf it really points to) by setting: protocol lda { ... mail_plugins = cmusieve mail_plugin_dir = /usr/lib/dovecot/modules/lda ... } and: plugin { sieve_global_path = /etc/dovecot/sieve-global.d/spam.sieve } I manually compiled /etc/dovecot/sieve-global.d/spam.sieve so there also exists /etc/dovecot/sieve-global.d/spam.sievec in the same directory. Then I restarted both Dovecot and Postfix. Mail is being delivered, but still only to the same place it always has. The filesystem shows these sieve files are not being accessed at all. I've read documents http://wiki1.dovecot.org/LDA/Sieve and http://wiki1.dovecot.org/LDA/Sieve/CMU to come up with this. But it just doesn't seem to be happening. So I guess it is a good thing I've broken my testing down into smaller units. Anything standout that I misinterpreted about the documentation? If not, I can post the whole config files (in case there is a conflict with something else I have done). FYI, I'm only trying to do a global sieve, not per-user sieve scripts. I'll tackle per-user stuff at a later date, after the global is working. -- sHiFt HaPpEnS!

4 10

[Dovecot] Per user quota on MySQL
by M. Rodrigo Monteiro 22 Dec '10

22 Dec '10

Hi! I'm new on Dovecot. I'm using: - CentOS 5.5 - Kernel 2.6.18-194.26.1.el5 x86_64 - Dovecot 2.0.8 (from source) - Postfix 2.7.2 (from source) - MySQL 5.0.77 (CentOS binary) - Postfixadmin 2.3.2 (from source) - Horde Webmail 1.2.9 - Thunderbird 3.1.7 (from CentOS) I follow this how to: http://wiki2.dovecot.org/HowTo/DovecotLDAPostfixAdminMySQL I was able to send and recieve e-mail via Postfix/Dovecot. I'm having troubles in the quota. As I said, I use Postfixadmin to manage users. When I log in Horde, it says that the quota is unlimited. Thunderbird too. I think it's because of the configuration on Dovecot. Here it's my confs files: ===== dovecot.conf ===== #ssl_cert_file = /etc/pki/dovecot/certs/myserver.example.com.crt #ssl_key_file = /etc/pki/dovecot/private/myserver.example.com.key #ssl_ca_file = /etc/pki/dovecot/certs/ca-bundle.crt #default_login_user = nobody disable_plaintext_auth = no log_path = /var/log/dovecot.log auth_mechanisms = plain login first_valid_uid = 200 last_valid_uid = 200 mail_location = maildir:/var/vmail/%d/%u ssl = no passdb { args = /usr/local/dovecot/etc/dovecot/sql.conf driver = sql } plugin { #acl = vfile:/usr/local/dovecot/etc/dovecot/acls quota = maildir:storage=10240:messages=1000 trash = /usr/local/dovecot/etc/dovecot/trash.conf } service auth { unix_listener auth-userdb { group = vmail mode = 0660 user = vmail } unix_listener auth-master { group = vmail mode = 0660 user = vmail } unix_listener /var/spool/postfix/private/auth { group = vmail mode = 0660 user = postfix } user = dovecot } userdb { args = /usr/local/dovecot/etc/dovecot/sql.conf driver = sql } userdb { driver = prefetch } protocol imap { imap_client_workarounds = delay-newmail mail_plugins = quota imap_quota } protocol pop3 { mail_plugins = quota pop3_client_workarounds = outlook-no-nuls oe-ns-eoh } protocol lda { mail_plugins = quota postmaster_address = postmaster(a)mydomain.com #log_path = /var/log/dovecot.log #info_log_path = /var/log/dovecot.log } ===== ===== sql.conf ===== driver = mysql connect = host=localhost dbname=postfix user=dovecot password=password user_query = SELECT concat('/var/vmail/', maildir) as home, concat('maildir:/var/vmail/', maildir) as mail, 200 AS uid, 200 AS gid, concat('maildir:storage=', floor(quota/1024)) AS quota FROM mailbox WHERE username = '%u' AND active = '1' ===== ===== mysql ===== mysql> select * from mailbox; +----------------------+------------------------------------+--------------+-----------------------+---------+------------+----------------+---------------------+---------------------+--------+ | username | password | name | maildir | quota | local_part | domain | created | modified | active | +----------------------+------------------------------------+--------------+-----------------------+---------+------------+----------------+---------------------+---------------------+--------+ | teste(a)mydomain.com | $1$bb3d6a71$IF/FORTbdoIqdzBLuSciJ0 | E-mail Teste | mydomain.com/teste/ | 1024000 | teste | mydomain.com | 2010-12-17 10:32:16 | 2010-12-17 11:46:24 | 1 | +----------------------+------------------------------------+--------------+-----------------------+---------+------------+----------------+---------------------+---------------------+--------+ ===== ===== mysql_virtual_mailbox_limit_maps.cf ===== user = postfix password = password hosts = localhost dbname = postfix query = SELECT quota FROM mailbox WHERE username='%s' AND active = '1' ===== I think it's it. If I forgot something, please let me know. Regards, Rodrigo. -- M. Rodrigo Monteiro "Free as in Freedom, not free as in free beer" "As we are liberated from our own fear, our presence automatically liberates others" Linux User # 403730 Pense antes de imprimir. Think before printing. AVISO LEGAL Esta mensagem é destinada exclusivamente para a(s) pessoa(s) a quem é dirigida, podendo conter informação confidencial e/ou legalmente privilegiada. Se você não for destinatário desta mensagem, desde já fica notificado de abster-se a divulgar, copiar, distribuir, examinar ou, de qualquer forma, utilizar a informação contida nesta mensagem, por ser ilegal. Caso você tenha recebido esta mensagem por engano, pedimos que nos retorne este E-Mail, promovendo, desde logo, a eliminação do seu conteúdo em sua base de dados, registros ou sistema de controle. Fica desprovida de eficácia e validade a mensagem que contiver vínculos obrigacionais, expedida por quem não detenha poderes de representação. LEGAL ADVICE This message is exclusively destined for the people to whom it is directed, and it can bear private and/or legally exceptional information. If you are not addressee of this message, since now you are advised to not release, copy, distribute, check or, otherwise, use the information contained in this message, because it is illegal. If you received this message by mistake, we ask you to return this email, making possible, as soon as possible, the elimination of its contents of your database, registrations or controls system. The message that bears any mandatory links, issued by someone who has no representation powers, shall be null or void.

7 14