Zum Hauptinhalt springen

Secret Migration Plan

Migrate all hardcoded secrets from source code repositories to Azure Key Vault (AKV).

πŸ€– Generated with Claude Code

⚠️ Not yet reviewed

Co-Authored-By: Claude (noreply@anthropic.com)

Overview​

  • Organization: togethercca
  • Project: tis-cca
  • Total Repositories: 171
  • Target: Azure Key Vault per environment
  • Tool: tis-secrets migrate (see README.md)
  • Created: 2026-02-19

Environments​

EnvKey Vault
Developmentat-tgca-tis-d-default
Fachtestat-tgca-tis-f-default
Prodat-tgca-tis-p-default

Tasks per Repository​

For each repository the following steps must be completed:

  1. DEV - Migrate secrets to Development Key Vault
  2. FT - Migrate secrets to Fachtest Key Vault
  3. PROD - Migrate secrets to Prod Key Vault
  4. GIT - Clean git history (remove leaked secrets from all commits)
  5. ROT - Rotate all affected secrets (new passwords, keys, tokens)
  6. LIB - Upgrade tis.hosting library to newest version

Priority Legend​

PriorityMeaning
CriticalExternal-facing, high secret count, identity/auth system
HighExternal-facing or contains DB credentials / API keys
MediumInternal service, limited exposure
LowLibrary, tool, or minimal secret risk
TBDNot yet assessed - needs initial scan
N/ANo secrets expected (documentation, templates, empty repos)

Critical Priority​

#RepositoryDEVFTPRODGITROTLIBNotesChallenges
1tis.identity❌❌❌❌❌❌12+ secrets, 11 OAuth ClientSecrets, DB-Creds, AD-Creds
2cca.intern.configurationManagement❌❌❌❌❌❌124 MB repo - likely contains environment configs

High Priority​

#RepositoryDEVFTPRODGITROTLIBNotesChallenges
3Tis.Partner.UniqaIntegrationβœ…βœ…βœ…βŒβŒβŒ7+ secrets, RSA Private Key, mTLS password, OAuth2
4tis.identity.legacy.tisoauth❌❌❌❌❌❌2 secrets, plaintext DB creds (shared omds account β€” password redacted, see Notes).NET Framework app with multiple projects
5TIS-Anmeldung❌❌❌❌❌❌6 secrets, SQL creds in Web.config, SalesManago keys.NET Framework 4.8 application
6api.servicebytogether.atβœ…βœ…βœ…βŒβŒβŒ3 secrets, OAuth2 ClientSecret, AI keys
7tis.anmeldungβœ…βœ…βœ…βŒβŒβœ…6 secrets, CCA-Online Secret identical across DEV/FT/PROD
8tis-cca.endkundenportal❌❌❌❌❌❌4 secrets, DB password, WebSMS ApiKeyDoes not use tis.hosting yet
9Tis.Partner.RiskineIntegrationβœ…βœ…βœ…βŒβŒβŒ5+ secrets, OAuth2, Prod DB password, BasicToken
10Tis.Partner.GraweIntegrationβœ…βœ…βœ…βŒβŒβŒ4 secrets, Grawe OAuth2, TIS Introspection Secret
11Tis.Partner.ZuerichIntegrationβœ…βœ…βœ…βŒβŒβŒ4 secrets, ApiGateway ClientSecret, Prod creds in repo
12Tis.Partner.AllianzIntegrationβœ…βœ…βœ…βŒβŒβŒ5 secrets, DB password, hardcoded DataProtection password
13Tis.Partner.HDIIntegrationβœ…βœ…βœ…βŒβŒβŒ4 secrets, DB password, hardcoded DataProtection "secret"
15Tis.Partner.MukiIntegrationβœ…βœ…βœ…βŒβŒβŒ2 secrets, OAuth2 ClientSecrets
16Tis.Partner.WuestenrotIntegrationβœ…βœ…βœ…βŒβŒβŒ2 secrets, OAuth2, cert password same across all envs
17Tis.Partner.VAVIntegrationβœ…βœ…βœ…βŒβŒβŒ2 secrets, VAV OAuth2, missing FT/Prod separation
18tis.core.services❌❌❌❌❌❌7 secrets, DB creds (shared omds account β€” password redacted) in 7 appsettings.NET Standard application

Medium Priority​

#RepositoryDEVFTPRODGITROTLIBNotesChallenges
19Tis.Hosting.ApiGatewayβœ…βœ…βœ…βŒβŒβœ…3 secrets, AdminPassword, AI ConnectionStrings
20tis.identity.apiβœ…βœ…βœ…βŒβŒβŒTBD - identity API, likely has secrets
21Tis.Identity.Benutzerverwaltungβœ…βœ…βœ…βŒβŒβŒTBD - user management, likely has secrets
22Tis.Identity.Makleradminβœ…βœ…βœ…βŒβŒβŒTBD - admin tool, likely has secrets
23tis.identity.oeamtcselfserviceβœ…βœ…βœ…βŒβŒβŒTBD - external-facing self-service
24tis.identity.ovbselfserviceβœ…βœ…βœ…βŒβŒβŒTBD - external-facing self-service
25tis.identity.trustcenter❌❌❌❌❌❌TBD - certificate/trust related
26tis.identity.benutzeranlage❌❌❌❌❌❌TBD - user provisioningStill on .NET Core 2.1 β€” requires framework upgrade before or during migration
27Tis.Identity.Legacy.TisAuthCookieSessionService❌❌❌❌❌❌TBD - legacy auth serviceDoes not use tis.hosting.extensions yet
28tis.identity.Legacy.TisUser❌❌❌❌❌❌TBD - legacy user service.NET Framework 4.7
29tis.identity.certificate.installer❌❌❌❌❌❌TBD - certificate management.NET Framework 4.8
31tis.riskine.anmeldungβœ…βœ…βœ…βŒβŒβœ…No secrets found
32Tis.Partner.GeneraliIntegrationβœ…βœ…βœ…βŒβŒβŒTBD - partner integration
33tis.partner.VigIntegrationβœ…βœ…βœ…βŒβŒβŒTBD - partner integration
35Tis.Hosting.ApiGateway.config❌❌❌❌❌❌TBD - API gateway configuration
36Tis.Hosting.Extensions❌❌❌❌❌❌TBD - hosting extensions (may contain config)
37tis.hosting.shellβœ…βœ…βœ…βœ…βœ…βœ…TBD - hosting shell
40tis.gf.apiβœ…βœ…βœ…βŒβŒβœ…TBD - GF API serviceUses tis.core libraries; references vulnerable RestSharp version
41tis.gfβœ…βŒβŒβŒβŒβœ…TBD - main GF applicationTODO: re-run tests when DB server is back online
42tis.gf.bpβœ…βœ…βœ…βœ…βœ…βœ…No secrets found
43tis.gf.bp.oeamtc❌❌❌❌❌❌TBD - OEAMTC business processNUnit tests not showing correctly in VS2025 Test Explorer
48tis.gf.erv❌❌❌❌❌❌TBD - electronic legal transactionsLeopoldo currently working on this app β€” revisit in a few days
49tis.gf.esign❌❌❌❌❌❌TBD - e-signature (89 MB, likely has cert secrets)Projects split across 3 solutions β€” should be consolidated into one per project-structure.md guidelines; do this in a session with Leopoldo (scheduled 2026-03-17)
51tis.gf.oeamtcUnfallβœ…βœ…βœ…βœ…βœ…βœ…No pre-existing secrets
52tis.gf.omds3.vigong❌❌❌❌❌❌TBD - VIG ONG integrationMigration deferred until 2026-03-16 (active development this week); keep upgrades minimal β€” app will be deprecated in favor of VigIntegration
55tis.gf.smr5❌❌❌❌❌❌TBD - SMR5 (104 MB)Complex app with many projects β€” discuss with Michael Hingel
56tis.gf.stornoansuchenβœ…βœ…βœ…βŒβŒβœ…TBD - cancellation requestsUses tis.core libraries
57tis.gf.trws❌❌❌❌❌❌TBD - TRWSCheck if still in use before migrating
59tis.gf.uniqa.service❌❌❌❌❌❌TBD - UNIQA service integrationCheck if still in use before migrating
60tis.gf.wgpβœ…βœ…βœ…βŒβŒβŒTBD - WGPCheck telemetry setup with Moritz
64tis.mandanten.vermittlerweb3βœ…βœ…βœ…βŒβŒβœ…TBD - broker web v3
66tis.monitoring.dashboard❌❌❌❌❌❌TBD - monitoring (may have connection strings)Fix invalid characters issue first
69tis.services.vertreiberkategorie❌❌❌❌❌❌TBD - distributor category service
70tis.bestand.bestandsuebersichtβœ…βœ…βœ…βŒβŒβœ…TBD - portfolio overview
71tis.bestand.klauselserviceβœ…βœ…βœ…βŒβŒβœ…TBD - clause service
73tis.bestand.omdsCollector❌❌❌❌❌❌TBD - OMDS collectorWindows Service, not ASP.NET β€” no tis.hosting support
74tis.bestand.omdsdownload❌❌❌❌❌❌TBD - OMDS download.NET Framework 4.6.2 application
75tis.bestand.omdsFileUpload❌❌❌❌❌❌TBD - OMDS file upload.NET Framework 4.6.1 application
77tis.benutzer.druckdaten❌❌❌❌❌❌TBD - user print data.NET Core 2.1 β€” requires framework upgrade before or during migration
78tis.datenverarbeitung.dbServices❌❌❌❌❌❌TBD - DB services (likely has connection strings)
79tis.datenverarbeitung.ftpServices❌❌❌❌❌❌TBD - FTP services (likely has FTP creds)
80tis.datenverarbeitung.tools❌❌❌❌❌❌TBD - data processing tools.NET Framework 4.0 β€” check if still in use before migrating
84tis.volltextsuche❌❌❌❌❌❌TBD - full-text search
85tis.pdftransformer.apiβœ…βœ…βœ…βœ…βœ…βœ…No secrets found
88tis.aduserunlockservice❌❌❌❌❌❌TBD - AD user unlock (likely has AD creds).NET Core 2.1 β€” requires framework upgrade before or during migration
89tis.userprofileβœ…βœ…βœ…βŒβŒβœ…TBD - user profile service
90tis.userabgleichβœ…βŒβŒβŒβŒβœ…TBD - user reconciliation
91tis.hybridgui.notificationsβœ…βŒβŒβŒβŒβœ…TBD - notification servicePROD deployment requires confirmation from Leopoldo
92Tis.Omds3.DeepLinkβœ…βœ…βœ…βŒβŒβœ…TBD - OMDS3 deep link service
95tis.omdsx2024❌❌❌❌❌❌TBD - OMDS X 2024Multiple active branches β€” deferred for later
120tis.ssis.schnittstellen❌❌❌❌❌❌TBD - SSIS interfacesAsk Karl if still in use
123ucl.tarifrechner❌❌❌❌❌❌TBD - UCL tariff calculator.NET Framework 4.5

Low Priority​

#RepositoryDEVFTPRODGITROTLIBNotesChallenges
124tis.core❌❌❌❌❌❌TBD - core library
125tis.core.legacy.cca-aspose❌❌❌❌❌❌TBD - Aspose license key?
126tis.cads.api.client❌❌❌❌❌❌TBD - API client library.NET Standard 2.1
129tis.identity.extensions.iis❌❌❌❌❌❌TBD - IIS extension.NET Framework 4.6.2
132tis.pdftransformer.clientβœ…βŒβŒβœ…βœ…βœ…No secrets found
133tis.services.pdftransformer.api.client❌❌❌❌❌❌TBD - PDF API client lib
134tis.tarifconf.api.client❌❌❌❌❌❌TBD - tariff config client (empty)
135tis.tarifconf.api.type❌❌❌❌❌❌TBD - type definitions only
136tis.cmnkeyvalues-parent❌❌❌❌❌❌TBD - key-value parent module
137tis.tools.clienthelper❌❌❌❌❌❌TBD - client helper tool
138tis.utils.appsettings❌❌❌❌❌❌TBD - appsettings utility
139Tis.Utils.AspNetCore.ApplicationInsights❌❌❌❌❌❌TBD - App Insights utility
140tis.utils.mapstruct❌❌❌❌❌❌TBD - MapStruct utility
141tis.utils.windowsupdate❌❌❌❌❌❌TBD - Windows Update utility
142tiscca.bundle-loading❌❌❌❌❌❌TBD - bundle loading
143tiscca.config-utils❌❌❌❌❌❌TBD - config utility
144tiscca.global-utils❌❌❌❌❌❌TBD - global utilities
145tiscca.jaxb-handler❌❌❌❌❌❌TBD - JAXB handler
146tiscca.json-helper❌❌❌❌❌❌TBD - JSON helper
147tiscca.userdata-modules❌❌❌❌❌❌TBD - user data modules
150tis.omds3.error-types❌❌❌❌❌❌TBD - OMDS3 error types
151tis-cca.omds.core❌❌❌❌❌❌TBD - OMDS core library
152tis-cca.omds.omds3client❌❌❌❌❌❌TBD - OMDS3 client (37 MB)
153tiscca.cads-parent❌❌❌❌❌❌TBD - CADS parent module (100 MB)
154tis-cca.DataUtils.Filtering❌❌❌❌❌❌TBD - data filtering utility
155tis-cca.DataUtils.Paging❌❌❌❌❌❌TBD - data paging utility

Archived / Disabled Repositories​

These repositories are archived or disabled and are out of scope for the migration.

#RepositoryNotes
30tis.identity.certificate.ScepEnrollmentServiceDisabled (archived repo)
34Tis.Partner.ApiInactive repo β€” last edited ~3 years ago, no pipelines
44tis.gf.bpr5Legacy/disabled, unused repo
45tis.gf.dochandlerLegacy/disabled, unused repo
47tis.gf.dpaLegacy repo β€” replaced by tis.gf.wgp
50tis.gf.fbaLegacy repo β€” replaced by tis.gf.wgp
53tis.gf.omds3engine.integrationserviceDisabled repo
61tis.gf.zahlungsaenderungLegacy app β€” functionality now part of tis.gf.wgp
58tis.gf.uniqa.omds3RequestForwarderLegacy repo
62tis.gf.gfweitergabeIncomplete rewrite attempt β€” untouched for 2 years, out of scope
63tis.gf.abgleichNo longer in use (confirmed by Michael Hingel)
65tis.vermittlerweb2Obsolete
67tis.makler.vertreiberkategorieLegacy repo β€” replaced by tis.services.vertreiberkategorie
72tis.bestand.ole.autoOleLegacy app β€” out of scope (587 MB)
76tis.bestand.vnnumcheckLegacy/unused β€” out of scope
81tis.dwhLegacy/disabled β€” out of scope
82tis.dwh.ssas.tabLegacy/disabled β€” out of scope
83tis.intern.datasearchLegacy/disabled β€” out of scope
86tis.xml2pdf.transformer.csharp.pocOld POC project β€” out of scope
87tis.schedulerLegacy β€” out of scope
96tis.omds3.smr5.adapterDisabled (archived repo)
97tis.omds3.smR5AdataperDisabled (archived repo)
107tis-ccaDisabled (archived repo)
101tiscca.kisservice.v2Disabled (.NET Framework 4.0)
114cca.omdsmergeDisabled (archived repo)
116tis.ssis.datenverarbeitungDisabled (archived repo)
117tis.ssis.etlDisabled (archived repo)
118tis.ssis.etl-internDisabled (archived repo)
119tis.ssis.reportsDisabled (archived repo)
169tis-cca.ui.angularjsDisabled (legacy AngularJS UI)

Out of Scope β€” Non-.NET/C# Applications​

These repositories are not .NET/C# applications and are out of scope for this phase of the migration. They are listed here for tracking purposes and will be addressed in a future phase.

#RepositoryPriorityNotesChallenges
14tiscca.omds3servicesHigh2 secrets, omds3.api Secret in 4 configsJava application
38tis.hguimenu.apiMediumTBD - hybrid GUI menu APIJava application
39tis.hguimenu.webconfigMediumTBD - web.config may contain secretsJava application
46tis.gf.document-creatorMediumTBD - document creatorJava application
54tis.gf.readonlyMediumTBD - readonly GFJava application
68tis.services.cads54MediumTBD - CADS serviceJava application
93tis.omds3services.deeplinkMediumTBD - OMDS3 deep linkJava application
94tis.omds3services.donauMediumTBD - OMDS3 Donau integrationJava application
98tis.omds3.gli.evpconnect.proxyMediumTBD - GLI EVP connect proxyJava application
99tis.omds3.gli.kfz.proxyMediumTBD - GLI KFZ proxyJava application
100tiscca.omds3services-vigong-parentMediumTBD - VIG ONG parent (28 MB)Java application
102tiscca.cads.tarifconfig.apiMediumTBD - tariff config APIJava application
103tiscca.cads.webuiMediumTBD - CADS web UI (51 MB)Java application
104tiscca.cads.webui-oeamtcMediumTBD - CADS OEAMTC web UIJava application
105tiscca.cads.dataviewMediumTBD - CADS data viewJava application
106tiscca.cads.oeamtcMediumTBD - CADS OEAMTCJava application
108tis-cca.admin-dashboardMediumTBD - admin dashboardAngular application β€” check if still in use
109tis-cca.ui.angularMediumTBD - Angular UIAngular application
110tis-cca.Infonet.GenerateSitemapMediumTBD - sitemap generatorJavaScript tool (active repo)
111tis.wildfly.config.apiMediumTBD - Wildfly config APIJava application
148tis.wildfly.config.clientLowTBD - Wildfly config clientJava application
149tis.wildfly.config.typesLowTBD - Wildfly config typesJava application
112tiscca.maklerdaten-java.jersey.rest.clientMediumTBD - Java REST clientJava application
113cca.intern.ccaonlineAdminConsoleMediumTBD - admin consoleAngular application
127tis.client.identiyLowTBD - identity client lib (note: typo in repo name)Java application
128tis.idsrv.clientLowTBD - identity server client libJava application
130tis.identity.api.javaclientLowTBD - Java client libJava application
131tis.soagfx.restapis.clientLowTBD - REST API client libJava application

N/A (No Secrets Expected)​

#RepositoryNotes
115Projekte.vig-avag-2025Documentation project, no code
121tis.betrieb.scriptsOperations scripts, no application code
122tis.betrieb.testuserTest data management, no application code
156tis.appinsights.telemetryTelemetry library, no secrets expected
157tis.autopreisspiegel.proxyEmpty repo (0 bytes)
158tis.hybridgui.menuTiny repo (3 KB), UI menu config
159tis.intern.omdsvalidatorValidator tool
160tis.polizzenkopien-parser-pocPOC
161tis.test.uploadTest upload tool
162tis.vs-templatesVisual Studio templates
163tis-cca.ckeditorCKEditor config
164tis-cca.documentationThis documentation repo
165tis-cca.publicwebsitePublic website (11 KB)
166tis-cca.styleguideCSS/SCSS styleguide
167tis-cca.testdata-managementTest data management
168tis-cca.tool.mitschrift.vscodeVS Code extension
170cca.demoDemo repo
171tis.riskine.anmeldungNo secrets found (Riskine login integration)

Progress Summary​

CategoryTotalCompleted (all 6 tasks)In ProgressNot Started
Critical2002
High150114
Medium5242028
Low260125
Archived/Disabled30---
Non-.NET/C#28---
N/A18---
Total17143259

Process​

Before Starting a Repo​

  1. Clone/pull the repository
  2. Run tis-secrets migrate --dry-run to identify secrets
  3. Update priority and notes in this document based on findings

Migration Steps per Environment​

  1. Run tis-secrets migrate -v <vault> -p <prefix> -e <env> for each environment
  2. Verify the application starts and functions correctly with AKV references
  3. Mark the environment checkbox as complete

Git History Cleanup​

  1. Use git filter-repo or BFG Repo Cleaner to remove secrets from history
  2. Force-push the cleaned history
  3. Notify all developers to re-clone

Secret Rotation​

  1. Generate new secrets/passwords/keys for all affected credentials
  2. Update the new values in Azure Key Vault
  3. Update any external systems (partner APIs, databases) with new credentials
  4. Verify application functionality after rotation
  5. Mark rotation checkbox as complete

Notes​

Redacted credential. Earlier revisions of this file and of _migration-brainstorming.md carried the plaintext password of the shared omds database account. The value is removed from both files, but it remains in the git history of this repository β€” redaction is not rotation. Rotating that account is the only fix that matters; until then, treat the password as compromised.

  • Repos marked TBD need an initial assessment with tis-secrets migrate --dry-run
  • Priority assignments for assessed repos are based on _migration-brainstorming.md (working material, not published)
  • Some repos may be reclassified after assessment (e.g., Medium -> High if secrets are found)
  • Empty or archive repos may be moved to N/A after verification