[CentOS] mysql won't start

Tue Oct 31 18:02:30 UTC 2006
David Mackintosh <David.Mackintosh at xdroop.com>

On Tue, Oct 31, 2006 at 11:48:31AM -0600, Aleksandar Milivojevic wrote:

> >This sounds like you have both the i386 package and the x86_64 package
> >installed.
> 
> For mysql package, that is perfectly OK.  mysql.i386 has 32-bit libs,  
> mysql.x86_64 has 64-bit libs.
> 
> /var/lib/mysql isn't part of mysql package.  It's part of mysql-server  
> package.  Therefore, uninstalling mysql package isn't likely to fix  
> anything.  However, if David still wants to do it, the right option to  
> use is --allmatches (as documented in rpm man page).

I got the RPMs uninstalled by specifying the full RPM spec, and using --nodeps:

# rpm -e --nodeps mysql-4.1.20-1.RHEL4.1.x86_64 mysql-4.1.20-1.RHEL4.1.i386
# rpm -e mysql-server-4.1.20-1.RHEL4.1.x86_64
# rpm -ivh mysql-server-4.1.20-1.RHEL4.1.x86_64.rpm mysql-4.1.20-1.RHEL4.1.x86_64.rpm

> Now, before doing anything drastic.  David, do you have SELinux  
> running on the box?  If so, is there anything logged in  
> /var/log/messages when you attempt to start MySQL?  Also, it'd be  
> interesting to see output of "ls -lZd / /var /var/lib /var/lib/mysql".

According to the /etc/selinux/config file, selinux is disabled.  This is confirmed
by getenforce.

/var/log/messages shows little of interest:

Oct 31 12:45:40 urquell2 mysqld: Initializing MySQL database:  succeeded
Oct 31 12:46:11 urquell2 mysqld: Starting MySQL:  failed

And the Z switch is obviously for selinux, so I'm not sure how interesting this
is, but:

[root at urquell2 ~]# ls -ld / /var /var/lib /var/lib/mysql
drwxrwx---  32 cvs     500 4096 Oct 30 16:40 /
drwxr-xr-x  25 root  root  4096 Oct 13 06:57 /var
drwxr-xr-x  30 root  root  4096 Oct 31 13:00 /var/lib
drwxr-xr-x   4 mysql mysql 4096 Oct 31 13:00 /var/lib/mysql

> 
> -- 
> NOTICE: If you are not intended recipient, you are hereby notified
> that by reading this message you agreed not to disturb frogs during
> mating season.  For more info, visit http://www.8-P.ca/
> 
> _______________________________________________
> CentOS mailing list
> CentOS at centos.org
> http://lists.centos.org/mailman/listinfo/centos
-- 
 /\oo/\
/ /()\ \ David Mackintosh | Public Key: 
         dave at xdroop.com  | http://www.xdroop.com/dave/gpg.html
         $ gpg --recv-keys --keyserver subkeys.pgp.net 4C032504
         Mystery attachment?  http://wiki.xdroop.com/space/GPG
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: not available
URL: <http://lists.centos.org/pipermail/centos/attachments/20061031/a8c0819a/attachment-0005.sig>