[Postfixbuch-users] SMTP-Auth SQL

Silvio Siefke listen at silviosiefke.de
Mo Jul 18 19:29:26 CEST 2005


Hallo,


möchte gerne SMTP Auth mit Mysql nutzen.
Gesagt, getan.

Postfix 2.1.5, Mysql 4.0, Postfixadmin

postconf -n
alias_database = hash:/etc/aliases
alias_maps = hash:/etc/aliases, hash:/var/lib/mailman/data/aliases
append_dot_mydomain = no
biff = no
broken_sasl_auth_clients = yes
config_directory = /etc/postfix
content_filter = smtp-amavis:[127.0.0.1]:10024
home_mailbox = Maildir/
html_directory = no
mailbox_size_limit = 51200000
mydestination = $myhostname, listen.hserver.info, listen.silviosiefke.de
myhostname = mail.hserver.info
mynetworks = 127.0.0.0/8
queue_directory = /var/spool/postfix
recipient_canonical_maps = hash:/etc/postfix/maps/canonical
recipient_delimiter = +
relocated_maps = hash:/etc/postfix/maps/relocated
sample_directory = /etc/postfix
smtpd_recipient_restrictions =
reject_unknown_sender_domain,
reject_non_fqdn_sender
permit_sasl_authenticated,
permit_mynetworks,
check_sender_access hash:/etc/postfix/spam/sender_access,
check_sender_access hash:/etc/postfix/spam/access
check_recipient_access hash:/etc/postfix/spam/recipient_access,
reject_unauth_destination
reject_rbl_client
reject_rbl_client
sbl.spamhaus.org
reject_rbl_client
list.dsbl.org
reject_rbl_client
relays.ordb.org
reject_rhsbl_client
blackhole.securitysage.com
reject_rhsbl_sender
blackhole.securitysage.com
smtpd_sasl_auth_enable = yes
smtpd_sasl_local_domain =
smtpd_sasl_security_options = noanonymous
smtpd_tls_cert_file = /etc/postfix/smtpd.cert
smtpd_tls_key_file = /etc/postfix/smtpd.key
smtpd_use_tls = no
transport_maps = hash:/etc/postfix/maps/transport
unknown_local_recipient_reject_code = 450
virtual_alias_maps = mysql:/etc/postfix/mysql/mysql_virtual_alias_maps.cf
virtual_gid_maps = static:108
virtual_mailbox_base = /usr/local/virtual
virtual_mailbox_domains =
mysql:/etc/postfix/mysql/mysql_virtual_domains_maps.cf
virtual_mailbox_limit = 51200000
virtual_mailbox_maps = mysql:/etc/postfix/mysql/mysql_virtual_mailbox_maps.cf
virtual_minimum_uid = 108
virtual_transport = virtual
virtual_uid_maps = static:108

postconf -m
static
cidr
nis
dbm
regexp
environ
proxy
btree
unix
hash
tcp
mysql
pcre
sdbm

Lokal gibt es ein "Relay Access Denied"
Jul 18 08:54:23 84-16-230-182 postfix/smtpd[19156]:
connect from localhost[::1]
Jul 18 08:54:23 84-16-230-182 postfix/smtpd[19156]:
NOQUEUE: reject: RCPT from localhost[::1]: 554 <Sabine.Krieg at cosag.de>:
Relay access denied; from=<lieferanten at siefke-internet.net>
to=<Sabine.Krieg at cosag.de> proto=ESMTP helo=<hserver.info>
Jul 18 08:54:23 84-16-230-182 postfix/smtpd[19156]:
lost connection after RCPT from localhost[::1]
Jul 18 08:54:23 84-16-230-182 postfix/smtpd[19156]:
disconnect from localhost[::1]

/etc/postfix/smtpd.conf
pwcheck_method: auxprop
auxprop_plugin: sql
sql_engine: mysql
mech_list: PLAIN LOGIN
sql_hostnames: 127.0.0.1
sql_user: xxxxxx
sql_passwd: xxxxxxx
sql_database: postfix
sql_select: SELECT password FROM mailbox WHERE username = '%u@%r'

Datenbank wird abgefragt, aber weiter passiert nichts. Aber
das lokal der Versand verweigert wird.



Könnt Ihr helfen?


SMTP-Auth Test habe ich auch über die Konsole gemacht.
telnet localhost 25
Trying ::1...
Connected to localhost.
Escape character is '^]'.
220 84-16-230-182.internetserviceteam.com ESMTP Postfix
ehlo mail.siefke-internet.net
250-84-16-230-182.internetserviceteam.com
250-PIPELINING
250-SIZE 10240000
250-VRFY
250-ETRN
250-AUTH LOGIN PLAIN
250-AUTH=LOGIN PLAIN
250 8BITMIME
AUTH PLAIN dXNlcm5hbWUAdXNlcm5hbWUAcGFzc3dvcmQ=
535 Error: authentication failed
QUIT
221 Bye



MFG Silvio




Mehr Informationen über die Mailingliste Postfixbuch-users