[Postfixbuch-users] bekomme kein smtp-auth über mysql db hin
Daniel
highway-master at gmx.net
Di Dez 5 22:24:14 CET 2006
hallo liste,
ich schaffe es nicht das ich mich authentifizieren kann in
meine /var/log/messages steht das:
sql_select option missing
auxpropfunc error no mechanism available
_sasl_plugin_load failed on sasl_auxprop_plug_init for plugin: sql
alles packete sind über mit yast rpm instlliert.
-postfix
-postif-mysql
-cyrus-sasl*
-mysql*
hier noch meine saslfinger ausgabe:
saslfinger - postfix Cyrus sasl configuration Tue Dec 5 20:59:39 CET 2006
version: 1.0
mode: server-side SMTP AUTH
-- basics --
Postfix: 2.2.9
System:
Welcome to SUSE LINUX 10.1 (i586) - Kernel \r (\l).
-- smtpd is linked to --
libsasl2.so.2 => /usr/lib/libsasl2.so.2 (0xb7e13000)
-- active SMTP AUTH and TLS parameters for smtpd --
broken_sasl_auth_clients = yes
smtpd_sasl_auth_enable = yes
smtpd_sasl_local_domain = mailsrv
smtpd_sasl_security_options = noanonymous
-- listing of /usr/lib/sasl2 --
total 562
drwxr-xr-x 2 root root 920 Dec 5 20:35 .
drwxr-xr-x 55 root root 18120 Dec 5 20:01 ..
-rwxr-xr-x 1 root root 13216 May 2 2006 libanonymous.so
-rwxr-xr-x 1 root root 13216 May 2 2006 libanonymous.so.2
-rwxr-xr-x 1 root root 13216 May 2 2006 libanonymous.so.2.0.21
-rwxr-xr-x 1 root root 15548 May 2 2006 libcrammd5.so
-rwxr-xr-x 1 root root 15548 May 2 2006 libcrammd5.so.2
-rwxr-xr-x 1 root root 15548 May 2 2006 libcrammd5.so.2.0.21
-rwxr-xr-x 1 root root 43316 May 2 2006 libdigestmd5.so
-rwxr-xr-x 1 root root 43316 May 2 2006 libdigestmd5.so.2
-rwxr-xr-x 1 root root 43316 May 2 2006 libdigestmd5.so.2.0.21
-rwxr-xr-x 1 root root 25168 May 2 2006 libgssapiv2.so
-rwxr-xr-x 1 root root 25168 May 2 2006 libgssapiv2.so.2
-rwxr-xr-x 1 root root 25168 May 2 2006 libgssapiv2.so.2.0.21
-rwxr-xr-x 1 root root 13724 May 2 2006 liblogin.so
-rwxr-xr-x 1 root root 13724 May 2 2006 liblogin.so.2
-rwxr-xr-x 1 root root 13724 May 2 2006 liblogin.so.2.0.21
-rwxr-xr-x 1 root root 14268 May 2 2006 libplain.so
-rwxr-xr-x 1 root root 14268 May 2 2006 libplain.so.2
-rwxr-xr-x 1 root root 14268 May 2 2006 libplain.so.2.0.21
-rwxr-xr-x 1 root root 18316 May 2 2006 libsasldb.so
-rwxr-xr-x 1 root root 18316 May 2 2006 libsasldb.so.2
-rwxr-xr-x 1 root root 18316 May 2 2006 libsasldb.so.2.0.21
-rwxr-xr-x 1 root root 21740 May 2 2006 libsql.so
-rwxr-xr-x 1 root root 21740 May 2 2006 libsql.so.2
-rwxr-xr-x 1 root root 21740 May 2 2006 libsql.so.2.0.21
-rw------- 1 root root 220 Dec 5 19:22 smtpd.conf
-- content of /usr/lib/sasl2/smtpd.conf --
pwcheck_method: auxprop
mech_list: plain login
auxprop_plugin: sql
sql_engine: mysql
sql_hostnames: localhost
sql_database: mail
sql_user: --- replaced ---
sql_passwd: --- replaced ---
sql_select: SELECT passwd FROM users WHERE mailad = '%u'
-- 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 - 20 smtpd
-o content_filter=amavisd-new:[127.0.0.1]:10024
pickup fifo n - n 60 1 pickup
cleanup unix n - n - 0 cleanup
qmgr fifo n - n 300 1 qmgr
rewrite unix - - n - - trivial-rewrite
bounce unix - - n - 0 bounce
defer unix - - n - 0 bounce
trace unix - - n - 0 bounce
verify unix - - n - 1 verify
flush unix n - n 1000? 0 flush
proxymap unix - - n - - proxymap
smtp unix - - n - - smtp -v
relay unix - - n - - smtp
-o fallback_relay=
amavisd-new unix - - n - 2 smtp
-o smtp_data_done_timeout=1200s
-o disable_dns_lookups=yes
-o smtp_send_xforward_command=yes
localhost: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
-o smtpd_bind_address=127.0.0.1
showq unix n - n - - showq
error unix - - n - - error
discard unix - - n - - discard
local unix - n n - - local
virtual unix - n n - - virtual
lmtp unix - - n - - lmtp
anvil unix - - n - 1 anvil
scache unix - - n - 1 scache
maildrop unix - n n - - pipe
flags=DRhu user=vmail argv=/usr/local/bin/maildrop -d ${recipient}
cyrus unix - n n - - pipe
user=cyrus argv=/usr/lib/cyrus/bin/deliver -e -r ${sender} -m ${extension}
${u ser}
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=foo argv=/usr/local/sbin/bsmtp -f $sender $nexthop $recipient
procmail unix - n n - - pipe
flags=R user=nobody argv=/usr/bin/procmail -t -m /etc/procmailrc ${sender}
${r ecipient}
-- mechanisms on localhost --
250-AUTH LOGIN PLAIN
250-AUTH=LOGIN PLAIN
-- end of saslfinger output --
Ich hoffe Ihr Könnte mir helfen ich sitze seit tagen an diesem problem. und
komm einfach nicht weiter. Ich hab auch leider nicht so die erfahrung mit
postfix.
ich bedanke mich für jeden tip
Gruss Daniel
Mehr Informationen über die Mailingliste Postfixbuch-users