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