RE: [Sqlgrey-users] Duplicate connect records

[Michael S. <Mic...@lr...>]

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.

Michael Storz
-------------------------------------------------
Leibniz-Rechenzentrum   !   <mailto:St...@lr...>
Barer Str. 21           !   Fax: +49 89 2809460
80333 Muenchen, Germany !   Tel: +49 89 289-28840