[SOLVED] Stats/Status Problems Ubuntu 6 / 5.0_RC2

[adamtheray]

I have a production machine running Ubuntu 6.06 server (i386) and originally installed RC1 on it. Even after an upgrade to RC2 the stats continue to malfunction.

zmcontrol status

shows everything as working but no stats show up in the admin panel.

Additionally, since the upgrade to RC2 the status comes up with the Server Error Encountered
Details:Message: system failure: getting service status Error code: service.FAILURE Method: ZmCsfeCommand.prototype.invoke Details:soap:Receiver

Any ideas?

Thanks,
Adam

[jholder]

Can you post your /opt/zimbra/logger/db/(hostname).err?

[adamtheray]

OK that should have been:

/opt/zimbra/logger/db/data/[hostname].err

I have a repeating error:

/opt/zimbra/logger/mysql/libexec/mysqld: Table './zimbra_logger/service_status' is marked as crashed and should be repaired

[jholder]

Sorry, it's in the data dir.

[adamtheray]

Yup,

I have a repeating error:

/opt/zimbra/logger/mysql/libexec/mysqld: Table './zimbra_logger/service_status' is marked as crashed and should be repaired

[jholder]

Try this:
su - zimbra
logmysql
mysql> use zimbra_logger;
mysql> repair table service_status;

[adamtheray]

OK, the status part is now fixed.

I will continue to monitor to see if the stats are working.

Thanks,
Adam

[adamtheray]

Everything is working like a charm.

Thanks for the help.

Adam

[mmorse]

marking as solved