Hello,
I also have an clean install of 4.0RC1 that does not show server status or in fact any of the server statistics. The installtion is on Mac OS X though, just to be different.
I have checked the logger database and it is there and it has tables but there is no data in the tables.
I have checked zimbra.log and can see status messages being logged there (although the lines from zimbramon have an extra \n on the end for some reason.
For some reason this information just does not seem to be getting into the database...
Below is the contents of logger_mysqld.log
Quote:
060821 10:12:03 mysqld started
060821 10:12:03 [Warning] Setting lower_case_table_names=2 because file system for /opt/zimbra/logger/db/data/ is case insensitive
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
060821 10:12:03 InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
060821 10:12:04 InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
060821 10:12:04 InnoDB: Log file ./ib_logfile1 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
060821 10:12:04 InnoDB: Started; log sequence number 0 0
/opt/zimbra/logger/mysql/libexec/mysqld: ready for connections.
Version: '4.1.20-log' socket: '/opt/zimbra/logger/db/mysql.sock' port: 7307 Source distribution
A mysqld process already exists at Mon Aug 21 10:12:31 BST 2006
A mysqld process already exists at Mon Aug 21 10:13:59 BST 2006
060821 10:17:30 [Note] /opt/zimbra/logger/mysql/libexec/mysqld: Normal shutdown
060821 10:17:31 InnoDB: Starting shutdown...
060821 10:17:33 InnoDB: Shutdown completed; log sequence number 0 43634
060821 10:17:33 [Note] /opt/zimbra/logger/mysql/libexec/mysqld: Shutdown complete
060821 10:17:33 mysqld ended
060821 10:18:42 mysqld started
060821 10:18:43 [Warning] Setting lower_case_table_names=2 because file system for /opt/zimbra/logger/db/data/ is case insensitive
060821 10:18:46 InnoDB: Started; log sequence number 0 43634
/opt/zimbra/logger/mysql/libexec/mysqld: ready for connections.
Version: '4.1.20-log' socket: '/opt/zimbra/logger/db/mysql.sock' port: 7307 Source distribution
060821 10:28:47 [Note] /opt/zimbra/logger/mysql/libexec/mysqld: Normal shutdown
060821 10:28:49 InnoDB: Starting shutdown...
060821 10:28:52 InnoDB: Shutdown completed; log sequence number 0 43634
060821 10:28:52 [Note] /opt/zimbra/logger/mysql/libexec/mysqld: Shutdown complete
060821 10:28:52 mysqld ended
060821 10:30:06 mysqld started
060821 10:30:10 [Warning] Setting lower_case_table_names=2 because file system for /opt/zimbra/logger/db/data/ is case insensitive
060821 10:30:16 InnoDB: Started; log sequence number 0 43634
/opt/zimbra/logger/mysql/libexec/mysqld: ready for connections.
Version: '4.1.20-log' socket: '/opt/zimbra/logger/db/mysql.sock' port: 7307 Source distribution
|
And here is the contents of zmloggerinit.log
Quote:
Installing all prepared tables
060821 10:12:02 [Warning] Setting lower_case_table_names=2 because file system for /opt/zimbra/logger/db/data/ is case insensitive
Fill help tables
060821 10:12:03 [Warning] Setting lower_case_table_names=2 because file system for /opt/zimbra/logger/db/data/ is case insensitive
To start mysqld at boot time you have to copy support-files/mysql.server
to the right place for your system
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/opt/zimbra/logger/mysql/bin/mysqladmin -u root password 'new-password'
/opt/zimbra/logger/mysql/bin/mysqladmin -u root -h mini01.mevanna.com password 'new-password'
See the manual for more instructions.
You can start the MySQL daemon with:
cd /opt/zimbra/mysql-standard-4.1.20-apple-darwin8.2.0-i686 ; /opt/zimbra/logger/mysql/bin/mysqld_safe &
You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory:
cd sql-bench ; perl run-all-tests
Please report any problems with the /opt/zimbra/mysql-standard-4.1.20-apple-darwin8.2.0-i686/bin/mysqlbug script!
The latest information about MySQL is available on the web at
http://www.mysql.com
Support MySQL by buying support/licenses at http://shop.mysql.com |
And these are the mysql processes running on the server...
Quote:
456 ?? S 0:00.02 /bin/sh /opt/zimbra/logger/mysql/bin/mysqld_safe --defaults-file=/opt/zimbra/conf/my.logger.cnf --ledir=/opt/zimbra/logger/mysql/libexec
480 ?? S 0:00.02 /bin/sh /opt/zimbra/mysql/bin/mysqld_safe --defaults-file=/opt/zimbra/conf/my.cnf --ledir=/opt/zimbra/mysql/libexec
569 ?? S 2:09.87 /opt/zimbra/mysql/libexec/mysqld --defaults-file=/opt/zimbra/conf/my.cnf --basedir=/opt/zimbra/mysql --datadir=/opt/zimbra/db/data --pid-file=/opt/zimbra/db/mysql.pid --port=7306 --socket=/opt/zimbra/db/mysql.sock
570 ?? S 1:43.16 /opt/zimbra/logger/mysql/libexec/mysqld --defaults-file=/opt/zimbra/conf/my.logger.cnf --basedir=/opt/zimbra/logger/mysql --datadir=/opt/zimbra/logger/db/data --pid-file=/opt/zimbra/logger/db/mysql.pid --port=7307 --socket=/opt/zimbra/logger/db/mysql.sock
|
Any help appreciated.
Jason