View Single Post
  #14 (permalink)  
Old 11-16-2009, 11:43 PM
HidX HidX is offline
Senior Member
 
Posts: 53
Default

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

Code:
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:
Quote:
[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:

Code:
zmcontrol status
Host mail.domen.ru
        antispam                Running
        antivirus               Running
        ldap                    Running
        logger                  Running
        mailbox                 Running
        mta                     Running
        snmp                    Running
        spell                   Running
        stats                   Running
Quote:
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
Quote:
zimbra@mail:/home/maks$ zmloggerctl status
Nothing showed
Code:
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
Code:
zimbra@mail:/home/maks$ /opt/zimbra/libexec/zmrrdfetch -f zmmtastats
no structure found for zmmtastats at /opt/zimbra/libexec/zmrrdfetch line 225.
Code:
zimbra@mail:/home/maks$ /opt/zimbra/libexec/zmrrdfetch -c -f zmmtastats
no structure found for zmmtastats at /opt/zimbra/libexec/zmrrdfetch line 225.
Code:
zimbra@mail:/home/maks$ grep -w MTA /var/log/zimbra-stats.log
Nothing showed - At the time of 10:00 am
Code:
zimbra@mail:/home/maks$ zmsoap -z GetLoggerStatsRequest stats/@name=zmmtastats | head -20
Quote:
44K /opt/zimbra/logger
Help please. What can I do in this situation?

Last edited by HidX; 11-17-2009 at 12:58 AM..
Reply With Quote