Install moodle dengan webserver dan database server yang terpisah

Server yang Disiapkan

 Server yang dipakai adalah Server Ubuntu 20.04

 Webserver = 192.168.1.67 = install apache,php7.4,moodle,mariadb-client

 databaseserver = 192.168.1.65 = install mariadb-server dan mariadb-client, php7.4-mysqli

Install MariaDB Server & Mariadb-client di server 192.168.1.65

sudo apt -y install mariadb-server

Restart & Enable

sudo systemctl start mariadb
sudo systemctl enable mariadb

Secure Installation

sudo mysql_secure_installation

Enter current password for root (enter for none): 
Set root password? [Y/n] y
New password: 
Re-enter new password: 
Remove anonymous users? [Y/n] y
Disallow root login remotely? [Y/n] n
Remove test database and access to it? [Y/n] y
Reload privilege tables now? [Y/n] y

Edit file config MariaDB

sudo nano /etc/mysql/mariadb.conf.d/50-server.cnf
Ganti bind-address dari 127.0.0.1 menjadi IP Server MariaDB
contoh kasus ini ganti menjadi 192.168.1.65

Create database and user moodle 192.168.1.65

mysql -u root -p 
create database moodle;
ALTER DATABASE moodle charset=utf8mb4;
ALTER DATABASE moodle CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci;
grant ALL on moodle.* to [email protected] identified by "123456";
FLUSH PRIVILEGES;
exit

Install PHP7.4 di database server 192.168.1.65

sudo apt update  
sudo apt install php7.4-mysql

Instal Mariadb-Client di Webserver (192.168.1.67)

apt install mariadb-client

Login dari Webserver ke MariaDB Server

mysql -u smpdbos-h 192.168.1.65 -p

Jika berhasil diakses kita lanjutkan dengan menginstall moodle di webserver

Update Repo

sudo apt update

Install Apache2

apt -y install apache2

sudo ufw allow 'Apache'

Install PHP 7.4

sudo apt update
sudo apt -y install php7.4

Install extension

sudo apt -y install php7.4-common php7.4-mysql php7.4-xml php7.4-xmlrpc \
php7.4-curl php7.4-gd php7.4-imagick php7.4-cli php7.4-dev \
php7.4-imap php7.4-mbstring php7.4-opcache php7.4-soap \
php7.4-zip php7.4-intl php7.4-cli \
imagemagick git zip libgd-dev libapache2-mod-php 

Edit

sudo vi /etc/php/7.4/apache2/php.ini

upload_max_filesize = 100M
post_max_size = 48M
memory_limit = 512M
max_execution_time = 600
max_input_vars = 5000
max_input_time = 1000

Restart apache2

sudo systemctl restart apache2.service

Test

sudo vi /var/www/html/phpinfo.php

<?php phpinfo( ); ?>

INSTALL MOODLE

Siapkan folder /var/moodledata/

Download language pack lewat web

https://download.moodle.org/download.php/direct/langpack/3.11/id.zip

transfer menggunakan scp ke

/usr/local/src

Install language pack

cd /usr/local/src
mkdir -p /var/moodledata/lang
cp id.zip /var/moodledata/lang
cd /var/moodledata/lang
unzip id.zip
chmod -Rf 777 /var/moodledata/lang/
chown -Rf www-data: /var/moodledata/lang/

Install Moodle

Download oleh manusia dari

https://download.moodle.org/download.php/stable311/moodle-latest-311.tgz

Copykan menggunakan scp ke

/usr/local/src

Install

cd /usr/local/src
cp moodle-latest-311.tgz /var/www/html/
cd /var/www/html/
tar zxvf moodle-latest-311.tgz
chown -Rf www-data: /var/moodledata/
chmod -Rf 777 /var/www/html/moodle	
chown -Rf www-data: /var/www/html/moodle

Lanjutkan dengan konfigurasi via web

http://localhost/moodle
http://ip-address/moodle

Install via web yang perlu diperhatikan

localhost = 192.168.1.65
databasename dan password disesuaikan
pilih mariadb sebagai databasenya

Pranala Menarik

https://musaamin.web.id/cara-memisahkan-apache-web-server-dan-mariadb-database-server/