Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

Eximstats not reporting.

Discussion in 'E-mail Discussion' started by phild, Feb 20, 2015.

  1. phild

    phild Member

    Joined:
    Dec 2, 2003
    Messages:
    18
    Likes Received:
    0
    Trophy Points:
    151
    Hi,
    If I run a sent summary report, or a view relayers report I get the following error:

    Error from delivery reporter: DBD::mysql::db selectall_arrayref failed: Can't find file: 'sends' (errno: 2)

    If I try to repair the database i get:

    eximstats.defers
    Error : Can't find file: 'defers' (errno: 2)
    status : Operation failed
    eximstats.failures
    Error : Can't find file: 'failures' (errno: 2)
    status : Operation failed
    eximstats.sends
    Error : Can't find file: 'sends' (errno: 2)
    status : Operation failed
    eximstats.smtp
    Error : Can't find file: 'smtp' (errno: 2)
    status : Operation failed

    Any sites recently added to the VPS are not listed at all when running mail manager plugin.

    I have reset Exim but to no avail.

    Thank you for your help in advance.
     
  2. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,803
    Likes Received:
    1,897
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello :)

    You can delete the database via phpMyAdmin or the MySQL command line environment and regenerate it via:

    Code:
    /usr/local/cpanel/bin/updateeximstats
    If you want to import data back into the database, you can use a command such as:

    Code:
    /scripts/import_exim_data /var/log/exim_mainlog*
    Note that this command take a while to complete, depending on the amount of data logged to the Exim log.

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. phild

    phild Member

    Joined:
    Dec 2, 2003
    Messages:
    18
    Likes Received:
    0
    Trophy Points:
    151
    Hi,
    thank you for your reply. I tried the update and it generated the following:

    root [/]# /usr/local/cpanel/bin/updateeximstats
    mysqldiff failed: The “/usr/local/cpanel/3rdparty/perl/514/bin/mysqldiff” command (process 15503) reported the “ENOENT” (2) error when it ended.
    Output was: mysqldump failed. Exit status: 2:
    mysqldump: Got error: 1017: Can't find file: 'defers' (errno: 2) when using LOCK TABLES

    -- MySQL dump 10.13 Distrib 5.5.42, for Linux (x86_64)

    --

    -- Host: localhost Database: eximstats

    -- ------------------------------------------------------

    -- Server version 5.5.42-cll



    /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;

    /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;

    /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;

    /*!40101 SET NAMES utf8 */;

    /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;

    /*!40103 SET TIME_ZONE='+00:00' */;

    /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;

    /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;

    /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;

    /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
    root [/]# _
     
  4. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,803
    Likes Received:
    1,897
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Have you verified there's free disk space on this system? If so, please open a support ticket using the link in my signature so we can take a closer look. You can post the ticket number here so we can update this thread with the outcome.

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice