zmstat is stopped!

[celeron]

Dear community,
I have a fresh install of zimbra FOSS 6.0.6 on rhel5 and have the problem with zmstat service. I tried to search on zimbra forum but the problem is not resolved. When I run zmstatctl status, I have "
process 5538 in /opt/zimbra/zmstat/pid/zmstat-mysql.pid not running".
This is the error log in zmstat.out
apache-convertd not running, not launching zmstat-convertd
/opt/zimbra/bin/mysql: line 20: /opt/zimbra/mysql/bin/mysql: No such file or directory
/opt/zimbra/bin/mysql: line 20: exec: /opt/zimbra/mysql/bin/mysql: cannot execute: No such file or directory
Error while running '/opt/zimbra/bin/mysql --user=zimbra --password=JdphmTAQccak --database=zimbra --batch --skip-column-names'. at /opt/zimbra/zimbramon/lib/Zimbra/DB/DB.pm line 73.
Warning: Not possible to monitor process stats

Please help me to resolve the problem.

Many thanks,

[uxbod]

ls -l /opt/zimbra/mysql/bin/mysql
ls -ld /opt/zimbra/mysql*

[celeron]

My mailbox server is working properly. Only zmstat service is stopped. I can see the output of these commnad. Are there any other ways for more checking?

Many thanks uxbod

[uxbod]

Would you please post the output of those commands.

[mackoftrack]

I am having the same problem.
Here is the output of those commands:

[root@zimbra log]# ls -l /opt/zimbra/mysql/bin/mysql
-rwxr-xr-x 1 root root 311221 Apr  6 14:05 /opt/zimbra/mysql/bin/mysql

[root@zimbra log]#  ls -ld /opt/zimbra/mysql*
lrwxrwxrwx 1 root root   59 Apr 10 21:47 /opt/zimbra/mysql -> /opt/zimbra/mysql-standard-5.0.90-pc-linux-gnu-i686-glibc23
drwxrwxr-x 7 root root 4096 Apr 10 21:48 /opt/zimbra/mysql-standard-5.0.90-pc-linux-gnu-i686-glibc23

[mackoftrack]

Nevermind, I figured out my problem. It was a permission issue: /opt/zimbra/zmstat/{today's date} was owned by root for some reason. After chown'ing to user zimbra, stats stayed running

[celeron]

I have right permissions in /opt/zimbra/zmstat/ but I can't start zmstat service. It always stops.

[adis]

We've had the same issue this morning.

OS platform is CentOS
Zimbra was updated a few days ago (6.0.6 - 6.0.6.1), and yesterday, CentOS was updated from 5.4 to 5.5.

zmstats stopped working around midnight, and we observed the following in zmstat.out:

/opt/zimbra/zmstat/vm.csv was stale (2010-05-17) pre-rotating
sh: /opt/zimbra/zmstat//2010-05-17/vm.csv.gz: Permission denied

The issue was resloved by changing permissions for 2010-05-17 directory and restarting zmstat daemon.

[ewilen]

Problem may reappear, see Bug 45010 – Stats service failing due to folder permissions getting set wrong for a patch.