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.