[Postfixbuch-users] Postfix, SMTP-Auth, "no secret in database", "sql_select option missing"
Martin Marcher
martin.marcher at openforce.com
Fr Dez 8 15:14:18 CET 2006
Hallo,
hatte ein ähnliches Problem:
smtpd_sasl_path = smtpd
hat das ganze gelöst mein smtpd file liegt in /etc/postfix/sasl/
lg
martin
Am 07.12.2006 um 17:34 schrieb Michael Reichenbach:
> Hallo,
>
> gestern habe ich einen Mailserver auf Ubuntu 6.10 nach der
> Anleitung von flurdy
> (http://flurdy.com/docs/postfix/) aufgesetzt. Erste Erfolge kamen
> schnell, folgendes
> funktioniert:
>
> - login via squirrelmail und lesen der emails via IMAP
> - IMAP und POP3 zugriff via outlook express
>
> was noch nicht geht: via SMTP eine email an den mailserver zu
> schicken.
>
>
> mail.log:
>
> -----<schnipp>-----
> Dec 7 16:21:28 mailserver postfix/master[30508]: daemon started --
> version 2.3.3, configuration
> /etc/postfix
> Dec 7 16:21:28 mailserver postfix/tlsmgr[30511]: open smtpd TLS cache
> btree:/var/spool/postfix/smtpd_scache
> Dec 7 16:21:28 mailserver postfix/tlsmgr[30511]:
> tlsmgr_cache_run_event: start TLS smtpd
> session cache cleanup
> Dec 7 16:21:39 mailserver postfix/smtpd[30519]: initializing the
> server-side TLS engine
> Dec 7 16:21:39 mailserver postfix/smtpd[30519]: warning:
> 192.168.0.1: address not listed for
> hostname localhost
> Dec 7 16:21:39 mailserver postfix/smtpd[30519]: connect from
> unknown[192.168.0.1]
> Dec 7 16:21:39 mailserver postfix/smtpd[30519]: warning: SASL
> authentication failure: no secret
> in database
> Dec 7 16:21:39 mailserver postfix/smtpd[30519]: warning: unknown
> [192.168.0.1]: SASL NTLM
> authentication failed: authentication failure
> Dec 7 16:21:39 mailserver postfix/smtpd[30519]: warning: SASL
> authentication failure: no secret
> in database
> Dec 7 16:21:39 mailserver postfix/smtpd[30519]: warning: unknown
> [192.168.0.1]: SASL NTLM
> authentication failed: authentication failure
> Dec 7 16:21:40 mailserver postfix/smtpd[30519]: warning: unknown
> [192.168.0.1]: SASL NTLM
> authentication aborted
> Dec 7 16:21:41 mailserver postfix/smtpd[30519]: lost connection
> after AUTH from
> unknown[192.168.0.1]
> Dec 7 16:21:41 mailserver postfix/smtpd[30519]: disconnect from
> unknown[192.168.0.1]
> -----<schnapp>-----
>
>
> auth.log:
>
> -----<schnipp>-----
> Dec 7 16:21:39 mailserver postfix/smtpd[30519]: sql_select option
> missing
> Dec 7 16:21:39 mailserver postfix/smtpd[30519]: auxpropfunc error
> no mechanism available
> Dec 7 16:21:39 mailserver postfix/smtpd[30519]: _sasl_plugin_load
> failed on
> sasl_auxprop_plug_init for plugin: sql
> Dec 7 16:21:39 mailserver postfix/smtpd[30519]: OTP unavailable
> because can't read/write key
> database /etc/opiekeys: No such file or directory
> Dec 7 16:21:39 mailserver postfix/smtpd[30519]: NTLM server step 1
> Dec 7 16:21:39 mailserver postfix/smtpd[30519]: client flags:
> ffffb207
> Dec 7 16:21:39 mailserver postfix/smtpd[30519]: NTLM server step 2
> Dec 7 16:21:39 mailserver postfix/smtpd[30519]: client user:
> Michael Reichenbach
> Dec 7 16:21:39 mailserver postfix/smtpd[30519]: client domain:
> VOYAGER
> Dec 7 16:21:39 mailserver postfix/smtpd[30519]: NTLM server step 1
> Dec 7 16:21:39 mailserver postfix/smtpd[30519]: client flags:
> ffff8207
> Dec 7 16:21:39 mailserver postfix/smtpd[30519]: NTLM server step 2
> Dec 7 16:21:39 mailserver postfix/smtpd[30519]: client user:
> mr at reichemi.mydyn.de
>
> -----<schnapp>-----
>
>
> saslfinger -s:
>
> -----<schnipp>-----
> saslfinger - postfix Cyrus sasl configuration Thu Dec 7 16:21:52
> CET 2006
> version: 1.0
> mode: server-side SMTP AUTH
>
> -- basics --
> Postfix: 2.3.3
> System: Ubuntu 6.10 \n \l
>
> -- smtpd is linked to --
> libsasl2.so.2 => /usr/lib/libsasl2.so.2 (0xb7dbe000)
>
> -- active SMTP AUTH and TLS parameters for smtpd --
> broken_sasl_auth_clients = yes
> smtpd_sasl_auth_enable = yes
> smtpd_sasl_local_domain =
> smtpd_sasl_path = /etc/postfix/sasl:/usr/lib/sasl2
> smtpd_sasl_security_options = noanonymous
> smtpd_tls_cert_file = /etc/postfix/postfix.cert
> smtpd_tls_key_file = /etc/postfix/postfix.key
> smtpd_tls_loglevel = 3
> smtpd_tls_session_cache_database = btree:${queue_directory}/
> smtpd_scache
> smtpd_use_tls = yes
>
>
> -- listing of /usr/lib/sasl2 --
> total 964
> drwxr-xr-x 2 root root 4096 2006-12-07 00:28 .
> drwxr-xr-x 139 root root 28672 2006-12-07 01:25 ..
> -rw-r--r-- 1 root root 13640 2006-10-12 17:47 libanonymous.a
> -rw-r--r-- 1 root root 855 2006-10-12 17:47 libanonymous.la
> -rw-r--r-- 1 root root 13196 2006-10-12 17:47 libanonymous.so
> -rw-r--r-- 1 root root 13196 2006-10-12 17:47 libanonymous.so.2
> -rw-r--r-- 1 root root 13196 2006-10-12 17:47 libanonymous.so.2.0.19
> -rw-r--r-- 1 root root 15942 2006-10-12 17:47 libcrammd5.a
> -rw-r--r-- 1 root root 841 2006-10-12 17:47 libcrammd5.la
> -rw-r--r-- 1 root root 15660 2006-10-12 17:47 libcrammd5.so
> -rw-r--r-- 1 root root 15660 2006-10-12 17:47 libcrammd5.so.2
> -rw-r--r-- 1 root root 15660 2006-10-12 17:47 libcrammd5.so.2.0.19
> -rw-r--r-- 1 root root 47092 2006-10-12 17:47 libdigestmd5.a
> -rw-r--r-- 1 root root 864 2006-10-12 17:47 libdigestmd5.la
> -rw-r--r-- 1 root root 43904 2006-10-12 17:47 libdigestmd5.so
> -rw-r--r-- 1 root root 43904 2006-10-12 17:47 libdigestmd5.so.2
> -rw-r--r-- 1 root root 43904 2006-10-12 17:47 libdigestmd5.so.2.0.19
> -rw-r--r-- 1 root root 13650 2006-10-12 17:47 liblogin.a
> -rw-r--r-- 1 root root 835 2006-10-12 17:47 liblogin.la
> -rw-r--r-- 1 root root 13992 2006-10-12 17:47 liblogin.so
> -rw-r--r-- 1 root root 13992 2006-10-12 17:47 liblogin.so.2
> -rw-r--r-- 1 root root 13992 2006-10-12 17:47 liblogin.so.2.0.19
> -rw-r--r-- 1 root root 30492 2006-10-12 17:47 libntlm.a
> -rw-r--r-- 1 root root 829 2006-10-12 17:47 libntlm.la
> -rw-r--r-- 1 root root 30472 2006-10-12 17:47 libntlm.so
> -rw-r--r-- 1 root root 30472 2006-10-12 17:47 libntlm.so.2
> -rw-r--r-- 1 root root 30472 2006-10-12 17:47 libntlm.so.2.0.19
> -rw-r--r-- 1 root root 20290 2006-10-12 17:47 libotp.a
> -rw-r--r-- 1 root root 829 2006-10-12 17:47 libotp.la
> -rw-r--r-- 1 root root 43312 2006-10-12 17:47 libotp.so
> -rw-r--r-- 1 root root 43312 2006-10-12 17:47 libotp.so.2
> -rw-r--r-- 1 root root 43312 2006-10-12 17:47 libotp.so.2.0.19
> -rw-r--r-- 1 root root 13938 2006-10-12 17:47 libplain.a
> -rw-r--r-- 1 root root 835 2006-10-12 17:47 libplain.la
> -rw-r--r-- 1 root root 13992 2006-10-12 17:47 libplain.so
> -rw-r--r-- 1 root root 13992 2006-10-12 17:47 libplain.so.2
> -rw-r--r-- 1 root root 13992 2006-10-12 17:47 libplain.so.2.0.19
> -rw-r--r-- 1 root root 22062 2006-10-12 17:47 libsasldb.a
> -rw-r--r-- 1 root root 856 2006-10-12 17:47 libsasldb.la
> -rw-r--r-- 1 root root 18272 2006-10-12 17:47 libsasldb.so
> -rw-r--r-- 1 root root 18272 2006-10-12 17:47 libsasldb.so.2
> -rw-r--r-- 1 root root 18272 2006-10-12 17:47 libsasldb.so.2.0.19
> -rw-r--r-- 1 root root 22100 2006-10-12 17:47 libsql.a
> -rw-r--r-- 1 root root 905 2006-10-12 17:47 libsql.la
> -rw-r--r-- 1 root root 21660 2006-10-12 17:47 libsql.so
> -rw-r--r-- 1 root root 21660 2006-10-12 17:47 libsql.so.2
> -rw-r--r-- 1 root root 21660 2006-10-12 17:47 libsql.so.2.0.19
>
>
>
>
> -- content of /etc/postfix/sasl/smtpd.conf --
> pwcheck_method: auxprop
> auxprop_plugin: sql
> mech_list: plain login cram-md5 digest-md5
> sql_engine: mysql
> sql_hostnames: 127.0.0.1
> sql_user: --- replaced ---
> sql_passwd: --- replaced ---
> sql_database: maildb
> sql_select: select clear from users where id='%u@%r' and enabled = 1
>
>
> -- active services in /etc/postfix/master.cf --
> # service type private unpriv chroot wakeup maxproc command + args
> # (yes) (yes) (yes) (never) (100)
> smtp inet n - n - - smtpd
> -o cleanup_service_name=pre-cleanup
> smtps inet n - n - - smtpd
> -o smtpd_tls_wrappermode=yes
> -o smtpd_sasl_auth_enable=yes
> 587 inet n - n - - smtpd
> -o smtpd_enforce_tls=yes
> -o smtpd_sasl_auth_enable=yes
> pickup fifo n - - 60 1 pickup
> cleanup unix n - - - 0 cleanup
> -o mime_header_checks=
> -o nested_header_checks=
> -o body_checks=
> -o header_checks=
> amavis unix - - - - 2 smtp
> -o smtp_data_done_timeout=1200
> -o smtp_send_xforward_command=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 strict_rfc821_envelopes=yes
> -o mynetworks=127.0.0.0/8
> -o smtpd_error_sleep_time=0
> -o smtpd_soft_error_limit=1001
> -o smtpd_hard_error_limit=1001
> pre-cleanup unix n - - - 0 cleanup
> -o virtual_alias_maps=
> -o canonical_maps=
> -o sender_canonical_maps=
> -o recipient_canonical_maps=
> -o masquerade_domains=
> qmgr fifo n - n 300 1 qmgr
> tlsmgr unix - - n 300 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
> smtp unix - - - - - smtpd -v
> relay unix - - - - - smtp
> -o fallback_relay=
> showq unix n - - - - showq
> error 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}
>
> -- mechanisms on localhost --
> 250-AUTH PLAIN NTLM LOGIN DIGEST-MD5 CRAM-MD5
> 250-AUTH=PLAIN NTLM LOGIN DIGEST-MD5 CRAM-MD5
>
>
> -- end of saslfinger output --
> -----<schnapp>-----
>
>
> ich hab gestern und heute schon endlose websites zu diesem oder
> ähnlichem thema gefunden, aber
> geholfen hat nichts :-(
> habt ihr vielleicht einen Tip?
>
> "smtpd_use_tls = no" hab ich auch schon probiert
>
>
> mfg, Michael
>
> --
> _______________________________________________
> Postfixbuch-users mailingliste
> Heinlein Professional Linux Support GmbH
>
> Postfixbuch-users at listi.jpberlin.de
> http://listi.jpberlin.de/mailman/listinfo/postfixbuch-users
>
Mehr Informationen über die Mailingliste Postfixbuch-users