More sqlgrey questions - Answered!

Fred Krogh · Last edited by Fred Krogh on Sun May 08, 2016 12:37 am; edited 1 time in total

So sqlgrey is doing pretty much what it is supposed to do, but the table from_awl is getting to many things in it, and I'm still getting too much spam.
I have the reconnect delay set to 2 (minutes), and the max_connect_age set to 2 (hours). I have made up a list of trusted email addressed and put that in a table called whitelist ([url],http://www.hyllander.org/content/sqlgrey-and-whitelisting-senders[/url] but I don't think my version of sqlgrey looks in that table. I'm thinking that maybe if I add more to the delay I can get rid of more of the spam. (Ideally there would be a way to blacklist it, but if there is one, I haven't seen how to do it.) I think I want to use the optout_email table, but if that is the way to do it, why have the whitelist table.

If I understand things correctly I could change "optmethod=none", to "optmethod=optout", and put my trusted email addressed in the optout_email table. I believe "optout" means to not greylist, i.e. to pass the email through without bothering to greylist it. Is this correct? And if there is some way to blacklist the ugly spam that get into the from_awl table I'd really like to know about it. Thanks,
Fred

Fred Krogh · Posted: Fri May 06, 2016 10:15 pm Post subject:

I think I may have an answer to my question, but it would be nice to have it confirmed. Namely I think that the optout_email table is for opting out of grey listing for recipients. This is not all that useful to me. I got impatient and tried putting the emails I trusted tp get mail from in optout_email and sure enough, nothing gets blocked. So the only hope is the whitelist table which does not seem to get looked at, or perhaps some way of black listing?

freke · Posted: Sat May 07, 2016 9:02 am Post subject:

You can use blacklists by adding to your smtpd_recipients_restrictions:

Fred Krogh · Posted: Sat May 07, 2016 5:43 pm Post subject:

I have 40 entries in the from_awl table that I don't want email from. All this in less than a day. This stuff still swamps my regular email even thought admittedly things are much better than before . Since places like spamhaus (which I am using) are able to reject mail from certain domains, it seems to me that it should be possible for me to have my own local list. It's possible my list would reject mail that others might want, but for my purposes I'd be happy not to see any email from these places. It just seems to me that there should be some way to have such a list locally. Anybody know how Thanks,
Fred
P.S. I'm currently using this

freke · Posted: Sat May 07, 2016 7:46 pm Post subject:

You can build access maps - ie. I have an /etc/postfix/maps/access_client with:

Fred Krogh · Posted: Sun May 08, 2016 12:37 am Post subject:

I don't even have a maps directory in my postfix directory and of course no access_client. This looks like just what I want. Many thanks freke!