aboutsummaryrefslogtreecommitdiff
path: root/op_guide/create_database
diff options
context:
space:
mode:
authorQuentin Dufour <quentin@deuxfleurs.fr>2020-09-21 16:29:49 +0200
committerQuentin Dufour <quentin@deuxfleurs.fr>2020-09-21 16:29:49 +0200
commit9e4e2f7b99ab8816afcf51e9575d75ccf73fb23f (patch)
tree7219b5a11bec1ce2aa439aa463f414b2f4408184 /op_guide/create_database
parent09fc30214da3febbf9c06a81bd52701f370be67e (diff)
downloadinfrastructure-9e4e2f7b99ab8816afcf51e9575d75ccf73fb23f.tar.gz
infrastructure-9e4e2f7b99ab8816afcf51e9575d75ccf73fb23f.zip
Add plume
Diffstat (limited to 'op_guide/create_database')
-rw-r--r--op_guide/create_database/README.md29
1 files changed, 19 insertions, 10 deletions
diff --git a/op_guide/create_database/README.md b/op_guide/create_database/README.md
index 7084a10..7d49c97 100644
--- a/op_guide/create_database/README.md
+++ b/op_guide/create_database/README.md
@@ -1,15 +1,24 @@
+## 1. Create a LDAP user and assign a password for your service
+
+Go to guichet.deuxfleurs.fr
+
+ 1. Everything takes place in `ou=services,ou=users,dc=deuxfleurs,dc=fr`
+ 2. Create a new user, like `johny`
+ 3. Generate a random password with `openssl rand -base64 32`
+ 4. Hash it with `slappasswd`
+ 5. Add a `userpassword` entry with the hash
+
+## 2. Connect to postgres with the admin users
+
```bash
-ssh root@<one node of the cluster>
-docker run -t -i superboum/amd64_postgres:v1
-psql -h psql-proxy.service.2.cluster.deuxfleurs.fr -p 25432 -U postgres -W postgres
+# 1. Launch ssh tunnel given in the README
+# 2. Make sure you have postregsql client installed locally
+psql -h localhost -U postgres -W postgres
```
-```sql
-CREATE USER seafile;
-CREATE DATABASE seafile ENCODING 'UTF8' LC_COLLATE='C' LC_CTYPE='C' template=template0 OWNER seafile;
--- GRANT ALL PRIVILEGES ON DATABASE seafile TO seafile;
-```
+## 3. Create the binded users with LDAP in postgres + the database
-```
-consul kv import @ldapkv_seafile.json
+```sql
+CREATE USER johny;
+CREATE DATABASE amazingapp OWNER johny;
```