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.

Webalizer stats not updating for 1 domain - corrupt mysql?

Discussion in 'General Discussion' started by froglen, Sep 12, 2007.

  1. froglen

    froglen Member

    Joined:
    Aug 30, 2006
    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    1
    Can anyone help with this problem?

    One particular domain is not getting its webalizer stats updated. The problem has been evident since a server migration 2 months ago. The domlog for the customer site shows hits with today's date so that side of it is okay.

    The output suggests that some mysql database tables are bad but I can't work out the database name in order to try and repair it.



    # /scripts/fixwebalizer pn102461
    removed `/customers/pn102461/tmp/webalizer/webalizer.current'
    removed `/customers/pn102461/tmp/webalizer/webalizer.hist'
    removed `/customers/pn102461/tmp/webalizer/dns_cache.db'
    Log checker loaded ok..
    ==> cPanel Log Daemon version 22.2
    ==> Shared RRDTOOL support enabled
    ==> Starting cpbandwd (bandwidth monitoring for IMAP/POP)
    cpbandwd is already running.
    Processing pn102461...
    Run Logs domain: puntarivieraresort.com BW Limit: 5242880000 Domains: []
    Processing exim stats for pn102461....(internal warning while parsing ) Wed Sep 12 07:49:40 2007 [27473] warn: DBD::mysql::db do failed: Table 'sends' is marked as crashed and should be repaired at /usr/local/cpanel/cpanellogd line 1088.
    at /usr/local/cpanel/cpanellogd line 1088
    eval {...} called at /usr/local/cpanel/cpanellogd line 1085
    main::geteximstats('pn102461') called at /usr/local/cpanel/cpanellogd line 1631
    main::parseeximlog('pn102461', 1073741824) called at /usr/local/cpanel/cpanellogd line 586
    main::updatebw('pn102461', '/customers/pn102461', 32474, 'DOMAINNAME.com', 5242880000, 'ARRAY(0x9f78a24)') called at /usr/local/cpanel/cpanellogd line 205


    (internal warning while parsing ) Wed Sep 12 07:49:40 2007 [27473] warn: DBD::mysql::db do failed: Table 'smtp' is marked as crashed and should be repaired at /usr/local/cpanel/cpanellogd line 1089.
    at /usr/local/cpanel/cpanellogd line 1089
    eval {...} called at /usr/local/cpanel/cpanellogd line 1085
    main::geteximstats('pn102461') called at /usr/local/cpanel/cpanellogd line 1631
    main::parseeximlog('pn102461', 1073741824) called at /usr/local/cpanel/cpanellogd line 586
    main::updatebw('pn102461', '/customers/pn102461', 32474, 'DOMAINNAME.com', 5242880000, 'ARRAY(0x9f78a24)') called at /usr/local/cpanel/cpanellogd line 205


    (internal warning while parsing ) Wed Sep 12 07:49:40 2007 [27473] warn: DBD::mysql::st execute failed: Table 'smtp' is marked as crashed and should be repaired at /usr/local/cpanel/cpanellogd line 1096.
    at /usr/local/cpanel/cpanellogd line 1096
    eval {...} called at /usr/local/cpanel/cpanellogd line 1085
    main::geteximstats('pn102461') called at /usr/local/cpanel/cpanellogd line 1631
    main::parseeximlog('pn102461', 1073741824) called at /usr/local/cpanel/cpanellogd line 586
    main::updatebw('pn102461', '/customers/pn102461', 32474, 'DOMAINNAME.com', 5242880000, 'ARRAY(0x9f78a24)') called at /usr/local/cpanel/cpanellogd line 205


    (internal warning while parsing ) Wed Sep 12 07:49:40 2007 [27473] warn: DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /usr/local/cpanel/cpanellogd line 1097.
    at /usr/local/cpanel/cpanellogd line 1097
    eval {...} called at /usr/local/cpanel/cpanellogd line 1085
    main::geteximstats('pn102461') called at /usr/local/cpanel/cpanellogd line 1631
    main::parseeximlog('pn102461', 1073741824) called at /usr/local/cpanel/cpanellogd line 586
    main::updatebw('pn102461', '/customers/pn102461', 32474, 'DOMAINNAME.com', 5242880000, 'ARRAY(0x9f78a24)') called at /usr/local/cpanel/cpanellogd line 205


    (internal warning while parsing ) Wed Sep 12 07:49:40 2007 [27473] warn: DBD::mysql::db do failed: Table 'smtp' is marked as crashed and should be repaired at /usr/local/cpanel/cpanellogd line 1100.
    at /usr/local/cpanel/cpanellogd line 1100
    eval {...} called at /usr/local/cpanel/cpanellogd line 1085
    main::geteximstats('pn102461') called at /usr/local/cpanel/cpanellogd line 1631
    main::parseeximlog('pn102461', 1073741824) called at /usr/local/cpanel/cpanellogd line 586
    main::updatebw('pn102461', '/customers/pn102461', 32474, 'DOMAINNAME.com', 5242880000, 'ARRAY(0x9f78a24)') called at /usr/local/cpanel/cpanellogd line 205


    (internal warning while parsing ) Wed Sep 12 07:49:40 2007 [27473] warn: DBD::mysql::db do failed: Table 'smtp' is marked as crashed and should be repaired at /usr/local/cpanel/cpanellogd line 1101.
    at /usr/local/cpanel/cpanellogd line 1101
    eval {...} called at /usr/local/cpanel/cpanellogd line 1085
    main::geteximstats('pn102461') called at /usr/local/cpanel/cpanellogd line 1631
    main::parseeximlog('pn102461', 1073741824) called at /usr/local/cpanel/cpanellogd line 586
    main::updatebw('pn102461', '/customers/pn102461', 32474, 'DOMAINNAME.com', 5242880000, 'ARRAY(0x9f78a24)') called at /usr/local/cpanel/cpanellogd line 205


    (internal warning while parsing ) Wed Sep 12 07:49:40 2007 [27473] warn: DBD::mysql::db do failed: Table 'sends' is marked as crashed and should be repaired at /usr/local/cpanel/cpanellogd line 1103.
    at /usr/local/cpanel/cpanellogd line 1103
    eval {...} called at /usr/local/cpanel/cpanellogd line 1085
    main::geteximstats('pn102461') called at /usr/local/cpanel/cpanellogd line 1631
    main::parseeximlog('pn102461', 1073741824) called at /usr/local/cpanel/cpanellogd line 586
    main::updatebw('pn102461', '/customers/pn102461', 32474, 'DOMAINNAME.com', 5242880000, 'ARRAY(0x9f78a24)') called at /usr/local/cpanel/cpanellogd line 205


    [an error occurred while processing this directive][an error occurred while processing this directive][an error occurred while processing this directive][an error occurred while processing this directive][an error occurred while processing this directive][an error occurred while processing this directive][an error occurred while processing this directive]...Done
    WEBLANG english
    Archive Status: 0
    About to fork for pn102461 [ALL DOMAINS: ,DOMAINNAME.com]
    Complete
     
  2. bubby

    bubby Member

    Joined:
    Mar 26, 2007
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    repair the table in exim stats

    mysql eximstats
    Reading table information for completion of table and column names
    You can turn off this feature to get a quicker startup with -A

    Welcome to the MySQL monitor. Commands end with ; or \g.
    Your MySQL connection id is 1972373 to server version: 4.1.22-standard

    Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

    mysql> show tables;
    +---------------------+
    | Tables_in_eximstats |
    +---------------------+
    | sends |
    | smtp |
    +---------------------+
    2 rows in set (0.00 sec)

    mysql> repair table sends;
    +-----------------+--------+----------+----------+
    | Table | Op | Msg_type | Msg_text |
    +-----------------+--------+----------+----------+
    | eximstats.sends | repair | status | OK |
    +-----------------+--------+----------+----------+
    1 row in set (0.01 sec)

    mysql> repair tables smtp;
    +----------------+--------+----------+----------+
    | Table | Op | Msg_type | Msg_text |
    +----------------+--------+----------+----------+
    | eximstats.smtp | repair | status | OK |
    +----------------+--------+----------+----------+
    1 row in set (0.05 sec)
     
Loading...

Share This Page