Corat Coret - User contributions [en]

Unifi Network

2025-01-10T07:41:06Z

Johan Efendi: Created page with " ===Menambahkan USG ke Existing Project=== Edit IP Address agar bisa dikenali di nextwork, misal 192.168.19.50 <syntaxhighlight lang="bash"> $ ssh ubnt@192.168.1.1 ubnt@ubnt:~$ configure ubnt@ubnt:~$ edit interfaces ethernet eth1 ubnt@ubnt:~$ set address 192.168.19.50 ubnt@ubnt:~$ commit ubnt@ubnt:~$ exit ubnt@ubnt:~$ exit </syntaxhighlight> Hapus IP lama dari USG <syntaxhighlight lang="bash"> $ ssh ubnt@[NEW IP] ubnt@ubnt:~$ configure ubnt@ubnt:~$ edit interfaces eth..."

===Menambahkan USG ke Existing Project===

Edit IP Address agar bisa dikenali di nextwork, misal 192.168.19.50
<syntaxhighlight lang="bash">
$ ssh ubnt@192.168.1.1
ubnt@ubnt:~$ configure
ubnt@ubnt:~$ edit interfaces ethernet eth1
ubnt@ubnt:~$ set address 192.168.19.50
ubnt@ubnt:~$ commit
ubnt@ubnt:~$ exit
ubnt@ubnt:~$ exit
</syntaxhighlight>

Hapus IP lama dari USG
<syntaxhighlight lang="bash">
$ ssh ubnt@[NEW IP]
ubnt@ubnt:~$ configure
ubnt@ubnt:~$ edit interfaces ethernet eth1
ubnt@ubnt:~$ delete address 192.168.1.1/24
ubnt@ubnt:~$ commit
ubnt@ubnt:~$ exit
</syntaxhighlight>

Beritahukan keberadaannya agar bisa dikenali oleh controller (CloudKey)
<syntaxhighlight lang="bash">
ubnt@ubnt:~$ set-inform http://[CLOUD KEY IP]:8080/inform
</syntaxhighlight>

Cheat Sheet

2024-12-01T23:10:49Z

Johan Efendi: Created page with "==Permanent Network Device Name== Temukan terlebih dahulu Mac Address yang akan dijadikan sebagai nama permanen network devive. Buat file /etc/systemd/network/10-ether1.link dan isi dengan <syntaxhighlight lang="bash"> [Match] MACAddress=aa:bb:cc:dd:ee:ff Type=ether [Link] Name=ether1 </syntaxhighlight> Sumber: * [https://pve.proxmox.com/wiki/Network_Configuration Network Configuration]"

==Permanent Network Device Name==

Temukan terlebih dahulu Mac Address yang akan dijadikan sebagai nama permanen network devive. Buat file /etc/systemd/network/10-ether1.link dan isi dengan
<syntaxhighlight lang="bash">
[Match]
MACAddress=aa:bb:cc:dd:ee:ff
Type=ether

[Link]
Name=ether1
</syntaxhighlight>

Sumber:
* [https://pve.proxmox.com/wiki/Network_Configuration Network Configuration]

NextCloud

2024-09-28T23:45:57Z

Johan Efendi: /* Generate Video Thumbnail */

==Reset Password==

* Login sebagai root dengan SSH
* Jalankan perintah <code>sudo -u nobody php-cli /srv/www/nextcloud/occ user:resetpassword <username></code>
* Masukkan password baru

<syntaxhighlight lang="bash">
sudo -u nobody php-cli /srv/www/nextcloud/occ user:resetpassword admin
Enter a new password:
Confirm the new password:
Successfully reset password for admin
</syntaxhighlight>

==Generate Video Thumbnail==

Install ffmpeg

<syntaxhighlight lang="bash">
# Install
apt install ffmpeg

# Verifikasi installasi
ffmpeg -version

# Check lokasi installasi ffmpeg
which ffmpeg
</syntaxhighlight>

Tamgahkan konfigurasi <code>config.php</code> dan sesuaikan lokasi ffmpeg

<syntaxhighlight lang="php">
'enable_previews' => true,
'enabledPreviewProviders' =>
array (
0 => 'OC\\Preview\\TXT',
1 => 'OC\\Preview\\MarkDown',
2 => 'OC\\Preview\\OpenDocument',
3 => 'OC\\Preview\\PDF',
4 => 'OC\\Preview\\MSOffice2003',
5 => 'OC\\Preview\\MSOfficeDoc',
6 => 'OC\\Preview\\Image',
7 => 'OC\\Preview\\Photoshop',
8 => 'OC\\Preview\\TIFF',
9 => 'OC\\Preview\\SVG',
10 => 'OC\\Preview\\Font',
11 => 'OC\\Preview\\MP3',
12 => 'OC\\Preview\\Movie',
13 => 'OC\\Preview\\MKV',
14 => 'OC\\Preview\\MP4',
15 => 'OC\\Preview\\AVI',
16 => 'OC\\Preview\\Mov',
),
'preview_ffmpeg_path' => '/usr/bin/ffmpeg',
</syntaxhighlight>

NextCloud

2024-09-28T23:44:21Z

Johan Efendi:

==Reset Password==

* Login sebagai root dengan SSH
* Jalankan perintah <code>sudo -u nobody php-cli /srv/www/nextcloud/occ user:resetpassword <username></code>
* Masukkan password baru

<syntaxhighlight lang="bash">
sudo -u nobody php-cli /srv/www/nextcloud/occ user:resetpassword admin
Enter a new password:
Confirm the new password:
Successfully reset password for admin
</syntaxhighlight>

==Generate Video Thumbnail==

Install ffmpeg

<syntaxhighlight lang="bash">
# Install
apt install ffmpeg

# Verifikasi installasi
ffmpeg -version

# Check lokasi installasi ffmpeg
which ffmpeg
</syntaxhighlight>

Tamgahkan konfigurasi <code>config.php</code> dan sesuaikan lokasi ffmpeg

<syntaxhighlight lang="php">
'enable_previews' => true,
'enabledPreviewProviders' =>
array (
0 => 'OC\\Preview\\TXT',
1 => 'OC\\Preview\\MarkDown',
2 => 'OC\\Preview\\OpenDocument',
3 => 'OC\\Preview\\PDF',
4 => 'OC\\Preview\\MSOffice2003',
5 => 'OC\\Preview\\MSOfficeDoc',
6 => 'OC\\Preview\\Image',
7 => 'OC\\Preview\\Photoshop',
8 => 'OC\\Preview\\TIFF',
9 => 'OC\\Preview\\SVG',
10 => 'OC\\Preview\\Font',
11 => 'OC\\Preview\\MP3',
12 => 'OC\\Preview\\Movie',
13 => 'OC\\Preview\\MKV',
14 => 'OC\\Preview\\MP4',
15 => 'OC\\Preview\\AVI',
15 => 'OC\\Preview\\Mov',
),
'preview_ffmpeg_path' => '/usr/bin/ffmpeg',
</syntaxhighlight>

NextCloud

2024-09-25T09:54:37Z

Johan Efendi: /* Reset Password */

NextCloud

2024-09-25T09:49:30Z

Johan Efendi: Created page with "==Reset Password== <syntaxhighlight lang="bash"> sudo -u nobody php-cli /srv/www/nextcloud/occ user:resetpassword admin Enter a new password: Confirm the new password: Successfully reset password for admin </syntaxhighlight>"

==Reset Password==
<syntaxhighlight lang="bash">
sudo -u nobody php-cli /srv/www/nextcloud/occ user:resetpassword admin
Enter a new password:
Confirm the new password:
Successfully reset password for admin
</syntaxhighlight>

Ubuntu Cheats

2024-09-13T06:33:40Z

Johan Efendi: Created page with "=Flush DNS= <syntaxhighlight lang="bash"> resolvectl flush-caches </syntaxhighlight>"

=Flush DNS=

<syntaxhighlight lang="bash">
resolvectl flush-caches
</syntaxhighlight>

Cyber Panel

2024-09-11T08:36:42Z

Johan Efendi: /* Shortcut */

=Deteksi IP Cloudflare=

<syntaxhighlight lang="bash">

# Edit litespeed config
nano /usr/local/lsws/conf/httpd_config.conf

# Tambahkan

useIpInProxyHeader 1

# Tambahkan

accessControl{
allow ALL, 173.245.48.0/20T, 103.21.244.0/22T, 103.22.200.0/22T, 103.31.4.0/22T, 141.101.64.0/18T, 108.162.192.0/18T, 190.93.240.0/20T, 188.114.96.0/20T, 197.234.240.0/22T, 198.41.128.0/17T, 162.158.0.0/15T, 104.16.0.0/13T, 104.24.0.0/14T, 172.64.0.0/13T, 131.0.72.0/22T
deny
}

# Restart litespeed

systemctl restart lsws

</syntaxhighlight>

=Shortcut=

<syntaxhighlight lang="bash">

# Trigger daily backup
/usr/local/CyberCP/bin/python /usr/local/CyberCP/plogical/IncScheduler.py Daily
</syntaxhighlight>

Cyber Panel

2024-09-11T08:36:29Z

Johan Efendi: /* Deteksi IP Cloudflare */

=Deteksi IP Cloudflare=

<syntaxhighlight lang="bash">

# Edit litespeed config
nano /usr/local/lsws/conf/httpd_config.conf

# Tambahkan

useIpInProxyHeader 1

# Tambahkan

accessControl{
allow ALL, 173.245.48.0/20T, 103.21.244.0/22T, 103.22.200.0/22T, 103.31.4.0/22T, 141.101.64.0/18T, 108.162.192.0/18T, 190.93.240.0/20T, 188.114.96.0/20T, 197.234.240.0/22T, 198.41.128.0/17T, 162.158.0.0/15T, 104.16.0.0/13T, 104.24.0.0/14T, 172.64.0.0/13T, 131.0.72.0/22T
deny
}

# Restart litespeed

systemctl restart lsws

</syntaxhighlight>

=Shortcut=

<syntaxhighlight lang="bash" style="overflow: auto;">

# Trigger daily backup
/usr/local/CyberCP/bin/python /usr/local/CyberCP/plogical/IncScheduler.py Daily
</syntaxhighlight>

Install Mikrotik di OS Ubuntu

2024-09-11T08:35:26Z

Johan Efendi: /* Install */

==Install==

<syntaxhighlight lang="bash">

wget https://download.mikrotik.com/routeros/7.15.3/chr-7.15.3.img.zip -O chr.img.zip
gunzip -c chr.img.zip > chr.img
echo u > /proc/sysrq-trigger

# Ganti /dev/sda dengan device yang sesuai
# Jalankan fdisk -l untuk nama devicenya

dd if=chr.img bs=1024 of=/dev/sda

</syntaxhighlight>

Install Mikrotik di OS Ubuntu

2024-09-11T08:33:34Z

Johan Efendi: Created page with "==Install== <syntaxhighlight lang="bash"> wget https://download.mikrotik.com/routeros/7.15.3/chr-7.15.3.img.zip -O chr.img.zip gunzip -c chr.img.zip > chr.img echo u > /proc/sysrq-trigger # Ganti /dev/sda dengan device yang sesuai # Jalankan fdisk -l untuk nama devicenya dd if=chr.img bs=1024 of=/dev/sda </syntaxhighlight>"

==Install==

<syntaxhighlight lang="bash">

wget https://download.mikrotik.com/routeros/7.15.3/chr-7.15.3.img.zip -O chr.img.zip
gunzip -c chr.img.zip > chr.img
echo u > /proc/sysrq-trigger

# Ganti /dev/sda dengan device yang sesuai
# Jalankan fdisk -l untuk nama devicenya
dd if=chr.img bs=1024 of=/dev/sda

</syntaxhighlight>

Zabbix

2024-09-10T12:10:55Z

Johan Efendi: /* Edit database */

===Edit database===

<syntaxhighlight lang="bash">
# nano /etc/zabbix/zabbix_server.conf
DBHost=localhost
DBName=zabbix
DBUser=zabbix
DBPassword=<password>

# nano /etc/zabbix/web/zabbix.conf.php
</syntaxhighlight>

===Menghapus History / Log===

<syntaxhighlight lang="bash">
SET @history_interval = 7;
SET @trends_interval = 90;

DELETE FROM alerts WHERE (UNIX_TIMESTAMP(NOW()) - clock) > (@history_interval * 24 * 60 * 60);
DELETE FROM acknowledges WHERE (UNIX_TIMESTAMP(NOW()) - clock) > (@history_interval * 24 * 60 * 60);
DELETE FROM events WHERE (UNIX_TIMESTAMP(NOW()) - clock) > (@history_interval * 24 * 60 * 60);

DELETE FROM history WHERE (UNIX_TIMESTAMP(NOW()) - clock) > (@history_interval * 24 * 60 * 60);
DELETE FROM history_uint WHERE (UNIX_TIMESTAMP(NOW()) - clock) > (@history_interval * 24 * 60 * 60);
DELETE FROM history_str WHERE (UNIX_TIMESTAMP(NOW()) - clock) > (@history_interval * 24 * 60 * 60);
DELETE FROM history_text WHERE (UNIX_TIMESTAMP(NOW()) - clock) > (@history_interval * 24 * 60 * 60);
DELETE FROM history_log WHERE (UNIX_TIMESTAMP(NOW()) - clock) > (@history_interval * 24 * 60 * 60);

DELETE FROM trends WHERE (UNIX_TIMESTAMP(NOW()) - clock) > (@trends_interval * 24 * 60 * 60);
DELETE FROM trends_uint WHERE (UNIX_TIMESTAMP(NOW()) - clock) > (@trends_interval * 24 * 60 * 60);
</syntaxhighlight>

Zabbix

2024-09-10T08:54:28Z

Johan Efendi:

===Edit database===

<syntaxhighlight lang="bash">
# vi /etc/zabbix/zabbix_server.conf
DBHost=localhost
DBName=zabbix
DBUser=zabbix
DBPassword=<password>
</syntaxhighlight>

===Menghapus History / Log===

<syntaxhighlight lang="bash">
SET @history_interval = 7;
SET @trends_interval = 90;

DELETE FROM alerts WHERE (UNIX_TIMESTAMP(NOW()) - clock) > (@history_interval * 24 * 60 * 60);
DELETE FROM acknowledges WHERE (UNIX_TIMESTAMP(NOW()) - clock) > (@history_interval * 24 * 60 * 60);
DELETE FROM events WHERE (UNIX_TIMESTAMP(NOW()) - clock) > (@history_interval * 24 * 60 * 60);

DELETE FROM history WHERE (UNIX_TIMESTAMP(NOW()) - clock) > (@history_interval * 24 * 60 * 60);
DELETE FROM history_uint WHERE (UNIX_TIMESTAMP(NOW()) - clock) > (@history_interval * 24 * 60 * 60);
DELETE FROM history_str WHERE (UNIX_TIMESTAMP(NOW()) - clock) > (@history_interval * 24 * 60 * 60);
DELETE FROM history_text WHERE (UNIX_TIMESTAMP(NOW()) - clock) > (@history_interval * 24 * 60 * 60);
DELETE FROM history_log WHERE (UNIX_TIMESTAMP(NOW()) - clock) > (@history_interval * 24 * 60 * 60);

DELETE FROM trends WHERE (UNIX_TIMESTAMP(NOW()) - clock) > (@trends_interval * 24 * 60 * 60);
DELETE FROM trends_uint WHERE (UNIX_TIMESTAMP(NOW()) - clock) > (@trends_interval * 24 * 60 * 60);
</syntaxhighlight>

Zabbix

2024-09-10T08:52:13Z

Johan Efendi: /* Menghapus History / Log */

===Menghapus History / Log===

<syntaxhighlight lang="bash">
SET @history_interval = 7;
SET @trends_interval = 90;

DELETE FROM alerts WHERE (UNIX_TIMESTAMP(NOW()) - clock) > (@history_interval * 24 * 60 * 60);
DELETE FROM acknowledges WHERE (UNIX_TIMESTAMP(NOW()) - clock) > (@history_interval * 24 * 60 * 60);
DELETE FROM events WHERE (UNIX_TIMESTAMP(NOW()) - clock) > (@history_interval * 24 * 60 * 60);

DELETE FROM history WHERE (UNIX_TIMESTAMP(NOW()) - clock) > (@history_interval * 24 * 60 * 60);
DELETE FROM history_uint WHERE (UNIX_TIMESTAMP(NOW()) - clock) > (@history_interval * 24 * 60 * 60);
DELETE FROM history_str WHERE (UNIX_TIMESTAMP(NOW()) - clock) > (@history_interval * 24 * 60 * 60);
DELETE FROM history_text WHERE (UNIX_TIMESTAMP(NOW()) - clock) > (@history_interval * 24 * 60 * 60);
DELETE FROM history_log WHERE (UNIX_TIMESTAMP(NOW()) - clock) > (@history_interval * 24 * 60 * 60);

DELETE FROM trends WHERE (UNIX_TIMESTAMP(NOW()) - clock) > (@trends_interval * 24 * 60 * 60);
DELETE FROM trends_uint WHERE (UNIX_TIMESTAMP(NOW()) - clock) > (@trends_interval * 24 * 60 * 60);
</syntaxhighlight>

Zabbix

2024-09-10T08:52:00Z

Johan Efendi: Created page with "=Menghapus History / Log= <syntaxhighlight lang="bash"> SET @history_interval = 7; SET @trends_interval = 90; DELETE FROM alerts WHERE (UNIX_TIMESTAMP(NOW()) - clock) > (@history_interval * 24 * 60 * 60); DELETE FROM acknowledges WHERE (UNIX_TIMESTAMP(NOW()) - clock) > (@history_interval * 24 * 60 * 60); DELETE FROM events WHERE (UNIX_TIMESTAMP(NOW()) - clock) > (@history_interval * 24 * 60 * 60); DELETE FROM history WHERE (UNIX_TIMESTAMP(NOW()) - clock) > (@history_..."

=Menghapus History / Log=

<syntaxhighlight lang="bash">
SET @history_interval = 7;
SET @trends_interval = 90;

DELETE FROM alerts WHERE (UNIX_TIMESTAMP(NOW()) - clock) > (@history_interval * 24 * 60 * 60);
DELETE FROM acknowledges WHERE (UNIX_TIMESTAMP(NOW()) - clock) > (@history_interval * 24 * 60 * 60);
DELETE FROM events WHERE (UNIX_TIMESTAMP(NOW()) - clock) > (@history_interval * 24 * 60 * 60);

DELETE FROM history WHERE (UNIX_TIMESTAMP(NOW()) - clock) > (@history_interval * 24 * 60 * 60);
DELETE FROM history_uint WHERE (UNIX_TIMESTAMP(NOW()) - clock) > (@history_interval * 24 * 60 * 60);
DELETE FROM history_str WHERE (UNIX_TIMESTAMP(NOW()) - clock) > (@history_interval * 24 * 60 * 60);
DELETE FROM history_text WHERE (UNIX_TIMESTAMP(NOW()) - clock) > (@history_interval * 24 * 60 * 60);
DELETE FROM history_log WHERE (UNIX_TIMESTAMP(NOW()) - clock) > (@history_interval * 24 * 60 * 60);

DELETE FROM trends WHERE (UNIX_TIMESTAMP(NOW()) - clock) > (@trends_interval * 24 * 60 * 60);
DELETE FROM trends_uint WHERE (UNIX_TIMESTAMP(NOW()) - clock) > (@trends_interval * 24 * 60 * 60);
</syntaxhighlight>

Install aaPanel Ubuntu 22.04

2024-09-10T06:42:45Z

Johan Efendi: /* Install */

=Install=

<syntaxhighlight lang="bash">
# Set timezone ke Asia/Jakarta
timedatectl set-timezone Asia/Jakarta

# Update
apt update && apt upgrade -y

# Install tools2 standard
apt install nano screen

# Install aapanel script
URL=https://www.aapanel.com/script/install_7.0_en.sh && if [ -f /usr/bin/curl ];then curl -ksSO "$URL" ;else wget --no-check-certificate -O install_7.0_en.sh "$URL";fi;bash install_7.0_en.sh aapanel

# Mengatasi bug saat install php extension
apt-get install autoconf -y
</syntaxhighlight>

=Installasi Compatible dengan WP=

* Apache 2.4
* PHP 8.3
* Pure FTPD
* phpMyAdmin
* Mailsys 4
* Redis 7

=Optional=

* FTP Storage
* Google Storage

=PHP 8.3=

* fileinfo
* redis
* imagemagick

=Cheat=

* mv /usr/bin/curl /usr/bin/curl_bak

Plesk

2024-09-10T00:42:00Z

Johan Efendi: /* Node & PHP */

=Location=

==Node & PHP==
<syntaxhighlight lang="bash">

# Node
/opt/plesk/node

# PHP
/opt/plesk/php

</syntaxhighlight>

Jika NPM tidak dikenali sebagai program di shell

<syntaxhighlight lang="bash">
export PATH=$PATH:/opt/plesk/node/21/bin
</syntaxhighlight>

=Whitelist Cloudflare IP's=
<syntaxhighlight lang="bash">
plesk bin ip_ban --add-trusted "173.245.48.0/20" -description "Cloudflare Proxy"
plesk bin ip_ban --add-trusted "173.245.48.0/20" -description "Cloudflare Proxy"
plesk bin ip_ban --add-trusted "103.21.244.0/22" -description "Cloudflare Proxy"
plesk bin ip_ban --add-trusted "103.22.200.0/22" -description "Cloudflare Proxy"
plesk bin ip_ban --add-trusted "103.31.4.0/22" -description "Cloudflare Proxy"
plesk bin ip_ban --add-trusted "141.101.64.0/18" -description "Cloudflare Proxy"
plesk bin ip_ban --add-trusted "108.162.192.0/18" -description "Cloudflare Proxy"
plesk bin ip_ban --add-trusted "190.93.240.0/20" -description "Cloudflare Proxy"
plesk bin ip_ban --add-trusted "188.114.96.0/20" -description "Cloudflare Proxy"
plesk bin ip_ban --add-trusted "197.234.240.0/22" -description "Cloudflare Proxy"
plesk bin ip_ban --add-trusted "198.41.128.0/17" -description "Cloudflare Proxy"
plesk bin ip_ban --add-trusted "162.158.0.0/15" -description "Cloudflare Proxy"
plesk bin ip_ban --add-trusted "104.16.0.0/13" -description "Cloudflare Proxy"
plesk bin ip_ban --add-trusted "104.24.0.0/14" -description "Cloudflare Proxy"
plesk bin ip_ban --add-trusted "172.64.0.0/13" -description "Cloudflare Proxy"
plesk bin ip_ban --add-trusted "131.0.72.0/22" -description "Cloudflare Proxy"
</syntaxhighlight>

Matomo

2024-09-05T06:31:04Z

Johan Efendi:

=Shortcut=

# Reset Password

php -r 'echo password_hash(md5("changeMe"), PASSWORD_DEFAULT) . "\n";'

# Config cloudflare

proxy_client_headers[] = HTTP_CF_CONNECTING_IP

Cyber Panel

2024-09-04T14:34:47Z

Johan Efendi: /* Deteksi IP Cloudflare */

=Deteksi IP Cloudflare=

<syntaxhighlight lang="bash" style="overflow: auto;">

# Edit litespeed config
nano /usr/local/lsws/conf/httpd_config.conf

# Tambahkan

useIpInProxyHeader 1

# Tambahkan

accessControl{
allow ALL, 173.245.48.0/20T, 103.21.244.0/22T, 103.22.200.0/22T, 103.31.4.0/22T, 141.101.64.0/18T, 108.162.192.0/18T, 190.93.240.0/20T, 188.114.96.0/20T, 197.234.240.0/22T, 198.41.128.0/17T, 162.158.0.0/15T, 104.16.0.0/13T, 104.24.0.0/14T, 172.64.0.0/13T, 131.0.72.0/22T
deny
}

# Restart litespeed

systemctl restart lsws

</syntaxhighlight>

=Shortcut=

<syntaxhighlight lang="bash" style="overflow: auto;">

# Trigger daily backup
/usr/local/CyberCP/bin/python /usr/local/CyberCP/plogical/IncScheduler.py Daily
</syntaxhighlight>

Matomo

2024-09-04T13:55:42Z

Johan Efendi: Created page with "=Shortcut= # Reset Password php -r 'echo password_hash(md5("changeMe"), PASSWORD_DEFAULT) . "\n";'"

=Shortcut=

# Reset Password

php -r 'echo password_hash(md5("changeMe"), PASSWORD_DEFAULT) . "\n";'

Cyber Panel

2024-09-04T12:20:58Z

Johan Efendi: /* Deteksi IP Cloudflare */

=Deteksi IP Cloudflare=

<syntaxhighlight lang="bash" style="overflow: auto;">
nano /usr/local/lsws/conf/httpd_config.conf

# Tambahkan
useIpInProxyHeader 1

# Tambahkan
accessControl{
allow ALL, 173.245.48.0/20T, 103.21.244.0/22T, 103.22.200.0/22T, 103.31.4.0/22T, 141.101.64.0/18T, 108.162.192.0/18T, 190.93.240.0/20T, 188.114.96.0/20T, 197.234.240.0/22T, 198.41.128.0/17T, 162.158.0.0/15T, 104.16.0.0/13T, 104.24.0.0/14T, 172.64.0.0/13T, 131.0.72.0/22T
deny
}

# Restart litespeed
</syntaxhighlight>

=Shortcut=

<syntaxhighlight lang="bash" style="overflow: auto;">

# Trigger daily backup
/usr/local/CyberCP/bin/python /usr/local/CyberCP/plogical/IncScheduler.py Daily
</syntaxhighlight>

Johan Efendi: Created page with "=Install Service= Menggunakan command prompt administrator <syntaxhighlight lang="prompt"> sc create "MariaDB" binpath= "\"F:/var/apps/Maria-11.4.2-x64/bin/mysqld\" \"--defaults-file=F:/var/mysql/data/01/my.ini\" MariaDB" DisplayName= "MariaDB" start= "auto" </syntaxhighlight>"

=Install Service=

Menggunakan command prompt administrator
<syntaxhighlight lang="prompt">
sc create "MariaDB" binpath= "\"F:/var/apps/Maria-11.4.2-x64/bin/mysqld\" \"--defaults-file=F:/var/mysql/data/01/my.ini\" MariaDB" DisplayName= "MariaDB" start= "auto"
</syntaxhighlight>

Docker Apache MySQL

2024-06-19T05:59:22Z

Johan Efendi:

=Installasi=

Menginstall Apache dan MySQL dengan docker

Struktur Direktori
<pre>
+ docker
+ +--- database
+ +--- web
+ + + default.conf
+ +--- Dockerfile
+ docker-compose.yml
</pre>

File: Dockerfile
<syntaxhighlight lang="docker">
FROM php:8.1.2-apache

RUN apt-get update \
&& apt-get install -y \
libfreetype6-dev \
libpng-dev \
libwebp-dev \
libjpeg62-turbo-dev \
libmcrypt-dev \
libzip-dev \
zip \
git \
default-mysql-client \
&& docker-php-ext-install \
pdo_mysql \
gd \
zip \
&& a2enmod \
rewrite

# Add the user UID:1000, GID:1000, home at /app
RUN groupadd -r app -g 1000 && useradd -u 1000 -r -g app -m -d /app -s /sbin/nologin -c "App user" app && \
chmod 755 /var/www/html

#upload
RUN echo "file_uploads = On\n" \
"memory_limit = 500M\n" \
"upload_max_filesize = 500M\n" \
"post_max_size = 500M\n" \
"max_execution_time = 600\n" \
> /usr/local/etc/php/conf.d/uploads.ini

# Install composer
COPY --from=composer:latest /usr/bin/composer /usr/local/bin/composer

USER app

WORKDIR /var/www/html

USER root

COPY ./web/default.conf /etc/apache2/sites-enabled/000-default.conf

CMD ["/usr/sbin/apache2ctl", "-D", "FOREGROUND"]

EXPOSE 80
</syntaxhighlight>

File: docker-compose.yml
<syntaxhighlight lang="docker">
version: '3'

services:
web:
environment:
- APACHE_RUN_USER=#1000
build:
context: ./docker
ports:
- 10000:80
volumes:
- ./:/var/www/html

database:
image: mariadb
restart: always
ports:
- 33061:3306
environment:
MYSQL_ROOT_PASSWORD: 123
volumes:
- ./docker/database:/var/lib/mysql
</syntaxhighlight>

File: default.conf
<syntaxhighlight lang="bash">
<VirtualHost *:80>
ServerName localhost

ServerAdmin webmaster@localhost
DocumentRoot /var/www/html/public

ErrorLog ${APACHE_LOG_DIR}/error.log
CustomLog ${APACHE_LOG_DIR}/access.log combined
</VirtualHost>
</syntaxhighlight>

Menjalankan
<syntaxhighlight lang="bash">
docker compose build
docker compose up -d
</syntaxhighlight>

Jika ingin menambahkan nodejs / npm
<syntaxhighlight lang="docker">
ENV NODE_PATH $NVM_DIR/v$NODE_VERSION/lib/node_modules
ENV PATH $NVM_DIR/versions/node/v$NODE_VERSION/bin:$PATH

ENV NVM_VERSION v0.39.7
ENV NODE_VERSION v18.17.0
ENV NVM_DIR /usr/local/nvm
RUN mkdir -p $NVM_DIR
RUN curl -o- https://raw.githubusercontent.com/creationix/nvm/v0.39.7/install.sh | bash

ENV NODE_PATH $NVM_DIR/$NODE_VERSION/lib/node_modules
ENV PATH $NVM_DIR/versions/node/$NODE_VERSION/bin:$PATH

RUN echo "source $NVM_DIR/nvm.sh && \
nvm install $NODE_VERSION && \
nvm alias default $NODE_VERSION && \
nvm use default" | bash

</syntaxhighlight>

=Akses Public=

<pre>

ip addr show eth0

netsh interface portproxy add v4tov4 listenport=10000 listenaddress=0.0.0.0 connectport=10000 connectaddress=www.xxx.yyy.zzzz

</pre>