Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

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:
    151
    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:
    156
    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:
    191
    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:
    156
    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:
    151
    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:
    191
    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:
    151
    I only have 1 server
     
  8. bigj

    bigj Well-Known Member

    Joined:
    Aug 9, 2003
    Messages:
    75
    Likes Received:
    0
    Trophy Points:
    156
    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:
    191
    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:
    168
    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:
    168
    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:
    191
    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:
    168
    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:
    168
    Location:
    India
    cPanel Access Level:
    DataCenter Provider
    :D
     
  15. PixyMisa

    PixyMisa Registered

    Joined:
    Aug 24, 2003
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    151
    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:
    156
    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:
    168
    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:
    156
    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:
    166
    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:
    191
    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