Eximstats not reporting.

[phild]

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.

 

[cPanelMichael]

Hello

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

/usr/local/cpanel/bin/updateeximstats

If you want to import data back into the database, you can use a command such as:

/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.

 

[phild]

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 @[email protected]@CHARACTER_SET_CLIENT */;

/*!40101 SET @[email protected]@CHARACTER_SET_RESULTS */;

/*!40101 SET @[email protected]@COLLATION_CONNECTION */;

/*!40101 SET NAMES utf8 */;

/*!40103 SET @[email protected]@TIME_ZONE */;

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

/*!40014 SET @[email protected]@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;

/*!40014 SET @[email protected]@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;

/*!40101 SET @[email protected]@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;

/*!40111 SET @[email protected]@SQL_NOTES, SQL_NOTES=0 */;
root [/]# _

 

[cPanelMichael]

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.