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
[Dbmail] Using dbmail for enterprise message monitoring?
Hello, I work in the information security department of a large corporation. Our mail server admins currently deliver to us all mail that passes through exchange to an E-mail account, which we then put into a custom MySQL table by way of a PHP script. This is very slow, but we have written custom applications to examine attachments etc for pornography (to be referred to HR) and to prevent leaks of competitive information and although slow there are few users (only four of us) so we live with it. After we found your project we were interested in migrating to it. Do you think DBMail would be a good fit for such a situation? Our table currently stores date, from, to, cc, subject, body, and generic has_attachment,has_image, and has_officefile flags. The body field is fulltext indexed. We keep attachments in flatfiles on disk. We presume your solution would be a little faster. :-) If anyone has any experience using DBMail for such a project (we average 150,000-200,000 messages a day), let me know. Thanks!
[Dbmail] Using DBMail in an existing web app
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). We're using Postgres as our backend. I've done a bunch of searching on the user and dev mailing list related to authentication as well as associating extra data to emails. I have a couple comments and a couple of questions. This is more of a brainstorm than anything else, so please feel free to pipe up. We use a different table setup for authentication. I know that I can write my own authentication functions and base them off of authsql.c to support this. 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... My biggest concern is, if contacts and extra data is associated with an email, what happens when the email is moved into a different folder? I know that IMAP doesn't have a move command, so we lose the dbmail_message row/id. Because there's a slight possibility that two people using our system could get the same email, we can't depend on the dbmail_physmessage being unique per user. Has anyone thought of how dbmail should act if an app developer wants to add extra fields/data related to an email? Jason signature.asc Description: PGP signature
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
[Dbmail] using dbmail
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
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
[Dbmail] Using DBmail without useraccounts
Hi I have dbmail setup using postfix and I would like to add and remove accounts into the mysql database only is there anyway to send all mail handled by postfix to the DBMail so that I don't have to make system level accounts, im building an interface to create users straight into the mysql Please help cause im banding my head against a wall and its starting to hurt regards Carl Fearby Director http://www.oceanworksuk.net/ Oceanworks UK Ltd image001.gif Description: GIF image
[Dbmail] Using DBmail without useraccounts
Hi I have dbmail setup using postfix and I would like to add and remove accounts into the mysql database only is there anyway to send all mail handled by postfix to the DBMail so that I don't have to make system level accounts, im building an interface to create users straight into the mysql Please help cause im banding my head against a wall and its starting to hurt Carl Fearby Director Ouch. Did you read the INSTALL file which was part of the package? Also: INSTALL.postfix i.e.: in /etc/postfix/master.cf add: dbmail-lmtp unix - - n - - lmtp and ...If you want to send all the email the MTA accepts to DBMail, use the following setting in /etc/postfix/main.cf: mailbox_transport = dbmail-lmtp:host:port Also: man dbmail-users Try DbMailAdministrator for GUI to add/manage users etc. http://library.mobrien.com/dbmailadministrator/ best... Mike
[Dbmail] Using DBMail as a Mailman archiver
Hello, A colleague told me about the existence of DBMail. Sounds very cool. I have not yet installed it, as I'd have to upgrade my MySQL installation first. Before I do install DBMail, I'd like to ask if it's possible to use DBMail simply as a Mailman archiver. Mailman, by default, uses Pipermail to archive messages. But it is possible to configure a different external archiver with a mm_cfg.py directive like in the following example that points to MHonarc: PUBLIC_EXTERNAL_ARCHIVER = '/usr/bin/mhonarc -add -outdir /var/mhonarc/archives/%(listname)s /tmp/out_external_archiver' This looks like a simple pipe and I'd like to do the same kind of thing with DBMail in the hopes of getting Mailman list messages into a database. I imagine I'd just have to set up a user for each list, right? Has anyone done this? Does it make sense? Thanks, Kevin McCann
[Dbmail] Using dbmail in parallel to othe local delivery
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
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
[Dbmail] using dbmail as a mail archive
is it possibile to use dbmail as searchable sql mail archive? and what about attachments, should be saved into sql or stripped? thanks
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
[Dbmail] Using DBMAIL
Thanks Bret for your web administration info for DBMAIL. It would also be nice to se a administration tool for DBMAIL on the fine WEBMIN project (www.webmin.com) since i do most of my adminstration with webmin. 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) I would like to know of anybody running DBMAIL in a working environment for 3000 users and more so my work will be well spent. Thanks
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