The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

I hate eximstats

Discussion in 'General Discussion' started by billyrobot, Jan 17, 2005.

  1. billyrobot

    billyrobot Active Member

    Joined:
    Feb 18, 2004
    Messages:
    25
    Likes Received:
    0
    Trophy Points:
    1
    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
     
  2. mr.wonderful

    mr.wonderful BANNED

    Joined:
    Feb 1, 2004
    Messages:
    345
    Likes Received:
    0
    Trophy Points:
    0
    run /etc/init.d/chkservd restart three times in succession then see if eximstats shuts up.
     
  3. equens

    equens Well-Known Member

    Joined:
    Feb 8, 2002
    Messages:
    270
    Likes Received:
    0
    Trophy Points:
    16
    /usr/local/cpanel/bin/checkperlmodules
    /scripts/cleanmd5
    /etc/init.d/cpanel restart

    Maybe this will help
     
  4. cPanelNick

    cPanelNick Administrator
    Staff Member

    Joined:
    Mar 9, 2015
    Messages:
    3,426
    Likes Received:
    2
    Trophy Points:
    38
    cPanel Access Level:
    DataCenter Provider
    Have you tried the latest CURRENT build? It works around some problems with perl.
     
  5. Promethyl

    Promethyl Well-Known Member

    Joined:
    Mar 27, 2004
    Messages:
    68
    Likes Received:
    0
    Trophy Points:
    6
    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
     
  6. Promethyl

    Promethyl Well-Known Member

    Joined:
    Mar 27, 2004
    Messages:
    68
    Likes Received:
    0
    Trophy Points:
    6
    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.
     
  7. DigitalN

    DigitalN Well-Known Member

    Joined:
    Sep 23, 2004
    Messages:
    420
    Likes Received:
    1
    Trophy Points:
    18
    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.
     
    #7 DigitalN, Jan 22, 2005
    Last edited: Jan 22, 2005
  8. bidouilleur

    bidouilleur Well-Known Member

    Joined:
    Apr 27, 2003
    Messages:
    46
    Likes Received:
    0
    Trophy Points:
    6
    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.
     
  9. Promethyl

    Promethyl Well-Known Member

    Joined:
    Mar 27, 2004
    Messages:
    68
    Likes Received:
    0
    Trophy Points:
    6
    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
     
  10. Promethyl

    Promethyl Well-Known Member

    Joined:
    Mar 27, 2004
    Messages:
    68
    Likes Received:
    0
    Trophy Points:
    6
    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!
     
Loading...

Share This Page