Error in WHM Mail Reports

Avatar
  • Answered
Hi,

WHM throw an error when I ask for a mail delivery report or any kind of summary. The error i:

DeliveryReporter API internal failure: DBD::mysql::db selectall_arrayref failed: File './eximstats/smtp.MYD' not found (Errcode: 2) at /usr/local/cpanel/Cpanel/Exception.pm line 96 Cpanel::Exception::new('Cpanel::Exception::Database::Error', 'Cpanel::ExceptionMessage::Raw=SCALAR(0x2444950)', 'HASH(0x29abdb8)') called at /usr/local/cpanel/Cpanel/Exception.pm line 47 Cpanel::Exception::create('Database::Error', 'Cpanel::ExceptionMessage::Raw=SCALAR(0x2444950)', 'HASH(0x29abdb8)') called at /usr/local/cpanel/Cpanel/Exception.pm line 55 Cpanel::Exception::create_raw('Database::Error', 'DBD::mysql::db selectall_arrayref failed: File \'./eximstats/...', 'HASH(0x29abdb8)') called at /usr/local/cpanel/Cpanel/DBI.pm line 79 Cpanel::DBI::_create_exception('Cpanel::DBI::Mysql::db=HASH(0x2a1ada8)', 'DBD::mysql::db selectall_arrayref failed: File \'./eximstats/...', undef) called at /usr/local/cpanel/Cpanel/DBI.pm line 70 Cpanel::DBI::_error_handler('DBD::mysql::db selectall_arrayref failed: File \'./eximstats/...', 'Cpanel::DBI::Mysql::db=HASH(0x2a1ada8)', undef) called at /usr/local/cpanel/Cpanel/DeliveryReporter.pm line 477 Cpanel::DeliveryReporter::query('Cpanel::DeliveryReporter=HASH(0x2a15810)', 'success', 1, 'maxsendunixtime', 1411654260, 'deliverytype', 'remote', 'dir', 'desc', ...) called at /usr/local/cpanel/bin/emailtrack line 53 eval {...} called at /usr/local/cpanel/bin/emailtrack line 53

Tks in advance

Andre Sa
Avatar
johnpaulb-imhs1
Hello Andre, Thank you for your question. This problem is typically caused by a database issue. You can repair databases via command line:
  1. Login to your server via SSH.
  2. Run this command:

    mysqlcheck --all-databases --auto-repair

After the databases are repaired,you should be able to access reports. If you have any further questions, feel free to post them below. Thank you, John-Paul