Thank you very much for the response liverpoolfcfan. I can't see much of anything suspicious in the DB. Here's what I see:
Code:
mysql> select * from user;
+-----------------------+--------+-------------------------------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+------------------+----------------+---------------------+--------------------+------------------+------------+--------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+----------------------+
| Host | User | Password | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv | Shutdown_priv | Process_priv | File_priv | Grant_priv | References_priv | Index_priv | Alter_priv | Show_db_priv | Super_priv | Create_tmp_table_priv | Lock_tables_priv | Execute_priv | Repl_slave_priv | Repl_client_priv | Create_view_priv | Show_view_priv | Create_routine_priv | Alter_routine_priv | Create_user_priv | Event_priv | Trigger_priv | ssl_type | ssl_cipher | x509_issuer | x509_subject | max_questions | max_updates | max_connections | max_user_connections |
+-----------------------+--------+-------------------------------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+------------------+----------------+---------------------+--------------------+------------------+------------+--------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+----------------------+
| localhost | root | xxxx | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | | | | | 0 | 0 | 0 | 0 |
| mail.xxxx.xxx | root | xxxx | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | | | | | 0 | 0 | 0 | 0 |
| 127.0.0.1 | root | xxxx | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | | | | | 0 | 0 | 0 | 0 |
| localhost | | | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | | | | | 0 | 0 | 0 | 0 |
| mail.xxxx.xxx | | | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | | | | | 0 | 0 | 0 | 0 |
| % | zimbra | xxxx | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | | | | | 0 | 0 | 0 | 0 |
| localhost | zimbra |xxxx | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | | | | | 0 | 0 | 0 | 0 |
| localhost.localdomain | zimbra | xxxx | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | | | | | 0 | 0 | 0 | 0 |
| localhost.localdomain | root | xxxx | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | | | | | 0 | 0 | 0 | 0 |
+-----------------------+--------+-------------------------------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+------------------+----------------+---------------------+--------------------+------------------+------------+--------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+----------------------+
9 rows in set (0.00 sec)
Moving on to the password stuff, I'm now a bit nervous. First, it looks like some passwords might not be set right, so to make sure, I set out (via your links ) to set them. Here's localconfig:
Code:
[zimbra@mail ~]$ zmlocalconfig -s | grep mysql | grep password
antispam_mysql_password =
antispam_mysql_root_password =
mysql_root_password = yyyyy
zimbra_logger_mysql_password =
zimbra_mysql_password = XXXXX
...and this is where I see other issues:
Code:
[zimbra@mail ~]$ ldap status
slapd running pid: 1563
[zimbra@mail ~]$ zmldappasswd -r XXXX
Updating local config and LDAP
TLS: SSL connect attempt failed with unknown errorerror:0407006A:rsa routines:RSA_padding_check_PKCS1_type_1:block type is not 01
[zimbra@mail ~]$ zmldappasswd YYYY
Updating local config and LDAP
TLS: SSL connect attempt failed with unknown errorerror:0407006A:rsa routines:RSA_padding_check_PKCS1_type_1:block type is not 01
[zimbra@mail ~]$ mysql.server status
mysql is running with pid 8255
[zimbra@mail ~]$ zmmypasswd --root QQQQQ
/opt/zimbra/bin/mysqladmin -u root --password=zimbra password QQQQQ
* Changed mysql root user password
* Changed mysql root user password root@localhost
[zimbra@mail ~]$ zmmypasswd ZZZZZZ
* Changed zimbra mysql user password
[zimbra@mail ~]$ logmysql.server status
-bash: logmysql.server: command not found
[zimbra@mail ~]$ zmloggerctl status
[zimbra@mail ~]$ ps ax | grep logger
2758 ? S 0:47 /usr/bin/perl /opt/zimbra/libexec/zmlogger
3002 ? S 0:00 zmlogger: zmrrdfetch: server
20109 pts/0 S+ 0:00 grep logger
[zimbra@mail ~]$ zmmylogpasswd
-bash: zmmylogpasswd: command not found
First of all, you can see the TLS/SSL problem. I tried Googling that and following this article, I recreated my certs, but ended up getting the same failure. Any ideas? I'm not an openssl guy.
Second is the logger stuff. zmcontrol shows it running, as does a ps, but I don't have the commands the web page references to set the password. Do you have those commands?
LinkBack URL
About LinkBacks
Java won't connect to mysql, but all services are up. Server's been down all day!
