Re: [Dbmail] Using DBMail in an existing web app
On Sat, 21 Oct 2006 22:55:31 +0200 Paul J Stevens [EMAIL PROTECTED] wrote: Jason Chu wrote: I believe my other two concerns about keeping emails and extra data/fields associated with emails still stand though. Jason, What you want is to associate meta-data with a physmessage and a user, not with a message in folder. That way you'd avoid the problems posed by copy. consider this: create table dbmail_annotation ( id bigint not null autoincrement, user_idnr bigint not null, physmessage_id bigint not null, message_partchar(16) not null default '', annotation text not null, primary key (id), unique (physmessage_id, id), foreign_key (physmessage_id) references dbmail_physmesssage(id) on update cascade on delete cascade ); this could be expanded with a ACL setup that would allow people to share access to an annotation with other users, like dbmail_acl does for mailboxes. Thanks Paul! That's exactly what I needed. I've spent a couple days thinking about this and playing around with it and I'm pretty sure we can pull it off. This will work way better than using a filesystem based mail store! Jason signature.asc Description: PGP signature
Re: [Dbmail] Using DBMail in an existing web app
Jason Chu wrote: I believe my other two concerns about keeping emails and extra data/fields associated with emails still stand though. Jason, What you want is to associate meta-data with a physmessage and a user, not with a message in folder. That way you'd avoid the problems posed by copy. consider this: create table dbmail_annotation ( id bigint not null autoincrement, user_idnr bigint not null, physmessage_id bigint not null, message_partchar(16) not null default '', annotation text not null, primary key (id), unique (physmessage_id, id), foreign_key (physmessage_id) references dbmail_physmesssage(id) on update cascade on delete cascade ); this could be expanded with a ACL setup that would allow people to share access to an annotation with other users, like dbmail_acl does for mailboxes. -- Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlandshttp://www.nfg.nl
Re: [Dbmail] Using DBMail in an existing web app
On Tue, 17 Oct 2006 21:12:23 -0700 Jason Chu [EMAIL PROTECTED] wrote: We're looking into using dbmail in our existing web app (http://oprius.com). Because our app is a CRM type of thing, we want to associate emails with other rows in the database (think associating emails with contacts). Ok, I was looking at the old 2.0 code. I just downloaded the 2.1 code and noticed a bunch of things have changed. Auth is still the same, just in a different place. I believe my other two concerns about keeping emails and extra data/fields associated with emails still stand though. Jason signature.asc Description: PGP signature
Re: [Dbmail] Using DBMail in an existing web app
Jason Chu wrote: We want to be able to archive all emails even if the user deletes them from the IMAP server, because we don't want the users to lose conversation history even if they're deleters. It'd be nice if these emails were just stored in the same tables as existing emails and just never shown by the IMAP server. I've noticed that dbmail doesn't delete emails until the maintenance script is run. I don't know exactly how this works though, could someone explain it? We might be able to use that... dbmail-maintenance will only delete messages that have status=MESSAGE_STATUS_PURGE. You could simply add a status value in dbmailtypes.h i.e. MESSAGE_STATUS_ARCHIVE and set the status to that new value. They will then never be deleted by dbmail, nor be shown by imapd. -- Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlandshttp://www.nfg.nl
Re: [Dbmail] using dbmail
Hi Marc, I did all you mentioed before that and i can add users to dbmail but the problem is: 1. how i can setup the MUA like outlook or MS outlook? because outlook ask for password before access the dbmail server. 2. can i send mail to user in dbmail using linux command MAIL from the dbmail server itself if yes please tell me how. regards. Khalid From: Marc Dirix [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED],DBMail mailinglist dbmail@dbmail.org To: DBMail mailinglist dbmail@dbmail.org Subject: Re: [Dbmail] using dbmail Date: Tue, 24 Jan 2006 11:24:29 +0100 There is an dbmailer.m4. http://www.helgrim.com/dbmaildocs/files/dbmail.m4 You can put this in your /usr/share/sendmail/cf/mailer and include in sendmail.mc : MAILER('dbmail') In mailertable you can add something like: mydomaindbmail:mydomain Or remove the MAILER('local') completely. Secondly you can use the dbmailer-lsmtp which is acts as a local smtp server to which you can forward the mail. Kind regards, Marc Dirix On Tue, Jan 24, 2006 at 10:07:35AM +, khalid hussein wrote: Hi all, i installed dbmail, but i don't know how i can use it, i can add new user but i don't khnow how i can send mail to this user either using mail command line or from other MUA, i use sendmail+pop3 for my mail server and is running well, please help me if there any additional configuration for configuration files for the old mail server, and how i can use dbmail server for domains the host with running dbmail part of this domains. thanks ___ Dbmail mailing list Dbmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail ___ Dbmail mailing list Dbmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail
Re: [Dbmail] using dbmail
1. how i can setup the MUA like outlook or MS outlook? because outlook ask for password before access the dbmail server. In Outlook or Outlook express you need to setup a new mail account, and point it to the server running dbmail. Here you select the protcol you want to use, pop3 or imap. You use the username and password you setup in the dbmail with dbmail-users. That should be all to it 2. can i send mail to user in dbmail using linux command MAIL from the dbmail server itself if yes please tell me how. regards. I run sendmail from the commandline like I normally do. dbmail-smtp should also work, however you can only send emails to the user which are in your dbmail system. echo message |dbmail-smtp -u user -m mailbox Kind regards, Marc
Re: [Dbmail] using dbmail
There is an dbmailer.m4. http://www.helgrim.com/dbmaildocs/files/dbmail.m4 You can put this in your /usr/share/sendmail/cf/mailer and include in sendmail.mc : MAILER('dbmail') In mailertable you can add something like: mydomaindbmail:mydomain Or remove the MAILER('local') completely. Secondly you can use the dbmailer-lsmtp which is acts as a local smtp server to which you can forward the mail. Kind regards, Marc Dirix On Tue, Jan 24, 2006 at 10:07:35AM +, khalid hussein wrote: Hi all, i installed dbmail, but i don't know how i can use it, i can add new user but i don't khnow how i can send mail to this user either using mail command line or from other MUA, i use sendmail+pop3 for my mail server and is running well, please help me if there any additional configuration for configuration files for the old mail server, and how i can use dbmail server for domains the host with running dbmail part of this domains. thanks ___ Dbmail mailing list Dbmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail
Re: [Dbmail] Using dbmail in parallel to othe local delivery
You can implement this in the MTA. One way is to have one server for receiving all SMTP traffic. This server has each user defined as a mailinglist in the aliasfile. My aliasline would look like magnus: [EMAIL PROTECTED], [EMAIL PROTECTED] Magnus Barak Bejerano wrote: Hi List. I was wondering if it is possible to use both DBmail and local delivery in parallel in my transition period? Any ideas? my current idea is to use procmail for local delivery and create a procmail file for each user, this will also allow me to sort messages into different folders. Thanks in advance. Barak ___ Dbmail mailing list Dbmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail
Re: [Dbmail] using dbmail as a mail archive
Giorgio70165 wrote: 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. You could store attachments in a separate table to keep text searches usable. -- Sandino Araico Sa'nchez -- Lo que no mata engorda.
Re: [Dbmail] using dbmail as a mail archive
* Sandino Araico Sanchez [EMAIL PROTECTED] [141203, 22:17]: You could store attachments in a separate table to keep text searches usable. Good idea! Do you know any good program that can strip attachments? thanks, bye
Re: [Dbmail] using dbmail as a mail archive
try ripmime, works fine except sometimes with large file names, subhasis All I want is a few minutes alone with the source code for the universe and a quick recompile. .---. / \ [EMAIL PROTECTED]@./ Subhasis Gupta /`\_/`\ Manager - Deptt. of IT // _ \\ UTI Investor Services Limited | \ )|_ Pl 3, Sector # 11, UTI Bhavan /`\_` _/ \ CBD Belapur, Navi Mumbai - 400 614 \__/'---'\__/ mailto:[EMAIL PROTECTED];[EMAIL PROTECTED] Visit us at http://www.utiisl.co.in Phone : +91 22 27561690 Extn 2108 - Original Message - From: Giorgio70165 [EMAIL PROTECTED] To: dbmail@dbmail.org Sent: Monday, December 15, 2003 2:15 PM Subject: Re: [Dbmail] using dbmail as a mail archive * Sandino Araico Sanchez [EMAIL PROTECTED] [141203, 22:17]: You could store attachments in a separate table to keep text searches usable. Good idea! Do you know any good program that can strip attachments? thanks, bye ___ Dbmail mailing list Dbmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail
Re: [Dbmail] using dbmail as a mail archive
* subhasis Gupta [EMAIL PROTECTED] [151203, 14:27]: try ripmime, works fine except sometimes with large file names, subhasis thanks subhasis, it seems to be right. I am testing it on a dev server bye
Re: [Dbmail] using dbmail as a mail archive
Hi! You could hack the source an add a has_attachments column. :-) Regards, Chris Giorgio70165 wrote: * subhasis Gupta [EMAIL PROTECTED] [151203, 14:27]: try ripmime, works fine except sometimes with large file names, subhasis thanks subhasis, it seems to be right. I am testing it on a dev server bye ___ Dbmail mailing list Dbmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail
Re: [Dbmail] using dbmail as a mail archive
* 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] using dbmail as a mail archive
Em Segunda 08 Dezembro 2003 11:38, Giorgio70165 escreveu: is it possibile to use dbmail as searchable sql mail archive? and what about attachments, should be saved into sql or stripped? yes, but messages are saved in a raw format. this means that the message contains the headers, the text and the attachments, only separated in a se quence of blocks. you can hack the code to not save the mime part (attachments), but you are by your own. ;-) []s, gandhi -- Ricardo Andere de Mello Quilombo Digital - Presidente [EMAIL PROTECTED] - 55 11 32717928
Re: [Dbmail] using dbmail as a mail archive
* Ricardo Andere de Mello [EMAIL PROTECTED] [081203, 14:52]: is it possibile to use dbmail as searchable sql mail archive? and what about attachments, should be saved into sql or stripped? yes, but messages are saved in a raw format. this means that the message contains the headers, the text and the attachments, only separated in a se quence of blocks. you can hack the code to not save the mime part (attachments), but you are by your own. ;-) It could be simpler to use and externa tool as preprocessing that strip attachments, and insert something like nfs,http,smb url of location in the saved mail but don't know how to do that. Any suggestion? bye
Re: [Dbmail] using dbmail as a mail archive
Giorgio70165 wrote: It could be simpler to use and externa tool as preprocessing that strip attachments, and insert something like nfs,http,smb url of location in the saved mail but don't know how to do that. Any suggestion? 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. -- Paul Stevens mailto:[EMAIL PROTECTED] NET FACILITIES GROUP PGP: finger [EMAIL PROTECTED] The Netherlandshttp://www.nfg.nl
Re: [Dbmail] Using DBMAIL
Now that my test DBMAIL server is up and running i have a lot of work to do to convert 3000 users using (postfix+uw IMAP+amavis+fprot+webmail) On that topic, are there any scripts/apps available to import the user data from file, into the database? Finding any scripts/apps is part of the work and writing some is they other part I have a link that i got on this mailing list check it out http://www.birdbrained.org/dbmail.php