Maildelivery Report blank cPanel/WHM

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 🙂