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 jdwilliams, Jan 26, 2004.

  1. jdwilliams

    jdwilliams Registered

    Joined:
    Jan 24, 2004
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    Hi,

    I keep getting emails that eximstats failed. On the service status page it is red.

    If i go to "View Relayers" under Email i get this.

    DBI connect('eximstats:localhost','eximstats',...) failed: Access denied for user: 'eximstats@localhost' (Using password: YES) at ./cgi/eximtop.cgi line 76 Can't Connect at ./cgi/eximtop.cgi line 79.


    Any ideas on how I can fix this?
     
  2. bigj

    bigj Well-Known Member

    Joined:
    Aug 9, 2003
    Messages:
    75
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    Tucson,AZ
    I have the same problem. This is on a fresh install too.

    bigj
     
  3. casey

    casey Well-Known Member

    Joined:
    Jan 17, 2003
    Messages:
    2,303
    Likes Received:
    0
    Trophy Points:
    36
    Location:
    If there is trouble, it will find me
    Check and see if you have a mysql user and database named eximstats. If not, you will have to create one manually.
     
  4. bigj

    bigj Well-Known Member

    Joined:
    Aug 9, 2003
    Messages:
    75
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    Tucson,AZ
    Sorry for the lack of info in the first post. I knew I didn't have the mysql data but I am unsure of what tables, if any, to create. Also, how does it know what username/password to use to access it? Does it just use the root account?

    bigj
     
  5. jdwilliams

    jdwilliams Registered

    Joined:
    Jan 24, 2004
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    How do i create a MYSQL database?
     
  6. casey

    casey Well-Known Member

    Joined:
    Jan 17, 2003
    Messages:
    2,303
    Likes Received:
    0
    Trophy Points:
    36
    Location:
    If there is trouble, it will find me
    Do you have more than one server? (I do not have ssh access to mine right now). On one with a working eximstats, do the following.

    # locate eximstats.sql
    Open that file and copy the commands into phpMyAdmin while logged in as root. That'll get you going.
     
  7. jdwilliams

    jdwilliams Registered

    Joined:
    Jan 24, 2004
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    I only have 1 server
     
  8. bigj

    bigj Well-Known Member

    Joined:
    Aug 9, 2003
    Messages:
    75
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    Tucson,AZ
    My .sql file is emtpy. Can you post yours? Thanks.

    bigj
     
  9. casey

    casey Well-Known Member

    Joined:
    Jan 17, 2003
    Messages:
    2,303
    Likes Received:
    0
    Trophy Points:
    36
    Location:
    If there is trouble, it will find me
    Give me 8 hours and I'll post mine when I get home. If anyone else would like to post theirs, feel free to do so in the meantime. :)
     
  10. anand

    anand Well-Known Member

    Joined:
    Nov 11, 2002
    Messages:
    1,435
    Likes Received:
    1
    Trophy Points:
    38
    Location:
    India
    cPanel Access Level:
    DataCenter Provider
    Just came across this thread :)

    I found 2 sql files.

    /usr/local/cpanel/etc/eximstats.sql.in
    /usr/local/cpanel/etc/eximstats.sql

    I believe the second one is what you are after.

    Here is the file for you.

    PHP:

    CONNECT mysql
    ;
                                                                                           
    REPLACE INTO user (hostuserpassword)
        
    VALUES (
            
    'localhost',
            
    'eximstats',
      -- 
    IMPORTANTChange this password!
            
    password('XXXXXX')
        );
                                                                                              
    REPLACE INTO db (hostdbuserselect_privinsert_privupdate_priv,
                     
    delete_privcreate_privdrop_priv)
        
    VALUES (
            
    'localhost',
            
    'eximstats',
            
    'eximstats',
            
    'Y''Y''Y''Y',
            
    'Y''Y'
        
    );

    FLUSH PRIVILEGES;

    CREATE DATABASE eximstats;
                                                                                              
    CONNECT eximstats;
                                                                                              
    CREATE TABLE sends (
      
    mailtime datetime NOT NULL default '0000-00-00 00:00:00',
      
    msgid char(15NOT NULL default '',
      
    email char(100NOT 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)
    TYPE=MyISAM;

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


    GRANT ALL ON eximstats.* TO eximstats@localhost;
                                                                                              
    CREATE INDEX msgid_index on sends (msgid);  

    Hope this helps.
     
  11. anand

    anand Well-Known Member

    Joined:
    Nov 11, 2002
    Messages:
    1,435
    Likes Received:
    1
    Trophy Points:
    38
    Location:
    India
    cPanel Access Level:
    DataCenter Provider
    heheh i wonder how the "replace" text on the top got so much indent, anyways i hope things work out for you guys :D
     
  12. casey

    casey Well-Known Member

    Joined:
    Jan 17, 2003
    Messages:
    2,303
    Likes Received:
    0
    Trophy Points:
    36
    Location:
    If there is trouble, it will find me
    Thanks, anand. That's the same as mine. :)
     
  13. anand

    anand Well-Known Member

    Joined:
    Nov 11, 2002
    Messages:
    1,435
    Likes Received:
    1
    Trophy Points:
    38
    Location:
    India
    cPanel Access Level:
    DataCenter Provider
    forgot to add, just change the password mentioned in the quote to something RANDOM.

    PHP:
    password('XXXXXX')
     
  14. anand

    anand Well-Known Member

    Joined:
    Nov 11, 2002
    Messages:
    1,435
    Likes Received:
    1
    Trophy Points:
    38
    Location:
    India
    cPanel Access Level:
    DataCenter Provider
    :D
     
  15. PixyMisa

    PixyMisa Registered

    Joined:
    Aug 24, 2003
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    Thanks guys! I had the same problem, and this fixed it.

    It took a bit of fiddling around - I needed to put my new random password in /var/cpanel/eximstatspass - but I got there.

    I think they just missed a step when they were reinstalling CPanel after my server blew up. :( Everything but eximstats was working.
     
  16. bigj

    bigj Well-Known Member

    Joined:
    Aug 9, 2003
    Messages:
    75
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    Tucson,AZ
    This fixed me too. Thanks for posting the sql file.

    bigj
     
  17. anand

    anand Well-Known Member

    Joined:
    Nov 11, 2002
    Messages:
    1,435
    Likes Received:
    1
    Trophy Points:
    38
    Location:
    India
    cPanel Access Level:
    DataCenter Provider
    anytime :D
     
  18. rqsweat

    rqsweat Active Member

    Joined:
    Mar 25, 2003
    Messages:
    42
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    New Jersey
    I replaced my file with the one listed in this post and I'm still having the same problem. Yes my password in /usr/local/cpanel/etc/eximstats.sql
    matches the one in /var/cpanel/eximstatspass. Yes I rebooted.

    Any other suggestions?
     
  19. erwinfa

    erwinfa Well-Known Member

    Joined:
    Jun 14, 2003
    Messages:
    108
    Likes Received:
    0
    Trophy Points:
    0
    I have upgraded into latest release cpanel 8.7.0-RELEASE_80
    , solve my problem
     
  20. casey

    casey Well-Known Member

    Joined:
    Jan 17, 2003
    Messages:
    2,303
    Likes Received:
    0
    Trophy Points:
    36
    Location:
    If there is trouble, it will find me
    This is probably a silly question, but you did use the code to create the databases, right? I.e., you didn't just replace the file did you?
    Rebooting is unnecessary.
     
Loading...

Share This Page