diff options
| author | Alex Auvolat <alex@adnab.me> | 2023-04-17 12:24:51 +0200 |
|---|---|---|
| committer | Alex Auvolat <alex@adnab.me> | 2023-04-17 12:24:51 +0200 |
| commit | 7d41074f738de8f9d7a7e910fb1c26ed698373c2 (patch) | |
| tree | 4f9ec3cea7b573d7fe7a90e619453ab3473b6a40 /content/operations/deploiement/app/create_database.md | |
| parent | 1701a090c292f9f3f1894e6844032b3cbe6d15de (diff) | |
| parent | 4a98a21215262f646307113782b3e8762de70660 (diff) | |
| download | guide.deuxfleurs.fr-7d41074f738de8f9d7a7e910fb1c26ed698373c2.tar.gz guide.deuxfleurs.fr-7d41074f738de8f9d7a7e910fb1c26ed698373c2.zip | |
Merge branch 'main' into reduce-image-sizes
Diffstat (limited to 'content/operations/deploiement/app/create_database.md')
| -rw-r--r-- | content/operations/deploiement/app/create_database.md | 34 |
1 files changed, 0 insertions, 34 deletions
diff --git a/content/operations/deploiement/app/create_database.md b/content/operations/deploiement/app/create_database.md deleted file mode 100644 index e5f8a72..0000000 --- a/content/operations/deploiement/app/create_database.md +++ /dev/null @@ -1,34 +0,0 @@ -+++ -title = "Créer une BDD" -description = "Création d'une base de données pour une nouvelle application" -date = 2022-12-22 -dateCreated = 2022-12-22 -weight = 11 -+++ - -## 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 - -This step can also be done using the automated tool `secretmgr.py` in the app folder. - -## 2. Connect to postgres with the admin users - -```bash -# 1. Launch ssh tunnel given in the README -# 2. Make sure you have postregsql client installed locally -psql -h localhost -U postgres -W postgres -``` - -## 3. Create the binded users with LDAP in postgres + the database - -```sql -CREATE USER sogo; -Create database sogodb with owner sogo encoding 'utf8' LC_COLLATE = 'C' LC_CTYPE = 'C' TEMPLATE template0; -``` |