question Re: ambari user management view missing in Archives of Support Questions (Read Only)

ambari user management view missing

prakashpunj — Thu, 03 Mar 2016 09:40:29 GMT

When I logon to Ambari as admin, I no longer see the manage ambari link. I need to create users. What could be wrong ?

Re: ambari user management view missing

afernandez — Thu, 03 Mar 2016 09:44:17 GMT

What version of Ambari are you using? Can you check this URI with the exact version, e.g.,

http://server:8080/views/ADMIN_VIEW/2.2.1.1/INSTANCE/#/

Can you check the API, http://server:8080/api/v1/users ?

Any errors in /var/log/ambari-server/ambari-server.log ?

Re: ambari user management view missing

amcbarnett — Thu, 03 Mar 2016 10:17:50 GMT

Did you do an upgrade? This usually occurs after an upgrade of Ambari. Did you remember to upgrade the Ambari database schema? This is an indication that the configurations e.g. Hive configurations in the newer version was not upgraded properly. The easiest way to fix is to look at each component, especially YARN or Hive, see if there is a missing property, usually on the initial Settings table (e.g, Hive authentication) and add it manually to the configuration file e.g. hive-site.xml.

Re: ambari user management view missing

tracy_m_daniel — Thu, 16 Jun 2016 21:19:25 GMT

I am having this same issue after upgrading to Ambari 2.2.2.0 i can only see Manage Ambari when on as Admin, my personal account is set as admin but the link no longer shows for me. The API for all users looks fine and my personal account is only in the admins group. Any thoughts on how to get the link back for my personal account?

Re: ambari user management view missing

tracy_m_daniel — Thu, 16 Jun 2016 21:59:13 GMT

we removed my group from my personal user account and it appears to have returned.

Re: ambari user management view missing

tracy_m_daniel — Thu, 16 Jun 2016 22:41:48 GMT

strange it is very random even after removing and adding group back it appears at each log in it is not there until i hit a refresh then it shows up

Re: ambari user management view missing

CVasamsetty — Fri, 17 Jun 2016 00:37:53 GMT

This issue occurs when ambari ADMIN user is given operator privilege or is added to some group that is given operator privilege. I logged into the ambari database, deleted the entry that got created related to this new user from ADMINPRIVILEGE table/ restarted ambari-server and now i can see the manage ambari link when logged in as admin.

Re: ambari user management view missing

Shelton — Thu, 11 Aug 2016 19:41:00 GMT

@chaitanya vasamsetty

I hit the same problem a I have 2 entries in the MySQL DB for the adminprivileges ? I guess the id.1 is for the admin but I don't want to take a guess so could you tel me what exatctly you deleted?

Re: ambari user management view missing

Shelton — Fri, 12 Aug 2016 14:12:59 GMT

The problem of Manage Ambari option resolved this is what I did !

Logged on the Ambari node where the MySQL database is running. Switch to the Ambari database and deleted the entry in adminprivlege with privilege id 9 I just guessed that id 1 was created first for the ambari Admin which was a correct assumption

# ambari-server stop 
# ambari-server start

But prior to deleting the above entry I run these 2 API's

Delete a user using REST API

curl -iv -u admin:admin -H "X-Requested-By: ambari"-X DELETE http://ambari-server:8080/api/v1/users/{user}

Delete a group using REST API :

curl -iv -u admin:admin -H "X-Requested-By: ambari"-X DELETE http://ambari-server:8080/api/v1/groups/{group}

Hope that helps someone

Re: ambari user management view missing

CVasamsetty — Fri, 12 Aug 2016 22:16:51 GMT

@Geoffrey Shelton Okot

yes that's correct, id.1 is for admin , i deleted the other entries.

Re: ambari user management view missing

Charlie_Cook — Mon, 22 Aug 2016 22:06:39 GMT

I had pretty much the same issue. Upgraded from Ambari 2.1.0 to 2.2.2. Performed the steps to upgrade the Ambari server database and everything worked except the Manage Ambari view was missing. If I used the URI

http://server:8080/views/ADMIN_VIEW/2.2.1.1/INSTANCE/#/

I could access the view, and it would start showing up on my menu, but would be missing again when I next logged in.

Followed the suggestion to look for permissions in the Ambari database and look for additional ones. In my scenario, there admin permissions looked like this.

select * from adminprivilege where principal_id = 1;

privilege_id | permission_id | resource_id | principal_id

--------------+---------------+-------------+--------------

1 | 1 | 1 | 1

52 | 3 | 9 | 1

From querying various tables I found that adminpermissions shows the properties for the permission_id, and the adminresource and adminresourcetype tables combine to show the resource_id properties.

In my case the 2 permissions listed are:

AMBARI.ADMIN permission on the AMBARI resource (the 1 1 1 1 adminprivilege row)

CLUSTER.OPERATE permission on the CLUSTER resource (the 52 3 9 1 adminprivilege row).

If I delete the CLUSTER.OPERATION permission (privilege_id = 52) from the adminprivilege table and restart ambari-server I can see the Manage Ambari permission again and admin seems to work properly.

If I look at the backup I took of the Postgres database that I made before performing the upgrade, I can see that both of the permissions were there before the upgrade. It appears that the new version of Ambari (2.2.0 in my case) doesn't handle this combination of privileges properly.

Just thought I would add some more detail as this looks like it could be an Ambari bug, and ideally, I'm assuming it isn't a normal thing to have to go into the Ambari database and manually delete rows in tables as I assume that making a mistake could likely corrupt the Ambari database.

Re: ambari user management view missing

Matthew_Chang-K — Thu, 16 Feb 2017 00:30:57 GMT

How do you do this? I have no idea how to delete the entry in the ambari database