Projet

Général

Profil

0001-Postgresql-user-fix-and-documentation.patch

Anonyme, 15 février 2018 12:44

Télécharger (2,12 ko)

Voir les différences: 

Subject: [PATCH] Postgresql user fix and documentation


 README.rst                | 21 ++++++++++++++-------
 roles/base/tasks/main.yml |  4 ++++
 2 files changed, 18 insertions(+), 7 deletions(-)
README.rst
1 
Dev install of publik
2 
=====================
1 
Development configuration for publik
2 
====================================
3 3 

  		




  4
  4
  
    
Ansible playbook that install and setup a multitenant publik instance using sources.

  		




  5
  5
  
    

  		




  ......




  19
  19
  
    
System requirements

  		




  20
  20
  
    
+++++++++++++++++++

  		




  21
  21
  
    

  		




  22
  
  
    
  * postgresql server must be installed

  		




  23
  
  
    
  * the system user used to run ansible must be a sudoer

  		




  24
  
  
    
  * the system user used to run ansible must to be able to connect to the postgres server withpout authentication and must be authorized to create databases

  		




  25
  
  
    
  * you need to have a valid SSL certificate ('ssl_certificate' and 'ssl_certificate_key' in configuration file)

  		




  
  22
  
    
* postgresql server must be installed

  		




  
  23
  
    
* the system user used to run ansible must be a sudoer

  		




  
  24
  
    
* configure postgresql in order to have these configuration:

  		




  
  25
  
    

  		




  
  26
  
    
  * the system user is used to run ansible and must to be able to connect to the postgresql server without authentication and must be authorized to create databases

  		




  
  27
  
    
  * postgresql must have a postgres user authorized to connect and create a db.

  		




  
  28
  
    
  * please edit /etc/postgresql/[INSTALLED VERSION]/main/pg_hba.conf and add these lines:

  		




  
  29
  
    

  		




  
  30
  
    
.. code-block:: configuration

  		




  
  31
  
    

  		




  
  32
  
    
  local   all     postgres    trust

  		




  
  33
  
    
  local   all     all         peer

  		




  26
  34
  
    

  		




  27
  
  
    
    

  		




  28
  35
  
    
Description

  		




  29
  36
  
    
===========

  		




  30
  37
  
    

  		












  

    
      roles/base/tasks/main.yml
    
  





  19
  19
  
    
       - supervisor

  		




  20
  20
  
    
  become: yes

  		




  21
  21
  
    

  		




  
  22
  
    
- name: "create the postgresql user named {{user}}"

  		




  
  23
  
    
  postgresql_user:

  		




  
  24
  
    
    name: "{{user}}"

  		




  
  25
  
    

  		




  22
  26
  
    
- name: create the virtualenv and install django

  		




  23
  27
  
    
  pip:

  		




  24
  28
  
    
    name: django

  		




  25
  
  
    
-