Hi Carsten

Wäre super, wenn jemand unterstützen kann.

Stehen die Passwörter deiner Benutzer cleartext oder verschlüsselt in der Datenbank?

Ciao, Werner

* Carsten Laun-De Lellis postfix-users@de.postfix.org:

Hallo alle zusammen

Ich habe ein Problem mit der Authtentifizierung über mysql und weiß nicht so recht, wie ich es lösen kann.

Meldung in der log-Datei: S000003 postfix/smtpd[10591]: warning: unknown[10.242.2.6]: SASL LOGIN authentication failed: authentication failure

Es muss sql_passwd und nicht sql_password in smtpd.conf heissen.

p@rick

Habe keine Idee, wo ich drehen muss, damit dies funktioniert. Momentan lasse ich nur relaying aus meinem LAN zu.

Wäre super, wenn jemand unterstützen kann.

Mit freundlichem Gruß Carsten Laun-De Lellis

Anbei ein Auszug aus dem Ergebnis von saslfinger:

saslfinger - postfix Cyrus sasl configuration Fr 19. Jun 12:38:03 CEST 2009 version: 1.0.4 mode: server-side SMTP AUTH

-- basics -- Postfix: 2.5.5 System: Ubuntu 9.04 \n \l

-- smtpd is linked to -- libsasl2.so.2 => /usr/lib/libsasl2.so.2 (0xb7d1f000)

-- active SMTP AUTH and TLS parameters for smtpd -- broken_sasl_auth_clients = yes smtpd_sasl_auth_enable = yes smtpd_sasl_authenticated_header = yes smtpd_sasl_local_domain = smtpd_sasl_security_options = noanonymous

-- listing of /usr/lib/sasl2 -- insgesamt 944 drwxr-xr-x 2 root root 4096 2009-06-15 09:55 . drwxr-xr-x 63 root root 20480 2009-06-15 17:09 .. -rw-r--r-- 1 root root 13868 2009-03-06 17:05 libanonymous.a -rw-r--r-- 1 root root 989 2009-03-06 17:05 libanonymous.la -rw-r--r-- 1 root root 13752 2009-03-06 17:05 libanonymous.so -rw-r--r-- 1 root root 13752 2009-03-06 17:05 libanonymous.so.2 -rw-r--r-- 1 root root 13752 2009-03-06 17:05 libanonymous.so.2.0.22 -rw-r--r-- 1 root root 16390 2009-03-06 17:05 libcrammd5.a -rw-r--r-- 1 root root 975 2009-03-06 17:05 libcrammd5.la -rw-r--r-- 1 root root 17848 2009-03-06 17:05 libcrammd5.so -rw-r--r-- 1 root root 17848 2009-03-06 17:05 libcrammd5.so.2 -rw-r--r-- 1 root root 17848 2009-03-06 17:05 libcrammd5.so.2.0.22 -rw-r--r-- 1 root root 47760 2009-03-06 17:05 libdigestmd5.a -rw-r--r-- 1 root root 998 2009-03-06 17:05 libdigestmd5.la -rw-r--r-- 1 root root 46828 2009-03-06 17:05 libdigestmd5.so -rw-r--r-- 1 root root 46828 2009-03-06 17:05 libdigestmd5.so.2 -rw-r--r-- 1 root root 46828 2009-03-06 17:05 libdigestmd5.so.2.0.22 -rw-r--r-- 1 root root 14160 2009-03-06 17:05 libldapdb.a -rw-r--r-- 1 root root 982 2009-03-06 17:05 libldapdb.la -rw-r--r-- 1 root root 17780 2009-03-06 17:05 libldapdb.so -rw-r--r-- 1 root root 17780 2009-03-06 17:05 libldapdb.so.2 -rw-r--r-- 1 root root 17780 2009-03-06 17:05 libldapdb.so.2.0.22 -rw-r--r-- 1 root root 13906 2009-03-06 17:05 liblogin.a -rw-r--r-- 1 root root 969 2009-03-06 17:05 liblogin.la -rw-r--r-- 1 root root 13748 2009-03-06 17:05 liblogin.so -rw-r--r-- 1 root root 13748 2009-03-06 17:05 liblogin.so.2 -rw-r--r-- 1 root root 13748 2009-03-06 17:05 liblogin.so.2.0.22 -rw-r--r-- 1 root root 30324 2009-03-06 17:05 libntlm.a -rw-r--r-- 1 root root 963 2009-03-06 17:05 libntlm.la -rw-r--r-- 1 root root 30196 2009-03-06 17:05 libntlm.so -rw-r--r-- 1 root root 30196 2009-03-06 17:05 libntlm.so.2 -rw-r--r-- 1 root root 30196 2009-03-06 17:05 libntlm.so.2.0.22 -rw-r--r-- 1 root root 14226 2009-03-06 17:05 libplain.a -rw-r--r-- 1 root root 969 2009-03-06 17:05 libplain.la -rw-r--r-- 1 root root 17844 2009-03-06 17:05 libplain.so -rw-r--r-- 1 root root 17844 2009-03-06 17:05 libplain.so.2 -rw-r--r-- 1 root root 17844 2009-03-06 17:05 libplain.so.2.0.22 -rw-r--r-- 1 root root 22402 2009-03-06 17:05 libsasldb.a -rw-r--r-- 1 root root 1000 2009-03-06 17:05 libsasldb.la -rw-r--r-- 1 root root 21804 2009-03-06 17:05 libsasldb.so -rw-r--r-- 1 root root 21804 2009-03-06 17:05 libsasldb.so.2 -rw-r--r-- 1 root root 21804 2009-03-06 17:05 libsasldb.so.2.0.22 -rw-r--r-- 1 root root 24164 2009-03-06 17:05 libsql.a -rw-r--r-- 1 root root 1098 2009-03-06 17:05 libsql.la -rw-r--r-- 1 root root 26064 2009-03-06 17:05 libsql.so -rw-r--r-- 1 root root 26064 2009-03-06 17:05 libsql.so.2 -rw-r--r-- 1 root root 26064 2009-03-06 17:05 libsql.so.2.0.22

-- listing of /etc/postfix/sasl -- insgesamt 12 drwxr-xr-x 2 root root 4096 2009-06-19 11:57 . drwxr-xr-x 4 root root 4096 2009-06-18 17:50 .. -rw-r--r-- 1 root root 458 2009-06-19 11:57 smtpd.conf

-- content of /etc/postfix/sasl/smtpd.conf -- #Global parameters log_level: 5 pwcheck_method: auxprop mech_list: plain login # cram-md5 digest-md5 #auxiliary plugin parameters auxprop_plugin:sql sql_engine:mysql sql_hostnames:localhost sql_database:mail sql_user: --- replaced --- sql_password: strenggeheim # sql_select: SELECT '%p' from virtual_users where username = '%u' and userrealm = '%r' and auth = '1' sql_select: SELECT password from virtual_users where username = '%u' and auth = '1' sql_usessl: no

-- content of /etc/postfix/sasl/smtpd.conf -- #Global parameters log_level: 5 pwcheck_method: auxprop mech_list: plain login # cram-md5 digest-md5 #auxiliary plugin parameters auxprop_plugin:sql sql_engine:mysql sql_hostnames:localhost sql_database:mail sql_user: --- replaced --- sql_password: strenggeheim # sql_select: SELECT '%p' from virtual_users where username = '%u' and auth = '1' sql_select: SELECT password from virtual_users where username = '%u' and auth = '1' sql_usessl: no

-- active services in /etc/postfix/master.cf -- # service type private unpriv chroot wakeup maxproc command + args # (yes) (yes) (yes) (never) (100) smtp inet n - - - - smtpd

pickup fifo n - - 60 1 pickup cleanup unix n - - - 0 cleanup qmgr fifo n - n 300 1 qmgr tlsmgr unix - - - 1000? 1 tlsmgr rewrite unix - - - - - trivial-rewrite bounce unix - - - - 0 bounce defer unix - - - - 0 bounce trace unix - - - - 0 bounce verify unix - - - - 1 verify flush unix n - - 1000? 0 flush proxymap unix - - n - - proxymap proxywrite unix - - n - 1 proxymap smtp unix - - - - - smtp relay unix - - - - - smtp -o smtp_fallback_relay= showq unix n - - - - showq error unix - - - - - error retry unix - - - - - error discard unix - - - - - discard local unix - n n - - local virtual unix - n n - - virtual lmtp unix - - - - - lmtp anvil unix - - - - 1 anvil scache unix - - - - 1 scache maildrop unix - n n - - pipe flags=DRhu user=vmail argv=/usr/bin/maildrop -d ${recipient} uucp unix - n n - - pipe flags=Fqhu user=uucp argv=uux -r -n -z -a$sender - $nexthop!rmail ($recipient) ifmail unix - n n - - pipe flags=F user=ftn argv=/usr/lib/ifmail/ifmail -r $nexthop ($recipient) bsmtp unix - n n - - pipe flags=Fq. user=bsmtp argv=/usr/lib/bsmtp/bsmtp -t$nexthop -f$sender $recipient scalemail-backend unix - n n - 2 pipe flags=R user=scalemail argv=/usr/lib/scalemail/bin/scalemail-store ${nexthop} ${user} ${extension} mailman unix - n n - - pipe flags=FR user=list argv=/usr/lib/mailman/bin/postfix-to-mailman.py ${nexthop} ${user}

amavisd-new unix - - n - 2 smtp -o smtp_data_done_timeout=1200s -o disable_dns_lookups=yes

127.0.0.1:10025 inet n - n - - smtpd -o content_filter= -o local_recipient_maps= -o relay_recipient_maps= -o smtpd_restriction_classes= -o smtpd_client_restrictions= -o smtpd_helo_restrictions= -o smtpd_sender_restrictions= -o smtpd_recipient_restrictions=permit_mynetworks,reject -o mynetworks=127.0.0.0/8

-- mechanisms on localhost -- 250-AUTH LOGIN PLAIN 250-AUTH=LOGIN PLAIN

-- end of saslfinger output --

---

postfix-users mailing list postfix-users@de.postfix.org http://de.postfix.org/cgi-bin/mailman/listinfo/postfix-users