Variables from .env ignored in SQL scripts because of hardcoded values

[holger-stenzhorn]

In rdc/redcap-overrides/mysql/scripts/20_mysql8_permission_update.sql and rdc/redcap-overrides/mysql/scripts/30_update_timezone.sql values are hardcoded instead of using the respective variables defined in .env, i.e. MYSQL_ROOT_PASSWORD, MYSQL_PASSWORD and TZ.

If e.g. the variable MYSQL_PASSWORD is set in .env to a non-default value then this breaks /opt/redcap/rdc/redcap-overrides/web/webroot/REDCapInstaller.php.

20_mysql8_permission_update.sql

ALTER USER 'redcap'@'%' IDENTIFIED WITH mysql_native_password BY 'redcap123';
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'root';

30_update_timezone.sql

SET GLOBAL time_zone = 'America/Los_Angeles';

REDCapInstaller.php

public function __construct() {
        ...
        $this->password = empty($_ENV['MYSQL_PASSWORD']) ? FALSE : $_ENV['MYSQL_PASSWORD'];
        ...