cost-allocation: Re-factor cost-allocation

[emirgens]

Re-factor cost allocation to follow the new structure for infrastructure

• cost-allocation: Migrate secrets to External Secret Operator #1225
• cost-allocation: Configure audit logging for SQL #1227
• cost-allocation: Rename sql resources - platform #1186
• cost-allocation: Rename sql resources - c2 #1190
• cost-allocation: Remove unused secrets #1195
• Delete obsolete App. reg. (if any)
• Evaluate any hardening of the SQL server and database
• Update documentation (radix-private) cost-allocation #1257

Order of things

• ## Create new resources (resources with new name, transfer data when starting to use it)
  • Keep legacy users and databases, install MI on all servers, old and new
  • Create MI and federated credentials for Github and Kubernetes
• ## Use the new resources
  • Upgrade API to MI
    kubectl patch rr radix-cost-allocation-api -p '{"spec":{"radixConfigFullName":"radixconfig.dev.yaml"}}' --type merge --context weekly-11 kubectl patch rr radix-cost-allocation-api -p '{"spec":{"radixConfigFullName":"radixconfig.dev.yaml"}}' --type merge --context weekly-12 kubectl patch rr radix-cost-allocation-api -p '{"spec":{"radixConfigFullName":"radixconfig.platform.yaml"}}' --type merge --context eu-18 kubectl patch rr radix-cost-allocation-api -p '{"spec":{"radixConfigFullName":"radixconfig.playground.yaml"}}' --type merge --context playground-11 kubectl patch rr radix-cost-allocation-api -p '{"spec":{"radixConfigFullName":"radixconfig.c2.yaml"}}' --type merge --context c2-prod-25 kubectl patch rr radix-cost-allocation-api -p '{"spec":{"radixConfigFullName":"radixconfig.c2.yaml"}}' --type merge --context c2-11
  • Upgrade Flux
  • Upgrade Scanner to MI
  • Release API
  • Release Scanner
• ## Cleanup
  • Migrate to new database (Flux for Scanner, Web-console/Radixconfig for API)
  • Enforce AD Authentication
  • Delete old users
  • Cost Allocation: Update baseline for MS SQL Servers #1256

PRs

• Refactor cost allocation config radix-flux#1953
• Migrate to managed identities radix-cost-allocation#116
• Migrate to workloadidentity radix-cost-allocation-api#110
• Bugfix managed identity name radix-cost-allocation#117
• Fix broken radixconfig templates and names radix-cost-allocation-api#111
• Release Logger, Bugfix, Workload Identity radix-cost-allocation-api#112
• Release Bugfix, Logger, Workload Identity radix-cost-allocation#118
• Rename cost allocation DBs radix-cost-allocation#119
• Rename cost allocation DBs radix-cost-allocation-api#113
• Rename cost allocation DBs radix-flux#1960
• Cost Allocation: Create Managed Identities #1249
• Update Client IDs for new managed identities radix-cost-allocation#120