Multi-Server OSX Logger - Data Not Yet Available

[Britt]

I've got a working installation of Zimbra OSS Version 3.1.4_GA_518 on 4 XServe G5s running OS X Server 10.4.6. First server runs ldap. Second runs mta, antivirus & antispam. Third runs mailbox, spell, and logger. Fourth runs mailbox. These were originally setup as 3.1.1 and were recently updated to 3.1.4.

When I tested Zimbra before implementation, I had no problem with logger. All of the graphs showed up fine. This was on a single-installation FC4 install.

Since installing Zimbra as a multi-server OSX install I haven't had any graphs show up. It's not anything critical, but it would be a nice plus.

Logger's running on the third server:

mail:~ zimbra$ zmcontrol status
Host mail.rcps.info
logger Running
mailbox Running
snmp Running
spell Running

I was trying to find errors that might help point to what was happening, and ran /opt/zimbra/libexec/zmgengraphs as root and got the following error message:

mail:root# /opt/zimbra/libexec/zmgengraphs
install_driver(mysql) failed: Can't load '/opt/zimbra/zimbramon/lib/darwin-thread-multi-2level/auto/DBD/mysql/mysql.bundle' for module DBD::mysql: dlopen(/opt/zimbra/zimbramon/lib/darwin-thread-multi-2level/auto/DBD/mysql/mysql.bundle, 1): Library not loaded: /opt/zimbra/mysql-standard-4.1.14-apple-darwin8.2.0-powerpc/lib/mysql/libmysqlclient.14.dylib
Referenced from: /opt/zimbra/zimbramon/lib/darwin-thread-multi-2level/auto/DBD/mysql/mysql.bundle
Reason: image not found at /System/Library/Perl/5.8.6/darwin-thread-multi-2level/DynaLoader.pm line 230.
at (eval 4) line 3
Compilation failed in require at (eval 4) line 3.
Perhaps a required shared library or dll isn't installed where expected
at /opt/zimbra/libexec/zmgengraphs line 107

I'd had some problems with mysql libs not being where they were expected at the beginning (mta not running in OSX multi-server installation) and solved this one the same way.

ln -s /opt/zimbra/mysql-standard-4.1.16-apple-darwin8.2.0-powerpc /opt/zimbra/mysql-standard-4.1.14-apple-darwin8.2.0-powerpc

/opt/zimbra/libexec/zmgengraphs
Generating hour graph for mta on ALL
Generating hour graph for mta on ALL
Generating day graph for mta on ALL
Generating day graph for mta on ALL
Generating month graph for mta on ALL
Generating month graph for mta on ALL
Generating year graph for mta on ALL
Generating year graph for mta on ALL
Generating hour graph for amavis on ALL
Generating day graph for amavis on ALL
Generating month graph for amavis on ALL
Generating year graph for amavis on ALL

That error seems to be solved, but still no data in the graphs.

Searching through forum posts I find this thread No data in server statistics and try the following suggestions

su - zimbra
logmysql
use zimbra_logger;
select distinct(host) from mta_aggregate;

and I get back

Empty set (0.00 sec).

How would I set the host if it's not listed or hasn't been set?

[brian]

This has been covered in several threads and there are fixes in later versions of zcs.

Take this post for somewhat of a summary
Logger service issues