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.

Eximstats not reporting.

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

  1. phild

    phild Member

    Joined:
    Dec 2, 2003
    Messages:
    18
    Likes Received:
    0
    Trophy Points:
    1
    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 Forums Analyst
    Staff Member

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

    phild Member

    Joined:
    Dec 2, 2003
    Messages:
    18
    Likes Received:
    0
    Trophy Points:
    1
    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 Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    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.
     
Loading...
Similar Threads - Eximstats reporting
  1. keat63
    Replies:
    5
    Views:
    390

Share This Page