SYAMS-Info

Enable Autologin for GDM on RHEL 8

1. Edit the GDM custom.conf file:

sudo nano /etc/gdm/custom.conf

2. Uncomment and modify/add the following lines under the [daemon] section:

[daemon]
AutomaticLoginEnable=True
AutomaticLogin=your_username

Oracle Database 19c Service (AUTOSTART CDB/PDB) on Oracle LinuxR8

Buat file service
sudo vi /etc/systemd/system/oracledb_ORCLCDB.service

[Unit]
Description=Oracle Database service for ORCLCDB
After=network.target
Wants=network.target

[Service]
Type=forking
User=oracle
Group=oinstall
Environment=ORACLE_HOME=/opt/oracle/product/19c/dbhome_1
Environment=ORACLE_SID=ORCLCDB
Environment=PATH=/opt/oracle/product/19c/dbhome_1/bin:/usr/bin:/bin
ExecStart=/opt/oracle/product/19c/dbhome_1/bin/dbstart $ORACLE_HOME
ExecStop=/opt/oracle/product/19c/dbhome_1/bin/dbshut $ORACLE_HOME
TimeoutSec=600
Restart=on-failure
RemainAfterExit=yes

[Install]
WantedBy=multi-user.target

Catatan penting:

dbstart/dbshut membaca /etc/oratab. Pastikan entri CDB:

ORCLCDB:/opt/oracle/product/19c/dbhome_1:Y (huruf terakhir Y agar auto-start).

Sesuaikan ORACLE_HOME/ORACLE_SID kalau berbeda.

Reload systemd
sudo systemctl daemon-reload

Enable saat boot
sudo systemctl enable oracledb_ORCLCDB.service

Start sekarang (opsional)

sudo systemctl start oracledb_ORCLCDB.service

Cek status
sudo systemctl status oracledb_ORCLCDB.service

Log jika perlu
journalctl -u oracledb_ORCLCDB.service -b

Oracle Listener Service (AUTOSTART LISTENER)

Buat file service
sudo vi /etc/systemd/system/oracle-listener.service

[Unit]
Description=Oracle Listener
After=network.target

[Service]
Type=forking
User=oracle
Group=oinstall
Environment=ORACLE_BASE=/opt/oracle
Environment=ORACLE_HOME=/opt/oracle/product/19c/dbhome_1
Environment=TNS_ADMIN=/opt/oracle/product/19c/dbhome_1/network/admin
Environment=LD_LIBRARY_PATH=/opt/oracle/product/19c/dbhome_1/lib
Environment=PATH=/opt/oracle/product/19c/dbhome_1/bin:/usr/bin:/bin
ExecStart=/opt/oracle/product/19c/dbhome_1/bin/lsnrctl start
ExecStop=/opt/oracle/product/19c/dbhome_1/bin/lsnrctl stop
RemainAfterExit=yes
Restart=on-failure

[Install]
WantedBy=multi-user.target

Reload systemd
sudo systemctl daemon-reload

Enable saat boot
sudo systemctl enable oracle-listener.service

Start sekarang
sudo systemctl start oracle-listener.service

Cek status
sudo systemctl status oracle-listener.service

Verifikasi listener
lsnrctl status

Uji Saat Reboot

Reboot
sudo reboot

Setelah login, cek:

sudo systemctl status oracledb_ORCLCDB.service
sudo systemctl status oracle-listener.service

Ringkasan

DB service: /etc/systemd/system/oracledb_ORCLCDB.service (pakai dbstart/dbshut).

Listener service: /etc/systemd/system/oracle-listener.service (pakai lsnrctl start/stop).

Pastikan /etc/oratab punya entri ...:Y.

Aktifkan auto-start dengan systemctl enable dan verifikasi dengan status / journalctl.

Langkah demi langkah instalasi Oracle Database 19c di Oracle Linux R8

# 1. User & Group
groupadd -g 54321 oinstall
groupadd -g 54322 dba
useradd -u 54321 -g oinstall -G dba oracle
passwd oracle

# 2. Install Preinstall & Oracle DB
yum install -y oracle-database-preinstall-19c
yum install -y oracle-database-ee-19c-1.0-1.x86_64.rpm

# 3. Set Password Default
export ORACLE_PASSWORD=xxxxx

# 4. Create & Start Database
/etc/init.d/oracledb_ORCLCDB-19c configure

# 5. Tambah Environment di .bashrc
echo 'export ORACLE_HOME=/opt/oracle/product/19c/dbhome_1' >> ~/.bashrc
echo 'export ORACLE_SID=ORCLCDB' >> ~/.bashrc
echo 'export PATH=$ORACLE_HOME/bin:$PATH' >> ~/.bashrc
source ~/.bashrc

# 6. Ganti Password SYS & SYSTEM
su - oracle
/opt/oracle/product/19c/dbhome_1/bin/oraenv # ORCLCDB
sqlplus / as sysdba
ALTER USER sys IDENTIFIED BY newpass;
ALTER USER system IDENTIFIED BY newpass;

Info Penting

ORACLE_HOME: /opt/oracle/product/19c/dbhome_1
ORACLE_BASE: /opt/oracle/
Listener: 1521
EM: https://localhost:5500/em

Mount Partisi NTFS di Oracle Linux R8

Berikut versi teks biasa tutorial instalasi NTFS-3G di Linux berbasis RHEL/CentOS/AlmaLinux/RockyLinux:

Aktifkan EPEL Repository

Jalankan perintah:
sudo dnf install -y epel-release

Install NTFS-3G

Setelah EPEL aktif, jalankan:
sudo dnf install -y ntfs-3g

Cek instalasi

Pastikan sudah terpasang dengan perintah:
ntfs-3g --version

Mount partisi NTFS

Misalnya partisi NTFS ada di /dev/sdb1 dan akan dipasang di /mnt/ntfs:

sudo mkdir -p /mnt/ntfs
sudo mount -t ntfs-3g /dev/sdb1 /mnt/ntfs

Unmount partisi

Setelah selesai digunakan:
sudo umount /mnt/ntfs

Panduan Instalasi Sertifikat Let's Encrypt (Produksi) untuk Apache (XAMPP/Linux) Langkah 1

🔐 Panduan Instalasi Sertifikat Let's Encrypt (Produksi) untuk Apache (XAMPP/Linux)
Langkah 1: Install Certbot

sudo apt update
sudo apt install certbot python3-certbot-apache

Langkah 2: Dapatkan Sertifikat Let's Encrypt

sudo certbot certonly --manual --preferred-challenges dns -d sub.domain.com

Ikuti instruksi yang muncul. Anda akan diminta menambahkan DNS TXT record:

    Name:

_acme-challenge.sub.domain.com.

Type:

TXT

Value (contoh dari certbot):

    7F4rb3Oz1BrAemrhDDHJGcIlItYc9kXcJRnAVhebLog

🕒 Tunggu propagasi DNS, lalu verifikasi TXT record sudah aktif menggunakan Google Admin Toolbox

Jika berhasil, Anda akan melihat pesan:

Successfully received certificate.
Certificate is saved at: /etc/letsencrypt/live/sub.domain.com/fullchain.pem
Key is saved at:         /etc/letsencrypt/live/sub.domain.com/privkey.pem

⚠️ Catatan

    Sertifikat manual tidak diperpanjang otomatis.

    Untuk perpanjangan, ulangi perintah certbot dan proses DNS challenge.

Langkah 3: Konfigurasi Apache (XAMPP)

Contoh konfigurasi VirtualHost SSL:

Edit file:

sudo nano /opt/lampp/etc/extra/httpd-ssl.conf

Tambahkan atau sesuaikan:

<VirtualHost *:443>
    ServerName sub.domain.com
    DocumentRoot "/opt/lampp/htdocs/subdomain"

    SSLEngine on
    SSLCertificateFile "/etc/letsencrypt/live/sub.domain.com/fullchain.pem"
    SSLCertificateKeyFile "/etc/letsencrypt/live/sub.domain.com/privkey.pem"

    <Directory "/opt/lampp/htdocs/subdomain">
        Options Indexes FollowSymLinks
        AllowOverride All
        Require all granted
    </Directory>
</VirtualHost>

<VirtualHost *:80>
    ServerName sub.domain.com
    Redirect permanent / https://sub.domain.com/
</VirtualHost>

Langkah 4: Aktifkan Modul SSL Apache

Edit file:

sudo nano /opt/lampp/etc/httpd.conf

Pastikan baris berikut tidak dikomentari (tidak diawali #):

LoadModule ssl_module modules/mod_ssl.so
Include etc/extra/httpd-ssl.conf

Langkah 5: Restart Apache

sudo /opt/lampp/lampp restart

Langkah 6: Uji Sertifikat

Buka browser dan akses:

https://sub.domain.com

Jika menggunakan sertifikat valid dari Let's Encrypt, tidak akan ada peringatan keamanan dari browser.

cloudflared tunnel on ubuntu

Berikut tutorial pembuatan Cloudflare Tunnel step-by-step lengkap dengan gambar dari tangkapan layar Anda, untuk pemahaman yang praktis dan rapi:
1️⃣ Login ke Cloudflare Dashboard

    Akses: https://dash.cloudflare.com/

    Masuk menggunakan akun email Anda.

    Pilih akun yang akan digunakan untuk tunnel.

2️⃣ Masuk ke menu Zero Trust → Tunnels

    Klik Zero Trust di sidebar.

    Pilih Networks → Tunnels.

    Anda akan melihat daftar tunnel aktif dan tidak aktif.

3️⃣ Klik Create a Tunnel

    Klik tombol + Create a tunnel.

4️⃣ Pilih metode koneksi tunnel

    Pilih Cloudflared (Recommended).

    Klik Select Cloudflared.

5️⃣ Ikuti instruksi instalasi Cloudflared

Jika belum menginstall cloudflared:

# Tambah GPG key
sudo mkdir -p --mode=0755 /usr/share/keyrings
curl -fsSL https://pkg.cloudflare.com/cloudflare-main.gpg | sudo tee /usr/share/keyrings/cloudflare-main.gpg >/dev/null

# Tambah repository
echo 'deb [signed-by=/usr/share/keyrings/cloudflare-main.gpg] https://pkg.cloudflare.com/cloudflared any main' | sudo tee /etc/apt/sources.list.d/cloudflared.list

# Update dan install
sudo apt-get update

sudo apt-get install cloudflared

6️⃣ Jalankan tunnel dengan token

Setelah cloudflared terinstall, Anda bisa:

    Jalankan otomatis saat boot:

sudo cloudflared service install <TOKEN_YANG_DISEDIAKAN>

    Atau jalankan manual:

cloudflared tunnel run --token <TOKEN_YANG_DISEDIAKAN>

Token didapat dari tampilan pembuatan tunnel.
7️⃣ Tunnel berhasil dibuat

Tunnel Anda akan muncul di daftar dengan status HEALTHY jika berjalan normal.

8️⃣ Konfigurasi Routes

Jika ingin mengarahkan domain ke server lokal Anda:

    Klik Configure pada tunnel.

    Tambahkan Public Hostname sesuai domain/subdomain dan arahkan ke port lokal server Anda (misal port 80/443).

    Simpan konfigurasi.

Gunakan systemctl status cloudflared untuk memeriksa status tunnel jika menggunakan service.