RE: [Sqlgrey-users] Duplicate connect records

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

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?

select sender_name, sender_domain, src,
count(sender_name+sender_domain+src) as count from connect group by
sender_name, sender_domain, src;

+-------------------------------------------------+---------------------
+-----------------+-------+
| sender_name                                     | sender_domain
| src             | count |
+-------------------------------------------------+---------------------
+-----------------+-------+
| -undef-                                         | -undef-
| 168.159.186     |     1 |
| -undef-                                         | -undef-
| 200.228.0.130   |     1 |
| -undef-                                         | -undef-
| 203.92.82.98    |     1 |
| -undef-                                         | -undef-
| 205.254.25.211  |     1 |
| aagbe.aagbe                                     | brantbrant.net
| 218.187.100.249 |     1 |
| aagnl.aagnl                                     | alvaalva.com
| 218.187.100.249 |     1 |
| account                                         | chase.com
| 62.193.214.159  |     4 |
| admin                                           | fivecolleges.edu
| 24.60.30.10     |     1 |
| antifraud                                       | chase.com
| 62.193.214      |     1 |
| b.dealchamp.0-5e1cf85-519f.amherst.edu.-dacetto | 22.asp070.com
| 69.6.65         |     1 |
| confirm                                         | chase.com
| 62.193.214.159  |     4 |
| greggfi                                         | fusemail.com
| 221.141.131.14  |     1 |
| morgantnwpaxczqu                                | verizon.net
| 70.22.253.236   |     1 |
| mrimmer                                         | unb.ca
| 206.47.199      |     1 |
| nmkidiqafukyo                                   | go.com
| 220.190.37.160  |     1 |
| north                                           | takuyakimura.com
| 201.34.80.220   |     1 |
| rtertee3e                                       | ert354tg.dyndns.org
| 61.111.231.68   |     1 |
| sara.goldstein                                  | teachforamerica.org
| 216.82.244      |     1 |
| service                                         | chase.com
| 62.193.214.159  |     4 |
| support                                         | chase.com
| 62.193.214      |     1 |
| support                                         | chase.com
| 62.193.214.159  |     1 |
| swig                                            | wigco.com
| 207.190.209     |     1 |
| symantecsmtpgateway                             | timetrak.com
| 69.223.125      |     1 |
+-------------------------------------------------+---------------------
+-----------------+-------+=20

Steffen

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

Steffen Plotner wrote the following on 14.09.2005 05:53 :

>Hi Lionel,
>=20
>Thank you for the info about the connect table - good to know that I am
on the right track.  What do we have you ask?
>=20
>We run RedHat AS4 on grey1.amherst.edu and grey2.amherst.edu servers.
The mysql database backend is located on another server also running
RedHat AS4 (no mysql replication). All machines are sync'd with NTP to
our DNS servers.
>=20
>Versions:
>sqlgrey-1.7.0-1.noarch.rpm    from sourceforge, using rpmbuild -ta
sqlgrey-<version>.tar.bz2
>IO-Multiplex-1.08.tar.gz
>Net-Server-0.88.tar.gz
>perl-5.8.5
>perl-DBI-1.40
>mysql-4.1.10a
>postfix-2.1.5
>=20
>Should I be running the 1.6.5 version (stable version)?
> =20
>

If you don't want to be a beta tester, yes :-)

I don't see any obvious problem with the software versions, I'll take
time to check the code to find out if something introduced a bug in
1.7.x and I'll be back to you.

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