Credential Management

Overview

We store all IT and DevOps-related credentials in Google Sheets. Each project has its own set of credentials, and these are kept in specific folders in Google Drive.

2. Project-Specific Credential Sheets

  • Each project has its own sheet to store details like:
    • Node information: IP addresses, ports, and hostnames.
    • Service passwords: MySQL, Scylla, Jenkins, and monitoring tool passwords.
  • These sheets are saved in folders for each project. All project folders are kept inside the Infra folder in Google Drive.

Folder Structure

Infra/
   ├── Elitical/
   │     └── Elitical-keys.xlsx
   ├── Panchayatseva/
   │     └── Panchayatseva-keys.xlsx
   ├── Eagleeyeview/
   │     └── Eagleeyeview-keys.xlsx
   └── ... (other projects)

3. Combined Credential Sheet

  • To make things simple, we combined all project credential sheets into one file called SAYUKTH-IT-KEYS.
  • This file has two tabs:
    1. IT Infra Details: For IT-related information.
    2. DevOps Infra Details: For tools and services used by DevOps.

Location

The SAYUKTH-IT-KEYS file is saved in:
Infra > SaYukth > IT Admin > SAYUKTH-IT-KEYS

Infra/
   ├── SaYukth/
   │     ├── IT Admin/
   │     │     └── SAYUKTH-IT-KEYS.xlsx
   │     └── DevOps-Credentials.xlsx

3. DevOps Credential Sheet

  • Another file, DevOps-Credentials, is used to store credentials for tools like Jenkins, SonarQube, and Grafana.
  • It also includes usernames and passwords for employees.

Location

The DevOps-Credentials file is saved in:
Infra > SaYukth > DevOps-Credentials

Infra/
   ├── SaYukth/
   │     └── DevOps-Credentials.xlsx