[postfix-users] Postfix + smtp(sql plugin couldn't connect to any host )

[Christian Frost]

Guten Abend Liste,

ich habe mich gerade an euerer Mailingliste eingetragen und schon das erste Problem.
Hier also die Information zu meinem Problem

Distribution: Debian Etch
Es wird Ssycp verwendet.
Postfix in Verbindung mit MySQL

Problem Emails können zwar abgerufen aber nicht versand werden, folgende Fehlermeldungen erhalte ich:

auth.log

Oct 28 17:07:04 mx1 postfix/smtpd[2687]: sql plugin Parse the username test at schisse.de
Oct 28 17:07:04 mx1 postfix/smtpd[2687]: sql plugin try and connect to a host
Oct 28 17:07:04 mx1 postfix/smtpd[2687]: sql plugin trying to open db 'syscp' on host 'localhost'
Oct 28 17:07:04 mx1 postfix/smtpd[2687]: sql plugin could not connect to host localhost

mail.log

Oct 28 17:17:13 mx1 postfix/smtpd[2794]: connect from unknown[217.89.113.253]
Oct 28 17:17:15 mx1 postfix/smtpd[2794]: warning: SASL authentication failure: no secret in database
Oct 28 17:17:15 mx1 postfix/smtpd[2794]: warning: unknown[217.89.113.253]: SASL CRAM-MD5 authentication failed: authentication failure
Oct 28 17:17:15 mx1 postfix/smtpd[2794]: warning: SASL authentication failure: Password verification failed
Oct 28 17:17:15 mx1 postfix/smtpd[2794]: warning: unknown[217.89.113.253]: SASL PLAIN authentication failed: authentication failure
Oct 28 17:17:15 mx1 postfix/smtpd[2794]: warning: unknown[217.89.113.253]: SASL LOGIN authentication failed: authentication failure
Oct 28 17:17:16 mx1 postfix/smtpd[2794]: disconnect from unknown[217.89.113.253]


postconf -n

address_verify_map = btree:/var/spool/postfix/verified_sender
address_verify_sender = postmaster at beispieldomain.tld
alias_database = hash:/etc/aliases
alias_maps = $alias_database
append_dot_mydomain = no
biff = no
broken_sasl_auth_clients = yes
config_directory = /etc/postfix
inet_interfaces = all
mailbox_command = procmail -a "$EXTENSION"
mailbox_size_limit = 0
message_size_limit = 10240000
mydestination = $myhostname $mydomain localhost localhost.$mydomain
mydomain = mx1.beispieldomain.tld
myhostname = mx1.beispieldomain.tld
mynetworks = 127.0.0.0/8
myorigin = beispieldomain.tld
recipient_delimiter = +
relayhost =
smtpd_banner = $myhostname ESMTP $mail_name
smtpd_helo_required = yes
smtpd_recipient_restrictions = reject_non_fqdn_sender   reject_non_fqdn_recipient       reject_unknown_sender_domain        reject_unknown_recipient_domain        permit_mynetworks        permit_sasl_authenticated      reject_unauth_destination        reject_invalid_hostname  reject_rbl_client zen.spamhaus.org  reject_rbl_client ix.dnsbl.manitu.net   check_sender_access  hash:/etc/postfix/check_sender  warn_if_reject reject_unverified_sender  check_policy_service inet:127.0.0.1:60000       permit
smtpd_sasl_auth_enable = yes
smtpd_sasl_local_domain = $myhostname
smtpd_sasl_security_options = noanonymous
smtpd_sender_restrictions = permit_mynetworks reject_unknown_sender_domain
unverified_sender_reject_code = 550
virtual_alias_domains =
virtual_alias_maps = mysql:/etc/postfix/mysql-virtual_alias_maps.cf
virtual_gid_maps = static:2000
virtual_mailbox_base = /var/kunden/mail/
virtual_mailbox_domains = mysql:/etc/postfix/mysql-virtual_mailbox_domains.cf
virtual_mailbox_maps = mysql:/etc/postfix/mysql-virtual_mailbox_maps.cf
virtual_uid_maps = static:2000


/etc/postfix/sasl/smtpd.conf

pwcheck_method: auxprop
auxprop_plugin: sql
mech_list: plain login cram-md5 digest-md5
sql_engine: mysql
sql_hostnames: localhost
sql_user: syscp
sql_passwd: supergeheimeskennwort
sql_database: syscp
sql_select: select password from mail_users where username='%u@%r'


Konfiguration habe ich mehrmals durchgeprüft auch statt localhost, 127.0.0.1 in der smtpd.conf eingetragen.
Auf der Konsole kann ich mich mit dem User syscp auf der mysqldb syscp connecten unter angabe 127.0.0.1 oder localhost (geht beides).
Falsches Kennwort kann ich ausschließen. Libs für SASL sind da.

mx1:/var/spool/postfix/var/run/mysqld# dpkg -l |grep sasl
ii  libsasl2               2.1.22.dfsg1-8                       Authentication abstraction library
ii  libsasl2-2             2.1.22.dfsg1-8                       Authentication abstraction library
ii  libsasl2-modules       2.1.22.dfsg1-8                       Pluggable Authentication Modules for SASL
ii  libsasl2-modules-sql   2.1.22.dfsg1-8                       Pluggable Authentication Modules for SASL (S

woran könnte es liegen das ich keine Mail versenden kann.
Falls noch zusätzlich ausgeben benötigt werden, sagt bescheid.


Vielen Dank

Mit freundlichen Grüßen

Christian Frost