Andrii Tkach created AMBARI-16020:
-------------------------------------
Summary: Hive Metastore install failed since mysql-server not
installed
Key: AMBARI-16020
URL: https://issues.apache.org/jira/browse/AMBARI-16020
Project: Ambari
Issue Type: Bug
Components: ambari-web
Affects Versions: 2.4.0
Reporter: Andrii Tkach
Assignee: Andrii Tkach
Priority: Critical
Fix For: 2.4.0
STR:
* Install Ambari 2.4.0.0-4686 on 3 hosts
* Install HDP 2.5.0.0-58 with Hive Server on 1 host and Hive Metastore on the
other
* Select option to install Hive with "New MySQL" database
Failed installing Hive Metastore since MySQL service was not installed.
{code}
File "/usr/lib/python2.6/site-packages/resource_management/core/shell.py",
line 293, in _call
raise Fail(err_msg)
resource_management.core.exceptions.Fail: Execution of 'export
HIVE_CONF_DIR=/usr/hdp/current/hive-metastore/conf/conf.server ;
/usr/hdp/current/hive-metastore/bin/schematool -initSchema -dbType mysql
-userName hive -passWord [PROTECTED]' returned 1. WARNING: Use "yarn jar" to
launch YARN applications.
Metastore connection URL:
jdbc:mysql://c6405.ambari.apache.org/hive?createDatabaseIfNotExist=true
Metastore Connection Driver : com.mysql.jdbc.Driver
Metastore connection User: hive
org.apache.hadoop.hive.metastore.HiveMetaException: Failed to get schema
version.
*** schemaTool failed ***
{code}
I had to run this manually,
{code}
yum install mysql-server -y
service mysqld start
mysql -u root -p (password is empty string)
mysql> CREATE USER 'hive'@'%' IDENTIFIED BY 'admin';
Query OK, 0 rows affected (0.00 sec)
mysql> GRANT ALL PRIVILEGES ON *.* TO 'hive'@'%';
Query OK, 0 rows affected (0.00 sec)
mysql> GRANT ALL PRIVILEGES ON *.* TO 'hive'@'localhost';
Query OK, 0 rows affected (0.00 sec)
mysql> GRANT ALL PRIVILEGES ON *.* TO 'hive'@'c6405.ambari.apache.org';
Query OK, 0 rows affected (0.00 sec)
mysql> GRANT ALL PRIVILEGES ON *.* TO 'hive'@'c6405.ambari.apache.org'
IDENTIFIED BY 'admin' WITH GRANT OPTION;
Query OK, 0 rows affected (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
{code}
and then try the Start again.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
