From: Aaron P. Martinez (mlproficuous.com)
Date: Fri Apr 09 2004 - 23:51:48 CDT

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

On Sun, 2004-04-04 at 11:55, Bopros wrote:
> Hi,
> In my database all passwords are in plain text. When I try to
> authenticate before sending mail in logs I see:
> connect from unknown[172.16.0.1]
> warning: SASL authentication failure: no user in db
> warning: SASL authentication failure: no user in db
> warning: unknown[172.16.0.1]: SASL LOGIN authentication failed
> lost connection after AUTH from unknown[172.16.0.1]
> disconnect from unknown[172.16.0.1]
>
> Please help me, what can I do wrong? If you need my confs I'll send
> it.
>
> > cat /usr/local/lib/sasl2/smtpd.conf
> pwcheck_method: auxprop
> auxprop_plugin: mysql
> mysql_user: postfix
> mysql_passwd: password
> mysql_hostnames: 192.168.1.254
> mysql_database: postfix
> mysql_statement: select password from mailbox where username='%u%r'
> mysql_verbose: yes
>
Please use a better description of the problems you're having. There
have been many discussions on sasl, but we can't help you without
knowing what version of postfix and what version of cyrus-sasl you're
using as the syntax changed from 2.1.15 - 2.1.18.

The main.cf that you have listed here is NOT the one that you should be
using. you will see CLEARLY and in BOLD text at the top that is
says..DO NOT EDIT THIS FILE. This file is traditionally called
main.cf.default. You should create a new main.cf with only the values
you're needing.

Log files will help immensely as well. You should append a '-v' to the
end of the smtpd line of your master.cf to get more information into the
maillog and also to get the debugging information for your sasl
authentication change your syslog to show debugging and above instead of
info and above. You should then see the attempts to connect to your
database.

Aaron

____Snip___

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