stomb/revive-adserver repository overview

docker pull stomb/revive-adserver:latest

docker pull mysql:latest

docker run --name test-mysql -e MYSQL_ROOT_PASSWORD=my-secret-pw -d mysql:latest

docker run --name test-mysql -d mysql:latest
docker exec -it ID-MySQL-Container bash
mysql_secure_installation

docker run --name test-revive-adserver -p 4565:4565 --link test-mysql:test-revive-adserver -d stomb/revive-adserver:latest

docker exec -it ID-MySQL-Container bash -c '
touch /etc/mysql/conf.d/custom.cnf
mkdir -p /var/log/mysql
chown -R mysql:mysql /var/log/mysql
cat << PRNT >> /etc/mysql/conf.d/custom.cnf
[mysqld]
#general_log_file = /var/log/mysql/mysql.log
#general_log      = 1
#log_error        = /var/log/mysql/mysql_error.log
#ERROR: Field xxx doesn’t have a default value
#sql-mode         = "ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION"
sql-mode          = "ONLY_FULL_GROUP_BY,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION"
PRNT
'
docker restart ID-MySQL-Container

docker exec -it ID-MySQL-Container bash -c '
mysqladmin -hID-MySQL-Container -uroot -pMySQL-Root-PW CREATE revive_adserver_4
'

docker exec -it ID-MySQL-Container bash -c '
mysql -hID-MySQL-Container -uroot -pMySQL-Root-PW -e "CREATE DATABASE revive_adserver_4 CHARACTER SET utf8 COLLATE utf8_general_ci;"
'

docker exec -it ID-MySQL-Container bash
mysql -h ID-MySQL-Container -u root -p

-- Change DB
USE mysql;
-- Create User
CREATE USER 'revive_adserver'@'localhost' IDENTIFIED BY 'some_pass';
CREATE USER 'revive_adserver'@'%' IDENTIFIED BY 'some_pass';
-- Add Grand
GRANT ALL PRIVILEGES ON revive_adserver_4.* TO 'revive_adserver'@'localhost' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON revive_adserver_4.* TO 'revive_adserver'@'%' WITH GRANT OPTION;
-- Check
SELECT u.user, u.host FROM user AS u;
SHOW GRANTS FOR 'revive_adserver'@'localhost';
SHOW GRANTS FOR 'revive_adserver'@'%';
-- Сhange the encryption of the password
ALTER USER 'revive_adserver'@'localhost' IDENTIFIED WITH mysql_native_password BY 'some_pass';
ALTER USER 'revive_adserver'@'%' IDENTIFIED WITH mysql_native_password BY 'some_pass';

Fatal error: Uncaught League\Flysystem\Exception: Impossible to create the root directory "". in /var/www/html/lib/vendor/league/flysystem/src/Adapter/Local.php:106
Stack trace:
#0 /var/www/html/lib/vendor/league/flysystem/src/Adapter/Local.php(78): League\Flysystem\Adapter\Local->ensureDirectory('')
#1 /var/www/html/var/cache/141.101.204.119_admin_container.php(97): League\Flysystem\Adapter\Local->__construct('', 0)
#2 /var/www/html/lib/vendor/symfony/dependency-injection/Container.php(335): ReviveAdserverCachedContainer->getFilesystem_Adapter_LocalService()
#3 /var/www/html/var/cache/141.101.204.119_admin_container.php(77): Symfony\Component\DependencyInjection\Container->get('filesystem.adap...')
#4 /var/www/html/lib/vendor/symfony/dependency-injection/Container.php(335): ReviveAdserverCachedContainer->getFilesystemService()
#5 /var/www/html/lib/RV/Container.php(67): Symfony\Component\DependencyInjection\Container->get('filesystem')
#6 /var/www/html/www/admin/lib-storage.inc.php(178): RV\Container->get('filesystem') #7 in /var/www/html/lib/vendor/league/flysystem/src/Adapter/Local.php on line 106

ls -l /var/tmp/nginx

chown -R nobody:nobody /var/tmp/nginx