#ubuntu時區調整
timedatectl set-timezone Asia/Taipei

#取得Codename
lsb_release -a

#在sources.list最後增加deb
vi /etc/apt/sources.list
deb http://nginx.org/packages/ubuntu/ focal nginx
deb-src http://nginx.org/packages/ubuntu/ focal nginx

#增加key才能apt-get update
wget http://nginx.org/keys/nginx_signing.key
apt-key add nginx_signing.key

apt-get update
apt-get install nginx

vi /etc/nginx/nginx.conf
user www-data;

vi /etc/nginx/conf.d/default.conf

    location ~ [^/]\.php(/|$) {
        include fastcgi_params;
        fastcgi_split_path_info  ^(.+\.php)(/.+)$;
        fastcgi_param   PATH_INFO       $fastcgi_path_info;
        fastcgi_pass unix:/run/php/php7.4-fpm.sock;
        fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;
    }

/etc/init.d/nginx restart
/etc/init.d/php7.4-fpm restart

#建議使用的根路徑
使用phpinfo()，取得如下路徑，nginx也使用如下路徑
$_SERVER[‘DOCUMENT_ROOT’]

#mariadb安裝
apt-get install mariadb-server
apt-get install php-xml php-mysqli

#初始化
mysql_secure_installation

#(HY000/1698): Access denied

mysql -u root
USE mysql;
UPDATE user SET plugin='' WHERE User='root';
FLUSH PRIVILEGES;
exit;

#sql執行記錄

# 設定輸出型別為 table
set global log_output='table';
# 開啟日誌功能
set global general_log=on;
# 切換到資料庫：mysql
use mysql;
# 設定輸出型別為 table
select * from general_log;

#moodle安裝
apt-get install php-curl php-zipphp-mbstring php-gd php-intl php-xmlrpc php-soap
mkdir /etc/nginx/moodledata
chown www-data /etc/nginx/moodledata

crontab -u www-data -e
*/1 * * * * /usr/bin/php /etc/nginx/html/admin/cli/cron.php >/dev/null

#certbot

certbot certonly --webroot --post-hook "service nginx reload" --webroot-path=/etc/nginx/letsencrypt -d link.tscs.com.tw