Chapters

24 Chapters | 2:45:42 |

01

Setup: Server Provisioning

8:38
02

Ansistrano Role Installation

5:50
03

Anatomy of an Ansistrano Deploy

4:40
04

Deploy with git

3:46
05

Virtual Host Setup

5:54
06

Deploying Keys & Private Repos

8:40
07

Ansistrano Stages & Shared Files

3:11
08

Deploy Hooks & parameters.yml

5:25
09

parameters.yml: Handling Secret Config

6:48
10

Composer & Cache Permissions

7:46
11

Building Webpack Encore Assets

8:56
12

Database Setup

6:21
13

Safe Migrations

7:10
14

Faster Deploy with Shared Files

7:01
15

Logs, Sessions & File Permissions

5:32
16

Cache Permission Secrets

6:34
17

Optimizing with Cache

3:14
18

Priming cache.app

7:00
19

Cleanup & GitHub OAuth Token

7:30
20

Deploying to Multiple Servers

7:11
21

Load Balancer & Reverse Proxy Setup

9:36
22

CircleCI: Auto-Deploy my Code!

10:29
23

Optimizing Performance!

11:14
24

When things go wrong: Rollback

7:11

> Dev Tools > Animated Deployment with Ansistrano

Buy Access to Course

12.

Database Setup

|

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 $9.00

Previous Chapter

Next Chapter

With a Subscription, click any sentence in the script to jump to that part of the video!

Login Subscribe

Login or register to check out the script

4 Comments

Sort By

Login or Register to join the conversation

IvanPuntiy 7 years ago edited

In case you are using newer server (Ubuntu 18.04 here): the root account is bound to root user, and not to password.
To fix, add this tasks to playbook.yml:

    - name: Install mysql-python
      become: true
      apt:
        name: python3-mysqldb
        state: latest
      become: true

    - name: Create MySQL symfony user
      become: true
      mysql_user:
        # change name to anything you want
        name: symfony
        # uncomment if pasword is wanted:
        # password: <somepassword>
        priv: '*.*:ALL'```

And change the username/password in vault.

1 |

Victor SFCASTS IvanPuntiy 7 years ago

Hey Ivan,

Thank you for sharing this with others! So you need to create a MySQL user first before start connecting to the DB from PHP scripts (or console commands) - good to know.

Cheers!

|

IvanPuntiy Victor 7 years ago

You welcome.
More specifically: Ubuntu 18.04 installation uses auth_socket for the MySQL root user.
Another option is to revert MySQL's root user authentication to the mysql_native_password.
I just choosed to create a new user.

|

Victor SFCASTS IvanPuntiy 7 years ago

Hey Ivan,

Yeah, probably the easiest. But good to know about alternative solution as well.
Thanks again!

Cheers!

|

While the fundamentals of Ansistrano haven't changed, this tutorial is built using Symfony 3, which has significant differences versus Symfony 4 and later.

Symfony 3 Ansible 2.1

What PHP libraries does this tutorial use?

// composer.json
{
    "require": {
        "php": ">=5.5.9",
        "doctrine/doctrine-bundle": "^1.6", // 1.6.8
        "doctrine/orm": "^2.5", // v2.7.2
        "incenteev/composer-parameter-handler": "^2.0", // v2.1.2
        "sensio/distribution-bundle": "^5.0.19", // v5.0.20
        "sensio/framework-extra-bundle": "^3.0.2", // v3.0.26
        "symfony/monolog-bundle": "^3.1.0", // v3.1.0
        "symfony/polyfill-apcu": "^1.0", // v1.4.0
        "symfony/swiftmailer-bundle": "^2.3.10", // v2.6.3
        "symfony/symfony": "3.3.*", // v3.3.5
        "twig/twig": "^1.0||^2.0", // v1.34.4
        "doctrine/doctrine-migrations-bundle": "^1.2", // v1.2.1
        "predis/predis": "^1.1", // v1.1.1
        "composer/package-versions-deprecated": "^1.11" // 1.11.99
    },
    "require-dev": {
        "sensio/generator-bundle": "^3.0", // v3.1.6
        "symfony/phpunit-bridge": "^3.0", // v3.3.5
        "doctrine/data-fixtures": "^1.1", // 1.3.3
        "hautelook/alice-bundle": "^1.3" // v1.4.1
    }
}

What Ansible libraries does this tutorial use?

# ansible/requirements.yml
-
    src: DavidWittman.redis
    version: 1.2.4
-
    src: ansistrano.deploy
    version: 2.7.0
-
    src: ansistrano.rollback
    version: 2.0.1

Previous Chapter

Next Chapter