[Greylist-users] relay_ip whitelist problem

[Evan Harris]

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


On Tue, 13 Apr 2004, Barb Dijker wrote:

> 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
>
>