Maildevery Report sometimes does not seem to work in WHM .
The issue is due to corruption in exims stats database and tables in it
Below is the fix for same
#Login to Mysql as root
root@host [/var/lib/mysql]# mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 646659
Server version: 5.5.42-cll MySQL Community Server (GPL)
Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.
#Drop database eximstats
mysql> drop database eximstats;
Query OK, 4 rows affected (0.05 sec)
Create new database eximstats;
mysql> create database eximstats;
Query OK, 1 row affected (0.00 sec)
mysql> quit
Bye
Now restore eximstats tables using below command
root@host [/var/lib/mysql]# mysql eximstats < /usr/local/cpanel/etc/eximstats_db.sql
#Update stats using below command
root@host [~]# /usr/local/cpanel/bin/updateeximstats
updateeximstats: database schema is up to date.
Now delivery report in WHM should show results 🙂