jadmire

Registered
Mar 13, 2004
2
0
151
I've also been getting "eximstats failed" messages every eight minutes or so since about 7 pm last evening. This is very puzzling since everything else on the server seems to be working fine, including mail services. I tried the fixes described for editing my.cnf and repairing the eximstats database in WHM, but nothing seems to have worked so far. I am wondering whether I might not do better just to turn eximstats off if I can, because from what I read, all eximstats really does is to collect statistics on incoming and outgoing email. Since I'm the only person using my server, I wonder whether eximstats is really critical to the proper operation of the server.

-Joe-
 

spike326

Member
Jan 18, 2004
10
0
151
Originally posted by jadmire
I've also been getting "eximstats failed" messages every eight minutes or so since about 7 pm last evening. This is very puzzling since everything else on the server seems to be working fine, including mail services. I tried the fixes described for editing my.cnf and repairing the eximstats database in WHM, but nothing seems to have worked so far. I am wondering whether I might not do better just to turn eximstats off if I can, because from what I read, all eximstats really does is to collect statistics on incoming and outgoing email. Since I'm the only person using my server, I wonder whether eximstats is really critical to the proper operation of the server.

-Joe-
I believe I was able to fix it, as I dont receive any failed messages. In WHM I just updated cpanel, then when to "Restart Services" and selected Mail Server (EXIM), then did a graceful reboot. Let me know if it works for you.
 

jadmire

Registered
Mar 13, 2004
2
0
151
The only problem with that is, I think I'm already at the most recent version. See, the kernel went bad on my server at the beginning of this week, and my host had to do a reinstall on Tuesday. They put in the current build of Apache and, I think, the current build of WHM/CPanel at that time; the build is 9.1.0-RELEASE 72. Could be that a graceful reboot of the server might be what's needed, though.

-Joe-
 

inkandpixel

Registered
Jul 11, 2003
2
0
151
WHM 9.1.0 cPanel 9.1.0-R72
RedHat 7.3 - WHM X v2.1.2

I am having eximstats/mysql/ftpd failingevery 5 minutes also. Any solutions?
 

beebware

Active Member
Aug 2, 2003
34
0
156
We're getting the same problem on WHM 9.1.0 cPanel 9.1.0-S93 RedHat 7.3 - WHM X v2.1.2: only started having the problems since the automatic upcp update which update MySQL for some strange, unknown, reason (i.e. it was previously up to date):
chkservd is up to date (Sun Jul 13 00:30:09 2003)
MySQL-server is not up to date (Sun Sep 7 19:57:37 2003)
Retrieving http://updates.cpanel.net/pub/sysup//7.3/MySQL-server/MySQL-server-4.0.18-0.i386.rpm
Preparing... ##################################################
Giving mysqld a couple of seconds to exit nicely
MySQL-server ##################################################
Installing all prepared tables
040311 2:04:03 /usr/sbin/mysqld: Shutdown Complete


PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/usr/bin/mysqladmin -u root password 'new-password'
/usr/bin/mysqladmin -u root -h cpanel.easyinternetsolutions.co.uk password 'new-password'
See the manual for more instructions.

NOTE: If you are upgrading from a MySQL <= 3.22.10 you should run
the /usr/bin/mysql_fix_privilege_tables. Otherwise you will not be
able to use the new GRANT command!

Please report any problems with the /usr/bin/mysqlbug script!

The latest information about MySQL is available on the web at
http://www.mysql.com
Support MySQL by buying support/licenses at https://order.mysql.com

MySQL-embedded is not up to date (Sun Sep 7 19:57:37 2003)
Retrieving http://updates.cpanel.net/pub/sysup//7.3/MySQL-embedded/MySQL-embedded-4.0.18-0.i386.rpm
Preparing... ##################################################
MySQL-embedded ##################################################
MySQL-client is not up to date (Sun Sep 7 19:57:37 2003)
Retrieving http://updates.cpanel.net/pub/sysup//7.3/MySQL-client/MySQL-client-4.0.18-0.i386.rpm
Preparing... ##################################################
MySQL-client ##################################################
MySQL-devel is not up to date (Sun Sep 7 19:57:37 2003)
Retrieving http://updates.cpanel.net/pub/sysup//7.3/MySQL-devel/MySQL-devel-4.0.18-0.i386.rpm
Preparing... ##################################################
MySQL-devel ##################################################
MySQL-bench is not up to date (Sun Sep 7 19:57:37 2003)
Retrieving http://updates.cpanel.net/pub/sysup//7.3/MySQL-bench/MySQL-bench-4.0.18-0.i386.rpm
Preparing... ##################################################
MySQL-bench ##################################################
MySQL-shared is not up to date (Sun Sep 7 19:57:37 2003)
Retrieving http://updates.cpanel.net/pub/sysup//7.3/MySQL-shared/MySQL-shared-4.0.18-0.i386.rpm
Preparing... ##################################################
MySQL-shared ##################################################
MySQL-shared-compat is not up to date (Tue Sep 9 17:01:42 2003)
Retrieving http://updates.cpanel.net/pub/sysup//7.3/MySQL-shared-compat/MySQL-shared-compat-4.0.18-0.i386.rpm
Preparing... ##################################################
MySQL-shared-compat ##################################################
portsentry is up to date (Wed Jan 30 02:02:40 2002)
Tried restarting MySQL and EXIM and still the mails come :(
 

inkandpixel

Registered
Jul 11, 2003
2
0
151
Here's what I did.

1 . Set my CPanel Update preferences to:
Manual Updates Only (RELEASE tree)

2. Ran CPanel Update
Upgrade to Latest Version

3. Restart Exim

4. Graceful Server Reboot

I haven't received anymore eximstats failed notices yet. (cross my fingers)
 

Dillard

Well-Known Member
Feb 26, 2003
114
0
166
The Netherlands
Had the same problem here. Driving me nuts with eighty thousand messages in two days.

Finally had some time to dive in: it seemed that somehow the eximstats database wasn't created and neither was the eximstats user.

I took the eximstats password from /var/cpane/eximstatspass and created a mysql user with this password.

Created a database eximstats and copied the structure from one of my other servers (I will include them below) and adjusted the specific database rights for the user eximstats on the database eximstats.

Then fired up /usr/local/cpanel/bin/eximstats and it worked !

Code:
# phpMyAdmin SQL Dump
# version 2.5.6-rc1
# [url]http://www.phpmyadmin.net[/url]
#
# Host: localhost
# Generation Time: Apr 06, 2004 at 11:24 PM
# Server version: 4.0.17
# PHP Version: 4.2.3
# 
# Database : `eximstats`
# 
DROP DATABASE `eximstats`;
CREATE DATABASE `eximstats`;
USE eximstats;

# --------------------------------------------------------

#
# Table structure for table `sends`
#

CREATE TABLE `sends` (
  `mailtime` datetime NOT NULL default '0000-00-00 00:00:00',
  `msgid` char(15) NOT NULL default '',
  `email` char(100) NOT NULL default '',
  `processed` int(11) default NULL,
  `user` char(30) default NULL,
  `size` int(11) default NULL,
  `ip` char(20) default NULL,
  `auth` char(20) default NULL,
  PRIMARY KEY  (`mailtime`,`msgid`,`email`),
  KEY `user_msgid_index` (`user`,`msgid`),
  KEY `msgid_index` (`msgid`)
) TYPE=MyISAM;

# --------------------------------------------------------

#
# Table structure for table `smtp`
#

CREATE TABLE `smtp` (
  `mailtime` datetime NOT NULL default '0000-00-00 00:00:00',
  `msgid` char(15) NOT NULL default '',
  `email` char(100) NOT NULL default '',
  `processed` int(11) default NULL,
  PRIMARY KEY  (`mailtime`,`msgid`,`email`),
  KEY `msgid_index` (`msgid`),
  KEY `processed_index` (`processed`)
) TYPE=MyISAM;
 

Blackknight

Member
Jul 12, 2003
9
0
151
I have the same problem. The databse is there, the mysql user is ok, eximstats is running, but WHm still shows it as being failed. It's really annoying since the customer is complaining about getting all of the eximstats failed messages.
 

tambo

Member
Apr 29, 2002
16
0
301
All I did was resetting Local MySQL Root Password. Now eximstats works perfectly ok.
 

faqall

Active Member
Jul 17, 2004
27
0
151
wait, how do you make databases as root so i can try that as after updating my kernal and doing a forceful reboot i notice that the eximstats failed.
 

flash7

Well-Known Member
Feb 16, 2004
201
0
166
same problem here,
RHL ES 3 - WHM 9.7.2 cPanel 9.7.7-R15

eximstats failed :mad:
 

okyanusmedya

Registered
Sep 6, 2004
1
0
151
I have this same problem.

My server information :
WHM 9.7.2 cPanel 9.7.7-R15
RedHat Enterprise 3 i686 - WHM X v3.1.0

This problem after cpanel upgrade:
kernel 2.4.21 20.ELPkg name/pattern
kernel-source 2.4.21 20.ELPkg name/pattern
kernel-utils 2.4 8.37.6Pkg name/pattern
perl 5.8.0 88.7 Pkg name/pattern
redhat-release 3ES 7.3 Config modified


now , eximstats failed.

[email protected] [~]# /usr/local/cpanel/bin/eximstats
Can't locate DBD/mysql.pm in @INC (@INC contains: /usr/lib/perl5/5.8.0/i386-linux-thread-multi /usr/lib/perl5/5.8.0 /usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi /
usr/lib/perl5/site_perl/5.8.0 /usr/lib/perl5/site_perl /usr/lib/perl5/vendor_perl/5.8.0/i386-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.0 /usr/lib/perl5/vendor_perl
/usr/lib/perl5/5.8.0/i386-linux-thread-multi /usr/lib/perl5/5.8.0 .) at /usr/local/cpanel/bin/eximstats line 258.
BEGIN failed--compilation aborted at /usr/local/cpanel/bin/eximstats line 258.