mysql.server is not running - ZCS 7 on Ubuntu 10.04

[jernej]

Hello,

I made a fresh install of Ubuntu server 10.04 (64bit) as a KVM virtual machine.
I installed only base system and needed libraries for zimbra.
Then I installed ZCS 7 and everything went smooth...
The problem is when I ckeck the zmcontrol staus I get:

mailbox Stopped
mysql.server is not running.

If I do ps au | grep msql i get this:

zimbra 1744 0.0 0.0 4112 668 ? S 10:00 0:00 /bin/sh /opt/zimbra/mysql/bin/mysqld_safe --defaults-file=/opt/zimbra/conf/my.cnf --external-locking --log-error=/opt/zimbra/log/mysql_error.log --ledir=/opt/zimbra/mysql/libexec
zimbra 1911 0.1 4.2 862184 87056 ? Sl 10:00 0:00 /opt/zimbra/mysql/libexec/mysqld --defaults-file=/opt/zimbra/conf/my.cnf --basedir=/opt/zimbra/mysql --datadir=/opt/zimbra/db/data --external-locking --log-error=/opt/zimbra/log/mysql_error.log --pid-file=/opt/zimbra/db/mysql.pid --socket=/opt/zimbra/db/mysql.sock --port=7306
root 3752 0.0 0.0 7628 988 pts/0 S+ 10:05 0:00 grep --color=auto mysql

I'm a bit lost.... Can please someone point me to the right direction? Many thanks!

Jernej

[phoenix]

Originally Posted by jernej

I'm a bit lost.... Can please someone point me to the right direction? Many thanks!

The information you've posted tells us nothing other than a service isn't running, look in the log files and see what errors are there when you try and start Zimbra.

[jernej]

Originally Posted by phoenix

The information you've posted tells us nothing other than a service isn't running, look in the log files and see what errors are there when you try and start Zimbra.

I have checked the log files and it seems that mysql is running under user zimbra. What i found in mailbox.log is a bunch of errors like:

Caused by: java.sql.SQLException: Access denied for user 'zimbra'@'localhost' (using password: YES)

Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientC onnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.

Caused by: java.net.ConnectException: Connection refused

I tried to connect manually to mysql zserver using zimbra user and zimbra password, but i get the
ERROR 1045 (28000): Access denied for user 'zimbra'@'localhost' (using password: YES)

I also tried to run "mysqld_safe --skip-grant-tables" to try to reset the password, but it doesn't play that way...

Any help would be appreciated. Thank you in advance!

Jernej

[kashifali]

try this
as [zimbra] shutdown zimbra " zmcontrol stop"
then as root run, chown -R zimbra:zimbra /opt/zimbra

then [as zimbra usera] start zimbra " zmcontrol start"

hope it helps
-kashif

[jernej]

Thank you Kashifali for your suggestion. I did what you said (and indeeed there were some folders inside /opz/zimbra/ that were owned by root:root and others by zimbra:zimbra) but unfortunately when I start zimbra (zmcontrol start) I still get the

mailbox Stopped
mysql.server is not running.

I think that mysql server is actually running, but there is something wrong with authentication. If I run:

zimbra@mailserver:~$ mysql -u root -p

and put in password "zimbra", I get

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

Walking in dark. Any suggestion or hint is appreciated!

Jernej