Trouble in zimbra Mysql

[dmjumena]

Dear Expert,

how about such error :

[zimbra@svrmaila ~]$ /opt/zimbra/mysql/libexec/mysqld
080910 12:46:07 InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name ./ibdata1
InnoDB: File operation call: 'open'.
InnoDB: Cannot continue operation.

I don't know how to resolve this issue, I'm using redhat linux but I got the problem in mysql.server and file mysql.sock is missing, and error like this :

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

zmcontrol status said that mysql.server is not running

please help me, I need your advice
Thank's
Danni M Jumena

[ArcaneMagus]

Try running /opt/zimbra/libexec/zmfixperms as the root user while the Zimbra services are stopped.

the mysql.sock file is created when the mysql service starts so it is understandable that it would be missing.

[dmjumena]

yes, I have tried to running /opt/zimbra/libexec/zmfixperms such you said, but the problem still exist with same condition
[zimbra@svrmaila ~]$ /opt/zimbra/bin/mysql start
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/opt/zimbra/db/mysql.sock' (2)

but linux have two mysql, the first within feature of redhat itself and the second when installed zimbra, so what the fisrt mysql must be stop when we'll running the zimbra??

[ArcaneMagus]

What is the output of the following two commands?

ls -l /opt/zimbra/db/mysql*

ps aux | grep mysql

Here is my systems output of the ps aux command if it helps at all:

zimbra   20712  0.0  0.0   3956   640 ?        S    Aug29   0:00 /bin/sh /opt/zimbra/logger/mysql/bin/mysqld_safe --defaults-file=/opt/zimbra/conf/my.logger.cnf --external-locking --log-error=/opt/zimbra/log/logger_mysql_error.log --ledir=/opt/zimbra/logger/mysql/libexec
zimbra   20760  0.0  0.5 219272 23272 ?        Sl   Aug29  11:01 /opt/zimbra/logger/mysql/libexec/mysqld --defaults-file=/opt/zimbra/conf/my.logger.cnf --basedir=/opt/zimbra/logger/mysql --datadir=/opt/zimbra/logger/db/data --pid-file=/opt/zimbra/logger/db/mysql.pid --skip-external-locking --port=7307 --socket=/opt/zimbra/logger/db/mysql.sock --external-locking
zimbra   20908  0.0  0.0   3956   640 ?        S    Aug29   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   20979  0.0  4.5 1220940 183280 ?      Sl   Aug29   9:27 /opt/zimbra/mysql/libexec/mysqld --defaults-file=/opt/zimbra/conf/my.cnf --basedir=/opt/zimbra/mysql --datadir=/opt/zimbra/db/data --pid-file=/opt/zimbra/db/mysql.pid --skip-external-locking --port=7306 --socket=/opt/zimbra/db/mysql.sock --external-locking
zimbra   22868  0.0  0.1  24504  4904 ?        S    Aug29   0:52 /usr/bin/perl -w /opt/zimbra/libexec/zmstat-mysql

[dmjumena]

PHP Code:

output of the first command like this : ls -l /opt/zimbra/db/mysql*

ls: /opt/zimbra/db/mysql*: No such file or directory 


result of ps aux | grep mysql

PHP Code:


root     26786  0.0  0.0   3916   680 pts/5    R+   11:20   0:00 grep mysql 


what's wrong??yesterday I was installed redhat linux include mysql then install zimbra and result can't connect through socket /opt/zimbra/db/mysql.sock, but today I installed fedora linux without mysql then result such above? so which the problem?

[ArcaneMagus]

Ok that output means that you have no running mysql services (not even non-zimbra ones).

Did you change the OS on one server from red hat to Fedora and mysql still wont start, or is a different server now also having trouble starting mysql?