Pivotal Knowledge Base

Follow

How to check the information for Elastic Runtime users

Environment

Product Version
Pivotal Cloud Foundry® (PCF) 1.6.x, 1.7.x

 

Purpose

This article discusses how to check the information for Elastic Runtime users.

Procedure

1. Target your system UAA. Run uaac target uaa.<system domain>.

ubuntu@pivotal-ops-manager:~$ uaac target uaa.system.azhao.com

Target: https://uaa.system.azhao.com
Context: admin, from client admin

2. Get your token. Run uaac token client get admin -s <admin client password>. Just press Enter for Client secret. Please be aware that the password and username here are the admin user and password for UAA. You can get it from Ops Manager GUI -> ER Tile -> Credential -> UAA -> Admin Client Credentials

ubuntu@pivotal-ops-manager:~$ uaac token client get admin -s <admin client password>
Client secret: ********************

Successfully fetched token via client credentials grant.
Target: https://uaa.system.azhao.com
Context: admin, from client admin

3. Run uaac users to show the detailed information for each user.  

ubuntu@pivotal-ops-manager:~$ uaac users
resources:
-
id: 7c975448-4e1c-40f8-88c1-4f6816860536
meta
version: 0
created: 2016-09-13T01:28:23.000Z
lastmodified: 2016-09-13T01:28:23.000Z
name
emails:
-
value: push_apps_manager
primary: false
groups:
-
value: ed540895-a8e9-4996-b706-1ef5a989b10b
display: cloud_controller.write
type: DIRECT
-
...
-
value: fb4eae2a-042b-4061-9f1e-7a55944b83e0
display: user_attributes
type: DIRECT
approvals:
active: true
verified: true
origin: uaa
schemas: urn:scim:schemas:core:1.0
username: alice
zoneid: uaa
passwordlastmodified: 2016-09-20T08:09:33.000Z
schemas: urn:scim:schemas:core:1.0
startindex: 1
itemsperpage: 100
totalresults: 7

Additional Information

You can also connect to the database directly to get the information. Please be aware that this is only for the troubleshooting purpose, and do not change anything if you're not quite sure how to recover.

1. Bosh ssh to MySQL vm. connect to MySQL database.

bosh_v46cxw307@a5f95f06-1ed5-4c0d-a8c5-2f09f65514c0:~$ mysql -u be45dadce4bcd4680e1f -p uaa
Enter password:
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 122
Server version: 10.0.22-MariaDB-wsrep Source distribution, wsrep_25.11.r21a2415

Copyright (c) 2000, 2015, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [uaa]>

2. Select from table users. You can see all information maintained for the ER users. 

MariaDB [uaa]> select * from users;
+--------------------------------------+---------------------+---------------------+---------+---------------------+--------------------------------------------------------------+---------------------+-------------+-----------+------------+--------+-------------+----------+--------+-------------+------------------+------+---------------------+------------------------------+
| id | created | lastmodified | version | username | password | email | authorities | givenname | familyname | active | phonenumber | verified | origin | external_id | identity_zone_id | salt | passwd_lastmodified | legacy_verification_behavior |
+--------------------------------------+---------------------+---------------------+---------+---------------------+--------------------------------------------------------------+---------------------+-------------+-----------+------------+--------+-------------+----------+--------+-------------+------------------+------+---------------------+------------------------------+
| 47e4a455-4f97-4c68-9e68-4d66ae3c8c02 | 2016-09-13 01:28:24 | 2016-09-13 01:28:24 | 0 | system_verification | $2a$10$yyADQ0lqXVerZvh3uXC2VuDrF4.AwQHmlpIp7aBv20Dff9v9tmxSq | system_verification | uaa.user | NULL | NULL | 1 | NULL | 1 | uaa | NULL | uaa | NULL | 2016-09-13 01:28:24 | 0 |
| 7c975448-4e1c-40f8-88c1-4f6816860536 | 2016-09-13 01:28:23 | 2016-09-13 01:28:23 | 0 | push_apps_manager | $2a$10$2.NoMClqTvCVBQYIZtwmh.zBYYGsBO5UFVwKPLfPXemXvpbCqLsvC | push_apps_manager | uaa.user | NULL | NULL | 1 | NULL | 1 | uaa | NULL | uaa | NULL | 2016-09-13 01:28:23 | 0 |
| 83d29bd7-63d2-4000-99a0-dafcfe07c407 | 2016-09-13 01:28:24 | 2016-09-13 01:28:24 | 0 | system_services | $2a$10$S6rSAPI3P/p2RfONW2HZ8.wnRpaKcBjRk4HFeG7oMRcYWXNCm0eOG | system_services | uaa.user | NULL | NULL | 1 | NULL | 1 | uaa | NULL | uaa | NULL | 2016-09-13 01:28:24 | 0 |
| 84f4638d-c476-4a76-8843-f29cc0711f9e | 2016-09-13 01:28:23 | 2016-09-13 01:28:23 | 0 | smoke_tests | $2a$10$zh88.UOWsg3L4IywJTgnXuRJ2zHGBxmxfxzeEZsKdj05PLk.Ij4Fu | smoke_tests | uaa.user | NULL | NULL | 1 | NULL | 1 | uaa | NULL | uaa | NULL | 2016-09-13 01:28:23 | 0 |
| 9f27cef2-7c4a-4701-871c-81aea4158334 | 2016-09-13 01:28:23 | 2016-09-13 01:28:23 | 0 | admin | $2a$10$L1H367mYswt6Fg7xIW4Ls.NWO8GfSnVuvjVGI1Lu3JHhCdbllaY7a | admin | uaa.user | NULL | NULL | 1 | NULL | 1 | uaa | NULL | uaa | NULL | 2016-09-13 01:28:23 | 0 |
| c6da9692-9eee-47ea-9ab5-dd6bd45f1efa | 2016-09-13 01:28:24 | 2016-09-13 01:28:24 | 0 | logsearch-firehose | $2a$10$3f18ToIXHKzqLt.0t3drM.YvyLowKwpLl2A.sVJxneZxY4evX21T2 | logsearch-firehose | uaa.user | NULL | NULL | 1 | NULL | 1 | uaa | NULL | uaa | NULL | 2016-09-13 01:28:24 | 0 |
+--------------------------------------+---------------------+---------------------+---------+---------------------+--------------------------------------------------------------+---------------------+-------------+-----------+------------+--------+-------------+----------+--------+-------------+------------------+------+---------------------+------------------------------+
6 rows in set (0.00 sec)

 

Comments

Powered by Zendesk