Page Menu
Home
DevCentral
Search
Configure Global Search
Log In
Files
F11708210
No One
Temporary
Actions
View File
Edit File
Delete File
View Transforms
Subscribe
Mute Notifications
Award Token
Flag For Later
Size
3 KB
Referenced Files
None
Subscribers
None
View Options
diff --git a/pillar/dbserver/cluster-A.sls b/pillar/dbserver/cluster-A.sls
index ddb814d..09cb006 100644
--- a/pillar/dbserver/cluster-A.sls
+++ b/pillar/dbserver/cluster-A.sls
@@ -1,160 +1,160 @@
dbserver_postgresql:
server:
cluster: A
# Fantoir database needs the pg_trgm extension
with_contrib: True
listen_addresses: "*"
users:
# Password paths are relative to ops/secrets/
airflow:
password: dbserver/cluster-A/users/airflow
privileges:
- database: airflow
scope: schema
privileges:
- ALL
corspat:
password: dbserver/cluster-A/users/corspat
privileges:
- database: corspat
scope: schema
privileges:
- ALL
fantoir:
password: dbserver/cluster-A/users/fantoir
privileges:
- database: fantoir
scope: schema
privileges:
- ALL
mailManagement:
password: dbserver/cluster-A/users/mailManagement
privileges:
- database: mail
scope: schema
privileges:
- SELECT
- INSERT
- UPDATE
- DELETE
tables:
- ALL
netbox:
password: dbserver/cluster-A/users/netbox
privileges:
- database: netbox
scope: schema
privileges:
- ALL
openfire:
password: dbserver/cluster-A/users/openfire
privileges:
- database: openfire
scope: schema
privileges:
- ALL
orbeon:
password: dbserver/cluster-A/users/orbeon
privileges:
- database: forms
scope: schema
privileges:
- ALL
- database: forms
scope: table
schema: public
tables:
- ALL
privileges:
- ALL
postfix:
password: dbserver/cluster-A/users/postfix
privileges:
- database: mail
scope: table
schema: public
tables:
- ALL
privileges:
- SELECT
databases:
airflow:
encoding: UTF8
owner: airflow
corspat:
encoding: UTF8
owner: corspat
fantoir:
encoding: UTF8
owner: fantoir
extensions:
- pg_trgm
forms:
encoding: UTF8
owner: orbeon
mail:
encoding: UTF8
owner: mailManagement
netbox:
encoding: UTF8
owner: netbox
openfire:
encoding: UTF8
owner: openfire
# Network connections allowed in pg_hba.conf
connections:
- db: airflow
user: airflow
ips: 172.27.27.0/28
- db: corspat
user: corspat
ips: 172.27.27.5/32
- db: fantoir
user: fantoir
ips: 172.27.27.0/28
- db: forms
user: orbeon
ips: &dwellers 172.27.27.4/32
method: password
- - db: netbox
- user: netbox
- ips: 172.27.27.0/28
-
- - db: openfire
- user: openfire
- ips: &docker002 172.27.27.5/32
+ - db: mail
+ user: mailManagement
+ ips: 172.27.27.5/32
method: password
- db: mail
user: postfix
ips: 172.27.27.3/32
method: password
- - db: mail
- user: mailManagement
- ips: 172.27.27.5/32
+ - db: netbox
+ user: netbox
+ ips: 172.27.27.0/28
+
+ - db: openfire
+ user: openfire
+ ips: &docker002 172.27.27.5/32
method: password
File Metadata
Details
Attached
Mime Type
text/x-diff
Expires
Mon, Sep 15, 05:14 (11 h, 25 m)
Storage Engine
blob
Storage Format
Raw Data
Storage Handle
2983742
Default Alt Text
(3 KB)
Attached To
Mode
rOPS Nasqueron Operations
Attached
Detach File
Event Timeline
Log In to Comment