From bf7f6e9ab7e65e3cfb60d09e2c1401ed95d6868e Mon Sep 17 00:00:00 2001
From: Tim Pierce <twp@clinicalfuture.com>
Date: Tue, 5 Nov 2013 13:43:34 -0500
Subject: [PATCH] Use PostgreSQL, not MySQL.

---
 docker/base/Dockerfile   | 17 +++++++----------
 docker/base/database.yml |  6 +++---
 2 files changed, 10 insertions(+), 13 deletions(-)

diff --git a/docker/base/Dockerfile b/docker/base/Dockerfile
index cb5e9a251c..a936715ce6 100644
--- a/docker/base/Dockerfile
+++ b/docker/base/Dockerfile
@@ -6,7 +6,7 @@ MAINTAINER Tim Pierce <twp@clinicalfuture.com>
 
 # TODO(twp): parameterize variables via autoconf or similar.
 ENV RUBY_VERSION_NUM   2.0.0
-ENV MYSQL_ROOT_PW      dummy_pw
+ENV POSTGRES_ROOT_PW   dummy_pw
 
 ENV ARVADOS_DEV_DB     arvados_development
 ENV ARVADOS_DEV_USER   arvados
@@ -20,17 +20,10 @@ ENV ARVADOS_PROD_DB    arvados_production
 ENV ARVADOS_PROD_USER  arvados
 ENV ARVADOS_PROD_PW    dummy_pw
 
-# Need to set the mysql passwords before installing mysql-server
-ENV MYSQL_ROOT_PW dummy_pw
-ENV DEBIAN_FRONTEND noninteractive
-RUN (echo mysql-server mysql-server/root_password password ${MYSQL_ROOT_PW} ; \
-     echo mysql-server mysql-server/root_password_again password ${MYSQL_ROOT_PW}) \
-    | debconf-set-selections
-
 # Install prerequisite packages for Arvados
 RUN apt-get update
-RUN apt-get install -q -y apt-utils
-RUN apt-get install -q -y git curl procps mysql-server
+RUN apt-get -q -y install -q -y apt-utils
+RUN apt-get -q -y install git curl procps postgresql apache2
 RUN curl -L https://get.rvm.io | bash -s stable --ruby=${RUBY_VERSION_NUM}
 
 # Set up RVM environment. These are just the env variables created by
@@ -54,3 +47,7 @@ RUN gem install rails
 
 # Download Arvados source.
 RUN git clone git://github.com/clinicalfuture/arvados.git /usr/src/arvados
+
+# Configure databases and users.
+ADD postgresql_config.sh /tmp/postgresql_config.sh
+RUN /tmp/postgresql_config.sh
diff --git a/docker/base/database.yml b/docker/base/database.yml
index 5081ce5c0b..4276240b2c 100644
--- a/docker/base/database.yml
+++ b/docker/base/database.yml
@@ -1,5 +1,5 @@
 development:
-  adapter: mysql
+  adapter: postgresql
   encoding: utf8
   database: arvados_development
   username: arvados
@@ -7,7 +7,7 @@ development:
   host: localhost
 
 test:
-  adapter: mysql
+  adapter: postgresql
   encoding: utf8
   database: arvados_test
   username: arvados
@@ -15,7 +15,7 @@ test:
   host: localhost
 
 production:
-  adapter: mysql
+  adapter: postgresql
   encoding: utf8
   database: arvados_production
   username: arvados
-- 
2.30.2