Tomcat broken after upgrade to 4

[dotslashroot]

Our email server is still down. I have not yet been able to fix this. Any advice would be great.

[bobby]

the passwords are not encrypted, they're just long character strings. what happens when you run these commands:

su - zimbra
which mysql
mysql

this wiki page explains how to get the passwords realigned between the config settings and the mysql user db:
Resetting LDAP & MySQL Passwords

[dotslashroot]

This is what I got when running those commands:

[root@mail ~]# su - zimbra
[zimbra@mail ~]$ which mysql
~/bin/mysql
[zimbra@mail ~]$ mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 4437 to server version: 4.1.20-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>

I reset the root and zimbra password and tomcat still doesnt run. Do I need to reset everything on that link you sent? Thanks.

edit: I was going through the rest of that document to reset the passwords and when I get to the mysql command after setting the --skip-grant-tables \ option it errors out with this:

[zimbra@mail ~]$ which mysql
~/bin/mysql
[zimbra@mail ~]$ mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/opt/zimbra/db/mysql.sock' (2)
[zimbra@mail ~]$

I can't continue because I can't connect. Any ideas? Thanks!

[bobby]

go back to running without the --skip-grant-tables option and post the output of this:

su - zimbra
mysql mysql
select host, user, password from user;