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 [EMAIL 
PROTECTED]
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 = [EMAIL PROTECTED]
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='[EMAIL PROTECTED]'


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
_______________________________________________
postfix-users mailing list
[email protected]
http://de.postfix.org/cgi-bin/mailman/listinfo/postfix-users

Antwort per Email an