Page Comparison

...

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

   
   

...