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

musti19 · Aug 18, 2013

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 · Aug 19, 2013

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 · Aug 19, 2013

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 · Aug 19, 2013

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 · Aug 19, 2013

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 · Aug 19, 2013

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 · Aug 19, 2013

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 · Aug 19, 2013

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 · Aug 19, 2013

I am having the exact same issue...please post a fix here ASAP.

cPanelMichael · Aug 20, 2013

celiac101 said:
I am having the exact same issue...please post a fix here ASAP.

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.

celiac101 · Aug 20, 2013

cPanelMichael said:
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

cPanelMichael · Aug 20, 2013

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 · Aug 20, 2013

That command yielded: mysql-version=5.1

cPanelMichael said:
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 · Aug 20, 2013

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 · Aug 20, 2013

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 · Aug 20, 2013

Yes, update the value in /var/cpanel/cpanel.config and then try updating cPanel again.

Thank you.

celiac101 · Aug 20, 2013

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 · Aug 20, 2013

It looks like that resolved the issue. Note that if you want to update cPanel, you must run:

/scripts/upcp

Thank you.

Thread starter	Similar threads	Forum	Replies	Date
G	CentOS 7 cPanel & WHM with Postgresql 13 (Error crontab update_db_cache)	Databases	7	Mar 4, 2021
S	SOLVED [CPANEL-33473] Mysql dump process privilege error after 5.7.31 update	Databases	10	Jul 13, 2020
G	SOLVED [CPANEL-31773] RoundCube DATABASE ERROR: CONNECTION FAILED after cPanel update to 86.0.8	Databases	4	Mar 4, 2020
A	I updated cpanel today. and phpmyadmin error	Databases	1	Feb 21, 2020
B	update_db_cache errors after update to cPanel 70	Databases	6	May 30, 2018

Search

Search

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

musti19

Well-Known Member

cPanelMichael

Administrator

musti19

Well-Known Member

cPanelMichael

Administrator

musti19

Well-Known Member

cPanelMichael

Administrator

musti19

Well-Known Member

cPanelMichael

Administrator

celiac101

Well-Known Member

cPanelMichael

Administrator

celiac101

Well-Known Member

cPanelMichael

Administrator

celiac101

Well-Known Member

cPanelMichael

Administrator

celiac101

Well-Known Member

cPanelMichael

Administrator

celiac101

Well-Known Member

cPanelMichael

Administrator