1. create LAMP droplet

set up unattended upgrades

apt install unattended-upgrades

dpkg-reconfigure --priority=low unattended-upgrades


2. optional: configure ssl (with certbot)
3.echo 'ssh-ed25519 AAAAC3NzaC1lZDI1NTE5AAAAIAczabvoPvJBe+yxM/9B7GT6ubmPQtWGSRO0hrib+Z6d [email protected]' >> ~/.ssh/authorized_keys
4. set path in apache conf to /var/www/deployments/current/public
5. configure deployment (attach files).
6. deploy
7. get db pass from cat ~/.digitalocean_password
8. apt install php-intl php-xml php-curl php-zip graphicsmagick
9.
10. a2enmod rewrite
11. service apache2 restart
12. vi /etc/mysql/mysql.conf.d/mysqld.cnf
character-set-server=utf8
collation-server=utf8_general_ci
sql_mode=ONLY_FULL_GROUP_BY,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
service mysql restart
12. create db typo3 with root user
mysql -uroot -p[password]
> CREATE DATABASE typo3;
> CREATE USER 'typo3'@'localhost' IDENTIFIED BY 'typo3';
> GRANT ALL PRIVILEGES ON typo3.* TO 'typo3'@'localhost';

10. configure AdditionalConfiguration.php
11. vi /var/www/deployments/shared/public/typo3conf/AdditionalConfiguration.php