From ef2540ceec02ca6c54b2a9ea7e78a9171379086b Mon Sep 17 00:00:00 2001
From: Jesse Luehrs <doy@tozt.net>
Date: Tue, 27 Aug 2019 02:33:37 -0400
Subject: migrate metabase to postgres

---
 modules/metabase/files/metabase.service |  6 ++++++
 modules/metabase/manifests/init.pp      | 17 ++++++++++++++++-
 2 files changed, 22 insertions(+), 1 deletion(-)

diff --git a/modules/metabase/files/metabase.service b/modules/metabase/files/metabase.service
index ce684cc..0adfd0a 100644
--- a/modules/metabase/files/metabase.service
+++ b/modules/metabase/files/metabase.service
@@ -6,6 +6,12 @@ After=network.target postgresql.service
 WorkingDirectory=/media/persistent/metabase
 User=metabase
 Environment=MB_JETTY_HOST=127.0.0.1
+Environment=MB_DB_TYPE=postgres
+Environment=MB_DB_DBNAME=metabase
+Environment=MB_DB_PORT=5432
+Environment=MB_DB_USER=metabase
+Environment=MB_DB_PASS=
+Environment=MB_DB_HOST=localhost
 ExecStart=java -jar /opt/metabase/metabase.jar
 
 [Install]
diff --git a/modules/metabase/manifests/init.pp b/modules/metabase/manifests/init.pp
index 8c5d7db..f4431b6 100644
--- a/modules/metabase/manifests/init.pp
+++ b/modules/metabase/manifests/init.pp
@@ -54,12 +54,27 @@ class metabase {
     ];
   }
 
+  exec { "create metabase application db":
+    provider => shell,
+    command => "createdb -U metabase metabase",
+    user => 'postgres',
+    unless => "psql -Atc 'select datname from pg_catalog.pg_database' | grep -F metabase",
+    require => [
+      Exec["create metabase db user"],
+      Package["postgresql"],
+      Service["postgresql"],
+    ];
+  }
+
   service { "metabase":
-    ensure => running,
+    ensure => stopped,
     require => [
       Package["jre-openjdk-headless"],
       File["/usr/lib/systemd/system/metabase.service"],
       File["/media/persistent/metabase"],
+      Exec["download metabase"],
+      Exec["create metabase db user"],
+      Exec["create metabase application db"],
     ];
   }
 }
-- 
cgit v1.2.3-54-g00ecf