Re: [Sqlgrey-users] google alerts

[Kenneth M. <kt...@ri...>]

Daniel,

We ran the sqlgrey in collection mode only for a few weeks. This
prepopulated all the domain_awl entries for Google mail. Then when
we enabled it, we did not have these problems.

Ken

On Fri, Mar 16, 2007 at 02:40:54PM -0500, Daniel J McDonald wrote:
> 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
> 
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys-and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> Sqlgrey-users mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlgrey-users
>