SEMI-OFFTOPIC
ricky gutierrez
xserverlinux at gmail.com
Mon Feb 16 12:44:55 CET 2015
Hi list, I write looking for some help, I'm using amavisd-new 2.8 on
centos 6.6 and MailZu , amavisd-new patch to work with mailzu, but
every time I connect to the web interface tells me connection with DB
fail, try several times and managed to connect after 5 attempts.
has anyone had this problem?
I've also tried to work the script that cleans the db MailZu, I run
and pretends clean the tables, but really did not
look
Executing... Sun Feb 15 21:31:00 2015
DELETE FROM msgrcpt WHERE rs='D'
229 rows affected
Executing... Sun Feb 15 21:31:00 2015
DELETE FROM msgs WHERE time_num < 1424053860 AND content IS NULL
172 rows affected
Executing... Sun Feb 15 21:31:00 2015
DELETE msgs FROM msgs LEFT JOIN msgrcpt USING(mail_id) WHERE
msgrcpt.mail_id IS NULL
205 rows affected
Executing... Sun Feb 15 21:31:00 2015
DELETE FROM msgs WHERE time_num < 1423452660
0E0 rows affected
Executing... Sun Feb 15 21:31:00 2015
DELETE quarantine FROM quarantine LEFT JOIN msgs USING(mail_id) WHERE
msgs.mail_id IS NULL
0E0 rows affected
Executing... Sun Feb 15 21:31:00 2015
DELETE msgrcpt FROM msgrcpt LEFT JOIN msgs USING(mail_id) WHERE
msgs.mail_id IS NULL
0E0 rows affected
Executing... Sun Feb 15 21:31:00 2015
DELETE FROM maddr WHERE NOT EXISTS (SELECT sid FROM msgs WHERE
sid=id) AND NOT EXISTS (SELECT rid FROM msgrcpt WHERE rid=id)
216 rows affected
Database cleanup successful
Any idea?
--
rickygm
http://gnuforever.homelinux.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.amavis.org/pipermail/amavis-users/attachments/20150216/dbf6bb9d/attachment.html>
More information about the amavis-users
mailing list