Mysql does not start on RHEL 64

[cryptogram]

Mysqld fails to start on RHEL 64 (Linux 2.6.9-42.0.3.ELsmp SMP Mon Sep 25 17:24:31 EDT 2006 x86_64 x86_64 x86_64 GNU/Linux) w/ zcs-NETWORK-4.5.0_GA_612.RHEL4_64

From zmsetup.log

* Creating required directories
* Generating mysql config /opt/zimbra/conf/my.cnf
* Creating database in /opt/zimbra/db/data
* Starting mysql server
* Failed to connect to mysql...retrying
* Failed to connect to mysql...retrying
* Failed to connect to mysql...giving up!
Done

Initializing logger sql database...
*** Running as zimbra user: /opt/zimbra/libexec/zmloggerinit

* Creating required directories
* Creating database in /opt/zimbra/logger/db/data
* Starting logger_mysql server
* Loading schema /opt/zimbra/db/loggerdb.sql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/opt/zimbra/logger/db/mysql.sock' (2)
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/opt/zimbra/logger/db/mysql.sock' (2)
* Setting random password for mysql root user in zimbra local config
* Setting random password for mysql zimbra user in zimbra local config
* Changing mysql root user password
^G/opt/zimbra/logger/mysql/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/opt/zimbra/logger/db/mysql.sock' (2)'
Check that mysqld is running and that the socket: '/opt/zimbra/logger/db/mysql.sock' exists!

Any help would be greatly appreciated.

[anand]

Was this an upgrade from 4.0.x or is this a new install?

[cryptogram]

Originally Posted by anand

Was this an upgrade from 4.0.x or is this a new install?

This was a complete fresh install on a freshly installed RHEL machine.

Thanks.

[anand]

is selinux turned on?

[cryptogram]

Originally Posted by anand

is selinux turned on?

Yes it is.

SELinux status: enabled
SELinuxfs mount: /selinux
Current mode: permissive
Mode from config file: permissive
Policy version: 18
Policy from config file:targeted

Policy booleans:
allow_syslog_to_console inactive
allow_ypbind inactive
dhcpd_disable_trans inactive
httpd_builtin_scripting active
httpd_disable_trans inactive
httpd_enable_cgi active
httpd_enable_homedirs active
httpd_ssi_exec active
httpd_tty_comm inactive
httpd_unified active
mysqld_disable_trans inactive
named_disable_trans inactive
named_write_master_zonesinactive
nscd_disable_trans inactive
ntpd_disable_trans inactive
pegasus_disable_trans inactive
portmap_disable_trans inactive
postgresql_disable_transinactive
snmpd_disable_trans inactive
squid_disable_trans inactive
syslogd_disable_trans inactive
use_nfs_home_dirs inactive
use_samba_home_dirs inactive
use_syslogng inactive
winbind_disable_trans inactive
ypbind_disable_trans inactive

[anand]

pls try with selinux off.

Is there anything in the logs directory from the logger mysql (we run two instance of mysql - one for mail and one for syslog data and in your case the logging one is the one that can not be initialized).

After that if you still have the same problem, (and since this is a new system, and you can afford to trash it) try running bash -x /opt/zimbra/libexec/zmloggerinit and see what the hell it is doing.

[cryptogram]

Originally Posted by anand

pls try with selinux off.

Is there anything in the logs directory from the logger mysql (we run two instance of mysql - one for mail and one for syslog data and in your case the logging one is the one that can not be initialized).

After that if you still have the same problem, (and since this is a new system, and you can afford to trash it) try running bash -x /opt/zimbra/libexec/zmloggerinit and see what the hell it is doing.

I will disable SELinux and see what happens and provide an update as soon as the system comes up again.

[cryptogram]

[root@zimbra ~]# sestatus
SELinux status: disabled

Disabled SELinux, but it is still not working. However, I am getting a different error message.

I am going to reinstall zcs from scratch. Is there anything I need to do before running the install.sh script to ensure that I am doing a clean reinstall of zcs?

Thanks.

[cryptogram]

[root@zimbra log]$ cat zmmyinit.log

Installing all prepared tables
mysqld got signal 11;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
We will try our best to scrape up some info that will hopefully help diagnose
the problem, but since we have already crashed, something is definitely wrong
and this may fail.

key_buffer_size=8388600
read_buffer_size=1044480
max_used_connections=0
max_connections=54
threads_connected=1
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 118567 K
bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

thd=(nil)
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
frame pointer is NULL, did you compile with
-fomit-frame-pointer? Aborting backtrace!
The manual page at http://www.mysql.com/doc/en/Crashing.html contains
information that should help you find out what is causing the crash.
Installation of system tables failed!

Examine the logs in /opt/zimbra/db/data for more information.
You can also try to start the mysqld daemon with:
/opt/zimbra/mysql/libexec/mysqld --skip-grant &
You can use the command line tool
/opt/zimbra/mysql/bin/mysql to connect to the mysql
database and look at the grant tables:

shell> /opt/zimbra/mysql/bin/mysql -u root mysql
mysql> show tables

Try 'mysqld --help' if you have problems with paths. Using --log
gives you a log in /opt/zimbra/db/data that may be helpful.

The latest information about MySQL is available on the web at
http://www.mysql.com
Please consult the MySQL manual section: 'Problems running mysql_install_db',
and the manual section that describes problems on your OS.
Another information source is the MySQL email archive.
Please check all of the above before mailing us!
And if you do mail us, you MUST use the /opt/zimbra/mysql-standard-5.0.26-pc-linux-gnu-i686-glibc23/bin/mysqlbug script!
Starting mysqld daemon with databases from /opt/zimbra/db/data
STOPPING server from pid file /opt/zimbra/db/mysql.pid
070118 12:34:26 mysqld ended

[phoenix]

If you want to do a clean install then './install.sh -u' will remove all of the /opt/zimbra directory. You should make sure that SElinux is disabled and not in warn mode and any firewall is also disabled. You can then run the install again.