question Re: DataNode Install Error on MySQL in Support Questions

DataNode Install Error on MySQL

david_yee — Tue, 26 Jan 2016 11:48:16 GMT

Hi All,

I am having the issue in installing the MySQL when creating the datanode. Help will be appreciated. Sorry for much trouble as I am totally new to it.

datanode-mysql-issue.png

Best Regards

David

Re: DataNode Install Error on MySQL

aervits — Tue, 26 Jan 2016 11:51:57 GMT

@David Yee

run yum install mysql-community-release manually and retry the install through ambari. Also please post errors as text so it's searchable on the site. When you post photos, other users cannot see the actual issues you're having.

Re: DataNode Install Error on MySQL

david_yee — Tue, 26 Jan 2016 11:55:40 GMT

Ok sure on posting the errors in text. 🙂

Hi Artem,

I have run the command manually "yum install mysql-community-release" but it gave me the following message.

Loaded plugins: amazon-id, rhui-lb, search-disabled-repos Repository HDP-UTILS-1.1.0.20 is listed more than once in the configuration No package mysql-community-release available. Error: Nothing to do

Best Regards

David

Re: DataNode Install Error on MySQL

aervits — Tue, 26 Jan 2016 11:57:07 GMT

@David Yee review your /etc/yum.repos.d/ directory for HDP-UTILS-1... entry and remove one of the entries. it says you have it listed more than once. Then do yum clean all, yum search mysql.

Re: DataNode Install Error on MySQL

david_yee — Tue, 26 Jan 2016 12:03:55 GMT

Wow... thank you so much Artem. It works.

Re: DataNode Install Error on MySQL

amcbarnett — Tue, 26 Jan 2016 12:06:24 GMT

Do the following

yum clean all
yum clean dbcache
yum clean metadata
yum makecache
rpm —rebuilddb
yum history new

@David Yee Are you following any instructions to install on AWS?

It seems that this the help you really need.

See the answer to

https://community.hortonworks.com/questions/10728/ambari-fails-to-register.html

Or check out these resources.

Re: DataNode Install Error on MySQL

aervits — Tue, 26 Jan 2016 12:13:19 GMT

@David Yee not to sound repetitive, but once you get a solution, please accept answers that helped resolve the question. This will help other users and this site doesn't get cluttered with unanswered threads.

Thanks

Re: DataNode Install Error on MySQL

aervits — Tue, 26 Jan 2016 12:16:45 GMT

@David Yee I converted my comment to answer, if that helps.

Re: DataNode Install Error on MySQL

marka_thorson — Fri, 19 Feb 2016 21:56:56 GMT

@Artem Ervits

How exactly do you remove one of the entries? I encountered the same issue as David and am quite new to Linux.

Re: DataNode Install Error on MySQL

aervits — Fri, 19 Feb 2016 22:01:27 GMT

ssh root@machine
yum repolist
cd /etc/yum.repos.d/
vi filename.repo

look for the .repo files that are similar like HDP.repo HDP-UTILS.repo, ambari.repo and find dupes that way with repolist command above, you can get a response saying what is listed twice, then find that file and edit it to remove the duplicate entry. @Mark Thorson

Re: DataNode Install Error on MySQL

marka_thorson — Fri, 19 Feb 2016 22:17:34 GMT

I see the files you are talking about (denoted by red arrows) but I don't see any exact duplicates.

Re: DataNode Install Error on MySQL

aervits — Fri, 19 Feb 2016 22:20:06 GMT

@Mark Thorson what is the exact issue you're facing? I see you have postgres installed, is that the issue that you're getting errors on dependency? You can uninstall Postgres and ambari-server and try again, ambari-server will pull postgres as part of install automatically. Check the ambari-server requirements for Postgres in our documentation for the right versions, v. 8 and 9 are supported.

Re: DataNode Install Error on MySQL

marka_thorson — Fri, 19 Feb 2016 22:50:39 GMT

I am using Ambari to create a new cluster but the install is failing at the MySQL Server install. I am getting the same error message as David included in his screenshot.

ambari-mysql-error-msg.txt

Re: DataNode Install Error on MySQL

aervits — Fri, 19 Feb 2016 22:53:17 GMT

run it manually and paste error here @Mark Thorson

yum install -y mysql-server

Re: DataNode Install Error on MySQL

marka_thorson — Fri, 19 Feb 2016 23:21:15 GMT

I ran that script and it returned "No Package mysql-server available. Error: Nothing to do". I take it I need to download a mysql package (MySQL 5.6) then try it again.

Re: DataNode Install Error on MySQL

aervits — Fri, 19 Feb 2016 23:28:22 GMT

@Mark Thorson try the command below first, if no result, download manually and install

yum search all mysql

Re: DataNode Install Error on MySQL

marka_thorson — Mon, 19 Aug 2019 11:18:59 GMT

Looks like mysql is installed. Do you think it could be something with the version of mysql installed? Maybe an incompatible version was installed?

Re: DataNode Install Error on MySQL

aervits — Sat, 20 Feb 2016 02:40:08 GMT

try this

yum install mysql-community-release

Re: DataNode Install Error on MySQL

marka_thorson — Sat, 20 Feb 2016 04:28:21 GMT

I tried that and it gave me the same result as before "No package mysql-community-release available Error: Nothing to do". @Artem Ervits

Re: DataNode Install Error on MySQL

marka_thorson — Mon, 22 Feb 2016 23:08:53 GMT

I followed the steps on this following link and I was able to successfully install MySQL. http://ahmed.amayem.com/installing-latest-version-of-mysql-on-linux-centos-6-production-server/