How to delete Aria Automation Config authentication providers when you can not see them in the Aria Automation Config UI

Products

• VMware Aria Suite

Issue/Introduction

Sometimes after you created an authentication provider in the Administration->Authentication tab of the Aria Automation Config UI you want to delete it. Sometimes you can no longer see the authentication provider in this tab but they still show up when you are trying to log into Aria Automation on the login page.

Environment

Aria Automation Config: 8.x 

Resolution

Before starting this process you will want to backup the postgres database or take a snapshot of the server the postgres database is on.

To resolve this issue we can delete the entries from the Aria Automation Config postgres database in the auth_configs table that we do not want to exist.

 

Connect the Aria Automation Config postgres server as root and run the following commands:
su postgres

psql -h 127.0.0.1

\l

\c raas * (where * is the guid from above command)

 

Verify the authentication providers you would like to delete with the following command:

select name,uuid from auth_configs;

 

Then use the following command to delete the authentication providers that are not needed using the UUID from the previous command: 

delete from auth_configs where uuid='<UUID from previous command>';