Re: Authentication failed sasl & mysql (SOLVED)

From: Andreas Winkelmann (no email)
Date: Tue Jun 01 2004 - 16:59:44 EDT


Am Dienstag, 1. Juni 2004 22:57 schrieb erri:

> Ohhhhh!!! my god. I cannot believe it, but now it works. At last.
> Thousands of thanks to you Andreas.
> File is readable for postfix. The poblem is in mech_list: plain.
> I did have this line :
> mech_list: login plain
> Then you tell me that i adding another line and for this finally i have two
> lines:
> mech_list: login plain
> mech_list: plain
>
> Now i have erased first line and now it works.

What means "it works"? Does the authentication works? The connect to the
mysql-server? Really?

> # more /usr/local/lib/sasl2/smtpd.conf
> pwcheck_method: auxprop
> auxprop_plugin: mysql
> mysql_hostnames: localhost
> mysql_user: mail
> mysql_password: clave
> mysql_database: mail
> mech_list: plain
> mysql_statement: select clear from users where id='%u' and domain='%r'
> mysql_verbose: yes
>
>
>
> Regards.
>
>
>
>
>
>
> ----- Original Message -----
> From: "Andreas Winkelmann" <>
> To: <>
> Sent: Tuesday, June 01, 2004 10:39 PM
> Subject: Re: Authentication failed sasl & mysql(latest test)
>
> > Am Dienstag, 1. Juni 2004 22:09 schrieb erri:
> > > This patch is very useful. Thanks, but it seems to be right.
> > > Now This is a long log file:
> > >
> > > Jun 1 22:01:20 aixsrv2 postfix/smtpd[307372]: SASL verifyfile conf:
> > > /usr/local/lib/sasl2/smtpd.conf
> > >
> > > Jun 1 22:01:20 aixsrv2 postfix/smtpd[307372]: > unknown[172.26.0.2]:
> > > 250-AUTH PLAIN LOGIN
> > > Jun 1 22:01:20 aixsrv2 postfix/smtpd[307372]: > unknown[172.26.0.2]:
> > > 250-AUTH=PLAIN LOGIN
> >
> > How are the permissions to this file? Is it really readable for Postfix?
> >
> > Post the file again, please. There are many reasons, speaking for, that
>
> the
>
> > file is not beeing read.
> >
> > First "mysql_verbose", with this option sasl should log at least one
>
> message
>
> > more.
> >
> > Second "mech_list: plain", with this Option only "PLAIN" should be
>
> offered.
>
> > ...
> >
> > --
> > Andreas

-- 
	Andreas







Hosted Email Solutions

Invaluement Anti-Spam DNSBLs



Powered By FreeBSD   Powered By FreeBSD