Modifies POL deployment to use mysql database

Adds script to automatically create database if not existant.
Adds generation of db env var to install script.

Change-Id: I334ffe2a2f9c2570cf94454948e23f1ce4b5aee7
Signed-off-by: Benjamin Diaz <bdiaz@whitestack.com>
diff --git a/installers/docker/docker-compose.yaml b/installers/docker/docker-compose.yaml
index 3a879ad..b1f0cc8 100644
--- a/installers/docker/docker-compose.yaml
+++ b/installers/docker/docker-compose.yaml
@@ -148,9 +148,10 @@
     volumes:
       - pol_db:/app/database
     environment:
-      OSMPOL_SQL_DATABASE_URI: sqlite:///app/database/policy_module.db
       OSMPOL_MESSAGE_HOST: kafka
       OSMPOL_MESSAGE_PORT: 9092
+    env_file:
+      - ./pol.env
     #depends_on:
     #  - kafka
     #  - mon
diff --git a/installers/full_install_osm.sh b/installers/full_install_osm.sh
index a48bd4d..6381c7e 100755
--- a/installers/full_install_osm.sh
+++ b/installers/full_install_osm.sh
@@ -822,6 +822,11 @@
         $WORKDIR_SUDO sed -i "s|OSMMON_VCA_SECRET.*|OSMMON_VCA_SECRET=$OSM_VCA_SECRET|g" $OSM_DOCKER_WORK_DIR/mon.env
     fi
 
+    # POL
+    if [ ! -f $OSM_DOCKER_WORK_DIR/pol.env ]; then
+        echo "OSMPOL_SQL_DATABASE_URI=mysql://root:${MYSQL_ROOT_PASSWORD}@mysql:3306/pol" | $WORKDIR_SUDO tee -a $OSM_DOCKER_WORK_DIR/pol.env
+    fi
+
     echo "Finished generation of docker env files"
 }