[SOLVED] mysql.server not running

[jholder]

Originally Posted by king0770

The mysql password for the zimbra acct is zimbra

Did you set that password, or did Zimbra? If you did, how?

Does
su - zimbra
zmlocalconfig -s | grep mysql

reveal that zimbra is the password?

[king0770]

Not sure what you mean by VPS...

Here's what I have in /etc/hosts

127.0.0.1 localhost.localdomain localhost
192.168.1.14 green.somedomain.com green

zimbra@green:~$ host localhost
localhost has address 127.0.0.1

zimbra@green:~$ host green.somedomain.com
green.somedomain.com has address 67.xx.xx.xx (public IP)

[king0770]

I did change the mysql password, but from reading some of the posts in the forums, the password should be zimbra (at least that's how I understood it).

To change the mysql password I followed this link:
Resetting LDAP & MySQL Passwords - ZimbraWiki

[jholder]

Originally Posted by king0770

I did change the mysql password, but from reading some of the posts in the forums, the password should be zimbra (at least that's how I understood it).

To change the mysql password I followed this link:
Resetting LDAP & MySQL Passwords - ZimbraWiki

tisk tisk tisk

Zimbra sets a random password upon installation.

To make things easy, you can just change the zimbra password to what ever is in zmlocalconfig -s | grep mysql

It's easier that way.

[king0770]

Are these encrypted?

mysql_logger_root_password = gZ1U9X6bu4zWhQ4tZ28SpfCAXiz64s
mysql_root_password = 1D59582639A5459A529E556F6090E662384422B9
zimbra_logger_mysql_password = UebCOQVlt9wAi_g8HEKXEYs5Yb2pb4S
zimbra_mysql_password = OHKbPvH1HlNFwEVoLW.ummqd

[jholder]

Yea-
Just wipe and reinstall. It'll be easier that way.

./install.sh -u

./install.sh

[king0770]

So is the root of my problem, mysql passwords?

Thanks again for you quick responses!!!

[jholder]

Originally Posted by king0770

So is the root of my problem, mysql passwords?

Thanks again for you quick responses!!!

Sure.

Well, we hope that's your problem. It really depends on whether or not your changed the mysql password voluntarily.

If you changed it because it wasn't working before, then we're probably running around in circles.

[king0770]

Hmmm....I...see...a...reinstall in my future.

Hey for the great support! Take care!!

[jholder]

Sure-
I'm going to mark this thread as solved. If you have issues again, please post a new thread, or let one of the mods know, and we'll reopen this thread.

Best of Luck,
john