[ale] Anyone have experience hosting email for multiple domains?

[Brandon Checketts]

Richard,

It looks like you postfix is trying to authenticate with saslauthd
instead of doing it directly via SQL.  Check the contents of
/usr/lib/sasl2/smtpd.conf (Actual location may change depending on
distro).  It should contains something like:

[root at secure /]# cat /usr/lib/sasl2/smtpd.conf
pwcheck_method: auxprop
mech_list:      PLAIN LOGIN
auxprop_plugin: sql
sql_verbose:    yes
sql_engine:     mysql
sql_hostnames:  localhost
sql_user:       [username]
sql_passwd:     [password]
sql_database:   [dbname]
sql_select:     SELECT password FROM mailbox WHERE username = '%u@%r'


Thanks,
Brandon Checketts


Richard Bronosky wrote:
> Brandon,
> I can't get smtp authentication to hit the DB. I get failures to auth,
> but mysql never logs any queries. (the first entry verifies that I
> have the general query log enabled:
> 
> tail -f /var/log/messages /var/log/maillog /var/log/mysqld.log
> ==> /var/log/mysqld.log <==
>                       2 Query       select version()
> 
> ==> /var/log/maillog <==
> Sep 16 07:26:33 primary postfix/smtpd[16453]: connect from
> mail-iw0-f198.google.com[209.85.223.198]
> Sep 16 07:26:33 primary postfix/smtpd[16453]: setting up TLS
> connection from mail-iw0-f198.google.com[209.85.223.198]
> Sep 16 07:26:33 primary postfix/smtpd[16453]: TLS connection
> established from mail-iw0-f198.google.com[209.85.223.198]: TLSv1 with
> cipher RC4-MD5 (128/128 bits)
> 
> ==> /var/log/messages <==
> Sep 16 07:26:35 primary saslauthd[15623]: do_auth         : auth
> failure: [user=emailsender] [service=smtp] [realm=bronosky.com]
> [mech=pam] [reason=PAM auth error]
> 
> ==> /var/log/maillog <==
> Sep 16 07:26:35 primary postfix/smtpd[16453]: warning: SASL
> authentication failure: Password verification failed
> Sep 16 07:26:35 primary postfix/smtpd[16453]: warning:
> mail-iw0-f198.google.com[209.85.223.198]: SASL PLAIN authentication
> failed: authentication failure
> Sep 16 07:26:35 primary postfix/smtpd[16453]: disconnect from
> mail-iw0-f198.google.com[209.85.223.198]
> 
> 
> .!# RichardBronosky #!.
> 
> 
> 
> On Mon, Aug 31, 2009 at 2:58 PM, Brandon Checketts
> <brandon at brandonchecketts.com> wrote:
>> Great.  Glad it helped.
>>
>> Thanks,
>> Brandon Checketts
>>
>>
>> Richard Bronosky wrote:
>>> Brandon, that knocked it out of the park. I've just skimmed it so far,
>>> but you have the best documentation I've seen. I'm so glad I asked.
>>> You just blew my mind... Like a Boss!
>>>
>>> On Mon, Aug 31, 2009 at 11:16 AM, Brandon
>>> Checketts<brandon at brandonchecketts.com> wrote:
>>>> I run a mail hosting service using Postfix and Dovecot and have a howto
>>>> set up at http://www.brandonchecketts.com/centos-mail-toaster.php  that
>>>> details the basic configuration.   I use that about once a month when
>>>> setting it up for somebody else and make small changes as new package
>>>> versions are released, so it should be pretty accurate and  I know it
>>>> works on CentOS 5.3.   Account credentials are stored in a MySQL backend
>>>> and it uses PostfixAdmin to manage the database of users.  I run several
>>>> hundred mailboxes off of it, and it works out great.
>>>>
>>>> Thanks,
>>>> Brandon Checketts
>>>>
>>>>
>>>>
>>>>
>>>> Richard Bronosky wrote:
>>>>> I'd like to avoid reliving your horror stories. I'm a big fan of
>>>>> "learn from the mistakes of other, don't make them yourself." So far I
>>>>> have installed postfix and dovecot on a CentOS 5.3 slicehost slice.
>>>>> Here are my needs (which I will compromise on if I must):
>>>>> 1. Forward email for at least 8 domains to other services (mostly Gmail).
>>>>> 2. Act as a secure sendmail server so that Gmail will send _from_ my
>>>>> domain, not _on behalf of_ my domain.
>>>>> 3. Act as 'final destination' for at least 1 domain.
>>>>> 4. Server IMAP for final destination domain[s].
>>>>>
>>>>> So, any advice, good reads, etc.? I have worked through
>>>>> http://wiki.centos.org/HowTos/postfix and am going through
>>>>> http://www.postfix.org/VIRTUAL_README.html I haven't started with
>>>>> http://wiki.dovecot.org/VirtualUsers so I don't know if I need that
>>>>> yet.
>>>>>
>>>> _______________________________________________
>>>> Ale mailing list
>>>> Ale at ale.org
>>>> http://mail.ale.org/mailman/listinfo/ale
>>>>
>>>
>>>
>> _______________________________________________
>> Ale mailing list
>> Ale at ale.org
>> http://mail.ale.org/mailman/listinfo/ale
>>
> 
> _______________________________________________
> Ale mailing list
> Ale at ale.org
> http://mail.ale.org/mailman/listinfo/ale