# What this PR does Short summary: this PR improves security and configuration management for Helm deployment. Please take a look at the details below. ## Which issue(s) this PR fixes Issues: - Cannot explicitly define redis database (only 0 and 1 numbers are used) - Cannot securely use TLS for Redis (cannot set CA certificate; cannot set client certificates) - Cannot securely use TLS for Postgres (cannot set CA certificate; cannot set client certificates; cannot set `verify-full` validation) - ~~Chart option `securityContext.readOnlyRootFilesystem: true` issues CrashLoopBack pod state~~ will be moved to new PR ## Checklist - [x] ~~Unit, integration, and e2e (if applicable) tests updated~~ (not required) - [x] Documentation added (or `pr:no public docs` PR label added if not required) - [x] `CHANGELOG.md` updated (or `pr:no changelog` PR label added if not required) - [x] Helm tests are fixed and updated - [x] Manually verified the features: - [x] postgres TLS connection with `verify-full` validation - [x] redis TLS connection with `cert_required` validation - [x] redis protocol and database number controls - [x] all containers properly work in read-only root filesystem - [x] all changes are backward compatible (doesn't break old deployments) ## Changelog - Fixed helm tests - Added configuration options for secure TLS communication with dependencies like Redis, MySQL, and Postgres - ~~Added configuration option for relocating `celerybeat` database file (read-only root filesystem issue)~~ will be moved to new PR - Improved redis database configuration options - Now only single redis database is used - Added ability to mount custom volumes (with CA certificates, for example) into Helm chart - ~~Fixed issue with read-only root filesystem for Helm chart~~ will be moved to new PR - Add ability to work with Redis ACL (and AWS ElastiCache)
141 lines
4 KiB
YAML
141 lines
4 KiB
YAML
suite: test MySQL envs for deployments
|
|
templates:
|
|
- engine/deployment.yaml
|
|
- engine/job-migrate.yaml
|
|
- celery/deployment.yaml
|
|
- telegram-polling/deployment.yaml
|
|
release:
|
|
name: oncall
|
|
tests:
|
|
- it: mariadb.enabled=false -> external MySQL default settings
|
|
set:
|
|
telegramPolling.enabled: true
|
|
mariadb.enabled: false
|
|
asserts:
|
|
- contains:
|
|
path: spec.template.spec.containers[0].env
|
|
content:
|
|
name: DATABASE_TYPE
|
|
not: true
|
|
- contains:
|
|
path: spec.template.spec.containers[0].env
|
|
content:
|
|
name: MYSQL_DB_NAME
|
|
value: oncall
|
|
- contains:
|
|
path: spec.template.spec.containers[0].env
|
|
content:
|
|
name: MYSQL_PORT
|
|
value: "3306"
|
|
- contains:
|
|
path: spec.template.spec.containers[0].env
|
|
content:
|
|
name: MYSQL_USER
|
|
value: root
|
|
- contains:
|
|
path: spec.template.spec.containers[0].env
|
|
content:
|
|
name: MYSQL_HOST
|
|
value: oncall-mariadb
|
|
|
|
- it: externalMysql -> use external MySQL custom settings
|
|
set:
|
|
telegramPolling.enabled: true
|
|
mariadb.enabled: false
|
|
externalMysql:
|
|
host: test-host
|
|
port: 5555
|
|
db_name: grafana_oncall
|
|
user: test_user
|
|
asserts:
|
|
- contains:
|
|
path: spec.template.spec.containers[0].env
|
|
content:
|
|
name: MYSQL_DB_NAME
|
|
value: grafana_oncall
|
|
- contains:
|
|
path: spec.template.spec.containers[0].env
|
|
content:
|
|
name: MYSQL_PORT
|
|
value: "5555"
|
|
- contains:
|
|
path: spec.template.spec.containers[0].env
|
|
content:
|
|
name: MYSQL_USER
|
|
value: test_user
|
|
- contains:
|
|
path: spec.template.spec.containers[0].env
|
|
content:
|
|
name: MYSQL_HOST
|
|
value: test-host
|
|
|
|
- it: externalMysql -> use external MySQL custom settings with additional options
|
|
set:
|
|
telegramPolling.enabled: true
|
|
mariadb.enabled: false
|
|
externalMysql:
|
|
host: test-host
|
|
port: 5555
|
|
db_name: grafana_oncall
|
|
user: test_user
|
|
options: "ssl_ca=/mnt/ssl/ca.crt ssl_key=/mnt/ssl/client.key ssl_cert=/mnt/ssl/client.crt"
|
|
asserts:
|
|
- contains:
|
|
path: spec.template.spec.containers[0].env
|
|
content:
|
|
name: MYSQL_OPTIONS
|
|
value: "ssl_ca=/mnt/ssl/ca.crt ssl_key=/mnt/ssl/client.key ssl_cert=/mnt/ssl/client.crt"
|
|
|
|
- it: mariadb.enabled=true -> internal MySQL default settings
|
|
set:
|
|
telegramPolling.enabled: true
|
|
asserts:
|
|
- contains:
|
|
path: spec.template.spec.containers[0].env
|
|
content:
|
|
name: MYSQL_DB_NAME
|
|
value: oncall
|
|
- contains:
|
|
path: spec.template.spec.containers[0].env
|
|
content:
|
|
name: MYSQL_PORT
|
|
value: "3306"
|
|
- contains:
|
|
path: spec.template.spec.containers[0].env
|
|
content:
|
|
name: MYSQL_USER
|
|
value: root
|
|
- contains:
|
|
path: spec.template.spec.containers[0].env
|
|
content:
|
|
name: MYSQL_HOST
|
|
value: oncall-mariadb
|
|
|
|
- it: mariadb.auth -> internal MySQL custom settings
|
|
set:
|
|
telegramPolling.enabled: true
|
|
mariadb:
|
|
auth:
|
|
database: grafana_oncall
|
|
username: grafana_oncall
|
|
asserts:
|
|
- contains:
|
|
path: spec.template.spec.containers[0].env
|
|
content:
|
|
name: MYSQL_DB_NAME
|
|
value: grafana_oncall
|
|
- contains:
|
|
path: spec.template.spec.containers[0].env
|
|
content:
|
|
name: MYSQL_PORT
|
|
value: "3306"
|
|
- contains:
|
|
path: spec.template.spec.containers[0].env
|
|
content:
|
|
name: MYSQL_USER
|
|
value: grafana_oncall
|
|
- contains:
|
|
path: spec.template.spec.containers[0].env
|
|
content:
|
|
name: MYSQL_HOST
|
|
value: oncall-mariadb
|