db-config.yml

db-config.yml

---

database_connection: &default_connection
  login_host: "localhost"
  login_user: "root"
  login_password: "password"

DEFAULT_ENCODING: "utf8"

databases:
  edxapp:
    state: "present"
    encoding: "{{ DEFAULT_ENCODING }}"
    <<: *default_connection
  dashboard:
    state: "present"
    encoding: "{{ DEFAULT_ENCODING }}"
    <<: *default_connection
  edxapp:
    state: "present"
    encoding: "{{ DEFAULT_ENCODING }}"
    <<: *default_connection
  xqueue:
    state: "present"
    encoding: "{{ DEFAULT_ENCODING }}"
    <<: *default_connection
  ora:
    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
  {{ EDXAPP_MYSQL_USER }}:
    state: "present
    password:{{ EDXAPP_MYSQL_PASSWORD }}
    host: "%"
    privileges:
      - '{{ EDXAPP_MYSQL_DB_NAME }}.*:ALL'
  {{ XQUEUE_MYSQL_USER }}:
    state: "present
    password:{{ XQUEUE_MYSQL_PASSWORD }}
    host: "%"
    privileges:
      - '{{ XQUEUE_MYSQL_DB_NAME }}.*:ALL'
  {{ ORA_MYSQL_USER }}:
    state: "present
    password:{{ ORA_MYSQL_PASSWORD }}
    host: "%"
    privileges:
      - '{{ ORA_MYSQL_DB_NAME }}.*:ALL'
  {{ COMMON_MYSQL_MIGRATE_USER }}:
    state: "present
    password:{{ COMMON_MYSQL_MIGRATE_PASS }}
    host: "%"
    privileges:
      - '{{ item }}.*:ALL'
  {{ COMMON_MYSQL_READ_ONLY_USER }}:
    state: "present
    password:{{ COMMON_MYSQL_READ_ONLY_PASS }}
    host: "%"
    privileges:
      - '*.*:ALL'
  {{ COMMON_MYSQL_ADMIN_USER }}:
    state: "present
    password:{{ COMMON_MYSQL_ADMIN_PASS }}
    host: "%"
    privileges:
      - '*.*:CREATE USER'