> smtpd_recipient_restrictions =
> ...
> check_client_access proxy:mysql:/etc/postfix/mysql-check-client-access.cf
> ...
Hello,
indeed I can't figure out why the check above can cause the error:
"Client host rejected: Access denied"
In my mysql 'postfix' database, I have a simple 'access' table with 3 culumn:
ip, mask, action.
The query for check SMTP relay is:
"select action from access where inet_aton(ip) & inet_aton(mask) =
inet_aton('%s') & inet_aton(mask) order by mask DESC limit 0,1;"
Basically, it returns OK, REJECT or no row.
In the specific case of the error that I have described in this post, the query
returns no row.
Here complete errore received by the sender:
<[email protected]>:
554: 5.7.1 <sonic307-9.consmr.mail.ir2.yahoo.com[87.248.110.34]>: Client host
rejected: Access denied
--- Below this line is a copy of the message.
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.it; s=s2048;
t=1497366344; bh=QZjaAukmiNp6iGsvVR67kpU0ELChNhm5DytI/msfDuA=;
h=Date:From:Reply-To:To:In-Reply-To:References:Subject:From:Subject;
b=PxvQw+FmmL3gr1Us+eQJlPtzPKfH/Uf8va6ni2TA+WunyajbinJLVxoviIw7OXRjjIyJDyr9+xS9ntGI8ChDNIPbSeaee3rl+eijvSeJK2mvq8J8sy8jXOVNsSZZmieUZxSRGX3H9BMcQ9/J98ixbXIa1yYJXEClxHLr8RTr9BKJD61mdW9U/I0wWgDYXWWCkN8qYzRn+J/5g7Cgb8N6qA1K1enIWErOKmgikm5ccImItz9IvgdJ69rDz4jOokxAQVSJJBHADsyNfPGZss+b4tgCU6t6gs9Q3l0oAb/hSW33KAcFQKezPu3VZ5MXoaZxrLfF8noHNY0jIkOTbFwRiQ==
X-YMail-OSG: xDBdgt8VM1kUVzeTWHDZFsOQ6D.VUgd2X1je9kRTVPs7tynSWG67U2vnk9hND7S
zRVHnlQsTUhsjvJ4tD2KLZPqXybQYzTcpgVgPEMvC5ML8G7A.jLif4WC.CRGYpTCTz_XVAXTXPGU
eqor9cVwcMgMz.ACKF9azVkHPy_6dFYDMKdtr5K7Jgd3e93GSgmwChC7osYWiSq3FY1lIG7u7gjd
Hdvk5JViErnoWXcfrC7Lu5B7VbGlAjQqyN6wrHe9dbiINyNJEefYWKVfQ9Fb_1pNZX1qSw..2UKN
tKDpS4iboNOXpvbhaNc8yRJEcmL8sUk.ouhEqzBvLq7Z7Ayq9ZR2.t2P7bx29hvfwoIS0_IYpvsg
RexZ9JIWNV79Wb.Dp9tFYGEdYZS8z5p4TEjdIvDdt1OX9AQt.ddP5xAyHDhzTXuiJJBDSwF8rDCk
J8SwSH8It6iT2HLsf6LNqWH8fSg6ie6YM__7dQPzX9VDTbCrpiYy_Hv2XJCBJYJAvJcMnyrprics
oNWVNap3SaxevkVGd5Kw.aLtMyj2vIbitcqmmkR.JssvL.q70kUOFQWZQa6Am4pWSaOmMXihl
Received: from sonic.gate.mail.ne1.yahoo.com by
sonic307.consmr.mail.ir2.yahoo.com with HTTP; Tue, 13 Jun 2017 15:05:44 +0000
Date: Tue, 13 Jun 2017 15:05:43 +0000 (UTC)
From: Simone Ponzalli <[email protected]>
Reply-To: aaa bbb <[email protected]>
To: ccc ddd<[email protected]>
Message-ID: <[email protected]>
In-Reply-To: <[email protected]>
References: <[email protected]>
<[email protected]>
<[email protected]>
Subject: I: xxxxxxxxxxx
MIME-Version: 1.0
Content-Type: multipart/mixed;
boundary="----=_Part_1748156_1137968452.1497366343412"
X-Mailer: WebService/1.1.9778 YahooMailNeo Mozilla/5.0 (Windows NT 6.1)
AppleWebKit/537.36 (KHTML, like Gecko) Chrome/58.0.3029.110 Safari/537.36
Content-Length: 53234
Regards,
RS
