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!

runwbelogs: Error on exim stats

Discussion in 'General Discussion' started by speckados, Oct 20, 2004.

  1. speckados

    speckados Well-Known Member

    Joined:
    May 21, 2003
    Messages:
    320
    Likes Received:
    1
    Trophy Points:
    168
    Location:
    Pastrana :: Guadalajara :: España
    cPanel Access Level:
    DataCenter Provider
    Twitter:
    Code:
    Processing exim stats for hosting....DBD::mysql::db do failed: Access denied for user: 'eximstats@localhost' to database 'eximstats' at /usr/local/cpanel/cpanellogd line 1720.
    That apears after run /scripts/runweblogs and after last Cpanel update-->
    WHM 9.9.3 cPanel 9.9.3-R17
    Fedora i686 - WHM X v3.1.0

    I looking for same problem but very old and not solution this problem.

    Any ideas?
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  2. nickn

    nickn Well-Known Member
    PartnerNOC

    Joined:
    Jun 15, 2003
    Messages:
    619
    Likes Received:
    1
    Trophy Points:
    168
    First try this.

    do "cat /var/cpanel/eximstatspass"

    That'll tell you the eximstats database password.

    Now mysql -u eximstats -p eximstats

    Use the password.

    If it doesn't work, which it shouldn't...Either reset the password, or recreate the database...

    Here's the database structure:

    Code:
    # phpMyAdmin SQL Dump
    # version 2.5.6-rc1
    # http://www.phpmyadmin.net
    #
    # Host: localhost
    # Generation Time: Apr 06, 2004 at 11:24 PM
    # Server version: 4.0.17
    # PHP Version: 4.2.3
    # 
    # Database : `eximstats`
    # 
    DROP DATABASE `eximstats`;
    CREATE DATABASE `eximstats`;
    USE eximstats;
    
    # --------------------------------------------------------
    
    #
    # Table structure for table `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;
    
    # --------------------------------------------------------
    
    #
    # Table structure for table `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;
    
     
  3. speckados

    speckados Well-Known Member

    Joined:
    May 21, 2003
    Messages:
    320
    Likes Received:
    1
    Trophy Points:
    168
    Location:
    Pastrana :: Guadalajara :: España
    cPanel Access Level:
    DataCenter Provider
    Twitter:
    Don't work.

    eximstats DB not problem (Check & repair)

    User and passwords for eximstats work properly with mysql -u

    Structure table it's identical.

    No solution teh problem.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice