Re: [Sqlgrey-users] Duplicate connect records

[Lionel B. <lio...@bo...>]

Michael Storz wrote the following on 14.09.2005 16:43 :

>On Wed, 14 Sep 2005, Steffen Plotner wrote:
>
>  
>
>>Hi Lionel,
>>
>>I have reverted to sqlgrey-1.6.5.tar.bz2 and within minutes of
>>restarting postfix/sqlgrey I can see duplications in the connect table.
>>The dump below shows the duplications in the count column on the far
>>right (duplications show with a count > 1).
>>
>>I wonder if anybody else sees this kind of behavior?
>>
>>
>>    
>>
>
>Hi Steffen,
>
>I don't think there is a problem. It seems you forgot that in table
>connect 4 items are stored sender_name, sender_domain, src AND rcpt.
>If an email goes to several recipients than you get several entries with
>stored sender_name, sender_domain and src. Just use
>
>select * from connect where src = "IP-ADDR" order by rcpt;
>
>with IP-ADDR replaced by one of the entries where count > 1. This should
>sjow that the difference in the entries are in field rcpt.
>  
>

The first table extract showed several entries for the same RCPT...

As a side note, there isn't a UNIQUE INDEX on the entries in this table 
(which would have prevented even a bug ins SQLgrey to create multiple 
entries), because... MySQL doesn't support them on such long rows :-(

Lionel.