Ubuntu Bionic rollout to wordpress-web host(s)

[adborden]

User Story

As an operator, I need new Ubuntu Bionic hosts provisioned in all of our environments so that I can continue receiving security updates automatically from Ubuntu.

Part of https://github.com/GSA/datagov-deploy/issues/571

Ubuntu 14.04 support ends April 2019. We should move to Ubuntu 16.04 or 18.04. The latest 18.04 is preferred, but we should consider what kind of support exists for it.

Details

Hosts are provisioned in these environments and play books are successfully applied.

1. [x] bionic sandbox
2. [x] staging
3. [x] production

Acceptance Criteria

• [x] Bionic hosts are provisioned and operating correctly
• [x] Bionic hosts reporting to our monitoring systems
• [x] Old Trusty hosts are decommissioned and removed from Ansible inventory

Definition of Done

The above acceptance criteria must be met.

[adborden]

Ran the wordpress playbook on bionic sandbox. It didn't complete successfully due to the database not being setup correctly. I opened https://github.com/GSA/datagov-deploy/issues/779, but I think we can continue once the staging bionic hosts are available.

TASK [software/wordpress/datagov-deploy : update s3 options] ****************************************
fatal: [wordpress-web1tf.internal.bionic.datagov.us]: FAILED! => {"changed": true, "cmd": "wp option update tantan_wordpress_s3 --format=json < s3.json", "delta": "0:00:00.257697", "end": "2019-05-08 23:12:43.874081", "msg": "non-zero return code", "rc": 1, "start": "2019-05-08 23:12:43.616384", "stderr": "Error: Error establishing a database connection. This either means that the username and password information in your `wp-config.php` file is incorrect or we can’t contact the database server at `wpdb`. This could mean your host’s database server is down.", "stderr_lines": ["Error: Error establishing a database connection. This either means that the username and password information in your `wp-config.php` file is incorrect or we can’t contact the database server at `wpdb`. This could mean your host’s database server is down."], "stdout": "", "stdout_lines": []}

[adborden]

Submitted a ticket to add new WordPress hosts to NetScaler.

[adborden]

Wordpress Trusty hosts have been removed.

--

The CloudFormation Stack has been updated by removing references to the instances to be terminated. The snapshots will remain for a year and unless directed would be removed after a year.

Here are the reference names of the instances terminated that can be used to find the snapshot for each EBS volumes that were attached to the instances: VM-OCSIT-DATA-1.0-P-CRM-WEB1P VM-OCSIT-DATA-1.0-P-CRM-WEB2P VM-OCSIT-DATA-1.0-P-DASHBOARD-WEB1P VM-OCSIT-DATA-1.0-P-DASHBOARD-WEB2P VM-OCSIT-DATA-1.0-P-WORDPRESS-WEB1P VM-OCSIT-DATA-1.0-P-WORDPRESS-WEB2P VM-OCSIT-DATA-1.0-P-DATAGOVSOLR1P VM-OCSIT-DATA-1.0-P-DATAGOVSOLR2P VM-OCSIT-DATA-1.0-P-DATAGOVSOLRM1P