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

Angel54689

Member
Oct 26, 2015
8
1
3
Bangladesh
cPanel Access Level
Root Administrator
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.

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

Code:
[[email protected] ~]# 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.
[emailtrack_search] version [1].
Some more information.

Code:
[[email protected] ~]# mysqlcheck eximstats
eximstats.defers                                   OK
eximstats.failures                                 OK
eximstats.sends                                    OK
eximstats.smtp                                     OK
Code:
[[email protected] ~]# 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: -
Code:
[[email protected] ~]# 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

Administrator
Staff member
Apr 11, 2011
47,910
2,213
363
Hello,

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

Code:
# runlevel
unknown
This will result in the following message /usr/local/cpanel/logs/tailwatchd.log, leading to issues with eximstats processing:

Code:
[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.
 
  • Like
Reactions: Angel54689

Angel54689

Member
Oct 26, 2015
8
1
3
Bangladesh
cPanel Access Level
Root Administrator
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.
 
  • Like
Reactions: cPanelMichael

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,910
2,213
363
I'm happy to see the issue is now resolved. Thank you for updating us with the outcome.