The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

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

Discussion in 'E-mail Discussions' started by Angel54689, Aug 31, 2016.

  1. Angel54689

    Angel54689 Registered

    Joined:
    Oct 26, 2015
    Messages:
    2
    Likes Received:
    1
    Trophy Points:
    3
    Location:
    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:
    [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.
    [emailtrack_search] version [1].
    Some more information.

    Code:
    [root@server1 ~]# mysqlcheck eximstats
    eximstats.defers                                   OK
    eximstats.failures                                 OK
    eximstats.sends                                    OK
    eximstats.smtp                                     OK
    Code:
    [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: -
    
    Code:
    [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?
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    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.
     
    Angel54689 likes this.
  3. Angel54689

    Angel54689 Registered

    Joined:
    Oct 26, 2015
    Messages:
    2
    Likes Received:
    1
    Trophy Points:
    3
    Location:
    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.
     
    cPanelMichael likes this.
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
Loading...

Share This Page