[Postfixbuch-users] SMTP-Auth SQL

[Patrick Ben Koetter]

Hallo Silvio,

bitte lade Dir saslfinger runter und lass es mit "saslfinger -s" laufen. Den
Output dann an die Liste.

Danke,

p at rick




* Silvio Siefke <listen at silviosiefke.de>:
> 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
> 
> -- 
> _______________________________________________
> Postfixbuch-users mailingliste
> Heinlein Professional Linux Support GmbH
> 
> Postfixbuch-users at listi.jpberlin.de
> http://listi.jpberlin.de/mailman/listinfo/postfixbuch-users

-- 
The Book of Postfix
<http://www.postfix-book.com>
SMTP AUTH debug utility:
<http://postfix.state-of-mind.de/patrick.koetter/saslfinger/>