question Re: mysql-community-server package not found on HDP-UTILS-1.1.0.22 repo in Archives of Support Questions (Read Only)

mysql-community-server package not found on HDP-UTILS-1.1.0.22 repo

sgarudi — Wed, 17 Jan 2018 20:28:01 GMT

The MySQL Server Install fails on HDP 2.6.4 with following error :

resource_management.core.exceptions.ExecutionFailed:
Execution of '/usr/bin/yum -d 0 -e 0 -y install mysql-community-release'
returned 1. Error: Nothing to do

This error is because the mysql-community-server package not found on HDP-UTILS-1.1.0.22 repo. With the HDP-UTILS-1.1.0.21 the installation is successful as the package is existing in that repo.

In the hortonworks HDP installation document the HDP-UTILS version in URL for is shown as HDP-UTILS-1.1.0.21, however during the actual installation the version for HDP-UTILS is HDP-UTILS-1.1.0.22. (https://docs.hortonworks.com/HDPDocuments/Ambari-2.6.1.0/bk_ambari-installation/content/hdp_26_repositories.html )

Is there a specific reason for not including mysql-community-server package in HDP-UTILS-1.1.0.22 repo ? Should it be pre-installed?

Re: mysql-community-server package not found on HDP-UTILS-1.1.0.22 repo

asirna — Wed, 17 Jan 2018 20:35:36 GMT

@Sonia Garudi,

From HDP 2.6.4, due to licensing issues mysql was removed. All the GPL licensed components will be removed from now. If you are using mysql for hive then you should install it by yourself.

Thanks,

Aditya

Re: mysql-community-server package not found on HDP-UTILS-1.1.0.22 repo

sgarudi — Thu, 18 Jan 2018 19:42:25 GMT

@Aditya Sirna, thanks for the clarification.

However, according to the https://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.6.4/bk_support-matrices/content/ch_matrices-hdp.html, Mysql instance will be installed by Ambari by default for Hive. Is it documented anywhere else that Mysql should be installed as a pre-req for Hive or is this to be updated yet?

Re: mysql-community-server package not found on HDP-UTILS-1.1.0.22 repo

sgarudi — Thu, 18 Jan 2018 19:58:40 GMT

Also, I noticed that the link for hdp-utils.repo in ppc documentation (https://docs.hortonworks.com/HDPDocuments/Ambari-2.6.1.0/bk_ambari-installation-ppc/content/hdp_26_repositories.html) is broken and the HDP-UTILS repo link is present in the hdp.repo.

Re: mysql-community-server package not found on HDP-UTILS-1.1.0.22 repo

joelandsonia — Tue, 20 Feb 2018 05:12:04 GMT

In a fresh install, HDP will attempt to install MySQL using the command above. I have not found a clean way to create a working repository for MySQL (I either get the above error or a conflict). Has anyone found a way to get this to work within the context of the HDP install or must it always be installed and configured *before* installing HDP?

Re: mysql-community-server package not found on HDP-UTILS-1.1.0.22 repo

pchallauk — Tue, 20 Feb 2018 05:33:55 GMT

I had the same issue and I am able to resolve it by Download and add the repository, then update.

wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm
sudo rpm -ivh mysql-community-release-el7-5.noarch.rpm
yum update

I assume you have taken care the below.

yum install -y mysql-connector-java
ambari-server setup --jdbc-db=mysql --jdbc-driver=/usr/share/java/mysql-connector-java.jar

Re: mysql-community-server package not found on HDP-UTILS-1.1.0.22 repo

joelandsonia — Tue, 20 Feb 2018 22:28:55 GMT

Hi Pavan -- that did indeed allow the install to proceed, but something must be wrong somewhere. It can't seem to configure the database for Hive. I get an error on startup about how the database can't be accessed by the node. Sigh....this all worked in 2.6.3......

org.apache.hadoop.hive.metastore.HiveMetaException:Failed to get schema version.
Underlying cause: java.sql.SQLException:null, message from server:"Host 'rh74-full.ibm.com' is not allowed to connect to this MySQL server"
SQL Error code:1130
org.apache.hadoop.hive.metastore.HiveMetaException:Failed to get schema version.