Cannot onboard VMs in the Console access page for user not found

When you try to onboard a VM in the Console access page on IBM Cloud Pak console, you might see the error message user xxx is not found.

Resolving the problem

To resolve this problem, follow the steps:

  1. Log in to the postgresql pod by running the following command:

    oc rsh sre-bastion-postgresql-0 -n kube-system
  2. Run the following commands in the postgresql pod:

    cat > /tmp/trucate.sql <<EOF
    truncate table public.user_maps CASCADE;
    truncate table public.os_user_acls;
    cat /tmp/trucate.sql
    psql -U postgres -w -d bastion -f /tmp/trucate.sql

    Note: After you run the commands, all the onboarded VMs will become off-boarded. You need to go to the Console access page, and onboard these VMs again.