Problem reinstall mysql on Cpanel-dns-only

mahdy_sharifi

Well-Known Member
Feb 26, 2012
220
1
68
cPanel Access Level
Root Administrator
Hello :

I get following error during reinstall mysql on cpanel-dns
guide please

Code:
[email protected] [/scripts]# /scripts/check_cpanel_rpms --fix
[20150219.000418]
[20150219.000418]   Problems were detected with cPanel-provided files which are RPM controlled.
[20150219.000418]   If you did not make these changes intentionally, you can correct them by running:
[20150219.000418]
[20150219.000418]   > /usr/local/cpanel/scripts/check_cpanel_rpms --fix
[20150219.000418]   The following RPMs are missing from your system:
[20150219.000418]   MySQL55-server-5.5.40-1.cp1136
[20150219.000449]   Removing 0 broken rpms:
[20150219.000449]   rpm: no packages given for erase
[20150219.000450]   Downloading http://httpupdate.cpanel.net/RPM/11.36/centos/6/x86_64/rpm.md5
[20150219.000450]   MySQL55-server-5.5.40-1.cp1136.x86_64.rpm already downloaded
[20150219.000451]   Hooks system enabled
[20150219.000451]   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
[20150219.000451]   All required 'pre' hooks have been run
[20150219.000451]   No RPMS need to be uninstalled
[20150219.000451]   Installing new rpms: MySQL55-server-5.5.40-1.cp1136.x86_64.rpm
[20150219.000451]   Preparing packages for installation...
[20150219.000451]   Some previous upgrade was not finished:
[20150219.000451]   -rw-r--r--. 1 root root 507 Feb 18 23:49 /var/lib/mysql/RPM_UPGRADE_MARKER
[20150219.000451]   Please check its status, then do
[20150219.000451]       rm /var/lib/mysql/RPM_UPGRADE_MARKER
[20150219.000451]   before repeating the MySQL upgrade.
[20150219.000451]   error: %pre(MySQL55-server-5.5.40-1.cp1136.x86_64) scriptlet failed, exit status 1
[20150219.000451]   error:   install: %pre scriptlet failed (2), skipping MySQL55-server-5.5.40-1.cp1136
[20150219.000451] W Error Code: 1
[20150219.000451] E The following possible errors were detected while installing RPMs:
[20150219.000451] E %pre(MySQL55-server-5.5.40-1.cp1136.x86_64) scriptlet failed, exit status 1 install
[20150219.000451]   The Administrator will be notified to review this output when this script completes
[20150219.000451]   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
[20150219.000451]   All required 'post' hooks have been run
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,909
2,224
463
Hello :)

Check for multiple PID files for MySQL in the /var/lib/mysql directory. EX:

ls -al /var/lib/mysql|grep pid

Remove any duplicate/invalid PID files, and then run:

Code:
/scripts/check_cpanel_rpms
Thank you.
 

mahdy_sharifi

Well-Known Member
Feb 26, 2012
220
1
68
cPanel Access Level
Root Administrator
not help ...

Code:
[email protected] [/home/mysql]# /scripts/check_cpanel_rpms
[20150220.193733]
[20150220.193733]   Problems were detected with cPanel-provided files which are RPM controlled.
[20150220.193733]   If you did not make these changes intentionally, you can correct them by running:
[20150220.193733]
[20150220.193733]   > /usr/local/cpanel/scripts/check_cpanel_rpms --fix
[20150220.193733]   The following RPMs are missing from your system:
[20150220.193733]   MySQL55-server-5.5.40-1.cp1136
Do you want to repair these RPMs?(y/n):
y
[20150220.193827]   Removing 0 broken rpms:
[20150220.193827]   rpm: no packages given for erase
[20150220.193828]   Downloading http://httpupdate.cpanel.net/RPM/11.36/centos/6/x86_64/rpm.md5
[20150220.193829]   MySQL55-server-5.5.40-1.cp1136.x86_64.rpm already downloaded
[20150220.193830]   Hooks system enabled
[20150220.193830]   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
[20150220.193830]   All required 'pre' hooks have been run
[20150220.193830]   No RPMS need to be uninstalled
[20150220.193830]   Installing new rpms: MySQL55-server-5.5.40-1.cp1136.x86_64.rpm
[20150220.193830]   Preparing packages for installation...
[20150220.193830]   Some previous upgrade was not finished:
[20150220.193830]   -rw-r--r--. 1 root root 507 Feb 18 23:49 /var/lib/mysql/RPM_UPGRADE_MARKER
[20150220.193830]   Please check its status, then do
[20150220.193830]       rm /var/lib/mysql/RPM_UPGRADE_MARKER
[20150220.193830]   before repeating the MySQL upgrade.
[20150220.193830]   error: %pre(MySQL55-server-5.5.40-1.cp1136.x86_64) scriptlet failed, exit status 1
[20150220.193830]   error:   install: %pre scriptlet failed (2), skipping MySQL55-server-5.5.40-1.cp1136
[20150220.193830] W Error Code: 1
[20150220.193830] E The following possible errors were detected while installing RPMs:
[20150220.193830] E %pre(MySQL55-server-5.5.40-1.cp1136.x86_64) scriptlet failed, exit status 1 install
[20150220.193830]   The Administrator will be notified to review this output when this script completes
[20150220.193830]   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
[20150220.193830]   All required 'post' hooks have been run
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,909
2,224
463
Feel free to 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.