[Dovecot] convert to mdbox
Hi How can I convert all virtual mailboxes from maildir to mdbox? Manually, one by one, working, but I have a lot ... Virtual users and domains stored in sql database. Thats what I want: mail_location = maildir:/var/vmail/%d/%n/Maildir to mail_location = mdbox:/var/vmail/%d/%n/mdbox Thanks Levi smime.p7s Description: S/MIME Cryptographic Signature
Re: [Dovecot] Managing IMAP IDLE/Push with Sieve – possible?
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Mon, 22 Jul 2013, FF wrote: I've been using Dovecot with Sieve for a long time already, and I'm very happy with it. Push is working fine too. I was wondering, however, whether it would be possible to define a Sieve rule (perhaps using some plug-in), such that an IMAP push message gets sent out only for specific senders etc.? I think you cannot. But you could split your INBOX into senders with PUSH (that are delivered to the INBOX) and others, that are delivered to INBOX2. - -- Steffen Kaiser -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.11 (GNU/Linux) iQEVAwUBUe4zH13r2wJMiz2NAQLd4gf/ZcfpXHUQCOozFV5L464voasate3T+aDf W6dnk9s+jOZiYmZZzaxZPw2z14v0GA5BAJdp4h/klbFPxg7Fs9MjUdoi2kusKaw6 ofbQwCsGnGD+kxme0JKtnayWo07Vwdo1rjbhxtSSGU7K4RVtnh4Kj6wTySCYrzKN +0mPIU1XUVJqw6ir+xrJSmcWY5joOnQ1+m1TI6J4E+qIqc+QjJkX1LFOMz+1Lz0x QR05UaH0+bWQPZqknWrxEEHz0eIXZsbrTuosMDHnHjDv1jRe1RzPFi6k+JvbCXcj N4ip0MNuMuYp/tXG9ntYjRwUvjJ8Du9smwh4FE72Uv11povihr7PzA== =0Afu -END PGP SIGNATURE-
Re: [Dovecot] convert to mdbox
Am 23.07.2013 09:08, schrieb Birta Levente: Hi How can I convert all virtual mailboxes from maildir to mdbox? Manually, one by one, working, but I have a lot ... Virtual users and domains stored in sql database. Thats what I want: mail_location = maildir:/var/vmail/%d/%n/Maildir to mail_location = mdbox:/var/vmail/%d/%n/mdbox Thanks Levi http://wiki2.dovecot.org/Tools/Dsync dsync should do it , but be aware from dsync bugs in some versions do heavy testing before doing something live, for many users do i.e with bash script export your users from sql to a file, or use live query for i in `cat user.lst` do dsync . done for avoid acl and quota problems dsync -o plugin/acl= -o plugin/quota= -u perhaps look at http://sys4.de/de/blog/2013/07/20/fallstricke-mit-acl-und-quota-bei-backup-mit-dsync-dovecot/ be aware of, if use zlib plugin all backup mails get compressed too Best Regards MfG Robert Schetterer -- [*] sys4 AG http://sys4.de, +49 (89) 30 90 46 64 Franziskanerstraße 15, 81669 München Sitz der Gesellschaft: München, Amtsgericht München: HRB 199263 Vorstand: Patrick Ben Koetter, Axel von der Ohe, Marc Schiffbauer Aufsichtsratsvorsitzender: Florian Kirstein
Re: [Dovecot] Managing IMAP IDLE/Push with Sieve – possible?
Am 23.07.2013 09:39, schrieb Steffen Kaiser: On Mon, 22 Jul 2013, FF wrote: I've been using Dovecot with Sieve for a long time already, and I'm very happy with it. Push is working fine too. I was wondering, however, whether it would be possible to define a Sieve rule (perhaps using some plug-in), such that an IMAP push message gets sent out only for specific senders etc.? I think you cannot. But you could split your INBOX into senders with PUSH (that are delivered to the INBOX) and others, that are delivered to INBOX2. -- Steffen Kaiser perhaps the imap lemonade extensions may do that have you investigated by that? Best Regards MfG Robert Schetterer -- [*] sys4 AG http://sys4.de, +49 (89) 30 90 46 64 Franziskanerstraße 15, 81669 München Sitz der Gesellschaft: München, Amtsgericht München: HRB 199263 Vorstand: Patrick Ben Koetter, Axel von der Ohe, Marc Schiffbauer Aufsichtsratsvorsitzender: Florian Kirstein
Re: [Dovecot] Dovecot 2.2.4/sendmail with sql user and aliases
Le 23 juil. 2013 à 02:41, Cedric a écrit : Hi, Ok thank for the interpretation, we used sendmail the last 16 years and I'm trying to migrate a old linuxconf/imapd setup here. [...] Below i provided two differents sql attempt, your input on how to make dovecot lda understand it should deliver the mail to the correct file are welcome [...] There's a new debug output fixing the domain entry The querry i pasted seem to be wrong for a previous configuration there's the correct one : [...] *** 1. row *** user: cedr...@mail.vdl username: cedrict domain: mail.vdl home: /vhome/mail.vdl/home/cedrict index: /vhome/mail.vdl/home/cedrict/mail/index control: /vhome/mail.vdl/home/cedrict/mail/control inbox: /var/spool/vmail/mail.vdl/cedrict layout: maildir++ uid: 60001 gid: 231 [...] *** 1. row *** user: cedr...@mail.vdl inbox: /var/spool/vmail/mail.vdl/cedrict home: /vhome/mail.vdl/home/cedrict uid: 60001 gid: 231 1 row in set (0,54 sec) [...] Hello Cédric, In both cases, your queries provide sufficient info for overriding or for providing a full substitute to mail_home (left empty in your dovecot.conf), but fail to do the same for mail_location. Perhaps could you try something like this: SELECT concat( s_courriel_utilisateur.utilisateur, '@', s_courriel_domaine.nom ) AS user, concat( 'mbox:~/mail:LAYOUT=maildir++:INDEX=MEMORY:CONTROL=~/mail/control:INBOX=/var/spool/vmail/', s_courriel_domaine.nom, '/', s_courriel_utilisateur.utilisateur ) AS mail, concat( /vhome/, s_courriel_domaine.nom, /home/, s_courriel_utilisateur.utilisateur ) AS home, s_courriel_utilisateur.uid AS uid, s_courriel_domaine.gid AS gid FROM [...] Not sure whether you still need the AS user part, but it should not hurt with such a query. More info at: http://wiki2.dovecot.org/UserDatabase http://wiki2.dovecot.org/AuthDatabase/SQL HTH, Axel
Re: [Dovecot] convert to mdbox
On 23/07/2013 10:44, Robert Schetterer wrote: Am 23.07.2013 09:08, schrieb Birta Levente: Hi How can I convert all virtual mailboxes from maildir to mdbox? Manually, one by one, working, but I have a lot ... Virtual users and domains stored in sql database. Thats what I want: mail_location = maildir:/var/vmail/%d/%n/Maildir to mail_location = mdbox:/var/vmail/%d/%n/mdbox Thanks Levi http://wiki2.dovecot.org/Tools/Dsync dsync should do it , but be aware from dsync bugs in some versions do heavy testing before doing something live, for many users do i.e with bash script export your users from sql to a file, or use live query for i in `cat user.lst` do dsync . done I thought dsync can do natively, just I don't figure out how. I use the latest 2.2.4 dovecot, so I hope there was no problem. for avoid acl and quota problems dsync -o plugin/acl= -o plugin/quota= -u Thanks for the hint. perhaps look at http://sys4.de/de/blog/2013/07/20/fallstricke-mit-acl-und-quota-bei-backup-mit-dsync-dovecot/ be aware of, if use zlib plugin all backup mails get compressed too Best Regards MfG Robert Schetterer Thank you!! Levi smime.p7s Description: S/MIME Cryptographic Signature
Re: [Dovecot] Managing IMAP IDLE/Push with Sieve – possible?
Hi, Thanks, that's interesting -- two questions: 1) Why is it not possible? Just not implemented, or is there any technical reason that actually prevents it from being implemented? 2) What do you mean by INBOX? Another, completely separate email account? Yes, that would be my backup plan. Thanks, F.F. -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Mon, 22 Jul 2013, FF wrote: I've been using Dovecot with Sieve for a long time already, and I'm very happy with it. Push is working fine too. I was wondering, however, whether it would be possible to define a Sieve rule (perhaps using some plug-in), such that an IMAP push message gets sent out only for specific senders etc.? I think you cannot. But you could split your INBOX into senders with PUSH (that are delivered to the INBOX) and others, that are delivered to INBOX2. - -- Steffen Kaiser -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.11 (GNU/Linux) iQEVAwUBUe4zH13r2wJMiz2NAQLd4gf/ZcfpXHUQCOozFV5L464voasate3T+aDf W6dnk9s+jOZiYmZZzaxZPw2z14v0GA5BAJdp4h/klbFPxg7Fs9MjUdoi2kusKaw6 ofbQwCsGnGD+kxme0JKtnayWo07Vwdo1rjbhxtSSGU7K4RVtnh4Kj6wTySCYrzKN +0mPIU1XUVJqw6ir+xrJSmcWY5joOnQ1+m1TI6J4E+qIqc+QjJkX1LFOMz+1Lz0x QR05UaH0+bWQPZqknWrxEEHz0eIXZsbrTuosMDHnHjDv1jRe1RzPFi6k+JvbCXcj N4ip0MNuMuYp/tXG9ntYjRwUvjJ8Du9smwh4FE72Uv11povihr7PzA== =0Afu -END PGP SIGNATURE-
Re: [Dovecot] Dovecot 2.2.4/sendmail with sql user and aliases
Hi, Thank you,it fixed the issue i had. Regards Cedric Le 2013-07-23 03:49, Axel Luttgens a écrit : Le 23 juil. 2013 à 02:41, Cedric a écrit : Hi, Ok thank for the interpretation, we used sendmail the last 16 years and I'm trying to migrate a old linuxconf/imapd setup here. [...] Below i provided two differents sql attempt, your input on how to make dovecot lda understand it should deliver the mail to the correct file are welcome [...] There's a new debug output fixing the domain entry The querry i pasted seem to be wrong for a previous configuration there's the correct one : [...] *** 1. row *** user:cedr...@mail.vdl username: cedrict domain: mail.vdl home: /vhome/mail.vdl/home/cedrict index: /vhome/mail.vdl/home/cedrict/mail/index control: /vhome/mail.vdl/home/cedrict/mail/control inbox: /var/spool/vmail/mail.vdl/cedrict layout: maildir++ uid: 60001 gid: 231 [...] *** 1. row *** user:cedr...@mail.vdl inbox: /var/spool/vmail/mail.vdl/cedrict home: /vhome/mail.vdl/home/cedrict uid: 60001 gid: 231 1 row in set (0,54 sec) [...] Hello Cédric, In both cases, your queries provide sufficient info for overriding or for providing a full substitute to mail_home (left empty in your dovecot.conf), but fail to do the same for mail_location. Perhaps could you try something like this: SELECT concat( s_courriel_utilisateur.utilisateur, '@', s_courriel_domaine.nom ) AS user, concat( 'mbox:~/mail:LAYOUT=maildir++:INDEX=MEMORY:CONTROL=~/mail/control:INBOX=/var/spool/vmail/', s_courriel_domaine.nom, '/', s_courriel_utilisateur.utilisateur ) AS mail, concat( /vhome/, s_courriel_domaine.nom, /home/, s_courriel_utilisateur.utilisateur ) AS home, s_courriel_utilisateur.uid AS uid, s_courriel_domaine.gid AS gid FROM [...] Not sure whether you still need the AS user part, but it should not hurt with such a query. More info at: http://wiki2.dovecot.org/UserDatabase http://wiki2.dovecot.org/AuthDatabase/SQL HTH, Axel
Re: [Dovecot] performance 2.1.17 zlib maildir
Am 22.07.2013 14:23, schrieb Robert Schetterer: Am 22.07.2013 13:50, schrieb Ralf Hildebrandt: * Robert Schetterer r...@sys4.de: Am 20.07.2013 20:30, schrieb Robert Schetterer: Hi Timo, i have reports from few users about lost performance with 2.17 maildir bigger mailboxes ( up to 2 GB ), i also use zlib plugin what about this patch.,may not working as i should? http://hg.dovecot.org/dovecot-2.1/rev/9c23d1fb8969 Best Regards MfG Robert Schetterer i checked this reverting to 2.1.15 (had only this pre compiled) perfomance gets better with this, looks like the problem is getting more worst with having bigger mailboxes and heavy use of subfolder trees any idea? I wonder why this would matter. zlib is compressing EACH message individually, so the actual SIZE of the mailbox would not matter (the number of message would matter, though). Which operations are slow? Folder listing? Actually accessing messages? accessing , list messsages , copy, move delete operations it must not be zlib related, that was a guess there are two other patches only maildir related might be a better guess http://hg.dovecot.org/dovecot-2.1/rev/7389ff729d2e http://hg.dovecot.org/dovecot-2.1/rev/4c05b9447a10 other patches dont look related to me, however i use a lot of other plugins which might also involved sorry not easy to measure , but performance here is def better with 2.1.15 , same client setup, no special failures about that in debug logs Best Regards MfG Robert Schetterer back to 2.1.17 looks like rising values for /proc/sys/fs/inotify/max_user_instances helped however i got no warning in the logs so wait and and see for now Best Regards MfG Robert Schetterer -- [*] sys4 AG http://sys4.de, +49 (89) 30 90 46 64 Franziskanerstraße 15, 81669 München Sitz der Gesellschaft: München, Amtsgericht München: HRB 199263 Vorstand: Patrick Ben Koetter, Axel von der Ohe, Marc Schiffbauer Aufsichtsratsvorsitzender: Florian Kirstein
Re: [Dovecot] script to test CATENATE
On 22/07/2013 23:17, Mike Abbott wrote: Attached please find a perl script which tests the CATENATE support in dovecot. I used this to test my CATENATE implementation a few years ago and it runs fine against dovecot in OS X Server. Hi Mike Do you think you might re-submit the matching BURL support to Postfix? It seems like it accidentally fell on the floor due to arriving at a bad moment some years back? Cheers Ed W
Re: [Dovecot] performance 2.1.17 zlib maildir
* Robert Schetterer r...@sys4.de: back to 2.1.17 looks like rising values for /proc/sys/fs/inotify/max_user_instances helped however i got no warning in the logs so wait and and see for now Wasn't this the bug I encountered with inotify the linux kernel? -- 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.hildebra...@charite.de | http://www.charite.de
Re: [Dovecot] performance 2.1.17 zlib maildir
Am 23.07.2013 14:17, schrieb Ralf Hildebrandt: * Robert Schetterer r...@sys4.de: back to 2.1.17 looks like rising values for /proc/sys/fs/inotify/max_user_instances helped however i got no warning in the logs so wait and and see for now Wasn't this the bug I encountered with inotify the linux kernel? yes , since then it should produce a warning in the logs ( havent found that at mine) , things now look better ,but i ll wait what power users will report, i am not a good tester in this case , cause i do too qualified mail handling *g Best Regards MfG Robert Schetterer -- [*] sys4 AG http://sys4.de, +49 (89) 30 90 46 64 Franziskanerstraße 15, 81669 München Sitz der Gesellschaft: München, Amtsgericht München: HRB 199263 Vorstand: Patrick Ben Koetter, Axel von der Ohe, Marc Schiffbauer Aufsichtsratsvorsitzender: Florian Kirstein
Re: [Dovecot] script to test CATENATE
Do you think you might re-submit the matching BURL support to Postfix? I don't think re-submitting is a good idea unless Wietse co. request it, which I doubt will happen.
Re: [Dovecot] script to test CATENATE
On 23/07/2013 14:30, Mike Abbott wrote: Do you think you might re-submit the matching BURL support to Postfix? I don't think re-submitting is a good idea unless Wietse co. request it, which I doubt will happen. My reading of it at the time was something like There are no clients that support this. We don't understand the need Now that there is at least one large client (I'm presuming that IOS does support it?) I think the world has changed and of course the patch has now had large scale testing (since I'm presuming again that it's included in the Apple distributed Postfix version?) I personally think that the idea is perfect and I would like to see it break into mainstream use and from there I think we will possibly see support added to additional clients (I think this is how to break the chicken/egg cycle). The idea that you can use IMAP commands to construct a message server side from bits of other messages, and then post it out server side is fantastic. Please consider having at least one more go. I think there is likely to be much better reception now that clients exist, the patch is well tested and Dovecot at least supports the IMAP side. Please...? Cheers Ed W
Re: [Dovecot] Sieve info
Sam Flint skrev den 2013-07-21 00:34: I'm using Dovecot v2, and I can't seem to find any info abut using sieve with the LDA, or the ManageSieve protocol, can you please point me un the right direction? http://sieve.info/ ?
Re: [Dovecot] Sieve info
Am 23.07.2013 22:04, schrieb Benny Pedersen: Sam Flint skrev den 2013-07-21 00:34: I'm using Dovecot v2, and I can't seem to find any info abut using sieve with the LDA, or the ManageSieve protocol, can you please point me un the right direction? http://sieve.info/ and why do you need to respond days later with generic stuff with no dovecot-context to a already answered question where the asner is simply the *dovecot2* wiki? Original-Nachricht Betreff: Re: [Dovecot] Sieve info Datum: Sun, 21 Jul 2013 00:47:54 +0200 Von: Reindl Harald h.rei...@thelounge.net An: Mailing-List dovecot dovecot@dovecot.org Am 21.07.2013 00:45, schrieb Sam Flint: On Jul 20, 2013 5:39 PM, Reindl Harald h.rei...@thelounge.net mailto:h.rei...@thelounge.net wrote: Am 21.07.2013 00:34, schrieb Sam Flint: I'm using Dovecot v2, and I can't seem to find any info abut using sieve with the LDA, or the ManageSieve protocol, can you please point me un the right direction? google dovecot sieve leads to http://wiki2.dovecot.org/Pigeonhole/Sieve/Configuration Thank you very muuch! The pointer on the v1 wiki pointed to a non-existent page http://wiki2.dovecot.org/ is for version = 2.0 many configs are completly different in v2 http://wiki.dovecot.org/ This documentation is for Dovecot v1.x, see wiki2 for v2.0 documentation signature.asc Description: OpenPGP digital signature
[Dovecot] dsync backup mails compressed
Hi Timo , looks like if zlib plugin is enabled all backupmails ( Maildir ) getting compressed i tested this dsync -o plugin/acl= -o plugin/quota= -u u...@beispiel.de backup maildir://nfs-backup-data/u...@beispiel.de adding -o plugin/zlib= didnt help i am not sure , what is the expected behave , and why -o plugin/quota= does not work ? Best Regards MfG Robert Schetterer -- [*] sys4 AG http://sys4.de, +49 (89) 30 90 46 64 Franziskanerstraße 15, 81669 München Sitz der Gesellschaft: München, Amtsgericht München: HRB 199263 Vorstand: Patrick Ben Koetter, Axel von der Ohe, Marc Schiffbauer Aufsichtsratsvorsitzender: Florian Kirstein
[Dovecot] piegonhole sieve prepending header lines with an extra space
Hi, I've noticed that the redirect sieve extension is placing an extra space before the headers of email when the 'redirect' command is used. Unfortunately this break gmail, yahoo, and most other email programs. I am using pigeonhole 0.4.0-14 with Dovecot 2.2.4.3; I see change 1781:e439789e3211 but it appears to only change how the X-Sieve header is generated. I only have the one dovecot instance but I will note that the setting 'mail_save_crlf = yes' is specified. Thanks, Anand