Server Statistics only show all 30 days

[silbro]

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

[mmorse]

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

[silbro]

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.

[silbro]

+------------------------+--------+----------+----------------------------------+
| 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

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

/opt/zimbra/logger/db/mysql.pid

exists. The processes

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

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

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

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

[pasco]

I have exactly the same problem...

Anyone out there with an idea to solve this problem?

[pasco]

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!)