[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