Hmmm. I've got one of those. The otherwise tidiest people become pack-rats
when it comes to old email. And they all want more than a Gig storage and
25m single file transfers.., then they use it all and IMAP-DoS the server
with 5-minute fetches from their MUAs...
Three dbmail attributes favour big systems.
1) Tuning the connections. DbMail can spawn children like rabbits. Tune for
the frequency of access your users want. If folks are pulling all the
headers every five minutes I wouldn't be stingy in dbamil.conf on children
nor connections. If the tendency is not to use POP you can cut down resource
expense by only running a small few dbmail-pop3d children and run *many*
dbmail-imapd children.
2) RDBMS can be on the mail server or elsewhere. Your choice.
3) Picking the RDBMS. The real choice you want to make is between PostgreSQL
and MySQL. Tuneability, speed and scalability scores now seem to favour
MySQL. If you go with MySQL (4.1.xx), do you use MyISAM or InnoDB schema?
MyISAM is faster but wants more maint.. InnoDB is very tidy and quite clever
about staying clean.
The DbMail InnoDB schema is very good and this is the best way ahead.
PostgreSQL vs MySQL I would say is a matter of what is native to your
enterprise, what people are accustomed to and comfortable maintaining.
PostgreSQL some say is certainly slower but I can't agree anymore since
PgSQL 8 and some refinements in DbMail. Go with what you know best.
Take a look at:
http://www.jaraok.com it's all DbMail on MySQL and *huge*
and
http://library.mobrien.com:2031/dbmailadministrator/demo/dbmailadministrator/DBMA.en
which will give you a peek at a running system.
best...
Mike
----- Original Message -----
From: "Oliver Schulze L." <[EMAIL PROTECTED]
To: "DBMail mailinglist" <dbmail@dbmail.org
Sent: Friday, July 08, 2005 6:34 PM
Subject: Re: [Dbmail] Can I use DBMail with sendmail?
Hi Mike,
yes, mimedefang is very powerfull, special for company policies.
Mike, how well does dbmail work with 200000+ emails per account
and 120000+ emails per folder?
I have users that never deleted emails in a 6 years period and using
mbox is a little slow. With the maildir option I think I will run out of
inodes.
Thanks
Oliver
M. J. [Mike] O'Brien wrote:
I understand. Sendmail's "Milter" API is awesome for that and
mimedefang is ultra flexible.
I did a kind of replacement thing for Postfix. Its just a shell script
Postfix pushes mail through which then hooks up with some other Perl
code and of course modules like SpamAssassin. A lot like mimedefang
without the much more efficient API. There are numerous ways of doing
all this in Postfix but I think you would miss your mimedefang :o)
best... Mike
----- Original Message ----- From: "Oliver Schulze L."
<[EMAIL PROTECTED]
To: "DBMail mailinglist" <dbmail@dbmail.org
Sent: Friday, July 08, 2005 1:48 PM
Subject: Re: [Dbmail] Can I use DBMail with sendmail?
Hi Mike,
many thanks for the instructions.
Will setup a dev box and start the test.
I use mimedefang for virus/spam/policies filtering, so I need sendmail.
Thanks
Oliver
M. J. [Mike] O'Brien wrote:
Hi Oliver:
Yes to Sendmail although I strongly recommend Postfix
I only ever used sendmail/dbmail on a dev box but it was fine. It is
gone now.
Sendmail must be built with mailertable support.
Then, if I remember right it is a matter of building your sendmail.cf
with
1) MAILER(dbmail)
at the end of the source file (whateverOS.mc)
2) and your mailertable.db hash is built from a mailertable source
file having a pointer to dbmail-smtp or dbmail-lmtpd for each domain
you wish to use dbmail ... something like:
my.domain dbmail-lmtp:127.0.0.1:24
makemap hash /etc/mail/mailertable < /etc/mail/mailertable
http://www.sendmail.org/m4/mailertables.html
Someone on the list was doing this recently.
best... Mike
----- Original Message ----- From: "Oliver Schulze L."
<[EMAIL PROTECTED]
To: <dbmail@dbmail.org
Sent: Thursday, July 07, 2005 3:14 PM
Subject: [Dbmail] Can I use DBMail with sendmail?
Hi,
it is posible to use dbmail with sendmail?
Thanks
Oliver
--
Oliver Schulze L.
<[EMAIL PROTECTED]
_______________________________________________
Dbmail mailing list
Dbmail@dbmail.org
https://mailman.fastxs.nl/mailman/listinfo/dbmail
