Results 1 to 9 of 9

Thread: Server status data is not available

  1. #1
    Join Date
    Feb 2006
    Posts
    33
    Rep Power
    9

    Default Server status data is not available

    Hello,

    I 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.

    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

    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

    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...

    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

  2. #2
    dijichi2 is offline OpenSource Builder & Moderator
    Join Date
    Oct 2005
    Posts
    1,176
    Rep Power
    12

    Default

    hmm.. what happens if you run:

    su - zimbra
    /opt/zimbra/libexec/zmstatuslog

  3. #3
    Join Date
    Feb 2006
    Posts
    33
    Rep Power
    9

    Default

    Entries are entered into the /var/log/zimbra.log file as expected.

    Aug 24 23:59:12 server01 zmtomcatmgr[16955]: status requested
    Aug 24 23:59:12 server01 zmtomcatmgr[16955]: status OK
    Aug 24 23:59:13 server01 zimbramon[16870]: 16870:info: 2006-08-24 23:59:08, STATUS: server01.alteredminds.com: antispam: Running\n
    Aug 24 23:59:13 server01 zimbramon[16870]: 16870:info: 2006-08-24 23:59:08, STATUS: server01.alteredminds.com: antivirus: Running\n
    Aug 24 23:59:13 server01 zimbramon[16870]: 16870:info: 2006-08-24 23:59:08, STATUS: server01.alteredminds.com: ldap: Running\n
    Aug 24 23:59:13 server01 zimbramon[16870]: 16870:info: 2006-08-24 23:59:08, STATUS: server01.alteredminds.com: logger: Running\n
    Aug 24 23:59:13 server01 zimbramon[16870]: 16870:info: 2006-08-24 23:59:08, STATUS: server01.alteredminds.com: mailbox: Running\n
    Aug 24 23:59:13 server01 zimbramon[16870]: 16870:info: 2006-08-24 23:59:08, STATUS: server01.alteredminds.com: mta: Running\n
    Aug 24 23:59:13 server01 zimbramon[16870]: 16870:info: 2006-08-24 23:59:08, STATUS: server01.alteredminds.com: snmp: Running\n
    Aug 24 23:59:13 server01 zimbramon[16870]: 16870:info: 2006-08-24 23:59:08, STATUS: server01.alteredminds.com: spell: Running\n
    The problem is this information is not getting into the database.

    Am I right in thinking that it is the following crontab entry that should process the log and make the database entries?

    #
    # process logs
    #
    00,10,20,30,40,50 * * * * /opt/zimbra/libexec/zmlogprocess > /tmp/logprocess.out 2>&1
    If so this is its output having run a zmstatuslog just prior..

    Processing mta entries from 0
    Found 0 messages
    Deleting processed postfix logs from raw_logs...Done
    Processing clamd entries from 0
    Found 0 entries
    Deleting processed clamd logs from raw_logs...Done
    Processing amavis entries from 0
    Found 0 entries
    Deleting processed amavis logs from raw_logs...Done
    Processing sendmail entries from 0
    Found 0 entries
    Deleting processed sendmail logs from raw_logs...Done
    Processing zimbramon entries from 0
    Found 0 entries
    Deleting processed zimbramon logs from raw_logs...Done
    Aggregating hour mta from 2006-08-24 23:00:00 to 2006-08-25 00:00:00
    Aggregating day mta from 2006-08-23 00:00:00 to 2006-08-24 00:00:00
    Aggregating day mta from 2006-08-24 00:00:00 to 2006-08-25 00:00:00
    Aggregating hour amavis from 2006-08-24 23:00:00 to 2006-08-25 00:00:00
    Aggregating day amavis from 2006-08-23 00:00:00 to 2006-08-24 00:00:00
    Aggregating day amavis from 2006-08-24 00:00:00 to 2006-08-25 00:00:00
    Aggregating hour disk from 2006-08-24 23:00:00 to 2006-08-25 00:00:00
    Aggregating day disk from 2006-08-23 00:00:00 to 2006-08-24 00:00:00
    Aggregating day disk from 2006-08-24 00:00:00 to 2006-08-25 00:00:00
    RAW: 31
    SUM: 730
    Pruning raw mta logs from 2006-07-25 00:00:00
    Pruning raw amavis logs from 2006-07-25 00:00:00
    Pruning raw disk logs from 2006-07-25 00:00:00
    Pruning summary mta logs from 2004-08-25 00:00:00
    Pruning summary amavis logs from 2004-08-25 00:00:00
    Pruning summary disk logs from 2004-08-25 00:00:00
    Pruning other raw logs from 2006-07-25 00:00:00

    From what I can tell its not picking up the zimbramon log lines.

  4. #4
    dijichi2 is offline OpenSource Builder & Moderator
    Join Date
    Oct 2005
    Posts
    1,176
    Rep Power
    12

    Default

    Am I right in thinking that it is the following crontab entry that should process the log and make the database entries?

    Quote:
    #
    # process logs
    #
    00,10,20,30,40,50 * * * * /opt/zimbra/libexec/zmlogprocess > /tmp/logprocess.out 2>&1
    hmm. i think zmlogprocess sweeps through the raw and detailed service entries that are already in the database and creates aggregate entries that are actually used to create the graphs, but i might be off base here.

    do:
    ps -ef |grep swatch

    you'll see several swatch processes that tail /var/log/zimbra.log and pipe the output to /opt/zimbra/libexec/zmlogger which actually puts the entries into the loggerdb.

    so, make sure your swatch processes are running - in the past these have been temperamental for me on different platforms, they do rely on lots perl libs.

  5. #5
    Join Date
    Feb 2006
    Posts
    33
    Rep Power
    9

    Default

    These are the swatch processes...

    373 p1 S 0:00.12 /usr/bin/perl /opt/zimbra/libexec/logswatch --config-file=/opt/zimbra/conf/logswatchrc --use-cpan-file-tail --script-dir=/tmp -t /var/log/zimbra.log
    518 p1 S 0:45.14 /usr/bin/perl /tmp/.swatch_script.373
    643 p1 S 0:00.10 /usr/bin/perl /opt/zimbra/libexec/swatch --config-file=/opt/zimbra/conf/swatchrc --use-cpan-file-tail --script-dir=/tmp -t /var/log/zimbra.log
    652 p1 S 0:45.05 /usr/bin/perl /tmp/.swatch_script.643

  6. #6
    Join Date
    Feb 2006
    Posts
    33
    Rep Power
    9

    Default

    Hi again

    I have now upgraded my installation to 4.0GA and still have no logging information reaching the database. I can see that the logswatch processes is picking the lines up from the log file (inserted a crude print to see what its getting), but there seems to be a break down after this with actually getting the information into the logging database.

    I can not find any error logs anywhere for this process that have anything in them.

    I really need some help more help on this one as I am reluctant to push this into production without the logging feature working.

    Many thanks
    Jason

  7. #7
    Join Date
    Feb 2006
    Posts
    33
    Rep Power
    9

    Default

    Seem to have worked it out, at least I am getting server status reported in the management interface now.

    The file /opt/zimbra/libexec/zmlogger has an error in it...
    my $logregex;
    # Apple's got an added field in their syslog entries...
    if ($platform =~ /^MAC/) {
    $logregex = qr/(^.{15}) \d+\.\d+\.\d+\.\d+ (\S+) ([^[]+)\[(\d+)\]: (.*)$/o;
    } else {
    $logregex = qr/(^.{15}) (\S+) ([^[]+)\[(\d+)\]: (.*)$/o;
    }
    This supposed added field does not appear in /var/log/zimbra so by using the standard logregex string everything works - so far. All I am waiting for is a bit of history to get into the database and see some graphs. Unless I post back, this is the solution.

    Jason

  8. #8
    Join Date
    Sep 2005
    Posts
    2,103
    Rep Power
    14

    Default

    Quote Originally Posted by jstrat
    Seem to have worked it out, at least I am getting server status reported in the management interface now.

    The file /opt/zimbra/libexec/zmlogger has an error in it...


    This supposed added field does not appear in /var/log/zimbra so by using the standard logregex string everything works - so far. All I am waiting for is a bit of history to get into the database and see some graphs. Unless I post back, this is the solution.

    Jason
    Can you add that to bugzilla? I'm especially interested to know if that's a local log line that's missing the added field, or if it's from a remote host.

    The Mac OSX is just enough different in strange ways that it's a bit of work to get it straight. (sed is different, if you can believe that!)
    Bugzilla - Wiki - Downloads - Before posting... Search!

  9. #9
    Join Date
    Feb 2006
    Posts
    33
    Rep Power
    9

    Default

    Bug 10374 Submitted

    Thanks
    Jason

Similar Threads

  1. Zimbra fails after working for 2 weeks
    By Linsys in forum Administrators
    Replies: 10
    Last Post: 10-07-2008, 12:42 AM
  2. need advice on configuring zimbra to work with fax server
    By pheonix1t in forum Administrators
    Replies: 0
    Last Post: 07-11-2007, 07:46 PM
  3. mysql.server is not running
    By Oswald-Kolle in forum Installation
    Replies: 27
    Last Post: 05-01-2007, 08:28 AM
  4. Trouble sending mail from Outlook
    By czaveri in forum Users
    Replies: 15
    Last Post: 07-24-2006, 11:01 AM
  5. Tomcat hanging
    By Morg0 in forum Administrators
    Replies: 42
    Last Post: 04-19-2006, 08:06 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •