Magento 2.2 on Ubuntu 16.04

This page is an anonymized sample of a technical page about the installation and configuration of open source Magento version 2.2. It is a demonstration of how this activity could be registered in a wiki. It is incomplete and probably somewhat outdated.

System messages are in Dutch as internet hoster Strato sets the system's language to the customer's locale and I did not change this :-(.


  • Strato VPS server V30-49
    (h1234567.stratoserver.net)
  • Ubuntu 16.04 LTS
  • Sendmail
  • Many more
root@h1234567:~# hostname
h1234567.stratoserver.net
root@h1234567:~#
root@h1234567:~# apt-get install apache2
Pakketlijsten worden ingelezen... Klaar
Boom van vereisten wordt opgebouwd... Klaar
De volgende extra pakketten zullen geïnstalleerd worden:
  apache2-bin apache2-data apache2-utils libapr1 libaprutil1 libaprutil1-dbd-sqlite3
  libaprutil1-ldap liblua5.1-0
Voorgestelde pakketten:
  apache2-doc apache2-suexec-pristine | apache2-suexec-custom ufw
De volgende NIEUWE pakketten zullen geïnstalleerd worden:
  apache2 apache2-bin apache2-data apache2-utils libapr1 libaprutil1
  libaprutil1-dbd-sqlite3 libaprutil1-ldap liblua5.1-0
0 opgewaardeerd, 9 nieuw geïnstalleerd, 0 te verwijderen en 0 niet opgewaardeerd.
Er moeten 1540 kB aan archieven opgehaald worden.
Na deze bewerking zal er 6369 kB extra schijfruimte gebruikt worden.
Wilt u doorgaan? [J/n]
Ophalen:1 ftp://ftp.stratoserver.net/pub/linux/ubuntu xenial/main amd64 libapr1 amd64 1.5.2-3 [86,0 kB]
Ophalen:2 ftp://ftp.stratoserver.net/pub/linux/ubuntu xenial/main amd64 libaprutil1 amd64 1.5.4-1build1 [77,1 kB]
Ophalen:3 ftp://ftp.stratoserver.net/pub/linux/ubuntu xenial/main amd64 libaprutil1-dbd-sqlite3 amd64 1.5.4-1build1 [10,6 kB]
Ophalen:4 ftp://ftp.stratoserver.net/pub/linux/ubuntu xenial/main amd64 libaprutil1-ldap amd64 1.5.4-1build1 [8720 B]
Ophalen:5 ftp://ftp.stratoserver.net/pub/linux/ubuntu xenial/main amd64 liblua5.1-0 amd64 5.1.5-8ubuntu1 [102 kB]
Ophalen:6 ftp://ftp.stratoserver.net/pub/linux/ubuntu xenial-updates/main amd64 apache2-bin amd64 2.4.18-2ubuntu3.5 [925 kB]
Ophalen:7 ftp://ftp.stratoserver.net/pub/linux/ubuntu xenial-updates/main amd64 apache2-utils amd64 2.4.18-2ubuntu3.5 [82,3 kB]
Ophalen:8 ftp://ftp.stratoserver.net/pub/linux/ubuntu xenial-updates/main amd64 apache2-data all 2.4.18-2ubuntu3.5 [162 kB]
Ophalen:9 ftp://ftp.stratoserver.net/pub/linux/ubuntu xenial-updates/main amd64 apache2 amd64 2.4.18-2ubuntu3.5 [86,7 kB]
1540 kB opgehaald in 0s (2680 kB/s)
Voorheen niet geselecteerd pakket libapr1:amd64 wordt geselecteerd.
(Database wordt ingelezen ... 22173 bestanden en mappen momenteel geïnstalleerd.)
Uitpakken van .../libapr1_1.5.2-3_amd64.deb wordt voorbereid...
Bezig met uitpakken van libapr1:amd64 (1.5.2-3) ...
Voorheen niet geselecteerd pakket libaprutil1:amd64 wordt geselecteerd.
Uitpakken van .../libaprutil1_1.5.4-1build1_amd64.deb wordt voorbereid...
Bezig met uitpakken van libaprutil1:amd64 (1.5.4-1build1) ...
Voorheen niet geselecteerd pakket libaprutil1-dbd-sqlite3:amd64 wordt geselecteerd.
Uitpakken van .../libaprutil1-dbd-sqlite3_1.5.4-1build1_amd64.deb wordt voorbereid...
Bezig met uitpakken van libaprutil1-dbd-sqlite3:amd64 (1.5.4-1build1) ...
Voorheen niet geselecteerd pakket libaprutil1-ldap:amd64 wordt geselecteerd.
Uitpakken van .../libaprutil1-ldap_1.5.4-1build1_amd64.deb wordt voorbereid...
Bezig met uitpakken van libaprutil1-ldap:amd64 (1.5.4-1build1) ...
Voorheen niet geselecteerd pakket liblua5.1-0:amd64 wordt geselecteerd.
Uitpakken van .../liblua5.1-0_5.1.5-8ubuntu1_amd64.deb wordt voorbereid...
Bezig met uitpakken van liblua5.1-0:amd64 (5.1.5-8ubuntu1) ...
Voorheen niet geselecteerd pakket apache2-bin wordt geselecteerd.
Uitpakken van .../apache2-bin_2.4.18-2ubuntu3.5_amd64.deb wordt voorbereid...
Bezig met uitpakken van apache2-bin (2.4.18-2ubuntu3.5) ...
Voorheen niet geselecteerd pakket apache2-utils wordt geselecteerd.
Uitpakken van .../apache2-utils_2.4.18-2ubuntu3.5_amd64.deb wordt voorbereid...
Bezig met uitpakken van apache2-utils (2.4.18-2ubuntu3.5) ...
Voorheen niet geselecteerd pakket apache2-data wordt geselecteerd.
Uitpakken van .../apache2-data_2.4.18-2ubuntu3.5_all.deb wordt voorbereid...
Bezig met uitpakken van apache2-data (2.4.18-2ubuntu3.5) ...
Voorheen niet geselecteerd pakket apache2 wordt geselecteerd.
Uitpakken van .../apache2_2.4.18-2ubuntu3.5_amd64.deb wordt voorbereid...
Bezig met uitpakken van apache2 (2.4.18-2ubuntu3.5) ...
Bezig met afhandelen van triggers voor libc-bin (2.23-0ubuntu10) ...
Bezig met afhandelen van triggers voor man-db (2.7.5-1) ...
Bezig met afhandelen van triggers voor systemd (229-4ubuntu21.1) ...
Instellen van libapr1:amd64 (1.5.2-3) ...
Instellen van libaprutil1:amd64 (1.5.4-1build1) ...
Instellen van libaprutil1-dbd-sqlite3:amd64 (1.5.4-1build1) ...
Instellen van libaprutil1-ldap:amd64 (1.5.4-1build1) ...
Instellen van liblua5.1-0:amd64 (5.1.5-8ubuntu1) ...
Instellen van apache2-bin (2.4.18-2ubuntu3.5) ...
Instellen van apache2-utils (2.4.18-2ubuntu3.5) ...
Instellen van apache2-data (2.4.18-2ubuntu3.5) ...
Instellen van apache2 (2.4.18-2ubuntu3.5) ...
Enabling module mpm_event.
Enabling module authz_core.
Enabling module authz_host.
Enabling module authn_core.
Enabling module auth_basic.
Enabling module access_compat.
Enabling module authn_file.
Enabling module authz_user.
Enabling module alias.
Enabling module dir.
Enabling module autoindex.
Enabling module env.
Enabling module mime.
Enabling module negotiation.
Enabling module setenvif.
Enabling module filter.
Enabling module deflate.
Enabling module status.
Enabling conf charset.
Enabling conf localized-error-pages.
Enabling conf other-vhosts-access-log.
Enabling conf security.
Enabling conf serve-cgi-bin.
Enabling site 000-default.
Bezig met afhandelen van triggers voor libc-bin (2.23-0ubuntu10) ...
Bezig met afhandelen van triggers voor systemd (229-4ubuntu21.1) ...
root@h1234567:~#

See also http://devdocs.magento.com/guides/v2.2/install-gde/prereq/apache.html

root@h1234567:~# apache2 -v
Server version: Apache/2.4.18 (Ubuntu)
Server built:   2017-09-18T15:09:02
 
## Step 1
root@h1234567:~# a2enmod rewrite
Enabling module rewrite.
To activate the new configuration, you need to run:
  service apache2 restart
 
## Step 2 (preparation)
root@h1234567:~#  ls -la /etc/apache2/
total 88
drwxr-xr-x  8 root root  4096 feb 13 13:46 .
drwxr-xr-x 85 root root  4096 feb 13 13:46 ..
-rw-r--r--  1 root root  7115 mrt 19  2016 apache2.conf
drwxr-xr-x  2 root root  4096 feb 13 13:46 conf-available
drwxr-xr-x  2 root root  4096 feb 13 13:46 conf-enabled
-rw-r--r--  1 root root  1782 mrt 19  2016 envvars
-rw-r--r--  1 root root 31063 mrt 19  2016 magic
drwxr-xr-x  2 root root 12288 feb 13 13:46 mods-available
drwxr-xr-x  2 root root  4096 feb 13 14:00 mods-enabled
-rw-r--r--  1 root root   320 mrt 19  2016 ports.conf
drwxr-xr-x  2 root root  4096 feb 13 13:46 sites-available
drwxr-xr-x  2 root root  4096 feb 13 13:46 sites-enabled
root@h1234567:~#
root@h1234567:~# find /etc/apache2/ -name *.conf
/etc/apache2/conf-available/security.conf
/etc/apache2/conf-available/serve-cgi-bin.conf
/etc/apache2/conf-available/charset.conf
/etc/apache2/conf-available/other-vhosts-access-log.conf
/etc/apache2/conf-available/localized-error-pages.conf
/etc/apache2/apache2.conf
/etc/apache2/sites-available/default-ssl.conf
/etc/apache2/sites-available/000-default.conf
/etc/apache2/conf-enabled/security.conf
/etc/apache2/conf-enabled/serve-cgi-bin.conf
/etc/apache2/conf-enabled/charset.conf
/etc/apache2/conf-enabled/other-vhosts-access-log.conf
/etc/apache2/conf-enabled/localized-error-pages.conf
/etc/apache2/mods-enabled/status.conf
/etc/apache2/mods-enabled/deflate.conf
/etc/apache2/mods-enabled/alias.conf
/etc/apache2/mods-enabled/setenvif.conf
/etc/apache2/mods-enabled/negotiation.conf
/etc/apache2/mods-enabled/autoindex.conf
/etc/apache2/mods-enabled/dir.conf
/etc/apache2/mods-enabled/mpm_event.conf
/etc/apache2/mods-enabled/mime.conf
/etc/apache2/ports.conf
/etc/apache2/sites-enabled/000-default.conf
/etc/apache2/mods-available/proxy_html.conf
/etc/apache2/mods-available/cache_disk.conf
/etc/apache2/mods-available/status.conf
/etc/apache2/mods-available/deflate.conf
/etc/apache2/mods-available/proxy.conf
/etc/apache2/mods-available/mpm_prefork.conf
/etc/apache2/mods-available/dav_fs.conf
/etc/apache2/mods-available/reqtimeout.conf
/etc/apache2/mods-available/alias.conf
/etc/apache2/mods-available/setenvif.conf
/etc/apache2/mods-available/negotiation.conf
/etc/apache2/mods-available/ldap.conf
/etc/apache2/mods-available/ssl.conf
/etc/apache2/mods-available/cgid.conf
/etc/apache2/mods-available/info.conf
/etc/apache2/mods-available/mpm_worker.conf
/etc/apache2/mods-available/autoindex.conf
/etc/apache2/mods-available/proxy_ftp.conf
/etc/apache2/mods-available/dir.conf
/etc/apache2/mods-available/mpm_event.conf
/etc/apache2/mods-available/actions.conf
/etc/apache2/mods-available/mime_magic.conf
/etc/apache2/mods-available/userdir.conf
/etc/apache2/mods-available/mime.conf
/etc/apache2/mods-available/proxy_balancer.conf
root@h1234567:~#
root@h1234567:~# cat /etc/apache2/sites-available/000-default.conf
<VirtualHost *:80>
        # The ServerName directive sets the request scheme, hostname and port that
        # the server uses to identify itself. This is used when creating
        # redirection URLs. In the context of virtual hosts, the ServerName
        # specifies what hostname must appear in the request's Host: header to
        # match this virtual host. For the default virtual host (this file) this
        # value is not decisive as it is used as a last resort host regardless.
        # However, you must set it for any further virtual host explicitly.
        #ServerName www.example.com
 
        ServerAdmin webmaster@localhost
        DocumentRoot /var/www/html
 
        # Available loglevels: trace8, ..., trace1, debug, info, notice, warn,
        # error, crit, alert, emerg.
        # It is also possible to configure the loglevel for particular
        # modules, e.g.
        #LogLevel info ssl:warn
 
        ErrorLog ${APACHE_LOG_DIR}/error.log
        CustomLog ${APACHE_LOG_DIR}/access.log combined
 
        # For most configuration files from conf-available/, which are
        # enabled or disabled at a global level, it is possible to
        # include a line for only one particular virtual host. For example the
        # following line enables the CGI configuration for this host only
        # after it has been globally disabled with "a2disconf".
        #Include conf-available/serve-cgi-bin.conf
</VirtualHost>
 
# vim: syntax=apache ts=4 sw=4 sts=4 sr noet
root@h1234567:~#

## DocumentRoot in above file is /var/www/html
## This is correct.
## Now see if this file is the same as the enabled one
root@h1234567:~# ls -la /etc/apache2/sites-enabled/000-default.conf
lrwxrwxrwx 1 root root 35 feb 13 13:46 /etc/apache2/sites-enabled/000-default.conf -> ../sites-available/000-default.conf
root@h1234567:~#
root@h1234567:~# ls -la /etc/apache2/sites-available/000-default.conf
-rw-r--r-- 1 root root 1332 mrt 19  2016 /etc/apache2/sites-available/000-default.conf
root@h1234567:~#

## Step 2 - Add AllowOveride
root@h1234567:~# cp -p /etc/apache2/sites-available/000-default.conf /etc/apache2/sites-available/000-default.conf_org
root@h1234567:~#
root@h1234567:~# vi /etc/apache2/sites-available/000-default.conf
root@h1234567:~#
root@h1234567:~# diff /etc/apache2/sites-available/000-default.conf /etc/apache2/sites-available/000-default.conf_org
31,35d30
< # Added by JohnG based on http://devdocs.magento.com/guides/v2.2/install-gde/prereq/apache.html
< <Directory "/var/www/html">
<         AllowOverride All
< </Directory>
<
root@h1234567:~#

## Step 3
root@h1234567:~# service apache2 restart
root@h1234567:~#

The machine does not have PHP installed yet.

Latest available Magento version is 2.2.

Steps in http://devdocs.magento.com/guides/v2.2/install-gde/prereq/prereq-overview.html were followed.

root@h1234567:~# php -v
-bash: php: command not found
root@h1234567:~# add-apt-repository ppa:ondrej/php
-bash: add-apt-repository: command not found
root@h1234567:~#

## See https://askubuntu.com/questions/593433/error-sudo-add-apt-repository-command-not-found
root@h1234567:~# apt-get install software-properties-common
Pakketlijsten worden ingelezen... Klaar
Boom van vereisten wordt opgebouwd
De statusinformatie wordt gelezen... Klaar
De volgende extra pakketten zullen geïnstalleerd worden:
  gir1.2-glib-2.0 iso-codes libcurl3-gnutls libdbus-glib-1-2 libgirepository-1.0-1
  librtmp1 python-apt-common python3-apt python3-dbus python3-gi python3-pycurl
  python3-software-properties unattended-upgrades
Voorgestelde pakketten:
  isoquery python3-apt-dbg python-apt-doc python-dbus-doc python3-dbus-dbg
  libcurl4-gnutls-dev python-pycurl-doc python3-pycurl-dbg bsd-mailx
De volgende NIEUWE pakketten zullen geïnstalleerd worden:
  gir1.2-glib-2.0 iso-codes libcurl3-gnutls libdbus-glib-1-2 libgirepository-1.0-1
  librtmp1 python-apt-common python3-apt python3-dbus python3-gi python3-pycurl
  python3-software-properties software-properties-common unattended-upgrades
0 opgewaardeerd, 14 nieuw geïnstalleerd, 0 te verwijderen en 0 niet opgewaardeerd.
Er moeten 3283 kB aan archieven opgehaald worden.
Na deze bewerking zal er 20,9 MB extra schijfruimte gebruikt worden.
Wilt u doorgaan? [J/n]
Ophalen:1 ftp://ftp.stratoserver.net/pub/linux/ubuntu xenial/main amd64 libgirepository-1.0-1 amd64 1.46.0-3ubuntu1 [88,3 kB]
Ophalen:2 ftp://ftp.stratoserver.net/pub/linux/ubuntu xenial/main amd64 gir1.2-glib-2.0 amd64 1.46.0-3ubuntu1 [127 kB]
Ophalen:3 ftp://ftp.stratoserver.net/pub/linux/ubuntu xenial/main amd64 iso-codes all 3.65-1 [2268 kB]
Ophalen:4 ftp://ftp.stratoserver.net/pub/linux/ubuntu xenial-updates/main amd64 librtmp1 amd64 2.4+20151223.gitfa8646d-1ubuntu0.1 [54,4 kB]
Ophalen:5 ftp://ftp.stratoserver.net/pub/linux/ubuntu xenial-updates/main amd64 libcurl3-gnutls amd64 7.47.0-1ubuntu2.6 [184 kB]
Ophalen:6 ftp://ftp.stratoserver.net/pub/linux/ubuntu xenial/main amd64 libdbus-glib-1-2 amd64 0.106-1 [67,1 kB]
Ophalen:7 ftp://ftp.stratoserver.net/pub/linux/ubuntu xenial/main amd64 python-apt-common all 1.1.0~beta1build1 [17,3 kB]
Ophalen:8 ftp://ftp.stratoserver.net/pub/linux/ubuntu xenial/main amd64 python3-apt amd64 1.1.0~beta1build1 [137 kB]
Ophalen:9 ftp://ftp.stratoserver.net/pub/linux/ubuntu xenial/main amd64 python3-dbus amd64 1.2.0-3 [83,1 kB]
Ophalen:10 ftp://ftp.stratoserver.net/pub/linux/ubuntu xenial/main amd64 python3-gi amd64 3.20.0-0ubuntu1 [153 kB]
Ophalen:11 ftp://ftp.stratoserver.net/pub/linux/ubuntu xenial/main amd64 python3-pycurl amd64 7.43.0-1ubuntu1 [42,3 kB]
Ophalen:12 ftp://ftp.stratoserver.net/pub/linux/ubuntu xenial-updates/main amd64 python3-software-properties all 0.96.20.7 [20,3 kB]
Ophalen:13 ftp://ftp.stratoserver.net/pub/linux/ubuntu xenial-updates/main amd64 software-properties-common all 0.96.20.7 [9452 B]
Ophalen:14 ftp://ftp.stratoserver.net/pub/linux/ubuntu xenial-updates/main amd64 unattended-upgrades all 0.90ubuntu0.9 [32,3 kB]
3283 kB opgehaald in 1s (2631 kB/s)
Voorconfigureren van pakketten ...
Voorheen niet geselecteerd pakket libgirepository-1.0-1:amd64 wordt geselecteerd.
(Database wordt ingelezen ... 22855 bestanden en mappen momenteel geïnstalleerd.)
Uitpakken van .../libgirepository-1.0-1_1.46.0-3ubuntu1_amd64.deb wordt voorbereid...
Bezig met uitpakken van libgirepository-1.0-1:amd64 (1.46.0-3ubuntu1) ...
Voorheen niet geselecteerd pakket gir1.2-glib-2.0:amd64 wordt geselecteerd.
Uitpakken van .../gir1.2-glib-2.0_1.46.0-3ubuntu1_amd64.deb wordt voorbereid...
Bezig met uitpakken van gir1.2-glib-2.0:amd64 (1.46.0-3ubuntu1) ...
Voorheen niet geselecteerd pakket iso-codes wordt geselecteerd.
Uitpakken van .../iso-codes_3.65-1_all.deb wordt voorbereid...
Bezig met uitpakken van iso-codes (3.65-1) ...
Voorheen niet geselecteerd pakket librtmp1:amd64 wordt geselecteerd.
Uitpakken van .../librtmp1_2.4+20151223.gitfa8646d-1ubuntu0.1_amd64.deb wordt voorbereid...
Bezig met uitpakken van librtmp1:amd64 (2.4+20151223.gitfa8646d-1ubuntu0.1) ...
Voorheen niet geselecteerd pakket libcurl3-gnutls:amd64 wordt geselecteerd.
Uitpakken van .../libcurl3-gnutls_7.47.0-1ubuntu2.6_amd64.deb wordt voorbereid...
Bezig met uitpakken van libcurl3-gnutls:amd64 (7.47.0-1ubuntu2.6) ...
Voorheen niet geselecteerd pakket libdbus-glib-1-2:amd64 wordt geselecteerd.
Uitpakken van .../libdbus-glib-1-2_0.106-1_amd64.deb wordt voorbereid...
Bezig met uitpakken van libdbus-glib-1-2:amd64 (0.106-1) ...
Voorheen niet geselecteerd pakket python-apt-common wordt geselecteerd.
Uitpakken van .../python-apt-common_1.1.0~beta1build1_all.deb wordt voorbereid...
Bezig met uitpakken van python-apt-common (1.1.0~beta1build1) ...
Voorheen niet geselecteerd pakket python3-apt wordt geselecteerd.
Uitpakken van .../python3-apt_1.1.0~beta1build1_amd64.deb wordt voorbereid...
Bezig met uitpakken van python3-apt (1.1.0~beta1build1) ...
Voorheen niet geselecteerd pakket python3-dbus wordt geselecteerd.
Uitpakken van .../python3-dbus_1.2.0-3_amd64.deb wordt voorbereid...
Bezig met uitpakken van python3-dbus (1.2.0-3) ...
Voorheen niet geselecteerd pakket python3-gi wordt geselecteerd.
Uitpakken van .../python3-gi_3.20.0-0ubuntu1_amd64.deb wordt voorbereid...
Bezig met uitpakken van python3-gi (3.20.0-0ubuntu1) ...
Voorheen niet geselecteerd pakket python3-pycurl wordt geselecteerd.
Uitpakken van .../python3-pycurl_7.43.0-1ubuntu1_amd64.deb wordt voorbereid...
Bezig met uitpakken van python3-pycurl (7.43.0-1ubuntu1) ...
Voorheen niet geselecteerd pakket python3-software-properties wordt geselecteerd.
Uitpakken van .../python3-software-properties_0.96.20.7_all.deb wordt voorbereid...
Bezig met uitpakken van python3-software-properties (0.96.20.7) ...
Voorheen niet geselecteerd pakket software-properties-common wordt geselecteerd.
Uitpakken van .../software-properties-common_0.96.20.7_all.deb wordt voorbereid...
Bezig met uitpakken van software-properties-common (0.96.20.7) ...
Voorheen niet geselecteerd pakket unattended-upgrades wordt geselecteerd.
Uitpakken van .../unattended-upgrades_0.90ubuntu0.9_all.deb wordt voorbereid...
Bezig met uitpakken van unattended-upgrades (0.90ubuntu0.9) ...
Bezig met afhandelen van triggers voor libc-bin (2.23-0ubuntu10) ...
Bezig met afhandelen van triggers voor man-db (2.7.5-1) ...
Bezig met afhandelen van triggers voor systemd (229-4ubuntu21.1) ...
Instellen van libgirepository-1.0-1:amd64 (1.46.0-3ubuntu1) ...
Instellen van gir1.2-glib-2.0:amd64 (1.46.0-3ubuntu1) ...
Instellen van iso-codes (3.65-1) ...
Instellen van librtmp1:amd64 (2.4+20151223.gitfa8646d-1ubuntu0.1) ...
Instellen van libcurl3-gnutls:amd64 (7.47.0-1ubuntu2.6) ...
Instellen van libdbus-glib-1-2:amd64 (0.106-1) ...
Instellen van python-apt-common (1.1.0~beta1build1) ...
Instellen van python3-apt (1.1.0~beta1build1) ...
Instellen van python3-dbus (1.2.0-3) ...
Instellen van python3-gi (3.20.0-0ubuntu1) ...
Instellen van python3-pycurl (7.43.0-1ubuntu1) ...
Instellen van python3-software-properties (0.96.20.7) ...
Instellen van software-properties-common (0.96.20.7) ...
Instellen van unattended-upgrades (0.90ubuntu0.9) ...

Creating config file /etc/apt/apt.conf.d/20auto-upgrades with new version

Creating config file /etc/apt/apt.conf.d/50unattended-upgrades with new version
Synchronizing state of unattended-upgrades.service with SysV init with /lib/systemd/systemd-sysv-install...
Executing /lib/systemd/systemd-sysv-install enable unattended-upgrades
Bezig met afhandelen van triggers voor libc-bin (2.23-0ubuntu10) ...
Bezig met afhandelen van triggers voor systemd (229-4ubuntu21.1) ...
root@h1234567:~#

root@h1234567:~# add-apt-repository ppa:ondrej/php
 Co-installable PHP versions: PHP 5.6, PHP 7.x and most requested extensions are included. Only Supported Versions of PHP (http://php.net/supported-versions.php) for Supported Ubuntu Releases (https://wiki.ubuntu.com/Releases) are provided. Don't ask for end-of-life PHP versions or Ubuntu release, they won't be provided.

Debian oldstable and stable packages are provided as well: https://deb.sury.org/#debian-dpa

You can get more information about the packages at https://deb.sury.org

BUGS&FEATURES: This PPA now has a issue tracker:
https://deb.sury.org/#bug-reporting

CAVEATS:
1. If you are using php-gearman, you need to add ppa:ondrej/pkg-gearman
2. If you are using apache2, you are advised to add ppa:ondrej/apache2
3. If you are using nginx, you are advise to add ppa:ondrej/nginx-mainline
   or ppa:ondrej/nginx

PLEASE READ: If you like my work and want to give me a little motivation, please consider donating regularly: https://donate.sury.org/

WARNING: add-apt-repository is broken with non-UTF-8 locales, see
https://github.com/oerdnj/deb.sury.org/issues/56 for workaround:

# LC_ALL=C.UTF-8 add-apt-repository ppa:ondrej/php
 More info: https://launchpad.net/~ondrej/+archive/ubuntu/php
Press [ENTER] to continue or ctrl-c to cancel adding it

gpg: keyring `/tmp/tmpap1k4ub6/secring.gpg' created
gpg: keyring `/tmp/tmpap1k4ub6/pubring.gpg' created
gpg: requesting key E5267A6C from hkp server keyserver.ubuntu.com
gpg: /tmp/tmpap1k4ub6/trustdb.gpg: trustdb created
gpg: key E5267A6C: public key "Launchpad PPA for Ondřej Surý" imported
gpg: Total number processed: 1
gpg:               imported: 1  (RSA: 1)
OK
root@h1234567:~#

root@h1234567:~# apt-get -y update
Ophalen:1 http://ppa.launchpad.net/ondrej/php/ubuntu xenial InRelease [23,9 kB]
Ophalen:2 http://ppa.launchpad.net/ondrej/php/ubuntu xenial/main amd64 Packages [45,5 kB]
Geraakt:3 ftp://ftp.stratoserver.net/pub/linux/ubuntu xenial InRelease
Geraakt:4 ftp://ftp.stratoserver.net/pub/linux/ubuntu xenial-updates InRelease
Geraakt:5 ftp://ftp.stratoserver.net/pub/linux/ubuntu xenial-security InRelease
Ophalen:6 http://ppa.launchpad.net/ondrej/php/ubuntu xenial/main Translation-en [26,3 kB]
95,7 kB opgehaald in 0s (195 kB/s)
Pakketlijsten worden ingelezen... Klaar
root@h1234567:~#
root@h1234567:~# apt-get install -y php7.1 libapache2-mod-php7.1 php7.1 php7.1-common php7.1-gd php7.1-mysql php7.1-mcrypt php7.1-curl php7.1-intl php7.1-xsl php7.1-mbstring php7.1-zip php7.1-bcmath php7.1-iconv php7.1-soap
Pakketlijsten worden ingelezen... Klaar
Boom van vereisten wordt opgebouwd
De statusinformatie wordt gelezen... Klaar
Let op, 'php7.1-common' wordt geselecteerd in plaats van 'php7.1-iconv'
De volgende extra pakketten zullen geïnstalleerd worden:
  libcurl3 libgd3 libjbig0 libjpeg-turbo8 libjpeg8 libmcrypt4 libpcre3 libssl1.1 libtiff5
  libwebp6 libx11-6 libx11-data libxau6 libxcb1 libxdmcp6 libxpm4 libxslt1.1 libzip5
  php-common php7.1-cli php7.1-json php7.1-opcache php7.1-readline php7.1-xml
Voorgestelde pakketten:
  php-pear libgd-tools libmcrypt-dev mcrypt
De volgende NIEUWE pakketten zullen geïnstalleerd worden:
  libapache2-mod-php7.1 libcurl3 libgd3 libjbig0 libjpeg-turbo8 libjpeg8 libmcrypt4
  libssl1.1 libtiff5 libwebp6 libx11-6 libx11-data libxau6 libxcb1 libxdmcp6 libxpm4
  libxslt1.1 libzip5 php-common php7.1 php7.1-bcmath php7.1-cli php7.1-common php7.1-curl
  php7.1-gd php7.1-intl php7.1-json php7.1-mbstring php7.1-mcrypt php7.1-mysql
  php7.1-opcache php7.1-readline php7.1-soap php7.1-xml php7.1-xsl php7.1-zip
De volgende pakketten zullen opgewaardeerd worden:
  libpcre3
1 opgewaardeerd, 36 nieuw geïnstalleerd, 0 te verwijderen en 2 niet opgewaardeerd.
Er moeten 8215 kB aan archieven opgehaald worden.
Na deze bewerking zal er 28,3 MB extra schijfruimte gebruikt worden.
Ophalen:1 http://ppa.launchpad.net/ondrej/php/ubuntu xenial/main amd64 libpcre3 amd64 2:8.41-4+ubuntu16.04.1+deb.sury.org+1 [235 kB]
Ophalen:2 ftp://ftp.stratoserver.net/pub/linux/ubuntu xenial/main amd64 libxau6 amd64 1:1.0.8-1 [8376 B]
Ophalen:3 ftp://ftp.stratoserver.net/pub/linux/ubuntu xenial/main amd64 libjpeg-turbo8 amd64 1.4.2-0ubuntu3 [111 kB]
Ophalen:4 ftp://ftp.stratoserver.net/pub/linux/ubuntu xenial/main amd64 libxdmcp6 amd64 1:1.1.2-1.1 [11,0 kB]
Ophalen:5 ftp://ftp.stratoserver.net/pub/linux/ubuntu xenial/main amd64 libxcb1 amd64 1.11.1-1ubuntu1 [40,0 kB]
Ophalen:6 ftp://ftp.stratoserver.net/pub/linux/ubuntu xenial/main amd64 libx11-data all 2:1.6.3-1ubuntu2 [113 kB]
Ophalen:7 ftp://ftp.stratoserver.net/pub/linux/ubuntu xenial/main amd64 libx11-6 amd64 2:1.6.3-1ubuntu2 [571 kB]
Ophalen:8 http://ppa.launchpad.net/ondrej/php/ubuntu xenial/main amd64 libssl1.1 amd64 1.1.0g-2.1+ubuntu16.04.1+deb.sury.org+1 [1334 kB]
Ophalen:9 ftp://ftp.stratoserver.net/pub/linux/ubuntu xenial-updates/main amd64 libcurl3 amd64 7.47.0-1ubuntu2.6 [187 kB]
Ophalen:10 ftp://ftp.stratoserver.net/pub/linux/ubuntu xenial/main amd64 libjpeg8 amd64 8c-2ubuntu8 [2194 B]
Ophalen:11 ftp://ftp.stratoserver.net/pub/linux/ubuntu xenial-updates/main amd64 libtiff5 amd64 4.0.6-1ubuntu0.2 [146 kB]
Ophalen:12 ftp://ftp.stratoserver.net/pub/linux/ubuntu xenial-updates/main amd64 libxpm4 amd64 1:3.5.11-1ubuntu0.16.04.1 [33,8 kB]
Ophalen:13 ftp://ftp.stratoserver.net/pub/linux/ubuntu xenial/universe amd64 libmcrypt4 amd64 2.5.8-3.3 [63,0 kB]
Ophalen:14 ftp://ftp.stratoserver.net/pub/linux/ubuntu xenial-updates/main amd64 libxslt1.1 amd64 1.1.28-2.1ubuntu0.1 [145 kB]
Ophalen:15 http://ppa.launchpad.net/ondrej/php/ubuntu xenial/main amd64 php-common all 1:60+ubuntu16.04.1+deb.sury.org+1 [14,7 kB]
Ophalen:16 http://ppa.launchpad.net/ondrej/php/ubuntu xenial/main amd64 php7.1-common amd64 7.1.14-1+ubuntu16.04.1+deb.sury.org+1 [885 kB]
Ophalen:17 http://ppa.launchpad.net/ondrej/php/ubuntu xenial/main amd64 php7.1-json amd64 7.1.14-1+ubuntu16.04.1+deb.sury.org+1 [17,2 kB]
Ophalen:18 http://ppa.launchpad.net/ondrej/php/ubuntu xenial/main amd64 php7.1-opcache amd64 7.1.14-1+ubuntu16.04.1+deb.sury.org+1 [143 kB]
Ophalen:19 http://ppa.launchpad.net/ondrej/php/ubuntu xenial/main amd64 php7.1-readline amd64 7.1.14-1+ubuntu16.04.1+deb.sury.org+1 [12,8 kB]
Ophalen:20 http://ppa.launchpad.net/ondrej/php/ubuntu xenial/main amd64 php7.1-cli amd64 7.1.14-1+ubuntu16.04.1+deb.sury.org+1 [1324 kB]
Ophalen:21 http://ppa.launchpad.net/ondrej/php/ubuntu xenial/main amd64 libapache2-mod-php7.1 amd64 7.1.14-1+ubuntu16.04.1+deb.sury.org+1 [1266 kB]
Ophalen:22 http://ppa.launchpad.net/ondrej/php/ubuntu xenial/main amd64 libjbig0 amd64 2.1-3.1+deb.sury.org~xenial+1 [26,4 kB]
Ophalen:23 http://ppa.launchpad.net/ondrej/php/ubuntu xenial/main amd64 libwebp6 amd64 0.6.0-4+ubuntu16.04.1+deb.sury.org+1 [184 kB]
Ophalen:24 http://ppa.launchpad.net/ondrej/php/ubuntu xenial/main amd64 libgd3 amd64 2.2.5-4+ubuntu16.04.1+deb.sury.org+2 [133 kB]
Ophalen:25 http://ppa.launchpad.net/ondrej/php/ubuntu xenial/main amd64 libzip5 amd64 1.3.2-1+ubuntu16.04.1+deb.sury.org+1 [53,1 kB]
Ophalen:26 http://ppa.launchpad.net/ondrej/php/ubuntu xenial/main amd64 php7.1 all 7.1.14-1+ubuntu16.04.1+deb.sury.org+1 [56,2 kB]
Ophalen:27 http://ppa.launchpad.net/ondrej/php/ubuntu xenial/main amd64 php7.1-bcmath amd64 7.1.14-1+ubuntu16.04.1+deb.sury.org+1 [15,7 kB]
Ophalen:28 http://ppa.launchpad.net/ondrej/php/ubuntu xenial/main amd64 php7.1-curl amd64 7.1.14-1+ubuntu16.04.1+deb.sury.org+1 [28,3 kB]
Ophalen:29 http://ppa.launchpad.net/ondrej/php/ubuntu xenial/main amd64 php7.1-gd amd64 7.1.14-1+ubuntu16.04.1+deb.sury.org+1 [27,2 kB]
Ophalen:30 http://ppa.launchpad.net/ondrej/php/ubuntu xenial/main amd64 php7.1-intl amd64 7.1.14-1+ubuntu16.04.1+deb.sury.org+1 [127 kB]
Ophalen:31 http://ppa.launchpad.net/ondrej/php/ubuntu xenial/main amd64 php7.1-mbstring amd64 7.1.14-1+ubuntu16.04.1+deb.sury.org+1 [467 kB]
Ophalen:32 http://ppa.launchpad.net/ondrej/php/ubuntu xenial/main amd64 php7.1-mcrypt amd64 7.1.14-1+ubuntu16.04.1+deb.sury.org+1 [14,5 kB]
Ophalen:33 http://ppa.launchpad.net/ondrej/php/ubuntu xenial/main amd64 php7.1-mysql amd64 7.1.14-1+ubuntu16.04.1+deb.sury.org+1 [120 kB]
Ophalen:34 http://ppa.launchpad.net/ondrej/php/ubuntu xenial/main amd64 php7.1-soap amd64 7.1.14-1+ubuntu16.04.1+deb.sury.org+1 [113 kB]
Ophalen:35 http://ppa.launchpad.net/ondrej/php/ubuntu xenial/main amd64 php7.1-xml amd64 7.1.14-1+ubuntu16.04.1+deb.sury.org+1 [113 kB]
Ophalen:36 http://ppa.launchpad.net/ondrej/php/ubuntu xenial/main amd64 php7.1-xsl all 7.1.14-1+ubuntu16.04.1+deb.sury.org+1 [55,9 kB]
Ophalen:37 http://ppa.launchpad.net/ondrej/php/ubuntu xenial/main amd64 php7.1-zip amd64 7.1.14-1+ubuntu16.04.1+deb.sury.org+1 [19,7 kB]
8215 kB opgehaald in 11s (738 kB/s)
Extraheren van sjablonen uit pakketten: 100%
Voorconfigureren van pakketten ...
Voorheen niet geselecteerd pakket libxau6:amd64 wordt geselecteerd.
(Database wordt ingelezen ... 23563 bestanden en mappen momenteel geïnstalleerd.)
Uitpakken van .../libxau6_1%3a1.0.8-1_amd64.deb wordt voorbereid...
Bezig met uitpakken van libxau6:amd64 (1:1.0.8-1) ...
Voorheen niet geselecteerd pakket libjpeg-turbo8:amd64 wordt geselecteerd.
Uitpakken van .../libjpeg-turbo8_1.4.2-0ubuntu3_amd64.deb wordt voorbereid...
Bezig met uitpakken van libjpeg-turbo8:amd64 (1.4.2-0ubuntu3) ...
Uitpakken van .../libpcre3_2%3a8.41-4+ubuntu16.04.1+deb.sury.org+1_amd64.deb wordt voorbereid...
Bezig met uitpakken van libpcre3:amd64 (2:8.41-4+ubuntu16.04.1+deb.sury.org+1) over (2:8.38-3.1) ...
Bezig met afhandelen van triggers voor libc-bin (2.23-0ubuntu10) ...
Bezig met afhandelen van triggers voor man-db (2.7.5-1) ...
Instellen van libpcre3:amd64 (2:8.41-4+ubuntu16.04.1+deb.sury.org+1) ...
Bezig met afhandelen van triggers voor libc-bin (2.23-0ubuntu10) ...
Voorheen niet geselecteerd pakket libssl1.1:amd64 wordt geselecteerd.
(Database wordt ingelezen ... 23574 bestanden en mappen momenteel geïnstalleerd.)
Uitpakken van .../libssl1.1_1.1.0g-2.1+ubuntu16.04.1+deb.sury.org+1_amd64.deb wordt voorbereid...
Bezig met uitpakken van libssl1.1:amd64 (1.1.0g-2.1+ubuntu16.04.1+deb.sury.org+1) ...
Voorheen niet geselecteerd pakket libxdmcp6:amd64 wordt geselecteerd.
Uitpakken van .../libxdmcp6_1%3a1.1.2-1.1_amd64.deb wordt voorbereid...
Bezig met uitpakken van libxdmcp6:amd64 (1:1.1.2-1.1) ...
Voorheen niet geselecteerd pakket libxcb1:amd64 wordt geselecteerd.
Uitpakken van .../libxcb1_1.11.1-1ubuntu1_amd64.deb wordt voorbereid...
Bezig met uitpakken van libxcb1:amd64 (1.11.1-1ubuntu1) ...
Voorheen niet geselecteerd pakket libx11-data wordt geselecteerd.
Uitpakken van .../libx11-data_2%3a1.6.3-1ubuntu2_all.deb wordt voorbereid...
Bezig met uitpakken van libx11-data (2:1.6.3-1ubuntu2) ...
Voorheen niet geselecteerd pakket libx11-6:amd64 wordt geselecteerd.
Uitpakken van .../libx11-6_2%3a1.6.3-1ubuntu2_amd64.deb wordt voorbereid...
Bezig met uitpakken van libx11-6:amd64 (2:1.6.3-1ubuntu2) ...
Voorheen niet geselecteerd pakket php-common wordt geselecteerd.
Uitpakken van .../php-common_1%3a60+ubuntu16.04.1+deb.sury.org+1_all.deb wordt voorbereid...
Bezig met uitpakken van php-common (1:60+ubuntu16.04.1+deb.sury.org+1) ...
Voorheen niet geselecteerd pakket php7.1-common wordt geselecteerd.
Uitpakken van .../php7.1-common_7.1.14-1+ubuntu16.04.1+deb.sury.org+1_amd64.deb wordt voorbereid...
Bezig met uitpakken van php7.1-common (7.1.14-1+ubuntu16.04.1+deb.sury.org+1) ...
Voorheen niet geselecteerd pakket php7.1-json wordt geselecteerd.
Uitpakken van .../php7.1-json_7.1.14-1+ubuntu16.04.1+deb.sury.org+1_amd64.deb wordt voorbereid...
Bezig met uitpakken van php7.1-json (7.1.14-1+ubuntu16.04.1+deb.sury.org+1) ...
Voorheen niet geselecteerd pakket php7.1-opcache wordt geselecteerd.
Uitpakken van .../php7.1-opcache_7.1.14-1+ubuntu16.04.1+deb.sury.org+1_amd64.deb wordt voorbereid...
Bezig met uitpakken van php7.1-opcache (7.1.14-1+ubuntu16.04.1+deb.sury.org+1) ...
Voorheen niet geselecteerd pakket php7.1-readline wordt geselecteerd.
Uitpakken van .../php7.1-readline_7.1.14-1+ubuntu16.04.1+deb.sury.org+1_amd64.deb wordt voorbereid...
Bezig met uitpakken van php7.1-readline (7.1.14-1+ubuntu16.04.1+deb.sury.org+1) ...
Voorheen niet geselecteerd pakket php7.1-cli wordt geselecteerd.
Uitpakken van .../php7.1-cli_7.1.14-1+ubuntu16.04.1+deb.sury.org+1_amd64.deb wordt voorbereid...
Bezig met uitpakken van php7.1-cli (7.1.14-1+ubuntu16.04.1+deb.sury.org+1) ...
Voorheen niet geselecteerd pakket libapache2-mod-php7.1 wordt geselecteerd.
Uitpakken van .../libapache2-mod-php7.1_7.1.14-1+ubuntu16.04.1+deb.sury.org+1_amd64.deb wordt voorbereid...
Bezig met uitpakken van libapache2-mod-php7.1 (7.1.14-1+ubuntu16.04.1+deb.sury.org+1) ...
Voorheen niet geselecteerd pakket libcurl3:amd64 wordt geselecteerd.
Uitpakken van .../libcurl3_7.47.0-1ubuntu2.6_amd64.deb wordt voorbereid...
Bezig met uitpakken van libcurl3:amd64 (7.47.0-1ubuntu2.6) ...
Voorheen niet geselecteerd pakket libjpeg8:amd64 wordt geselecteerd.
Uitpakken van .../libjpeg8_8c-2ubuntu8_amd64.deb wordt voorbereid...
Bezig met uitpakken van libjpeg8:amd64 (8c-2ubuntu8) ...
Voorheen niet geselecteerd pakket libjbig0:amd64 wordt geselecteerd.
Uitpakken van .../libjbig0_2.1-3.1+deb.sury.org~xenial+1_amd64.deb wordt voorbereid...
Bezig met uitpakken van libjbig0:amd64 (2.1-3.1+deb.sury.org~xenial+1) ...
Voorheen niet geselecteerd pakket libtiff5:amd64 wordt geselecteerd.
Uitpakken van .../libtiff5_4.0.6-1ubuntu0.2_amd64.deb wordt voorbereid...
Bezig met uitpakken van libtiff5:amd64 (4.0.6-1ubuntu0.2) ...
Voorheen niet geselecteerd pakket libwebp6:amd64 wordt geselecteerd.
Uitpakken van .../libwebp6_0.6.0-4+ubuntu16.04.1+deb.sury.org+1_amd64.deb wordt voorbereid...
Bezig met uitpakken van libwebp6:amd64 (0.6.0-4+ubuntu16.04.1+deb.sury.org+1) ...
Voorheen niet geselecteerd pakket libxpm4:amd64 wordt geselecteerd.
Uitpakken van .../libxpm4_1%3a3.5.11-1ubuntu0.16.04.1_amd64.deb wordt voorbereid...
Bezig met uitpakken van libxpm4:amd64 (1:3.5.11-1ubuntu0.16.04.1) ...
Voorheen niet geselecteerd pakket libgd3:amd64 wordt geselecteerd.
Uitpakken van .../libgd3_2.2.5-4+ubuntu16.04.1+deb.sury.org+2_amd64.deb wordt voorbereid...
Bezig met uitpakken van libgd3:amd64 (2.2.5-4+ubuntu16.04.1+deb.sury.org+2) ...
Voorheen niet geselecteerd pakket libmcrypt4 wordt geselecteerd.
Uitpakken van .../libmcrypt4_2.5.8-3.3_amd64.deb wordt voorbereid...
Bezig met uitpakken van libmcrypt4 (2.5.8-3.3) ...
Voorheen niet geselecteerd pakket libxslt1.1:amd64 wordt geselecteerd.
Uitpakken van .../libxslt1.1_1.1.28-2.1ubuntu0.1_amd64.deb wordt voorbereid...
Bezig met uitpakken van libxslt1.1:amd64 (1.1.28-2.1ubuntu0.1) ...
Voorheen niet geselecteerd pakket libzip5:amd64 wordt geselecteerd.
Uitpakken van .../libzip5_1.3.2-1+ubuntu16.04.1+deb.sury.org+1_amd64.deb wordt voorbereid...
Bezig met uitpakken van libzip5:amd64 (1.3.2-1+ubuntu16.04.1+deb.sury.org+1) ...
Voorheen niet geselecteerd pakket php7.1 wordt geselecteerd.
Uitpakken van .../php7.1_7.1.14-1+ubuntu16.04.1+deb.sury.org+1_all.deb wordt voorbereid...
Bezig met uitpakken van php7.1 (7.1.14-1+ubuntu16.04.1+deb.sury.org+1) ...
Voorheen niet geselecteerd pakket php7.1-bcmath wordt geselecteerd.
Uitpakken van .../php7.1-bcmath_7.1.14-1+ubuntu16.04.1+deb.sury.org+1_amd64.deb wordt voorbereid...
Bezig met uitpakken van php7.1-bcmath (7.1.14-1+ubuntu16.04.1+deb.sury.org+1) ...
Voorheen niet geselecteerd pakket php7.1-curl wordt geselecteerd.
Uitpakken van .../php7.1-curl_7.1.14-1+ubuntu16.04.1+deb.sury.org+1_amd64.deb wordt voorbereid...
Bezig met uitpakken van php7.1-curl (7.1.14-1+ubuntu16.04.1+deb.sury.org+1) ...
Voorheen niet geselecteerd pakket php7.1-gd wordt geselecteerd.
Uitpakken van .../php7.1-gd_7.1.14-1+ubuntu16.04.1+deb.sury.org+1_amd64.deb wordt voorbereid...
Bezig met uitpakken van php7.1-gd (7.1.14-1+ubuntu16.04.1+deb.sury.org+1) ...
Voorheen niet geselecteerd pakket php7.1-intl wordt geselecteerd.
Uitpakken van .../php7.1-intl_7.1.14-1+ubuntu16.04.1+deb.sury.org+1_amd64.deb wordt voorbereid...
Bezig met uitpakken van php7.1-intl (7.1.14-1+ubuntu16.04.1+deb.sury.org+1) ...
Voorheen niet geselecteerd pakket php7.1-mbstring wordt geselecteerd.
Uitpakken van .../php7.1-mbstring_7.1.14-1+ubuntu16.04.1+deb.sury.org+1_amd64.deb wordt voorbereid...
Bezig met uitpakken van php7.1-mbstring (7.1.14-1+ubuntu16.04.1+deb.sury.org+1) ...
Voorheen niet geselecteerd pakket php7.1-mcrypt wordt geselecteerd.
Uitpakken van .../php7.1-mcrypt_7.1.14-1+ubuntu16.04.1+deb.sury.org+1_amd64.deb wordt voorbereid...
Bezig met uitpakken van php7.1-mcrypt (7.1.14-1+ubuntu16.04.1+deb.sury.org+1) ...
Voorheen niet geselecteerd pakket php7.1-mysql wordt geselecteerd.
Uitpakken van .../php7.1-mysql_7.1.14-1+ubuntu16.04.1+deb.sury.org+1_amd64.deb wordt voorbereid...
Bezig met uitpakken van php7.1-mysql (7.1.14-1+ubuntu16.04.1+deb.sury.org+1) ...
Voorheen niet geselecteerd pakket php7.1-soap wordt geselecteerd.
Uitpakken van .../php7.1-soap_7.1.14-1+ubuntu16.04.1+deb.sury.org+1_amd64.deb wordt voorbereid...
Bezig met uitpakken van php7.1-soap (7.1.14-1+ubuntu16.04.1+deb.sury.org+1) ...
Voorheen niet geselecteerd pakket php7.1-xml wordt geselecteerd.
Uitpakken van .../php7.1-xml_7.1.14-1+ubuntu16.04.1+deb.sury.org+1_amd64.deb wordt voorbereid...
Bezig met uitpakken van php7.1-xml (7.1.14-1+ubuntu16.04.1+deb.sury.org+1) ...
Voorheen niet geselecteerd pakket php7.1-xsl wordt geselecteerd.
Uitpakken van .../php7.1-xsl_7.1.14-1+ubuntu16.04.1+deb.sury.org+1_all.deb wordt voorbereid...
Bezig met uitpakken van php7.1-xsl (7.1.14-1+ubuntu16.04.1+deb.sury.org+1) ...
Voorheen niet geselecteerd pakket php7.1-zip wordt geselecteerd.
Uitpakken van .../php7.1-zip_7.1.14-1+ubuntu16.04.1+deb.sury.org+1_amd64.deb wordt voorbereid...
Bezig met uitpakken van php7.1-zip (7.1.14-1+ubuntu16.04.1+deb.sury.org+1) ...
Bezig met afhandelen van triggers voor libc-bin (2.23-0ubuntu10) ...
Bezig met afhandelen van triggers voor man-db (2.7.5-1) ...
Instellen van libxau6:amd64 (1:1.0.8-1) ...
Instellen van libjpeg-turbo8:amd64 (1.4.2-0ubuntu3) ...
Instellen van libssl1.1:amd64 (1.1.0g-2.1+ubuntu16.04.1+deb.sury.org+1) ...
Instellen van libxdmcp6:amd64 (1:1.1.2-1.1) ...
Instellen van libxcb1:amd64 (1.11.1-1ubuntu1) ...
Instellen van libx11-data (2:1.6.3-1ubuntu2) ...
Instellen van libx11-6:amd64 (2:1.6.3-1ubuntu2) ...
Instellen van php-common (1:60+ubuntu16.04.1+deb.sury.org+1) ...
Instellen van php7.1-common (7.1.14-1+ubuntu16.04.1+deb.sury.org+1) ...

Creating config file /etc/php/7.1/mods-available/calendar.ini with new version

Creating config file /etc/php/7.1/mods-available/ctype.ini with new version

Creating config file /etc/php/7.1/mods-available/exif.ini with new version

Creating config file /etc/php/7.1/mods-available/fileinfo.ini with new version

Creating config file /etc/php/7.1/mods-available/ftp.ini with new version

Creating config file /etc/php/7.1/mods-available/gettext.ini with new version

Creating config file /etc/php/7.1/mods-available/iconv.ini with new version

Creating config file /etc/php/7.1/mods-available/pdo.ini with new version

Creating config file /etc/php/7.1/mods-available/phar.ini with new version

Creating config file /etc/php/7.1/mods-available/posix.ini with new version

Creating config file /etc/php/7.1/mods-available/shmop.ini with new version

Creating config file /etc/php/7.1/mods-available/sockets.ini with new version

Creating config file /etc/php/7.1/mods-available/sysvmsg.ini with new version

Creating config file /etc/php/7.1/mods-available/sysvsem.ini with new version

Creating config file /etc/php/7.1/mods-available/sysvshm.ini with new version

Creating config file /etc/php/7.1/mods-available/tokenizer.ini with new version
Instellen van php7.1-json (7.1.14-1+ubuntu16.04.1+deb.sury.org+1) ...

Creating config file /etc/php/7.1/mods-available/json.ini with new version
Instellen van php7.1-opcache (7.1.14-1+ubuntu16.04.1+deb.sury.org+1) ...

Creating config file /etc/php/7.1/mods-available/opcache.ini with new version
Instellen van php7.1-readline (7.1.14-1+ubuntu16.04.1+deb.sury.org+1) ...

Creating config file /etc/php/7.1/mods-available/readline.ini with new version
Instellen van php7.1-cli (7.1.14-1+ubuntu16.04.1+deb.sury.org+1) ...
update-alternatives: /usr/bin/php7.1 wordt gebruikt om in de automatische modus in /usr/bin/php (php) te voorzien.
update-alternatives: /usr/bin/phar7.1 wordt gebruikt om in de automatische modus in /usr/bin/phar (phar) te voorzien.
update-alternatives: /usr/bin/phar.phar7.1 wordt gebruikt om in de automatische modus in /usr/bin/phar.phar (phar.phar) te voorzien.

Creating config file /etc/php/7.1/cli/php.ini with new version
Instellen van libapache2-mod-php7.1 (7.1.14-1+ubuntu16.04.1+deb.sury.org+1) ...

Creating config file /etc/php/7.1/apache2/php.ini with new version
Module mpm_event disabled.
Enabling module mpm_prefork.
apache2_switch_mpm Switch to prefork
apache2_invoke: Enable module php7.1
Instellen van libcurl3:amd64 (7.47.0-1ubuntu2.6) ...
Instellen van libjpeg8:amd64 (8c-2ubuntu8) ...
Instellen van libjbig0:amd64 (2.1-3.1+deb.sury.org~xenial+1) ...
Instellen van libtiff5:amd64 (4.0.6-1ubuntu0.2) ...
Instellen van libwebp6:amd64 (0.6.0-4+ubuntu16.04.1+deb.sury.org+1) ...
Instellen van libxpm4:amd64 (1:3.5.11-1ubuntu0.16.04.1) ...
Instellen van libgd3:amd64 (2.2.5-4+ubuntu16.04.1+deb.sury.org+2) ...
Instellen van libmcrypt4 (2.5.8-3.3) ...
Instellen van libxslt1.1:amd64 (1.1.28-2.1ubuntu0.1) ...
Instellen van libzip5:amd64 (1.3.2-1+ubuntu16.04.1+deb.sury.org+1) ...
Instellen van php7.1 (7.1.14-1+ubuntu16.04.1+deb.sury.org+1) ...
Instellen van php7.1-bcmath (7.1.14-1+ubuntu16.04.1+deb.sury.org+1) ...

Creating config file /etc/php/7.1/mods-available/bcmath.ini with new version
Instellen van php7.1-curl (7.1.14-1+ubuntu16.04.1+deb.sury.org+1) ...

Creating config file /etc/php/7.1/mods-available/curl.ini with new version
Instellen van php7.1-gd (7.1.14-1+ubuntu16.04.1+deb.sury.org+1) ...

Creating config file /etc/php/7.1/mods-available/gd.ini with new version
Instellen van php7.1-intl (7.1.14-1+ubuntu16.04.1+deb.sury.org+1) ...

Creating config file /etc/php/7.1/mods-available/intl.ini with new version
Instellen van php7.1-mbstring (7.1.14-1+ubuntu16.04.1+deb.sury.org+1) ...

Creating config file /etc/php/7.1/mods-available/mbstring.ini with new version
Instellen van php7.1-mcrypt (7.1.14-1+ubuntu16.04.1+deb.sury.org+1) ...

Creating config file /etc/php/7.1/mods-available/mcrypt.ini with new version
Instellen van php7.1-mysql (7.1.14-1+ubuntu16.04.1+deb.sury.org+1) ...

Creating config file /etc/php/7.1/mods-available/mysqlnd.ini with new version

Creating config file /etc/php/7.1/mods-available/mysqli.ini with new version

Creating config file /etc/php/7.1/mods-available/pdo_mysql.ini with new version
Instellen van php7.1-soap (7.1.14-1+ubuntu16.04.1+deb.sury.org+1) ...

Creating config file /etc/php/7.1/mods-available/soap.ini with new version
Instellen van php7.1-xml (7.1.14-1+ubuntu16.04.1+deb.sury.org+1) ...

Creating config file /etc/php/7.1/mods-available/dom.ini with new version

Creating config file /etc/php/7.1/mods-available/simplexml.ini with new version

Creating config file /etc/php/7.1/mods-available/wddx.ini with new version

Creating config file /etc/php/7.1/mods-available/xml.ini with new version

Creating config file /etc/php/7.1/mods-available/xmlreader.ini with new version

Creating config file /etc/php/7.1/mods-available/xmlwriter.ini with new version

Creating config file /etc/php/7.1/mods-available/xsl.ini with new version
Instellen van php7.1-xsl (7.1.14-1+ubuntu16.04.1+deb.sury.org+1) ...
Instellen van php7.1-zip (7.1.14-1+ubuntu16.04.1+deb.sury.org+1) ...

Creating config file /etc/php/7.1/mods-available/zip.ini with new version
Bezig met afhandelen van triggers voor libc-bin (2.23-0ubuntu10) ...
Bezig met afhandelen van triggers voor libapache2-mod-php7.1 (7.1.14-1+ubuntu16.04.1+deb.sury.org+1) ...
root@h1234567:~#

## Verification core php
root@h1234567:~# php -v
PHP 7.1.14-1+ubuntu16.04.1+deb.sury.org+1 (cli) (built: Feb  9 2018 09:33:27) ( NTS )
Copyright (c) 1997-2018 The PHP Group
Zend Engine v3.1.0, Copyright (c) 1998-2018 Zend Technologies
    with Zend OPcache v7.1.14-1+ubuntu16.04.1+deb.sury.org+1, Copyright (c) 1999-2018, by Zend Technologies
root@h1234567:~#

## Verification all required PHP extensions 
root@h1234567:~# php -me
[PHP Modules]
bcmath
calendar
Core
ctype
curl
date
dom
exif
fileinfo
filter
ftp
gd
gettext
hash
iconv
intl
json
libxml
mbstring
mcrypt
mysqli
mysqlnd
openssl
pcntl
pcre
PDO
pdo_mysql
Phar
posix
readline
Reflection
session
shmop
SimpleXML
soap
sockets
SPL
standard
sysvmsg
sysvsem
sysvshm
tokenizer
wddx
xml
xmlreader
xmlwriter
xsl
Zend OPcache
zip
zlib

[Zend Modules]
Zend OPcache

root@h1234567:~#

See http://devdocs.magento.com/guides/v2.2/install-gde/prereq/php-settings.html

root@h1234567:~# php --ini
Configuration File (php.ini) Path: /etc/php/7.1/cli
Loaded Configuration File:         /etc/php/7.1/cli/php.ini
Scan for additional .ini files in: /etc/php/7.1/cli/conf.d
Additional .ini files parsed:      /etc/php/7.1/cli/conf.d/10-mysqlnd.ini,
/etc/php/7.1/cli/conf.d/10-opcache.ini,
/etc/php/7.1/cli/conf.d/10-pdo.ini,
/etc/php/7.1/cli/conf.d/15-xml.ini,
/etc/php/7.1/cli/conf.d/20-bcmath.ini,
/etc/php/7.1/cli/conf.d/20-calendar.ini,
/etc/php/7.1/cli/conf.d/20-ctype.ini,
/etc/php/7.1/cli/conf.d/20-curl.ini,
/etc/php/7.1/cli/conf.d/20-dom.ini,
/etc/php/7.1/cli/conf.d/20-exif.ini,
/etc/php/7.1/cli/conf.d/20-fileinfo.ini,
/etc/php/7.1/cli/conf.d/20-ftp.ini,
/etc/php/7.1/cli/conf.d/20-gd.ini,
/etc/php/7.1/cli/conf.d/20-gettext.ini,
/etc/php/7.1/cli/conf.d/20-iconv.ini,
/etc/php/7.1/cli/conf.d/20-intl.ini,
/etc/php/7.1/cli/conf.d/20-json.ini,
/etc/php/7.1/cli/conf.d/20-mbstring.ini,
/etc/php/7.1/cli/conf.d/20-mcrypt.ini,
/etc/php/7.1/cli/conf.d/20-mysqli.ini,
/etc/php/7.1/cli/conf.d/20-pdo_mysql.ini,
/etc/php/7.1/cli/conf.d/20-phar.ini,
/etc/php/7.1/cli/conf.d/20-posix.ini,
/etc/php/7.1/cli/conf.d/20-readline.ini,
/etc/php/7.1/cli/conf.d/20-shmop.ini,
/etc/php/7.1/cli/conf.d/20-simplexml.ini,
/etc/php/7.1/cli/conf.d/20-soap.ini,
/etc/php/7.1/cli/conf.d/20-sockets.ini,
/etc/php/7.1/cli/conf.d/20-sysvmsg.ini,
/etc/php/7.1/cli/conf.d/20-sysvsem.ini,
/etc/php/7.1/cli/conf.d/20-sysvshm.ini,
/etc/php/7.1/cli/conf.d/20-tokenizer.ini,
/etc/php/7.1/cli/conf.d/20-wddx.ini,
/etc/php/7.1/cli/conf.d/20-xmlreader.ini,
/etc/php/7.1/cli/conf.d/20-xmlwriter.ini,
/etc/php/7.1/cli/conf.d/20-xsl.ini,
/etc/php/7.1/cli/conf.d/20-zip.ini
 
 
## See location on DEV server
root@h1234567:~# ls -la /etc/php/7.1/apache2/php.ini
-rw-r--r-- 1 root root 71500 feb  9 11:42 /etc/php/7.1/apache2/php.ini
root@h1234567:~#

web server configuration
/etc/php/7.1/apache2/php.ini

PHP command-line configuration is placed in
/etc/php/7.1/cli/php.ini

For Ubuntu with Apache, OPcache settings are typically located in php.ini.

Now I changed both
/etc/php/7.1/apache2/php.ini and
/etc/php/7.1/cli/php.ini

## If files are identical, only one needs to be changed. And copy it to the other one.
root@h1234567:~# diff /etc/php/7.1/apache2/php.ini /etc/php/7.1/cli/php.ini
314c314
< disable_functions = pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_get_handler,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,pcntl_async_signals,
---
> disable_functions =
374c374
< expose_php = Off
---
> expose_php = On
404c404
< memory_limit = 128M
---
> memory_limit = -1
root@h1234567:~#

## Both need to be archived as _org and changed
## php settings and opcache setting is changed
root@h1234567:~# cp -p /etc/php/7.1/apache2/php.ini /etc/php/7.1/apache2/php.ini_org
root@h1234567:~#
root@h1234567:~# cp -p /etc/php/7.1/cli/php.ini /etc/php/7.1/cli/php.ini_org
root@h1234567:~#

root@h1234567:~# vi /etc/php/7.1/apache2/php.ini
root@h1234567:~#
root@h1234567:~# diff /etc/php/7.1/apache2/php.ini /etc/php/7.1/apache2/php.ini_org
404,405c404
< ;memory_limit = 128M JohnG - org
< memory_limit = 2G
---
> memory_limit = 128M
940,941c939
< ;date.timezone = JohnG - org
< date.timezone = Europe/Amsterdam
---
> ;date.timezone =
1822,1823c1820
< ; JohnG - uncommented
< opcache.save_comments=1
---
> ;opcache.save_comments=1
root@h1234567:~#
root@h1234567:~#

root@h1234567:~# vi /etc/php/7.1/cli/php.ini
root@h1234567:~#
root@h1234567:~# diff /etc/php/7.1/cli/php.ini /etc/php/7.1/cli/php.ini_org
404,405c404
< ;memory_limit = -1 JohnG - org
< memory_limit = 2G
---
> memory_limit = -1
940,941c939
< ;date.timezone = JohnG - org
< date.timezone = Europe/Amsterdam
---
> ;date.timezone =
1822,1823c1820
< ; JohnG - uncommented
< opcache.save_comments=1
---
> ;opcache.save_comments=1
root@h1234567:~#

root@h1234567:~# service apache2 restart
root@h1234567:~#

Composer will be installed later on.

Read general guidelines: http://devdocs.magento.com/guides/v2.2/install-gde/prereq/mysql.html#instgde-prereq-mysql-intro

Steps: http://devdocs.magento.com/guides/v2.2/install-gde/prereq/mysql.html#instgde-prereq-mysql57-ub16

Steps 1, 2, 3 and 4

## 1. Install
root@h1234567:~# apt install -y mysql-server mysql-client
Pakketlijsten worden ingelezen... Klaar
Boom van vereisten wordt opgebouwd
De statusinformatie wordt gelezen... Klaar
De volgende extra pakketten zullen geïnstalleerd worden:
  apparmor libaio1 libapparmor-perl libcgi-fast-perl libcgi-pm-perl libencode-locale-perl
  libevent-core-2.0-5 libfcgi-perl libhtml-parser-perl libhtml-tagset-perl
  libhtml-template-perl libhttp-date-perl libhttp-message-perl libio-html-perl
  liblwp-mediatypes-perl libnuma1 libtimedate-perl liburi-perl mysql-client-5.7
  mysql-client-core-5.7 mysql-server-5.7 mysql-server-core-5.7
Voorgestelde pakketten:
  apparmor-profiles apparmor-profiles-extra apparmor-docs apparmor-utils libdata-dump-perl
  libipc-sharedcache-perl libwww-perl tinyca
De volgende NIEUWE pakketten zullen geïnstalleerd worden:
  apparmor libaio1 libapparmor-perl libcgi-fast-perl libcgi-pm-perl libencode-locale-perl
  libevent-core-2.0-5 libfcgi-perl libhtml-parser-perl libhtml-tagset-perl
  libhtml-template-perl libhttp-date-perl libhttp-message-perl libio-html-perl
  liblwp-mediatypes-perl libnuma1 libtimedate-perl liburi-perl mysql-client
  mysql-client-5.7 mysql-client-core-5.7 mysql-server mysql-server-5.7
  mysql-server-core-5.7
0 opgewaardeerd, 24 nieuw geïnstalleerd, 0 te verwijderen en 2 niet opgewaardeerd.
Er moeten 19,8 MB aan archieven opgehaald worden.
Na deze bewerking zal er 164 MB extra schijfruimte gebruikt worden.
Ophalen:1 ftp://ftp.stratoserver.net/pub/linux/ubuntu xenial-updates/main amd64 libapparmor-perl amd64 2.10.95-0ubuntu2.8 [31,4 kB]
Ophalen:2 ftp://ftp.stratoserver.net/pub/linux/ubuntu xenial-updates/main amd64 apparmor amd64 2.10.95-0ubuntu2.8 [450 kB]
Ophalen:3 ftp://ftp.stratoserver.net/pub/linux/ubuntu xenial/main amd64 libaio1 amd64 0.3.110-2 [6356 B]
Ophalen:4 ftp://ftp.stratoserver.net/pub/linux/ubuntu xenial/main amd64 libnuma1 amd64 2.0.11-1ubuntu1 [21,0 kB]
Ophalen:5 ftp://ftp.stratoserver.net/pub/linux/ubuntu xenial-updates/main amd64 mysql-client-core-5.7 amd64 5.7.21-0ubuntu0.16.04.1 [6363 kB]
Ophalen:6 ftp://ftp.stratoserver.net/pub/linux/ubuntu xenial-updates/main amd64 mysql-client-5.7 amd64 5.7.21-0ubuntu0.16.04.1 [1676 kB]
Ophalen:7 ftp://ftp.stratoserver.net/pub/linux/ubuntu xenial-updates/main amd64 mysql-server-core-5.7 amd64 5.7.21-0ubuntu0.16.04.1 [7809 kB]
Ophalen:8 ftp://ftp.stratoserver.net/pub/linux/ubuntu xenial-updates/main amd64 libevent-core-2.0-5 amd64 2.0.21-stable-2ubuntu0.16.04.1 [70,6 kB]
Ophalen:9 ftp://ftp.stratoserver.net/pub/linux/ubuntu xenial-updates/main amd64 mysql-server-5.7 amd64 5.7.21-0ubuntu0.16.04.1 [2724 kB]
Ophalen:10 ftp://ftp.stratoserver.net/pub/linux/ubuntu xenial/main amd64 libhtml-tagset-perl all 3.20-2 [13,5 kB]
Ophalen:11 ftp://ftp.stratoserver.net/pub/linux/ubuntu xenial/main amd64 liburi-perl all 1.71-1 [76,9 kB]
Ophalen:12 ftp://ftp.stratoserver.net/pub/linux/ubuntu xenial/main amd64 libhtml-parser-perl amd64 3.72-1 [86,1 kB]
Ophalen:13 ftp://ftp.stratoserver.net/pub/linux/ubuntu xenial/main amd64 libcgi-pm-perl all 4.26-1 [185 kB]
Ophalen:14 ftp://ftp.stratoserver.net/pub/linux/ubuntu xenial/main amd64 libfcgi-perl amd64 0.77-1build1 [32,3 kB]
Ophalen:15 ftp://ftp.stratoserver.net/pub/linux/ubuntu xenial/main amd64 libcgi-fast-perl all 1:2.10-1 [10,2 kB]
Ophalen:16 ftp://ftp.stratoserver.net/pub/linux/ubuntu xenial/main amd64 libencode-locale-perl all 1.05-1 [12,3 kB]
Ophalen:17 ftp://ftp.stratoserver.net/pub/linux/ubuntu xenial/main amd64 libhtml-template-perl all 2.95-2 [60,4 kB]
Ophalen:18 ftp://ftp.stratoserver.net/pub/linux/ubuntu xenial/main amd64 libtimedate-perl all 2.3000-2 [37,5 kB]
Ophalen:19 ftp://ftp.stratoserver.net/pub/linux/ubuntu xenial/main amd64 libhttp-date-perl all 6.02-1 [10,4 kB]
Ophalen:20 ftp://ftp.stratoserver.net/pub/linux/ubuntu xenial/main amd64 libio-html-perl all 1.001-1 [14,9 kB]
Ophalen:21 ftp://ftp.stratoserver.net/pub/linux/ubuntu xenial/main amd64 liblwp-mediatypes-perl all 6.02-1 [21,7 kB]
Ophalen:22 ftp://ftp.stratoserver.net/pub/linux/ubuntu xenial/main amd64 libhttp-message-perl all 6.11-1 [74,3 kB]
Ophalen:23 ftp://ftp.stratoserver.net/pub/linux/ubuntu xenial-updates/main amd64 mysql-client all 5.7.21-0ubuntu0.16.04.1 [10,1 kB]
Ophalen:24 ftp://ftp.stratoserver.net/pub/linux/ubuntu xenial-updates/main amd64 mysql-server all 5.7.21-0ubuntu0.16.04.1 [10,2 kB]
19,8 MB opgehaald in 5s (3484 kB/s)
Voorconfigureren van pakketten ...
Voorheen niet geselecteerd pakket libapparmor-perl wordt geselecteerd.
(Database wordt ingelezen ... 24173 bestanden en mappen momenteel geïnstalleerd.)
Uitpakken van .../libapparmor-perl_2.10.95-0ubuntu2.8_amd64.deb wordt voorbereid...
Bezig met uitpakken van libapparmor-perl (2.10.95-0ubuntu2.8) ...
Voorheen niet geselecteerd pakket apparmor wordt geselecteerd.
Uitpakken van .../apparmor_2.10.95-0ubuntu2.8_amd64.deb wordt voorbereid...
Bezig met uitpakken van apparmor (2.10.95-0ubuntu2.8) ...
Voorheen niet geselecteerd pakket libaio1:amd64 wordt geselecteerd.
Uitpakken van .../libaio1_0.3.110-2_amd64.deb wordt voorbereid...
Bezig met uitpakken van libaio1:amd64 (0.3.110-2) ...
Voorheen niet geselecteerd pakket libnuma1:amd64 wordt geselecteerd.
Uitpakken van .../libnuma1_2.0.11-1ubuntu1_amd64.deb wordt voorbereid...
Bezig met uitpakken van libnuma1:amd64 (2.0.11-1ubuntu1) ...
Voorheen niet geselecteerd pakket mysql-client-core-5.7 wordt geselecteerd.
Uitpakken van .../mysql-client-core-5.7_5.7.21-0ubuntu0.16.04.1_amd64.deb wordt voorbereid...
Bezig met uitpakken van mysql-client-core-5.7 (5.7.21-0ubuntu0.16.04.1) ...
Voorheen niet geselecteerd pakket mysql-client-5.7 wordt geselecteerd.
Uitpakken van .../mysql-client-5.7_5.7.21-0ubuntu0.16.04.1_amd64.deb wordt voorbereid...
Bezig met uitpakken van mysql-client-5.7 (5.7.21-0ubuntu0.16.04.1) ...
Voorheen niet geselecteerd pakket mysql-server-core-5.7 wordt geselecteerd.
Uitpakken van .../mysql-server-core-5.7_5.7.21-0ubuntu0.16.04.1_amd64.deb wordt voorbereid...
Bezig met uitpakken van mysql-server-core-5.7 (5.7.21-0ubuntu0.16.04.1) ...
Voorheen niet geselecteerd pakket libevent-core-2.0-5:amd64 wordt geselecteerd.
Uitpakken van .../libevent-core-2.0-5_2.0.21-stable-2ubuntu0.16.04.1_amd64.deb wordt voorbereid...
Bezig met uitpakken van libevent-core-2.0-5:amd64 (2.0.21-stable-2ubuntu0.16.04.1) ...
Voorheen niet geselecteerd pakket mysql-server-5.7 wordt geselecteerd.
Uitpakken van .../mysql-server-5.7_5.7.21-0ubuntu0.16.04.1_amd64.deb wordt voorbereid...
Bezig met uitpakken van mysql-server-5.7 (5.7.21-0ubuntu0.16.04.1) ...
Voorheen niet geselecteerd pakket libhtml-tagset-perl wordt geselecteerd.
Uitpakken van .../libhtml-tagset-perl_3.20-2_all.deb wordt voorbereid...
Bezig met uitpakken van libhtml-tagset-perl (3.20-2) ...
Voorheen niet geselecteerd pakket liburi-perl wordt geselecteerd.
Uitpakken van .../liburi-perl_1.71-1_all.deb wordt voorbereid...
Bezig met uitpakken van liburi-perl (1.71-1) ...
Voorheen niet geselecteerd pakket libhtml-parser-perl wordt geselecteerd.
Uitpakken van .../libhtml-parser-perl_3.72-1_amd64.deb wordt voorbereid...
Bezig met uitpakken van libhtml-parser-perl (3.72-1) ...
Voorheen niet geselecteerd pakket libcgi-pm-perl wordt geselecteerd.
Uitpakken van .../libcgi-pm-perl_4.26-1_all.deb wordt voorbereid...
Bezig met uitpakken van libcgi-pm-perl (4.26-1) ...
Voorheen niet geselecteerd pakket libfcgi-perl wordt geselecteerd.
Uitpakken van .../libfcgi-perl_0.77-1build1_amd64.deb wordt voorbereid...
Bezig met uitpakken van libfcgi-perl (0.77-1build1) ...
Voorheen niet geselecteerd pakket libcgi-fast-perl wordt geselecteerd.
Uitpakken van .../libcgi-fast-perl_1%3a2.10-1_all.deb wordt voorbereid...
Bezig met uitpakken van libcgi-fast-perl (1:2.10-1) ...
Voorheen niet geselecteerd pakket libencode-locale-perl wordt geselecteerd.
Uitpakken van .../libencode-locale-perl_1.05-1_all.deb wordt voorbereid...
Bezig met uitpakken van libencode-locale-perl (1.05-1) ...
Voorheen niet geselecteerd pakket libhtml-template-perl wordt geselecteerd.
Uitpakken van .../libhtml-template-perl_2.95-2_all.deb wordt voorbereid...
Bezig met uitpakken van libhtml-template-perl (2.95-2) ...
Voorheen niet geselecteerd pakket libtimedate-perl wordt geselecteerd.
Uitpakken van .../libtimedate-perl_2.3000-2_all.deb wordt voorbereid...
Bezig met uitpakken van libtimedate-perl (2.3000-2) ...
Voorheen niet geselecteerd pakket libhttp-date-perl wordt geselecteerd.
Uitpakken van .../libhttp-date-perl_6.02-1_all.deb wordt voorbereid...
Bezig met uitpakken van libhttp-date-perl (6.02-1) ...
Voorheen niet geselecteerd pakket libio-html-perl wordt geselecteerd.
Uitpakken van .../libio-html-perl_1.001-1_all.deb wordt voorbereid...
Bezig met uitpakken van libio-html-perl (1.001-1) ...
Voorheen niet geselecteerd pakket liblwp-mediatypes-perl wordt geselecteerd.
Uitpakken van .../liblwp-mediatypes-perl_6.02-1_all.deb wordt voorbereid...
Bezig met uitpakken van liblwp-mediatypes-perl (6.02-1) ...
Voorheen niet geselecteerd pakket libhttp-message-perl wordt geselecteerd.
Uitpakken van .../libhttp-message-perl_6.11-1_all.deb wordt voorbereid...
Bezig met uitpakken van libhttp-message-perl (6.11-1) ...
Voorheen niet geselecteerd pakket mysql-client wordt geselecteerd.
Uitpakken van .../mysql-client_5.7.21-0ubuntu0.16.04.1_all.deb wordt voorbereid...
Bezig met uitpakken van mysql-client (5.7.21-0ubuntu0.16.04.1) ...
Voorheen niet geselecteerd pakket mysql-server wordt geselecteerd.
Uitpakken van .../mysql-server_5.7.21-0ubuntu0.16.04.1_all.deb wordt voorbereid...
Bezig met uitpakken van mysql-server (5.7.21-0ubuntu0.16.04.1) ...
Bezig met afhandelen van triggers voor systemd (229-4ubuntu21.1) ...
Bezig met afhandelen van triggers voor man-db (2.7.5-1) ...
Bezig met afhandelen van triggers voor libc-bin (2.23-0ubuntu10) ...
Instellen van libapparmor-perl (2.10.95-0ubuntu2.8) ...
Instellen van apparmor (2.10.95-0ubuntu2.8) ...
update-rc.d: warning: start and stop actions are no longer supported; falling back to defaults
diff: /var/lib/apparmor/profiles/.apparmor.md5sums: No such file or directory
Instellen van libaio1:amd64 (0.3.110-2) ...
Instellen van libnuma1:amd64 (2.0.11-1ubuntu1) ...
Instellen van mysql-client-core-5.7 (5.7.21-0ubuntu0.16.04.1) ...
Instellen van mysql-client-5.7 (5.7.21-0ubuntu0.16.04.1) ...
Instellen van mysql-server-core-5.7 (5.7.21-0ubuntu0.16.04.1) ...
Instellen van libevent-core-2.0-5:amd64 (2.0.21-stable-2ubuntu0.16.04.1) ...
Instellen van mysql-server-5.7 (5.7.21-0ubuntu0.16.04.1) ...
update-alternatives: /etc/mysql/mysql.cnf wordt gebruikt om in de automatische modus in /etc/mysql/my.cnf (my.cnf) te voorzien.
Renaming removed key_buffer and myisam-recover options (if present)
Instellen van libhtml-tagset-perl (3.20-2) ...
Instellen van liburi-perl (1.71-1) ...
Instellen van libhtml-parser-perl (3.72-1) ...
Instellen van libcgi-pm-perl (4.26-1) ...
Instellen van libfcgi-perl (0.77-1build1) ...
Instellen van libcgi-fast-perl (1:2.10-1) ...
Instellen van libencode-locale-perl (1.05-1) ...
Instellen van libhtml-template-perl (2.95-2) ...
Instellen van libtimedate-perl (2.3000-2) ...
Instellen van libhttp-date-perl (6.02-1) ...
Instellen van libio-html-perl (1.001-1) ...
Instellen van liblwp-mediatypes-perl (6.02-1) ...
Instellen van libhttp-message-perl (6.11-1) ...
Instellen van mysql-client (5.7.21-0ubuntu0.16.04.1) ...
Instellen van mysql-server (5.7.21-0ubuntu0.16.04.1) ...
Bezig met afhandelen van triggers voor systemd (229-4ubuntu21.1) ...
Bezig met afhandelen van triggers voor libc-bin (2.23-0ubuntu10) ...
root@h1234567:~#
root@h1234567:~#

## 2. Secure
root@h1234567:~# mysql_secure_installation

Securing the MySQL server deployment.

Enter password for user root:

VALIDATE PASSWORD PLUGIN can be used to test passwords
and improve security. It checks the strength of password
and allows the users to set only those passwords which are
secure enough. Would you like to setup VALIDATE PASSWORD plugin?

Press y|Y for Yes, any other key for No: Y

There are three levels of password validation policy:

LOW    Length >= 8
MEDIUM Length >= 8, numeric, mixed case, and special characters
STRONG Length >= 8, numeric, mixed case, special characters and dictionary                  file

Please enter 0 = LOW, 1 = MEDIUM and 2 = STRONG: 1
Using existing password for root.

Estimated strength of the password: 100
Change the password for root ? ((Press y|Y for Yes, any other key for No) : N

 ... skipping.
By default, a MySQL installation has an anonymous user,
allowing anyone to log into MySQL without having to have
a user account created for them. This is intended only for
testing, and to make the installation go a bit smoother.
You should remove them before moving into a production
environment.

Remove anonymous users? (Press y|Y for Yes, any other key for No) : y
Success.


Normally, root should only be allowed to connect from
'localhost'. This ensures that someone cannot guess at
the root password from the network.

Disallow root login remotely? (Press y|Y for Yes, any other key for No) : y
Success.

By default, MySQL comes with a database named 'test' that
anyone can access. This is also intended only for testing,
and should be removed before moving into a production
environment.


Remove test database and access to it? (Press y|Y for Yes, any other key for No) : y
 - Dropping test database...
Success.

 - Removing privileges on test database...
Success.

Reloading the privilege tables will ensure that all changes
made so far will take effect immediately.

Reload privilege tables now? (Press y|Y for Yes, any other key for No) : y
Success.

All done!
root@h1234567:~#

## 3. Test
root@h1234567:~# mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 6
Server version: 5.7.21-0ubuntu0.16.04.1 (Ubuntu)

Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>
mysql> SHOW VARIABLES LIKE 'max_allowed_packet';
+--------------------+----------+
| Variable_name      | Value    |
+--------------------+----------+
| max_allowed_packet | 16777216 |
+--------------------+----------+
1 row in set (0,01 sec)

mysql>
mysql> quit
Bye
root@h1234567:~#
root@h1234567:~#

## 4. Change 'max_allowed_packet' => FAILS because of strange circular reference with symbolic links
## I leave it as it is.

Step 5 is Configuring the Magento database instance
See http://devdocs.magento.com/guides/v2.2/install-gde/prereq/mysql.html#instgde-prereq-mysql-config

root@h1234567:~# mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 7
Server version: 5.7.21-0ubuntu0.16.04.1 (Ubuntu)
 
Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.
 
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
 
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
 
mysql>
mysql> create database magento;
Query OK, 1 row affected (0,01 sec)
 
mysql> GRANT ALL ON magento.* TO magento@localhost IDENTIFIED BY 'Magento2!';
Query OK, 0 rows affected, 1 warning (0,01 sec)
 
mysql>
mysql> exit
Bye
root@h1234567:~#
root@h1234567:~# mysql -u magento -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 5.7.21-0ubuntu0.16.04.1 (Ubuntu)
 
Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.
 
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
 
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
 
mysql>
mysql> exit
Bye
root@h1234567:~#

Later on I must check the following:

We recommend you configure your database instance as appropriate for your business. When configuring your database, please keep the following in mind:

  • Indexers require higher tmp_table_size and max_heap_table_size values (e.g., 64M). If you configure the batch_size parameter, you can adjust that value along with the table size settings to improve indexer performance. Refer to the Magento Optimization Guide for more information.
  • For optimal performance, make sure all MySQL and Magento index tables can be kept in memory (e.g., configure innodb_buffer_pool_size).

(See http://devdocs.magento.com/guides/v2.2/install-gde/prereq/mysql.html#instgde-prereq-mysql57-ub16 below)

See http://devdocs.magento.com/guides/v2.2/install-gde/prereq/connect-auth.html

Magento account created for John Anonymized with mailadres janonymized@nonexisting.com.
Pw: ##SCRAMBLED##

Access key created:

Step 5 says

New public and private keys are now associated with your account that you can click to copy. Save this information or keep the page open when working with your Magento project. Use the Public key as your user name and the Private key as your password.

Go to http://devdocs.magento.com/guides/v2.2/install-gde/prereq/connect-auth.html#manage-your-authentication-keys
if you need to Manage your authentication keys (e.g. disable, enable, delete).

## 1. Create Magento file system owner
root@h1234567:~# adduser magento_user
Adding user `magento_user' ...
Adding new group `magento_user' (1001) ...
Adding new user `magento_user' (1001) with group `magento_user' ...
Creating home directory `/home/magento_user' ...
Copying files from `/etc/skel' ...
Enter new UNIX password:
Retype new UNIX password:
passwd: password updated successfully
Changing the user information for magento_user
Enter the new value, or press ENTER for the default
        Full Name []:
        Room Number []:
        Work Phone []:
        Home Phone []:
        Other []:
Is the information correct? [Y/n]
 
## 2. Find web server user's group
root@h1234567:~# ps aux | grep apache
root     14637  0.0  0.1 487396 10436 ?        Ss   15:29   0:00 /usr/sbin/apache2 -k start
www-data 14640  0.0  0.0 487476  7448 ?        S    15:29   0:00 /usr/sbin/apache2 -k start
www-data 14641  0.0  0.0 487476  7444 ?        S    15:29   0:00 /usr/sbin/apache2 -k start
www-data 14642  0.0  0.0 487468  7196 ?        S    15:29   0:00 /usr/sbin/apache2 -k start
www-data 14643  0.0  0.0 487476  7448 ?        S    15:29   0:00 /usr/sbin/apache2 -k start
www-data 14644  0.0  0.0 487476  7444 ?        S    15:29   0:00 /usr/sbin/apache2 -k start
www-data 16396  0.0  0.0 487428  6856 ?        S    16:16   0:00 /usr/sbin/apache2 -k start
root     16634  0.0  0.0  12888  1068 pts/0    S+   17:41   0:00 grep --color=auto apache
root@h1234567:~#

root@h1234567:~# groups www-data
www-data : www-data
 
 
# 3. Put the Magento file system owner in the web server’s group
root@h1234567:~# usermod -a -G www-data magento_user
 
root@h1234567:~# groups magento_user
magento_user : magento_user www-data
 
root@h1234567:~# service apache2 restart
root@h1234567:~#

The -a -G options are important because they add apache or www-data as a secondary group to the user account, which preserves the user’s primary group. Adding a secondary group to a user account helps restrict file ownership and permissions to ensure members of a shared group only have access to certain files.

Step 4. Get the Magento software will be taken after the installation of Composer.

Later on we do step 5. Set ownership and permissions for the shared group

See http://devdocs.magento.com/guides/v2.2/install-gde/prereq/integrator_install.html
part Next step http://devdocs.magento.com/guides/v2.2/install-gde/prereq/integrator_install_composer.html

root@h1234567:~# composer --help
-bash: composer: command not found
root@h1234567:~#
root@h1234567:~# apt install composer
Pakketlijsten worden ingelezen... Klaar
Boom van vereisten wordt opgebouwd
De statusinformatie wordt gelezen... Klaar
De volgende extra pakketten zullen geïnstalleerd worden:
  git git-man javascript-common jsonlint liberror-perl libjs-excanvas mercurial
  mercurial-common patch php-cli-prompt php-composer-semver php-composer-spdx-licenses
  php-json-schema php-symfony-console php-symfony-filesystem php-symfony-finder
  php-symfony-process
Voorgestelde pakketten:
  git-daemon-run | git-daemon-sysvinit git-doc git-el git-email git-gui gitk gitweb
  git-arch git-cvs git-mediawiki git-svn qct kdiff3 | kdiff3-qt | kompare | meld | tkcvs
  | mgdiff wish python-mysqldb python-pygments python-openssl diffutils-doc
  php-symfony-event-dispatcher php-psr-log
De volgende NIEUWE pakketten zullen geïnstalleerd worden:
  composer git git-man javascript-common jsonlint liberror-perl libjs-excanvas mercurial
  mercurial-common patch php-cli-prompt php-composer-semver php-composer-spdx-licenses
  php-json-schema php-symfony-console php-symfony-filesystem php-symfony-finder
  php-symfony-process
0 opgewaardeerd, 18 nieuw geïnstalleerd, 0 te verwijderen en 2 niet opgewaardeerd.
Er moeten 6368 kB aan archieven opgehaald worden.
Na deze bewerking zal er 39,0 MB extra schijfruimte gebruikt worden.
Wilt u doorgaan? [J/n]
Ophalen:1 ftp://ftp.stratoserver.net/pub/linux/ubuntu xenial/universe amd64 php-symfony-console all 2.7.10-0ubuntu2 [67,1 kB]
Ophalen:2 ftp://ftp.stratoserver.net/pub/linux/ubuntu xenial/universe amd64 php-symfony-filesystem all 2.7.10-0ubuntu2 [20,5 kB]
Ophalen:3 ftp://ftp.stratoserver.net/pub/linux/ubuntu xenial/universe amd64 php-symfony-finder all 2.7.10-0ubuntu2 [33,3 kB]
Ophalen:4 ftp://ftp.stratoserver.net/pub/linux/ubuntu xenial/universe amd64 php-symfony-process all 2.7.10-0ubuntu2 [30,4 kB]
Ophalen:5 ftp://ftp.stratoserver.net/pub/linux/ubuntu xenial/universe amd64 php-json-schema all 1.6.1-1build1 [21,1 kB]
Ophalen:6 ftp://ftp.stratoserver.net/pub/linux/ubuntu xenial/universe amd64 php-composer-spdx-licenses all 1.1.2-1build1 [8960 B]
Ophalen:7 ftp://ftp.stratoserver.net/pub/linux/ubuntu xenial/universe amd64 php-composer-semver all 1.2.0-1build1 [10,0 kB]
Ophalen:8 ftp://ftp.stratoserver.net/pub/linux/ubuntu xenial/universe amd64 jsonlint all 1.4.0-1build1 [10,3 kB]
Ophalen:9 ftp://ftp.stratoserver.net/pub/linux/ubuntu xenial/universe amd64 php-cli-prompt all 1.0.1+dfsg-1build1 [4452 B]
Ophalen:10 ftp://ftp.stratoserver.net/pub/linux/ubuntu xenial/universe amd64 composer all 1.0.0~beta2-1 [283 kB]
Ophalen:11 ftp://ftp.stratoserver.net/pub/linux/ubuntu xenial/main amd64 liberror-perl all 0.17-1.2 [19,6 kB]
Ophalen:12 ftp://ftp.stratoserver.net/pub/linux/ubuntu xenial-updates/main amd64 git-man all 1:2.7.4-0ubuntu1.3 [736 kB]
Ophalen:13 ftp://ftp.stratoserver.net/pub/linux/ubuntu xenial-updates/main amd64 git amd64 1:2.7.4-0ubuntu1.3 [3102 kB]
Ophalen:14 ftp://ftp.stratoserver.net/pub/linux/ubuntu xenial/main amd64 javascript-common all 11 [6066 B]
Ophalen:15 ftp://ftp.stratoserver.net/pub/linux/ubuntu xenial/universe amd64 libjs-excanvas all 0.r3-4 [45,2 kB]
Ophalen:16 ftp://ftp.stratoserver.net/pub/linux/ubuntu xenial/universe amd64 mercurial-common all 3.7.3-1ubuntu1 [1833 kB]
Ophalen:17 ftp://ftp.stratoserver.net/pub/linux/ubuntu xenial/universe amd64 mercurial amd64 3.7.3-1ubuntu1 [46,3 kB]
Ophalen:18 ftp://ftp.stratoserver.net/pub/linux/ubuntu xenial/main amd64 patch amd64 2.7.5-1 [90,4 kB]
6368 kB opgehaald in 2s (3089 kB/s)
Voorheen niet geselecteerd pakket php-symfony-console wordt geselecteerd.
(Database wordt ingelezen ... 24845 bestanden en mappen momenteel geïnstalleerd.)
Uitpakken van .../php-symfony-console_2.7.10-0ubuntu2_all.deb wordt voorbereid...
Bezig met uitpakken van php-symfony-console (2.7.10-0ubuntu2) ...
Voorheen niet geselecteerd pakket php-symfony-filesystem wordt geselecteerd.
Uitpakken van .../php-symfony-filesystem_2.7.10-0ubuntu2_all.deb wordt voorbereid...
Bezig met uitpakken van php-symfony-filesystem (2.7.10-0ubuntu2) ...
Voorheen niet geselecteerd pakket php-symfony-finder wordt geselecteerd.
Uitpakken van .../php-symfony-finder_2.7.10-0ubuntu2_all.deb wordt voorbereid...
Bezig met uitpakken van php-symfony-finder (2.7.10-0ubuntu2) ...
Voorheen niet geselecteerd pakket php-symfony-process wordt geselecteerd.
Uitpakken van .../php-symfony-process_2.7.10-0ubuntu2_all.deb wordt voorbereid...
Bezig met uitpakken van php-symfony-process (2.7.10-0ubuntu2) ...
Voorheen niet geselecteerd pakket php-json-schema wordt geselecteerd.
Uitpakken van .../php-json-schema_1.6.1-1build1_all.deb wordt voorbereid...
Bezig met uitpakken van php-json-schema (1.6.1-1build1) ...
Voorheen niet geselecteerd pakket php-composer-spdx-licenses wordt geselecteerd.
Uitpakken van .../php-composer-spdx-licenses_1.1.2-1build1_all.deb wordt voorbereid...
Bezig met uitpakken van php-composer-spdx-licenses (1.1.2-1build1) ...
Voorheen niet geselecteerd pakket php-composer-semver wordt geselecteerd.
Uitpakken van .../php-composer-semver_1.2.0-1build1_all.deb wordt voorbereid...
Bezig met uitpakken van php-composer-semver (1.2.0-1build1) ...
Voorheen niet geselecteerd pakket jsonlint wordt geselecteerd.
Uitpakken van .../jsonlint_1.4.0-1build1_all.deb wordt voorbereid...
Bezig met uitpakken van jsonlint (1.4.0-1build1) ...
Voorheen niet geselecteerd pakket php-cli-prompt wordt geselecteerd.
Uitpakken van .../php-cli-prompt_1.0.1+dfsg-1build1_all.deb wordt voorbereid...
Bezig met uitpakken van php-cli-prompt (1.0.1+dfsg-1build1) ...
Voorheen niet geselecteerd pakket composer wordt geselecteerd.
Uitpakken van .../composer_1.0.0~beta2-1_all.deb wordt voorbereid...
Bezig met uitpakken van composer (1.0.0~beta2-1) ...
Voorheen niet geselecteerd pakket liberror-perl wordt geselecteerd.
Uitpakken van .../liberror-perl_0.17-1.2_all.deb wordt voorbereid...
Bezig met uitpakken van liberror-perl (0.17-1.2) ...
Voorheen niet geselecteerd pakket git-man wordt geselecteerd.
Uitpakken van .../git-man_1%3a2.7.4-0ubuntu1.3_all.deb wordt voorbereid...
Bezig met uitpakken van git-man (1:2.7.4-0ubuntu1.3) ...
Voorheen niet geselecteerd pakket git wordt geselecteerd.
Uitpakken van .../git_1%3a2.7.4-0ubuntu1.3_amd64.deb wordt voorbereid...
Bezig met uitpakken van git (1:2.7.4-0ubuntu1.3) ...
Voorheen niet geselecteerd pakket javascript-common wordt geselecteerd.
Uitpakken van .../javascript-common_11_all.deb wordt voorbereid...
Bezig met uitpakken van javascript-common (11) ...
Voorheen niet geselecteerd pakket libjs-excanvas wordt geselecteerd.
Uitpakken van .../libjs-excanvas_0.r3-4_all.deb wordt voorbereid...
Bezig met uitpakken van libjs-excanvas (0.r3-4) ...
Voorheen niet geselecteerd pakket mercurial-common wordt geselecteerd.
Uitpakken van .../mercurial-common_3.7.3-1ubuntu1_all.deb wordt voorbereid...
Bezig met uitpakken van mercurial-common (3.7.3-1ubuntu1) ...
Voorheen niet geselecteerd pakket mercurial wordt geselecteerd.
Uitpakken van .../mercurial_3.7.3-1ubuntu1_amd64.deb wordt voorbereid...
Bezig met uitpakken van mercurial (3.7.3-1ubuntu1) ...
Voorheen niet geselecteerd pakket patch wordt geselecteerd.
Uitpakken van .../patch_2.7.5-1_amd64.deb wordt voorbereid...
Bezig met uitpakken van patch (2.7.5-1) ...
Bezig met afhandelen van triggers voor man-db (2.7.5-1) ...
Instellen van php-symfony-console (2.7.10-0ubuntu2) ...
Instellen van php-symfony-filesystem (2.7.10-0ubuntu2) ...
Instellen van php-symfony-finder (2.7.10-0ubuntu2) ...
Instellen van php-symfony-process (2.7.10-0ubuntu2) ...
Instellen van php-json-schema (1.6.1-1build1) ...
Instellen van php-composer-spdx-licenses (1.1.2-1build1) ...
Instellen van php-composer-semver (1.2.0-1build1) ...
Instellen van jsonlint (1.4.0-1build1) ...
Instellen van php-cli-prompt (1.0.1+dfsg-1build1) ...
Instellen van composer (1.0.0~beta2-1) ...
Instellen van liberror-perl (0.17-1.2) ...
Instellen van git-man (1:2.7.4-0ubuntu1.3) ...
Instellen van git (1:2.7.4-0ubuntu1.3) ...
Instellen van javascript-common (11) ...
apache2_invoke: Enable configuration javascript-common
Instellen van libjs-excanvas (0.r3-4) ...
Instellen van mercurial-common (3.7.3-1ubuntu1) ...
Instellen van mercurial (3.7.3-1ubuntu1) ...
 
Creating config file /etc/mercurial/hgrc.d/hgext.rc with new version
Instellen van patch (2.7.5-1) ...
root@h1234567:~#
root@h1234567:~# composer --help
Usage:
  help [options] [--] [<command_name>]
 
Arguments:
  command                        The command to execute
  command_name                   The command name [default: "help"]
 
Options:
      --xml                      To output help as XML
      --format=FORMAT            The output format (txt, xml, json, or md) [default: "txt"]
      --raw                      To output raw command help
  -h, --help                     Display this help message
  -q, --quiet                    Do not output any message
  -V, --version                  Display this application version
      --ansi                     Force ANSI output
      --no-ansi                  Disable ANSI output
  -n, --no-interaction           Do not ask any interactive question
      --profile                  Display timing and memory usage information
  -d, --working-dir=WORKING-DIR  If specified, use the given directory as working directory.
  -v|vv|vvv, --verbose           Increase the verbosity of messages: 1 for normal output, 2 for more verbose output and 3 for debug
 
Help:
 The help command displays help for a given command:
 
   php /usr/bin/composer help list
 
 You can also output the help in other formats by using the --format option:
 
   php /usr/bin/composer help --format=xml list
 
 To display the list of available commands, please use the list command.
root@h1234567:~#
root@h1234567:~#

This is step 4 as referred to above (http://devdocs.magento.com/guides/v2.2/install-gde/prereq/integrator_install_ce.html#perms-over).
Particularly Magento Open Source metapackage is installed by doing this: http://devdocs.magento.com/guides/v2.2/install-gde/prereq/integrator_install_ce.html. CE stands for Community Edition.

root@h1234567:~# groups magento_user
magento_user : magento_user www-data

## Directory /var/www is home of www-data
## DocumentRoot is /var/www/html
root@h1234567:~# cd /var/www/html
root@h1234567:/var/www/html# ls -la
total 20
drwxr-xr-x 2 root root  4096 feb 13 13:46 .
drwxr-xr-x 3 root root  4096 feb 13 13:46 ..
-rw-r--r-- 1 root root 11321 feb 13 13:46 index.html

## Fix ownership and writing authorization for group 
root@h1234567:/var/www/html# chown -R www-data:www-data .
root@h1234567:/var/www/html# chmod -R g+w .

root@h1234567:/var/www/html# ls -la
total 20
drwxrwxr-x 2 www-data www-data  4096 feb 13 13:46 .
drwxr-xr-x 3 root     root      4096 feb 13 13:46 ..
-rw-rw-r-- 1 www-data www-data 11321 feb 13 13:46 index.html
## Now magento_user can create the Magento project using Composer

## Now let Composer get and install the software including dependencies
## Username and password as seen below are the Public and Private key of my account jgeerlings@eqteam.nl at the Magento Marketplace
magento_user@h1234567:/var/www/html$ composer create-project --repository-url=https://repo.magento.com/ magento/project-community-edition magento_2.2
    Authentication required (repo.magento.com):
      Username: b7579e99fb6ea0e869b3e8e81a5fd27d
      Password:
Do you want to store credentials for repo.magento.com in /home/magento_user/.composer/auth.json ? [Yn]
Installing magento/project-community-edition (2.2.2)
  - Installing magento/project-community-edition (2.2.2)
    Downloading: 100%

Created project in magento_2.2
Loading composer repositories with package information
Updating dependencies (including require-dev)
  - Installing magento/magento-composer-installer (0.1.13)
    Downloading: 100%

  - Installing magento/zendframework1 (1.13.1)
    Downloading: 100%

  - Installing zendframework/zend-stdlib (2.7.7)
    Downloading: 100%

  - Installing zendframework/zend-hydrator (1.1.0)
    Downloading: 100%

  - Installing psr/container (1.0.0)
    Downloading: 100%

  - Installing container-interop/container-interop (1.2.0)
    Downloading: 100%

  - Installing zendframework/zend-validator (2.10.2)
    Downloading: 100%

  - Installing zendframework/zend-escaper (2.5.2)
    Downloading: 100%

  - Installing zendframework/zend-uri (2.5.2)
    Downloading: 100%

  - Installing zendframework/zend-loader (2.5.1)
    Downloading: 100%

  - Installing zendframework/zend-http (2.7.0)
    Downloading: 100%

  - Installing psr/log (1.0.2)
    Downloading: 100%

  - Installing monolog/monolog (1.23.0)
    Downloading: 100%

  - Installing psr/http-message (1.0.1)
    Downloading: 100%

  - Installing zendframework/zend-diactoros (1.7.0)
    Downloading: 100%

  - Installing zendframework/zend-psr7bridge (0.2.2)
    Downloading: 100%

  - Installing zendframework/zend-servicemanager (2.7.10)
    Downloading: 100%

  - Installing zendframework/zend-filter (2.7.2)
    Downloading: 100%

  - Installing zendframework/zend-inputfilter (2.8.1)
    Downloading: 100%

  - Installing zendframework/zend-form (2.11.0)
    Downloading: 100%

  - Installing zendframework/zend-eventmanager (2.6.4)
    Downloading: 100%

  - Installing zendframework/zend-mvc (2.7.13)
    Downloading: 100%

  - Installing zendframework/zend-math (2.7.0)
    Downloading: 100%

  - Installing zendframework/zend-crypt (2.6.0)
    Downloading: 100%

  - Installing zendframework/zend-code (3.1.0)
    Downloading: 100%

  - Installing tedivm/jshrink (v1.2.0)
    Downloading: 100%

  - Installing symfony/polyfill-mbstring (v1.7.0)
    Downloading: 100%

  - Installing symfony/debug (v3.0.9)
    Downloading: 100%

  - Installing symfony/console (v2.8.34)
    Downloading: 100%

  - Installing oyejorge/less.php (v1.7.0.14)
    Downloading: 100%

  - Installing symfony/process (v2.8.34)
    Downloading: 100%

  - Installing symfony/finder (v3.4.4)
    Downloading: 100%

  - Installing symfony/filesystem (v3.4.4)
    Downloading: 100%

  - Installing seld/phar-utils (1.0.1)
    Downloading: 100%

  - Installing seld/jsonlint (1.7.1)
    Downloading: 100%

  - Installing seld/cli-prompt (1.0.3)
    Downloading: 100%

  - Installing justinrainbow/json-schema (5.2.6)
    Downloading: 100%

  - Installing composer/spdx-licenses (1.3.0)
    Downloading: 100%

  - Installing composer/semver (1.4.2)
    Downloading: 100%

  - Installing composer/ca-bundle (1.1.0)
    Downloading: 100%

  - Installing composer/composer (1.4.1)
    Downloading: 100%

  - Installing colinmollenhour/credis (1.8.2)
    Downloading: 100%

  - Installing colinmollenhour/php-redis-session-abstract (v1.3.4)
    Downloading: 100%

  - Installing magento/framework (101.0.2)
    Downloading: 100%

  - Installing magento/module-config (101.0.2)
    Downloading: 100%

  - Installing magento/module-deploy (100.2.2)
    Downloading: 100%

  - Installing magento/module-user (101.0.1)
    Downloading: 100%

  - Installing magento/module-email (100.2.1)
    Downloading: 100%

  - Installing magento/module-variable (100.2.1)
    Downloading: 100%

  - Installing magento/module-store (100.2.2)
    Downloading: 100%

  - Installing magento/module-media-storage (100.2.0)
    Downloading: 100%

  - Installing magento/module-ui (101.0.2)
    Downloading: 100%

  - Installing magento/module-require-js (100.2.0)
    Downloading: 100%

  - Installing magento/module-authorization (100.2.0)
    Downloading: 100%

  - Installing magento/module-quote (101.0.2)
    Downloading: 100%

  - Installing magento/module-catalog-inventory (100.2.2)
    Downloading: 100%

  - Installing magento/module-eav (101.0.1)
    Downloading: 100%

  - Installing magento/module-catalog (102.0.2)
    Downloading: 100%

  - Installing magento/module-backend (100.2.2)
    Downloading: 100%

  - Installing magento/module-translation (100.2.2)
    Downloading: 100%

  - Installing magento/module-developer (100.2.1)
    Downloading: 100%

  - Installing magento/module-security (100.2.0)
    Downloading: 100%

  - Installing magento/module-customer (101.0.2)
    Downloading: 100%

  - Installing magento/module-integration (100.2.1)
    Downloading: 100%

  - Installing magento/module-page-cache (100.2.1)
    Downloading: 100%

  - Installing magento/module-widget (101.0.1)
    Downloading: 100%

  - Installing magento/module-theme (100.2.2)
    Downloading: 100%

  - Installing magento/module-url-rewrite (101.0.2)
    Downloading: 100%

  - Installing magento/module-cms-url-rewrite (100.2.0)
    Downloading: 100%

  - Installing magento/module-cms (102.0.2)
    Downloading: 100%

  - Installing magento/module-catalog-url-rewrite (100.2.2)
    Downloading: 100%

  - Installing magento/module-import-export (100.2.2)
    Downloading: 100%

  - Installing magento/module-tax (100.2.2)
    Downloading: 100%

  - Installing magento/module-reports (100.2.2)
    Downloading: 100%

  - Installing magento/module-sales-rule (101.0.1)
    Downloading: 100%

  - Installing magento/module-rule (100.2.0)
    Downloading: 100%

  - Installing magento/module-catalog-rule (101.0.2)
    Downloading: 100%

  - Installing magento/module-sales (101.0.2)
    Downloading: 100%

  - Installing magento/module-shipping (100.2.2)
    Downloading: 100%

  - Installing magento/module-directory (100.2.1)
    Downloading: 100%

  - Installing magento/module-msrp (100.2.0)
    Downloading: 100%

  - Installing magento/module-checkout (100.2.2)
    Downloading: 100%

  - Installing magento/module-payment (100.2.1)
    Downloading: 100%

  - Installing magento/module-rss (100.2.0)
    Downloading: 100%

  - Installing magento/module-wishlist (101.0.1)
    Downloading: 100%

  - Installing magento/module-gift-message (100.2.0)
    Downloading: 100%

  - Installing magento/module-sales-sequence (100.2.0)
    Downloading: 100%

  - Installing magento/module-contact (100.2.1)
    Downloading: 100%

  - Installing magento/module-grouped-product (100.2.1)
    Downloading: 100%

  - Installing magento/module-downloadable (100.2.1)
    Downloading: 100%

  - Installing magento/module-newsletter (100.2.1)
    Downloading: 100%

  - Installing magento/module-review (100.2.2)
    Downloading: 100%

  - Installing magento/module-catalog-import-export (100.2.2)
    Downloading: 100%

  - Installing magento/module-product-alert (100.2.0)
    Downloading: 100%

  - Installing magento/module-indexer (100.2.1)
    Downloading: 100%

  - Installing magento/module-cron (100.2.1)
    Downloading: 100%

  - Installing magento/module-backup (100.2.1)
    Downloading: 100%

  - Installing temando/module-shipping-m2 (1.0.4)
    Downloading: 100%

  - Installing dotmailer/dotmailer-magento2-extension (2.3.8)
    Downloading: 100%

  - Installing shopialfb/facebook-module (2.2.1)
    Downloading: 100%

  - Installing magento/language-zh_hans_cn (100.2.0)
    Downloading: 100%

  - Installing magento/language-pt_br (100.2.0)
    Downloading: 100%

  - Installing magento/language-nl_nl (100.2.0)
    Downloading: 100%

  - Installing magento/language-fr_fr (100.2.0)
    Downloading: 100%

  - Installing magento/language-es_es (100.2.0)
    Downloading: 100%

  - Installing magento/language-en_us (100.2.0)
    Downloading: 100%

  - Installing magento/language-de_de (100.2.0)
    Downloading: 100%

  - Installing magento/theme-frontend-blank (100.2.1)
    Downloading: 100%

  - Installing magento/theme-frontend-luma (100.2.2)
    Downloading: 100%

  - Installing magento/theme-adminhtml-backend (100.2.1)
    Downloading: 100%

  - Installing magento/module-wishlist-analytics (100.2.0)
    Downloading: 100%

  - Installing magento/module-weee (100.2.0)
    Downloading: 100%

  - Installing magento/module-webapi (100.2.1)
    Downloading: 100%

  - Installing magento/module-webapi-security (100.2.0)
    Downloading: 100%

  - Installing magento/module-version (100.2.0)
    Downloading: 100%

  - Installing magento/module-vault (101.0.1)
    Downloading: 100%

  - Installing magento/module-usps (100.2.0)
    Downloading: 100%

  - Installing magento/module-ups (100.2.1)
    Downloading: 100%

  - Installing magento/module-tax-import-export (100.2.0)
    Downloading: 100%

  - Installing magento/module-swatches-layered-navigation (100.2.0)
    Downloading: 100%

  - Installing magento/module-configurable-product (100.2.2)
    Downloading: 100%

  - Installing magento/module-swatches (100.2.1)
    Downloading: 100%

  - Installing magento/module-swagger (100.2.1)
    Downloading: 100%

  - Installing magento/module-robots (100.2.0)
    Downloading: 100%

  - Installing magento/module-sitemap (100.2.2)
    Downloading: 100%

  - Installing magento/module-signifyd (100.2.1)
    Downloading: 100%

  - Installing magento/module-send-friend (100.2.0)
    Downloading: 100%

  - Installing magento/module-search (100.2.2)
    Downloading: 100%

  - Installing magento/module-catalog-search (100.2.2)
    Downloading: 100%

  - Installing magento/module-sample-data (100.2.1)
    Downloading: 100%

  - Installing magento/module-sales-inventory (100.2.0)
    Downloading: 100%

  - Installing magento/module-sales-analytics (100.2.0)
    Downloading: 100%

  - Installing magento/module-review-analytics (100.2.0)
    Downloading: 100%

  - Installing magento/module-release-notification (100.2.0)
    Downloading: 100%

  - Installing magento/module-quote-analytics (100.2.0)
    Downloading: 100%

  - Installing magento/module-product-video (100.2.1)
    Downloading: 100%

  - Installing magento/module-persistent (100.2.0)
    Downloading: 100%

  - Installing magento/module-instant-purchase (100.2.0)
    Downloading: 100%

  - Installing magento/module-paypal (100.2.1)
    Downloading: 100%

  - Installing magento/module-offline-shipping (100.2.1)
    Downloading: 100%

  - Installing magento/module-offline-payments (100.2.0)
    Downloading: 100%

  - Installing magento/module-new-relic-reporting (100.2.1)
    Downloading: 100%

  - Installing magento/module-multishipping (100.2.0)
    Downloading: 100%

  - Installing magento/module-layered-navigation (100.2.0)
    Downloading: 100%

  - Installing magento/module-grouped-import-export (100.2.0)
    Downloading: 100%

  - Installing magento/module-cookie (100.2.0)
    Downloading: 100%

  - Installing magento/module-google-analytics (100.2.1)
    Downloading: 100%

  - Installing magento/module-google-optimizer (100.2.1)
    Downloading: 100%

  - Installing magento/module-google-adwords (100.2.0)
    Downloading: 100%

  - Installing magento/module-fedex (100.2.0)
    Downloading: 100%

  - Installing magento/module-encryption-key (100.2.0)
    Downloading: 100%

  - Installing magento/module-downloadable-import-export (100.2.0)
    Downloading: 100%

  - Installing magento/module-dhl (100.2.0)
    Downloading: 100%

  - Installing magento/module-customer-import-export (100.2.1)
    Downloading: 100%

  - Installing magento/module-customer-analytics (100.2.0)
    Downloading: 100%

  - Installing magento/module-currency-symbol (100.2.0)
    Downloading: 100%

  - Installing magento/module-configurable-product-sales (100.2.0)
    Downloading: 100%

  - Installing magento/module-configurable-import-export (100.2.0)
    Downloading: 100%

  - Installing magento/module-checkout-agreements (100.2.0)
    Downloading: 100%

  - Installing magento/module-catalog-widget (100.2.0)
    Downloading: 100%

  - Installing magento/module-catalog-rule-configurable (100.2.0)
    Downloading: 100%

  - Installing magento/module-catalog-analytics (100.2.0)
    Downloading: 100%

  - Installing zendframework/zend-session (2.8.4)
    Downloading: 100%

  - Installing paragonie/random_compat (v2.0.11)
    Downloading: 100%

  - Installing zendframework/zend-captcha (2.7.1)
    Downloading: 100%

  - Installing zendframework/zend-db (2.9.2)
    Downloading: 100%

  - Installing magento/module-captcha (100.2.0)
    Downloading: 100%

  - Installing magento/module-cache-invalidate (100.2.0)
    Downloading: 100%

  - Installing magento/module-bundle (100.2.2)
    Downloading: 100%

  - Installing magento/module-bundle-import-export (100.2.0)
    Downloading: 100%

  - Installing braintree/braintree_php (3.25.0)
    Downloading: 100%

  - Installing magento/module-braintree (100.2.2)
    Downloading: 100%

  - Installing magento/module-authorizenet (100.2.0)
    Downloading: 100%

  - Installing magento/module-analytics (100.2.0)
    Downloading: 100%

  - Installing magento/module-advanced-pricing-import-export (100.2.1)
    Downloading: 100%

  - Installing magento/module-admin-notification (100.2.1)
    Downloading: 100%

  - Installing magento/module-marketplace (100.2.0)
    Downloading: 100%

  - Installing ramsey/uuid (3.7.1)
    Downloading: 100%

  - Installing league/climate (2.6.1)
    Downloading: 100%

  - Installing sjparkinson/static-review (4.1.1)
    Downloading: 100%

  - Installing magento/composer (1.2.0)
    Downloading: 100%

  - Installing phpseclib/phpseclib (2.0.9)
    Downloading: 100%

  - Installing symfony/event-dispatcher (v2.8.34)
    Downloading: 100%

  - Installing tubalmartin/cssmin (v4.1.0)
    Downloading: 100%

  - Installing pelago/emogrifier (V1.2.0)
    Downloading: 100%

  - Installing colinmollenhour/cache-backend-file (1.4)
    Downloading: 100%

  - Installing colinmollenhour/cache-backend-redis (1.10.2)
    Downloading: 100%

  - Installing zendframework/zend-log (2.9.2)
    Downloading: 100%

  - Installing zendframework/zend-json (2.6.1)
    Downloading: 100%

  - Installing zendframework/zend-serializer (2.8.1)
    Downloading: 100%

  - Installing zendframework/zend-di (2.6.1)
    Downloading: 100%

  - Installing zendframework/zend-config (2.6.0)
    Downloading: 100%

  - Installing zendframework/zend-view (2.10.0)
    Downloading: 100%

  - Installing zendframework/zend-i18n (2.7.4)
    Downloading: 100%

  - Installing zendframework/zend-text (2.6.0)
    Downloading: 100%

  - Installing zendframework/zend-modulemanager (2.8.2)
    Downloading: 100%

  - Installing zendframework/zend-console (2.7.0)
    Downloading: 100%

  - Installing zendframework/zend-server (2.7.0)
    Downloading: 100%

  - Installing zendframework/zend-soap (2.7.0)
    Downloading: 100%

  - Installing magento/magento2-base (2.2.2)
    Downloading: 100%

  - Installing squizlabs/php_codesniffer (3.1.1)
    Downloading: 100%

  - Installing lusitanian/oauth (v0.8.10)
    Downloading: 100%

  - Installing theseer/fdomdocument (1.6.6)
    Downloading: 100%

  - Installing sebastian/version (2.0.1)
    Downloading: 100%

  - Installing sebastian/resource-operations (1.0.0)
    Downloading: 100%

  - Installing sebastian/recursion-context (3.0.0)
    Downloading: 100%

  - Installing sebastian/object-reflector (1.1.1)
    Downloading: 100%

  - Installing sebastian/object-enumerator (3.0.3)
    Downloading: 100%

  - Installing sebastian/global-state (2.0.0)
    Downloading: 100%

  - Installing sebastian/exporter (3.1.0)
    Downloading: 100%

  - Installing sebastian/environment (3.1.0)
    Downloading: 100%

  - Installing sebastian/diff (1.4.3)
    Downloading: 100%

  - Installing sebastian/comparator (2.0.0)
    Downloading: 100%

  - Installing doctrine/instantiator (1.1.0)
    Downloading: 100%

  - Installing phpunit/php-text-template (1.2.1)
    Downloading: 100%

  - Installing phpunit/phpunit-mock-objects (4.0.4)
    Downloading: 100%

  - Installing phpunit/php-timer (1.0.9)
    Downloading: 100%

  - Installing phpunit/php-file-iterator (1.4.5)
    Downloading: 100%

  - Installing theseer/tokenizer (1.1.0)
    Downloading: 100%

  - Installing sebastian/code-unit-reverse-lookup (1.0.1)
    Downloading: 100%

  - Installing phpunit/php-token-stream (2.0.2)
    Downloading: 100%

  - Installing phpunit/php-code-coverage (5.3.0)
    Downloading: 100%

  - Installing webmozart/assert (1.3.0)
    Downloading: 100%

  - Installing phpdocumentor/reflection-common (1.0.1)
    Downloading: 100%

  - Installing phpdocumentor/type-resolver (0.4.0)
    Downloading: 100%

  - Installing phpdocumentor/reflection-docblock (4.3.0)
    Downloading: 100%

  - Installing phpspec/prophecy (1.7.4)
    Downloading: 100%

  - Installing phar-io/version (1.0.1)
    Downloading: 100%

  - Installing phar-io/manifest (1.0.1)
    Downloading: 100%

  - Installing myclabs/deep-copy (1.7.0)
    Downloading: 100%

  - Installing phpunit/phpunit (6.2.4)
    Downloading: 100%

  - Installing sebastian/finder-facade (1.2.2)
    Downloading: 100%

  - Installing sebastian/phpcpd (2.0.4)
    Downloading: 100%

  - Installing symfony/dependency-injection (v3.4.4)
    Downloading: 100%

  - Installing symfony/config (v3.4.4)
    Downloading: 100%

  - Installing pdepend/pdepend (2.5.0)
    Downloading: 100%

  - Installing phpmd/phpmd (2.6.0)
    Downloading: 100%

  - Installing symfony/stopwatch (v4.0.4)
    Downloading: 100%

  - Installing symfony/polyfill-php72 (v1.7.0)
    Downloading: 100%

  - Installing symfony/polyfill-php70 (v1.7.0)
    Downloading: 100%

  - Installing ircmaxell/password-compat (v1.0.4)
    Downloading: 100%

  - Installing symfony/polyfill-php55 (v1.7.0)
    Downloading: 100%

  - Installing symfony/polyfill-php54 (v1.7.0)
    Downloading: 100%

  - Installing symfony/options-resolver (v4.0.4)
    Downloading: 100%

  - Installing gecko-packages/gecko-php-unit (v2.2)
    Downloading: 100%

  - Installing doctrine/lexer (v1.0.1)
    Downloading: 100%

  - Installing doctrine/annotations (v1.6.0)
    Downloading: 100%

  - Installing friendsofphp/php-cs-fixer (v2.2.16)
    Downloading: 100%

zendframework/zend-validator suggests installing zendframework/zend-i18n-resources (Translations of validator messages)
monolog/monolog suggests installing aws/aws-sdk-php (Allow sending log messages to AWS services like DynamoDB)
monolog/monolog suggests installing doctrine/couchdb (Allow sending log messages to a CouchDB server)
monolog/monolog suggests installing ext-amqp (Allow sending log messages to an AMQP server (1.0+ required))
monolog/monolog suggests installing ext-mongo (Allow sending log messages to a MongoDB server)
monolog/monolog suggests installing graylog2/gelf-php (Allow sending log messages to a GrayLog2 server)
monolog/monolog suggests installing mongodb/mongodb (Allow sending log messages to a MongoDB server via PHP Driver)
monolog/monolog suggests installing php-amqplib/php-amqplib (Allow sending log messages to an AMQP server using php-amqplib)
monolog/monolog suggests installing php-console/php-console (Allow sending log messages to Google Chrome)
monolog/monolog suggests installing rollbar/rollbar (Allow sending log messages to Rollbar)
monolog/monolog suggests installing ruflin/elastica (Allow sending log messages to an Elastic Search server)
monolog/monolog suggests installing sentry/sentry (Allow sending log messages to a Sentry server)
zendframework/zend-servicemanager suggests installing ocramius/proxy-manager (ProxyManager 0.5.* to handle lazy initialization of services)
zendframework/zend-form suggests installing zendframework/zendservice-recaptcha (in order to use the ReCaptcha form element)
zendframework/zend-mvc suggests installing zendframework/zend-authentication (Zend\Authentication component for Identity plugin)
zendframework/zend-mvc suggests installing zendframework/zend-servicemanager-di (^1.0.1, if using zend-servicemanager v3 and requiring the zend-di integration)
zendframework/zend-math suggests installing ext-gmp (If using the gmp functionality)
zendframework/zend-math suggests installing ircmaxell/random-lib (Fallback random byte generator for Zend\Math\Rand if Mcrypt extensions is unavailable)
magento/framework suggests installing ext-imagick (Use Image Magick >=3.0.0 as an optional alternative image processing library)
magento/module-catalog suggests installing magento/module-catalog-sample-data (Sample Data version:100.2.*)
magento/module-customer suggests installing magento/module-customer-sample-data (Sample Data version:100.2.*)
magento/module-widget suggests installing magento/module-widget-sample-data (Sample Data version:100.2.*)
magento/module-theme suggests installing magento/module-theme-sample-data (Sample Data version:100.2.*)
magento/module-cms suggests installing magento/module-cms-sample-data (Sample Data version:100.2.*)
magento/module-tax suggests installing magento/module-tax-sample-data (Sample Data version:100.2.*)
magento/module-sales-rule suggests installing magento/module-sales-rule-sample-data (Sample Data version:100.2.*)
magento/module-catalog-rule suggests installing magento/module-catalog-rule-sample-data (Sample Data version:100.2.*)
magento/module-sales suggests installing magento/module-sales-sample-data (Sample Data version:100.2.*)
magento/module-msrp suggests installing magento/module-msrp-sample-data (Sample Data version:100.2.*)
magento/module-wishlist suggests installing magento/module-wishlist-sample-data (Sample Data version:100.2.*)
magento/module-grouped-product suggests installing magento/module-grouped-product-sample-data (Sample Data version:100.2.*)
magento/module-downloadable suggests installing magento/module-downloadable-sample-data (Sample Data version:100.2.*)
magento/module-review suggests installing magento/module-review-sample-data (Sample Data version:100.2.*)
magento/module-configurable-product suggests installing magento/module-configurable-sample-data (Sample Data version:100.2.*)
magento/module-configurable-product suggests installing magento/module-product-links-sample-data (Sample Data version:100.2.*)
magento/module-swatches suggests installing magento/module-swatches-sample-data (Sample Data version:100.2.*)
magento/module-sample-data suggests installing magento/sample-data-media (Sample Data version:100.2.*)
magento/module-offline-shipping suggests installing magento/module-offline-shipping-sample-data (Sample Data version:100.2.*)
zendframework/zend-session suggests installing mongodb/mongodb (If you want to use the MongoDB session save handler)
zendframework/zend-session suggests installing zendframework/zend-cache (Zend\Cache component)
paragonie/random_compat suggests installing ext-libsodium (Provides a modern crypto API that can be used to generate random bytes.)
zendframework/zend-captcha suggests installing zendframework/zend-i18n-resources (Translations of captcha messages)
zendframework/zend-captcha suggests installing zendframework/zendservice-recaptcha (ZendService\ReCaptcha component)
magento/module-bundle suggests installing magento/module-bundle-sample-data (Sample Data version:100.2.*)
ramsey/uuid suggests installing ircmaxell/random-lib (Provides RandomLib for use with the RandomLibAdapter)
ramsey/uuid suggests installing ext-libsodium (Provides the PECL libsodium extension for use with the SodiumRandomGenerator)
ramsey/uuid suggests installing ext-uuid (Provides the PECL UUID extension for use with the PeclUuidTimeGenerator and PeclUuidRandomGenerator)
ramsey/uuid suggests installing moontoast/math (Provides support for converting UUID to 128-bit integer (in string form).)
ramsey/uuid suggests installing ramsey/uuid-doctrine (Allows the use of Ramsey\Uuid\Uuid as Doctrine field type.)
ramsey/uuid suggests installing ramsey/uuid-console (A console application for generating UUIDs with ramsey/uuid)
sjparkinson/static-review suggests installing sensiolabs/security-checker (Required for ComposerSecurityReview.)
phpseclib/phpseclib suggests installing ext-libsodium (SSH2/SFTP can make use of some algorithms provided by the libsodium-php extension.)
phpseclib/phpseclib suggests installing ext-gmp (Install the GMP (GNU Multiple Precision) extension in order to speed up arbitrary precision integer arithmetic operations.)
symfony/event-dispatcher suggests installing symfony/http-kernel ()
zendframework/zend-log suggests installing ext-mongo (mongo extension to use Mongo writer)
zendframework/zend-log suggests installing ext-mongodb (mongodb extension to use MongoDB writer)
zendframework/zend-log suggests installing zendframework/zend-mail (Zend\Mail component to use the email log writer)
zendframework/zend-json suggests installing zendframework/zendxml (To support Zend\Json\Json::fromXml() usage)
zendframework/zend-view suggests installing zendframework/zend-authentication (Zend\Authentication component)
zendframework/zend-view suggests installing zendframework/zend-feed (Zend\Feed component)
zendframework/zend-view suggests installing zendframework/zend-navigation (Zend\Navigation component)
zendframework/zend-view suggests installing zendframework/zend-paginator (Zend\Paginator component)
zendframework/zend-view suggests installing zendframework/zend-permissions-acl (Zend\Permissions\Acl component)
zendframework/zend-i18n suggests installing zendframework/zend-cache (Zend\Cache component)
zendframework/zend-i18n suggests installing zendframework/zend-i18n-resources (Translation resources)
lusitanian/oauth suggests installing symfony/http-foundation (Allows using the Symfony Session storage backend.)
lusitanian/oauth suggests installing predis/predis (Allows using the Redis storage backend.)
sebastian/global-state suggests installing ext-uopz (*)
phpunit/php-code-coverage suggests installing ext-xdebug (^2.5.5)
phpunit/phpunit suggests installing phpunit/php-invoker (^1.1)
phpunit/phpunit suggests installing ext-xdebug (*)
symfony/dependency-injection suggests installing symfony/yaml ()
symfony/dependency-injection suggests installing symfony/expression-language (For using expressions in service container configuration)
symfony/dependency-injection suggests installing symfony/proxy-manager-bridge (Generate service proxies to lazy load them)
symfony/config suggests installing symfony/yaml (To use the yaml reference dumper)
Package sjparkinson/static-review is abandoned, you should avoid using it. Use phpro/grumphp instead.
Writing lock file
Generating autoload files
magento_user@h1234567:/var/www/html$

## Where are these dependent software packages being installed?
## Example 1
root@h1234567:/var/www/html# find / -name phpspec
/var/www/html/magento_2.2/vendor/phpspec
/home/magento_user/.composer/cache/files/phpspec
root@h1234567:/var/www/html#

## Example 2
root@h1234567:/var/www/html# find / -name module-checkout-agreements
/var/www/html/magento_2.2/vendor/magento/module-checkout-agreements
/home/magento_user/.composer/cache/files/magento/module-checkout-agreements
root@h1234567:/var/www/html#

## Conclusion: inside the magento_2.2 directory that was created shortly before.

See http://devdocs.magento.com/guides/v2.2/install-gde/prereq/integrator_install_ce.html#perms-set-two-users
this is Step 5.

## All steps were executed by root
root@h1234567:/var/www/html# ls -la
total 24
drwxrwxr-x  3 www-data     www-data      4096 feb 14 09:24 .
drwxr-xr-x  3 root         root          4096 feb 13 13:46 ..
-rw-rw-r--  1 www-data     www-data     11321 feb 13 13:46 index.html
drwxrwxr-x 13 magento_user magento_user  4096 feb 14 09:30 magento_2.2
 
## Change group 
root@h1234567:/var/www/html# chown -R magento_user:www-data magento_2.2
 
root@h1234567:/var/www/html# ls -la  magento_2.2
total 1160
drwxrwxr-x 13 magento_user www-data   4096 feb 14 09:30 .
drwxrwxr-x  3 www-data     www-data   4096 feb 14 09:24 ..
drwxrwxr-x  4 magento_user www-data   4096 feb 14 09:30 app
-rw-rw-r--  1 magento_user www-data    138 feb 14 09:30 auth.json.sample
drwxrwxr-x  2 magento_user www-data   4096 feb 14 09:30 bin
-rw-rw-r--  1 magento_user www-data 566648 feb 14 09:30 CHANGELOG.md
-rw-rw-rw-  1 magento_user www-data   1921 dec 11 17:59 composer.json
-rw-rw-r--  1 magento_user www-data 442644 feb 14 09:30 composer.lock
-rw-rw-r--  1 magento_user www-data   3671 feb 14 09:30 CONTRIBUTING.md
-rw-rw-r--  1 magento_user www-data    647 feb 14 09:30 COPYING.txt
drwxrwxr-x  5 magento_user www-data   4096 feb 14 09:30 dev
drwxrwxr-x  2 magento_user www-data   4096 feb 14 09:30 generated
-rw-rw-rw-  1 magento_user www-data   1437 dec 11 17:59 .gitignore
-rw-rw-r--  1 magento_user www-data     57 feb 14 09:30 grunt-config.json.sample
-rw-rw-r--  1 magento_user www-data   2994 feb 14 09:30 Gruntfile.js.sample
-rw-rw-r--  1 magento_user www-data  11951 feb 14 09:30 .htaccess
-rw-rw-r--  1 magento_user www-data  11475 feb 14 09:30 .htaccess.sample
-rw-rw-r--  1 magento_user www-data   1370 feb 14 09:30 index.php
-rw-rw-r--  1 magento_user www-data    691 feb 14 09:30 ISSUE_TEMPLATE.md
drwxrwxr-x  4 magento_user www-data   4096 feb 14 09:30 lib
-rw-rw-r--  1 magento_user www-data  10376 feb 14 09:30 LICENSE_AFL.txt
-rw-rw-r--  1 magento_user www-data  10364 feb 14 09:30 LICENSE.txt
-rw-rw-r--  1 magento_user www-data   5531 feb 14 09:30 nginx.conf.sample
-rw-rw-r--  1 magento_user www-data   1415 feb 14 09:30 package.json.sample
-rw-rw-r--  1 magento_user www-data   1757 feb 14 09:30 .php_cs.dist
-rw-rw-r--  1 magento_user www-data    804 feb 14 09:30 php.ini.sample
drwxrwxr-x  2 magento_user www-data   4096 feb 14 09:30 phpserver
drwxrwxr-x  6 magento_user www-data   4096 feb 14 09:30 pub
-rw-rw-r--  1 magento_user www-data    804 feb 14 09:30 PULL_REQUEST_TEMPLATE.md
drwxrwxr-x  7 magento_user www-data   4096 feb 14 09:30 setup
-rw-rw-r--  1 magento_user www-data   1820 feb 14 09:30 .travis.yml
drwxrwxr-x  7 magento_user www-data   4096 feb 14 09:24 update
-rw-rw-r--  1 magento_user www-data    101 feb 14 09:30 .user.ini
drwxrwxr-x  2 magento_user www-data   4096 feb 14 09:30 var
drwxrwxr-x 42 magento_user www-data   4096 feb 14 09:30 vendor
 
root@h1234567:/var/www/html# cd magento_2.2
 
## Some files get write authorization for group
root@h1234567:/var/www/html/magento_2.2# find var generated vendor pub/static pub/media app/etc -type f -exec chmod g+w {} \;
 
## Some dirs get write authorization and sticky bit for group
root@h1234567:/var/www/html/magento_2.2# find var generated vendor pub/static pub/media app/etc -type d -exec chmod g+ws {} \;
 
root@h1234567:/var/www/html/magento_2.2# ls -la
total 1160
drwxrwxr-x 13 magento_user www-data   4096 feb 14 09:30 .
drwxrwxr-x  3 www-data     www-data   4096 feb 14 09:24 ..
drwxrwxr-x  4 magento_user www-data   4096 feb 14 09:30 app
-rw-rw-r--  1 magento_user www-data    138 feb 14 09:30 auth.json.sample
drwxrwxr-x  2 magento_user www-data   4096 feb 14 09:30 bin
-rw-rw-r--  1 magento_user www-data 566648 feb 14 09:30 CHANGELOG.md
-rw-rw-rw-  1 magento_user www-data   1921 dec 11 17:59 composer.json
-rw-rw-r--  1 magento_user www-data 442644 feb 14 09:30 composer.lock
-rw-rw-r--  1 magento_user www-data   3671 feb 14 09:30 CONTRIBUTING.md
-rw-rw-r--  1 magento_user www-data    647 feb 14 09:30 COPYING.txt
drwxrwxr-x  5 magento_user www-data   4096 feb 14 09:30 dev
drwxrwsr-x  2 magento_user www-data   4096 feb 14 09:30 generated
-rw-rw-rw-  1 magento_user www-data   1437 dec 11 17:59 .gitignore
-rw-rw-r--  1 magento_user www-data     57 feb 14 09:30 grunt-config.json.sample
-rw-rw-r--  1 magento_user www-data   2994 feb 14 09:30 Gruntfile.js.sample
-rw-rw-r--  1 magento_user www-data  11951 feb 14 09:30 .htaccess
-rw-rw-r--  1 magento_user www-data  11475 feb 14 09:30 .htaccess.sample
-rw-rw-r--  1 magento_user www-data   1370 feb 14 09:30 index.php
-rw-rw-r--  1 magento_user www-data    691 feb 14 09:30 ISSUE_TEMPLATE.md
drwxrwxr-x  4 magento_user www-data   4096 feb 14 09:30 lib
-rw-rw-r--  1 magento_user www-data  10376 feb 14 09:30 LICENSE_AFL.txt
-rw-rw-r--  1 magento_user www-data  10364 feb 14 09:30 LICENSE.txt
-rw-rw-r--  1 magento_user www-data   5531 feb 14 09:30 nginx.conf.sample
-rw-rw-r--  1 magento_user www-data   1415 feb 14 09:30 package.json.sample
-rw-rw-r--  1 magento_user www-data   1757 feb 14 09:30 .php_cs.dist
-rw-rw-r--  1 magento_user www-data    804 feb 14 09:30 php.ini.sample
drwxrwxr-x  2 magento_user www-data   4096 feb 14 09:30 phpserver
drwxrwxr-x  6 magento_user www-data   4096 feb 14 09:30 pub
-rw-rw-r--  1 magento_user www-data    804 feb 14 09:30 PULL_REQUEST_TEMPLATE.md
drwxrwxr-x  7 magento_user www-data   4096 feb 14 09:30 setup
-rw-rw-r--  1 magento_user www-data   1820 feb 14 09:30 .travis.yml
drwxrwxr-x  7 magento_user www-data   4096 feb 14 09:24 update
-rw-rw-r--  1 magento_user www-data    101 feb 14 09:30 .user.ini
drwxrwsr-x  2 magento_user www-data   4096 feb 14 09:30 var
drwxrwsr-x 42 magento_user www-data   4096 feb 14 09:30 vendor
 
root@h1234567:/var/www/html/magento_2.2# ls -la bin/magento
-rwxr-xr-x 1 magento_user www-data 799 feb 14 09:30 bin/magento
## Not necessary to execute this command
root@h1234567:/var/www/html/magento_2.2# chmod u+x bin/magento
root@h1234567:/var/www/html/magento_2.2# ls -la bin/magento
-rwxr-xr-x 1 magento_user www-data 799 feb 14 09:30 bin/magento
root@h1234567:/var/www/html/magento_2.2#

IP address is 99.123.122.121

root@h1234567:/var/www/html/magento_2.2# ifconfig -a
lo        Link encap:Local Loopback
          inet addr:127.0.0.1  Mask:255.0.0.0
          inet6 addr: ::1/128 Scope:Host
          UP LOOPBACK RUNNING  MTU:65536  Metric:1
          RX packets:0 errors:0 dropped:0 overruns:0 frame:0
          TX packets:0 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:0
          RX bytes:0 (0.0 B)  TX bytes:0 (0.0 B)
 
venet0    Link encap:UNSPEC  HWaddr 00-00-00-00-00-00-00-00-00-00-00-00-00-00-00-00
          inet addr:127.0.0.1  P-t-P:127.0.0.1  Bcast:0.0.0.0  Mask:255.255.255.255
          inet6 addr: ::2/128 Scope:Compat
          UP BROADCAST POINTOPOINT RUNNING NOARP  MTU:1500  Metric:1
          RX packets:70575 errors:0 dropped:0 overruns:0 frame:0
          TX packets:66777 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:0
          RX bytes:136107598 (136.1 MB)  TX bytes:7145904 (7.1 MB)
 
venet0:0  Link encap:UNSPEC  HWaddr 00-00-00-00-00-00-00-00-00-00-00-00-00-00-00-00
          inet addr:99.123.122.121  P-t-P:99.123.122.121  Bcast:99.123.122.121  Mask:255.255.255.255
          UP BROADCAST POINTOPOINT RUNNING NOARP  MTU:1500  Metric:1
 
root@h1234567:/var/www/html/magento_2.2#

Beware
For security, remove write permissions from these directories: '/var/www/html/magento_2.2/app/etc'
⇒ I'do this after installing the sample data!

Dump of the database after clean install:
magento_2.2_clean_install.sql.gz

root@h1234567:/var/www/html# ls -la
total 24
drwxrwxr-x  3 www-data     www-data  4096 feb 14 09:24 .
drwxr-xr-x  3 root         root      4096 feb 13 13:46 ..
-rw-rw-r--  1 www-data     www-data 11321 feb 13 13:46 index.html
drwxrwxr-x 13 magento_user www-data  4096 feb 14 09:30 magento_2.2
root@h1234567:/var/www/html#
root@h1234567:/var/www/html#
root@h1234567:/var/www/html# su www-data
This account is currently not available.
root@h1234567:/var/www/html# su magento_user
magento_user@h1234567:/var/www/html$
magento_user@h1234567:/var/www/html$ ls -la
total 24
drwxrwxr-x  3 www-data     www-data  4096 feb 14 09:24 .
drwxr-xr-x  3 root         root      4096 feb 13 13:46 ..
-rw-rw-r--  1 www-data     www-data 11321 feb 13 13:46 index.html
drwxrwxr-x 13 magento_user www-data  4096 feb 14 09:30 magento_2.2
magento_user@h1234567:/var/www/html$
magento_user@h1234567:/var/www/html$
magento_user@h1234567:/var/www/html$ mkdir tools
magento_user@h1234567:/var/www/html$ cd tools
magento_user@h1234567:/var/www/html/tools$ wget https://github.com/vrana/adminer/releases/download/v4.6.1/adminer-4.6.1-mysql-en.php
--2018-02-14 10:40:37--  https://github.com/vrana/adminer/releases/download/v4.6.1/adminer-4.6.1-mysql-en.php
Resolving github.com (github.com)... 192.30.253.112, 192.30.253.113
Connecting to github.com (github.com)|192.30.253.112|:443... connected.
HTTP request sent, awaiting response... 302 Found
Location: https://github-production-release-asset-2e65be.s3.amazonaws.com/627735/cec52b3c-0d30-11e8-8cdc-79a68886bceb?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIAIWNJYAX4CSVEH53A%2F20180214%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Date=20180214T094038Z&X-Amz-Expires=300&X-Amz-Signature=f0f756ae9421d7c33fce64f86d084ea614b9f241653397ea1bb9e684886f48d5&X-Amz-SignedHeaders=host&actor_id=0&response-content-disposition=attachment%3B%20filename%3Dadminer-4.6.1-mysql-en.php&response-content-type=application%2Foctet-stream [following]
--2018-02-14 10:40:38--  https://github-production-release-asset-2e65be.s3.amazonaws.com/627735/cec52b3c-0d30-11e8-8cdc-79a68886bceb?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIAIWNJYAX4CSVEH53A%2F20180214%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Date=20180214T094038Z&X-Amz-Expires=300&X-Amz-Signature=f0f756ae9421d7c33fce64f86d084ea614b9f241653397ea1bb9e684886f48d5&X-Amz-SignedHeaders=host&actor_id=0&response-content-disposition=attachment%3B%20filename%3Dadminer-4.6.1-mysql-en.php&response-content-type=application%2Foctet-stream
Resolving github-production-release-asset-2e65be.s3.amazonaws.com (github-production-release-asset-2e65be.s3.amazonaws.com)... 54.231.72.19
Connecting to github-production-release-asset-2e65be.s3.amazonaws.com (github-production-release-asset-2e65be.s3.amazonaws.com)|54.231.72.19|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 206874 (202K) [application/octet-stream]
Saving to: ‘adminer-4.6.1-mysql-en.php’
 
adminer-4.6.1-mysql-en 100%[============================>] 202,03K   387KB/s    in 0,5s
 
2018-02-14 10:40:39 (387 KB/s) - ‘adminer-4.6.1-mysql-en.php’ saved [206874/206874]
 
magento_user@h1234567:/var/www/html/tools$
magento_user@h1234567:/var/www/html/tools$ cd ..
magento_user@h1234567:/var/www/html$ find tools
tools
tools/adminer-4.6.1-mysql-en.php
magento_user@h1234567:/var/www/html$ find tools -ls
248255164      4 drwxrwxr-x   2 magento_user magento_user     4096 feb 14 10:40 tools
248255357    204 -rw-rw-r--   1 magento_user magento_user   206874 feb  9 00:33 tools/adminer-4.6.1-mysql-en.php

Step 1. Sampledata deploy

magento_user@h1234567:/var/www/html$
magento_user@h1234567:/var/www/html$ php magento_2.2/bin/magento sampledata:deploy
./composer.json has been updated
Loading composer repositories with pac
    Authentication required (repo.magento.com):
      Username: b7579e99fb6ea0e869b3e8e81a5fd27d
      Password:
Do you want to store credentials for repo.magento.com in /var/www/html/magento_2.2/var/composer_home/auth.json ? [Yn]
Updating dependencies (including require-dev)
Package operations: 20 installs, 0 updates, 0 removals
  - Installing magento/module-catalog-sample-data (100.2.0): Downloading (100%)
  - Installing magento/module-bundle-sample-data (100.2.0): Downloading (100%)
  - Installing magento/module-widget-sample-data (100.2.0): Downloading (100%)
  - Installing magento/module-customer-sample-data (100.2.0): Downloading (100%)
  - Installing magento/sample-data-media (100.2.0): Downloading (100%)
  - Installing magento/module-theme-sample-data (100.2.0): Downloading (100%)
  - Installing magento/module-cms-sample-data (100.2.0): Downloading (100%)
  - Installing magento/module-tax-sample-data (100.2.0): Downloading (100%)
  - Installing magento/module-catalog-rule-sample-data (100.2.0): Downloading (100%)
  - Installing magento/module-sales-rule-sample-data (100.2.0): Downloading (100%)
  - Installing magento/module-downloadable-sample-data (100.2.0): Downloading (100%)
  - Installing magento/module-msrp-sample-data (100.2.0): Downloading (100%)
  - Installing magento/module-wishlist-sample-data (100.2.0): Downloading (100%)
  - Installing magento/module-product-links-sample-data (100.2.0): Downloading (100%)
  - Installing magento/module-review-sample-data (100.2.0): Downloading (100%)
  - Installing magento/module-grouped-product-sample-data (100.2.0): Downloading (100%)
  - Installing magento/module-swatches-sample-data (100.2.0): Downloading (100%)
  - Installing magento/module-offline-shipping-sample-data (100.2.0): Downloading (100%)
  - Installing magento/module-configurable-sample-data (100.2.0): Downloading (100%)
  - Installing magento/module-sales-sample-data (100.2.1): Downloading (100%)
<warning>Package sjparkinson/static-review is abandoned, you should avoid using it. Use phpro/grumphp instead.</warning>
Writing lock file
Generating autoload files
magento_user@h1234567:/var/www/html$
magento_user@h1234567:/var/www/html$

Step 2. Setup upgrade

If you’re installing sample data after installing Magento, you must also run the following command to update the database and schema.

magento_user@h1234567:/var/www/html/magento_2.2$ php bin/magento setup:upgrade
Cache cleared successfully
File system cleanup:
/var/www/html/magento_2.2/generated/code/Composer
/var/www/html/magento_2.2/generated/code/Magento
/var/www/html/magento_2.2/generated/code/Symfony
/var/www/html/magento_2.2/pub/static/adminhtml
/var/www/html/magento_2.2/pub/static/deployed_version.txt
/var/www/html/magento_2.2/pub/static/frontend
/var/www/html/magento_2.2/var/view_preprocessed/pub
Updating modules:
Schema creation/updates:
Module 'Magento_Store':
Module 'Magento_Directory':
Module 'Magento_AdvancedPricingImportExport':
Module 'Magento_Config':
Module 'Magento_Backend':
Module 'Magento_Theme':
Module 'Magento_Eav':
Module 'Magento_Backup':
Module 'Magento_Customer':
Module 'Magento_AdminNotification':
Module 'Magento_BundleImportExport':
Module 'Magento_Indexer':
Module 'Magento_CacheInvalidate':
Module 'Magento_Cms':
Module 'Magento_Catalog':
Module 'Magento_Security':
Module 'Magento_CatalogImportExport':
Module 'Magento_Rule':
Module 'Magento_Cron':
Module 'Magento_Msrp':
Module 'Magento_Search':
Module 'Magento_Bundle':
Module 'Magento_Quote':
Module 'Magento_CatalogUrlRewrite':
Module 'Magento_Widget':
Module 'Magento_SalesSequence':
Module 'Magento_Payment':
Module 'Magento_CatalogInventory':
Module 'Magento_Downloadable':
Module 'Magento_CmsUrlRewrite':
Module 'Magento_User':
Module 'Magento_ConfigurableImportExport':
Module 'Magento_UrlRewrite':
Module 'Magento_Sales':
Module 'Magento_CatalogSearch':
Module 'Magento_Contact':
Module 'Magento_Cookie':
Module 'Magento_Newsletter':
Module 'Magento_CurrencySymbol':
Module 'Magento_Checkout':
Module 'Magento_Integration':
Module 'Magento_CustomerImportExport':
Module 'Magento_SampleData':
Module 'Magento_Deploy':
Module 'Magento_Developer':
Module 'Magento_Dhl':
Module 'Magento_Authorization':
Module 'Magento_Tax':
Module 'Magento_ImportExport':
Module 'Magento_Weee':
Module 'Magento_CatalogRule':
Module 'Magento_Email':
Module 'Magento_EncryptionKey':
Module 'Magento_Fedex':
Module 'Magento_GiftMessage':
Module 'Magento_GoogleAdwords':
Module 'Magento_GoogleAnalytics':
Module 'Magento_Ui':
Module 'Magento_GroupedImportExport':
Module 'Magento_GroupedProduct':
Module 'Magento_CatalogSampleData':
Module 'Magento_DownloadableImportExport':
Module 'Magento_DownloadableSampleData':
Module 'Magento_InstantPurchase':
Module 'Magento_Analytics':
Module 'Magento_LayeredNavigation':
Module 'Magento_Marketplace':
Module 'Magento_MediaStorage':
Module 'Magento_ConfigurableProduct':
Module 'Magento_MsrpSampleData':
Module 'Magento_Multishipping':
Module 'Magento_NewRelicReporting':
Module 'Magento_Reports':
Module 'Magento_OfflinePayments':
Module 'Magento_SalesRule':
Module 'Magento_OfflineShipping':
Module 'Magento_PageCache':
Module 'Magento_ConfigurableProductSales':
Module 'Magento_Vault':
Module 'Magento_Persistent':
Module 'Magento_ProductAlert':
Module 'Magento_BundleSampleData':
Module 'Magento_ProductVideo':
Module 'Magento_Paypal':
Module 'Magento_QuoteAnalytics':
Module 'Magento_ReleaseNotification':
Module 'Magento_Review':
Module 'Magento_RequireJs':
Module 'Magento_Shipping':
Module 'Magento_ReviewAnalytics':
Module 'Magento_ConfigurableSampleData':
Module 'Magento_Robots':
Module 'Magento_Rss':
Module 'Magento_CatalogRuleConfigurable':
Module 'Magento_CheckoutAgreements':
Module 'Magento_SalesAnalytics':
Module 'Magento_SalesInventory':
Module 'Magento_OfflineShippingSampleData':
Module 'Magento_CatalogRuleSampleData':
Module 'Magento_CustomerSampleData':
Module 'Magento_Captcha':
Module 'Magento_ThemeSampleData':
Module 'Magento_ProductLinksSampleData':
Module 'Magento_CustomerAnalytics':
Module 'Magento_SendFriend':
Module 'Magento_Wishlist':
Module 'Magento_Signifyd':
Module 'Magento_Sitemap':
Module 'Magento_SalesRuleSampleData':
Module 'Magento_Swagger':
Module 'Magento_Swatches':
Module 'Magento_SwatchesLayeredNavigation':
Module 'Magento_SwatchesSampleData':
Module 'Magento_ReviewSampleData':
Module 'Magento_TaxImportExport':
Module 'Magento_TaxSampleData':
Module 'Magento_Authorizenet':
Module 'Magento_CmsSampleData':
Module 'Magento_Translation':
Module 'Magento_GoogleOptimizer':
Module 'Magento_Ups':
Module 'Magento_SalesSampleData':
Module 'Magento_CatalogAnalytics':
Module 'Magento_Usps':
Module 'Magento_Variable':
Module 'Magento_Braintree':
Module 'Magento_Version':
Module 'Magento_Webapi':
Module 'Magento_WebapiSecurity':
Module 'Magento_GroupedProductSampleData':
Module 'Magento_CatalogWidget':
Module 'Magento_WidgetSampleData':
Module 'Dotdigitalgroup_Email':
Module 'Magento_WishlistAnalytics':
Module 'Magento_WishlistSampleData':
Module 'Shopial_Facebook':
Module 'Temando_Shipping':
Schema post-updates:
Module 'Magento_Store':
Module 'Magento_Directory':
Module 'Magento_AdvancedPricingImportExport':
Module 'Magento_Config':
Module 'Magento_Backend':
Module 'Magento_Theme':
Module 'Magento_Eav':
Module 'Magento_Backup':
Module 'Magento_Customer':
Module 'Magento_AdminNotification':
Module 'Magento_BundleImportExport':
Module 'Magento_Indexer':
Running schema recurring...
Module 'Magento_CacheInvalidate':
Module 'Magento_Cms':
Module 'Magento_Catalog':
Running schema recurring...
Module 'Magento_Security':
Module 'Magento_CatalogImportExport':
Module 'Magento_Rule':
Module 'Magento_Cron':
Running schema recurring...
Module 'Magento_Msrp':
Module 'Magento_Search':
Module 'Magento_Bundle':
Running schema recurring...
Module 'Magento_Quote':
Module 'Magento_CatalogUrlRewrite':
Running schema recurring...
Module 'Magento_Widget':
Module 'Magento_SalesSequence':
Module 'Magento_Payment':
Module 'Magento_CatalogInventory':
Running schema recurring...
Module 'Magento_Downloadable':
Module 'Magento_CmsUrlRewrite':
Module 'Magento_User':
Module 'Magento_ConfigurableImportExport':
Module 'Magento_UrlRewrite':
Module 'Magento_Sales':
Module 'Magento_CatalogSearch':
Module 'Magento_Contact':
Module 'Magento_Cookie':
Module 'Magento_Newsletter':
Module 'Magento_CurrencySymbol':
Module 'Magento_Checkout':
Module 'Magento_Integration':
Running schema recurring...
Module 'Magento_CustomerImportExport':
Module 'Magento_SampleData':
Module 'Magento_Deploy':
Module 'Magento_Developer':
Module 'Magento_Dhl':
Module 'Magento_Authorization':
Module 'Magento_Tax':
Module 'Magento_ImportExport':
Module 'Magento_Weee':
Running schema recurring...
Module 'Magento_CatalogRule':
Module 'Magento_Email':
Module 'Magento_EncryptionKey':
Module 'Magento_Fedex':
Module 'Magento_GiftMessage':
Module 'Magento_GoogleAdwords':
Module 'Magento_GoogleAnalytics':
Module 'Magento_Ui':
Module 'Magento_GroupedImportExport':
Module 'Magento_GroupedProduct':
Module 'Magento_CatalogSampleData':
Module 'Magento_DownloadableImportExport':
Module 'Magento_DownloadableSampleData':
Module 'Magento_InstantPurchase':
Module 'Magento_Analytics':
Module 'Magento_LayeredNavigation':
Module 'Magento_Marketplace':
Module 'Magento_MediaStorage':
Module 'Magento_ConfigurableProduct':
Running schema recurring...
Module 'Magento_MsrpSampleData':
Module 'Magento_Multishipping':
Module 'Magento_NewRelicReporting':
Module 'Magento_Reports':
Running schema recurring...
Module 'Magento_OfflinePayments':
Module 'Magento_SalesRule':
Module 'Magento_OfflineShipping':
Module 'Magento_PageCache':
Module 'Magento_ConfigurableProductSales':
Module 'Magento_Vault':
Module 'Magento_Persistent':
Module 'Magento_ProductAlert':
Running schema recurring...
Module 'Magento_BundleSampleData':
Module 'Magento_ProductVideo':
Module 'Magento_Paypal':
Module 'Magento_QuoteAnalytics':
Module 'Magento_ReleaseNotification':
Module 'Magento_Review':
Module 'Magento_RequireJs':
Module 'Magento_Shipping':
Module 'Magento_ReviewAnalytics':
Module 'Magento_ConfigurableSampleData':
Module 'Magento_Robots':
Module 'Magento_Rss':
Module 'Magento_CatalogRuleConfigurable':
Module 'Magento_CheckoutAgreements':
Module 'Magento_SalesAnalytics':
Module 'Magento_SalesInventory':
Module 'Magento_OfflineShippingSampleData':
Module 'Magento_CatalogRuleSampleData':
Module 'Magento_CustomerSampleData':
Module 'Magento_Captcha':
Module 'Magento_ThemeSampleData':
Module 'Magento_ProductLinksSampleData':
Module 'Magento_CustomerAnalytics':
Module 'Magento_SendFriend':
Module 'Magento_Wishlist':
Running schema recurring...
Module 'Magento_Signifyd':
Module 'Magento_Sitemap':
Module 'Magento_SalesRuleSampleData':
Module 'Magento_Swagger':
Module 'Magento_Swatches':
Module 'Magento_SwatchesLayeredNavigation':
Module 'Magento_SwatchesSampleData':
Module 'Magento_ReviewSampleData':
Module 'Magento_TaxImportExport':
Module 'Magento_TaxSampleData':
Module 'Magento_Authorizenet':
Module 'Magento_CmsSampleData':
Module 'Magento_Translation':
Module 'Magento_GoogleOptimizer':
Module 'Magento_Ups':
Module 'Magento_SalesSampleData':
Module 'Magento_CatalogAnalytics':
Module 'Magento_Usps':
Module 'Magento_Variable':
Module 'Magento_Braintree':
Module 'Magento_Version':
Module 'Magento_Webapi':
Module 'Magento_WebapiSecurity':
Module 'Magento_GroupedProductSampleData':
Module 'Magento_CatalogWidget':
Module 'Magento_WidgetSampleData':
Module 'Dotdigitalgroup_Email':
Running schema recurring...
Module 'Magento_WishlistAnalytics':
Module 'Magento_WishlistSampleData':
Module 'Shopial_Facebook':
Module 'Temando_Shipping':
Data install/update:
Module 'Magento_Store':
Module 'Magento_Directory':
Module 'Magento_AdvancedPricingImportExport':
Module 'Magento_Config':
Module 'Magento_Backend':
Module 'Magento_Theme':
Module 'Magento_Eav':
Module 'Magento_Backup':
Module 'Magento_Customer':
Module 'Magento_AdminNotification':
Module 'Magento_BundleImportExport':
Module 'Magento_Indexer':
Module 'Magento_CacheInvalidate':
Module 'Magento_Cms':
Module 'Magento_Catalog':
Module 'Magento_Security':
Module 'Magento_CatalogImportExport':
Module 'Magento_Rule':
Module 'Magento_Cron':
Module 'Magento_Msrp':
Module 'Magento_Search':
Module 'Magento_Bundle':
Module 'Magento_Quote':
Module 'Magento_CatalogUrlRewrite':
Module 'Magento_Widget':
Module 'Magento_SalesSequence':
Module 'Magento_Payment':
Module 'Magento_CatalogInventory':
Module 'Magento_Downloadable':
Module 'Magento_CmsUrlRewrite':
Module 'Magento_User':
Module 'Magento_ConfigurableImportExport':
Module 'Magento_UrlRewrite':
Module 'Magento_Sales':
Module 'Magento_CatalogSearch':
Module 'Magento_Contact':
Module 'Magento_Cookie':
Module 'Magento_Newsletter':
Module 'Magento_CurrencySymbol':
Module 'Magento_Checkout':
Module 'Magento_Integration':
Module 'Magento_CustomerImportExport':
Module 'Magento_SampleData':
Module 'Magento_Deploy':
Module 'Magento_Developer':
Module 'Magento_Dhl':
Module 'Magento_Authorization':
Module 'Magento_Tax':
Module 'Magento_ImportExport':
Module 'Magento_Weee':
Module 'Magento_CatalogRule':
Module 'Magento_Email':
Module 'Magento_EncryptionKey':
Module 'Magento_Fedex':
Module 'Magento_GiftMessage':
Module 'Magento_GoogleAdwords':
Module 'Magento_GoogleAnalytics':
Module 'Magento_Ui':
Module 'Magento_GroupedImportExport':
Module 'Magento_GroupedProduct':
Module 'Magento_CatalogSampleData':
Installing data...
Module 'Magento_DownloadableImportExport':
Module 'Magento_DownloadableSampleData':
Installing data...
Module 'Magento_InstantPurchase':
Module 'Magento_Analytics':
Module 'Magento_LayeredNavigation':
Module 'Magento_Marketplace':
Module 'Magento_MediaStorage':
Module 'Magento_ConfigurableProduct':
Module 'Magento_MsrpSampleData':
Installing data...
Module 'Magento_Multishipping':
Module 'Magento_NewRelicReporting':
Module 'Magento_Reports':
Module 'Magento_OfflinePayments':
Module 'Magento_SalesRule':
Module 'Magento_OfflineShipping':
Module 'Magento_PageCache':
Module 'Magento_ConfigurableProductSales':
Module 'Magento_Vault':
Module 'Magento_Persistent':
Module 'Magento_ProductAlert':
Module 'Magento_BundleSampleData':
Installing data...
Module 'Magento_ProductVideo':
Module 'Magento_Paypal':
Module 'Magento_QuoteAnalytics':
Module 'Magento_ReleaseNotification':
Module 'Magento_Review':
Module 'Magento_RequireJs':
Module 'Magento_Shipping':
Module 'Magento_ReviewAnalytics':
Module 'Magento_ConfigurableSampleData':
Installing data...
Module 'Magento_Robots':
Module 'Magento_Rss':
Module 'Magento_CatalogRuleConfigurable':
Module 'Magento_CheckoutAgreements':
Module 'Magento_SalesAnalytics':
Module 'Magento_SalesInventory':
Module 'Magento_OfflineShippingSampleData':
Installing data...
Module 'Magento_CatalogRuleSampleData':
Installing data...
Module 'Magento_CustomerSampleData':
Installing data...
Module 'Magento_Captcha':
Module 'Magento_ThemeSampleData':
Installing data...
Module 'Magento_ProductLinksSampleData':
Installing data...
Module 'Magento_CustomerAnalytics':
Module 'Magento_SendFriend':
Module 'Magento_Wishlist':
Module 'Magento_Signifyd':
Module 'Magento_Sitemap':
Module 'Magento_SalesRuleSampleData':
Installing data...
Module 'Magento_Swagger':
Module 'Magento_Swatches':
Module 'Magento_SwatchesLayeredNavigation':
Module 'Magento_SwatchesSampleData':
Installing data...
Module 'Magento_ReviewSampleData':
Installing data...
Module 'Magento_TaxImportExport':
Module 'Magento_TaxSampleData':
Installing data...
Module 'Magento_Authorizenet':
Module 'Magento_CmsSampleData':
Installing data...
Module 'Magento_Translation':
Module 'Magento_GoogleOptimizer':
Module 'Magento_Ups':
Module 'Magento_SalesSampleData':
Installing data...
Module 'Magento_CatalogAnalytics':
Module 'Magento_Usps':
Module 'Magento_Variable':
Module 'Magento_Braintree':
Module 'Magento_Version':
Module 'Magento_Webapi':
Module 'Magento_WebapiSecurity':
Module 'Magento_GroupedProductSampleData':
Installing data...
Module 'Magento_CatalogWidget':
Module 'Magento_WidgetSampleData':
Installing data...
Module 'Dotdigitalgroup_Email':
Module 'Magento_WishlistAnalytics':
Module 'Magento_WishlistSampleData':
Installing data...
Module 'Shopial_Facebook':
Module 'Temando_Shipping':
Data post-updates:
Module 'Magento_Store':
Module 'Magento_Directory':
Module 'Magento_AdvancedPricingImportExport':
Module 'Magento_Config':
Module 'Magento_Backend':
Module 'Magento_Theme':
Running data recurring...
Module 'Magento_Eav':
Module 'Magento_Backup':
Module 'Magento_Customer':
Module 'Magento_AdminNotification':
Module 'Magento_BundleImportExport':
Module 'Magento_Indexer':
Running data recurring...
Module 'Magento_CacheInvalidate':
Module 'Magento_Cms':
Module 'Magento_Catalog':
Module 'Magento_Security':
Module 'Magento_CatalogImportExport':
Module 'Magento_Rule':
Module 'Magento_Cron':
Module 'Magento_Msrp':
Module 'Magento_Search':
Module 'Magento_Bundle':
Module 'Magento_Quote':
Module 'Magento_CatalogUrlRewrite':
Module 'Magento_Widget':
Module 'Magento_SalesSequence':
Running data recurring...
Module 'Magento_Payment':
Module 'Magento_CatalogInventory':
Module 'Magento_Downloadable':
Module 'Magento_CmsUrlRewrite':
Module 'Magento_User':
Module 'Magento_ConfigurableImportExport':
Module 'Magento_UrlRewrite':
Module 'Magento_Sales':
Module 'Magento_CatalogSearch':
Module 'Magento_Contact':
Module 'Magento_Cookie':
Module 'Magento_Newsletter':
Module 'Magento_CurrencySymbol':
Module 'Magento_Checkout':
Module 'Magento_Integration':
Module 'Magento_CustomerImportExport':
Module 'Magento_SampleData':
Module 'Magento_Deploy':
Module 'Magento_Developer':
Module 'Magento_Dhl':
Module 'Magento_Authorization':
Module 'Magento_Tax':
Module 'Magento_ImportExport':
Module 'Magento_Weee':
Module 'Magento_CatalogRule':
Module 'Magento_Email':
Module 'Magento_EncryptionKey':
Module 'Magento_Fedex':
Module 'Magento_GiftMessage':
Module 'Magento_GoogleAdwords':
Module 'Magento_GoogleAnalytics':
Module 'Magento_Ui':
Module 'Magento_GroupedImportExport':
Module 'Magento_GroupedProduct':
Module 'Magento_CatalogSampleData':
Module 'Magento_DownloadableImportExport':
Module 'Magento_DownloadableSampleData':
Module 'Magento_InstantPurchase':
Module 'Magento_Analytics':
Module 'Magento_LayeredNavigation':
Module 'Magento_Marketplace':
Module 'Magento_MediaStorage':
Module 'Magento_ConfigurableProduct':
Module 'Magento_MsrpSampleData':
Module 'Magento_Multishipping':
Module 'Magento_NewRelicReporting':
Module 'Magento_Reports':
Module 'Magento_OfflinePayments':
Module 'Magento_SalesRule':
Module 'Magento_OfflineShipping':
Module 'Magento_PageCache':
Module 'Magento_ConfigurableProductSales':
Module 'Magento_Vault':
Module 'Magento_Persistent':
Module 'Magento_ProductAlert':
Module 'Magento_BundleSampleData':
Module 'Magento_ProductVideo':
Module 'Magento_Paypal':
Module 'Magento_QuoteAnalytics':
Module 'Magento_ReleaseNotification':
Module 'Magento_Review':
Module 'Magento_RequireJs':
Module 'Magento_Shipping':
Module 'Magento_ReviewAnalytics':
Module 'Magento_ConfigurableSampleData':
Module 'Magento_Robots':
Module 'Magento_Rss':
Module 'Magento_CatalogRuleConfigurable':
Module 'Magento_CheckoutAgreements':
Module 'Magento_SalesAnalytics':
Module 'Magento_SalesInventory':
Module 'Magento_OfflineShippingSampleData':
Module 'Magento_CatalogRuleSampleData':
Module 'Magento_CustomerSampleData':
Module 'Magento_Captcha':
Module 'Magento_ThemeSampleData':
Module 'Magento_ProductLinksSampleData':
Module 'Magento_CustomerAnalytics':
Module 'Magento_SendFriend':
Module 'Magento_Wishlist':
Module 'Magento_Signifyd':
Module 'Magento_Sitemap':
Module 'Magento_SalesRuleSampleData':
Module 'Magento_Swagger':
Module 'Magento_Swatches':
Module 'Magento_SwatchesLayeredNavigation':
Module 'Magento_SwatchesSampleData':
Module 'Magento_ReviewSampleData':
Module 'Magento_TaxImportExport':
Module 'Magento_TaxSampleData':
Module 'Magento_Authorizenet':
Module 'Magento_CmsSampleData':
Module 'Magento_Translation':
Module 'Magento_GoogleOptimizer':
Module 'Magento_Ups':
Module 'Magento_SalesSampleData':
Module 'Magento_CatalogAnalytics':
Module 'Magento_Usps':
Module 'Magento_Variable':
Module 'Magento_Braintree':
Module 'Magento_Version':
Module 'Magento_Webapi':
Module 'Magento_WebapiSecurity':
Module 'Magento_GroupedProductSampleData':
Module 'Magento_CatalogWidget':
Module 'Magento_WidgetSampleData':
Module 'Dotdigitalgroup_Email':
Module 'Magento_WishlistAnalytics':
Module 'Magento_WishlistSampleData':
Module 'Shopial_Facebook':
Module 'Temando_Shipping':
Nothing to import.
magento_user@h1234567:/var/www/html/magento_2.2$

BOTH STOREFRONT AND BACKOFFICE GIVE AN ERROR.

Storefront:
There has been an error processing your request
Exception printing is disabled by default for security reasons.
Error log record number: 827638731404

Backoffice:
There has been an error processing your request
Exception printing is disabled by default for security reasons.
Error log record number: 400911229355

BEWARE

  • When checking the /var/log/apache2/error.log no errors were shown, indicating the issues I had on DEV.
  • After reloading both the storefront and the backoffice repeatedly (using Ctrl-F5) both urls starting working again. Backoffice first and the storefront a bit later.
  • It seems like the issues were due to me using the storefront and the backoffice BEFORE the sample data was loaded.
  • Probably the observed behaviour had to do with caching!

Strange behaviour

http://99.123.122.121/magento_2.2/promotions/pants-all.html
gives

SELECT `e`.*, IF(at_custom_use_parent_settings.value_id > 0, at_custom_use_parent_settings.value, at_custom_use_parent_settings_default.value) AS `custom_use_parent_settings` FROM `catalog_category_entity` AS `e` LEFT JOIN `catalog_category_entity_int` AS `at_custom_use_parent_settings_default` ON (`at_custom_use_parent_settings_default`.`entity_id` = `e`.`entity_id`) AND (`at_custom_use_parent_settings_default`.`attribute_id` = '70') AND `at_custom_use_parent_settings_default`.`store_id` = 0 LEFT JOIN `catalog_category_entity_int` AS `at_custom_use_parent_settings` ON (`at_custom_use_parent_settings`.`entity_id` = `e`.`entity_id`) AND (`at_custom_use_parent_settings`.`attribute_id` = '70') AND (`at_custom_use_parent_settings`.`store_id` = 1) WHERE (`e`.`entity_id` IN('32', '29', '2', '1')) AND (((IF(at_custom_use_parent_settings.value_id > 0, at_custom_use_parent_settings.value, at_custom_use_parent_settings_default.value) = 0) OR (IF(at_custom_use_parent_settings.value_id > 0, at_custom_use_parent_settings.value, at_custom_use_parent_settings_default.value) IS NULL))) AND (`e`.`level` != 0) ORDER BY `e`.`level` DESC
There has been an error processing your request

Exception printing is disabled by default for security reasons.

Error log record number: 1176918150291

On the 2nd reload the SQL statement is shown with the normal page below. On the 3rd reload on the normal page is shown!!??

After being granted access to the Backoffice the following error is shown:

/Warning: fopen(/var/www/html/magento_2.2/var/cache//mage-tags/mage---077_DB_PDO_MYSQL_DDL): failed to open stream: Permission denied in /var/www/html/magento_2.2/vendor/colinmollenhour/cache-backend-file/File.php on line 646

Show authorization of the mentioned file:

root@h1234567:/var/www/html/magento_2.2# ls -la /var/www/html/magento_2.2/var/cache//mage-tags/mage---077_DB_PDO_MYSQL_DDL
-rw-rw---- 1 magento_user magento_user 4480 feb 14 11:04 /var/www/html/magento_2.2/var/cache//mage-tags/mage---077_DB_PDO_MYSQL_DDL
root@h1234567:/var/www/html/magento_2.2#

Even though the installation was done directly by user magento_user. The named group probably need to be modified to www-data.

## Let's see how many files/dirs have assumedly been assigned the wrong group
root@h1234567:/var/www/html/magento_2.2# find . -group magento_user | wc -l
161
 
## Just fix them all
root@h1234567:/var/www/html/magento_2.2# chown -R magento_user:www-data .
 
root@h1234567:/var/www/html/magento_2.2# find . -group magento_user | wc -l
0
 
root@h1234567:/var/www/html/magento_2.2# ls -la
total 1180
drwxrwxr-x 13 magento_user www-data   4096 feb 14 09:30 .
drwxrwxr-x  4 www-data     www-data   4096 feb 14 10:39 ..
drwxrwxr-x  4 magento_user www-data   4096 feb 14 09:30 app
-rw-rw-r--  1 magento_user www-data    138 feb 14 09:30 auth.json.sample
drwxrwxr-x  2 magento_user www-data   4096 feb 14 09:30 bin
-rw-rw-r--  1 magento_user www-data 566648 feb 14 09:30 CHANGELOG.md
-rw-rw-rw-  1 magento_user www-data   3078 feb 14 10:49 composer.json
-rw-rw-r--  1 magento_user www-data 464403 feb 14 10:50 composer.lock
-rw-rw-r--  1 magento_user www-data   3671 feb 14 09:30 CONTRIBUTING.md
-rw-rw-r--  1 magento_user www-data    647 feb 14 09:30 COPYING.txt
drwxrwxr-x  5 magento_user www-data   4096 feb 14 09:30 dev
drwxrwsr-x  4 magento_user www-data   4096 feb 14 11:02 generated
-rw-rw-rw-  1 magento_user www-data   1437 dec 11 17:59 .gitignore
-rw-rw-r--  1 magento_user www-data     57 feb 14 09:30 grunt-config.json.sample
-rw-rw-r--  1 magento_user www-data   2994 feb 14 09:30 Gruntfile.js.sample
-rw-rw-r--  1 magento_user www-data  11951 feb 14 09:30 .htaccess
-rw-rw-r--  1 magento_user www-data  11475 feb 14 09:30 .htaccess.sample
-rw-rw-r--  1 magento_user www-data   1370 feb 14 09:30 index.php
-rw-rw-r--  1 magento_user www-data    691 feb 14 09:30 ISSUE_TEMPLATE.md
drwxrwxr-x  4 magento_user www-data   4096 feb 14 09:30 lib
-rw-rw-r--  1 magento_user www-data  10376 feb 14 09:30 LICENSE_AFL.txt
-rw-rw-r--  1 magento_user www-data  10364 feb 14 09:30 LICENSE.txt
-rw-rw-r--  1 magento_user www-data   5531 feb 14 09:30 nginx.conf.sample
-rw-rw-r--  1 magento_user www-data   1415 feb 14 09:30 package.json.sample
-rw-rw-r--  1 magento_user www-data   1757 feb 14 09:30 .php_cs.dist
-rw-rw-r--  1 magento_user www-data    804 feb 14 09:30 php.ini.sample
drwxrwxr-x  2 magento_user www-data   4096 feb 14 09:30 phpserver
drwxrwxr-x  6 magento_user www-data   4096 feb 14 09:30 pub
-rw-rw-r--  1 magento_user www-data    804 feb 14 09:30 PULL_REQUEST_TEMPLATE.md
drwxrwxr-x  7 magento_user www-data   4096 feb 14 09:30 setup
-rw-rw-r--  1 magento_user www-data   1820 feb 14 09:30 .travis.yml
drwxrwxr-x  7 magento_user www-data   4096 feb 14 09:24 update
-rw-rw-r--  1 magento_user www-data    101 feb 14 09:30 .user.ini
drwxrwsr-x  9 magento_user www-data   4096 feb 14 11:12 var
drwxrwsr-x 42 magento_user www-data   4096 feb 14 10:50 vendor

SUCCESS, AT LAST

Issue Checkout cart hangs
Cause Adblocker blocks (part of) the checkout page

1st screenshot: Chrome has Adblocker uBlock enabled
2nd screenshot: Firefox has Adblocker uBlock disabled and checkout was successful

How to solve this issue for all potential buyers with adblockers?

Database diagram of Magento 2.1.3

Source: http://anna.voelkl.at/wp-content/uploads/2016/12/ce2.1.3.png

Advise: download it to see all the details

Security fix in Read-only File System
De security is verbeterd, dankzij een wijziging in het Read-only File System. Magento heeft de var/generated directory uit de var directory gehaald. Hiermee kun je de gehele directory tree (met uitzondering van var en pub/media) op read-only zetten, wat weer gunstig is voor de veiligheid van je shop.

https://www.byte.nl/blog/talloze-nieuwe-magento-2-features-released

TO DO

Username magadmin
Email janonymized@nonexisting.com
Password (same as db user pw)
Your Store Address http://99.123.122.121/magento_2.2/
Magento Admin Address http://99.123.122.121/magento_2.2/admin_ves89k/
Encryption Key 549253d0dsomerandomstuff
Adminer access http://99.123.122.121/tools/adminer-4.6.1-mysql-en.php
  • content/2018021312411461.txt
  • Last modified: 2020/08/23 22:03