Page MenuHomeDevCentral
Files F3764100

D3461.diff
No OneTemporary
Actions

D3461.diff
View Options

diff --git a/pillar/credentials/vault.sls b/pillar/credentials/vault.sls
--- a/pillar/credentials/vault.sls
+++ b/pillar/credentials/vault.sls
@@ -101,6 +101,9 @@
vault_secrets_by_role:
devserver:
+ - ops/secrets/dbserver/windriver-mariadb/users/*
+ - ops/secrets/dbserver/windriver-pgsql/users/*
+
- ops/secrets/nasqueron/notifications/notifications-cli/%%node%%
- ops/secrets/nasqueron/deploy/deploy_keys/alken-orin
diff --git a/pillar/dbserver/windriver.sls b/pillar/dbserver/windriver.sls
new file mode 100644
--- /dev/null
+++ b/pillar/dbserver/windriver.sls
@@ -0,0 +1,44 @@
+# -------------------------------------------------------------
+# Database configuration for devserver
+# - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
+# Project: Nasqueron
+# License: Trivial work, not eligible to copyright
+# -------------------------------------------------------------
+
+# -------------------------------------------------------------
+# MySQL (MariaDB)
+# - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
+
+dbserver_mysql:
+
+ server:
+ salt:
+ # Account used by Salt to configure the server
+ credentials: dbserver/windriver-mariadb/users/salt
+
+ # As of 2024-09, users and databases are managed manually
+ # You're most than welcome to automate any user/db deployment here.
+ # cluster-B.sls can be helpful for syntax hints
+ users: {}
+ databases: {}
+
+# -------------------------------------------------------------
+# PostgreSQL
+# - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
+
+dbserver_postgresql:
+
+ server:
+ cluster: windriver
+
+ # Fantoir database needs the pg_trgm extension
+ with_contrib: True
+
+ listen_addresses: "*"
+
+ # As of 2024-09, users and databases are managed manually
+ # You're most than welcome to automate any user/db deployment here.
+ # cluster-A.sls can be helpful for syntax hints
+ users: {}
+ databases: {}
+ connections: {}
diff --git a/pillar/tower.sls b/pillar/tower.sls
--- a/pillar/tower.sls
+++ b/pillar/tower.sls
@@ -15,3 +15,6 @@
- saas/nextcloud/{{ minion_id }}/*.sls
- webserver/{{ minion_id }}/*.sls
+
+ # For devserver role, there is no cluster associated
+ - dbserver/{{ minion_id }}.sls

File Metadata

Mime Type
text/plain
Expires
Sat, Nov 23, 04:14 (17 h, 53 m)
Storage Engine
blob
Storage Format
Raw Data
Storage Handle
2257107
Default Alt Text
D3461.diff (2 KB)

Event Timeline

Nasqueron DevCentral · If it had been much bigger the moon would have had a core of ice. · Powered by Phabricator