diff options
author | Milo Casagrande <milo.casagrande@linaro.org> | 2014-06-11 12:23:38 +0200 |
---|---|---|
committer | Milo Casagrande <milo.casagrande@linaro.org> | 2014-06-11 12:23:38 +0200 |
commit | ecdb954ae89c1261316b307c6417b9af49b58400 (patch) | |
tree | 06d0be52864d84628d4b3d849a38b578891f4443 | |
parent | 082888b88d666b9b8cca4b64daee525216f7ded9 (diff) |
Use PostgreSQL instead of MySQL.
Change-Id: I9fbacb6fcc3ffa0b5b590a0a5b49167ab0582b58
-rw-r--r-- | ansible/group_vars/all | 2 | ||||
-rw-r--r-- | ansible/roles/configure-db/tasks/main.yml | 12 | ||||
-rw-r--r-- | ansible/roles/install-deps/tasks/main.yml | 7 |
3 files changed, 11 insertions, 10 deletions
diff --git a/ansible/group_vars/all b/ansible/group_vars/all index 1eaeced..6be714b 100644 --- a/ansible/group_vars/all +++ b/ansible/group_vars/all @@ -2,7 +2,7 @@ install_base: /srv web_user: www-data app_user: www-data git_head: HEAD -db_driver: mysql +db_driver: pg db_host: localhost db_name: bugzilla db_user: bugzilla diff --git a/ansible/roles/configure-db/tasks/main.yml b/ansible/roles/configure-db/tasks/main.yml index 1d3a233..e4e6b98 100644 --- a/ansible/roles/configure-db/tasks/main.yml +++ b/ansible/roles/configure-db/tasks/main.yml @@ -1,11 +1,11 @@ --- -- name: Create MySQL bugzilla database - mysql_db: name={{ db_name }} - state=present - -- name: Create MySQL bugzilla user +- name: Create PostgreSQL bugzilla user mysql_user: name={{ db_user }} password={{ db_pass }} - priv={{ db_name }}.*:ALL state=present +- name: Create PostgrteSQL bugzilla database + postgresql_db: name={{ db_name }} + owner={{ db_user }} + state=present + diff --git a/ansible/roles/install-deps/tasks/main.yml b/ansible/roles/install-deps/tasks/main.yml index 22f0ba7..9348de7 100644 --- a/ansible/roles/install-deps/tasks/main.yml +++ b/ansible/roles/install-deps/tasks/main.yml @@ -6,6 +6,7 @@ with_items: - apache2 - bsd-mailx + - build-essential - git - ldap-utils - libapache2-mod-perl2 @@ -18,7 +19,7 @@ - libdate-calc-perl - libdatetime-perl - libdatetime-timezone-perl - - libdbd-mysql-perl + - libdbd-pg-perl - libdbi-perl - libemail-mime-modifier-perl - libemail-mime-perl @@ -47,9 +48,9 @@ - libxml-perl - libxml-twig-perl - lynx - - mysql-server - perlmagick - - python-mysqldb + - postgresql + - python-psycopg - tree - unzip - xmlto |