MySQL 8.0¶

The easiest way to install MySQL 8.0 is to use the official vendor package.

Follow the official documentation: <https://dev.mysql.com/doc/refman/8.0/en/linux-installation-debian.html>.

Download the bundle package for the required version:

# wget https://downloads.mysql.com/archives/get/p/23/file/mysql-server_8.0.23-1debian10_amd64.deb-bundle.tar

And follow the aforementioned documentation.

When installing MySQL 8.0, you’ll have to choose the authentication method. Please select Use Legacy Authentication Method as the Strong Password Encryption is not yet supported by Akeneo PIM.

PHP 8.0¶

As Ubuntu 18.04 only provides PHP 7.2, we need to use Ondrej Sury packages to install PHP 8.0..

First, install the repository:

$ apt-get install software-properties-common
$ add-apt-repository ppa:ondrej/php
$ apt update

If you get an error it may be because of non-UTF-8 locales, try

$ LC_ALL=C.UTF-8 add-apt-repository ppa:ondrej/php
$ apt update

Then, install PHP and the required extensions:

$ apt-get install php8.0-cli php8.0-apcu php8.0-bcmath php8.0-curl php8.0-opcache php8.0-fpm php8.0-gd php8.0-intl php8.0-memcached php8.0-mysql php8.0-xml php8.0-zip php8.0-mbstring php8.0-imagick

Elasticsearch 7.16¶

Follow the official Elasticsearch documentation: official vendor package:

• first install the PGP key

• then install the package via the official repository

# apt-get install apt-transport-https
# wget -qO - https://artifacts.elastic.co/GPG-KEY-elasticsearch | apt-key add -
# echo "deb https://artifacts.elastic.co/packages/7.x/apt stable main" | tee -a /etc/apt/sources.list.d/elastic-7.x.list
# apt update && apt-get install elasticsearch
# service elasticsearch start

# sysctl -w vm.max_map_count=262144
# echo "vm.max_map_count=262144" | tee /etc/sysctl.d/elasticsearch.conf
# service elasticsearch restart

Apache¶

$ apt-get install apache2
$ a2enmod rewrite proxy_fcgi
$ service apache2 restart

$ a2dismod php5

MySQL¶

• Create a dedicated MySQL database and a dedicated user (called akeneo_pim) for the application

$ mysql -u root -p
mysql> CREATE DATABASE akeneo_pim;
mysql> CREATE USER akeneo_pim@localhost IDENTIFIED WITH mysql_native_password BY 'akeneo_pim';
mysql> GRANT ALL PRIVILEGES ON akeneo_pim.* TO akeneo_pim@localhost;
mysql> EXIT

PHP¶

• Setup CLI php.ini file /etc/php/8.0/cli/php.ini

$ sudo vim /etc/php/8.0/cli/php.ini
memory_limit = 1024M
date.timezone = UTC

• Setup FPM php.ini file /etc/php/8.0/fpm/php.ini

$ sudo vim /etc/php/8.0/fpm/php.ini
memory_limit = 512M
date.timezone = UTC

To avoid spending too much time on permission problems between the CLI user and the FPM user, a good practice is to use the same user for both of them.

• Get your identifiers

$ id
uid=1000(my_user), gid=1000(my_group), ...

In this example, the user is my_user and the group is my_group.

• Stop FPM

$ sudo service php8.0-fpm stop

• Open the file /etc/php/8.0/fpm/pool.d/www.conf with your favorite text editor:

$ sudo vi /etc/php/8.0/fpm/pool.d/www.conf
# replace these environment variables:
user = my_user
group = my_group
listen = /run/php/php8.0-fpm.sock
listen.owner = www-data
listen.group = www-data

• Restart FPM

$ sudo service php8.0-fpm restart

Elasticsearch¶

Depending on the volume of data, it can be interesting to tweak the amount of memory usable by the JVM, as recommended by the official documentation. Usually, this configuration lies in the file /etc/elasticsearch/jvm.options.

Apache¶

 1<VirtualHost *:80>
 2    ServerName akeneo-pim.local
 3
 4    DocumentRoot /path/to/installation/pim-community-standard/public
 5    <Directory /path/to/installation/pim-community-standard/public>
 6        AllowOverride None
 7        Require all granted
 8
 9        Options -MultiViews
10        RewriteEngine On
11        RewriteCond %{REQUEST_FILENAME} !-f
12        RewriteRule ^(.*)$ index.php [QSA,L]
13    </Directory>
14
15    <Directory /path/to/installation/pim-community-standard/public/bundles>
16        RewriteEngine Off
17    </Directory>
18
19    <FilesMatch \.php$>
20        SetHandler "proxy:unix:/run/php/php7.4-fpm.sock|fcgi://localhost/"
21    </FilesMatch>
22
23    SetEnvIf Authorization .+ HTTP_AUTHORIZATION=$0
24
25    ErrorLog ${APACHE_LOG_DIR}/akeneo-pim_error.log
26    LogLevel warn
27    CustomLog ${APACHE_LOG_DIR}/akeneo-pim_access.log combined
28</VirtualHost>

$ sudo apache2ctl configtest
# This will return 'Syntax OK'

$ sudo a2ensite akeneo-pim.local
$ sudo service apache2 reload

127.0.0.1    akeneo-pim.local

Node 14¶

$ apt-get install curl
$ curl -sL https://deb.nodesource.com/setup_14.x -o nodesource_setup.sh
$ bash nodesource_setup.sh
$ apt-get install -y nodejs

To check which version of Node.js you have installed after these initial steps, type:

$ nodejs -v

Yarn¶

$ curl -sL https://dl.yarnpkg.com/debian/pubkey.gpg | apt-key add -
$ echo "deb https://dl.yarnpkg.com/debian/ stable main" | tee /etc/apt/sources.list.d/yarn.list
$ apt update && apt-get install yarn