开源LMS-moodle-安装和使用

chown -R root /path/to/moodle
chmod -R 0755 /path/to/moodle

sudo apt-get install mysql-server

# 检查安装是否成功
mysql --version
systemctl status mysql.service
# root 密码默认为空，但是只有root用户能进
sudo mysql

# 安全提升：the removal of test users, test databases and permission for remote login by a root user.
# sudo mysql_secure_installation

# 修改 mysql root 密码
# mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';
# mysql> FLUSH PRIVILEGES;

# 创建数据库 moodle
mysql> CREATE DATABASE moodle DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

# 添加 app 的数据库用户
mysql> CREATE USER moodleuser@'192.168.%.%' IDENTIFIED BY 'moodle';
mysql> GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,CREATE TEMPORARY TABLES,DROP,INDEX,ALTER ON moodle.* TO moodleuser@'192.168.%.%';
mysql> FLUSH PRIVILEGES;

sudo apt install apache2
sudo ufw app list
sudo ufw app info "Apache Full"
sudo ufw allow in "Apache Full"

sudo apt install php libapache2-mod-php php-mysql php-curl php-zip php-xml php-mbstring php-gd php-intl
sudo systemctl restart apache2

mkdir /path/to/moodledata
chmod 0777 /path/to/moodledata

<VirtualHost *:80>
    ServerAdmin webmaster@localhost
    ServerName your_domain
    ServerAlias www.your_domain
    DocumentRoot /opt/moodle/moodle-310
    ErrorLog ${APACHE_LOG_DIR}/error.log
    CustomLog ${APACHE_LOG_DIR}/access.log combined
</VirtualHost>

sudo a2ensite moodle.conf
# disable default conf
sudo a2dissite 000-default.conf

# test config syntax
sudo apache2ctl configtest

# 重启apache2
sudo systemctl restart apache2

# moodle
Alias /moodle/ "/opt/moodle/moodle-310/"

<Directory "/opt/moodle/moodle-310">
	Options FollowSymlinks
	AllowOverride None
	Require all granted
</Directory>

Alias /moodle "/opt/server/moodle/moodle-310"
<Directory "/opt/server/moodle/moodle-310">
    AllowOverride None
    Order allow,deny
    Allow from all
</Directory>

chown www-data /path/to/moodle
cd /path/to/moodle/admin/cli
sudo -u www-data /usr/bin/php install.php
chown -R root /path/to/moodle