aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorMilo Casagrande <milo.casagrande@linaro.org>2014-06-11 12:23:38 +0200
committerMilo Casagrande <milo.casagrande@linaro.org>2014-06-11 12:23:38 +0200
commitecdb954ae89c1261316b307c6417b9af49b58400 (patch)
tree06d0be52864d84628d4b3d849a38b578891f4443
parent082888b88d666b9b8cca4b64daee525216f7ded9 (diff)
downloadlinaro-bugzilla-tools-ecdb954ae89c1261316b307c6417b9af49b58400.tar.gz
Use PostgreSQL instead of MySQL.
Change-Id: I9fbacb6fcc3ffa0b5b590a0a5b49167ab0582b58
-rw-r--r--ansible/group_vars/all2
-rw-r--r--ansible/roles/configure-db/tasks/main.yml12
-rw-r--r--ansible/roles/install-deps/tasks/main.yml7
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