Installation on Oracle Linux 7 fails due to dependency problems between MySQL and Maria

[Douglas Wagner]

The installation script running on Oracle Linux 7 fails due to an rpm dependency error conflict between MySQL and MariaDB.

It appears that the installer is a bit "split minded" when it comes to Oracle Linux 7 at this point: Early in the installation process it initially fails because Oracle Linux no longer has package "mysql-community-server" as part of it's package set.

2017-02-07 22:21:11.175 | + functions-common:yum_install:1355 : sudo_with_proxies yum install -y mysql-community-server
2017-02-07 22:21:11.984 | + functions-common:yum_install:1355 : echo YUM_FAILED 1
2017-02-07 22:21:11.984 | + functions-common:sudo_with_proxies:2352 : local sudo
2017-02-07 22:21:11.984 | ++ functions-common:sudo_with_proxies:2354 : id -u
2017-02-07 22:21:11.984 | + functions-common:sudo_with_proxies:2354 : [[ 1002 = \0 ]]
2017-02-07 22:21:11.984 | + functions-common:sudo_with_proxies:2354 : sudo=sudo
2017-02-07 22:21:11.984 | + functions-common:sudo_with_proxies:2356 : sudo http_proxy= https_proxy= no_proxy= yum install -y mysql-community-server
2017-02-07 22:21:11.984 | Loaded plugins: langpacks, ulninfo
2017-02-07 22:21:11.984 | No package mysql-community-server available.
2017-02-07 22:21:11.984 | Error: Nothing to do
2017-02-07 22:21:11.984 | YUM_FAILED 1

HOWEVER if you look back farther in the installation, you find this:
(Part of a Yum Install early in the process)
2017-02-07 22:18:35.133 | mariadb-devel x86_64 3:10.1.18-3.el7 openstack-newton 917 k
...
2017-02-07 22:18:56.817 | mariadb-common x86_64 3:10.1.18-3.el7 openstack-newton 63 k
2017-02-07 22:18:56.817 | mariadb-config x86_64 3:10.1.18-3.el7 openstack-newton 25 k
2017-02-07 22:18:56.817 | mariadb-libs x86_64 3:10.1.18-3.el7 openstack-newton 641 k

Which installs correctly.

So now you have mariadb-common, config, libs and devel...which seem to be coming from the openstack-newton repository...but then later in the process it wants to install mysql-community-server.

If I fix the mysql-community-server error with "sudo rpm -Uvh http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm" to install the mysql installation, it will continue past this point but later in the script die on:

2017-02-07 22:27:27.783 | +functions-common:sudo_with_proxies:2356 sudo http_proxy= https_proxy= no_proxy= yum install -y mysql-community-server
2017-02-07 22:27:27.783 | Loaded plugins: langpacks, ulninfo
2017-02-07 22:27:27.783 | Resolving Dependencies
2017-02-07 22:27:27.783 | --> Running transaction check
2017-02-07 22:27:27.783 | ---> Package mysql-community-server.x86_64 0:5.6.35-2.el7 will be installed
2017-02-07 22:27:27.783 | --> Processing Dependency: mysql-community-client(x86-64) >= 5.6.10 for package: mysql-community-server-5.6.35-2.el7.x86_64
2017-02-07 22:27:27.783 | --> Running transaction check
2017-02-07 22:27:27.783 | ---> Package mysql-community-client.x86_64 0:5.6.35-2.el7 will be installed
2017-02-07 22:27:27.783 | --> Finished Dependency Resolution
2017-02-07 22:27:27.783 |
2017-02-07 22:27:27.783 | Dependencies Resolved
2017-02-07 22:27:27.783 |
2017-02-07 22:27:27.783 | ================================================================================
2017-02-07 22:27:27.783 | Package Arch Version Repository Size
2017-02-07 22:27:27.783 | ================================================================================
2017-02-07 22:27:27.783 | Installing:
2017-02-07 22:27:27.783 | mysql-community-server x86_64 5.6.35-2.el7 mysql56-community 59 M
2017-02-07 22:27:27.783 | Installing for dependencies:
2017-02-07 22:27:27.783 | mysql-community-client x86_64 5.6.35-2.el7 mysql56-community 19 M
2017-02-07 22:27:27.783 |
2017-02-07 22:27:27.783 | Transaction Summary
2017-02-07 22:27:27.783 | ================================================================================
2017-02-07 22:27:27.783 | Install 1 Package (+1 Dependent package)
2017-02-07 22:27:27.783 |
2017-02-07 22:27:27.783 | Total size: 78 M
2017-02-07 22:27:27.783 | Installed size: 338 M
2017-02-07 22:27:27.783 | Downloading packages:
2017-02-07 22:27:27.784 | Running transaction check
2017-02-07 22:27:27.784 | Running transaction test
2017-02-07 22:27:27.784 |
2017-02-07 22:27:27.784 |
2017-02-07 22:27:27.784 | Transaction check error:
2017-02-07 22:27:27.784 | file /etc/my.cnf from install of mysql-community-server-5.6.35-2.el7.x86_64 conflicts with file from package mariadb-config-3:10.1.18-3.el7.x86_64
2017-02-07 22:27:27.784 |
2017-02-07 22:27:27.784 | Error Summary
2017-02-07 22:27:27.784 | -------------
2017-02-07 22:27:27.784 |
2017-02-07 22:27:27.784 | YUM_FAILED 1

OracleLinux 7 (at this point) should be detected no differently than RHEL7 or CentOS 7, and in fact, if you go into "./lib/databases/mysql" and modify the entire code set to put all "is_oraclelinux" checks as OR cases to all "is_fedora" checks, stack.sh properly runs to completion.

Furthermore: Why are we pulling mariadb packages from the Openstack Neuton repository when the base package management repos for each of the OS instances already have either MariaDB or MySQL as part of their repositories. If a specific version from OpenStack repo needs to be installed it should be a separate yum call with all other repos turned off...and a full installation should be made (note that you don't get "server" or the base "mariadb" package installed with this method).

[Sean Dague (sdague)]

Automatically discovered version newton in description. If this is incorrect, please update the description to include 'https://api.launchpad.net/1.0/devstack version: ...'

[Sean Dague (sdague)]

Automatically discovered version newton in description. If this is incorrect, please update the description to include 'devstack version: ...'

[Aizuddin Zali (mymzbe)]

Kindly provide 'yum repolist' output.