Mails displayed twice in admin spam quarantine list

Problems/questions regarding MailCleaner installation

Moderators: Pascal, mentor, FlorianB, bourgeois

Studi
Posts: 5
Joined: Mon Jan 15, 2018 12:25 pm
How did you hear about Mailcleaner: Internet

Mails displayed twice in admin spam quarantine list

Postby Studi » Fri Jan 19, 2018 8:22 am

In Mailcleaner 2017 every email in admin spam quarantine lists are displayed twice.

quarantine.png
quarantine.png (16.58 KiB) Viewed 432 times


They are physically stored in the spam log database with same message id twice.

+------------+----------+-------------+--------------+----------------------+------------------+--------+--------------------------------------------------+--------+-----------+-------------+--------+-------------+---------+---------------+---------------+
| date_in | time_in | to_domain | to_user | sender | exim_id | M_date | M_subject | forced | in_master | store_slave | M_rbls | M_prefilter | M_score | M_globalscore | is_newsletter |
+------------+----------+-------------+--------------+----------------------+------------------+--------+--------------------------------------------------+--------+-----------+-------------+--------+-------------+---------+---------------+---------------+
| 2018-01-18 | 12:19:18 | example.com | recipient | sender@example.com | 1ec8Dp-0000AM-EA | NULL | =?UTF-8?Q?K=C3=B6nnen_Angebote_selig_machen=3F?= | 1 | 0 | 1 | 0 | SpamC | 0.100 | 0 | 1 |
| 2018-01-18 | 12:19:18 | example.com | recipient | sender@example.com | 1ec8Dp-0000AM-EA | NULL | =?UTF-8?Q?K=C3=B6nnen_Angebote_selig_machen=3F?= | 1 | 0 | 1 | 0 | SpamC | 0.100 | 0 | 1 |
+------------+----------+-------------+--------------+----------------------+------------------+--------+--------------------------------------------------+--------+-----------+-------------+--------+-------------+---------+---------------+---------------+


From my understanding this should be impossible because of the multikey declaration of the table:

+---------------+---------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------------+---------------+------+-----+---------+-------+
| date_in | date | NO | MUL | NULL | |
| time_in | time | NO | | NULL | |
| to_domain | varchar(100) | NO | | NULL | |
| to_user | varchar(100) | NO | MUL | NULL | |
| sender | varchar(120) | NO | | NULL | |
| exim_id | varchar(16) | NO | MUL | NULL | |
| M_date | varchar(50) | YES | | NULL | |
| M_subject | varchar(250) | YES | | NULL | |
| forced | enum('1','0') | NO | | 0 | |
| in_master | enum('1','0') | NO | | 0 | |
| store_slave | int(11) | NO | | NULL | |
| M_rbls | varchar(250) | YES | | NULL | |
| M_prefilter | varchar(250) | YES | | NULL | |
| M_score | decimal(7,3) | YES | | NULL | |
| M_globalscore | int(11) | YES | | NULL | |
| is_newsletter | enum('1','0') | NO | | 0 | |
+---------------+---------------+------+-----+---------+-------+


Any ideas?
mmarable
Posts: 14
Joined: Fri Feb 09, 2018 7:25 pm
How did you hear about Mailcleaner: Internet
Contact:

Re: Mails displayed twice in admin spam quarantine list

Postby mmarable » Tue Feb 20, 2018 9:37 pm

Try checking the box "Show multi-recipient messages only once" and then refresh the results
Matthew Marable
Sr. Solutions Architect
Open Source Consultant

@: mmarable@oitibs.com
W: https://www.oitibs.com
scorpian
Posts: 3
Joined: Sat Mar 17, 2018 5:55 am
How did you hear about Mailcleaner: Using this for years

Re: Mails displayed twice in admin spam quarantine list

Postby scorpian » Tue Apr 03, 2018 12:55 pm

hi

I'm too facing the same issue . MailCleaner version is 2018.02 , patch level is 2018011901

each and every SPAM mails are listed twice in the quarantine list.

please help to fix this

Thank You
Scorpian
FlorianB
Posts: 296
Joined: Wed Apr 01, 2015 2:27 pm
How did you hear about Mailcleaner: job

Re: Mails displayed twice in admin spam quarantine list

Postby FlorianB » Tue Apr 03, 2018 1:08 pm

Hello,
The DB constraint should avoid that to happens....
So I suppose people concerned have synchronization problem.
Could you try commands to check synchro and resync_db.sh to resolve it.
Regards,
Florian

Return to “Installation”

Who is online

Users browsing this forum: Bing [Bot] and 1 guest