Postingan

install mariadb dan remote pakai dbeaver

 panduan install disini: https://mariadb.com/docs/server/server-management/install-and-upgrade-mariadb/installing-mariadb/binary-packages/installing-mariadb-on-macos-using-homebrew kalau DBeaver-nya di MacBook yang sama dengan MariaDB, berarti nggak perlu remote setup sama sekali . Lebih simpel  Kondisi ini sebenarnya bukan “remote” , tapi local connection . Setup paling sederhana (recommended) 1) Pastikan MariaDB jalan brew services start mariadb Cek: mysql -uroot -p Kalau bisa masuk → aman. 2) Setting koneksi di DBeaver Di DBeaver → New Connection → MariaDB Isi seperti ini: Host : 127.0.0.1 (atau localhost ) Port : 3306 Database : (boleh kosong atau isi nama DB) Username : root Password : password root MariaDB Klik Test Connection → harusnya langsung connect. Tidak perlu : buka firewall set bind-address bikin user baru (kecuali mau best practice) (Opsional tapi bagus) Bikin user non-root untuk daily use Kalau mau rapi & aman, bikin user khusus buat DBeaver. Masuk ...

script notifikasi telegram profile radius di mikrotik

  {     :local bot       "xxxxxx:xxxxxxxxxxxxxxxx" ;     :local chat     "-xxxxxxxx" ;     :local uname     $user ;     :local remoteIP $"remote-address" ;     :local caller   $"caller-id" ;     :local called   $"called-id" ;     :local iface     $interface ;     :local waktu    ([/system clock get time] . " " . [/system clock get date] );     :local message  ( "<b>\E2\9C\85 PPPoE CONNECT</b>%0A%0A" . \                       "<b>User</b>: <code>" . $uname . "</code>%0A" . \                       "<b>Caller-ID</b>: <code>" . $caller . "</code>%0A" . \                    ...

static route di linux ubuntu/debian di /etc/network/interfaces

 Berikut ini panduan static route di linux ubuntu/debian,  Debian / Ubuntu lama (pakai /etc/network/interfaces ), bukan netplan 👍 Tinggal tambahkan baris up di konfigurasi eth1 . Edit file: nano /etc/network/interfaces Ubah jadi seperti ini: auto lo iface lo inet loopback auto eth0 iface eth0 inet static address 103.100.100.60/29 gateway 103.100.100.57 auto eth1 iface eth1 inet static address 172.25.255.106/24 up ip route add 172.25.224.0/24 via 172.25.255.1 dev eth1 down ip route del 172.25.224.0/24 via 172.25.255.1 dev eth1 ⚠️ Ganti 172.25.255.1 kalau IP router lokal kamu beda. Apply tanpa reboot (aman) ifdown eth1 && ifup eth1 Atau reboot kalau mau aman total: reboot Verifikasi ip route | grep 172.25.224 Output yang benar: 172.25.224.0/24 via 172.25.255.1 dev eth1