[Greylist-users] relay_ip whitelist problem

[Albert Whale]

Evan Harris wrote:

>This looks like a DB problem, since I don't see anything wrong with the
>whitelist record.
>
>First, check your db tables to make sure your indexes aren't corrupted.  If
>that isn't the problem, then add a print of the full $query string, and plug
>it manually into a mysql shell, and debug it from there to figure out why
>the db is not returning the row you expect it to.
>
>Evan
>  
>
I've seen DB problems recently with the Greylisting, and the problem was 
the Date/time was not correct (hardware clock 9 months off).  Given that 
the machine was running in the past the last update field was 
significantly older than the correct date and time.

NTP is a good cure for this, but a Race condition on the Firewall did 
not permit the ntp to sync up properly.

HTH.

-- 
Albert E. Whale, CISSP - Sr. Security, Network, and Systems Consultant
--------------------------------------------------------------------------------
http://www.abs-comptech.com & http://www.No-JunkMail.com 
ABS Computer Technology, Inc. - ESM, Computer & Networking Specialists
SPAM Zapper - www.No-JunkMail.com - SPAM Stops Here.
Founding Board of Directors of Pittsburgh FBI - InfraGard