[oopstu]

marcmac, you're rapidly becoming my hero. So I duplicated the steps outlined in your post about manualy resetting mysql passwords but I substitued logmysql.server for mysql.server. Now, the sql server appears to run, or maybe run-crash-run. I think I've got the passwords all in sync, but the /tmp/logswatch.out is showing this:

DBD::mysql::st execute failed: MySQL server has gone away at /opt/zimbra/bin/zmlogger line 162, <> line 973.
DBD::mysql::st execute failed: MySQL server has gone away at /opt/zimbra/bin/zmlogger line 162, <> line 974.
DBD::mysql::st execute failed: MySQL server has gone away at /opt/zimbra/bin/zmlogger line 162, <> line 975.
DBD::mysql::st execute failed: MySQL server has gone away at /opt/zimbra/bin/zmlogger line 162, <> line 976.
DBD::mysql::st execute failed: MySQL server has gone away at /opt/zimbra/bin/zmlogger line 162, <> line 977.
DBD::mysql::st execute failed: MySQL server has gone away at /opt/zimbra/bin/zmlogger line 162, <> line 978.
DBD::mysql::st execute failed: MySQL server has gone away at /opt/zimbra/bin/zmlogger line 162, <> line 979.
DBD::mysql::st execute failed: MySQL server has gone away at /opt/zimbra/bin/zmlogger line 162, <> line 980.
DBD::mysql::st execute failed: MySQL server has gone away at /opt/zimbra/bin/zmlogger line 162, <> line 981.
DBD::mysql::st execute failed: MySQL server has gone away at /opt/zimbra/bin/zmlogger line 162, <> line 982.
DBD::mysql::st execute failed: MySQL server has gone away at /opt/zimbra/bin/zmlogger line 162, <> line 983.
DBD::mysql::st execute failed: MySQL server has gone away at /opt/zimbra/bin/zmlogger line 162, <> line 984.
DBD::mysql::st execute failed: MySQL server has gone away at /opt/zimbra/bin/zmlogger line 162, <> line 985.
DBD::mysql::st execute failed: MySQL server has gone away at /opt/zimbra/bin/zmlogger line 162, <> line 986.
DBD::mysql::st execute failed: MySQL server has gone away at /opt/zimbra/bin/zmlogger line 162, <> line 987.
DBD::mysql::st execute failed: MySQL server has gone away at /opt/zimbra/bin/zmlogger line 162, <> line 988.
DBD::mysql::st execute failed: MySQL server has gone away at /opt/zimbra/bin/zmlogger line 162, <> line 989.
DBD::mysql::st execute failed: MySQL server has gone away at /opt/zimbra/bin/zmlogger line 162, <> line 990.
DBD::mysql::st execute failed: MySQL server has gone away at /opt/zimbra/bin/zmlogger line 162, <> line 991.
DBD::mysql::st execute failed: MySQL server has gone away at /opt/zimbra/bin/zmlogger line 162, <> line 992.
DBD::mysql::st execute failed: MySQL server has gone away at /opt/zimbra/bin/zmlogger line 162, <> line 993.
DBD::mysql::st execute failed: MySQL server has gone away at /opt/zimbra/bin/zmlogger line 162, <> line 994.
DBD::mysql::st execute failed: MySQL server has gone away at /opt/zimbra/bin/zmlogger line 162, <> line 995.
DBD::mysql::st execute failed: MySQL server has gone away at /opt/zimbra/bin/zmlogger line 162, <> line 996.
DBD::mysql::st execute failed: MySQL server has gone away at /opt/zimbra/bin/zmlogger line 162, <> line 997.
DBD::mysql::st execute failed: MySQL server has gone away at /opt/zimbra/bin/zmlogger line 162, <> line 998.
DBD::mysql::st execute failed: MySQL server has gone away at /opt/zimbra/bin/zmlogger line 162, <> line 999.
DBD::mysql::st execute failed: MySQL server has gone away at /opt/zimbra/bin/zmlogger line 162, <> line 1000.
DBD::mysql::st execute failed: MySQL server has gone away at /opt/zimbra/bin/zmlogger line 162, <> line 1001.
DBD::mysql::st execute failed: MySQL server has gone away at /opt/zimbra/bin/zmlogger line 162, <> line 1002.


Swatch appears to be running now.

zmloggerctl status is much happier:

[zimbra@mail ~]$ sh -x bin/zmloggerctl status
+ 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
+ R=0
+ '[' 0 -ne 0 ']'
+ exit 1
[zimbra@mail ~]$

If i could get just a *bit* more help or one more magic pointer like the last I think I'll be there. Thanks again for all the help. What a great community you have around a killer system.