From: Victor Duchovni (Victor.DuchovniMorganStanley.com)
Date: Fri Dec 01 2006 - 09:39:34 CST

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

On Fri, Dec 01, 2006 at 10:54:59AM +0100, Rocco Scappatura wrote:

> virtual_alias_maps =
> proxy:mysql:/etc/postfix/virtual_alias.cf
>
> while I think the major of connection come from lookup in mailbox table..

Because smtpd does virtual(5) lookups during recipient validation, and
it is not uncommon to have hundreds of running smtpd processes that can
overwhelm the MySQL server.

Because cleanup does virtual(5) lookups during address rewriting, and
it is not uncommon to have hundreds of running cleanup processes that
can overwhelm the MySQL server.

> virtual_mailbox_maps = mysql:/etc/postfix/mysql-virtual-maps.cf
>
> where /etc/postfix/mysql-virtual-maps.cf contains the username and password for POP3/POP3-SSL/IMAP/IMAP-SSL authentication.

This table has nothing to do with usernames/passwords, it stores mailbox
paths.

--
        Viktor.

Disclaimer: off-list followups get on-list replies or get ignored.
Please do not ignore the "Reply-To" header.

To unsubscribe from the postfix-users list, visit
http://www.postfix.org/lists.html or click the link below:
<mailto:majordomopostfix.org?body=unsubscribe%20postfix-users>

If my response solves your problem, the best way to thank me is to not
send an "it worked, thanks" follow-up. If you must respond, please put
"It worked, thanks" in the "Subject" so I can delete these quickly.

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]