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 |