cd /tmp
wget https://dev.mysql.com/get/mysql-apt-config_0.8.13-1_all.deb
apt install gnupg
dpkg -i mysql-apt-config_0.8.13-1_all.deb
apt install gnupg composer php-zip php-symfony apache2 php mysql-server php-mysql curl
a2enmod rewrite env
curl -fSL https://getcomposer.org/composer.phar -o composer.phar
php composer.phar create-project "novosga/novosga:2.0" novosga
echo 'date.timezone = America/New_York' > /etc/php/7.3/apache2/conf.d/datetimezone.ini
mv novosga/ /var/www/
cd /var/www/novosga/
bin/console cache:clear --no-debug --no-warmup --env=prod
bin/console cache:warmup --env=prod
chown www-data:www-data -R /var/www/novosga
chmod +w -R /var/www/novosga/var/
echo 'Options -MultiViews
RewriteEngine On
RewriteCond %{REQUEST_FILENAME} !-f
RewriteRule (.*)$ index.php [QSA,L]
SetEnv APP_ENV prod
SetEnv LANGUAGE pt_BR
SetEnv DATABASE_URL mysql://novosga:MySQL_App_P4ssW0rd@localhost:3306/novosga2?charset=utf8mb4&serverVersion=5.7
' > /var/www/novosga/public/.htaccess
mysql -e "CREATE USER 'novosga'@'localhost' IDENTIFIED WITH mysql_native_password BY 'MySQL_App_P4ssW0rd';"
mysql -e "GRANT ALL PRIVILEGES ON . TO 'novosga'@'localhost';"
APP_ENV=prod \
LANGUAGE=pt_BR \
DATABASE_URL="mysql://novosga:MySQL_App_P4ssW0rd@localhost:3306/novosga2?charset=utf8mb4&serverVersion=5.7" \
bin/console novosga:install
