Saturday, July 11, 2026

install openclaw

 jadikan file .bat

@echo off

setlocal EnableDelayedExpansion


:: ================================================================

::  install_nodejs_openclaw.bat  (v4 - Telegram Allowlist)

::  Install Node.js + OpenClaw

::  Jalankan sebagai Administrator.

:: ================================================================


title  Setup OpenClaw - Telegram (Allowlist) + DeepSeek


set "NODE_VERSION=22.16.0"

set "NODE_ARCH=x64"

set "NODE_MSI=node-v%NODE_VERSION%-%NODE_ARCH%.msi"

set "NODE_URL=https://nodejs.org/dist/v%NODE_VERSION%/%NODE_MSI%"

set "NODE_INSTALLER=%TEMP%\%NODE_MSI%"

set "NODE_DIR=%ProgramFiles%\nodejs"

set "NPM_GLOBAL=%APPDATA%\npm"

set "OC=%NPM_GLOBAL%\openclaw.cmd"


cls

echo.

echo  ================================================================

echo    OpenClaw Installer 

echo  ================================================================

echo.


:: ================================================================

::  [0] Cek Administrator

:: ================================================================

net session >nul 2>&1

if %ERRORLEVEL% neq 0 (

    echo  [ERROR] Harus dijalankan sebagai Administrator.

    echo          Klik kanan file ini -^> "Run as administrator"

    echo.

    pause & exit /b 1

)


:: ================================================================

::  [1] Cek / Install Node.js

:: ================================================================

echo.

echo  [1/7] Memeriksa Node.js...

where node >nul 2>&1

if %ERRORLEVEL% equ 0 (

    for /f "tokens=*" %%V in ('node --version 2^>nul') do echo        Sudah ada: %%V - dilewati.

    set "PATH=%NODE_DIR%;%NPM_GLOBAL%;%PATH%"

    goto :install_openclaw

)


echo        Mengunduh Node.js v%NODE_VERSION%...


where curl >nul 2>&1

if %ERRORLEVEL% equ 0 (

    curl -L --ssl-no-revoke --progress-bar -o "%NODE_INSTALLER%" "%NODE_URL%"

    if %ERRORLEVEL% equ 0 goto :node_dl_ok

    echo        curl gagal, beralih ke bitsadmin...

)


bitsadmin /transfer "NodeJSDownload" /download /priority normal "%NODE_URL%" "%NODE_INSTALLER%" >nul

if %ERRORLEVEL% neq 0 ( echo  [ERROR] Gagal download Node.js. & goto :error_exit )


:node_dl_ok

if not exist "%NODE_INSTALLER%" ( echo  [ERROR] File installer tidak ditemukan. & goto :error_exit )

echo        Menginstall Node.js...

msiexec.exe /i "%NODE_INSTALLER%" /qn /norestart ADDLOCAL=ALL

if %ERRORLEVEL% neq 0 ( echo  [ERROR] Instalasi Node.js gagal (code %ERRORLEVEL%). & del /f /q "%NODE_INSTALLER%" >nul 2>&1 & goto :error_exit )

del /f /q "%NODE_INSTALLER%" >nul 2>&1

set "PATH=%NODE_DIR%;%NPM_GLOBAL%;%PATH%"

echo        Node.js berhasil diinstall.


:: ================================================================

::  [2] Install OpenClaw

:: ================================================================

:install_openclaw

echo.

echo  [2/7] Menginstall OpenClaw...

if not exist "%NODE_DIR%\npm.cmd" ( echo  [ERROR] npm tidak ditemukan. & goto :error_exit )

call "%NODE_DIR%\npm.cmd" install -g openclaw --silent

if %ERRORLEVEL% neq 0 ( echo  [ERROR] Gagal install OpenClaw. & goto :error_exit )

if not exist "%OC%" if exist "%NODE_DIR%\openclaw.cmd" set "OC=%NODE_DIR%\openclaw.cmd"

if not exist "%OC%" ( echo  [ERROR] openclaw.cmd tidak ditemukan: %OC% & goto :error_exit )

echo        OpenClaw berhasil diinstall.


:: ================================================================

::  [3] Onboarding

:: ================================================================

echo.

echo  [3/7] Inisialisasi OpenClaw...

call "%OC%" onboard --non-interactive --skip-health >nul 2>&1

echo        Selesai.

pause

save, jalankan.

Sunday, July 5, 2026

Sunday, June 21, 2026

Sunday, June 14, 2026

VPN, remote, proxy and hosting

Jika optimasi di atas dilakukan, berikut adalah perkiraan penggunaan RAM:

  • OS Debian (Idle): ~100 MB - 150 MB
  • Headscale: ~20 MB - 50 MB (sangat ringan)
  • RustDesk Server (hbbs + hbbr): ~15 MB - 30 MB (hanya memakan memori kecil)
  • Squid Proxy Server: ~50 MB - 100 MB (tergantung besarnya cache)
  • myVestaCP (Nginx + PHP-FPM + MariaDB tanpa Email/ClamAV): ~400 MB - 500 MB
  • Total Konsumsi: ~600 MB - 850 MB.

Saturday, May 30, 2026

Install di win10

Install otomatis di win 10, dengan powershell - Run as Administrator:

Monday, March 16, 2026

setup server dg mariadb

 

 ini save sebagai setup.sh, chmod +x, jalankan ./setup.sh


Wednesday, March 11, 2026

setup app dan api

 dibuat api.sh, chmod +x, jalankan ./api.sh

setup server

 ini save sebagai setup.sh, chmod +x, jalankan ./setup.sh


Friday, June 27, 2025

Thursday, February 20, 2025

Jasper Report - Idempiere - Date

 #utk report dg parameter date Optional, pakai query:
Parameters
tgl = java.util.Date

SQL = select * from tableX where lahir=coalesce($P{tgl},lahir)

paham?

Saturday, February 15, 2025

Mencari Query Lambat di Postgres

/etc/postgresql/17/main/postgresql.conf

 #------------------------------------------------------------------------------
# CUSTOMIZED OPTIONS
#------------------------------------------------------------------------------

# Add settings for extensions here
shared_preload_libraries = 'auto_explain'

#Log query yang lebih lambat dari 3 detik
auto_explain.log_min_duration = '1s'

#Sertakan statistik waktu eksekusi
auto_explain.log_analyze = 'true'

#Sertakan informasi penggunaan buffer
auto_explain.log_buffers = 'true'

#Sertakan waktu setiap node dalam query plan
auto_explain.log_timing = 'true'

#Sertakan detail tambahan tentang query plan
auto_explain.log_verbose = 'true'

#Log subquery atau nested statement
auto_explain.log_nested_statements = 'true'


logging_collector = on
log_directory = 'pg_log'

#tempat log, cek di data_directory di file ini juga, default di: /var/lib/postgresql/17/main

 

#reff auto explain = https://www.postgresql.org/docs/current/auto-explain.html

 

Sunday, January 5, 2025

Install postgresql 17 on debian 12

sudo apt install curl ca-certificates
 

sudo install -d /usr/share/postgresql-common/pgdg
 

sudo curl -o /usr/share/postgresql-common/pgdg/apt.postgresql.org.asc --fail https://www.postgresql.org/media/keys/ACCC4CF8.asc
 

sudo sh -c 'echo "deb [signed-by=/usr/share/postgresql-common/pgdg/apt.postgresql.org.asc] https://apt.postgresql.org/pub/repos/apt $(lsb_release -cs)-pgdg main" > /etc/apt/sources.list.d/pgdg.list'
 

sudo apt update
 

sudo apt -y install postgresql-17

--done--

Wednesday, January 1, 2025

Tigervncserver on debian12

install minimal

myvestacp

lxde-core

timedatectl set-timezone Asia/Jakarta

dpkg --add-architecture i386
apt update
apt install wine wine32 wine64 libwine libwine:i386 fonts-wine
cd /usr/local/bin
wget http://winetricks.org/winetricks
chmod +x winetricks
apt install firefox-esr -y
apt install tigervnc-standalone-server tigervnc-common
reboot now

useradd namauser

su - namauser -m

vncserver

[create vncpasswd] tersimpan di /home/namauser/.vnc/passwd

#tambahkan namauser di /etc/tigervnc/vncserver.users

:1=namauser

 

#create file config = /home/namauser/.vnc/config, isinya:

geometry=1360x768

alwaysshared

localhost=no

 

#tambahkan service file:

cp /lib/systemd/system/tigervncserver@.service  /etc/systemd/system/vncserver@:[vncport-5900].service
 

#aktifkan service

systemctl enable --now vncserver@:33102



Wednesday, September 25, 2024

Membesarkan HD Virtual - Qemu KVM

 Host=CentOS 6 / Debian

VM=Oracle Linux 5


===============================

--di HOST

===============================

--matikan vm

--cek size (dari Host)

qemu-img info [nama HD vm]


--extend size HD nya (dari Host) misal ditambah 20G

qemu-img resize [nama HD vm] +20G


--cek size (dari Host)

qemu-img info [nama HD vm]


--matikan virtual manager bila perlu 

--ATAU reboot HOST bila perlu (opsi terakhir)

============================

--nyalakan VM - login ke VM

============================

--cek diskfree

df -l


--fdisk: cek nama hard disk yg akan ditambahkan, misal /dev/vda dst...

fdisk -l


--fdisk: masuk ke hdd yg akan ditambahkan

fdisk /dev/vda


--print utk lihat partisi terakhir (misal udah ada 2)

p

--create partisi

n

--primary

p

--nomor 3 (karna udah ada 2)

3

--write (kalau belum write maka dianggap batal)

w


--cek apakah partisi nomor 3 udah ada

fdisk -l


--wajib reboot vm

reboot


--lakukan tanpa di skip

pvs

pvcreate /dev/vda3

vgs

vgextend /dev/VolGroup00 /dev/vda3

lvs

lvextend -l +100%FREE /dev/VolGroup00/LogVol00

resize2fs /dev/VolGroup00/LogVol00


--cek lagi, harusnya udah bertambah

df -h


reboot

--login lagi -- double cek dg 

df -h


===========================

--selesai... tidur lagi :)

===========================


Sunday, December 18, 2022

New RAM+SSD and Reinstall server HP DL380 Gen9

 1.tarik keluar 3/4 badan, buka tutup atas(tanpa alat),plastik, pasang RAM, tutup semua, pasang SSD

2.pasang monitor+keyboard+mouse di server

3.boot - tekan F10 - HP Smart Storage Administrator [ENTER]

4.[Configure] -> select All SSD, check UnASSIGNED Drives

5.RAID Level = Raid 1, biarkan default,[CREATE LOGICAL DRIVE] -> [FINISH]

6. [x] right top to [REBOOT]

7. boot - tekan F9 -> pilih boot dari FlashDisk (USB)

Wednesday, December 7, 2022

host=Debian11 ip-host=15 network=bridge virtual=ip12

#login root, remove DVD

nano /etc/apt/sources.list

menjadi=

deb http://mirror.0x.sg/debian/ bullseye main

deb-src http://mirror.0x.sg/debian/ bullseye main


deb http://security.debian.org/debian-security bullseye-security main

deb-src http://security.debian.org/debian-security bullseye-security main


# bullseye-updates, to get updates before a point release is made;

# see https://www.debian.org/doc/manuals/debian-reference/ch02.en.html#_updates_and_backports

deb http://mirror.0x.sg/debian/ bullseye-updates main

deb-src http://mirror.0x.sg/debian/ bullseye-updates main


---end of sources.list

#allow root ssh

nano /etc/ssh/sshd_config


#allow root login

nano /etc/gdm3/daemon.conf

[security]

AllowRoot=true


nano /etc/pam.d/gdm-password

#auth required pam_succeed_if.so user != root quiet_success


#instal kvm

apt install qemu-kvm libvirt-clients libvirt-daemon-system bridge-utils virtinst libvirt-daemon

apt install virt-manager -y


virsh net-list --all


#jadikan autostart

virsh net-autostart default


#bridge util

apt install bridge-utils uml-utilities -y


modprobe vhost_net


#tambahkan vhost_net

nano /etc/modules

vhost_net


#cek

lsmod | grep vhost


#lihat nama network

ip a

#set bridge dg ip HOST, bukan ip TAMU

nano /etc/network/interfaces

#tambahin (bila nama networknya eno1)

auto br0

iface br0 inet static

  address 10.12.13.105/16

  gateway 10.12.0.3

  dns-nameservers 10.12.0.7

  bridge_ports eno1

#reboot

#baru buka virt-manager utk define TAMU dg BRIDGE br0
#set ip masing2 TAMU di TAMU 

Sunday, October 2, 2022

install myvestacp

 1.install minimal debian 11

2.ubah password root

3.ikuti=

apt install -y mc curl

curl -O http://c.myvestacp.com/vst-install-debian.sh

bash vst-install-debian.sh --apache yes --nginx yes --phpfpm no --vsftpd no --proftpd yes --named yes --mysql yes --mysql8 no --postgresql no --exim yes --dovecot yes --clamav yes --spamassassin yes --iptables yes --fail2ban yes --quota no --force no --interactive yes --port [isi-nomor-besar] --lang en

apt install postgresql postgresql-contrib

apt install openjdk-17-jdk -y

apt install lxde-core -y firefox-esr


Wednesday, September 21, 2022

Backup Restore Postgresql

** backup **

[enter password utk postgres -- bila perlu]

root#passwd postgres

[enter password]

root#su postgres

postgres# pg_dump -W -F t idempiere > /tmp/idempiere.tar

exit


** restore **

root#su postgres

postgres#psql  --masuk psql

postgres# drop database idempiere

postgres# create database idempiere

postgres# exit ---dari psql

postgres# pg_restore --dbname=idempiere < /tmp/idempiere.tar

exit

** selesai **

Wednesday, April 14, 2021

Check VPS / Test VPS

cek ini juga: http://note88.blogspot.com/2013/08/cara-test-vps.html  

 

https://github.com/masonr/yet-another-bench-script

SSD LAPTOP LOKAL ASLI

Basic System Information:
---------------------------------
Processor  : Intel Core Processor (Skylake, IBRS)
CPU cores  : 2 @ 2711.998 MHz
AES-NI     : ✔ Enabled
VM-x/AMD-V : ✔ Enabled
RAM        : 1.9 GiB
Swap       : 4.0 GiB
Disk       : 191.9 GiB

fio Disk Speed Tests (Mixed R/W 50/50):
---------------------------------
Block Size | 4k            (IOPS) | 64k           (IOPS)
  ------   | ---            ----  | ----           ----
Read       | 182.77 MB/s  (45.6k) | 1.35 GB/s    (21.1k)
Write      | 183.25 MB/s  (45.8k) | 1.35 GB/s    (21.2k)
Total      | 366.02 MB/s  (91.5k) | 2.70 GB/s    (42.3k)
           |                      |                     
Block Size | 512k          (IOPS) | 1m            (IOPS)
  ------   | ---            ----  | ----           ----
Read       | 1.14 GB/s     (2.2k) | 1.38 GB/s     (1.3k)
Write      | 1.21 GB/s     (2.3k) | 1.47 GB/s     (1.4k)
Total      | 2.36 GB/s     (4.6k) | 2.86 GB/s     (2.7k)
 

 

 

 

VPS SSD CACHE ....... rack (L.A)

Wed Apr 14 13:59:03 WIB 2021

Basic System Information:
---------------------------------
Processor  : Intel(R) Xeon(R) CPU E5-2690 0 @ 2.90GHz
CPU cores  : 3 @ 2899.996 MHz
AES-NI     : ✔ Enabled
VM-x/AMD-V : ❌ Disabled
RAM        : 2.3 GiB
Swap       : 2.5 GiB
Disk       : 38.3 GiB

fio Disk Speed Tests (Mixed R/W 50/50):
---------------------------------
Block Size | 4k            (IOPS) | 64k           (IOPS)
  ------   | ---            ----  | ----           ----
Read       | 3.24 MB/s      (810) | 46.30 MB/s     (723)
Write      | 3.26 MB/s      (816) | 46.49 MB/s     (726)
Total      | 6.50 MB/s     (1.6k) | 92.80 MB/s    (1.4k)
           |                      |                     
Block Size | 512k          (IOPS) | 1m            (IOPS)
  ------   | ---            ----  | ----           ----
Read       | 115.94 MB/s    (226) | 121.60 MB/s    (118)
Write      | 122.10 MB/s    (238) | 129.70 MB/s    (126)
Total      | 238.04 MB/s    (464) | 251.30 MB/s    (244)

iperf3 Network Speed Tests (IPv4):
---------------------------------
Provider        | Location (Link)           | Send Speed      | Recv Speed     
                |                           |                 |                
Clouvider       | London, UK (10G)          | 528 Mbits/sec   | 151 Mbits/sec  
Online.net      | Paris, FR (10G)           | 205 Mbits/sec   | busy           
WorldStream     | The Netherlands (10G)     | 483 Mbits/sec   | 95.9 Mbits/sec
Biznet          | Jakarta, Indonesia (1G)   | 502 Mbits/sec   | 81.6 Mbits/sec
Clouvider       | NYC, NY, US (10G)         | 563 Mbits/sec   | 221 Mbits/sec  
Velocity Online | Tallahassee, FL, US (10G) | 614 Mbits/sec   | 234 Mbits/sec  
Clouvider       | Los Angeles, CA, US (10G) | 681 Mbits/sec   | 603 Mbits/sec 

Iveloz Telecom  | Sao Paulo, BR (2G)        | 95.2 Mbits/sec  | 71.1 Mbits/sec


VPS .....SING uson --- paroki (PARAHHHHHHHHHHHHH)

Mon Apr 19 14:35:26 +08 2021                                                                                                          
                                                                                                                                      
Basic System Information:                                                                                                             
---------------------------------                                                                                                     
Processor  : QEMU Virtual CPU version 2.5+                                                                                            
CPU cores  : 2 @ 2397.222 MHz                                                                                                         
AES-NI     : ❌ Disabled                                                                                                              
VM-x/AMD-V : ❌ Disabled                                                                                                              
RAM        : 1.9 GiB                                                                                                                  
Swap       : 1024.0 MiB                                                                                                               
Disk       : 19.6 GiB                                                                                                                 
                                                                                                                                      
fio Disk Speed Tests (Mixed R/W 50/50):
---------------------------------                                                                                                     
Block Size | 4k            (IOPS) | 64k           (IOPS)                                                                              
  ------   | ---            ----  | ----           ----                                                                               
Read       | 3.72 MB/s      (930) | 3.43 MB/s       (53)
Write      | 3.75 MB/s      (939) | 3.65 MB/s       (57)
Total      | 7.47 MB/s     (1.8k) | 7.09 MB/s      (110)
           |                      |                     
Block Size | 512k          (IOPS) | 1m            (IOPS)
  ------   | ---            ----  | ----           ----
Read       | 9.14 MB/s       (17) | 7.00 MB/s        (6)
Write      | 10.11 MB/s      (19) | 7.67 MB/s        (7)
Total      | 19.26 MB/s      (36) | 14.67 MB/s      (13)

iperf3 Network Speed Tests (IPv4):
---------------------------------
Provider        | Location (Link)           | Send Speed      | Recv Speed     
                |                           |                 |                
Clouvider       | London, UK (10G)          | 72.2 Mbits/sec  | 105 Mbits/sec  
Online.net      | Paris, FR (10G)           | 44.7 Mbits/sec  | 83.7 Mbits/sec
WorldStream     | The Netherlands (10G)     | 71.6 Mbits/sec  | 142 Mbits/sec  
Biznet          | Jakarta, Indonesia (1G)   | 373 Mbits/sec   | 213 Mbits/sec  
Clouvider       | NYC, NY, US (10G)         | 122 Mbits/sec   | 204 Mbits/sec  
Velocity Online | Tallahassee, FL, US (10G) | 97.1 Mbits/sec  | 171 Mbits/sec  
Clouvider       | Los Angeles, CA, US (10G) | 131 Mbits/sec   | 198 Mbits/sec  
Iveloz Telecom  | Sao Paulo, BR (2G)        | busy            | busy       

Geekbench 5 Benchmark Test:
---------------------------------
Test            | Value                         
                |                               
Single Core     | 522                           
Multi Core      | 1005                          
Full Test       | https://browser.geekbench.com/v5/cpu/7491446



Thursday, April 8, 2021

hapus openlite speed cache

 Hapus SEMUA CACHE dan REBOOT:

rm /usr/local/lsws/cachedata -rf && reboot now