IPv6 Web: Moodle

/etc/apt/source.list /etc/hosts IPv6 interface

Edit /etc/apt/sources.list pastikan

deb http://archive.ubuntu.com/ubuntu bionic main universe multiverse
deb http://archive.ubuntu.com/ubuntu bionic-security main universe multiverse
deb http://archive.ubuntu.com/ubuntu bionic-updates main universe multiverse

Edit /etc/hosts pastikan

::1     localhost.localdomain   localhost
::1     localhost6.localdomain6 localhost6

Set IPv6 di interface, misalnya,

ip addr add <ipv6addr>/<ipv6prefix> dev enp3s0
ip route add ::/0 via <ipv6gayeway> dev enp2s0
ip addr add 2345::3/64 dev enp3s0

Instalasi

wget https://repo.percona.com/apt/percona-release_latest.$(lsb_release -sc)_all.deb
sudo dpkg -i percona-release_latest.$(lsb_release -sc)_all.deb
sudo apt update
sudo apt install percona-server-server-5.7

Masukan root password percona jika di tanya. Asumsi password root = 123456.

apt -y install apache2 php php-xmlrpc php-mysql php-gd php-cli php-curl \
mysql-client mysql-server libphp-adodb libgd-dev php-curl php-pear php-zip php-intl \
php-common libapache2-mod-php php-fpm php-soap \
php-bz2 php-xml imagemagick git unzip php-mbstring

Restart apache2

service apache2 stop
service apache2 start

Database

Untuk operasional, jangan menggunakan username & password seperti contoh di bawah ini. Ini hanya contoh untuk memudahkan saja.

mysql -u root -h ::1 -p123456

create database moodle;
ALTER DATABASE moodle charset=utf8mb4;
ALTER DATABASE moodle CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci;
grant ALL on root.* to moodle@localhost;
grant ALL on moodle.* to moodle@localhost identified by "moodle";
grant ALL on moodle.* to moodle@'::1' identified by "moodle";
grant ALL on moodle.* to moodle identified by "moodle";
exit

/etc/init.d/mysql restart