Move mariadb logs to volume for heka collecting

Change-Id: I68a9679e1d88fde410815daac05a612c6f56cbb4
Depends-On: I2b879fa3d10e25c51c8aab8dfc2e11560f5c89f8

docker/mariadb/mariadb_sudoers

@@ -1 +1 @@
-%microservices ALL=(root) NOPASSWD: /bin/chown mysql\: /var/lib/mysql, /usr/bin/chown mysql\: /var/lib/mysql, /opt/ccp/bin/mariadb-security-reset.expect
+%microservices ALL=(root) NOPASSWD: /bin/chown mysql\: /var/lib/mysql, /bin/chown mysql\:mysql /var/log/ccp/mysql, /opt/ccp/bin/mariadb-security-reset.expect

service/files/my.cnf.j2

@@ -3,7 +3,7 @@ bind-address = {{ network_topology["private"]["address"] }}
 port = {{ mariadb_port }}
 
 datadir=/var/lib/mysql/
-log-error=/var/log/mysql.log
+log-error=/var/log/ccp/mysql/mysql.log
 max_connections=10000
 
 log-bin=mariadb-bin

service/mariadb.yaml

@@ -10,7 +10,14 @@ service:
       probes:
         readiness: /opt/ccp/bin/mariadb-readiness.sh
         liveness: "true"
+      volumes:
+      - name: mysql-logs
+        path: /var/log/ccp/mysql
+        type: host
+        readOnly: False
       pre:
+        - name: chown-logs-dir
+          command: sudo /bin/chown mysql:mysql /var/log/ccp/mysql
         - name: mariadb-bootstrap
           command: /opt/ccp/bin/mariadb-bootstrap.sh
       daemon:
@@ -20,7 +27,6 @@ service:
             - mariadb-readiness
             - mariadb-bootstrap
             - mariadb-security-reset.expect
-
 files:
   mariadb-my-cnf:
     path: /etc/mysql/my.cnf