Re: [HELP] Postfix v2 + SASL2 + MySQL
On Sat, Jan 29, 2005 at 09:06:31PM -0500, Bob Billson wrote:
hi,
[...]
BB> I've been at this all day and not making any progress. Can anyone get me
BB> pointed in right direction? I would really appreciate it! :-) If you
BB> need more info to help out, let me know.
I've had the same problemes some days ago (although it was a
gentoo-server)
BB> /etc/default/saslauthd (NOTE: Searching Google brings up conflicting
BB> instructions on what this file should have. Some comments seem to
BB> believe that saslauthd doesn't need to be automagically started for
BB> Postfix v2 + SASL2. Others disagree. It's confusing.):
there are several ways: i think if you want to use pam (then you can
have encrypted passwords in the database) you must use saslauthd which
uses pam. if you don't need crypted passwords in the database i think
you don't need the saslauthd because postfix speaks directly with the
database (in sasl1 and some early version of sasl2 you didn't need the
saslauthd to use pam too)
[...]
BB> smtpd_sasl_auth_enable = yes
BB> smtpd_sasl_security_options = noanonymous
BB> smtpd_sasl_local_domain = $myhostname
BB> broken_sasl_auth_clients = yes
BB> unknown_local_recipient_reject_code = 550
BB> inet_interfaces = all
BB> smtpd_sasl_application_name = smtpd
change
smtpd_sasl_local_domain = $myhostname
to
smtpd_sasl_local_domain =
=
see below why
[...]
BB> Jan 29 20:18:53 pigpen postfix/smtpd[22508]: sql auxprop plugin using mysql engine
BB> Jan 29 20:18:53 pigpen postfix/smtpd[22508]: connect from web1.elbnet.com[65.209.12.165]
BB> Jan 29 20:20:18 pigpen postfix/smtpd[22508]: sql plugin Parse the username test@example.com@smtp.theshed.dhs.org
BB> Jan 29 20:20:18 pigpen postfix/smtpd[22508]: sql plugin try and connect to a host
BB> Jan 29 20:20:18 pigpen postfix/smtpd[22508]: sql plugin trying to open db 'provider' on host '127.0.0.1'
BB> Jan 29 20:20:18 pigpen postfix/smtpd[22508]: sql plugin Parse the username test@example.com@smtp.theshed.dhs.org
BB> Jan 29 20:20:18 pigpen postfix/smtpd[22508]: sql plugin try and connect to a host
BB> Jan 29 20:20:18 pigpen postfix/smtpd[22508]: sql plugin trying to open db 'provider' on host '127.0.0.1'
BB> Jan 29 20:20:18 pigpen postfix/smtpd[22508]: begin transaction
BB> Jan 29 20:20:18 pigpen postfix/smtpd[22508]: sql plugin create statement from userPassword test.example.com smtp.theshed.dhs.org
BB> Jan 29 20:20:18 pigpen postfix/smtpd[22508]: sql plugin doing query SELECT clearpw FROM postfix_users where email = 'test@example.com@smtp.theshed.dhs.org';
BB> Jan 29 20:20:18 pigpen postfix/smtpd[22508]: sql plugin: no result found
BB> Jan 29 20:20:18 pigpen postfix/smtpd[22508]: sql plugin create statement from cmusaslsecretPLAIN test.example.com smtp.theshed.dhs.org
BB> Jan 29 20:20:18 pigpen postfix/smtpd[22508]: sql plugin doing query SELECT clearpw FROM postfix_users where email = 'test@example.com@smtp.theshed.dhs.org';
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
because you have smtpd_sasl_local_domain = $myhostname, every username
is appended with this value (i assume your usename is test@example.com)
*HTH*
cheers,
roman
Reply to: