[Greylist-users] relay_ip whitelist problem

[Barb Dijker]

It appears that sometimes the database query for the relay check comes  
up empty handed, when it shouldn't.

Here is an example on one of my servers (RH, sendmail 8.12.10, mysql  
3.23.54, relaydelay 0.04).  The extra info is debugging I added to  
convince me that the relay_ip check was actually happening.  This  
message should have been whitelisted.

=== 2004-04-13 10:32:15 ===
Stored Sender: <krista at XXXXXX.com>
Passed Recipient: <XXXXXX at XXXXXX.com>
   Relay: [64.25.15.136] - If_Addr: 206.168.112.40
   RelayIP: 64.25.15.136 - RelayName:  - RelayIdent:  - PossiblyForged: 0
   From: krista - To: XXXXXX at XXXXXX.com
   InMailer: local - OutMailer: esmtp - QueueID: i3DGW4jJ007462
Checking relay_ip: relay_ip = '64.25.15.136' OR relay_ip = '64.25.15'  
OR relay_ip = '64.25' OR relay_ip = '64'
Checking rcpt_to: rcpt_to = '<XXXXXX at XXXXXX.com>' OR rcpt_to =  
'XXXXXX.com'
   New mail row successfully inserted.  Passing mail.  rowid: 23118


 > select * from relaytofrom where relay_ip = "64.25.15.136";

-----+
| id    | relay_ip     | mail_from                     | rcpt_to         
                              | block_expires       | record_expires      
  | blocked_count | passed_count | aborted_count | origin_type |  
create_time         | last_update    |
+-------+--------------+------------------------------- 
+---------------------------------------------+--------------------- 
+---------------------+---------------+--------------+--------------- 
+-------------+---------------------+----------------+
| 19891 | 64.25.15.136 | NULL                          | NULL            
                              | 0000-00-00 00:00:00 | 2004-04-15  
12:47:23 |             0 |            0 |            16 | AUTO        |  
2004-04-12 09:27:53 | 2004041310


The whitelist db entry was created by my poprelayd.  Yea, I know, use  
smtp auth.  I need something during a transition.  I'd rather  
transition without all the spam.

Barb Dijker
Netrack, Inc., 3080 Valmont Rd Ste 200, Boulder CO 80301
303.938.0188, toll free 1.888.9Netrack, fax 303.938.0177
www.netrack.net