[Dbmail] pop and imap differences

2003-12-09 Thread Craig Coles
I am using the current 2.0 code and have enabled both the pop3 and imap
daemons.
 I am trying out a few different webmail solutions and seeing different
results.

My imap tests (phpgroupware and imp) are seeing From lines and Subject lines
like this:

From: [EMAIL PROTECTED]
Subject: dbmail IMAP server info: this message could not be parsed

however, the same messages (not all do this) when received thru pop3 daemon
have
the correct From and Subject lines.

why is this?


-Craig



This message was sent using IMP, the Internet Messaging Program.


RE: [Dbmail] Unused Mailbox

2003-12-09 Thread Filip Wuytack

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of
Jesse Norell
Sent: 08 December 2003 23:17
To: dbmail@dbmail.org
Subject: RE: [Dbmail] Unused Mailbox


Hello,

  I think dbmail-maintenance cleans that up.  Or you could
manually run something like "delete from mailboxes where
owner_idnr not in (select distinct user_idnr from users)"
or even add a foreign key in mailboxes that references
users (using "on delete cascade").

jn


 Original Message 
From: Nunno Luca 
To: 
Subject: [Dbmail] Unused Mailbox
Sent: Mon, 8 Dec 2003 23:42:25 +0100

> Hi all,
>  
> How i can delete the unused MailBoxes ? 
> Delete an user or a mailbox don't clear entry in mailbox table ( i think
> because they reference the messages)
>  
> Anyone can suggest a query to delete it ?
>  
> Thank's
> 
> 
-- End Original Message --


--
Jesse Norell
jesse (at) kci.net


___
Dbmail mailing list
Dbmail@dbmail.org
https://mailman.fastxs.nl/mailman/listinfo/dbmail



Re: [Dbmail] using dbmail as a mail archive

2003-12-09 Thread Giorgio70165
* Paul J Stevens <[EMAIL PROTECTED]> [081203, 21:52]:

> And by then, unless very careful you'd be dropping dbmail's keyfeature: 
> efficient, low-latancy storage.
> 
> Implemention of external storage of attachments without losing it's 
> performance requires an asynchronous architecture that is currently 
> missing from the codebase.

Thinked in a local lan use, still keep the potential low efficient and
low-latency storage ? 
I mean that whenever a mail is searched through a sql query, the user
got the mail and the url to the related attachments in a local-lan
server.

Anyway I think it could be difficult to handle thousands of doc,pdf and
those kind of attachment directly encoded into the database in raw mail
format, I estimated not less that 24Gb/year of archived mail size.

bye


RE: [Dbmail] Unused Mailbox

2003-12-09 Thread Jesse Norell
Hello,

  I think dbmail-maintenance cleans that up.  Or you could
manually run something like "delete from mailboxes where
owner_idnr not in (select distinct user_idnr from users)"
or even add a foreign key in mailboxes that references
users (using "on delete cascade").

jn


 Original Message 
From: Nunno Luca 
To: 
Subject: [Dbmail] Unused Mailbox
Sent: Mon, 8 Dec 2003 23:42:25 +0100

> Hi all,
>  
> How i can delete the unused MailBoxes ? 
> Delete an user or a mailbox don't clear entry in mailbox table ( i think
> because they reference the messages)
>  
> Anyone can suggest a query to delete it ?
>  
> Thank's
> 
> 
-- End Original Message --


--
Jesse Norell
jesse (at) kci.net