[Postfixbuch-users] Postfix, SMTP-Auth, "no secret in database", "sql_select option missing"
Michael Reichenbach
mr at reichemi.de
Fr Dez 8 15:28:51 CET 2006
hallo,
NEIN! man glaubt es nicht! daran lag es, offenbar schon die ganze zeit lang... DANKE für den
tipp!!
Micha
==================================================
At Friday, December 08, 2006 3:14 PM [GMT +1], Martin Marcher <martin.marcher at openforce.com>
wrote:
> 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