I hate eximstats

[billyrobot]

Oh man do I ever! Eximstats has never given me anything but trouble.

My current problem:
exim stats appears to be running when I check status in WHM. When I restart cpanel from the command line, eximstats starts ok (no mysql DB issues, no missing perl modules as far as I can tell). However, I get an email every 2-5 minutes in my inbox telling me that eximstats has failed. I've run upcp, so that's not a solution, and I'm using a current version of WHM/cpanel. I've tried disabling eximstats in the service manager and in tweak settings, to no avail -- I still get the messages.

Is there anyway I can stop this eximspam? Tips are much appreciated!

best,
BR

[mr.wonderful]

run /etc/init.d/chkservd restart three times in succession then see if eximstats shuts up.

[equens]

/usr/local/cpanel/bin/checkperlmodules
/scripts/cleanmd5
/etc/init.d/cpanel restart

Maybe this will help

[cpanelnick]

Have you tried the latest CURRENT build? It works around some problems with perl.

[Promethyl]

Nah man. That's not going to do any good.

I have the same problem as the above user.

When I restarted cpanel, I got ...

Stopping mailman services: Shutting down Mailman's master qrunner

Starting eximstats: DBI connect('eximstats:localhost','eximstats',...) failed: Access denied for user: 'eximstats@localhost' (Using password: YES) at /usr/local/cpanel/bin/eximstats line 262
Can't Connect at /usr/local/cpanel/bin/eximstats line 265.
[FAILED]

Further investigation showed I was missing the eximstat/eximstats db and table.

Could someone please provide a structure only dump of the tables in that db.

Michael

[Promethyl]

Here is the commands I used to fix mine:

CREATE DATABASE IF NOT EXISTS eximstats

mysql> GRANT ALL PRIVILEGES ON eximstats.* TO 'eximstats'@'localhost' IDENTIFIED BY 'THEPASSWORD' WITH GRANT OPTION;
Query OK, 0 rows affected (0.01 sec)

root@xbox [/~/]# ps -ef | grep stat
mailnull 3204 1 0 08:07 pts/0 00:00:00 /usr/bin/perl /usr/local/cpanel/bin/eximstats

Ironically, the process with run now... but I am still in need of the table schema dump as the tables are still missing in action.

[DigitalN]

I find that the tables (sends & smtp) in eximstats frequently crash too

# mysql eximstats

> check table sends;

repair if crashed

> repair table sends;

> check table smtp;

repair if crashed

> repair table smtp;

> quit

The tables are as follows

mysql> describe sends;
+-----------+-----------+------+-----+---------------------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------+-----------+------+-----+---------------------+-------+
| mailtime | datetime | | PRI | 0000-00-00 00:00:00 | |
| msgid | char(15) | | PRI | | |
| email | char(100) | | PRI | | |
| processed | int(11) | YES | | NULL | |
| user | char(30) | YES | MUL | NULL | |
| size | int(11) | YES | | NULL | |
| ip | char(20) | YES | | NULL | |
| auth | char(20) | YES | | NULL | |
+-----------+-----------+------+-----+---------------------+-------+


mysql> describe smtp;
+-----------+-----------+------+-----+---------------------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------+-----------+------+-----+---------------------+-------+
| mailtime | datetime | | PRI | 0000-00-00 00:00:00 | |
| msgid | char(15) | | PRI | | |
| email | char(100) | | PRI | | |
| processed | int(11) | YES | MUL | NULL | |
+-----------+-----------+------+-----+---------------------+-------+


eximstats.sql

DROP TABLE IF EXISTS 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;

DROP TABLE IF EXISTS 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;

mysql eximstats < eximstats.sql

should do it.

[bidouilleur]

I had a problem with eximstats a few days ago. I was reading in this forum and found another solution for my problem, not sure it wil help you since I have the impression there are several reasons for it's failure

In my case I had to initiate a new root password for Mysql. In WHM in the Mysql section you can give a new password.... seems that eximstats missed the password and simply couldn't write to it's database. In my case it all ended the errors.

Might as well try it.

[Promethyl]

I dropped the tables in the eximstats db as you suggested...

It shows eximstats running, and there are now entries in the tables... But the service manager still shows eximstats as not running... What might I be doing wrong?

root@box [~]# /etc/init.d/cpanel restart
Stopping cPanel services: [ OK ]
Stopping pop3 services: [ OK ]
Stopping cPanel log services: [ OK ]
Stopping cPanel Chat services: [ OK ]
Stopping cPanel ssl services: [ OK ]

Stopping mailman services: Shutting down Mailman's master qrunner

Starting eximstats: [ OK ]
Starting cPanel services: [ OK ]
Starting cPanel Log services: [ OK ]
Starting pop3 services: [ OK ]
Starting cPanel Chat services: [ OK ]
Starting Melange Chat services:
Starting cPanel ssl services: [ OK ]
Starting mailman services: Starting Mailman's master qrunner.

root@box [~]# ps -ef | grep eximstats
mailnull 31759 1 0 15:03 pts/1 00:00:00 /usr/bin/perl /usr/local/cpanel/bin/eximstats
root 31970 17850 0 15:04 pts/1 00:00:00 grep eximstats

[Promethyl]

I ran this like four times, syncing in between. Probably not necessary... but ... hey. Overkill never killed anyone.

/etc/init.d/chkservd restart

->>> DigitalN, you rule!