MySQL has differing user permissions based on the origin of the request. Ambari should do this for you when it connects as a privileged user, but try connecting as root to MySQL, then issue...
grant all on hive.* to 'hive@'your_ambari_host_ip' identified by 'your_hive_password'; flush privileges; On Thu, Nov 5, 2015 at 6:06 AM, Kaliyug Antagonist < [email protected]> wrote: > I have installed HDP 2.3 using Ambari 2.1.2. > > When I attempt to start the Hive Metastore, I get : > > stderr: /var/lib/ambari-agent/data/errors-811.txt > > Traceback (most recent call last): > File > "/var/lib/ambari-agent/cache/common-services/HIVE/0.12.0.2.0/package/scripts/hive_metastore.py", > line 219, in <module> > HiveMetastore().execute() > File > "/usr/lib/python2.6/site-packages/resource_management/libraries/script/script.py", > line 219, in execute > method(env) > File > "/var/lib/ambari-agent/cache/common-services/HIVE/0.12.0.2.0/package/scripts/hive_metastore.py", > line 55, in start > self.configure(env) # FOR SECURITY > File > "/var/lib/ambari-agent/cache/common-services/HIVE/0.12.0.2.0/package/scripts/hive_metastore.py", > line 66, in configure > hive(name = 'metastore') > File > "/usr/lib/python2.6/site-packages/ambari_commons/os_family_impl.py", line > 89, in thunk > return fn(*args, **kwargs) > File > "/var/lib/ambari-agent/cache/common-services/HIVE/0.12.0.2.0/package/scripts/hive.py", > line 292, in hive > user = params.hive_user > File > "/usr/lib/python2.6/site-packages/resource_management/core/base.py", line > 154, in __init__ > self.env.run() > File > "/usr/lib/python2.6/site-packages/resource_management/core/environment.py", > line 152, in run > self.run_action(resource, action) > File > "/usr/lib/python2.6/site-packages/resource_management/core/environment.py", > line 118, in run_action > provider_action() > File > "/usr/lib/python2.6/site-packages/resource_management/core/providers/system.py", > line 260, in action_run > tries=self.resource.tries, try_sleep=self.resource.try_sleep) > File > "/usr/lib/python2.6/site-packages/resource_management/core/shell.py", line > 70, in inner > result = function(command, **kwargs) > File > "/usr/lib/python2.6/site-packages/resource_management/core/shell.py", line > 92, in checked_call > tries=tries, try_sleep=try_sleep) > File > "/usr/lib/python2.6/site-packages/resource_management/core/shell.py", line > 140, in _call_wrapper > result = _call(command, **kwargs_copy) > File > "/usr/lib/python2.6/site-packages/resource_management/core/shell.py", line > 291, 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:// > l1033lab.sss.se.company.com:3306/hive?createDatabaseIfNotExist=true > Metastore Connection Driver : com.mysql.jdbc.Driver > Metastore connection User: hive > org.apache.hadoop.hive.me > > > In the Hive config., I have selected 'New MySQL database'. > > On the machine l1033lab, there is a MySQL running : > > > [root@l1033lab ~]# mysql -u hive > Welcome to the MySQL monitor. Commands end with ; or \g. > Your MySQL connection id is 441 > Server version: 5.1.73 Source distribution > > Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights > reserved. > > Oracle is a registered trademark of Oracle Corporation and/or its > affiliates. Other names may be trademarks of their respective > owners. > > Type 'help;' or '\h' for help. Type '\c' to clear the current input > statement. > > mysql> > mysql> > mysql> select > User,Select_priv,Insert_priv,Update_priv,Delete_priv,Create_priv from > mysql.user; > > +------+-------------+-------------+-------------+-------------+-------------+ > | User | Select_priv | Insert_priv | Update_priv | Delete_priv | > Create_priv | > > +------+-------------+-------------+-------------+-------------+-------------+ > | root | Y | Y | Y | Y | Y > | > | root | Y | Y | Y | Y | Y > | > | root | Y | Y | Y | Y | Y > | > | hive | Y | Y | Y | Y | Y > | > > +------+-------------+-------------+-------------+-------------+-------------+ > 4 rows in set (0.00 sec) > > mysql> > mysql> show databases; > +--------------------+ > | Database | > +--------------------+ > | information_schema | > | mysql | > | test | > +--------------------+ > 3 rows in set (0.00 sec) > > How shall I proceed ? > > >
