diff options
author | Quentin Dufour <quentin@deuxfleurs.fr> | 2020-09-21 16:29:49 +0200 |
---|---|---|
committer | Quentin Dufour <quentin@deuxfleurs.fr> | 2020-09-21 16:29:49 +0200 |
commit | 9e4e2f7b99ab8816afcf51e9575d75ccf73fb23f (patch) | |
tree | 7219b5a11bec1ce2aa439aa463f414b2f4408184 /op_guide | |
parent | 09fc30214da3febbf9c06a81bd52701f370be67e (diff) | |
download | infrastructure-9e4e2f7b99ab8816afcf51e9575d75ccf73fb23f.tar.gz infrastructure-9e4e2f7b99ab8816afcf51e9575d75ccf73fb23f.zip |
Add plume
Diffstat (limited to 'op_guide')
-rw-r--r-- | op_guide/create_database/README.md | 29 |
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; ``` |