Re: [Sqlgrey-users] google alerts

[Lionel B. <lio...@bo...>]

McDonald, Dan wrote the following on 16.03.2007 18:31 :
>
> I noticed that google does not play well with sqlgrey.  Got a few
> complaints about google alert messages not being delivered
>

Is it a recurring problem? Did you wait 24h to see if Google retried
later? Are there entries in from_awl and domain_awl?

> and found
> this in my connect table:
> mysql> select count(*), src from connect where sender_domain rlike
> "alerts.bounces.google.com" group by src;
> +----------+----------------+
> | count(*) | src            |
> +----------+----------------+
> |      385 | 209.85.132     |
> |        1 | 209.85.132.185 |
> |        1 | 209.85.132.190 |
> |        1 | 209.85.132.191 |
> |      110 | 64.233.162     |
> |        1 | 64.233.162.183 |
> |      361 | 64.233.184     |
> |        4 | 66.249.92      |
> +----------+----------------+
> 8 rows in set (0.35 sec)
>
> So, I add to my /etc/sqlgrey/clients_fqdn_whitelist.local file:
> [mcdonalddj@sa sqlgrey]$ sudo grep google clients_fqdn_whitelist.local
> alerts.bounces.google.com
>

This will whitelist mails from the system called
"alerts.bounces.google.com" not mails with a return address in this domain.
>
>
> But it's still greylisting:
> mcdonalddj@sa sqlgrey]$ sudo tail -f /var/log/mail/info | grep
> alerts.bounces.google.com
> Mar 16 11:16:50 sa sqlgrey: grey: new: 209.85.132(209.85.132.186),
> 1ra...@al...
> -> **mumble**@austinenergy.com
> Mar 16 12:16:50 sa postfix/smtpd[2267]: NOQUEUE: reject: RCPT from
> an-out-0910.google.com[209.85.132.186]: 450 4.7.1
>

If you want to use clients_fqdn_whitelist.local, you'll need to put
an-out-0910.google.com
in it.

Or like explained at the top of clients_fqdn_whitelist :
*.google.com

Lionel.