How to manually update the airgap FQDN in TCA-CP postgres database

Products

VMware Telco Cloud Automation

Issue/Introduction

This document contains the procedure to update the database manually with the airgapFqdn in the ApplianceConfig table on TCA-CP (where workload cluster is configured).

Symptoms:

Trying to open terminal for a workload cluster from TCA UI fails abruptly due to associated pods trying to pull images from public jfrog repo in an airgapped env.
Running diagnosis tests for a mgmt/workload cluster from TCA UI fails due to associated pods trying to pull images from public jfrog repo in an airgapped env.

Environment

TCA 2.3

Cause

Airgap Server FQDN is missing for clusters in the database of TCA Control plane node. This could happen after cluster certs are renewed using manual/automated work arounds provided.

Resolution

Update Airgap FQDN for management cluster in TCA-CP DB.

SSH into the TCA-CP appliance as admin.
Connect to the postgres database using the following command:

    connect-to-postgres

Verify that the record exists

    SELECT * from "ApplianceConfig" WHERE val->'config'->>'clusterName'='<cluster_name>';

Check the entries for the cluster, you will find Airgap entry is missing.

Run the following command on the postgress to update the airgap fqdn for the cluster(s)

    UPDATE "ApplianceConfig" SET "val" = jsonb_set("val", '{config,airgapFqdn}', '"<airgap_fqdn>"') WHERE "val"->'config'->>'clusterName'='<cluster_name>';

Example of the DB entry before and after the changes:
Before adding airgap FQDN:
{ "_id" : ObjectId("########################"), "config" : { "url" : "[https://##.###.##.###:6443|https://##.###.##.###:6443/]", "clusterName" : "<clusterName>", , "UUID" : "########-####-####-####-############", "version" : "1.22", "kubeSystemUUID" : "########-####-####-####-############", "clusterType" : "WORKLOAD" } , "section" : "kubernetes", "enterprise" : "HybridityAdmin", "organization" : "HybridityAdmin", "lastUpdated" : ISODate("2024-03-20T07:59:24.211Z"),
"lastUpdateEnterprise" : "HybridityAdmin", "lastUpdateOrganization" : "HybridityAdmin", "lastUpdateUser" : "HybridityAdmin", "creationDate" : ISODate("2023-02-16T11:13:18.802Z"), "creationEnterprise" : "HybridityAdmin", "creationOrganization" : "HybridityAdmin", "creationUser" : "HybridityAdmin", "isDeleted" : false }

After updating the changes in DB:
{ "_id" : ObjectId("########################"), "config" : { "url" : "[https://##.###.##.###:6443|https://##.###.##.###:6443/]", "clusterName" : "<clusterName>","kubeconfig" : "", "UUID" : "########-####-####-####-############", "version" : "1.22", "kubeSystemUUID" : "########-####-####-####-############", "clusterType" : "WORKLOAD", "airgapFqdn" : "[name.example.com|http://name.example.com/]" } , "section" : "kubernetes", "enterprise" : "HybridityAdmin", "organization" : "HybridityAdmin", "lastUpdated" : ISODate("2024-03-20T07:59:24.211Z"), "lastUpdateEnterprise" : "HybridityAdmin", "lastUpdateOrganization" : "HybridityAdmin", "lastUpdateUser" : "HybridityAdmin", "creationDate" : ISODate("2023-02-16T11:13:18.802Z"), "creationEnterprise" : "HybridityAdmin", "creationOrganization" : "HybridityAdmin", "creationUser" : "HybridityAdmin", "isDeleted" : false }