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.

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:
    291
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Acequias :: Granada :: 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?
     
  2. nickn

    nickn Well-Known Member
    PartnerNOC

    Joined:
    Jun 15, 2003
    Messages:
    619
    Likes Received:
    1
    Trophy Points:
    18
    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:
    291
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Acequias :: Granada :: 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.
     
Loading...

Share This Page