Ambari : MySQL Server install

I get the following error eventhough mysql-client has been installed:

stderr:

None
stdout:

notice: /Stage[1]/Hdp::Snappy::Package/Hdp::Snappy::Package::Ln[32]/Hdp::Exec[hdp::snappy::package::ln 32]/Exec[hdp::snappy::package::ln 32]/returns: executed successfully
err: /Stage[2]/Hdp-mysql::Server/Hdp::Package[mysql]/Hdp::Package::Process_pkg[mysql]/Package[mysql-client]/ensure: change from absent to present failed: Could not find package mysql-client
err: /Stage[2]/Hdp-mysql::Server/Hdp::Package[mysql]/Hdp::Package::Process_pkg[mysql]/Package[mysql]/ensure: change from absent to present failed: Could not find package mysql
notice: /Stage[2]/Hdp-mysql::Server/Hdp::Package[mysql]/Hdp::Package::Process_pkg[mysql]/Anchor[hdp::package::mysql::end]: Dependency Package[mysql] has failures: true
notice: /Stage[2]/Hdp-mysql::Server/Hdp::Package[mysql]/Hdp::Package::Process_pkg[mysql]/Anchor[hdp::package::mysql::end]: Dependency Package[mysql-client] has failures: true
warning: /Stage[2]/Hdp-mysql::Server/Hdp::Package[mysql]/Hdp::Package::Process_pkg[mysql]/Anchor[hdp::package::mysql::end]: Skipping because of failed dependencies
…

I’m using SUSE

# zypper search mysql
Loading repository data…
Reading installed packages…

S | Name | Summary | Type
–+———————-+—————————————————–+——–
i | MySQL-client | MySQL – Client | package
i | MySQL-server | MySQL: a very fast and reliable SQL database server | package
i | libmysqlclient_r15 | A True Multiuser, Multithreaded SQL Database Server | package
i | libqt4-sql-mysql | Qt 4 MySQL support | package
i | mysql-connector-java | MySQL Connector/J – JDBC driver for MySQL | package

Topic

[Larry LiuModerator]

Hi, David

Let’s take this offline. I will email you for next step.

Thanks

Larry

[David KunzMember]

Sorry, I meant the same original error message occurred again.
Tried dropping the hive schema and still fails with the same original message.
I’m attaching the ambari-agent.log (ambari-agent.out is empty).
Thanks,
David

[SefMember]

Hi David,

Thanks for trying this again. From output in last comment it is not clear what failed. Can you please provide ambari-agent.log and ambari-agent.out file? One more thing you can try is to drop hive database and hive users that you crated prior to uninstalling MySQL.

Thanks,
Seth

[David KunzMember]

Uninstalled mysql and mysql-client.
Removed all the packages and restarted the installation process.
It still fails at that point, but what is interesting is the mysql and msql-client packages get installed.

TDC2-2-23:/etc/zypp/repos.d # rpm -qil MySQL-client-5.5.25a-1.linux2.6
Name : MySQL-client Relocations: (not relocatable)
Version : 5.5.25a Vendor: Oracle and/or its affiliates
Release : 1.linux2.6 Build Date: Fri Jun 29 07:15:33 2012
Install Date: Mon Mar 11 15:52:16 2013 Build Host: vitro46
Group : Applications/Databases Source RPM: MySQL-5.5.25a-1.linux2.6.src.rpm
Size : 60157205 License: Copyright (c) 2000, 2012, Oracle and/or its affiliates. All rights reserved. Under GPL license as shown in the Description field.
Signature : DSA/SHA1, Sat Jun 30 02:09:13 2012, Key ID 8c718d3b5072e1f5
Packager : MySQL Release Engineering
URL : http://www.mysql.com/
Summary : MySQL – Client

[SefMember]

Hi David,

I think there might be an issue here. We are looking further into this. For now you can try to uninstall mysql and mysql-client and have Ambari install and setup MySQL during installation process. Can you please give it a try?

Please let us know if this is helpful.

Thanks,
Seth

[David KunzMember]

Yes, I made sure mysql was running, created database hive and user hive and put in those credentials in the installation setup so that Ambari would not need to install mysql-server/mysql-client. It still failed with the same original error message. I even tried using the mysql root user to give it full control and the same issue occured.
Thanks,
David

[tedrMember]

HI David,

Since you already have MySQL installed. During the install there is a point where you point Ambari at your running MySQL instance. Did you do this? If you leave this field blank Ambari will try to install MySQL for you, thinking that you don’t currently have it installed. Note: The MySQL server needs to be running at the time of install.

Thanks,
Ted.

[David KunzMember]

Here is what I get when I run the following:
zypper info mysql
zypper info mysql-client
zypper info mysql-server

TDC2-2-23:~ # zypper info mysql
Loading repository data…
Reading installed packages…

package ‘mysql’ not found.

TDC2-2-23:~ # zypper info mysql-client
Loading repository data…
Reading installed packages…

Information for package mysql-client:

Repository: ARTIFACTS
Name: MySQL-client
Version: 5.5.25a-1.linux2.6
Arch: x86_64
Vendor: Oracle and/or its affiliates
Support Level: unknown
Installed: Yes
Status: up-to-date
Installed Size: 57.4 MiB
Summary: MySQL – Client
Description:
This package contains the standard MySQL clients and administration tools.

For a description of MySQL see the base MySQL RPM or http://www.mysql.com/

TDC2-2-23:~ # zypper info mysql-server
Loading repository data…
Reading installed packages…

Information for package mysql-server:

Repository: ARTIFACTS
Name: MySQL-server
Version: 5.5.25a-1.linux2.6
Arch: x86_64
Vendor: Oracle and/or its affiliates
Support Level: unknown
Installed: Yes
Status: up-to-date
Installed Size: 152.9 MiB
Summary: MySQL: a very fast and reliable SQL database server
Description:
The MySQL(TM) software delivers a very fast, multi-threaded, multi-user,
and robust SQL (Structured Query Language) database server. MySQL Server
is intended for mission-critical, heavy-load production systems as well
as for embedding into mass-deployed software. MySQL is a trademark of
Oracle and/or its affiliates

The MySQL software has Dual Licensing, which means you can use the MySQL
software free of charge under the GNU General Public License
(http://www.gnu.org/licenses/). You can also purchase commercial MySQL
licenses from Oracle and/or its affiliates if you do not wish to be bound by the terms of
the GPL. See the chapter “Licensing and Support” in the manual for
further info.

The MySQL web site (http://www.mysql.com/) provides the latest news and
information about the MySQL software. Also please see the documentation
and the manual for more information.

This package includes the MySQL server binary as well as related utilities
to run and administer a MySQL server.

If you want to access and work with the database, you have to install
package “MySQL-client” as well!

[tedrMember]

Hi David,

Is that a list of Installed packages, or a listing of available packages? What do you get when you run

zypper info mysql ?

Thanks,
Ted.

[David KunzMember]

It’s SUSE 11 sp1.
And in this case, it is just a single node setup for now.

Thanks,
David

[RobertMember]

Hi David,
What version of SUSE are you using? Also is this for single node setup?

Regards,
Robert

[David KunzMember]

Thank you for your update.
I ran the following commands and installed the mysql packages using zypper. I also provided the Ambari setup with th e mysql login/db credentials to have Ambari skip the mysql install portion, but the same error occurs indicating that it cannot find the package “mysql-client”. I was thinking it could have something to do with the casing because on the linux server, it shows as “MySQL-client”.
Please let me know what else to try or if there is a log I could get to provide more details. Nothing is stated inside the ambari-server or ambari-agent log files.
Thanks,
David

[abdelrahman shettiaMember]

Hi David,

Please run zypper clean first and rerun the Ambari installation after that. If the problem persist install the mysql packages with zypper and see if if all of the packages installed successfully and there are no decencies failures. and Run the Ambari installation gain. Hope this helps.

Thanks
-Abdelrhaman

[Author]

Replies