upgrade to 6.0.2 stats and status no longer working

[imx]

This fixed it for me...thanks

[imx]

Well...maybe a little hasty, will see...certainly fixes it for message count graph for 48 hours - still have no av, message volume graphs for 48 hours

loading data for chart...

[pfnguyen]

please follow the troubleshooting steps here:

Logger - Zimbra :: Wiki

Also, 'loading data for chart...' indicates a javascript error, can you also paste any exception you might have in the firefox error console (or firebug, if you have that).

[HidX]

There was a problem with daily disconnection statistics (after upgrade 6.0.1 to 6.0.2). Read this topic, I did the following:

rm -r /opt/zimbra/logger/db/data/*
./zmfixperms --verbose --extended
/opt/zimbra/bin/zmsyslogsetup

Then I tried to execute command: /opt/zimbra/libexec/zmlogger&

The answer was:

[1] 1022
mail:/opt/zimbra/libexec# zmrrdfetch server pid: 1053
DBD::SQLite::db selectrow_array failed: no such table: config at /opt/zimbra/libexec/zmlogger line 404.
Schema version not found, upgrading to version 4 at /opt/zimbra/libexec/zmlogger line 407.

[1]+ Stopped /opt/zimbra/libexec/zmlogger

As a result, statistics in general ceased to work ... All sections shown "no data available". In the "drive" there's nothing at all, even the message "no data available". Works only sections of user sessions and quotas.

Here's my diagnostic data:

zmcontrol status
Host mail.domen.ru
        antispam                Running
        antivirus               Running
        ldap                    Running
        logger                  Running
        mailbox                 Running
        mta                     Running
        snmp                    Running
        spell                   Running
        stats                   Running

zmstatctl status
Running: zmstat-vm
Running: zmstat-allprocs
Running: zmstat-fd
Running: zmstat-mtaqueue
Running: zmstat-mysql
Running: zmstat-cpu
Running: zmstat-df
Running: zmstat-io-x
Running: zmstat-io
Running: zmstat-proc

zimbra@mail:/home/maks$ zmloggerctl status
Nothing showed

zimbra@mail:/home/maks$ ps ax | grep zmlogger
 3823 ?        Z      0:00 [zmlogger] 
 3915 ?        S      0:00 zmlogger: zmrrdfetch: server
 9608 pts/0    S+     0:00 grep zmlogger

zimbra@mail:/home/maks$ /opt/zimbra/libexec/zmrrdfetch -f zmmtastats
no structure found for zmmtastats at /opt/zimbra/libexec/zmrrdfetch line 225.

zimbra@mail:/home/maks$ /opt/zimbra/libexec/zmrrdfetch -c -f zmmtastats
no structure found for zmmtastats at /opt/zimbra/libexec/zmrrdfetch line 225.

zimbra@mail:/home/maks$ grep -w MTA /var/log/zimbra-stats.log
Nothing showed - At the time of 10:00 am

zimbra@mail:/home/maks$ zmsoap -z GetLoggerStatsRequest stats/@name=zmmtastats | head -20

44K /opt/zimbra/logger

Help please. What can I do in this situation?

[yannjeg]

Hi,

I've notice that default Debian GNU/Linux 5 install use syslog.

When I start /opt/zimbra/bin/zmsyslogsetup, it generates a file in /etc called rsyslogd.conf.

So, I've done an 'aptitude install rsyslogd' and evrything ( status and stats ) seems to works...

[HidX]

Originally Posted by yannjeg

Hi,

I've notice that default Debian GNU/Linux 5 install use syslog.

When I start /opt/zimbra/bin/zmsyslogsetup, it generates a file in /etc called rsyslogd.conf.

So, I've done an 'aptitude install rsyslogd' and evrything ( status and stats ) seems to works...

Package "rsyslogd" not suschetvuet
Maybe you meant: "rsyslog" or "sysklogd"?

[yannjeg]

right, the package name is rsyslog, rsyslogd is the binary.

Sorry...

[HidX]

Originally Posted by yannjeg

right, the package name is rsyslog, rsyslogd is the binary.

Sorry...

You had a similar problem with statistics?

[Richelieu]

I did the operation of installing rsyslog and there is an improvement. It nows show graphs, but empty ones so far.

[yannjeg]

Originally Posted by Richelieu

I did the operation of installing rsyslog and there is an improvement. It nows show graphs, but empty ones so far.

You should wait a little before having graphs.

When I first install ZCS 6.0.2 in an fresh Debian Lenny, everything on Server Status was red and have an error on Server Statistics...