[Dovecot] convert to mdbox

2013-07-23 Thread 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



smime.p7s
Description: S/MIME Cryptographic Signature


Re: [Dovecot] Managing IMAP IDLE/Push with Sieve – possible?

2013-07-23 Thread Steffen Kaiser

-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

2013-07-23 Thread Robert Schetterer
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?

2013-07-23 Thread Robert Schetterer
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

2013-07-23 Thread Axel Luttgens
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

2013-07-23 Thread Birta Levente

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?

2013-07-23 Thread FF

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

2013-07-23 Thread Cedric

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

2013-07-23 Thread Robert Schetterer
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

2013-07-23 Thread Ed W

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

2013-07-23 Thread 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?

-- 
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

2013-07-23 Thread Robert Schetterer
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

2013-07-23 Thread Mike Abbott
 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

2013-07-23 Thread Ed W

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

2013-07-23 Thread 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/ ?


Re: [Dovecot] Sieve info

2013-07-23 Thread Reindl Harald


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

2013-07-23 Thread Robert Schetterer
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

2013-07-23 Thread Anand Kumria
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