Re: e-mail server farm question

2006-05-24 Thread Michal F. Hanula
On Mon, May 22, 2006 at 11:16:41PM -0500, Vulpes Velox wrote:
 Maildir makes it easy to distribute it across multiple machines as
 well.
Cyrus Murder looks even better --- take a look at
http://cyrusimap.web.cmu.edu/configuration.html

There is, of course, a catch --- you can only access the mail store via
IMAP/POP3/LMTP (you cannot touch the files directly, though it _is_ easy to
extract the data in case you decide you do not want to see Cyrus any
more), but that can be considered an advantage.

(I have stardet reading this thread in the middle, if you have already
considered cyrus, just ignore me)
mf

-- 
May God bless and keep the Tsar far away from us.


pgpG2SQ1rKXLK.pgp
Description: PGP signature


Re: e-mail server farm question

2006-05-23 Thread Evren Yurtesen

Vulpes Velox wrote:


On Mon, 22 May 2006 11:54:02 -0500
Kevin Kinsey [EMAIL PROTECTED] wrote:



At 07:17 AM 5/22/2006, Evren Yurtesen wrote:


Hello,

I was wondering how does services like yahoo mail is storing
e-mails. Somehow the smtp server should know where to deliver
the mail inside the system and webmail should know from which
server to read it from.

Does anybody have any practical ideas about how it is done?



Derek Ragona wrote:
 If you are using sendmail, as most FreeBSD users are, you can
 check the sendmail.org site for information on mail handling.
 There are a number of methods that depend on your setup.


Well, it's pretty obvious that they aren't using a stock
SendMail:

# telnet mx2.mail.yahoo.com 25
Trying 67.28.113.72...
Connected to mx2.mail.yahoo.com.
Escape character is '^]'.
220 mta309.mail.re4.yahoo.com ESMTP YSmtp service ready

Short of finding an article written by someone 'in the know',
or an answer for someone like that, we can only guess.  I'd
probably start with guessing a big DB on a large SAN;
which pretty much negates the which server to read from
question (up to a point).  Everything else is pretty
academic.  SMTP, IMAP, POP.



Maildir makes it easy to distribute it across multiple machines as
well.


What do you mean exactly? distributing 1 user's mails into seperate
machines? I didnt understand how Maildir helps to this actually.
Thanks,
Evren
___
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to [EMAIL PROTECTED]


Re: e-mail server farm question

2006-05-23 Thread Chad Leigh -- Shire.Net LLC


On May 23, 2006, at 1:35 AM, Evren Yurtesen wrote:


Vulpes Velox wrote:


On Mon, 22 May 2006 11:54:02 -0500
Kevin Kinsey [EMAIL PROTECTED] wrote:

At 07:17 AM 5/22/2006, Evren Yurtesen wrote:


Hello,

I was wondering how does services like yahoo mail is storing
e-mails. Somehow the smtp server should know where to deliver
the mail inside the system and webmail should know from which
server to read it from.

Does anybody have any practical ideas about how it is done?



Derek Ragona wrote:
 If you are using sendmail, as most FreeBSD users are, you can
 check the sendmail.org site for information on mail handling.
 There are a number of methods that depend on your setup.


Well, it's pretty obvious that they aren't using a stock
SendMail:

# telnet mx2.mail.yahoo.com 25
Trying 67.28.113.72...
Connected to mx2.mail.yahoo.com.
Escape character is '^]'.
220 mta309.mail.re4.yahoo.com ESMTP YSmtp service ready

Short of finding an article written by someone 'in the know',
or an answer for someone like that, we can only guess.  I'd
probably start with guessing a big DB on a large SAN;
which pretty much negates the which server to read from
question (up to a point).  Everything else is pretty
academic.  SMTP, IMAP, POP.

Maildir makes it easy to distribute it across multiple machines as
well.


What do you mean exactly? distributing 1 user's mails into seperate
machines? I didnt understand how Maildir helps to this actually.



I am not sure anyone was talking about distributing 1 person's mail  
across separate machines.  The discussion seemed to be how to handle  
large amounts of mail spread out across machines, which maildir helps  
with as you can have one or more file servers and lots of consumers  
(imap/pop) and deliverers (mta) accessing those maildirs on your file  
servers.  Combine with a backend database of some sort (we use an  
ldap db that includes the path for a specific accounts mail) and voilá.


Chad


---
Chad Leigh -- Shire.Net LLC
Your Web App and Email hosting provider
chad at shire.net



___
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to [EMAIL PROTECTED]


Re: e-mail server farm question

2006-05-23 Thread Evren Yurtesen

Chad Leigh -- Shire.Net LLC wrote:



On May 23, 2006, at 1:35 AM, Evren Yurtesen wrote:


Vulpes Velox wrote:


On Mon, 22 May 2006 11:54:02 -0500
Kevin Kinsey [EMAIL PROTECTED] wrote:


At 07:17 AM 5/22/2006, Evren Yurtesen wrote:


Hello,

I was wondering how does services like yahoo mail is storing
e-mails. Somehow the smtp server should know where to deliver
the mail inside the system and webmail should know from which
server to read it from.

Does anybody have any practical ideas about how it is done?



Derek Ragona wrote:
 If you are using sendmail, as most FreeBSD users are, you can
 check the sendmail.org site for information on mail handling.
 There are a number of methods that depend on your setup.


Well, it's pretty obvious that they aren't using a stock
SendMail:

# telnet mx2.mail.yahoo.com 25
Trying 67.28.113.72...
Connected to mx2.mail.yahoo.com.
Escape character is '^]'.
220 mta309.mail.re4.yahoo.com ESMTP YSmtp service ready

Short of finding an article written by someone 'in the know',
or an answer for someone like that, we can only guess.  I'd
probably start with guessing a big DB on a large SAN;
which pretty much negates the which server to read from
question (up to a point).  Everything else is pretty
academic.  SMTP, IMAP, POP.


Maildir makes it easy to distribute it across multiple machines as
well.



What do you mean exactly? distributing 1 user's mails into seperate
machines? I didnt understand how Maildir helps to this actually.



I am not sure anyone was talking about distributing 1 person's mail  
across separate machines.  The discussion seemed to be how to handle  
large amounts of mail spread out across machines, which maildir helps  
with as you can have one or more file servers and lots of consumers  
(imap/pop) and deliverers (mta) accessing those maildirs on your file  
servers.  Combine with a backend database of some sort (we use an  ldap 
db that includes the path for a specific accounts mail) and voilá.


Chad



Ah sorry, I didnt think it that way for a moment. I thought you meant Maildir
stores mails in seperate files compred to mbox format used by sendmail 
so...anyhow
my mistake :) But it is possible to make changes to sendmail so that it
will store to different folders also.

I think the conclusion is a database, multiple smtp servers querying database
to see where to forward received e-mails, multiple pop3/imap servers querying
database to see from where to read the e-mails and multiple storage machines.
This way it can scale to an unlimited size.

So it requires a lot of coding :)

Thanks,
Evren
___
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to [EMAIL PROTECTED]


Re: e-mail server farm question

2006-05-23 Thread DAve

Evren Yurtesen wrote:

Chad Leigh -- Shire.Net LLC wrote:



On May 23, 2006, at 1:35 AM, Evren Yurtesen wrote:


Vulpes Velox wrote:


On Mon, 22 May 2006 11:54:02 -0500
Kevin Kinsey [EMAIL PROTECTED] wrote:


At 07:17 AM 5/22/2006, Evren Yurtesen wrote:


Hello,

I was wondering how does services like yahoo mail is storing
e-mails. Somehow the smtp server should know where to deliver
the mail inside the system and webmail should know from which
server to read it from.

Does anybody have any practical ideas about how it is done?



Derek Ragona wrote:
 If you are using sendmail, as most FreeBSD users are, you can
 check the sendmail.org site for information on mail handling.
 There are a number of methods that depend on your setup.


Well, it's pretty obvious that they aren't using a stock
SendMail:

# telnet mx2.mail.yahoo.com 25
Trying 67.28.113.72...
Connected to mx2.mail.yahoo.com.
Escape character is '^]'.
220 mta309.mail.re4.yahoo.com ESMTP YSmtp service ready

Short of finding an article written by someone 'in the know',
or an answer for someone like that, we can only guess.  I'd
probably start with guessing a big DB on a large SAN;
which pretty much negates the which server to read from
question (up to a point).  Everything else is pretty
academic.  SMTP, IMAP, POP.


Maildir makes it easy to distribute it across multiple machines as
well.



What do you mean exactly? distributing 1 user's mails into seperate
machines? I didnt understand how Maildir helps to this actually.



I am not sure anyone was talking about distributing 1 person's mail  
across separate machines.  The discussion seemed to be how to handle  
large amounts of mail spread out across machines, which maildir helps  
with as you can have one or more file servers and lots of consumers  
(imap/pop) and deliverers (mta) accessing those maildirs on your file  
servers.  Combine with a backend database of some sort (we use an  
ldap db that includes the path for a specific accounts mail) and voilá.


Chad



Ah sorry, I didnt think it that way for a moment. I thought you meant 
Maildir
stores mails in seperate files compred to mbox format used by sendmail 
so...anyhow

my mistake :) But it is possible to make changes to sendmail so that it
will store to different folders also.

I think the conclusion is a database, multiple smtp servers querying 
database
to see where to forward received e-mails, multiple pop3/imap servers 
querying
database to see from where to read the e-mails and multiple storage 
machines.

This way it can scale to an unlimited size.

So it requires a lot of coding :)



Not really, we have a large system which required little coding except 
for script tools.


We have two FreeBSD servers as public gateways running Sendmail + 
Milter-Ahead + MailScanner. These 'gateways' scan mail for viruses and 
then forward the delivery on to three toasters which are FreeBSD servers 
running qmail + vpopmail + Spamd + SquirrelMail.


The toasters each mount an NFS share from a Sun Enterprise to store the 
mail. Vpopmail answers the validation reqests from Milter-Ahead and gets 
all it's storage/authentication information such as Maildir delivery, 
forwarding, SpamAssassin settings, etc from a common MySQL DB.


All very stock and the system can grow as large as the mail store server 
allows. When it is incapable, we will replace it with a larger machine. 
Just because I know you will ask, the mail store server is raid5, dual 
power supply, dual nic. The gateways, toasters, and mail store all 
communicate via a private network which is 1gb.


It has proven very robust during the past two years.

DAve

--
This message was checked by forty monkeys and
found to not contain any SPAM whatsoever.

Your monkeys may vary
___
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to [EMAIL PROTECTED]


Re: e-mail server farm question

2006-05-23 Thread Iantcho Vassilev

Not really, we have a large system which required little coding except
for script tools.

We have two FreeBSD servers as public gateways running Sendmail +
Milter-Ahead + MailScanner. These 'gateways' scan mail for viruses and
then forward the delivery on to three toasters which are FreeBSD servers
running qmail + vpopmail + Spamd + SquirrelMail.



Why you have chosed sendmail on the gateways?
What are the advangtages..i think it is not the speed?
___
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to [EMAIL PROTECTED]


Re: e-mail server farm question

2006-05-23 Thread DAve

Iantcho Vassilev wrote:

Not really, we have a large system which required little coding except
for script tools.

We have two FreeBSD servers as public gateways running Sendmail +
Milter-Ahead + MailScanner. These 'gateways' scan mail for viruses and
then forward the delivery on to three toasters which are FreeBSD servers
running qmail + vpopmail + Spamd + SquirrelMail.



Why you have chosed sendmail on the gateways?
What are the advangtages..i think it is not the speed?


I've used Sendmail, Postfix, and qmail. Sendmail is the MTA the author 
of MailScanner has the most experience with, so I used it as well.


In my situation, all mail is pushed back out via static routes in 
mailertable to toasters. Sendmail is doing nothing but filling an 
in-queue, and emptying an out-queue.  Pretty simple stuff, everything is 
inbound, speed has not been an issue.


DAve

--
This message was checked by forty monkeys and
found to not contain any SPAM whatsoever.

Your monkeys may vary
___
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to [EMAIL PROTECTED]


Re: e-mail server farm question

2006-05-23 Thread Vulpes Velox
On Tue, 23 May 2006 10:35:51 +0300
Evren Yurtesen [EMAIL PROTECTED] wrote:

 Vulpes Velox wrote:
 
  On Mon, 22 May 2006 11:54:02 -0500
  Kevin Kinsey [EMAIL PROTECTED] wrote:
  
  
 At 07:17 AM 5/22/2006, Evren Yurtesen wrote:
 
 Hello,
 
 I was wondering how does services like yahoo mail is storing
 e-mails. Somehow the smtp server should know where to deliver
 the mail inside the system and webmail should know from which
 server to read it from.
 
 Does anybody have any practical ideas about how it is done?
 
 
 Derek Ragona wrote:
   If you are using sendmail, as most FreeBSD users are, you can
   check the sendmail.org site for information on mail handling.
   There are a number of methods that depend on your setup.
  
 
 Well, it's pretty obvious that they aren't using a stock
 SendMail:
 
 # telnet mx2.mail.yahoo.com 25
 Trying 67.28.113.72...
 Connected to mx2.mail.yahoo.com.
 Escape character is '^]'.
 220 mta309.mail.re4.yahoo.com ESMTP YSmtp service ready
 
 Short of finding an article written by someone 'in the know',
 or an answer for someone like that, we can only guess.  I'd
 probably start with guessing a big DB on a large SAN;
 which pretty much negates the which server to read from
 question (up to a point).  Everything else is pretty
 academic.  SMTP, IMAP, POP.
  
  
  Maildir makes it easy to distribute it across multiple machines as
  well.
 
 What do you mean exactly? distributing 1 user's mails into seperate
 machines? I didnt understand how Maildir helps to this actually.

Maildir is nfs safe and does not require locking. Thus multiple
programs can safely use it.
___
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to [EMAIL PROTECTED]


Re: e-mail server farm question

2006-05-23 Thread Vulpes Velox
On Tue, 23 May 2006 11:26:36 +0300
Evren Yurtesen [EMAIL PROTECTED] wrote:

 Chad Leigh -- Shire.Net LLC wrote:
 
  
  On May 23, 2006, at 1:35 AM, Evren Yurtesen wrote:
  
  Vulpes Velox wrote:
 
  On Mon, 22 May 2006 11:54:02 -0500
  Kevin Kinsey [EMAIL PROTECTED] wrote:
 
  At 07:17 AM 5/22/2006, Evren Yurtesen wrote:
 
  Hello,
 
  I was wondering how does services like yahoo mail is storing
  e-mails. Somehow the smtp server should know where to deliver
  the mail inside the system and webmail should know from which
  server to read it from.
 
  Does anybody have any practical ideas about how it is done?
 
 
  Derek Ragona wrote:
   If you are using sendmail, as most FreeBSD users are, you can
   check the sendmail.org site for information on mail handling.
   There are a number of methods that depend on your setup.
  
 
  Well, it's pretty obvious that they aren't using a stock
  SendMail:
 
  # telnet mx2.mail.yahoo.com 25
  Trying 67.28.113.72...
  Connected to mx2.mail.yahoo.com.
  Escape character is '^]'.
  220 mta309.mail.re4.yahoo.com ESMTP YSmtp service ready
 
  Short of finding an article written by someone 'in the know',
  or an answer for someone like that, we can only guess.  I'd
  probably start with guessing a big DB on a large SAN;
  which pretty much negates the which server to read from
  question (up to a point).  Everything else is pretty
  academic.  SMTP, IMAP, POP.
 
  Maildir makes it easy to distribute it across multiple machines
  as well.
 
 
  What do you mean exactly? distributing 1 user's mails into
  seperate machines? I didnt understand how Maildir helps to this
  actually.
 
  
  I am not sure anyone was talking about distributing 1 person's
  mail across separate machines.  The discussion seemed to be how
  to handle large amounts of mail spread out across machines, which
  maildir helps with as you can have one or more file servers and
  lots of consumers (imap/pop) and deliverers (mta) accessing those
  maildirs on your file servers.  Combine with a backend database
  of some sort (we use an  ldap db that includes the path for a
  specific accounts mail) and voilá.
  
  Chad
  
 
 Ah sorry, I didnt think it that way for a moment. I thought you
 meant Maildir stores mails in seperate files compred to mbox format
 used by sendmail so...anyhow my mistake :) But it is possible to
 make changes to sendmail so that it will store to different folders
 also.

Maildir does store mail in serperate files. Each email is a file.
http://en.wikipedia.org/wiki/Maildir
 
 I think the conclusion is a database, multiple smtp servers
 querying database to see where to forward received e-mails,
 multiple pop3/imap servers querying database to see from where to
 read the e-mails and multiple storage machines. This way it can
 scale to an unlimited size.
 
 So it requires a lot of coding :)

Nah, once you get everything installed and configured it is easy.
Dovecot and qmail are both easy to set up. Then just a bit of shell
scripting for a user adding and removing script.
___
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to [EMAIL PROTECTED]


e-mail server farm question

2006-05-22 Thread Evren Yurtesen

Hello,

I was wondering how does services like yahoo mail is storing e-mails.
Somehow the smtp server should know where to deliver the mail inside the
system and webmail should know from which server to read it from.

Does anybody have any practical ideas about how it is done?

Thanks,
Evren
___
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to [EMAIL PROTECTED]


Re: e-mail server farm question

2006-05-22 Thread Derek Ragona
If you are using sendmail, as most FreeBSD users are, you can check the 
sendmail.org site for information on mail handling.  There are a number of 
methods that depend on your setup.


-Derek

At 07:17 AM 5/22/2006, Evren Yurtesen wrote:

Hello,

I was wondering how does services like yahoo mail is storing e-mails.
Somehow the smtp server should know where to deliver the mail inside the
system and webmail should know from which server to read it from.

Does anybody have any practical ideas about how it is done?

Thanks,
Evren
___
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to [EMAIL PROTECTED]

--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
MailScanner thanks transtec Computers for their support.



--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
MailScanner thanks transtec Computers for their support.

___
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to [EMAIL PROTECTED]


Re: e-mail server farm question

2006-05-22 Thread Kevin Kinsey

At 07:17 AM 5/22/2006, Evren Yurtesen wrote:

Hello,

I was wondering how does services like yahoo mail is storing e-mails.
Somehow the smtp server should know where to deliver the mail inside the
system and webmail should know from which server to read it from.

Does anybody have any practical ideas about how it is done?


Derek Ragona wrote:
 If you are using sendmail, as most FreeBSD users are, you can check
 the sendmail.org site for information on mail handling.  There are a
 number of methods that depend on your setup.


Well, it's pretty obvious that they aren't using a stock
SendMail:

# telnet mx2.mail.yahoo.com 25
Trying 67.28.113.72...
Connected to mx2.mail.yahoo.com.
Escape character is '^]'.
220 mta309.mail.re4.yahoo.com ESMTP YSmtp service ready

Short of finding an article written by someone 'in the know',
or an answer for someone like that, we can only guess.  I'd
probably start with guessing a big DB on a large SAN;
which pretty much negates the which server to read from
question (up to a point).  Everything else is pretty
academic.  SMTP, IMAP, POP.

Kevin Kinsey

--
You never realize how many friends you
have until you rent a house at the beach.

___
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to [EMAIL PROTECTED]


Re: e-mail server farm question

2006-05-22 Thread Vulpes Velox
On Mon, 22 May 2006 11:54:02 -0500
Kevin Kinsey [EMAIL PROTECTED] wrote:

  At 07:17 AM 5/22/2006, Evren Yurtesen wrote:
  Hello,
 
  I was wondering how does services like yahoo mail is storing
  e-mails. Somehow the smtp server should know where to deliver
  the mail inside the system and webmail should know from which
  server to read it from.
 
  Does anybody have any practical ideas about how it is done?
 
 Derek Ragona wrote:
   If you are using sendmail, as most FreeBSD users are, you can
   check the sendmail.org site for information on mail handling.
   There are a number of methods that depend on your setup.
  
 
 Well, it's pretty obvious that they aren't using a stock
 SendMail:
 
 # telnet mx2.mail.yahoo.com 25
 Trying 67.28.113.72...
 Connected to mx2.mail.yahoo.com.
 Escape character is '^]'.
 220 mta309.mail.re4.yahoo.com ESMTP YSmtp service ready
 
 Short of finding an article written by someone 'in the know',
 or an answer for someone like that, we can only guess.  I'd
 probably start with guessing a big DB on a large SAN;
 which pretty much negates the which server to read from
 question (up to a point).  Everything else is pretty
 academic.  SMTP, IMAP, POP.

Maildir makes it easy to distribute it across multiple machines as
well.
___
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to [EMAIL PROTECTED]


Re: E-mail server, minimalist approach

2006-03-26 Thread Vaaf

At 00:08 26.03.2006, Matthew Seaman wrote:

On Sat, Mar 25, 2006 at 09:38:42PM +0100, Vaaf wrote:

 My minimalist approach to using MySQL for instance, is to stay away
 from phpMyAdmin and just create my databases like this:

 CREATE DATABASE IF NOT EXISTS database;
 GRANT USAGE ON database.* TO [EMAIL PROTECTED] IDENTIFIED BY 'password';
 GRANT ALL ON database.* TO [EMAIL PROTECTED];

Ummm... the minimalist approach would only require /two/ lines:

  CREATE DATABASE IF NOT EXISTS database ;
  GRANT ALL ON database.* TO [EMAIL PROTECTED] IDENTIFIED BY 'password' ;

More pertinently, the really big advantage of doing stuff the
command-line way is that you can arrange all this sort of thing as a
series of scripts preserved under CVS or the like.  Takes a little
more effort the first time you do it, then saves you having to
rediscover it all the next or any subsequent time.

   Cheers,

   Matthew

--
Dr Matthew J Seaman MA, D.Phil.   7 Priory Courtyard
  Flat 3
PGP: http://www.infracaninophile.co.uk/pgpkey Ramsgate
  Kent, CT11 9PW


I feel so silly :)
Thank you for pointing that out.

Yes, I am searching the command-line way for having virtual
e-mail users and virtual domains.

I've set up and configured Postfix, Courier-IMAP and SASL.

According to (a revised setup of) high5.net/howto, this is all I need:

CREATE DATABASE IF NOT EXISTS mail;
GRANT ALL ON mail.* TO [EMAIL PROTECTED] IDENTIFIED BY 'fooBehej';

USE mail;
CREATE TABLE IF NOT EXISTS alias (
  address varchar(255) NOT NULL default '',
  goto text NOT NULL,
  domain varchar(255) NOT NULL default '',
  created datetime NOT NULL default '-00-00 00:00:00',
  modified datetime NOT NULL default '-00-00 00:00:00',
  active tinyint(1) NOT NULL default '1',
  PRIMARY KEY (address),
  KEY address (address)
) TYPE=MyISAM COMMENT='Postfix virtual aliases';

USE mail;
CREATE TABLE IF NOT EXISTS domain (
  domain varchar(255) NOT NULL default '',
  description varchar(255) NOT NULL default '',
  aliases int(10) NOT NULL default '0',
  mailboxes int(10) NOT NULL default '0',
  maxquota int(10) NOT NULL default '0',
  transport varchar(255) default NULL,
  backupmx tinyint(1) NOT NULL default '0',
  created datetime NOT NULL default '-00-00 00:00:00',
  modified datetime NOT NULL default '-00-00 00:00:00',
  active tinyint(1) NOT NULL default '1',
  PRIMARY KEY (domain),
  KEY domain (domain)
) TYPE=MyISAM COMMENT='Postfix virtual domains';

USE mail;
CREATE TABLE IF NOT EXISTS mailbox (
  username varchar(255) NOT NULL default '',
  password varchar(255) NOT NULL default '',
  name varchar(255) NOT NULL default '',
  maildir varchar(255) NOT NULL default '',
  quota int(10) NOT NULL default '0',
  domain varchar(255) NOT NULL default '',
  created datetime NOT NULL default '-00-00 00:00:00',
  modified datetime NOT NULL default '-00-00 00:00:00',
  active tinyint(1) NOT NULL default '1',
  PRIMARY KEY (username),
  KEY username (username)
) TYPE=MyISAM COMMENT='Postfix virtual mailboxes';

But then, unfortunately, Postfixadmin to properly govern these.
Aren't there any alternatives?

All the best,
Vaaf

___
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to [EMAIL PROTECTED]


E-mail server, minimalist approach

2006-03-25 Thread Vaaf


Hello!

I am curious about the best practices of hosting other people's e-mails
in FreeBSD, using Postfix and MySQL if necessary.

I used to use Postfixadmin but lately I feel sick when using badly laid out
web user interfaces like that. Maintaining stuff graphically not only makes me
want to change and redesign everything I see---it also makes it difficult for
me to store my configurations in my configuration repository.

Is there a minimalist approach to this?
Any recommendations?

(the following is off topic)

My minimalist approach to using MySQL for instance, is to stay away
from phpMyAdmin and just create my databases like this:

CREATE DATABASE IF NOT EXISTS database;
GRANT USAGE ON database.* TO [EMAIL PROTECTED] IDENTIFIED BY 'password';
GRANT ALL ON database.* TO [EMAIL PROTECTED];

Those are 3 lines that go well into my mysql.txt file, further subjected to
encryption, DVD burning and then burrial somewhere deep inside the
Sahara desert. Thanks folks!

-- Vaaf

___
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to [EMAIL PROTECTED]


Re: E-mail server, minimalist approach

2006-03-25 Thread Matthew Seaman
On Sat, Mar 25, 2006 at 09:38:42PM +0100, Vaaf wrote:

 My minimalist approach to using MySQL for instance, is to stay away
 from phpMyAdmin and just create my databases like this:
 
 CREATE DATABASE IF NOT EXISTS database;
 GRANT USAGE ON database.* TO [EMAIL PROTECTED] IDENTIFIED BY 'password';
 GRANT ALL ON database.* TO [EMAIL PROTECTED];

Ummm... the minimalist approach would only require /two/ lines:

  CREATE DATABASE IF NOT EXISTS database ; 
  GRANT ALL ON database.* TO [EMAIL PROTECTED] IDENTIFIED BY 'password' ;

More pertinently, the really big advantage of doing stuff the
command-line way is that you can arrange all this sort of thing as a
series of scripts preserved under CVS or the like.  Takes a little
more effort the first time you do it, then saves you having to
rediscover it all the next or any subsequent time.

   Cheers,

   Matthew

-- 
Dr Matthew J Seaman MA, D.Phil.   7 Priory Courtyard
  Flat 3
PGP: http://www.infracaninophile.co.uk/pgpkey Ramsgate
  Kent, CT11 9PW
___
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to [EMAIL PROTECTED]


Re: New FreeBSD 5.3 e-mail server extremely slow - traced to getpwnam maybe ?

2005-01-05 Thread Bruce Campbell
Quoting Kris Kennaway [EMAIL PROTECTED]:

 On Tue, Jan 04, 2005 at 09:27:27PM -0500, Bruce Campbell wrote:
 
  I wrote a small program:
  
#include sys/types.h
#include pwd.h
  
main( int argc, char *argv[] )
{
getpwuid( 13076 );
}
  
  and ran it under truss on 5.x and it generated 178,711 lines of output.
  (the bulk of which is those lseek/read calls as above)
  ...
 
 Try tuning the pwd_mkdb parameters (see hash(3)) in
 /usr/src/usr.sbin/pwd_mkdb/pwd_mkdb.c and recompile:
 
 HASHINFO openinfo = {
 4096,   /* bsize */
 32, /* ffactor */
 256,/* nelem */
 2048 * 1024,/* cachesize */
 NULL,   /* hash() */
 0   /* lorder */
 };
 
 e.g. adjust nelem to 12000 to accomodate your
 significantly-larger-than-average password database.  If this helps,
 please submit a PR requesting that someone make an option to pwd_mkdb
 to tune this at runtime (or better yet, submit the patch to do this
 yourself - it's straightforward to modify the source to do this).

Thanks.  That had no effect on the large number of seeks/reads
to do a getpwuid of a specific uid.  I tried boosting that
number further, still no change.  I suspect the problem is related
to some change to the hash functions between 4.7 and 5.2.1 and I
hope to get to the bottom of it today.

I tried two getpwnam (as opposed to getpwuid) calls on 2 different userids, one
took 1000 seek/reads, the other 16,000, so it's all
pretty random, no doubt related to how stuff gets hashed.  On
4.7 it takes just one or two reads/seeks.

As each login via ipop, imap, and each sendmail, and just about everything
will be doing getpwnam's I think this is our problem.

-- 
Bruce Campbell
Engineering Computing
CPH-2374B
University of Waterloo
(519)888-4567 ext 5889


This mail sent through www.mywaterloo.ca
___
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to [EMAIL PROTECTED]


Re: New FreeBSD 5.3 e-mail server extremely slow - traced to getpwnam maybe ?

2005-01-05 Thread Bruce Campbell
Quoting Bruce Campbell [EMAIL PROTECTED]:
  On Tue, Jan 04, 2005 at 09:27:27PM -0500, Bruce Campbell wrote:
  
   I wrote a small program:
   
 #include sys/types.h
 #include pwd.h
   
 main( int argc, char *argv[] )
 {
 getpwuid( 13076 );
 }
   
   and ran it under truss on 5.x and it generated 178,711 lines of output.
   (the bulk of which is those lseek/read calls as above)

It looks like the overhaul of getpwent Apr/2003 to make it thread safe:

  http://www.freebsd.org/cgi/cvsweb.cgi/src/lib/libc/gen/getpwent.c

may be the problem.

I've tested the dbm_fetch function independently on a large
file, and it is fine.

I've opened a bug report, and plan to build a replacement 4.x
mail server, as the most deterministic path to restoring
adequate e-mail service to our users.

Can anyone suggest a workaround ?

-- 
Bruce Campbell
Engineering Computing
CPH-2374B
University of Waterloo
(519)888-4567 ext 5889


This mail sent through www.mywaterloo.ca
___
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to [EMAIL PROTECTED]


Re: New FreeBSD 5.3 e-mail server extremely slow - traced to getpwnam maybe ?

2005-01-05 Thread Bruce Campbell
Quoting Bruce Campbell [EMAIL PROTECTED]:
 Quoting Bruce Campbell [EMAIL PROTECTED]:
   On Tue, Jan 04, 2005 at 09:27:27PM -0500, Bruce Campbell wrote:
   
I wrote a small program:

  #include sys/types.h
  #include pwd.h

  main( int argc, char *argv[] )
  {
  getpwuid( 13076 );
  }

and ran it under truss on 5.x and it generated 178,711 lines of output.
(the bulk of which is those lseek/read calls as above)
 
 It looks like the overhaul of getpwent Apr/2003 to make it thread safe:
 
   http://www.freebsd.org/cgi/cvsweb.cgi/src/lib/libc/gen/getpwent.c
 
 may be the problem.
 
 I've tested the dbm_fetch function independently on a large
 file, and it is fine.
 
 I've opened a bug report, and plan to build a replacement 4.x
 mail server, as the most deterministic path to restoring
 adequate e-mail service to our users.
 
 Can anyone suggest a workaround ?

Well, somewhat unbelievably, copying a getpwent.c from 4.7
and remaking libc on 5.3 with it worked.  Load average
has gone from 70 to 2.

And, so that this qualifies as a question...

Am I crazy to pull an old getpwnam from 4.7 and blindly
build it on 5.3 ?

-- 
Bruce Campbell
Engineering Computing
CPH-2374B
University of Waterloo
(519)888-4567 ext 5889


This mail sent through www.mywaterloo.ca
___
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to [EMAIL PROTECTED]


Re: New FreeBSD 5.3 e-mail server extremely slow - traced to getpwnam maybe ?

2005-01-05 Thread Bruce Campbell
Quoting Bruce Campbell [EMAIL PROTECTED]:
 ...
 Well, somewhat unbelievably, copying a getpwent.c from 4.7
 and remaking libc on 5.3 with it worked.  Load average
 has gone from 70 to 2.
 

One of my co-workers has found a less kludgey workaround
for the high load problem we were seeing on 5.3 with
large /etc/master.passwd, as follows:

--- /etc/nsswitch.conf.old  Wed Jan  5 19:23:24 2005
+++ /etc/nsswitch.conf  Wed Jan  5 19:23:43 2005
@@ -1,7 +1,7 @@
-group: compat
+group: files
 group_compat: nis
 hosts: files dns
 networks: files
-passwd: compat
+passwd: files
 passwd_compat: nis
 shells: files

System is purring with load average under 1 now,
200,000 pop/imap sessions per day and 200,000 e-mails
per day, all spamassassinated.

For more details and ongoing followup, see:

  http://www.freebsd.org/cgi/query-pr.cgi?pr=75855

-- 
Bruce Campbell
Engineering Computing
CPH-2374B
University of Waterloo
(519)888-4567 ext 5889


This mail sent through www.mywaterloo.ca
___
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to [EMAIL PROTECTED]


New FreeBSD 5.3 e-mail server extremely slow...

2005-01-04 Thread Bruce Campbell

We upgraded from a dual 1.66GHz AMD running FreeBSD 4.7
and a dual 3GHz Xeon running FreeBSD 5.3 and the new server
is painfully slow, even after turning spamassassin 
and yavr (yet another virus recipe) off.  Load
appears to be imapd/ipop3d (uw-imapd) related.
New server is Adaptec SCSI RAID, old one was 3ware ATA RAID,
but disk load is relatively low anyway.

It is a fairly high volume server, maybe 150,000 messages
per day and 150,000 pop/imap sessions per day.  But the old
box was doing relatively fine.

Turning off hyperthreading helped alot, but not enough.

load average is around 48 now, I've set the 2 sendmail
conf load av settings to 48 so at least e-mail gets in.

A quick truss of an ipop3d process shows piles
of this streaming by...

setitimer(0,{0 0, 0 0},{0 0, 599 92})= 0 (0x0)
write(1,0x805a000,21)= 21 (0x15)
gettimeofday({1104857422 906783},0x0)= 0 (0x0)
setitimer(0,{0 0, 600 0},{0 0, 0 0}) = 0 (0x0)
read(0x0,0x8063000,0x832c)   = 10 (0xa)
setitimer(0,{0 0, 0 0},{0 0, 600 0}) = 0 (0x0)
write(1,0x805a000,14)= 14 (0xe)
gettimeofday({1104857422 908916},0x0)= 0 (0x0)
setitimer(0,{0 0, 600 0},{0 0, 0 0}) = 0 (0x0)

top shows 80-90% system activity.

About to revert to our old box and maybe nfs mount
/var/mail to make it less painless.  Any suggestions ?

-- 
Bruce Campbell
Engineering Computing
CPH-2374B
University of Waterloo
(519)888-4567 ext 5889


This mail sent through www.mywaterloo.ca
___
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to [EMAIL PROTECTED]


Re: New FreeBSD 5.3 e-mail server extremely slow...

2005-01-04 Thread Kris Kennaway
On Tue, Jan 04, 2005 at 12:38:48PM -0500, Bruce Campbell wrote:
 
 We upgraded from a dual 1.66GHz AMD running FreeBSD 4.7
 and a dual 3GHz Xeon running FreeBSD 5.3 and the new server
 is painfully slow, even after turning spamassassin 
 and yavr (yet another virus recipe) off.  Load
 appears to be imapd/ipop3d (uw-imapd) related.

Same version as you were running before?  Same configuration files?

Can you show us your kernel configuration and dmesg?

Kris

pgpUpAMPoKDD3.pgp
Description: PGP signature


Re: New FreeBSD 5.3 e-mail server extremely slow...

2005-01-04 Thread Bruce Campbell
Quoting Kris Kennaway [EMAIL PROTECTED]:

 On Tue, Jan 04, 2005 at 12:38:48PM -0500, Bruce Campbell wrote:
  
  We upgraded from a dual 1.66GHz AMD running FreeBSD 4.7
  and a dual 3GHz Xeon running FreeBSD 5.3 and the new server
  is painfully slow, even after turning spamassassin 
  and yavr (yet another virus recipe) off.  Load
  appears to be imapd/ipop3d (uw-imapd) related.
 
 Same version as you were running before?  Same configuration files?

Well, no, not quite.

old: imap-uw-2002_1,1
new: imap-uw-2004a,1

Just about all packages have undergone some updates on our
new server.  The only processes for which we have hundreds
running would be sendmail, procmail, ipop3d and imapd.
But, when I had the sendmail conf'ed to shutdown mail
when load av went over 12, load av would still shoot
up to 40 or 50 and stay there, and only major processes were imapd, ipop3d.
And I noticed them calling setitimer alot, and 80% system usage.

I'm about to pull the zero channel adaptec scsi raid card, for no other reason
than I'm out of bright ideas.

 
 Can you show us your kernel configuration and dmesg?
 
 Kris

old: (difference from 4.7 GENERIC)

- cpu   I386_CPU
- cpu   I486_CPU
+ optionsQUOTA   #enable disk quotas
+ options   SMP # Symmetric MultiProcessor Kernel
+ options   APIC_IO # Symmetric (APIC) I/O

new: (difference from 5.3 GENERIC)

Reverted to non SMP for now, only difference from GENERIC is...

 options   QUOTA

I did have 

 options   SMP

going for a while.  Removing SMP has made no difference in load
or responsiveness.  Actually seems slightly better on one CPU.

dmesg.boot from new system is as follows:

Copyright (c) 1992-2004 The FreeBSD Project.
Copyright (c) 1979, 1980, 1983, 1986, 1988, 1989, 1991, 1992, 1993, 1994
The Regents of the University of California. All rights reserved.
FreeBSD 5.3-RELEASE #0: Thu Nov 25 15:48:15 EST 2004
[EMAIL PROTECTED]:/usr/src/sys/i386/compile/MAIL_SERVER
Timecounter i8254 frequency 1193182 Hz quality 0
CPU: Intel(R) Xeon(TM) CPU 3.06GHz (3065.80-MHz 686-class CPU)
  Origin = GenuineIntel  Id = 0xf27  Stepping = 7
  
Features=0xbfebfbffFPU,VME,DE,PSE,TSC,MSR,PAE,MCE,CX8,APIC,SEP,MTRR,PGE,MCA,CMO
V,PAT,PSE36,CLFLUSH,DTS,ACPI,MMX,FXSR,SSE,SSE2,SS,HTT,TM,PBE
  Hyperthreading: 2 logical CPUs
real memory  = 2146959360 (2047 MB)
avail memory = 2095419392 (1998 MB)
ACPI APIC Table: PTLTD  APIC  
ioapic0 Version 2.0 irqs 0-23 on motherboard
ioapic1 Version 2.0 irqs 24-47 on motherboard
ioapic2 Version 2.0 irqs 48-71 on motherboard
npx0: [FAST]
npx0: math processor on motherboard
npx0: INT 16 interface
acpi0: PTLTD   RSDT on motherboard
acpi0: Power Button (fixed)
Timecounter ACPI-fast frequency 3579545 Hz quality 1000
acpi_timer0: 24-bit timer at 3.579545MHz port 0x1008-0x100b on acpi0
cpu0: ACPI CPU (2 Cx states) on acpi0
pcib0: ACPI Host-PCI bridge port 0xcf8-0xcff on acpi0
pci0: ACPI PCI bus on pcib0
pci0: unknown at device 0.1 (no driver attached)
pcib1: ACPI PCI-PCI bridge at device 2.0 on pci0
pcib1: could not get PCI interrupt routing table for \\_SB_.PCI0.HLB_ - 
AE_NOT_FOU
ND
pci1: ACPI PCI bus on pcib1
pci1: base peripheral, interrupt controller at device 28.0 (no driver 
attached)
pcib2: ACPI PCI-PCI bridge at device 29.0 on pci1
pci2: ACPI PCI bus on pcib2
em0: Intel(R) PRO/1000 Network Connection, Version - 1.7.35 port 
0x3000-0x303f m
em 0xf820-0xf821 irq 54 at device 3.0 on pci2
em0: Ethernet address: 00:30:48:29:c5:a8
em0:  Speed:N/A  Duplex:N/A
em1: Intel(R) PRO/1000 Network Connection, Version - 1.7.35 port 
0x3040-0x307f m
em 0xf822-0xf823 irq 55 at device 3.1 on pci2
em1: Ethernet address: 00:30:48:29:c5:a9
em1:  Speed:N/A  Duplex:N/A
pci1: base peripheral, interrupt controller at device 30.0 (no driver 
attached)
pcib3: ACPI PCI-PCI bridge at device 31.0 on pci1
pci3: ACPI PCI bus on pcib3
asr0: Adaptec Caching SCSI RAID mem 
0xfc00-0xfdff,0xfb00-0xfbff,
0xf830-0xf83f irq 30 at device 3.0 on pci3
asr0: [GIANT-LOCKED]
asr0: ADAPTEC 2015S FW Rev. 3B05, 2 channel, 256 CCBs, Protocol I2O
uhci0: Intel 82801CA/CAM (ICH3) USB controller USB-A port 0x2000-0x201f irq 
16 a
t device 29.0 on pci0
uhci0: [GIANT-LOCKED]
usb0: Intel 82801CA/CAM (ICH3) USB controller USB-A on uhci0
usb0: USB revision 1.0
uhub0: Intel UHCI root hub, class 9/0, rev 1.00/1.00, addr 1
uhub0: 2 ports with 2 removable, self powered
uhci1: Intel 82801CA/CAM (ICH3) USB controller USB-B port 0x2020-0x203f irq 
19 a
t device 29.1 on pci0
uhci1: [GIANT-LOCKED]
usb1: Intel 82801CA/CAM (ICH3) USB controller USB-B on uhci1
usb1: USB revision 1.0
uhub1: Intel UHCI root hub, class 9/0, rev 1.00/1.00, addr 1
uhub1: 2 ports with 2 removable, self powered
uhci2: Intel 82801CA/CAM (ICH3) USB controller USB-C port 0x2040-0x205f irq 
18 a
t device 29.2 on pci0
uhci2: [GIANT-LOCKED]
usb2: Intel 82801CA/CAM (ICH3) USB controller USB-C on uhci2
usb2: USB 

Re: New FreeBSD 5.3 e-mail server extremely slow...

2005-01-04 Thread Timothy Luoma
On Jan 4, 2005, at 4:45 PM, Bruce Campbell wrote:
The only processes for which we have hundreds running would be 
sendmail, procmail, ipop3d and imapd.
I love procmail and would hate to live w/o it, but that would be my 
first suspect out of that list.

TjL
who once got a phone call from his ISP because of his .procmailrc 
(oops!)

___
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to [EMAIL PROTECTED]


Re: New FreeBSD 5.3 e-mail server extremely slow...

2005-01-04 Thread Kris Kennaway
On Tue, Jan 04, 2005 at 04:45:16PM -0500, Bruce Campbell wrote:
 Quoting Kris Kennaway [EMAIL PROTECTED]:
 
  On Tue, Jan 04, 2005 at 12:38:48PM -0500, Bruce Campbell wrote:
   
   We upgraded from a dual 1.66GHz AMD running FreeBSD 4.7
   and a dual 3GHz Xeon running FreeBSD 5.3 and the new server
   is painfully slow, even after turning spamassassin 
   and yavr (yet another virus recipe) off.  Load
   appears to be imapd/ipop3d (uw-imapd) related.
  
  Same version as you were running before?  Same configuration files?
 
 Well, no, not quite.
 
 old: imap-uw-2002_1,1
 new: imap-uw-2004a,1

OK, that's where you should start, then.  Go back to the software
configuration that you know is working and see if it still misbehaves.

Kris

pgp4Ak9FEHcLW.pgp
Description: PGP signature


Re: New FreeBSD 5.3 e-mail server extremely slow...

2005-01-04 Thread Colin J. Raven
On Jan 4 at 16:58, Timothy Luoma launched this into the bitstream:
On Jan 4, 2005, at 4:45 PM, Bruce Campbell wrote:
The only processes for which we have hundreds running would be sendmail, 
procmail, ipop3d and imapd.
I love procmail and would hate to live w/o it, but that would be my first 
suspect out of that list.

TjL
who once got a phone call from his ISP because of his .procmailrc (oops!)
You too eh? :-)
-Colin
(who just *knows* it was _that_ special recipe on the procmail list 
that did us both in on the same day!!)
Sorta like a digital Montezuma's revenge [shudder] sorry, couldn't 
resist.
___
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to [EMAIL PROTECTED]


Re: New FreeBSD 5.3 e-mail server extremely slow - traced to getpwnam maybe ?

2005-01-04 Thread Bruce Campbell
Quoting Kris Kennaway [EMAIL PROTECTED]:
  Well, no, not quite.
  
  old: imap-uw-2002_1,1
  new: imap-uw-2004a,1
 
 OK, that's where you should start, then.  Go back to the software
 configuration that you know is working and see if it still misbehaves.
 
 Kris

Thanks.  I shutdown imapd/ipop3d completely so I just had sendmail running, and 
still
load av. was 20-30.

Anyways, I have just found something very odd with both 5.2.1 and 5.3
on multiple different systems here, including a brand new GENERIC install.

On 5.x, ls -l or ps waux is very slow with our
/etc/master.passwd which has 11320 entries.  I truss'ed
those commands, and gave up after watching :

  lseek(4,0x17d000,SEEK_SET)   = 1560576 (0x17d000)
  read(0x4,0x8074000,0x1000)   = 4096 (0x1000)
  lseek(4,0x17e000,SEEK_SET)   = 1564672 (0x17e000)
  read(0x4,0x8062000,0x1000)   = 4096 (0x1000)
  lseek(4,0x17f000,SEEK_SET)   = 1568768 (0x17f000)
  read(0x4,0x8066000,0x1000)   = 4096 (0x1000)
  lseek(4,0x18,SEEK_SET)   = 1572864 (0x18)

scroll by for 10 minutes.  (handle 4 = /etc/spwd.db)

I wrote a small program:

  #include sys/types.h
  #include pwd.h

  main( int argc, char *argv[] )
  {
  getpwuid( 13076 );
  }

and ran it under truss on 5.x and it generated 178,711 lines of output.
(the bulk of which is those lseek/read calls as above)

4.7 (with same master.passwd file) gave 59 lines of output, which seems
normal.

I'm speculating that imap and sendmail and just about everything use
getpwuid and getpwuid is misbehaving on 5.x especially with a large
master.passwd file.

I will report this through the proper mechanism once I do
just a bit more testing.  And perhaps it is a known issue
already and I'll look into that also.  Or perhaps I have messed
something up unwittingly, which I have been known to do.

We do have an extremely busy 5.2.1 system running here fine on
the same hardware, just it has a small /etc/master.passwd which may explain that
systems success to date.

Thank you to everyone who sent suggestions.

-- 
Bruce Campbell
Engineering Computing
CPH-2374B
University of Waterloo
(519)888-4567 ext 5889


This mail sent through www.mywaterloo.ca
___
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to [EMAIL PROTECTED]


Re: New FreeBSD 5.3 e-mail server extremely slow - traced to getpwnam maybe ?

2005-01-04 Thread Kris Kennaway
On Tue, Jan 04, 2005 at 09:27:27PM -0500, Bruce Campbell wrote:

 I wrote a small program:
 
   #include sys/types.h
   #include pwd.h
 
   main( int argc, char *argv[] )
   {
   getpwuid( 13076 );
   }
 
 and ran it under truss on 5.x and it generated 178,711 lines of output.
 (the bulk of which is those lseek/read calls as above)
 
 4.7 (with same master.passwd file) gave 59 lines of output, which seems
 normal.
 
 I'm speculating that imap and sendmail and just about everything use
 getpwuid and getpwuid is misbehaving on 5.x especially with a large
 master.passwd file.

Try tuning the pwd_mkdb parameters (see hash(3)) in
/usr/src/usr.sbin/pwd_mkdb/pwd_mkdb.c and recompile:

HASHINFO openinfo = {
4096,   /* bsize */
32, /* ffactor */
256,/* nelem */
2048 * 1024,/* cachesize */
NULL,   /* hash() */
0   /* lorder */
};

e.g. adjust nelem to 12000 to accomodate your
significantly-larger-than-average password database.  If this helps,
please submit a PR requesting that someone make an option to pwd_mkdb
to tune this at runtime (or better yet, submit the patch to do this
yourself - it's straightforward to modify the source to do this).

Kris


pgpAjUrFD81hG.pgp
Description: PGP signature


Re: E-mail server

2002-11-25 Thread Jim Durham
On Saturday 23 November 2002 10:30 pm, Damien Hull wrote:
 I've decided to use squirrelmail as my web based mail client. Because I
 get a lot of mail I need a way of sorting my mail through squirrelmail.
 For this the squirrelmail people have provided a procmail interface.

 The problem with the procmail interface is that it uses ftp to change
 the users procmail settings.

 Is there another way of sorting mail through squirrelmail or any other
 web based mail client? I don't want to run ftp on my server.

I'm not sure exactly what your setup is, but, all you are doing is changing 
each user's .procmailrc file. I assume that hacking squirrelmail to use a 
more secure protocol like scp is not easily done, so perhaps you would be 
better off writing an HTML form that inputs the rules each user wants to 
implement and then write some PHP code to formulate the rules in .procmailrc 
format and scp to transfer them to the user's .promailrc file. If you use 
private/public key encryption with private and public keys, you can make this 
seamless (not ask for a password for each transfer, etc).

Well.it's one way of doing it...you may get better answers.
-Jim

To Unsubscribe: send mail to [EMAIL PROTECTED]
with unsubscribe freebsd-questions in the body of the message



E-mail server

2002-11-23 Thread Damien Hull
I've decided to use squirrelmail as my web based mail client. Because I
get a lot of mail I need a way of sorting my mail through squirrelmail.
For this the squirrelmail people have provided a procmail interface. 

The problem with the procmail interface is that it uses ftp to change
the users procmail settings. 

Is there another way of sorting mail through squirrelmail or any other
web based mail client? I don't want to run ftp on my server.




To Unsubscribe: send mail to [EMAIL PROTECTED]
with unsubscribe freebsd-questions in the body of the message



E-mail server

2002-11-16 Thread Damien Hull
I need some help setting up an E-mail server. I've done this before but
not something this big. Heres what will need.

1. The server will have about 4000 users and will need room to grow.

2. Each user should have a limet on the amount of E-mail they can store
on the server. I don't know how much space each user will get but lets
use 5mb for now. 

3. This will be a pop3 server.

4. The hardware we were planing on using runs at 400mhz and has a 10gig
drive. I'd like to up that to a 20gig drive. RAM will be 128 or more.

5. We need to transfer user accounts from the failing Windows E-mail
server over to the rocking FreeBSD box. 

That's it! I can setup just about all of it but steps 2 and 5 I know
nothing about. Also, if any of you think this box will not work in any
way or you have a few tips on making it better pleas let me know. The
last thing I want is for 4000 people to call up asking where their
E-mail went. 




To Unsubscribe: send mail to [EMAIL PROTECTED]
with unsubscribe freebsd-questions in the body of the message



Re: E-mail server

2002-11-16 Thread Damien Hull
I was planing on using qmail and qpopper. I'm a postfix user so I've got
some reading to do. Don't know if we will install sqwebmail but we
could. 

Vpopmail is new to me. I checked out their website and it looks good but
I don't know if will need it. I'm helping someone else build this E-mail
server and I don't know if there will be other domains the box will be
collecting mail for. 

Thanks for the info!

On Fri, 2002-11-15 at 23:18, Unix Tools wrote:
 Hi,
 use qmail quite robust
 1) qmail
 2) vpopmail
 3) sqwebmail
 
 QUITE A GOOD COMBINATION.
 
 - Original Message - 
 From: Damien Hull [EMAIL PROTECTED]
 To: [EMAIL PROTECTED]
 Sent: Sunday, November 17, 2002 01:26 AM
 Subject: E-mail server
 
 
  I need some help setting up an E-mail server. I've done this before but
  not something this big. Heres what will need.
  
  1. The server will have about 4000 users and will need room to grow.
  
  2. Each user should have a limet on the amount of E-mail they can store
  on the server. I don't know how much space each user will get but lets
  use 5mb for now. 
  
  3. This will be a pop3 server.
  
  4. The hardware we were planing on using runs at 400mhz and has a 10gig
  drive. I'd like to up that to a 20gig drive. RAM will be 128 or more.
  
  5. We need to transfer user accounts from the failing Windows E-mail
  server over to the rocking FreeBSD box. 
  
  That's it! I can setup just about all of it but steps 2 and 5 I know
  nothing about. Also, if any of you think this box will not work in any
  way or you have a few tips on making it better pleas let me know. The
  last thing I want is for 4000 people to call up asking where their
  E-mail went. 
  
  
  
  
  To Unsubscribe: send mail to [EMAIL PROTECTED]
  with unsubscribe freebsd-questions in the body of the message
  



To Unsubscribe: send mail to [EMAIL PROTECTED]
with unsubscribe freebsd-questions in the body of the message