The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

MySQL Upgrade Fails

Discussion in 'Database Discussions' started by seizart, Dec 3, 2014.

  1. seizart

    seizart Active Member

    Joined:
    Feb 21, 2013
    Messages:
    40
    Likes Received:
    0
    Trophy Points:
    6
    cPanel Access Level:
    Root Administrator
    same issue here after an upgrade of mysql

    root@167.114.0.123's password:
    Last login: Wed Dec 3 16:16:41 2014 from 24.201.15.110
    CentOS release 6.4 (Final)
    Linux serveur.myserver.com 3.10.23-xxxx-std-ipv6-64 #1 SMP Tue Mar 18 14:48:24 CET 2014 x86_64 x86_64 x86_64 GNU/Linux

    server : 243225
    hostname : serveur.myserver.com
    eth0 IPv4 : 167.114.0.123
    eth0 IPv6 : 2607:5300:60:637b::/64

    Code:
    root@serveur [~]# /usr/local/cpanel/scripts/check_cpanel_rpms --fix
    root@serveur [~]# /scripts/update_local_rpm_versions --edit target_settings.MySQL55 uninstalled
    root@serveur [~]# /scripts/check_cpanel_rpms --fix
    [20141203.182158]    
    [20141203.182158]   The following RPMs are unneeded on your system and should be uninstalled:
    [20141203.182158]   MySQL55-client-5.5.40-1.cp1136
    [20141203.182158]   MySQL55-devel-5.5.40-1.cp1136
    [20141203.182158]   MySQL55-server-5.5.40-1.cp1136
    [20141203.182158]   MySQL55-shared-5.5.40-1.cp1136
    [20141203.182158]   MySQL55-test-5.5.40-1.cp1136
    [20141203.182158]   compat-MySQL50-shared-5.0.96-4.cp1136
    [20141203.182158]   compat-MySQL51-shared-5.1.73-4.cp1136
    [20141203.182203]   Removing 0 broken rpms: 
    [20141203.182203]   rpm: n'a aucun paquetage à désinstaller
    [20141203.182204]   No new RPMS needed for install
    [20141203.182205]   Uninstalling unneeded rpms: MySQL55-test MySQL55-server MySQL55-client compat-MySQL51-shared compat-MySQL50-shared MySQL55-shared MySQL55-devel
    root@serveur [~]# /scripts/update_local_rpm_versions --edit target_settings.MySQL55 installed
    root@serveur [~]# /scripts/check_cpanel_rpms --fix
    [20141203.182215]   
    [20141203.182215]   Problems were detected with cPanel-provided files which are RPM controlled.
    [20141203.182215]   If you did not make these changes intentionally, you can correct them by running:
    [20141203.182215]   
    [20141203.182215]   > /usr/local/cpanel/scripts/check_cpanel_rpms --fix
    [20141203.182215]   The following RPMs are missing from your system:
    [20141203.182215]   MySQL55-client-5.5.40-1.cp1136
    [20141203.182215]   MySQL55-devel-5.5.40-1.cp1136
    [20141203.182215]   MySQL55-server-5.5.40-1.cp1136
    [20141203.182215]   MySQL55-shared-5.5.40-1.cp1136
    [20141203.182215]   MySQL55-test-5.5.40-1.cp1136
    [20141203.182215]   compat-MySQL50-shared-5.0.96-4.cp1136
    [20141203.182215]   compat-MySQL51-shared-5.1.73-4.cp1136
    [20141203.182221]   Removing 0 broken rpms: 
    [20141203.182221]   rpm: n'a aucun paquetage à désinstaller
    [20141203.182222]   Downloading [url]http://httpupdate.cpanel.net/RPM/11.36/centos/6/x86_64/rpm.md5[/url]
    [20141203.182222]   Downloading [url]http://httpupdate.cpanel.net/RPM/11.36/centos/6/x86_64/MySQL55-shared-5.5.40-1.cp1136.x86_64.rpm[/url]
    [20141203.182222]   Downloading [url]http://httpupdate.cpanel.net/RPM/11.36/centos/6/x86_64/MySQL55-server-5.5.40-1.cp1136.x86_64.rpm[/url]
    [20141203.182223]   Downloading [url]http://httpupdate.cpanel.net/RPM/11.36/centos/6/x86_64/compat-MySQL50-shared-5.0.96-4.cp1136.x86_64.rpm[/url]
    [20141203.182223]   Downloading [url]http://httpupdate.cpanel.net/RPM/11.36/centos/6/x86_64/MySQL55-test-5.5.40-1.cp1136.x86_64.rpm[/url]
    [20141203.182224]   Downloading [url]http://httpupdate.cpanel.net/RPM/11.36/centos/6/x86_64/MySQL55-devel-5.5.40-1.cp1136.x86_64.rpm[/url]
    [20141203.182224]   Downloading [url]http://httpupdate.cpanel.net/RPM/11.36/centos/6/x86_64/compat-MySQL51-shared-5.1.73-4.cp1136.x86_64.rpm[/url]
    [20141203.182225]   Downloading [url]http://httpupdate.cpanel.net/RPM/11.36/centos/6/x86_64/MySQL55-client-5.5.40-1.cp1136.x86_64.rpm[/url]
    [20141203.182226]   Hooks system enabled
    [20141203.182226]   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
    [20141203.182226]   All required 'pre' hooks have been run
    [20141203.182226]   No RPMS need to be uninstalled
    [20141203.182226]   Installing new rpms: MySQL55-shared-5.5.40-1.cp1136.x86_64.rpm MySQL55-server-5.5.40-1.cp1136.x86_64.rpm compat-MySQL50-shared-5.0.96-4.cp1136.x86_64.rpm MySQL55-test-5.5.40-1.cp1136.x86_64.rpm MySQL55-devel-5.5.40-1.cp1136.x86_64.rpm compat-MySQL51-shared-5.1.73-4.cp1136.x86_64.rpm MySQL55-client-5.5.40-1.cp1136.x86_64.rpm
    [20141203.182226]   Préparation des paquetages pour l'installation...
    [20141203.182226]   MySQL55-client-5.5.40-1.cp1136
    [20141203.182227]   MySQL55-server-5.5.40-1.cp1136
    [20141203.182229]   Upgrading
    [20141203.182229]   ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
    [20141203.182239]   Looking for 'mysql' as: /usr/bin/mysql
    [20141203.182239]   Looking for 'mysqlcheck' as: /usr/bin/mysqlcheck
    [20141203.182239]   FATAL ERROR: Upgrade failed
    [20141203.182240]   /usr/bin/mysqladmin: connect to server at 'localhost' failed
    [20141203.182240]   error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)'
    [20141203.182240]   Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists!
    [20141203.182240]   Unable to reset root MySQL password. at /usr/local/cpanel/scripts/securemysql line 151.
    [20141203.182241]   Starting MySQL. ERROR! The server quit without updating PID file (/var/lib/mysql/serveur.myserver.com.pid).
    [20141203.182246]   MySQL55-test-5.5.40-1.cp1136
    [20141203.182248]   compat-MySQL51-shared-5.1.73-4.cp1136
    [20141203.182248]   MySQL55-devel-5.5.40-1.cp1136
    [20141203.182249]   compat-MySQL50-shared-5.0.96-4.cp1136
    [20141203.182249]   MySQL55-shared-5.5.40-1.cp1136
    [20141203.182250] E The following possible errors were detected while installing RPMs:
    [20141203.182250] E 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)'
    [20141203.182250]   The Administrator will be notified to review this output when this script completes
    [20141203.182250]   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
    [20141203.182250]   All required 'post' hooks have been run
    root@serveur [~]#
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,723
    Likes Received:
    660
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Hello :)

    Could you open a support ticket using the link in my signature so we can take a closer look? You can post the ticket number here so we can update this thread with the outcome.

    Thank you.
     
Loading...

Share This Page