View source for 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 smpdbos@192.168.1.67 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/