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.

eximstats failed

Discussion in 'General Discussion' started by nsusa, Nov 3, 2004.

  1. nsusa

    nsusa Well-Known Member

    Joined:
    Jun 30, 2004
    Messages:
    93
    Likes Received:
    1
    Trophy Points:
    8
    Location:
    Colorado, USA
    My Service Status window shows

    eximstats failed with an ugly red dot.

    Any idea how I can fix this? I restarted MySQL and Exim but it stays red.

    Chris
     
  2. useradmin

    useradmin Well-Known Member

    Joined:
    Oct 8, 2004
    Messages:
    107
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    INDIA
    fixesssss

    Hello...

    Please run following command it will solve ur problem

    /scripts/upcp --force
    restart exim from whm

    ..
     
  3. fjgaston

    fjgaston Member

    Joined:
    Oct 10, 2003
    Messages:
    10
    Likes Received:
    0
    Trophy Points:
    1
    Thank you very much useradmin !

    ... this procedure really works. :cool:
     
  4. ventrue21

    ventrue21 Registered

    Joined:
    Jun 3, 2003
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    What if eximstats still does not activate?
     
  5. Sinewy

    Sinewy Well-Known Member

    Joined:
    May 15, 2004
    Messages:
    367
    Likes Received:
    1
    Trophy Points:
    18
    Location:
    Sydney, Australia
    cPanel Access Level:
    DataCenter Provider
    the above by useradmin actually will not work.

    it was more of a coincidence that chkservd did another check through the services and found that eximstats was up as a result of the automagic restart.

    the right way to fix it:

    make sure the perl module "DBD::mysql" is installed. use the Install a Perl Module feature in WHM to do this.

    then:

    /etc/init.d/mysql restart
    /etc/init.d/cpanel restart
    /etc/init.d/chkservd restart

    this will fix eximstats most of the time.
     
  6. ventrue21

    ventrue21 Registered

    Joined:
    Jun 3, 2003
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    Eximstats is sill not running. Any thoughts?

    root@web1 [~]# /etc/init.d/mysql restart
    Killing mysqld with pid 8422
    Wait for mysqld to exit. done
    root@web1 [~]# /etc/init.d/cpanel restart
    Stopping cPanel services: [ OK ]
    Stopping pop3 services: [ OK ]
    Stopping cPanel log services: [FAILED]
    Stopping cPanel Chat services: [ OK ]
    Stopping Melange Chat services: [ OK ]
    Stopping InterChange services: [FAILED]
    Stopping cPanel ssl services: [ OK ]

    Stopping mailman services: Shutting down Mailman's master qrunner
    PID unreadable in: /usr/local/cpanel/3rdparty/mailman/data/master-qrunner.pid
    [Errno 2] No such file or directory: '/usr/local/cpanel/3rdparty/mailman/data/master-qrunner.pid'
    Is qrunner even running?

    Starting eximstats: Can't locate DBD/mysql.pm in @INC (@INC contains: /usr/lib/perl5/5.8.4/i686-linux /usr/lib/perl5/5.8.4 /usr/lib/perl5/site_perl/5.8.4/i686-linux /usr/lib/perl5/site_perl/5.8.4 /usr/lib/perl5/site_perl/5.8.0 /usr/lib/perl5/site_perl .) at /usr/local/cpanel/bin/eximstats line 258.
    BEGIN failed--compilation aborted at /usr/local/cpanel/bin/eximstats line 258.
    [FAILED]
    Starting cPanel services: [ OK ]
    Starting cPanel Log services: Can't locate DBD/mysql.pm in @INC (@INC contains: /usr/lib/perl5/5.8.4/i686-linux /usr/lib/perl5/5.8.4 /usr/lib/perl5/site_perl/5.8.4/i686-linux /usr/lib/perl5/site_perl/5.8.4 /usr/lib/perl5/site_perl/5.8.0 /usr/lib/perl5/site_perl . /usr/local/cpanel /usr/local/cpanel/3rdparty/lib/perl) at /usr/local/cpanel/cpanellogd line 43.
    BEGIN failed--compilation aborted at /usr/local/cpanel/cpanellogd line 43.
    [FAILED]
    Starting pop3 services: [ OK ]
    Starting cPanel Chat services: [ OK ]
    Starting Melange Chat services: [ OK ]
    Starting cPanel ssl services: [ OK ]
    Starting mailman services: Site list is missing: mailman

    root@web1 [~]# /etc/init.d/chkservd restart
    Stopping chkservd: [ OK ]
    Starting chkservd: [ OK ]
    root@web1 [~]#
     
  7. linux-image

    linux-image Well-Known Member

    Joined:
    Jun 8, 2004
    Messages:
    1,192
    Likes Received:
    1
    Trophy Points:
    38
    Location:
    India
    cPanel Access Level:
    Root Administrator
    what is the error given by the install perl module option at the WHM ?
     
  8. ventrue21

    ventrue21 Registered

    Joined:
    Jun 3, 2003
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    install perl module does not even find any perl modules. I don't really get any errors just the inablity to actually find a mod and install it. Trying to install via cpan is also proving to not work.
     
  9. linux-image

    linux-image Well-Known Member

    Joined:
    Jun 8, 2004
    Messages:
    1,192
    Likes Received:
    1
    Trophy Points:
    38
    Location:
    India
    cPanel Access Level:
    Root Administrator
    can u do an upcp and then try. sometimes the cpan needs some updates !
     
  10. ventrue21

    ventrue21 Registered

    Joined:
    Jun 3, 2003
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    that was one of the first things I tried. I ran the update utility and still no luck with the most recent version of cpanel...

    Any suggestions?
     
  11. inda

    inda Member

    Joined:
    Dec 28, 2004
    Messages:
    10
    Likes Received:
    0
    Trophy Points:
    1
    install

    rm -rf /home/.cpan/

    Code:
    /scripts/perlinstaller DBI::DBD
    /scripts/perlinstaller DBD::mysql
    
    
    
    /etc/init.d/mysql restart
    /etc/init.d/cpanel restart
    /etc/init.d/chkservd restart
    
    result:
    root@mail [~]# /etc/init.d/cpanel restart
    Stopping cPanel services:                                  [  OK  ]
    Stopping pop3 services:                                    [  OK  ]
    Stopping cPanel log services:                              [FAILED]
    Stopping cPanel Chat services:                             [  OK  ]
    Stopping Melange Chat services:                            [  OK  ]
    Stopping InterChange services:                             [FAILED]
    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:                            [  OK  ]
    Starting cPanel ssl services:                              [  OK  ]
    Starting mailman services: Starting Mailman's master qrunner.
    
    root@mail [~]# /etc/init.d/chkservd restart
    Stopping chkservd:                                         [  OK  ]
    Starting chkservd:                                         [  OK  ]
    
    
    List... :cool:
     
    #11 inda, Dec 28, 2004
    Last edited: Dec 31, 2004
  12. NNNils

    NNNils Well-Known Member

    Joined:
    Sep 17, 2002
    Messages:
    580
    Likes Received:
    0
    Trophy Points:
    16
    I get this when restarting cpanel:

    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.


    Any idea?
     
  13. grayentropy

    grayentropy Member

    Joined:
    Oct 19, 2003
    Messages:
    8
    Likes Received:
    0
    Trophy Points:
    1
    I just fixed my site

    Did you wait a good 15 minutes to see if the red light goes away or see a MySQL database for exim stats? This works. Thanks to all
     
  14. cz1179

    cz1179 BANNED

    Joined:
    Dec 27, 2004
    Messages:
    105
    Likes Received:
    0
    Trophy Points:
    0
    I'm having the same problem. Eximstats and IMAP show in red in stats

    I ran the above scripts and even reinstalled exim.

    What could be the solution?
     
  15. arbuzas

    arbuzas Member

    Joined:
    Apr 10, 2004
    Messages:
    23
    Likes Received:
    0
    Trophy Points:
    1
    Same thing here I tray this link: http://forums.cpanel.net/showpost.php?p=140446&postcount=22
    But it don't fix. Any one know how to fix? :confused:
     
  16. philb

    philb Well-Known Member

    Joined:
    Jan 28, 2004
    Messages:
    116
    Likes Received:
    0
    Trophy Points:
    16
    If you launch mysql, and then type

    show databases;

    is there an eximstats database in there at all? I've noticed that cpanel spectactularly fails to create the eximstats database or user at all when it's initially installed, it would seem.
     
  17. arbuzas

    arbuzas Member

    Joined:
    Apr 10, 2004
    Messages:
    23
    Likes Received:
    0
    Trophy Points:
    1
    Yes, there are eximstats DB with 2 tables: sends, stmp.
     
  18. philb

    philb Well-Known Member

    Joined:
    Jan 28, 2004
    Messages:
    116
    Likes Received:
    0
    Trophy Points:
    16
    Start up mysql and do the following:

    use mysql;

    select user from user where user = "eximstats";

    Does it output a line for the eximstats user?
     
    #18 philb, Jan 8, 2005
    Last edited: Jan 8, 2005
  19. arbuzas

    arbuzas Member

    Joined:
    Apr 10, 2004
    Messages:
    23
    Likes Received:
    0
    Trophy Points:
    1
    mysql> use mysql
    Database changed
    mysql> select user from user where user = "eximstats";
    +-----------+
    | user |
    +-----------+
    | eximstats |
    +-----------+
    1 row in set (0.01 sec)
     
  20. philb

    philb Well-Known Member

    Joined:
    Jan 28, 2004
    Messages:
    116
    Likes Received:
    0
    Trophy Points:
    16
    ok.

    Take the value from:

    cat /var/cpanel/eximstatspass && echo ""

    and put it into the following mysql sequence:

    use mysql;

    update mysql.user set password=password("<the output>") where user="eximstats";

    so eg; if cat /var/cpanel/eximstatspass gave you:

    foobar

    you'd have an update line of:

    update mysql.user set password=password("foobar") where user="eximstats";

    Then try doing /etc/init.d/cpanel restart and see what it outputs for eximstats.
     
    #20 philb, Jan 8, 2005
    Last edited: Jan 8, 2005
Loading...

Share This Page