README.txt

cms-ars-3.1-moderate-oracle-mysql-ee-5.7-cis-overlay
====================================================

InSpec profile overlay to validate the secure configuration of Oracle
MySQL EE 5.7 against [CIS's](https://www.cisecurity.org/cis-benchmarks/)
Oracle MySQL EE 5.7 Benchmark 1.0.0 tailored for [CMS ARS
3.1](https://www.cms.gov/Research-Statistics-Data-and-Systems/CMS-Information-Technology/InformationSecurity/Info-Security-Library-Items/ARS-31-Publication.html)
for CMS systems categorized as Moderate.

Getting Started
---------------

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](http://inspec.io/) 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](https://www.inspec.io/docs/reference/profiles/).

    # 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: [] 

Running This Overlay
--------------------

When the **"runner"** host uses this profile overlay for the first time,
follow these steps:

    mkdir profiles
    cd profiles
    git clone https://github.cms.gov/ispg-dev/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> 

Viewing the JSON Results
------------------------

The JSON results output file can be loaded into
**[heimdall-lite](https://mitre.github.io/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](https://github.com/mitre/heimdall)**, allowing for additional
functionality such as to store and compare multiple profile runs.

Authors
-------

-   Eugene Aronne
-   Danny Haynes

Special Thanks
--------------

-   Alicia Sturtevant

Getting Help
------------

To report a bug or feature request, please open an
[issue](https://github.cms.gov/ISPG/cms-ars-3.1-moderate-oracle-mysql-ee-5.7-cis-overlay/issues/new).

License
-------

This is licensed under the [Apache
2.0](https://www.apache.org/licenses/LICENSE-2.0) license.

### NOTICE

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.

### NOTICE

-   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)