[Postfixbuch-users] Problem mit SMTP AUTH

[Frank Fiedler]

From: "Sandy Drobic"
>...
> NOCH EINMAL explizit:
>
> Bitte lege /etc/sasl2/smtpd.conf an mit folgendem Inhalt:
>
> mech_list: plain login
>...
>...

Mach ich doch einfach mal:

server:/etc/postfix/sasl2 # postfix reload
postfix/postfix-script: refreshing the Postfix mail system

server:/etc/postfix/sasl2 # ls -la
insgesamt 12
drwxr-xr-x 2 root root    4096 16. Jan 21:58 .
drwxr-xr-x 5 root root    4096 16. Jan 21:47 ..
-rw-r----- 1 root postfix  233 16. Jan 21:58 smtpd.conf

server:/etc/postfix/sasl2 # cat smtpd.conf
mech_list: plain login
pwcheck_method: auxprop
auxprop_plugin: sql
sql_engine: mysql
sql_hostnames: localhost
sql_user: XXXXXXX
sql_passwd: XXXXXXX
sql_database: mailbase
sql_select: select password from users where account='%u@%r'

server:/etc/postfix/sasl2 # telnet localhost 25
Trying 127.0.0.1...
Connected to localhost.
Escape character is '^]'.
220 mailserver.test.biz ESMTP Postfix
EHLO test.biz
250-mailserver.test.biz
250-PIPELINING
250-SIZE 5120000
250-VRFY
250-ETRN
250-AUTH DIGEST-MD5 PLAIN CRAM-MD5 LOGIN GSSAPI
250-AUTH=DIGEST-MD5 PLAIN CRAM-MD5 LOGIN GSSAPI
250-ENHANCEDSTATUSCODES
250-8BITMIME
250 DSN
QUIT
221 2.0.0 Bye
Connection closed by foreign host.
server:/etc/postfix/sasl2 #

Kein Eintrag in der sqllog

Meldungen in der messages:
Jan 16 22:01:54 server postfix/smtpd[27979]: auxpropfunc error invalid 
parameter supplied
Jan 16 22:01:54 server postfix/smtpd[27979]: _sasl_plugin_load failed on 
sasl_auxprop_plug_init for plugin: ldapdb
Jan 16 22:01:54 server postfix/smtpd[27979]: sql_select option missing
Jan 16 22:01:54 server postfix/smtpd[27979]: auxpropfunc error no mechanism 
available
Jan 16 22:01:54 server postfix/smtpd[27979]: _sasl_plugin_load failed on 
sasl_auxprop_plug_init for plugin: sql

Meldungen in der maillog
Jan 16 22:01:58 server postfix/smtpd[27979]: connect from 
p578b38d4.dip0.t-ipconnect.de[xxx.xxx.xxx.xxx]
Jan 16 22:01:58 server postfix/smtpd[27979]: warning: SASL authentication 
problem: unable to open Berkeley db /etc/sasldb2: No such file or directory
Jan 16 22:01:58 server postfix/smtpd[27979]: warning: SASL authentication 
problem: unable to open Berkeley db /etc/sasldb2: No such file or directory
Jan 16 22:01:58 server postfix/smtpd[27979]: warning: 
p578b38d4.dip0.t-ipconnect.de[xxx.xxx.xxx.xxx]: SASL LOGIN authentication 
failed: authentication failure
Jan 16 22:01:58 server postfix/smtpd[27979]: lost connection after AUTH from 
p578b38d4.dip0.t-ipconnect.de[xxx.xxx.xxx.xxx]

Kopfkratz. :-(

DAnke Frank