Tips agar aman dari putus koneksi SSH restore sql db moodle ke docker

 💡 Tips agar aman dari putus koneksi SSH (opsional tapi disarankan):
Jika kamu restore dari dalam container tapi terhubung lewat SSH dan takut koneksi putus, gunakan screen atau tmux dari host/server sebelum masuk container.

Contoh:

# Di host/server sebelum masuk container
screen -S restore-moodle

# Masuk ke container
docker exec -it moodle-db bash

# Jalankan restore di dalam container
mysql -u root -prootpass moodle < /moodle.sql

Kalau putus, kamu tinggal reconnect SSH dan:
screen -r restore-moodle

Restore database backup ke container MariaDB Docker

 Moodle yang dijalankan di Docker bisa menggunakan database dari Moodle "native" (yang non-Docker) — baik itu hasil backup SQL (.sql) atau koneksi langsung ke server MariaDB/MySQL yang sudah ada.

---

✅ Opsi A: Restore database backup ke container MariaDB Docker

Jika kamu punya file backup database Moodle (biasanya moodle.sql), maka:

1. Jalankan container MariaDB untuk Moodle

Pastikan kamu punya container mariadb untuk Moodle,

2. Restore database ke container

Misalnya kamu punya file moodle.sql:

 # docker cp /root/moodle2.sql mariadb:/tmp/moodle2.sql
Successfully copied 2.38GB to mariadb:/tmp/moodle2.sql

root@debian:~# docker exec -it mariadb bash

# Di dalam container:
mysql -u root -p nama_container_moodle < /moodle.sql (path sql)
I have no name!@1a92d6190fbd:/$ mysql -u root -p bitnami_moodle < /tmp/moodle2.sql

Saat diminta password, masukkan:

---

4. Setelah selesai, restart Moodle

Keluar dari container dulu (exit), lalu restart container Moodle

docker restart moodle
 

🔍 Uji akses Moodle di browser:

Buka: http://localhost:8080
Atau jika di server:http://<IP-server>:8080

 

 

 

 

 

menjalankan container docker

 # cd moodle-docker/

/moodle-docker# docker compose up -d 

Pasang Moodle 4.5.4+ di Docker,

🎯 Tujuan:

Menjalankan Moodle 4.5.4+ di Docker, bisa diakses online via Cloudflare Tunnel, di PC Debian 10 RAM 6 GB, bersamaan dengan WordPress.

✅ LANGKAH-LANGKAH SETUP

1. 📁 Buat Folder Moodle
mkdir -p ~/moodle-docker
cd ~/moodle-docker

2. 📝 Buat docker-compose.yml
nano docker-compose.yml

Isi dengan:

version: '3.7'

services:
  moodle:
    image: bitnami/moodle:4.5.4
    container_name: moodle
    ports:
      - "8088:8080"  # gunakan port unik
    environment:
      - MOODLE_DATABASE_HOST=mariadb
      - MOODLE_DATABASE_PORT_NUMBER=3306
      - MOODLE_DATABASE_USER=bn_moodle
      - MOODLE_DATABASE_NAME=bitnami_moodle
      - MOODLE_DATABASE_PASSWORD=moodlepass
      - MOODLE_USERNAME=admin
      - MOODLE_PASSWORD=admin123
      - MOODLE_EMAIL=admin@example.com
      - TZ=Asia/Makassar
    volumes:
      - moodle_data:/bitnami/moodle
      - moodledata_data:/bitnami/moodledata
    depends_on:
      - mariadb

  mariadb:
    image: bitnami/mariadb:10.11
    container_name: moodle-mariadb
    environment:
      - MARIADB_ROOT_PASSWORD=rootpass
      - MARIADB_DATABASE=bitnami_moodle
      - MARIADB_USER=bn_moodle
      - MARIADB_PASSWORD=moodlepass
    volumes:
      - mariadb_data:/bitnami/mariadb

volumes:
  moodle_data:
  moodledata_data:
  mariadb_data:

Gunakan port 8088 agar tidak bentrok dengan WordPress (biasanya port 80).


3. ▶️ Jalankan
docker-compose up -d

Cek status:
docker ps


. 🌍 Akses Lokal

Cek dulu lokal:
http://localhost:8088
atau dari HP/laptop dalam jaringan lokal:
http://IP-PC:8088

Install Docker dan Docker Compose

 
🧰 LANGKAH 1: Pasang Docker dan Docker Compose
🔹 1.1. Update & install dependensi
apt update
apt install apt-transport-https ca-certificates curl gnupg2 software-properties-common -y

# apt install apt-transport-https ca-certificates curl gnupg2 software-properties-common -y
Reading package lists... Done
Building dependency tree       
Reading state information... Done
apt-transport-https is already the newest version (1.8.2.3).
ca-certificates is already the newest version (20200601~deb10u2).
gnupg2 is already the newest version (2.2.12-1+deb10u2).
curl is already the newest version (7.64.0-4+deb10u9).
The following additional packages will be installed:
  gir1.2-packagekitglib-1.0 libappstream4 libglib2.0-0 libglib2.0-bin libgstreamer1.0-0 libpackagekit-glib2-18 libstemmer0d
  packagekit packagekit-tools python3-distro-info python3-software-properties unattended-upgrades
Suggested packages:
  gstreamer1.0-tools appstream bsd-mailx default-mta | mail-transport-agent needrestart
The following NEW packages will be installed:
  gir1.2-packagekitglib-1.0 libappstream4 libglib2.0-bin libgstreamer1.0-0 libpackagekit-glib2-18 libstemmer0d packagekit
  packagekit-tools python3-distro-info python3-software-properties software-properties-common unattended-upgrades
The following packages will be upgraded:
  libglib2.0-0
1 upgraded, 12 newly installed, 0 to remove and 172 not upgraded.
Need to get 4,679 kB of archives.
After this operation, 10.8 MB of additional disk space will be used.
Get:1 http://deb.debian.org/debian buster/main amd64 libpackagekit-glib2-18 amd64 1.1.12-5 [116 kB]
Get:2 http://security.debian.org/debian-security buster/updates/main amd64 libglib2.0-0 amd64 2.58.3-2+deb10u6 [1,263 kB]
Get:3 http://deb.debian.org/debian buster/main amd64 gir1.2-packagekitglib-1.0 amd64 1.1.12-5 [35.9 kB]
Get:4 http://security.debian.org/debian-security buster/updates/main amd64 libglib2.0-bin amd64 2.58.3-2+deb10u6 [126 kB]
Get:5 http://security.debian.org/debian-security buster/updates/main amd64 python3-distro-info all 0.21+deb10u1 [8,108 B]
Get:6 http://deb.debian.org/debian buster/main amd64 libstemmer0d amd64 0+svn585-1+b2 [63.3 kB]
Get:7 http://deb.debian.org/debian buster/main amd64 libappstream4 amd64 0.12.5-1 [110 kB]
Get:8 http://deb.debian.org/debian buster/main amd64 libgstreamer1.0-0 amd64 1.14.4-1 [2,103 kB]
Get:9 http://deb.debian.org/debian buster/main amd64 packagekit amd64 1.1.12-5 [593 kB]
Get:10 http://deb.debian.org/debian buster/main amd64 packagekit-tools amd64 1.1.12-5 [46.9 kB]
Get:11 http://deb.debian.org/debian buster/main amd64 python3-software-properties all 0.96.20.2-2 [49.6 kB]
Get:12 http://deb.debian.org/debian buster/main amd64 software-properties-common all 0.96.20.2-2 [83.3 kB]
Get:13 http://deb.debian.org/debian buster/main amd64 unattended-upgrades all 1.11.2 [79.0 kB]
Fetched 4,679 kB in 1s (5,213 kB/s)
apt-listchanges: Reading changelogs...
Preconfiguring packages ...
(Reading database ... 42288 files and directories currently installed.)
Preparing to unpack .../00-libglib2.0-0_2.58.3-2+deb10u6_amd64.deb ...
Unpacking libglib2.0-0:amd64 (2.58.3-2+deb10u6) over (2.58.3-2+deb10u4) ...
Selecting previously unselected package libpackagekit-glib2-18:amd64.
Preparing to unpack .../01-libpackagekit-glib2-18_1.1.12-5_amd64.deb ...
Unpacking libpackagekit-glib2-18:amd64 (1.1.12-5) ...
Selecting previously unselected package gir1.2-packagekitglib-1.0.
Preparing to unpack .../02-gir1.2-packagekitglib-1.0_1.1.12-5_amd64.deb ...
Unpacking gir1.2-packagekitglib-1.0 (1.1.12-5) ...
Selecting previously unselected package libstemmer0d:amd64.
Preparing to unpack .../03-libstemmer0d_0+svn585-1+b2_amd64.deb ...
Unpacking libstemmer0d:amd64 (0+svn585-1+b2) ...
Selecting previously unselected package libappstream4:amd64.
Preparing to unpack .../04-libappstream4_0.12.5-1_amd64.deb ...
Unpacking libappstream4:amd64 (0.12.5-1) ...
Selecting previously unselected package libglib2.0-bin.
Preparing to unpack .../05-libglib2.0-bin_2.58.3-2+deb10u6_amd64.deb ...
Unpacking libglib2.0-bin (2.58.3-2+deb10u6) ...
Selecting previously unselected package libgstreamer1.0-0:amd64.
Preparing to unpack .../06-libgstreamer1.0-0_1.14.4-1_amd64.deb ...
Unpacking libgstreamer1.0-0:amd64 (1.14.4-1) ...
Selecting previously unselected package packagekit.
Preparing to unpack .../07-packagekit_1.1.12-5_amd64.deb ...
Unpacking packagekit (1.1.12-5) ...
Selecting previously unselected package packagekit-tools.
Preparing to unpack .../08-packagekit-tools_1.1.12-5_amd64.deb ...
Unpacking packagekit-tools (1.1.12-5) ...
Selecting previously unselected package python3-distro-info.
Preparing to unpack .../09-python3-distro-info_0.21+deb10u1_all.deb ...
Unpacking python3-distro-info (0.21+deb10u1) ...
Selecting previously unselected package python3-software-properties.
Preparing to unpack .../10-python3-software-properties_0.96.20.2-2_all.deb ...
Unpacking python3-software-properties (0.96.20.2-2) ...
Selecting previously unselected package software-properties-common.
Preparing to unpack .../11-software-properties-common_0.96.20.2-2_all.deb ...
Unpacking software-properties-common (0.96.20.2-2) ...
Selecting previously unselected package unattended-upgrades.
Preparing to unpack .../12-unattended-upgrades_1.11.2_all.deb ...
Unpacking unattended-upgrades (1.11.2) ...
Setting up libglib2.0-0:amd64 (2.58.3-2+deb10u6) ...
Setting up libglib2.0-bin (2.58.3-2+deb10u6) ...
Setting up libpackagekit-glib2-18:amd64 (1.1.12-5) ...
Setting up gir1.2-packagekitglib-1.0 (1.1.12-5) ...
Setting up python3-software-properties (0.96.20.2-2) ...
Setting up libstemmer0d:amd64 (0+svn585-1+b2) ...
Setting up python3-distro-info (0.21+deb10u1) ...
Setting up libgstreamer1.0-0:amd64 (1.14.4-1) ...
Setcap worked! gst-ptp-helper is not suid!
Setting up libappstream4:amd64 (0.12.5-1) ...
Setting up software-properties-common (0.96.20.2-2) ...
Setting up unattended-upgrades (1.11.2) ...

Creating config file /etc/apt/apt.conf.d/50unattended-upgrades with new version
Created symlink /etc/systemd/system/multi-user.target.wants/unattended-upgrades.service → /lib/systemd/system/unattended-upgrade
s.service.
Synchronizing state of unattended-upgrades.service with SysV service script with /lib/systemd/systemd-sysv-install.
Executing: /lib/systemd/systemd-sysv-install enable unattended-upgrades
Setting up packagekit (1.1.12-5) ...
Setting up packagekit-tools (1.1.12-5) ...
Processing triggers for systemd (241-7~deb10u8) ...
Processing triggers for man-db (2.8.5-2) ...
Processing triggers for dbus (1.12.20-0+deb10u1) ...
Processing triggers for libc-bin (2.28-10+deb10u1) ...

🔹 1.2. Tambahkan GPG key Docker
curl -fsSL https://download.docker.com/linux/debian/gpg | apt-key add -

🔹 1.3. Tambahkan repo Docker stable
add-apt-repository "deb [arch=amd64] https://download.docker.com/linux/debian $(lsb_release -cs) stable"

🔹 1.4. Install Docker
apt update
apt install docker-ce docker-ce-cli containerd.io -y

🔹 1.5. Cek versi Docker
docker --version

🧰 LANGKAH 2: Install Docker Compose (manual karena Debian 10)
Walaupun Docker Compose sekarang sudah bisa dijalankan langsung lewat docker compose, lebih stabil untuk Debian 10 jika kita instal manual versi plugin-nya.
🧩 1. Install Docker Compose plugin resmi
apt install docker-compose-plugin -y

Setelah itu, cek:
docker compose version

Kalau sukses, akan muncul semacam:
Docker Compose version v2.27.1

Jika Compose sudah siap, kita akan lanjut ke:

Setelah sekian lama menggunakan Ubuntu 16.04, akhirnya dipaksa peningkatan juga ke Ubuntu 20.04

Berawal dari proses mematikan di 16.04 yg sangat lama sampai 1 jam belum mati-mati, lalu saya paksa dengan menekan tombol daya, berakhir dengan sistem rusak dan tidak bisa melakukan pengebutan kembali. Tidak mau ambil pusing penyelesaian masalah dan pengawakutuan sekaligus PC butuh segera untuk bekerja, akhirnya saya pasang ulang + coba peningkatan ke 20.04.
.
Impresi awal 20.04 adalah durasi animasinya kelamaan, jadi kurang responsif dan terkesan lemot . Lalu saya pasang ekstensi Impatience dan set kecepatannya jd 0.25 . Dan udah jadi wus-wus. 😁
Hal yg kurang nyaman bagi saya 1 lagi adalah Ruang kerjanya vertical. Sedangkan saya lebih nyaman ruang kerja dengan tipe kisi 2x2 seperti di 16.04 . Pasang Workspace Matrix, ruang kerjanya bisa jadi kisi lagi dan sekaligus bisa 3x2.
.
Untuk kebutuhan kerja, saya pasang peramban Chrome dan editor teks VSCode. Tanpa pasang-pasang pengaya dan ekstensi, langsung siap digunakan. Terimakasih kepada direktori /home yang berada di partisi tersendiri. 👏👏👏
.
Belajar dari pengalaman sebelumnya, karena tidak ingin pasang perangkat lunak,layanan di sistem dan menjaga sistem tetap ringan, saya pasang docker untuk menjalankan peladen postgres-sql dan peladen redis. Saat ini mungkin hanya butuh 2 layanan itu saja, tapi kedepannya saya pasti butuh peladen mariadb,peladen mongodb,peladen rabbitmq,dll. Jadi docker ini sangat memudahkan bagi saya yang malas melakukan konfigurasi dan ingin segera bekerja. 💃
.
Untuk tampilan cukup sederhana saja. Menonaktifkan Ubuntu Dock, pasang tema dan ikon gelap MacOS, pasang kertas dinding MacOS Big Sur, dan pasang planck.
.
Terimakasih 16.04 yang sudah menemani sejak 2016. 🤝

 

 

 

 sumber: https://web.facebook.com/groups/2327054593/permalink/10158664721124594/?_rdc=1&_rdr