Results 1 to 6 of 6

Thread: Server Statistics only show all 30 days

  1. #1
    Join Date
    Jan 2008
    Location
    Switzerland
    Posts
    46
    Rep Power
    7

    Default Server Statistics only show all 30 days

    Hello,

    I installed the server succesfully everything works fine and smooth but there is one little problem. My statistic graphs only show all 30 days. The rest doesn't show anything.... why is that ? The server is actively being used so it's not because there is nobody using it maybe someone has had this problem too and found a solution. Since the server is productive I rather not risk anything that might damage the system. Thx in advance!

    Edit:
    The statistics do not show all 30 days, it just had information from the last month looked at this totally wrong, it isn't updating at all.

    sincerely,

    Silvio
    Last edited by silbro; 02-20-2008 at 07:55 AM.

  2. #2
    Join Date
    May 2006
    Location
    USA
    Posts
    6,242
    Rep Power
    21

    Default

    Have they ever shown up or did they show up and disappear?
    See if anything in Logger - Zimbra :: Wiki stands out at you.
    You might also manually run /opt/zimbra/libexec/zmgengraphs

  3. #3
    Join Date
    Jan 2008
    Location
    Switzerland
    Posts
    46
    Rep Power
    7

    Default

    Yes they have shown and then just disappeared. But I think I had a reboot in between. I will go check out the page and also see if the services are running. Will report back, thx in advance.

  4. #4
    Join Date
    Jan 2008
    Location
    Switzerland
    Posts
    46
    Rep Power
    7

    Default

    Code:
    +------------------------+--------+----------+----------------------------------+
    | Table                  | Op     | Msg_type | Msg_text                         |
    +------------------------+--------+----------+----------------------------------+
    | zimbra_logger.raw_logs | repair | error    | Incorrect file format 'raw_logs' |
    +------------------------+--------+----------+----------------------------------+
    1 row in set, 1 warning (0.00 sec)
    seems like there is something wrong, repair table raw_logs; didnt change anything.

    this is what I found in /opt/zimbra/logger/db/data/vineyard-01.err
    Code:
    root@vineyard-01:~# less /opt/zimbra/log
    log/    logger/
    root@vineyard-01:~# less /opt/zimbra/logger/db/data/vineyard-01.err
    080130 09:34:11  mysqld started
    InnoDB: The first specified data file ./ibdata1 did not exist:
    InnoDB: a new database to be created!
    080130  9:34:11  InnoDB: Setting file ./ibdata1 size to 10 MB
    InnoDB: Database physically writes the file full: wait...
    080130  9:34:11  InnoDB: Log file ./ib_logfile0 did not exist: new to be created
    InnoDB: Setting log file ./ib_logfile0 size to 5 MB
    InnoDB: Database physically writes the file full: wait...
    080130  9:34:11  InnoDB: Log file ./ib_logfile1 did not exist: new to be created
    InnoDB: Setting log file ./ib_logfile1 size to 5 MB
    InnoDB: Database physically writes the file full: wait...
    InnoDB: Doublewrite buffer not found: creating new
    InnoDB: Doublewrite buffer created
    InnoDB: Creating foreign key constraint system tables
    InnoDB: Foreign key constraint system tables created
    080130  9:34:12  InnoDB: Started; log sequence number 0 0
    080130  9:34:12 [Note] /opt/zimbra/logger/mysql/libexec/mysqld: ready for connec
    tions.
    Version: '5.0.45-log'  socket: '/opt/zimbra/logger/db/mysql.sock'  port: 7307  S
    ource distribution
    A mysqld process already exists at  Wed Jan 30 09:35:31 CET 2008
    080201 21:25:16  mysqld started
    080201 21:25:16  InnoDB: Database was not shut down normally!
    /opt/zimbra/logger/db/data/vineyard-01.err
    the file
    Code:
    /opt/zimbra/logger/db/mysql.pid
    exists. The processes

    Code:
    9445 ?        S      0:00 /usr/bin/perl /opt/zimbra/libexec/zmlogger
    3822 ?        S      0:00 /bin/sh /opt/zimbra/logger/mysql/bin/mysqld_safe --de
    3936 ?        Sl     2:55 /opt/zimbra/logger/mysql/libexec/mysqld --defaults-fi
    are running.

    This is the output of ps aux | grep logswatch

    Code:
    admin@vineyard-01:/opt/zimbra/logger/db$ ps aux | grep logswatch
    zimbra    9066  0.0  0.2   5564  3904 ?        S    06:25   0:00 /usr/bin/perl /opt/zimbra/libexec/logswatch --config-file=/opt/zimbra/conf/logswatchrc --use-cpan-file-tail --script-dir=/tmp -t /var/log/zimbra.log
    admin    16985  0.0  0.0   2912   792 pts/0    R+   09:32   0:00 grep logswatch
    output of logmysqladmin status

    Code:
    zimbra@vineyard-01:~/logger/db$ logmysqladmin status
    Uptime: 584988  Threads: 2  Questions: 241651  Slow queries: 5894  Opens: 21  Flush tables: 1  Open tables: 15  Queries per second avg: 0.413
    grep logswatch

    Code:
    zimbra@vineyard-01:~/logger/db$ ps aux | grep logswatch
    zimbra    9066  0.0  0.2   5564  3904 ?        S    06:25   0:00 /usr/bin/perl /opt/zimbra/libexec/logswatch --config-file=/opt/zimbra/conf/logswatchrc --use-cpan-file-tail --script-dir=/tmp -t /var/log/zimbra.log
    zimbra   18268  0.0  0.0   2920   824 pts/0    S+   09:38   0:00 grep logswatch
    Last edited by silbro; 02-21-2008 at 01:28 AM.

  5. #5
    Join Date
    Jun 2008
    Location
    St. Gallen, Switzerland
    Posts
    25
    Rep Power
    7

    Default

    I have exactly the same problem...

    Anyone out there with an idea to solve this problem?

  6. #6
    Join Date
    Jun 2008
    Location
    St. Gallen, Switzerland
    Posts
    25
    Rep Power
    7

    Default

    Actually, I have no mails in graphics at all.

    Could there be a connection problem to the mysql-Server because of the root PWD? What PWD is there set? Should I set one? Or change it?

    I did an Update of my Debian Etch, perhaps this is the "cause" of the problem? Even though I did the same on a different machine, without the graphs-problem...

    I went through all the checks described in the wiki, but without finding any errors. But the graphs do still not show the mails (which are listed in mysql!)


Similar Threads

  1. Zimbra fails after working for 2 weeks
    By Linsys in forum Administrators
    Replies: 10
    Last Post: 10-07-2008, 12:42 AM
  2. need advice on configuring zimbra to work with fax server
    By pheonix1t in forum Administrators
    Replies: 0
    Last Post: 07-11-2007, 07:46 PM
  3. Error 256 on Installation
    By RuinExplorer in forum Installation
    Replies: 5
    Last Post: 10-19-2006, 09:19 AM
  4. Getting problems in FC4 while instalation
    By kitty_bhoo in forum Installation
    Replies: 13
    Last Post: 09-12-2006, 10:34 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •