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@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@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