DX APM - Unable to login to tenant or masteradmin console
Article ID: 185182
Updated On:
Products
CA Application Performance Management (APM / Wily / Introscope)
DX Application Performance Management
CA App Experience Analytics
Issue/Introduction
Unable to login to APM 11 login UI, apmservices-gateway, dxportal, tenant, axa admin or masteradmin console
Cause
Authorization is controlled by AXA services, the message indicates and there is an issue with either axa services, postgres or elastic nodes
Environment
APM 11.x, 19.x
Resolution
Option 1: Restart Posgres pod
a) obtain the postgres pod name
kubectl get pods -ndxi | grep post
postgresql-77c878cc47-hvst8 1/1 Running 0
b) delete the pod
kubectl delete pod postgresql-77c878cc47-hvst8 -ndxi
pod "postgresql-77c878cc47-hvst8" deleted
Option 2: Restart axaservices-adminui pods
a) obtain the postgres pod name
kubectl get pods -ndxi | grep axaservices-adminui
axaservices-adminui-69444f5d6d-x9mth 1/1 Running 0 32d
b) delete the pod
kubectl delete pod axaservices-adminui-69444f5d6d-x9mth
Option 3: Review posgres logs for possible database corruption
DX - Unable to login to tenant - corrupted postgres database
https://ca-broadcom.wolkenservicedesk.com/external/article?articleId=184125
Option 4: Problem with Elastic Nodes
DX - Unable to login to tenant and mastertenant - jarvis-elasticsearch pods evicted
https://ca-broadcom.wolkenservicedesk.com/external/article?articleId=185156
Option 5: Account locked out
Locate postgres pod, get shell to running container, then run sql statements to unlock the account:
a) obtain the postgres pod name
kubectl get pods -ndxi | grep postgres
b) get inside the container
kubectl exec -it <posgres-pod> -ndxi bash
c) connect to aoplatform database
psql -U aopuser -d aoplatform
d) unlock the account
SELECT strikecount FROM aradminbasicauthuser WHERE userid = 'MASTERADMIN';
UPDATE aradminbasicauthuser SET strikecount = 0 WHERE userid = 'MASTERADMIN';
a) obtain the postgres pod name
kubectl get pods -ndxi | grep post
postgresql-77c878cc47-hvst8 1/1 Running 0
b) delete the pod
kubectl delete pod postgresql-77c878cc47-hvst8 -ndxi
pod "postgresql-77c878cc47-hvst8" deleted
Option 2: Restart axaservices-adminui pods
a) obtain the postgres pod name
kubectl get pods -ndxi | grep axaservices-adminui
axaservices-adminui-69444f5d6d-x9mth 1/1 Running 0 32d
b) delete the pod
kubectl delete pod axaservices-adminui-69444f5d6d-x9mth
Option 3: Review posgres logs for possible database corruption
DX - Unable to login to tenant - corrupted postgres database
https://ca-broadcom.wolkenservicedesk.com/external/article?articleId=184125
Option 4: Problem with Elastic Nodes
DX - Unable to login to tenant and mastertenant - jarvis-elasticsearch pods evicted
https://ca-broadcom.wolkenservicedesk.com/external/article?articleId=185156
Option 5: Account locked out
Locate postgres pod, get shell to running container, then run sql statements to unlock the account:
a) obtain the postgres pod name
kubectl get pods -ndxi | grep postgres
b) get inside the container
kubectl exec -it <posgres-pod> -ndxi bash
c) connect to aoplatform database
psql -U aopuser -d aoplatform
d) unlock the account
SELECT strikecount FROM aradminbasicauthuser WHERE userid = 'MASTERADMIN';
UPDATE aradminbasicauthuser SET strikecount = 0 WHERE userid = 'MASTERADMIN';
Additional Information
Attachments
Feedback
Yes
No
Powered by
