Mail Delivery Reports not working after updating to 58.0 (build 25)

Hello, I'm having a problem with eximstats, mail delivery report of WHM is not showing any recent mail activity. And it's showing an error.

Error from delivery reporter: Can't call method "quote" on an undefined value at /usr/local/cpanel/Cpanel/DeliveryReporter.pm line 470.

Error log.

[root@server1 ~]# tail -f /usr/local/cpanel/logs/error_log
        Whostmgr::API::1::Exim::search(HASH(0x1f37760), HASH(0x5fe85a0), HASH(0x1f365d8)) called at whostmgr/bin/xml-api.pl line 2972
        whostmgr::bin::xml_api::__ANON__(HASH(0x5fe85a0), HASH(0x1f37760), HASH(0x1f365d8), CODE(0x6e22d58)) called at /usr/local/cpanel/Whostmgr/API/1/Data/Wrapper.pm line 217
        Whostmgr::API::1::Data::Wrapper::try {...} () called at /usr/local/cpanel/3rdparty/perl/522/lib64/perl5/cpanel_lib/Try/Tiny.pm line 80
        eval {...} called at /usr/local/cpanel/3rdparty/perl/522/lib64/perl5/cpanel_lib/Try/Tiny.pm line 71
        Try::Tiny::try(CODE(0x60e78a8), Try::Tiny::Catch=REF(0x72db0c0)) called at /usr/local/cpanel/Whostmgr/API/1/Data/Wrapper.pm line 236
        Whostmgr::API::1::Data::Wrapper::execute_internal(CODE(0x6132268), HASH(0x1f37760), HASH(0x1f365d8), HASH(0x6af6440), CODE(0x6e22d58)) called at whostmgr/bin/xml-api.pl line 3123
        whostmgr::bin::xml_api::runapp("emailtrack_search", HASH(0x1f365d8), HASH(0x1f4f850), 0, CODE(0x6e22d58)) called at whostmgr/bin/xml-api.pl line 2905
        whostmgr::bin::xml_api::script(CODE(0x6e22d58), "-json", "./emailtrack_search") called at whostmgr/bin/xml-api.pl line 2857
[2016-09-01 08:04:58 +0600] info [xml-api] Error from delivery reporter: Can't call method "quote" on an undefined value at /usr/local/cpanel/Cpanel/DeliveryReporter.pm line 470.
track_search] version [1].

Some more information.

[root@server1 ~]# mysqlcheck eximstats
eximstats.defers                                   OK
eximstats.failures                                 OK
eximstats.sends                                    OK
eximstats.smtp                                     OK

[root@server1 ~]# stat /usr/local/cpanel/bin/updateeximstats
  File: "/usr/local/cpanel/bin/updateeximstats"
  Size: 3729            Blocks: 8          IO Block: 4096   regular file
Device: 803h/2051d      Inode: 3250955677  Links: 1
Access: (0755/-rwxr-xr-x)  Uid: (    0/    root)   Gid: (    0/    root)
Access: 2016-08-31 08:30:11.436768484 +0600
Modify: 2016-08-04 13:47:33.528273011 +0600
Change: 2016-08-04 13:49:46.933421104 +0600
Birth: -

[root@server1 ~]# grep eximstats /usr/local/cpanel/logs/tailwatchd_log
Cpanel::DBI::Mysql connect('','eximstats',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) at /usr/local/cpanel/Cpanel/DBI.pm line 89.
[2759] [2016-06-03 12:41:42 +0600] [Cpanel::TailWatch] [INFO] Opened /var/cpanel/sql/eximstats.sql in append mode
Cpanel::DBI::Mysql connect('','eximstats',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) at /usr/local/cpanel/Cpanel/DBI.pm line 89.
Cpanel::DBI::Mysql connect('','eximstats',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) at /usr/local/cpanel/Cpanel/DBI.pm line 89.
Cpanel::DBI::Mysql connect('','eximstats',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) at /usr/local/cpanel/Cpanel/DBI.pm line 89.
Cpanel::DBI::Mysql connect('','eximstats',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) at /usr/local/cpanel/Cpanel/DBI.pm line 89.
Cpanel::DBI::Mysql connect('','eximstats',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) at /usr/local/cpanel/Cpanel/DBI.pm line 89.
Cpanel::DBI::Mysql connect('','eximstats',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) at /usr/local/cpanel/Cpanel/DBI.pm line 89.
Cpanel::DBI::Mysql connect('','eximstats',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) at /usr/local/cpanel/Cpanel/DBI.pm line 89.
Cpanel::DBI::Mysql connect('','eximstats',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) at /usr/local/cpanel/Cpanel/DBI.pm line 89.
Cpanel::DBI::Mysql connect('','eximstats',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) at /usr/local/cpanel/Cpanel/DBI.pm line 89.
Cpanel::DBI::Mysql connect('','eximstats',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) at /usr/local/cpanel/Cpanel/DBI.pm line 89.
Cpanel::DBI::Mysql connect('','eximstats',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) at /usr/local/cpanel/Cpanel/DBI.pm line 89.
Cpanel::DBI::Mysql connect('','eximstats',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) at /usr/local/cpanel/Cpanel/DBI.pm line 89.
Cpanel::DBI::Mysql connect('','eximstats',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) at /usr/local/cpanel/Cpanel/DBI.pm line 89.
Cpanel::DBI::Mysql connect('','eximstats',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) at /usr/local/cpanel/Cpanel/DBI.pm line 89.
Cpanel::DBI::Mysql connect('','eximstats',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) at /usr/local/cpanel/Cpanel/DBI.pm line 89.
Cpanel::DBI::Mysql connect('','eximstats',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) at /usr/local/cpanel/Cpanel/DBI.pm line 89.
Cpanel::DBI::Mysql connect('','eximstats',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) at /usr/local/cpanel/Cpanel/DBI.pm line 89.
Cpanel::DBI::Mysql connect('','eximstats',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) at /usr/local/cpanel/Cpanel/DBI.pm line 89.
Cpanel::DBI::Mysql connect('','eximstats',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) at /usr/local/cpanel/Cpanel/DBI.pm line 89.
Cpanel::DBI::Mysql connect('','eximstats',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) at /usr/local/cpanel/Cpanel/DBI.pm line 89.
Cpanel::DBI::Mysql connect('','eximstats',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) at /usr/local/cpanel/Cpanel/DBI.pm line 89.
Cpanel::DBI::Mysql connect('','eximstats',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) at /usr/local/cpanel/Cpanel/DBI.pm line 89.
Cpanel::DBI::Mysql connect('','eximstats',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) at /usr/local/cpanel/Cpanel/DBI.pm line 89.
Cpanel::DBI::Mysql connect('','eximstats',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) at /usr/local/cpanel/Cpanel/DBI.pm line 89.
Cpanel::DBI::Mysql connect('','eximstats',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) at /usr/local/cpanel/Cpanel/DBI.pm line 89.
Cpanel::DBI::Mysql connect('','eximstats',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) at /usr/local/cpanel/Cpanel/DBI.pm line 89.
Cpanel::DBI::Mysql connect('','eximstats',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) at /usr/local/cpanel/Cpanel/DBI.pm line 89.
Cpanel::DBI::Mysql connect('','eximstats',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) at /usr/local/cpanel/Cpanel/DBI.pm line 89.
Cpanel::DBI::Mysql connect('','eximstats',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) at /usr/local/cpanel/Cpanel/DBI.pm line 89.
Cpanel::DBI::Mysql connect('','eximstats',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) at /usr/local/cpanel/Cpanel/DBI.pm line 89.
Cpanel::DBI::Mysql connect('','eximstats',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) at /usr/local/cpanel/Cpanel/DBI.pm line 89.
Cpanel::DBI::Mysql connect('','eximstats',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) at /usr/local/cpanel/Cpanel/DBI.pm line 89.
Cpanel::DBI::Mysql connect('','eximstats',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) at /usr/local/cpanel/Cpanel/DBI.pm line 89.
Cpanel::DBI::Mysql connect('','eximstats',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) at /usr/local/cpanel/Cpanel/DBI.pm line 89.
[11488] [2016-07-13 11:08:55 +0600] [Cpanel::TailWatch] [INFO] Opened /var/cpanel/sql/eximstats.sql in append mode
Cpanel::DBI::Mysql connect('','eximstats',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) at /usr/local/cpanel/Cpanel/DBI.pm line 89.
Cpanel::DBI::Mysql connect('','eximstats',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) at /usr/local/cpanel/Cpanel/DBI.pm line 89.
Cpanel::DBI::Mysql connect('','eximstats',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) at /usr/local/cpanel/Cpanel/DBI.pm line 89.
Cpanel::DBI::Mysql connect('','eximstats',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) at /usr/local/cpanel/Cpanel/DBI.pm line 89.
Cpanel::DBI::Mysql connect('','eximstats',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) at /usr/local/cpanel/Cpanel/DBI.pm line 89.
Cpanel::DBI::Mysql connect('','eximstats',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) at /usr/local/cpanel/Cpanel/DBI.pm line 89.
Cpanel::DBI::Mysql connect('','eximstats',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) at /usr/local/cpanel/Cpanel/DBI.pm line 89.
Cpanel::DBI::Mysql connect('','eximstats',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) at /usr/local/cpanel/Cpanel/DBI.pm line 89.
Cpanel::DBI::Mysql connect('','eximstats',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) at /usr/local/cpanel/Cpanel/DBI.pm line 89.
Cpanel::DBI::Mysql connect('','eximstats',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) at /usr/local/cpanel/Cpanel/DBI.pm line 89.
Cpanel::DBI::Mysql connect('','eximstats',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) at /usr/local/cpanel/Cpanel/DBI.pm line 89.
Cpanel::DBI::Mysql connect('','eximstats',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) at /usr/local/cpanel/Cpanel/DBI.pm line 89.
Cpanel::DBI::Mysql connect('','eximstats',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) at /usr/local/cpanel/Cpanel/DBI.pm line 105.
Cpanel::DBI::Mysql connect('','eximstats',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) at /usr/local/cpanel/Cpanel/DBI.pm line 105.
Cpanel::DBI::Mysql connect('','eximstats',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) at /usr/local/cpanel/Cpanel/DBI.pm line 105.
[6188] [2016-08-30 01:26:48 +0600] [Cpanel::TailWatch] [INFO] Opened /var/cpanel/sql/eximstats.sql in append mode
Cpanel::DBI::Mysql connect('','eximstats',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) at /usr/local/cpanel/Cpanel/DBI.pm line 105.

I wanted to open a ticket. But cPanel takes a lot of time to reply. So I was wondering if anyone has any suggestion?

cPanelMichael

September 01, 2016 13:55

Hello, Per the support ticket opened for this issue, it was determined this issue relates to the runlevel set on the operating system:

# runlevel
unknown

This will result in the following message /usr/local/cpanel/logs/tailwatchd.log, leading to issues with eximstats processing:
[Cpanel::TailWatch] [INFO] Waiting for server to finish booting.
The following third-party URL offers instructions on changing the runlevel on the system: How to change a runlevel on RHEL 7 Linux system Thank you.

Angel54689

September 01, 2016 14:50

Hi Michael, Thanks a lot for your wonderful support and because you proved me wrong. cPanel support is even faster than the forum moderator (my post was awaiting moderation). Anyway, the problem is now solved. I created a systemd service for autostarting a simple shell script, yesterday. I am guessing, I messed up the unit file. I removed the systemd service file, and rebooted the server, that fixed the problem. Thanks a lot again.

September 01, 2016 18:18

I'm happy to see the issue is now resolved. Thank you for updating us with the outcome.

Mail Delivery Reports not working after updating to 58.0 (build 25)

Comments

Didn't find what you were looking for?