Logger

[KevinH]

"logmysqladmin start" is not the right syntax. You don't even need to use that to start/stop. It's only used for admin of the database.

So now that it's started what happens? Do you get an error of sometype?

[jholder]

Well, when I go into the admin panel, I get an error right off about the logger connection.

zmcontrol status reveals the logger is still stopped.
sh -x zmloggerctl status reveals:

+ BASE=/opt/zimbra
+ SCRIPTS='logmysql.server zmlogswatchctl'
+ case "$1" in
+ STATUS=0
+ for i in '$SCRIPTS'
+ '[' logmysql.server = logmysql.server ']'
+ /opt/zimbra/bin/logmysqladmin status
+ R=1
+ '[' 1 -ne 0 ']'
+ STATUS=1
+ for i in '$SCRIPTS'
+ '[' zmlogswatchctl = logmysql.server ']'
+ /opt/zimbra/bin/zmlogswatchctl status
/opt/zimbra/bin/zmlogswatchctl: line 69: kill: (5491) - No such process

So it still sounds like the swatch isn't starting likely because of a password issue. Would you like me to post a log?

How late will you be cruising the forums, I gotta run somewhere?

[KevinH]

Originally Posted by wannabetenor

So it still sounds like the swatch isn't starting likely because of a password issue. Would you like me to post a log?

How late will you be cruising the forums, I gotta run somewhere?

Yep post the tomcat log and see if you can start swatch manually. You can also try to connect to MySQL manually with the new password to see if that works.

I'm on/of the forums all the time. If I miss you don't worry I'm sure I'll get to it tomorrow. Plus logger is not mission critical so if it's not running it shouldn't cause too much harm. Lots of folks don't run it at all to save resources on smaller hardware.

[jholder]

Yeah, the logger is a nice feature, but I don't really care if it runs.

My problem is that it (logger) wasn't running when I tried the dev build. When it (inst script) encountered that the logger wasn't running, it exited abnormally causing havoc...and eventually the restoration from a backup. (Which btw, I will be posting an extenisve tutorial on)

I want to get it running because I'm fearful to run any dev builds (for testing/bugzilla) or any future releases, because I don't want the installer to exit.

I'm talking in fragments.

---------
BTW: in the pvt, I meant we were working with Dan on the network edition...not that we were going to buy Dan...I don't think he's for sale.

[jholder]

Good Evening,
Here are the results:
cat log

 zmtomcatstart: info: stale pid 26950 in pid file: No such process
Mar 29, 2006 6:39:47 PM org.apache.coyote.http11.Http11Protocol init
INFO: Initializing Coyote HTTP/1.1 on http-81
Mar 29, 2006 6:39:49 PM org.apache.coyote.http11.Http11Protocol init
INFO: Initializing Coyote HTTP/1.1 on http-443
Mar 29, 2006 6:39:49 PM org.apache.coyote.http11.Http11Protocol init
INFO: Initializing Coyote HTTP/1.1 on http-7071
Mar 29, 2006 6:39:49 PM org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 4506 ms
Mar 29, 2006 6:39:49 PM org.apache.catalina.core.StandardService start
INFO: Starting service Catalina
Mar 29, 2006 6:39:49 PM org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/5.5.7
Mar 29, 2006 6:39:49 PM org.apache.catalina.core.StandardHost start
INFO: XML validation disabled
log4j:WARN No appenders could be found for logger (org.apache.catalina.session.ManagerBase).
log4j:WARN Please initialize the log4j system properly.
Zimbra server reserving server socket port=110 bindaddr=null ssl=false
Zimbra server reserving server socket port=143 bindaddr=null ssl=false
Zimbra server process is running as root, changing to user=zimbra uid=501 gid=501
Zimbra server process, after change, is running with uid=501 euid=501 gid=501 egid=501
Mar 29, 2006 6:40:13 PM org.apache.coyote.http11.Http11Protocol start
INFO: Starting Coyote HTTP/1.1 on http-81
Mar 29, 2006 6:40:13 PM org.apache.coyote.http11.Http11Protocol start
INFO: Starting Coyote HTTP/1.1 on http-443
Mar 29, 2006 6:40:14 PM org.apache.coyote.http11.Http11Protocol start
INFO: Starting Coyote HTTP/1.1 on http-7071
Mar 29, 2006 6:40:14 PM org.apache.catalina.startup.Catalina start
INFO: Server startup in 25191 ms

Using su zimbra
zmlogswatchctl start returns nothing
zmlogswatchctl status returns nothing
zmlogswatchctl stop returns /opt/zimbra/bin/zmlogswatchctl: line 69: kill: (16938) - No such process

mysql mysql sends me into the database.

It's got to be the password.. but I'm just not use what to change.

[KevinH]

Not sure why you think it's the password. I don't see any error's pointing to that at all. Can you run:

sh -x zmlogswatchctl start

Then

ps -ef |grep zimbra

[jholder]

[zimbra@tusd-exch01 bin]$ sh -x zmlogswatchctl start returned:

+ BASE=/opt/zimbra
+ CONFIG=/opt/zimbra/conf/logswatchrc
+ PIDFILE=/opt/zimbra/log/logswatch.pid
+ '[' -f /opt/zimbra/log/logswatch.pid ']'
++ cat /opt/zimbra/log/logswatch.pid
+ PID=21581
+ source /opt/zimbra/.bashrc
++ alias 'rm=rm -i'
++ alias 'cp=cp -i'
++ alias 'mv=mv -i'
++ alias 'h=history 40'
++ alias j=jobs
++ '[' -f /etc/bashrc ']'
++ . /etc/bashrc
++++ id -gn
++++ id -un
++++ id -u
+++ '[' zimbra = zimbra -a 501 -gt 99 ']'
+++ umask 002
+++ '[' '' ']'
++ ZIMBRA_HOME=/opt/zimbra
++ export ZIMBRA_HOME
++ JAVA_HOME=/opt/zimbra/java
++ export JAVA_HOME
++ JAVA_JVM_VERSION=1.5
++ export JAVA_JVM_VERSION
++ PATH=/opt/zimbra/bin:/opt/zimbra/zimbramon:/opt/zimbra/postfix-2.2.5/sbin:/opt/zimbra/openldap/bin:/opt/zimbra/java/bin:/opt/zimbra/snmp/bin:/opt/zimbra/bin:/opt/zimbra/zimbramon:/opt/zimbra/postfix-2.2.5/sbin:/opt/zimbra/openldap/bin:/opt/zimbra/java/bin:/opt/zimbra/snmp/bin:/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/root/bin
++ export PATH
++ LD_LIBRARY_PATH=/opt/zimbra/lib:/opt/zimbra/lib:
++ export LD_LIBRARY_PATH
++ SNMPCONFPATH=/opt/zimbra/conf
++ export SNMPCONFPATH
++ PERLLIB=/opt/zimbra/zimbramon/lib:/opt/zimbra/zimbramon/lib/i386-linux-thread-multi:/opt/zimbra/zimbramon/lib/i486-linux-gnu-thread-multi:/opt/zimbra/zimbramon/lib/i586-linux-thread-multi:/opt/zimbra/zimbramon/lib/darwin-thread-multi-2level
++ export PERLLIB
++ ulimit -n 10000
+ case "$1" in
+ '[' -f /opt/zimbra/conf/logswatchrc ']'
+ PID=13382
+ chmod 777 /tmp/logswatch.out
+ echo 13382
+ '[' x13382 '!=' x ']'
+ kill -0 13382
+ exit 0
[zimbra@tusd-exch01 bin]$ + /opt/zimbra/bin/logswatch --config-file=/opt/zimbra/conf/logswatchrc --script-dir=/tmp -t /var/log/zimbra.log

---------------------------------------------------------------------
[zimbra@tusd-exch01 bin]$ ps -ef |grep zimbra returned:

zimbra   27954     1  0 Mar28 ?        00:00:00 /usr/bin/tail -n 0 -f /var/log/zimbra.log
zimbra   16203     1  0 18:36 ?        00:00:00 /bin/sh /opt/zimbra/mysql/bin/mysqld_safe --defaults-file=/opt/zimbra/conf/my.cnf --ledir=/opt/zimbra/mysql/bin
zimbra   16235 16203  0 18:36 ?        00:00:10 /opt/zimbra/mysql/bin/mysqld --defaults-file=/opt/zimbra/conf/my.cnf --basedir=/opt/zimbra/mysql --datadir=/opt/zimbra/db/data --pid-file=/opt/zimbra/db/mysql.pid --skip-locking --port=7306 --socket=/opt/zimbra/db/mysql.sock
zimbra   16278     1  0 18:36 ?        00:00:03 /opt/zimbra/openldap/libexec/slapd -l LOCAL0 -4 -u zimbra -h ldaps:// ldap://:389/ -f /opt/zimbra/conf/slapd.conf
zimbra   16366     1  0 18:37 ?        00:00:05 /usr/bin/perl /opt/zimbra/bin/zmmtaconfig
zimbra   16688     1  0 18:37 ?        00:00:02 amavisd (master)
zimbra   16692 16688  0 18:37 ?        00:00:02 amavisd (ch2-avail)
zimbra   16693 16688  0 18:37 ?        00:00:01 amavisd (ch2-avail)
zimbra   16694 16688  0 18:37 ?        00:00:02 amavisd (ch2-avail)
zimbra   16695 16688  0 18:37 ?        00:00:02 amavisd (ch2-avail)
zimbra   16696 16688  0 18:37 ?        00:00:02 amavisd (ch2-avail)
zimbra   16697 16688  0 18:37 ?        00:00:02 amavisd (ch1-avail)
zimbra   16698 16688  0 18:37 ?        00:00:04 amavisd (ch2-avail)
zimbra   16699 16688  0 18:37 ?        00:00:03 amavisd (ch1-avail)
zimbra   16700 16688  0 18:37 ?        00:00:02 amavisd (ch1-avail)
zimbra   16701 16688  0 18:37 ?        00:00:02 amavisd (ch1-avail)
zimbra   16920     1  0 18:38 ?        00:00:00 /bin/sh /opt/zimbra/logger/mysql/bin/mysqld_safe --defaults-file=/opt/zimbra/conf/my.logger.cnf --ledir=/opt/zimbra/logger/mysql/bin
zimbra   16937     1  0 18:38 ?        00:00:00 /opt/zimbra/clamav/bin/freshclam --config-file=/opt/zimbra/conf/freshclam.conf -d --checks=12
zimbra   17007 16920  0 18:38 ?        00:00:07 /opt/zimbra/logger/mysql/bin/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 --skip-locking --port=7307 --socket=/opt/zimbra/logger/db/mysql.sock
zimbra   17072     1  0 18:38 ?        00:00:04 /opt/zimbra/clamav/sbin/clamd --config-file /opt/zimbra/conf/clamd.conf
zimbra   17622     1  0 18:39 ?        00:00:32 /opt/zimbra/jdk1.5.0_05/bin/java -Xms93m -Xmx93m -client -XX:NewRatio=2 -Dcatalina.base=/opt/zimbra/jakarta-tomcat-5.5.7 -Dcatalina.home=/opt/zimbra/jakarta-tomcat-5.5.7 -Djava.io.tmpdir=/opt/zimbra/jakarta-tomcat-5.5.7/temp -Djava.library.path=/opt/zimbra/lib/jars -Djava.endorsed.dirs=/opt/zimbra/jakarta-tomcat-5.5.7/common/endorsed -classpath /opt/zimbra/jakarta-tomcat-5.5.7/bin/bootstrap.jar:/opt/zimbra/jakarta-tomcat-5.5.7/bin/commons-logging-api.jar org.apache.catalina.startup.Bootstrap start
root     18436     1  0 18:40 ?        00:00:00 /opt/zimbra/postfix-2.2.5/libexec/master
zimbra   18450     1  0 18:40 ?        00:00:00 /opt/zimbra/cyrus-sasl-2.1.21.ZIMBRA/sbin/saslauthd -r -a zimbra
zimbra   18451 18450  0 18:40 ?        00:00:00 /opt/zimbra/cyrus-sasl-2.1.21.ZIMBRA/sbin/saslauthd -r -a zimbra
zimbra   18452 18450  0 18:40 ?        00:00:00 /opt/zimbra/cyrus-sasl-2.1.21.ZIMBRA/sbin/saslauthd -r -a zimbra
zimbra   18453 18450  0 18:40 ?        00:00:00 /opt/zimbra/cyrus-sasl-2.1.21.ZIMBRA/sbin/saslauthd -r -a zimbra
zimbra   18454 18450  0 18:40 ?        00:00:00 /opt/zimbra/cyrus-sasl-2.1.21.ZIMBRA/sbin/saslauthd -r -a zimbra
zimbra   18463     1  0 18:40 ?        00:00:00 /usr/bin/perl /opt/zimbra/bin/swatch --config-file=/opt/zimbra/conf/swatchrc --script-dir=/tmp -t /var/log/zimbra.log
zimbra   18478 18463  0 18:40 ?        00:00:01 /usr/bin/perl /tmp/.swatch_script.18463
zimbra   18496 18478  0 18:41 ?        00:00:00 /usr/bin/tail -n 0 -f /var/log/zimbra.log
zimbra   18510     1  0 18:41 ?        00:00:00 /opt/zimbra/httpd-2.0.54/bin/httpd -k start -f /opt/zimbra/conf/httpd.conf
zimbra   18511 18510  0 18:41 ?        00:00:00 /opt/zimbra/httpd-2.0.54/bin/httpd -k start -f /opt/zimbra/conf/httpd.conf
zimbra   18512 18510  0 18:41 ?        00:00:00 /opt/zimbra/httpd-2.0.54/bin/httpd -k start -f /opt/zimbra/conf/httpd.conf
zimbra   18513 18510  0 18:41 ?        00:00:00 /opt/zimbra/httpd-2.0.54/bin/httpd -k start -f /opt/zimbra/conf/httpd.conf
zimbra   18514 18510  0 18:41 ?        00:00:00 /opt/zimbra/httpd-2.0.54/bin/httpd -k start -f /opt/zimbra/conf/httpd.conf
zimbra   18515 18510  0 18:41 ?        00:00:00 /opt/zimbra/httpd-2.0.54/bin/httpd -k start -f /opt/zimbra/conf/httpd.conf
root     12335 12317  0 20:32 pts/1    00:00:00 su zimbra
zimbra   12336 12335  0 20:32 pts/1    00:00:00 bash
root     12652 12502  0 20:33 pts/3    00:00:00 su zimbra
zimbra   12653 12652  0 20:33 pts/3    00:00:00 bash
zimbra   13781 12653  0 20:37 pts/3    00:00:00 ps -ef
zimbra   13782 12653  0 20:37 pts/3    00:00:00 [grep]

The reason I am inclined to belive it's a password issue is because that seems to be the majority of the issues involving the logger in the forum....but you guys built the thing.

[KevinH]

Well looks like it's running. Anything in /var/log/zimbra.log about swatch?

[jholder]

Well, that's what it looks like, but if I login to the admin panel, it says it can't connect to the logger.

It doesn't say anything directly in the zimbra log about the swatch, so I thought I'd post the startup:

Mar 29 18:37:36 tusd-exch01 zimbramon[16258]: 16258:info: Starting antivirus 
Mar 29 18:37:42 tusd-exch01 amavis[16664]: starting.  /opt/zimbra/amavisd/sbin/amavisd at tusd-exch01.tombstone.k12.az.us amavisd-new-2.3.3 (20050822), Unicode aware, LANG=en_US.UTF-8
Mar 29 18:37:42 tusd-exch01 amavis[16664]: user=501, EUID: 501 (501);  group=, EGID: 501 502 501 5 (501 502 501 5)
Mar 29 18:37:42 tusd-exch01 amavis[16664]: Perl version               5.008005
Mar 29 18:37:45 tusd-exch01 amavis[16688]: Net::Server: Process Backgrounded
Mar 29 18:37:45 tusd-exch01 amavis[16688]: Net::Server: 2006/03/29-18:37:45 Amavis (type Net::Server::PreForkSimple) starting! pid(16688)
Mar 29 18:37:45 tusd-exch01 amavis[16688]: Net::Server: Binding to TCP port 10024 on host 127.0.0.1
Mar 29 18:37:45 tusd-exch01 amavis[16688]: Net::Server: Group Not Defined.  Defaulting to EGID '501 502 501 5'
Mar 29 18:37:45 tusd-exch01 amavis[16688]: Net::Server: User Not Defined.  Defaulting to EUID '501'
Mar 29 18:37:45 tusd-exch01 amavis[16688]: Module Amavis::Conf        2.043
Mar 29 18:37:45 tusd-exch01 amavis[16688]: Module Archive::Tar        1.26
Mar 29 18:37:45 tusd-exch01 amavis[16688]: Module Archive::Zip        1.16
Mar 29 18:37:45 tusd-exch01 amavis[16688]: Module BerkeleyDB          0.27
Mar 29 18:37:45 tusd-exch01 amavis[16688]: Module Compress::Zlib      1.41
Mar 29 18:37:45 tusd-exch01 amavis[16688]: Module Convert::TNEF       0.17
Mar 29 18:37:45 tusd-exch01 amavis[16688]: Module Convert::UUlib      1.051
Mar 29 18:37:45 tusd-exch01 amavis[16688]: Module DBD::mysql          3.0002
Mar 29 18:37:45 tusd-exch01 amavis[16688]: Module DBI                 1.48
Mar 29 18:37:45 tusd-exch01 amavis[16688]: Module DB_File             1.809
Mar 29 18:37:45 tusd-exch01 amavis[16688]: Module MIME::Entity        5.418
Mar 29 18:37:45 tusd-exch01 amavis[16688]: Module MIME::Parser        5.418
Mar 29 18:37:45 tusd-exch01 amavis[16688]: Module MIME::Tools         5.418
Mar 29 18:37:45 tusd-exch01 amavis[16688]: Module Mail::Header        1.67
Mar 29 18:37:45 tusd-exch01 amavis[16688]: Module Mail::Internet      1.67
Mar 29 18:37:45 tusd-exch01 amavis[16688]: Module Mail::SpamAssassin  3.001000
Mar 29 18:37:45 tusd-exch01 amavis[16688]: Module Net::Cmd            2.26
Mar 29 18:37:45 tusd-exch01 amavis[16688]: Module Net::DNS            0.53
Mar 29 18:37:45 tusd-exch01 amavis[16688]: Module Net::LDAP           0.33
Mar 29 18:37:45 tusd-exch01 amavis[16688]: Module Net::SMTP           2.29
Mar 29 18:37:45 tusd-exch01 amavis[16688]: Module Net::Server         0.89
Mar 29 18:37:45 tusd-exch01 amavis[16688]: Module Time::HiRes         1.83
Mar 29 18:37:45 tusd-exch01 amavis[16688]: Module Unix::Syslog        0.99
Mar 29 18:37:45 tusd-exch01 amavis[16688]: Amavis::DB code    loaded
Mar 29 18:37:45 tusd-exch01 amavis[16688]: Amavis::Cache code loaded
Mar 29 18:37:45 tusd-exch01 amavis[16688]: SQL base code      NOT loaded
Mar 29 18:37:45 tusd-exch01 amavis[16688]: SQL::Log code      NOT loaded
Mar 29 18:37:45 tusd-exch01 amavis[16688]: SQL::Quarantine    NOT loaded
Mar 29 18:37:45 tusd-exch01 amavis[16688]: Lookup::SQL  code  NOT loaded
Mar 29 18:37:45 tusd-exch01 amavis[16688]: Lookup::LDAP code  loaded
Mar 29 18:37:45 tusd-exch01 amavis[16688]: AM.PDP prot  code  NOT loaded
Mar 29 18:37:45 tusd-exch01 amavis[16688]: SMTP-in prot code  loaded
Mar 29 18:37:45 tusd-exch01 amavis[16688]: ANTI-VIRUS code    loaded
Mar 29 18:37:45 tusd-exch01 amavis[16688]: ANTI-SPAM  code    loaded
Mar 29 18:37:45 tusd-exch01 amavis[16688]: Unpackers  code    loaded
Mar 29 18:37:45 tusd-exch01 amavis[16688]: Found $file            at /usr/bin/file
Mar 29 18:37:45 tusd-exch01 amavis[16688]: No $dspam,             not using it
Mar 29 18:37:45 tusd-exch01 amavis[16688]: Internal decoder for .mail
Mar 29 18:37:45 tusd-exch01 amavis[16688]: Internal decoder for .asc 
Mar 29 18:37:45 tusd-exch01 amavis[16688]: Internal decoder for .uue 
Mar 29 18:37:45 tusd-exch01 amavis[16688]: Internal decoder for .hqx 
Mar 29 18:37:45 tusd-exch01 amavis[16688]: Internal decoder for .ync 
Mar 29 18:37:45 tusd-exch01 amavis[16688]: No decoder for       .F    tried: unfreeze, freeze -d, melt, fcat
Mar 29 18:37:45 tusd-exch01 amavis[16688]: Found decoder for    .Z    at /usr/bin/uncompress
Mar 29 18:37:45 tusd-exch01 amavis[16688]: Internal decoder for .gz  
Mar 29 18:37:46 tusd-exch01 amavis[16688]: Found decoder for    .bz2  at /usr/bin/bzip2 -d
Mar 29 18:37:46 tusd-exch01 amavis[16688]: No decoder for       .lzo  tried: lzop -d
Mar 29 18:37:46 tusd-exch01 amavis[16688]: Found decoder for    .rpm  at /usr/bin/rpm2cpio
Mar 29 18:37:46 tusd-exch01 amavis[16688]: Found decoder for    .cpio at /usr/bin/pax
Mar 29 18:37:46 tusd-exch01 amavis[16688]: Found decoder for    .tar  at /usr/bin/pax
Mar 29 18:37:46 tusd-exch01 amavis[16688]: Found decoder for    .deb  at /usr/bin/ar
Mar 29 18:37:46 tusd-exch01 amavis[16688]: Internal decoder for .zip 
Mar 29 18:37:46 tusd-exch01 amavis[16688]: No decoder for       .rar  tried: rar, unrar
Mar 29 18:37:46 tusd-exch01 amavis[16688]: No decoder for       .arj  tried: arj, unarj
Mar 29 18:37:46 tusd-exch01 amavis[16688]: No decoder for       .arc  tried: nomarch, arc
Mar 29 18:37:46 tusd-exch01 amavis[16688]: No decoder for       .zoo  tried: zoo
Mar 29 18:37:46 tusd-exch01 amavis[16688]: Found decoder for    .lha  at /usr/bin/lha
Mar 29 18:37:46 tusd-exch01 amavis[16688]: No decoder for       .cab  tried: cabextract
Mar 29 18:37:46 tusd-exch01 amavis[16688]: No decoder for       .tnef tried: tnef
Mar 29 18:37:46 tusd-exch01 amavis[16688]: Internal decoder for .tnef
Mar 29 18:37:46 tusd-exch01 amavis[16688]: Found decoder for    .exe  at /usr/bin/lha
Mar 29 18:37:46 tusd-exch01 amavis[16688]: Using internal av scanner code for (primary) ClamAV-clamd
Mar 29 18:37:46 tusd-exch01 amavis[16688]: Creating db in /opt/zimbra/amavisd/db/; BerkeleyDB 0.27, libdb 4.2
Mar 29 18:37:46 tusd-exch01 amavis[16688]: SpamControl: initializing Mail::SpamAssassin
Mar 29 18:37:49 tusd-exch01 amavis[16688]: SpamControl: done
Mar 29 18:38:16 tusd-exch01 zimbramon[16258]: 16258:info: Starting logger 
Mar 29 18:38:16 tusd-exch01 clamd[16908]: Daemon started. 
Mar 29 18:38:16 tusd-exch01 clamd[16908]: clamd daemon 0.87.1 (OS: linux-gnu, ARCH: i386, CPU: i686) 
Mar 29 18:38:16 tusd-exch01 clamd[16908]: Log file size limited to 20971520 bytes. 
Mar 29 18:38:16 tusd-exch01 clamd[16908]: Reading databases from /opt/zimbra/clamav/db 
Mar 29 18:38:16 tusd-exch01 zimbramon[16258]: 16258:info: Starting mailbox 
Mar 30 01:38:19 tusd-exch01 postfix/postqueue[17021]: fatal: Queue report unavailable - mail system is down
Mar 29 18:38:20 tusd-exch01 zimbramon[16761]: 16761:info: 2006-03-29 18:38:01, STATUS: tusd-exch01.tombstone.k12.az.us: antispam: Running 
Mar 29 18:38:20 tusd-exch01 zimbramon[16761]: 16761:info: 2006-03-29 18:38:01, STATUS: tusd-exch01.tombstone.k12.az.us: antivirus: Stopped 
Mar 29 18:38:20 tusd-exch01 zimbramon[16761]: 16761:info: 2006-03-29 18:38:01, STATUS: tusd-exch01.tombstone.k12.az.us: ldap: Running 
Mar 29 18:38:20 tusd-exch01 zimbramon[16761]: 16761:info: 2006-03-29 18:38:01, STATUS: tusd-exch01.tombstone.k12.az.us: logger: Stopped 
Mar 29 18:38:20 tusd-exch01 zimbramon[16761]: 16761:info: 2006-03-29 18:38:01, STATUS: tusd-exch01.tombstone.k12.az.us: mailbox: Stopped 
Mar 29 18:38:20 tusd-exch01 zimbramon[16761]: 16761:info: 2006-03-29 18:38:01, STATUS: tusd-exch01.tombstone.k12.az.us: mta: Stopped 
Mar 29 18:38:20 tusd-exch01 zimbramon[16761]: 16761:info: 2006-03-29 18:38:01, STATUS: tusd-exch01.tombstone.k12.az.us: snmp: Stopped 
Mar 29 18:38:20 tusd-exch01 zimbramon[16761]: 16761:info: 2006-03-29 18:38:01, STATUS: tusd-exch01.tombstone.k12.az.us: spell: Stopped 
Mar 29 18:38:25 tusd-exch01 clamd[16908]: Protecting against 48233 viruses. 
Mar 29 18:38:25 tusd-exch01 clamd[17072]: Bound to port 3310 
Mar 29 18:38:25 tusd-exch01 clamd[17072]: Setting connection queue length to 15 
Mar 29 18:38:25 tusd-exch01 clamd[17072]: Archive: Archived file size limit set to 104857600 bytes. 
Mar 29 18:38:25 tusd-exch01 clamd[17072]: Archive: Recursion level limit set to 8. 
Mar 29 18:38:25 tusd-exch01 clamd[17072]: Archive: Files limit set to 1000. 
Mar 29 18:38:25 tusd-exch01 clamd[17072]: Archive: Compression ratio limit set to 250. 
Mar 29 18:38:25 tusd-exch01 clamd[17072]: Archive support enabled. 
Mar 29 18:38:25 tusd-exch01 clamd[17072]: Archive: RAR support disabled. 
Mar 29 18:38:25 tusd-exch01 clamd[17072]: Portable Executable support enabled. 
Mar 29 18:38:25 tusd-exch01 clamd[17072]: Mail files support enabled. 
Mar 29 18:38:25 tusd-exch01 clamd[17072]: OLE2 support enabled. 
Mar 29 18:38:25 tusd-exch01 clamd[17072]: HTML support enabled. 
Mar 29 18:38:25 tusd-exch01 clamd[17072]: Self checking every 1800 seconds. 
Mar 30 01:39:14 tusd-exch01 postfix/postqueue[17459]: fatal: Queue report unavailable - mail system is down
Mar 29 18:39:16 tusd-exch01 zimbramon[17266]: 17266:info: 2006-03-29 18:39:02, STATUS: tusd-exch01.tombstone.k12.az.us: antispam: Running 
Mar 29 18:39:16 tusd-exch01 zimbramon[17266]: 17266:info: 2006-03-29 18:39:02, STATUS: tusd-exch01.tombstone.k12.az.us: antivirus: Running 
Mar 29 18:39:16 tusd-exch01 zimbramon[17266]: 17266:info: 2006-03-29 18:39:02, STATUS: tusd-exch01.tombstone.k12.az.us: ldap: Running 
Mar 29 18:39:16 tusd-exch01 zimbramon[17266]: 17266:info: 2006-03-29 18:39:02, STATUS: tusd-exch01.tombstone.k12.az.us: logger: Stopped 
Mar 29 18:39:16 tusd-exch01 zimbramon[17266]: 17266:info: 2006-03-29 18:39:02, STATUS: tusd-exch01.tombstone.k12.az.us: mailbox: Stopped 
Mar 29 18:39:16 tusd-exch01 zimbramon[17266]: 17266:info: 2006-03-29 18:39:02, STATUS: tusd-exch01.tombstone.k12.az.us: mta: Stopped 
Mar 29 18:39:16 tusd-exch01 zimbramon[17266]: 17266:info: 2006-03-29 18:39:02, STATUS: tusd-exch01.tombstone.k12.az.us: snmp: Stopped 
Mar 29 18:39:16 tusd-exch01 zimbramon[17266]: 17266:info: 2006-03-29 18:39:02, STATUS: tusd-exch01.tombstone.k12.az.us: spell: Stopped 
Mar 29 18:39:41 tusd-exch01 zimbramon[16258]: 16258:info: Starting mta 
Mar 30 01:40:08 tusd-exch01 postfix/postqueue[17742]: fatal: Queue report unavailable - mail system is down
Mar 29 18:40:08 tusd-exch01 zimbramon[17711]: 17711:info: 2006-03-29 18:40:05, DISK: : dev: /dev/hda1, mp: /, tot: 75118, avail: 48266 
Mar 29 18:40:09 tusd-exch01 zimbramon[17707]: 17707:info: 2006-03-29 18:40:05, QUEUE: 0 0 
Mar 29 18:40:12 tusd-exch01 zimbramon[17711]: 17711:info: 2006-03-29 18:40:05, DISK: : dev: /dev/hdb1, mp: /boot, tot: 65273, avail: 61868 
Mar 29 18:40:13 tusd-exch01 sendmail[17758]: k2U1eChm017758: from=zimbra, size=311, class=0, nrcpts=1, msgid=<200603300140.k2U1eChm017758@tusd-exch01.tombstone.k12.az.us>, relay=zimbra@localhost
Mar 29 18:40:13 tusd-exch01 sendmail[17758]: k2U1eChm017758: to=zimbra, ctladdr=zimbra (501/501), delay=00:00:01, xdelay=00:00:00, mailer=relay, pri=30311, relay=[127.0.0.1] [127.0.0.1], dsn=4.0.0, stat=Deferred: Connection refused by [127.0.0.1]
Mar 30 01:40:30 tusd-exch01 postfix/postqueue[18230]: fatal: Queue report unavailable - mail system is down
Mar 29 18:40:34 tusd-exch01 zimbramon[17732]: 17732:info: 2006-03-29 18:40:13, STATUS: tusd-exch01.tombstone.k12.az.us: antispam: Running 
Mar 29 18:40:34 tusd-exch01 zimbramon[17732]: 17732:info: 2006-03-29 18:40:13, STATUS: tusd-exch01.tombstone.k12.az.us: antivirus: Running 
Mar 29 18:40:34 tusd-exch01 zimbramon[17732]: 17732:info: 2006-03-29 18:40:13, STATUS: tusd-exch01.tombstone.k12.az.us: ldap: Running 
Mar 29 18:40:34 tusd-exch01 zimbramon[17732]: 17732:info: 2006-03-29 18:40:13, STATUS: tusd-exch01.tombstone.k12.az.us: logger: Stopped 
Mar 29 18:40:34 tusd-exch01 zimbramon[17732]: 17732:info: 2006-03-29 18:40:13, STATUS: tusd-exch01.tombstone.k12.az.us: mailbox: Running 
Mar 29 18:40:34 tusd-exch01 zimbramon[17732]: 17732:info: 2006-03-29 18:40:13, STATUS: tusd-exch01.tombstone.k12.az.us: mta: Stopped 
Mar 29 18:40:34 tusd-exch01 zimbramon[17732]: 17732:info: 2006-03-29 18:40:13, STATUS: tusd-exch01.tombstone.k12.az.us: snmp: Stopped 
Mar 29 18:40:34 tusd-exch01 zimbramon[17732]: 17732:info: 2006-03-29 18:40:13, STATUS: tusd-exch01.tombstone.k12.az.us: spell: Stopped 
Mar 29 18:40:55 tusd-exch01 postfix/postsuper[18388]: Requeued: 5 messages
Mar 29 18:40:57 tusd-exch01 postfix/postfix-script: warning: not owned by root: /opt/zimbra/postfix-2.2.5/conf/main.cf
Mar 29 18:40:57 tusd-exch01 postfix/postfix-script: starting the Postfix mail system
Mar 29 18:40:57 tusd-exch01 postfix/master[18436]: daemon started -- version 2.2.5, configuration /opt/zimbra/postfix-2.2.5/conf
Mar 29 18:40:57 tusd-exch01 postfix/pickup[18446]: E6B67240BE4: uid=502 from= orig_id=05EB3240BE1
Mar 29 18:40:58 tusd-exch01 zimbramon[16258]: 16258:info: Starting snmp 
Mar 29 18:40:58 tusd-exch01 zimbramon[16258]: 16258:info: Starting spell

[KevinH]

Got some more info/ideas...

It looks like the password change was done on the wrong db - remember, the mysql command uses the conf file, which tells it to use a unix domain socket, so the port you tell it to use won't effect anything.

Also, swatch info goes to /tmp/swatch.out and /tmp/logswatch.out.

Soooo.....
edit logmysql.server to add skip-grant-tables
logmysql.server start
logmysql
> use mysql
> update user set password=PASSWORD('foobar') where user like 'root%';
> flush-privileges
> exit

zmlocalconfig -e -f mysql_logger_root_password=foobar
logmysql.server stop
re-edit startup script
logmysql.server start
logmysqladmin status
echo $?

That should return 0

Also, make sure that the port in localconfig == the port value in conf/my.logger.cnf (should be 7307)
and that zimbraLogHostName in ldap == the correct hostname