Re: [Sqlgrey-users] google alerts

[Daniel J M. <dan...@au...>]

On Fri, 2007-03-16 at 19:19 +0100, Lionel Bouton wrote:
> 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?

Yes.
>  Did you wait 24h to see if Google retried
> later? 

Google uses a different name for each attempt.

> Are there entries in from_awl and domain_awl?
not for alerts.bounces.google.com, just for
goo...@go...

> > 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.
Ah, since it is a pool of servers in different netblocks with different
names, that is a problem.

> 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

A pity, but I guess I need to do that... Done.  And mail is now flowing.

-- 
Daniel J McDonald, CCIE # 2495, CISSP # 78281, CNX
Austin Energy
http://www.austinenergy.com