Skip to main content

Upgraded mysql via WHM after shell upgrade failed - mysql service won't start

yoHuge
On CentOS 5.9 i686 running WHM 11.38, I was attempting to upgrade mysql from 5.0 to 5.5 using shell instead of WHM because I was told it was safer that way as it would keep the old mysql lib intact and my sites would have no downtime. HA. The shell upgrade failed. So I attempted to upgrade using WHM mysql upgrade and that failed. Then I did an easyapache upgrade and then another mysql upgrade via WHM which finally showed it was a success. But then the mysql service wouldn't start and it produced the error message: "Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)"
The tail end of the MySQL error log shows this: mysqld started 130312 4:13:16 InnoDB: Started; log sequence number 0 2350314 130312 4:13:16 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.0.96-community' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Edition (GPL) 130923 21:06:50 [Note] /usr/sbin/mysqld: Normal shutdown 130923 21:06:50 InnoDB: Starting shutdown... 130923 21:06:50 InnoDB: Shutdown completed; log sequence number 0 2794677 130923 21:06:50 [Note] /usr/sbin/mysqld: Shutdown complete 130923 21:06:50 mysqld ended
In shell I got this: # rpm -qa|grep -i mysql MySQL55-shared-5.5.32-1.cp1136 MySQL55-devel-5.5.32-1.cp1136 cpanel-mysql-libs-5.0.96-1.cp1136 cpanel-mysql-5.0.96-1.cp1136 cpanel-perl-514-MySQL-Diff-0.43-1.cp1136 MySQL55-client-5.5.32-1.cp1136 MySQL55-test-5.5.32-1.cp1136 cpanel-perl-514-DBD-mysql-4.021-1.cp1136
The output list shows that i'm missing the current version of mysql 5.5 server. I tried re-upgrading mysql from within WHM and it said success but the mysql won't start and it looks like it is not available. So it seems the old version of mysql 5.0 didn't uninstall correctly and it is conflicting with a partial install of the new mysql 5.5 version. ??? So my question is, how do I completely uninstall the old mysql 5.0 from shell? Do I have to uninstall both mysql versions using rpm from shell to completely remove them, exit shell, and then use WHM to install mysql 5.5 again? I can't do a downgrade back to mysql 5.0 via WHM. Any help would be great! thanks.

Comments

3 comments

Date Votes
  • cPanelKenneth
    The 5.0 RPMs in your output, which contain cpanel in the RPM name, can be ignored. Those are used internally by cPanel & WHM, not by Apache. What is the output of /scripts/check_cpanel_rpms --fix?
    0
  • yoHuge
    Ok, I had just done a remove package command from shell before I got the forum reply: # rpm -e cpanel-mysql-5.0.96-1.cp1136
    because I thought that was conflicting, but it didn't change anything. The results of entering the command to check cpanel rpms is: root@huge [/]# /scripts/check_cpanel_rpms [20130924.154603] [20130924.154603] Problems were detected with cPanel-provided files which are RPM controlled. [20130924.154603] If you did not make these changes intentionally, you can correct them by running: [20130924.154603] [20130924.154603] > /usr/local/cpanel/scripts/check_cpanel_rpms --fix [20130924.154603] The following RPMs are missing from your system: [20130924.154603] MySQL55-server.5.5.32-1.cp1136 [20130924.154603] cpanel-mysql.5.0.96-1.cp1136 Do you want to repair these RPMs?(y/n): y [20130924.154709] Removing 0 broken rpms: [20130924.154709] rpm: no packages given for erase [20130924.154717] Downloading http://httpupdate.cpanel.net/RPM/11.36/centos/5/i386/rpm.md5 [20130924.154718] Downloading http://httpupdate.cpanel.net/RPM/11.36/centos/5/i386/cpanel-mysql-5.0.96-1.cp1136.i386.rpm [20130924.154719] MySQL55-server-5.5.32-1.cp1136.i386.rpm already downloaded [20130924.154720] Hooks system enabled [20130924.154720] Checking for and running RPM::Versions 'pre' hooks for any RPMs about to be installed warn [check_cpanel_rpms] program "/scripts/premysqlup" is not executable [20130924.154720] All required 'pre' hooks have been run [20130924.154722] No RPMS need to be uninstalled [20130924.154722] Installing new rpms: cpanel-mysql-5.0.96-1.cp1136.i386.rpm MySQL55-server-5.5.32-1.cp1136.i386.rpm [20130924.154722] Preparing packages for installation... [20130924.154724] cpanel-mysql-5.0.96-1.cp1136 [20130924.154724] You have more than one PID file: [20130924.154724] -rw-rw---- 1 mysql mysql 5 Sep 18 2009 /var/lib/mysql/huge.pid [20130924.154724] -rw-rw---- 1 mysql mysql 5 Mar 19 2009 /var/lib/mysql/mail.myservername.com.pid [20130924.154724] -rw-rw---- 1 mysql mysql 5 Mar 19 2009 /var/lib/mysql/web2.justhost.com.pid [20130924.154724] Please check which one (if any) corresponds to a running server [20130924.154724] and delete all others before repeating the MySQL upgrade. [20130924.154724] error: %pre(MySQL55-server-5.5.32-1.cp1136.i386) scriptlet failed, exit status 1 [20130924.154724] error: install: %pre scriptlet failed (2), skipping MySQL55-server-5.5.32-1.cp1136 [20130924.154724] W Error Code: 2 [20130924.154724] E The following possible errors were detected while installing RPMs: [20130924.154724] E %pre(MySQL55-server-5.5.32-1.cp1136.i386) scriptlet failed, exit status 1 install [20130924.154724] The Administrator will be notified to review this output when this script completes [20130924.154724] Checking for and running RPM::Versions 'post' hooks for any RPMs just installed warn [check_cpanel_rpms] program "/scripts/postmysqlinstall" is not executable warn [check_cpanel_rpms] program "/scripts/postmysqlup" is not executable [20130924.154724] All required 'post' hooks have been run
    What files do I have to remove before mysql will be repaired? The names 'huge' and 'myservername' are mine, but I have no idea who 'justhost' is or why they are in the results page.
    0
  • yoHuge
    It's working now .. removed the PID files, then ran 'check_cpanel_rpms' again. Then ran easyapache again after that and it all works. Thanks.
    0

Please sign in to leave a comment.

Didn't find what you were looking for?

New post