Re: Discursion about bug #465

Jorge Bastos wrote:
> Paul,
> 
> I’d like to discurss this bug.
> 
> How does the other IMAP server handle this?

Dont know. A command line buffer of 64k already seems quite excessive.

> 
> I belive I’m not the only one with a imap mailbox with 10.000 emails.

Of course you're not. But apparently OE6 is the only client that will try to
delete all of them in *one* command, specifying each message id seperately.

I know most other clients will issue several commands specifying something like
a couple of hundred message ids per command,
Or they will use nice message ranges:
XX STORE 1:1000000 +FLAGS (\Deleted)
will happily delete 100k message without any trouble.

You can also simply delete the whole mailbox, though that will immediately
destroy the messages, rather than using the stepped deletion that you get when
deleting messages.

> Right now I didn’t made any test with other imap server, but I’ll with
> cyrus to see what it does.

--

-- 
  ________________________________________________________________

Re: Discursion about bug #465

Paul J Stevens wrote:
> though that will immediately
> destroy the messages, rather than using the stepped deletion that you get when
> deleting messages.

Will this behavior be changed to the "stepped deletion" scheme? If so, 
in 2.2 or 2.3?

Regards,

--

-- 
Aleksander Kamenik
system administrator
+372 6659 649
aleksander <at> krediidiinfo.ee

Krediidiinfo AS
http://www.krediidiinfo.ee/

Re: Discursion about bug #465

Aleksander Kamenik wrote:

> Will this behavior be changed to the "stepped deletion" scheme? If so,
> in 2.2 or 2.3?

Personally, I'm not in favor of this at all.

If accidental deletion of mailboxes is what bothers you, you can configure the
mailclients to move mailboxes to below Trash (like thunderbird does).

If you all think we cannot live without stepped deletion of mailboxes, what is
required is:
- break the foreign key restraint between messages and mailboxes
- setup a trigger that will update the status field of all messages when a
mailbox is deleted.
- make sure the integrity check run by dbmail-util no longer delete unconnected
messages.

So no this will not happen in the 2.2. code, but it may be done in 2.3

--

-- 
  ________________________________________________________________
  Paul Stevens                                      paul at nfg.nl
  NET FACILITIES GROUP                     GPG/PGP: 1024D/11F8CD31
  The Netherlands________________________________http://www.nfg.nl

Re: deb installation questions

On Sep 30, 2007, at 7:12 AM, Paul J Stevens wrote:

>
> Tom
>
> 2.2.6-2 just entered testing today.

That might explain why I didn't see it the day before.
Thanks!

Re: Discursion about bug #465

Paul J Stevens wrote:

> If accidental deletion of mailboxes is what bothers you, you can configure the
> mailclients to move mailboxes to below Trash (like thunderbird does).

That's not always possible.

> If you all think we cannot live without stepped deletion of mailboxes, what is
> required is:
> - break the foreign key restraint between messages and mailboxes
> - setup a trigger that will update the status field of all messages when a
> mailbox is deleted.
> - make sure the integrity check run by dbmail-util no longer delete unconnected
> messages.
> 
> So no this will not happen in the 2.2. code, but it may be done in 2.3

Sounds fair. I'm not that worried either, although it would be a nice 
feature and would be consistent with the deletion of individual messages.

It was a surprise for me when I found out that the stepped deletion 
process could be bypassed. I think I might not be the only one, maybe a 
warning should be somewhere for admins?

The restoring of messages (mostly accidental deletes by users) via 
simple SQL instead of running for the backups has been a valuable dbmail 
feature so far, too bad this can't be used in the case of mailboxes.

--

-- 
Aleksander Kamenik

general question

Hello people,

I am currently developing a web interface for accessing emails
within dbmail directly through that web site, something like Horde or
Roundcube but specifically for dbmail.
Reading access is handled directly via SQL and changing stuff I mainly
handle via IMAP.

Two questions have came up though:

1). how can I see if a email has been forwarded? There is a flag
for answered but forwarded doesn´t seem to be there.

2). is there an easy way to determine if an email has an attachment or
not? I could use a simple check of size but this is not 100% accurate
and parsing through all emails and check the mime structure becomes
quite time consuming.

Well, thanks for your help!

Kind regards,
Daniel

Re: general question

Daniel Urstöger wrote:
> Hello people,
> 
> I am currently developing a web interface for accessing emails
> within dbmail directly through that web site, something like Horde or
> Roundcube but specifically for dbmail.
> Reading access is handled directly via SQL and changing stuff I mainly
> handle via IMAP.

Mmm, please consider that storage models can and will change. The IMAP protocol
and it's RFC extensions are cast in solid rock.

> 
> Two questions have came up though:
> 
> 1). how can I see if a email has been forwarded? There is a flag
> for answered but forwarded doesn´t seem to be there.

That's correct. Forwarded is not a supported flag (yet).

> 
> 2). is there an easy way to determine if an email has an attachment or
> not? I could use a simple check of size but this is not 100% accurate
> and parsing through all emails and check the mime structure becomes
> quite time consuming.

For now:  use IMAP's "FETCH n (BODYSTRUCTURE)"

2.3.0 (coming to you later this month) will support arbitrary labels. Whether a
message will then be flagged when forwarded depends on the client. 2.3 will also

Re: Discursion about bug #465

On Montag, 1. Oktober 2007 10:40 Paul J Stevens wrote:
> - break the foreign key restraint between messages and mailboxes

Would it not be possible to insert a DELETED flag to mailboxes? Like 
this, all behaviour could be let the same, just when a client deletes 
the folder, it's not deleted, just marked so. And that is removed 
normally with the next dbmail-util cleanup.

mfg zmi
--

-- 
// Michael Monnerie, Ing.BSc    -----      http://it-management.at
// Tel: 0676/846 914 666                      .network.your.ideas.
// PGP Key:         "curl -s http://zmi.at/zmi.asc | gpg --import"
// Fingerprint: EA39 8918 EDFF 0A68 ACFB  11B7 BA2D 060F 1C6F E6B0
// Keyserver: www.keyserver.net                   Key-ID: 1C6FE6B0

_______________________________________________
DBmail mailing list
DBmail <at> dbmail.org
https://mailman.fastxs.nl/mailman/listinfo/dbmail

Re: general question

Paul J Stevens schrieb:
> Daniel Urstöger wrote:
>> Hello people,
>>
>> I am currently developing a web interface for accessing emails
>> within dbmail directly through that web site, something like Horde or
>> Roundcube but specifically for dbmail.
>> Reading access is handled directly via SQL and changing stuff I mainly
>> handle via IMAP.
> 
> Mmm, please consider that storage models can and will change. The IMAP protocol
> and it's RFC extensions are cast in solid rock.

yes, I will have to update my script accordingly, it just gives me
quite an advantage accessing the data directly via SQL and not havening
IMAP as intermediate layer, performance wise.

>> Two questions have came up though:
>>
>> 1). how can I see if a email has been forwarded? There is a flag
>> for answered but forwarded doesn´t seem to be there.
> 
> That's correct. Forwarded is not a supported flag (yet).

Okay, so how does a mail client recognize this? via an IMAP command to?

>> 2). is there an easy way to determine if an email has an attachment or
>> not? I could use a simple check of size but this is not 100% accurate
>> and parsing through all emails and check the mime structure becomes
>> quite time consuming.

RE: Discursion about bug #465

Ok Paul,
I was looking how the other clients do it and sinse i'm trying to drop the use of outlook express, it's solved.
I belive other clients do it as you say.

-----Original Message-----
From: dbmail-bounces <at> dbmail.org [mailto:dbmail-bounces <at> dbmail.org] On Behalf Of Paul J Stevens
Sent: segunda-feira, 1 de Outubro de 2007 8:23
To: DBMail mailinglist
Subject: Re: [Dbmail] Discursion about bug #465

Jorge Bastos wrote:
> Paul,
> 
> I’d like to discurss this bug.
> 
> How does the other IMAP server handle this?

Dont know. A command line buffer of 64k already seems quite excessive.

> 
> I belive I’m not the only one with a imap mailbox with 10.000 emails.

Of course you're not. But apparently OE6 is the only client that will try to
delete all of them in *one* command, specifying each message id seperately.

I know most other clients will issue several commands specifying something like
a couple of hundred message ids per command,
Or they will use nice message ranges:
XX STORE 1:1000000 +FLAGS (\Deleted)
will happily delete 100k message without any trouble.