RE: [Sqlgrey-users] Duplicate connect records

[Steffen P. <swp...@am...>]

Hello Lionel,

Yesterday, I really did have duplications for whatever reason I have not
determined yet. The duplications I thought I had today were incorrectly
queried for. The query should have been:

select sender_name, sender_domain, src,
count(sender_name+sender_domain+src+rcpt) as count=20
from connect=20
group by sender_name, sender_domain, src, rcpt=20
having count(sender_name+sender_domain+src+rcpt) > 1;

Which includes the rcpt field in the group and I have NO duplications.

So, that leaves us with why did I have duplications.

Would you mind explaining the syntax you use in your perl code (I use
perl a bit, however I admit that I am not totally clear about the syntax
below:), in particularly the $#$ part, I understand that the $result is
contains a reference:

    if ($#$result !=3D 0) {
        return 0; # not a single entry
    } else {
        return 1; # at least one entry
    }

Thinking that it might mean the number of records (?) I wrote a little
script to check this:

' the query SHOULD return ONE record (at least in my connect table, just
substitute the value below...

my $sth =3D $dbconn->prepare("SELECT * FROM connect WHERE sender_name =
=3D
'zwsfkz'");

my $result =3D $sth->fetchall_arrayref();
print "$#$result \n";

$sth->execute();
my $count=3D0;
while ( my $row =3D $sth->fetchrow_hashref() )
{
	$count++;
}
print "$count\n";

And I find that the first value is always one less than the actual
count. Hmmm.=20


-----Original Message-----
From: sql...@li...
[mailto:sql...@li...] On Behalf Of Steffen
Plotner
Sent: Wednesday, September 14, 2005 11:24 AM
To: sql...@li...
Subject: RE: [Sqlgrey-users] Duplicate connect records

Hi Lionel,

I use a shell script using scp to sync the sqlgrey.conf files on both
servers. I just checked them and they match.=20

Steffen=20

-----Original Message-----
From: sql...@li...
[mailto:sql...@li...] On Behalf Of Lionel
Bouton
Sent: Wednesday, September 14, 2005 11:16 AM
To: sql...@li...
Subject: Re: [Sqlgrey-users] Duplicate connect records

A quick note: is there anything obvious returned by a diff between the
sqlgrey.conf files on the two greylisting servers? You could have
surprising problems if they aren't synchronised properly.

Lionel.


-------------------------------------------------------
SF.Net email is sponsored by:
Tame your development challenges with Apache's Geronimo App Server.
Download it for free - -and be entered to win a 42" plasma tv or your
very own Sony(tm)PSP.  Click here to play:
http://sourceforge.net/geronimo.php
_______________________________________________
Sqlgrey-users mailing list
Sql...@li...
https://lists.sourceforge.net/lists/listinfo/sqlgrey-users


-------------------------------------------------------
SF.Net email is sponsored by:
Tame your development challenges with Apache's Geronimo App Server.
Download it for free - -and be entered to win a 42" plasma tv or your
very own Sony(tm)PSP.  Click here to play:
http://sourceforge.net/geronimo.php
_______________________________________________
Sqlgrey-users mailing list
Sql...@li...
https://lists.sourceforge.net/lists/listinfo/sqlgrey-users