SQL table lookup

2015-05-07 Thread Rod K
I'm trying to implement check_client_restrictions = check_client_access pgsql:/path/to/local_blacklist-sql.cf, ... Previously I had the same information in a cidr: check_client_access cidr:/path/to/local_blacklist.cidr, When I check with postmap postmap -q 1.2.3.4 pgsql:/path/to

Re: SQL table lookup

2015-05-07 Thread Wietse Venema
Rod K: > I'm trying to implement > > check_client_restrictions = > check_client_access pgsql:/path/to/local_blacklist-sql.cf, Note that this also makes queries with client name parent domains and network prefixes (see the section "HOST NAME/ADDRESS PATTERNS" in the access(5) manpage). > >

Re: SQL table lookup

2015-05-07 Thread Rod K
On 5/7/2015 1:48 PM, Wietse Venema wrote: Rod K: I'm trying to implement check_client_restrictions = check_client_access pgsql:/path/to/local_blacklist-sql.cf, Note that this also makes queries with client name parent domains and network prefixes (see the section "HOST NAME/ADDRESS PATTE

Re: SQL table lookup

2015-05-07 Thread Wietse Venema
Rod K: > *DUNNO* Pretend that the lookup key was not found. This prevents Postfix >from trying substrings of the lookup key (such as a > subdomain >name, or a network address subnetwork). > " > > This to me means the first lookup would check domain.tld (rece

Re: SQL table lookup

2015-05-07 Thread Rod K
On 5/7/2015 3:01 PM, Wietse Venema wrote: Rod K: *DUNNO* Pretend that the lookup key was not found. This prevents Postfix from trying substrings of the lookup key (such as a subdomain name, or a network address subnetwork). " This to me means the first lo

Re: SQL table lookup

2015-05-07 Thread Wietse Venema
Wietse: > DUNNO means something was found, don't look further. You want to > return "not found" instead. Rod K: > In access.5 "not found" is not a listed response. Is that a literal > "NOT FOUND" or, in the case of an SQL query, an empty string or null, or > 0 rows? Returning NOT FOUND means:

Re: SQL table lookup

2015-05-08 Thread Tobi
-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Am 07.05.2015 um 18:43 schrieb Rod K: > I'm trying to implement > > check_client_restrictions = check_client_access > pgsql:/path/to/local_blacklist-sql.cf, ... > have you had a look at postfix postscreen featue? http://www.postfix.org/POSTSCREEN_R

Re: SQL table lookup

2015-05-08 Thread Rod K
On 5/8/2015 3:33 AM, Tobi wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Am 07.05.2015 um 18:43 schrieb Rod K: I'm trying to implement check_client_restrictions = check_client_access pgsql:/path/to/local_blacklist-sql.cf, ... have you had a look at postfix postscreen featue? http://w

Re: SQL table lookup

2015-05-12 Thread Peter
On 05/08/2015 04:43 AM, Rod K wrote: > check_client_restrictions = There is no such setting, you probably want smtpd_client_restrictions. Peter

Re: SQL table lookup

2015-05-12 Thread Rod K
On 5/12/2015 7:55 PM, Peter wrote: On 05/08/2015 04:43 AM, Rod K wrote: check_client_restrictions = There is no such setting, you probably want smtpd_client_restrictions. Peter Yes I did. Should have been smtpd_client_restrictions = check_client_access