[AMBARI-17161] Ubuntu 16, Hive Metastore Start failed

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 2.4.0
• Assignee: Andrew Onischuk
• Reporter: Andrew Onischuk
• Created: 10/Jun/16 10:14
• Updated: 13/Jun/16 15:20
• Resolved: 13/Jun/16 12:04

Description

/var/lib/ambari-agent/tmp/addMysqlUser.sh didn't add mysql user.

+ echo 'Adding user hive@% and removing users with empty name'
Adding user hive@% and removing users with empty name
+ /var/lib/ambari-agent/ambari-sudo.sh su mysql -s /bin/bash - -c 'mysql -u root -e "CREATE USER '\''hive'\''@'\''%'\'' IDENTIFIED BY '\''h'\'';"'
ERROR 1698 (28000): Access denied for user 'root'@'localhost'
+ /var/lib/ambari-agent/ambari-sudo.sh su mysql -s /bin/bash - -c 'mysql -u root -e "GRANT ALL PRIVILEGES ON . TO '\''hive'\''@'\''%'\'';"'
ERROR 1698 (28000): Access denied for user 'root'@'localhost'
+ /var/lib/ambari-agent/ambari-sudo.sh su mysql -s /bin/bash - -c 'mysql -u root -e "DELETE FROM mysql.user WHERE user='\'''\'';"'
ERROR 1698 (28000): Access denied for user 'root'@'localhost'
+ /var/lib/ambari-agent/ambari-sudo.sh su mysql -s /bin/bash - -c 'mysql -u root -e "flush privileges;"'
ERROR 1698 (28000): Access denied for user 'root'@'localhost'
+ /var/lib/ambari-agent/ambari-sudo.sh service mysql stop

Issue Links

• links to: ReviewBoard