Failed to solve dependencies

[Noturns]

Last night the plesk auto updater ran an update. And i was wondering if others have had the same issue?

CentOS6, RHEL5 x64 Plesk 12 Unlimited

Detecting installed product components.
Gathering information about installed license key...
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* base: centos.mirror.triple-it.nl
* extras: centos.mirror.triple-it.nl
* updates: centos.mirror.triple-it.nl

PPB_12_0_18-dist | 951 B 00:00

PPB_12_0_18-thirdparty | 951 B 00:00

PSA_12_0_18-dist | 2.9 kB 00:00

PSA_12_0_18-thirdparty | 2.9 kB 00:00

SITEBUILDER_12_0_7-dist | 951 B 00:00

SITEBUILDER_12_0_7-thirdparty | 951 B 00:00
Exception: Failed to solve dependencies:
mysql-connector-odbc-5.1.5r1144-7.el6.x86_64 requires libmysqlclient_r.so.16(libmysqlclient_16)(64bit)
mariadb-server-10.0.11-2.el6.x86_64 requires libJudy.so.1()(64bit)
mariadb-10.0.11-2.el6.x86_64 requires libtcmalloc.so.4()(64bit)
mysql-connector-odbc-5.1.5r1144-7.el6.x86_64 requires libmysqlclient_r.so.16()(64bit)
mariadb-server-10.0.11-2.el6.x86_64 requires libtcmalloc.so.4()(64bit)
mariadb-server-10.0.11-2.el6.x86_64 requires libprotobuf-lite.so.6()(64bit)

ERROR: The Yum utility failed to install the required packages.
Attention! Your software might be inoperable.
Please, contact product technical support.

 

[IgorG]

Looks like that you have mix of mysql and mariadb packages on this server. Which DB server is used for Plesk psa database?
According to mariadb installation guide http://devblog.plesk.com/2013/08/mariadb-installation-guide/ all mysql related packages should be removed from server.

 

[Noturns]

Which DB server is used for Plesk psa database?

# rpm -qa mysql*
mysql-connector-odbc-5.1.5r1144-7.el6.x86_64
mysql-libs-5.1.73-3.el6_5.x86_64
mysql-5.1.73-3.el6_5.x86_64
mysql-server-5.1.73-3.el6_5.x86_64

 

[Noturns]

I discovered that in "Plesk Update and Upgrade Settings" the following option was switched to enabled: "Automatically install updates for third-party components (such as MySQL and PHPMyAdmin)"

Maybe that triggered a deployment of third-party mysql server, however i have not found anything in the logs just yet that could verify this for me

 

[Noturns]

Looks like that you have mix of mysql and mariadb packages on this server. Which DB server is used for Plesk psa database?
According to mariadb installation guide http://devblog.plesk.com/2013/08/mariadb-installation-guide/ all mysql related packages should be removed from server.

I'm following the mariadb tutorial, however i'm stuck at step 1 ...

Step 1| If you’re doing a drop-in replacement, backup your databases:

# mysqldump -uadmin -p`< /etc/psa/.psa.shadow ` \
--all-databases | gzip > /root/mysql.all.dump.sql.gz

And this returns:

-- Warning: Skipping the data of table mysql.event. Specify the --events option explicitly.

I have tried to remove whitespace. Is there a bug in my command?

 

[UFHH01]

Hi Noturns,

this is just a WARNING... nothing more. The db still gets dumped, but without the table "mysql.vent", which is a temporary table to execute automatic, recurring tasks ( since version 5.1 ). Please see the mysql - documentation for it.

 

[Noturns]

Hi Noturns,
this is just a WARNING... nothing more. The db still gets dumped, but without the table "mysql.vent", which is a temporary table to execute automatic, recurring tasks ( since version 5.1 ). Please see the mysql - documentation for it.

@UFHH01
I'm sorry, because as a Windows user i got used that a warning means "requires an action"

Yessss.... it worked! and without issues as i followed @IgorG his tutorial for MariaDB version 5.5

The server is still running (for now at least...)
I created a new snapshot before i started just in case ^^

A final check. Yum update has nothing to do ...

# yum install MariaDB-server MariaDB-client MariaDB-compat
Loaded plugins: fastestmirror, security
Setting up Install Process
Loading mirror speeds from cached hostfile
* base: mirror.denit.net
* extras: mirror.denit.net
* updates: mirror.denit.net
Package MariaDB-server-5.5.42-1.el6.x86_64 already installed and latest version
Package MariaDB-client-5.5.42-1.el6.x86_64 already installed and latest version
Package MariaDB-compat-5.5.42-1.el6.x86_64 already installed and latest version
Nothing to do

And a final check in Plesk 12 ....
Database version has been updated to Mysql 5.5 (whoohoooo ^^ )

I did found a issue when i click "Add new Database" this would result in a broken page :-(

update: you need to do this

mysql_upgrade -uadmin -p`< /etc/psa/.psa.shadow `

OK i have tested MariaDB version 5.5 and everything worked !!

 

[Noturns]

Ok, i would like to give MariaDB version 10 a go after a brief test of version MariaDB version 5.5.

MariaDB version 10 is currently a stable version based on MariaDB version 5.5
~!~ an upgrade from MariaDB version 5.5 to version 10 did not succeed.

I had to restore a snapshot and retry the steps in the tutorial with the repository for MariaDB version 10 and i was able to upgrade to MariaDB version 10 very quickly and without issues.

baseurl = http://yum.mariadb.org/10.0/centos6-amd64

And this is code is important, otherwise it would not refresh the Server database version:

mysql_upgrade -uadmin -p`< /etc/psa/.psa.shadow `

It is funny that it says Server type Mysql and database version 10.x.x = Mysql10 !!

 

[Noturns]

If i query mysql packages i get this result:

# rpm -qa mysql*
mysql-connector-odbc-5.1.5r1144-7.el6.x86_64

It was not covered in that tutorial, i don't know if Plesk uses this module.....
- Is there a way to query which package is used by an package?
- How can i safely remove this MySQL-Connector-ODBC package?
- What is the command?

 

[IgorG]

For example:

[root@ppu12-0 ~]# rpm -qa | grep mysql
mysql-5.1.73-3.el6_5.i686
mysql-libs-5.1.73-3.el6_5.i686
mysql-server-5.1.73-3.el6_5.i686
mysql-connector-odbc-5.1.5r1144-7.el6.i686
php-mysql-5.3.3-40.el6_6.i686

[root@ppu12-0 ~]# rpm -e --test mysql-connector-odbc-5.1.5r1144-7.el6.i686
error: Failed dependencies:
mysql-connector-odbc is needed by (installed) plesk-core-12.0.18-cos6.build1200140606.15.i386