InSpec profile overlay to validate the secure configuration of Oracle MySQL EE 5.7 against CIS's Oracle MySQL EE 5.7 Benchmark 1.0.0 tailored for CMS ARS 3.1 for CMS systems categorized as Moderate.
It is intended and recommended that InSpec and this profile overlay be run from a "runner" host (such as a DevOps orchestration server, an administrative management system, or a developer's workstation/laptop) against the target.
For the best security of the runner, always install on the runner the latest version of InSpec and supporting Ruby language components.
Latest versions and installation options are available at the InSpec site.
Git is required to download the latest InSpec profiles using the instructions below. Git can be downloaded from the Git site.
The following attributes must be configured in an attributes file for the profile to run correctly. More information about InSpec attributes can be found in the InSpec Profile Documentation.
# description: Username MySQL DB Server (e.g., 'root')
user: ''
# description: Password MySQL DB Server (e.g., 'P@ssw0rd1')
password: ''
# description: Hostname MySQL DB Server (e.g., 'localhost')
host: ''
# description: Port MySQL DB Server
port: 3306
# description: List of MySQL database users (e.g., ['root'])
mysql_users: []
# description: Set to true if the MySQL server has a slave configured
is_mysql_server_slave_configured: false
# description: List of MySQL administrative users (e.g., ['root'])
mysql_administrative_users: []
# description: List of MySQL users allows to modify or create data structures (e.g., ['root'])
mysql_users_allowed_modify_or_create: []
When the "runner" host uses this profile overlay for the first time, follow these steps:
mkdir profiles
cd profiles
git clone https://github.com/CMSgov/cms-ars-3.1-moderate-oracle-mysql-ee-5.7-cis-overlay.git
git clone https://github.com/mitre/oracle-mysql-ee-5.7-cis-baseline.git
cd cms-ars-3.1-moderate-oracle-mysql-ee-5.7-cis-overlay
bundle install
cd ..
inspec exec cms-ars-3.1-moderate-oracle-mysql-ee-5.7-cis-overlay --attrs=<path_to_your_attributes_file/name_of_your_attributes_file.yml> --reporter=cli json:<path_to_your_output_file/name_of_your_output_file.json>
For every successive run, follow these steps to always have the latest version of this overlay and dependent profiles:
cd profiles/oracle-mysql-ee-5.7-cis-baseline
git pull
cd ../cms-ars-3.1-moderate-oracle-mysql-ee-5.7-cis-overlay
git pull
bundle install
cd ..
inspec exec cms-ars-3.1-moderate-oracle-mysql-ee-5.7-cis-overlay --attrs=<path_to_your_attributes_file/name_of_your_attributes_file.yml> --reporter=cli json:<path_to_your_output_file/name_of_your_output_file.json>
The JSON results output file can be loaded into heimdall-lite for a user-interactive, graphical view of the InSpec results.
The JSON InSpec results file may also be loaded into a full heimdall server, allowing for additional functionality such as to store and compare multiple profile runs.
- Eugene Aronne
- Danny Haynes
- Alicia Sturtevant
To report a bug or feature request, please open an issue.
This is licensed under the Apache 2.0 license.
This software was produced for the U. S. Government under Contract Number HHSM-500-2012-00008I, and is subject to Federal Acquisition Regulation Clause 52.227-14, Rights in Data-General.
No other use other than that granted to the U. S. Government, or to those acting on behalf of the U. S. Government under that Clause is authorized without the express written permission of The MITRE Corporation.
For further information, please contact The MITRE Corporation, Contracts Management Office, 7515 Colshire Drive, McLean, VA 22102-7539, (703) 983-6000.
- This project is dual-licensed under the terms of the Apache license 2.0 (apache-2.0)
- This project is dual-licensed under the terms of the Creative Commons Attribution Share Alike 4.0 (cc-by-sa-4.0)