cPanel Update error , Reason MySQL 5.1 conflicts 5.5 howto solve?

musti19

Well-Known Member
Jan 20, 2013
111
1
18
cPanel Access Level
Root Administrator
Hello,
my cPanel system cant update to 11.38.2.2 from 11.38.1(15),
because i get the error:
Code:
[20130818.214312]   MySQL51-client-5.1.70-1.cp1136.x86_64.rpm already downloaded
[20130818.214313]   MySQL51-devel-5.1.70-1.cp1136.x86_64.rpm already downloaded
[20130818.214313]   MySQL51-shared-5.1.70-1.cp1136.x86_64.rpm already downloaded
[20130818.214313]   MySQL51-test-5.1.70-1.cp1136.x86_64.rpm already downloaded
[20130818.214313]   MySQL51-server-5.1.70-1.cp1136.x86_64.rpm already downloaded
[20130818.214313]   All files Staged
[20130818.214313]   Testing if the newly downloaded RPMS can be installed without conflict
[20130818.214313]   Testing RPM transaction
[20130818.214314]       file /usr/bin/mysql from install of MySQL51-client-5.1.70-1.cp1136.x86_64 conflicts with file from package MySQL55-client-5.5.32-1.cp1136.x86_64
[20130818.214314]       file /usr/bin/mysql_waitpid from install of MySQL51-client-5.1.70-1.cp1136.x86_64 conflicts with file from package MySQL55-client-5.5.32-1.cp1136.x86_64
[20130818.214314]       file /usr/bin/mysqlaccess from install of MySQL51-client-5.1.70-1.cp1136.x86_64 conflicts with file from package MySQL55-client-5.5.32-1.cp1136.x86_64
[20130818.214314]       file /usr/bin/mysqladmin from install of MySQL51-client-5.1.70-1.cp1136.x86_64 conflicts with file from package MySQL55-client-5.5.32-1.cp1136.x86_64
[20130818.214314]       file /usr/bin/mysqlbinlog from install of MySQL51-client-5.1.70-1.cp1136.x86_64 conflicts with file from package MySQL55-client-5.5.32-1.cp1136.x86_64
[20130818.214314]       file /usr/bin/mysqlcheck from install of MySQL51-client-5.1.70-1.cp1136.x86_64 conflicts with file from package MySQL55-client-5.5.32-1.cp1136.x86_64
[20130818.214314]       file /usr/bin/mysqldump from install of MySQL51-client-5.1.70-1.cp1136.x86_64 conflicts with file from package MySQL55-client-5.5.32-1.cp1136.x86_64
[20130818.214314]       file /usr/bin/mysqlimport from install of MySQL51-client-5.1.70-1.cp1136.x86_64 conflicts with file from package MySQL55-client-5.5.32-1.cp1136.x86_64
[20130818.214314]       file /usr/bin/mysqlshow from install of MySQL51-client-5.1.70-1.cp1136.x86_64 conflicts with file from package MySQL55-client-5.5.32-1.cp1136.x86_64
[20130818.214314]       file /usr/bin/mysqlslap from install of MySQL51-client-5.1.70-1.cp1136.x86_64 conflicts with file from package MySQL55-client-5.5.32-1.cp1136.x86_64
how can i solve this?
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,913
2,201
363
Hello :)

Check to see which version of MySQL is installed on your system:

Code:
mysql -V
rpm -qa|grep MySQL
It looks like you may have MySQL 5.1 and MySQL 5.5 RPMs installed. Have you manually upgraded MySQL or modified it for third-party installations? Assuming that MySQL 5.1 should not be installed, you can run the following command:

Code:
/scripts/update_local_rpm_versions --edit target_settings.MySQL51 uninstalled
Then, run:

Code:
/usr/local/cpanel/scripts/check_cpanel_rpms
Thank you.
 

musti19

Well-Known Member
Jan 20, 2013
111
1
18
cPanel Access Level
Root Administrator
rpm -qa|grep MySQL:
Code:
MySQL55-shared-5.5.32-1.cp1136.x86_64
MySQL55-client-5.5.32-1.cp1136.x86_64
cpanel-perl-514-MySQL-Diff-0.43-1.cp1136.x86_64
MySQL55-server-5.5.32-1.cp1136.x86_64
MySQL55-devel-5.5.32-1.cp1136.x86_64
MySQL55-test-5.5.32-1.cp1136.x86_64
No i have not installed mysql manually.

After the command:
Code:
/scripts/update_local_rpm_versions --edit target_settings.MySQL51 uninstalled
and
Code:
/usr/local/cpanel/scripts/check_cpanel_rpms
get this output:
Code:
[20130819.144406]   The following RPMs are unneeded on your system and should be                                   uninstalled:
[20130819.144406]   MySQL55-client.5.5.32-1.cp1136
[20130819.144406]   MySQL55-devel.5.5.32-1.cp1136
[20130819.144406]   MySQL55-server.5.5.32-1.cp1136
[20130819.144406]   MySQL55-shared.5.5.32-1.cp1136
[20130819.144406]   MySQL55-test.5.5.32-1.cp1136
Does it mean, to uninstall running mysql 5.5 ?
I stopped the command via CTRL+C fastly.
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,913
2,201
363
Please post the output of the following commands:

Code:
mysql -V
Also, did you upgrade to MySQL version 5.5 in the past? Did you use the "WHM Home » Software » MySQL Upgrade" interface? If so, this command will ensure the RPM check script detects it as installed:

Code:
/scripts/update_local_rpm_versions --edit target_settings.MySQL55 installed
Thank you.
 

musti19

Well-Known Member
Jan 20, 2013
111
1
18
cPanel Access Level
Root Administrator
mysql -V
Code:
mysql  Ver 14.14 Distrib 5.5.32, for Linux (x86_64) using readline 5.1
No, I installed cPanel 10 days ago on Centos 6.4 and have not upgraded it.
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,913
2,201
363
Please run this command:

Code:
/scripts/update_local_rpm_versions --edit target_settings.MySQL55 installed
Then run:

Code:
/usr/local/cpanel/scripts/check_cpanel_rpms
Also, have you upgraded to cPanel version 11.38 yet, or are you still using cPanel version 11.36?

Thank you.
 

musti19

Well-Known Member
Jan 20, 2013
111
1
18
cPanel Access Level
Root Administrator
actually im using 11.38.1 (build 15) and tried to update to 11.38.2.2.
Because of this problem,it was not possible.
I entered the commands, i get this output:


Code:
[20130819.171613]   Problems were detected with cPanel-provided files which are RPM controlled.
[20130819.171613]   If you did not make these changes intentionally, you can correct them by running:

[20130819.171613]   > /usr/local/cpanel/scripts/check_cpanel_rpms --fix
[20130819.171613]   The following RPMs are missing from your system:
[20130819.171613]   MySQL51-client.5.1.70-1.cp1136
[20130819.171613]   MySQL51-devel.5.1.70-1.cp1136
[20130819.171613]   MySQL51-server.5.1.70-1.cp1136
[20130819.171613]   MySQL51-shared.5.1.70-1.cp1136
[20130819.171613]   MySQL51-test.5.1.70-1.cp1136
But my system have already mysql 5.5 and dont need 5.1, this command want to install 5.1?
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,913
2,201
363
Could you open a support ticket so we can take a closer look? You can submit a ticket via:

Submit A Ticket

Please post the ticket number here so we can update this thread with the outcome.

Thank you.
 

celiac101

Well-Known Member
Dec 19, 2012
96
1
58
cPanel Access Level
Website Owner
Please open a support ticket and provide us with the ticket number if the previous solutions listed here have not resolved the issue.

Thank you.
None of the fixes posted here work, any other ideas besides opening a ticket? Here is part of the log:


An error was detected which prevented updatenow from completing normally.
Please review the enclosed log for further details

Code:
[20130819.230643]   Testing if the newly downloaded RPMS can be installed without conflict
[20130819.230643]   Testing RPM transaction
[20130819.230644]       file /usr/bin/mysql from install of MySQL51-client-5.1.70-1.cp1136.x86_64 conflicts with file from package MySQL55-client-5.5.32-1.cp1136.x86_64
[20130819.230644]       file /usr/bin/mysql_waitpid from install of MySQL51-client-5.1.70-1.cp1136.x86_64 conflicts with file from package MySQL55-client-5.5.32-1.cp1136.x86_64
[20130819.230644]       file /usr/bin/mysqlaccess from install of MySQL51-client-5.1.70-1.cp1136.x86_64 conflicts with file from package MySQL55-client-5.5.32-1.cp1136.x86_64
[20130819.230644]       file /usr/bin/mysqladmin from install of MySQL51-client-5.1.70-1.cp1136.x86_64 conflicts with file from package MySQL55-client-5.5.32-1.cp1136.x86_64
 
Last edited by a moderator:

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,913
2,201
363
You can check to make sure the version of MySQL you have installed is configured in the /var/cpanel/cpanel.config file. EX:

Code:
grep -i mysql-version /var/cpanel/cpanel.config
Otherwise, opening a ticket is the best option because it allows us to access your system directly to investigate.

Thank you.
 

celiac101

Well-Known Member
Dec 19, 2012
96
1
58
cPanel Access Level
Website Owner
That command yielded: mysql-version=5.1


You can check to make sure the version of MySQL you have installed is configured in the /var/cpanel/cpanel.config file. EX:

Code:
grep -i mysql-version /var/cpanel/cpanel.config
Otherwise, opening a ticket is the best option because it allows us to access your system directly to investigate.

Thank you.
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,913
2,201
363
Edit the file using a text editor such as "vi" and change the value to:

mysql-version=5.5

Note that this assumes you already installed MySQL version 5.5 on the system.

Thank you.
 

celiac101

Well-Known Member
Dec 19, 2012
96
1
58
cPanel Access Level
Website Owner
Thank you, to be sure I ran:
# mysql -V
mysql Ver 14.14 Distrib 5.5.32, for Linux (x86_64) using readline 5.1

so I assume I need to do what you ask?
Scott
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,913
2,201
363
Yes, update the value in /var/cpanel/cpanel.config and then try updating cPanel again.

Thank you.
 

celiac101

Well-Known Member
Dec 19, 2012
96
1
58
cPanel Access Level
Website Owner
It appears this fixed the issue. After updating /var/cpanel/cpanel.config
mysql-version=5.1
to
mysql-version=5.5

I ran these three commands, which all seemed to complete without errors:
/scripts/update_local_rpm_versions --edit target_settings.MySQL55 installed
/usr/local/cpanel/scripts/check_cpanel_rpms
/usr/local/cpanel/scripts/check_cpanel_rpms --fix

However, I did not get an email notification from the system that cpanel updated, which I normally get (but again, I also didn't get a failure notice, which is what I got when I ran the above commands)
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,913
2,201
363
It looks like that resolved the issue. Note that if you want to update cPanel, you must run:

/scripts/upcp

Thank you.