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:
TCA 2.3
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.
Update Airgap FQDN for management cluster in TCA-CP DB.
connect-to-postgres
SELECT * from "ApplianceConfig" WHERE val->'config'->>'clusterName'='<cluster_name>';
Check the entries for the cluster, you will find Airgap entry is missing.
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 }