[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