mysql not running

[kaloxy]

Hi

I am getting the following error in my /opt/zimbra/mysql/var/<hostname>.err
100124 17:53:11 mysqld started
100124 17:53:11 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: 'create'.
InnoDB: Cannot continue operation.
100124 17:53:11 mysqld ended

I have the following in my host file

# Do not remove the following line, or various programs
# that require network functionality will fail.
172.16.30.4 <FQDN.co.zm> mail
127.0.0. localhost.localdomain localhost
::1 localhost6.localdomain6 localhost6

[zimbra@mail ~]$ zmcontrol -v
Release 6.0.3_GA_1915.RHEL5_20091118110117 CentOS5 FOSS edition.

[zimbra@mail ~]$ zmcontrol status
Host FQDN
antispam Running
antivirus Running
ldap Running
logger Running
mailbox Stopped
mysql.server is not running.
mta Running
snmp Running
spell Running
stats Stopped


Before the server was running just fine. pls help

[phoenix]

As this was previously running I guess the Installation forum isn't the correct one, I'll move it for you. Did you search the forums for any similar problems and if so, what did you try to fix the problem?

Originally Posted by kaloxy

I am getting the following error in my /opt/zimbra/mysql/var/<hostname>.err
100124 17:53:11 mysqld started
100124 17:53:11 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: 'create'.
InnoDB: Cannot continue operation.
100124 17:53:11 mysqld ended

Have you tried shutting down Zimbra (and killing any remaining processes, if there are any) and running zmfixperms (as root)?

/opt/zimbra/libexec/zmfixperms -extended

Originally Posted by kaloxy

I have the following in my host file

# Do not remove the following line, or various programs
# that require network functionality will fail.
172.16.30.4 <FQDN.co.zm> mail
127.0.0. localhost.localdomain localhost
::1 localhost6.localdomain6 localhost6

Well, for a start you hosts file is incorrect. Check the Quick Start Installation Guide for details of what you should have in there. Do you also have valid DNS A & MX records pointing to this server? Is it on the internet or is it behind a Firewall and/or a NAT router? I assume that the loopback IP address is a typing error?

Originally Posted by kaloxy

[zimbra@mail ~]$ zmcontrol -v
Release 6.0.3_GA_1915.RHEL5_20091118110117 CentOS5 FOSS edition.

You should put that information in your forum profile.