Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. This guide assumes that you have cloned the edX configuration repository and installed the python requirements.
  2. Change to the configuration/playbooks /edx-east directory.

  3. Create a database configuration file named, say db-config.yml, with the following structure.  You will need to customize this for your own purposes including adding strong passwords.  This also assumes that you already have a root account on the MySQL instance you will be using.

    Code Block
    ---
    
    database_connection: &default_connection
      login_host: "localhost"
      login_user: "root"
      login_password: "secret"
    
    DEFAULT_ENCODING: "utf8"
    
    databases:
      edxapp:
        state: "present"
        encoding: "{{ DEFAULT_ENCODING }}"
        <<: *default_connection
      dashboard:
        state: "present"
        encoding: "{{ DEFAULT_ENCODING }}"
        <<: *default_connection
    
    database_users:
      migrate:
        state: "present"
        password: "migrate_secret"
        host: "%"
        privileges:
          - "edxapp%.*:SELECT,INSERT,UPDATE,DELETE,ALTER,CREATE,DROP,INDEX"
          - "dashboard%.*:SELECT,INSERT,UPDATE,DELETE,ALTER,CREATE,DROP,INDEX"
        <<: *default_connection
      dash:
        state: "present"
        password: "dash_secret"
        host: "%"
        privileges:
          - "dashboard.*:SELECT,INSERT,UPDATE,DELETE"
        <<: *default_connection


  4. Run ansible as follows

    Code Block
    ansible-playbook -i 'localhost,' create_db_and_users.yml -e@/path/to/db-config.yml --ask-sudo-pass


...

Content by Label
showLabelsfalse
max5
spacesDEVOPS
showSpacefalse
sortmodified
reversetrue
typepage
cqllabel = "kb-how-to-article" and type = "page" and space = "DEVOPS"
labelskb-how-to-article

Page Properties
hiddentrue


Related issues