Chapters

30 Chapters | 2:45:48 |

01

Hello Ansible!

5:53
02

Modules

6:34
03

Hosts & the Inventory File

4:45
04

Vagrant <3's Ansible

6:30
05

Create your Playbook!

3:18
06

Install Stuff: The apt Module

3:12
07

apt Package Upgrades & Requirements

6:13
08

PHP 7, Nginx & MySQL

6:09
09

Extensions, php.ini & lineinfile

7:23
10

git & Variables

5:21
11

Installing Composer & the script Module

6:45
12

Installing Composer Deps

4:31
13

Nginx Configuration & Ansible Templates

7:24
14

Handlers: For Handling Serious Biz

7:12
15

Cache Permissions

2:19
16

Symfony Console Commands

5:38
17

Tagging Tasks

4:46
18

Idempotency, changed_when & Facts

6:48
19

vars_prompt & Environment Variables

5:38
20

pre_tasks and set_fact

6:35
21

Faster Smarter Playbook

5:48
22

Skipping Tasks based on Changed

3:01
23

Organizing with include

2:10
24

Organizing into Roles

7:37
25

Using a 3rd Party to Install Redis

4:36
26

Variables and parameters.yml

3:06
27

The Variable Vault

7:22
28

Deploy to AWS!

6:06
29

Host Group Vars

3:30
30

Launch a Cloud Instance!

9:43

> Dev Tools > Ansible for Automation!

Buy Access to Course

08.

PHP 7, Nginx & MySQL

|

Autoplay

Keep on Learning!

If you liked what you've learned so far, dive in! Subscribe to get
access to this tutorial plus video, code and script downloads.

Start your All-Access Pass

Buy just this tutorial for $10.00

Previous Chapter

Next Chapter

Login or register to check out the script

4 Comments

Sort By

Login or Register to join the conversation

JuanLuisGarciaBorrego 8 years ago edited

Hi!

I'm installed mysql-server with a new root password by default.

I saw a trick:



- name: Set MySQL root password before installing
  become: true
  debconf: name='mysql-server' question='mysql-server/root_password' value='{{mysql_set_password_root | quote}}' vtype='password'

- name: Confirm MySQL root password before installing
  become: true
  debconf: name='mysql-server' question='mysql-server/root_password_again' value='{{mysql_set_password_root | quote}}' vtype='password'
#and then
- name: Install MySQL DB server
  become: true
  apt:
    name: mysql-server
    state: latest

It works, but in terminal when we run ansible always exists 2 tasks changed (Set MySQL root password before installing and Confirm MySQL root password before installing )

Do you know any way for set root password or do you know how I can skip me these 2 steps with a var and property when?

regards!

|

Victor SFCASTS JuanLuisGarciaBorrego 8 years ago

Hey Juan,

The easiest way is to set "changed_when: false" for those 2 tasks. Another possible solution I see: I think you can use stat module to check if "/usr/bin/mysql" exists, register the output as variable and use it in those 2 steps in "when" statement. So simply if "/usr/bin/mysql" is exist - then just skip those debconf steps. Though I don't know wether you need to re-enter the password on upgrading MySQL, because you have "state: latest". If so, then probably it won't work. But I think "changed_when: false" is enough here if you just want to keep your playbook clean.

Cheers!

|

JuanLuisGarciaBorrego Victor 8 years ago edited

It's true!

The solution:


- name: Set MySQL root password before installing
  become: true
  debconf: name='mysql-server' question='mysql-server/root_password' value='{{mysql_set_password_root | quote}}' vtype='password'
  changed_when: false

- name: Confirm MySQL root password before installing
  become: true
  debconf: name='mysql-server' question='mysql-server/root_password_again' value='{{mysql_set_password_root | quote}}' vtype='password'
  changed_when: false

Thanks victor =) !!!

|

Victor SFCASTS JuanLuisGarciaBorrego 8 years ago

You're welcome ;)

Btw, nice find of debconf solution, that's really interesting!

Cheers!

|

This tutorial is built using an older version of Symfony, but the core concepts of Ansible are still valid. New versions of Ansible may contain some features that we don't use here.

Symfony 3 Ansible 2.1

What PHP libraries does this tutorial use?

// composer.json
{
    "require": {
        "php": ">=5.5.9",
        "symfony/symfony": "3.1.*", // v3.1.4
        "doctrine/orm": "^2.5", // v2.7.2
        "doctrine/doctrine-bundle": "^1.6", // 1.6.4
        "doctrine/doctrine-cache-bundle": "^1.2", // 1.3.0
        "symfony/swiftmailer-bundle": "^2.3", // v2.3.11
        "symfony/monolog-bundle": "^2.8", // 2.11.1
        "symfony/polyfill-apcu": "^1.0", // v1.2.0
        "sensio/distribution-bundle": "^5.0", // v5.0.12
        "sensio/framework-extra-bundle": "^3.0.2", // v3.0.16
        "incenteev/composer-parameter-handler": "^2.0", // v2.1.2
        "doctrine/doctrine-migrations-bundle": "^1.2", // v1.2.0
        "snc/redis-bundle": "^2.0", // 2.0.0
        "predis/predis": "^1.1", // v1.1.1
        "composer/package-versions-deprecated": "^1.11" // 1.11.99
    },
    "require-dev": {
        "sensio/generator-bundle": "^3.0", // v3.0.8
        "symfony/phpunit-bridge": "^3.0", // v3.1.4
        "doctrine/data-fixtures": "^1.1", // 1.3.3
        "hautelook/alice-bundle": "^1.3" // v1.4.1
    }
}

Previous Chapter

Next Chapter