Eximstats not reporting.

phild

• February 20, 2015 09:34

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

  • February 23, 2015 12:35

  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.

  0
• 

  phild

  • February 23, 2015 15:58

  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 [/]# _

  0
• 

  cPanelMichael

  • February 24, 2015 12:08

  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.

  0

Please sign in to leave a comment.