ARTIKEL PEMULA: September 2023

Archive for September 2023

Connect AC Controller to Wis CLoud

ryo 13.28 Add Comment

ryo

1. Pastikan sudah memiliki akun ruijie cloud.

2. Akses ke laman web https://wis.ruijienetworks.com/index/recognise

3. Buat projek baru

Tambah AC Device

4. Penambahan perangkat AC Controler

- Info pelanggan, Next

- Tambah AC Device

Salin Mac id AC controller kemudian beri nama sesuai lokasi, Next

- Proses penyambungan AC Controller ke WIS Cloud

Buka Akses AC Controler menggunakan putty atau web console

masukkan perintah:

#config

(config)#ip name-server 8.8.8.8

(config)#wis enable

(config)#wis server-url http://wispi.ruijienetworks.com

(config)#ac-controller

(config)#wqos fs enable

(config)#end

#write

- Klik Finish.

5. Akses laman web http://wispi.ruijienetworks.com

6. Tunggu beberapa saat hingga projek muncul pada laman http://wispi.ruijienetworks.com

7. Jika sudah muncul, klik projek yang baru dibuat.

8. Proses sinkron data penuh dari AC Controller ke WIS Cloud biasanya 72 jam.

Note: Semakin lama data yang tersinkron, maka akan semakin akurat proses analisa WIS Cloud.

___Sekian, Semoga bermanfaat___

Setting RSSI Ruijie CLI

ryo 12.35 Add Comment

ryo

✅ Setting RSSI

Wireless Controler:

WS6008>enable

WS6008#config

WS6008(config)# ap-config XXX //XXX merupakan nama dari AP yang akan di ubah

WS6008(config-ap)# response-rssi 25 radio 1 //radio 1 ialah 2.4G, 2 ialah 5G

WS6008(config-ap)# assoc-rssi 20 radio 1

WS6008(config-ap)# end

WS6008#write

Cek User yang tersambung

WS6008#show ac-config client

Cek RSSI User yang tersambung

WS6008#show ac-config debug client

AP Indoor

Ruijie#config ter

Ruijie(config)#interface dot11radio 1/0

Ruijie(config-if-Dot11radio 1/0)#response-rssi 20 ----->access Minimum RSSI

Ruijie(config-if-Dot11radio 1/0)#assoc-rssi 28 ---Minimum associated RSSI

Cek RSSI User yang tersambung

Ruijie(config)#show dot a a

Perhitungan RSSI menjadi signal:

Case: Pelanggan dengan signal diatas -70 tidak dapat tersambung ke wifi

Perhitungan:

Respon rssi:

-95 (Maximum RSSI) - (-70) = 25

Catatan:

Respon-rssi：

Ini digunakan untuk memaksa mengontrol jangkauan akses terminal nirkabel.

Jika RSSI pengguna nirkabel selama akses kurang dari nilai ini, maka mereka tidak diperbolehkan mengakses SSID ini.

Asosiasi-rssi：

Ini digunakan untuk memaksa rentang kontrol untuk mempertahankan asosiasi dan membuat pengguna offline ketika RSSI pengguna nirkabel dalam asosiasi kurang dari nilai ini.

Catatan:

A. Untuk respon-rssi, satu AP masih memungkinkan pengguna nirkabel untuk terhubung dengan SSID setelah 2 penolakan.

B. Untuk assoc-rssi, ketika terminal dikaitkan selama 1 menit, jika lebih rendah dari RSSI, maka akan ditendang offline.

Ketika terminal dikaitkan kembali, jika masih di bawah ambang batas,

AP tunggal akan menendang STA lagi setelah 10 menit. Jika terminal terus-menerus berada di bawah ambang batas,

itu akan ditendang setiap 10 menit sekali. Sekarang pengaturan waktu terkait tidak didukung.

Penjelasan:

Rssi:

Rssi menampilkan rasio normal sinyal komunikasi ke noise. Jika rasio sinyal noise terlau tinggi,

tingkat komunikasi akan tinggi, dan kapasitas anti interferensi akan sangat kuat

Normalnya nilai RSSI harus lebih besar dari sama dengan 25 db. Jika kurang dari 15db,

kendala yang mungkin terjadi diantaranya banyak paket loss dan koneksi lambat

Noise floor:

Noise floor menampilkan tingkat interferensi dari pemakaian chanel di area sekitar perangkat dan atau gangguan non-wifi.

Jika noise terlalu tinggi, Mungkin akan terjadi penolakan RSSI, dan menyebabkan tingkat komunikasi menurun

Normalnya nilai noise floor harus lebih kecil dari sama dengan -95 dbm. Jika lebih dari -80 dbm,

kendala yang mungkin terjadi diantaranya banyak paket loss dan nilai RSSI akan lemah.

Chanel usage:

Chanel usage menampilkan persentase seberapa sibuk jaringan nirkabel di area sekitar perangkat.

Normalnya nilai chanel usage harus lebih kecil dari sama dengan 60%. Jika lebih dari 80%,

signal yang diterima tidak stabil, cenderung menurun.

_____Sekian, Semoga bermanfaat_____

Manual book Mikrotik CLI

ryo 00.11 Add Comment

ryo

Daftar Isi:

✅ Interface ✅ PPP / VPN ✅ Queue

✅ Wireless ✅ IP ✅ Tools

✅ Bridge ✅ System

_____Kategori Interface_____

✅ Interface:

Ubah nama

interface set 2 name=ether2-lokal

Tambah catatan khusus

interface set 2 comment="sw lokal user:admin pass:admin321"

Disable / enable interface

interface set 2 disabled=yes

interface set 2 disabled=no

✅ Interface list:

Buat list baru

interface list add name=lokal

Pengkategori interface

interface list member add list=lokal interface=ether3

interface list member add list=lokal interface=ether4

✅ Ethernet:

Ubah rate interface

interface ethernet set 2 speed=100Mbps

Ubah checklist auto negosiasi

interface ethernet set 2 auto-negotiation=no

✅ EOIP:

Tambah EOIP

interface eoip add name="to-server18" remote-address="172.30.20.17" tunnel-id=18 disabled=no

✅ Vlan:

Tambah Vlan

interface vlan add name=wifi-umum20 vlan-id=20 interface=ether3

_____Kategori Wireless_____

✅ Wireless sebagai AP

interface wireless set 0 disabled=no mode=ap-bridge channel-width=20mhz band=5ghz-a/n frequency-mode=superchannel country=no_country_set frequency=5750 ssid="AP-tes" wireless-protocol=any

✅ Wireless sebagai ST

interface wireless set 0 mode=station-bridge channel-width=20mhz band=5ghz-a/n ssid="AP-tes" scan-list=5750,5760,5770,5780,5790,5800 frequency-mode=superchannel country=no_country_set wireless-protocol=any disabled=no

✅ Virtual AP

interface wireless add master-interface=wlan1 ssid="AP-umum2" mode=ap-bridge disabled=no

✅ Access list Jika mode radio AP

interface wireless access-list add mac-address=74:4D:28:XX:XX:XX interface=wlan1 signal-range=-75..120 authentication=yes forwarding=yes disabled=no

✅ Connect list Jika mode radio ST

interface wireless connect-list add interface=wlan1 mac-address=74:3A:18:XX:XX:XX signal-range=-75..120 disabled=no

_____Kategori Bridge_____

✅ Bridge

interface bridge add name=Bridge-lokal protocol-mode=rstp disabled=no

✅ Bridge Port

interface bridge port add bridge=bridge-lokal interface=ether3 disabled=no

_____Kategori PPP / VPN_____

✅ PPTP:

Server enable

interface pptp-server server set enabled=yes

Secret
ppp secret add name=tes password=tes321 service=pptp local-address=192.168.10.1 remote-address=192.168.10.20 disabled=no

✅ L2TP:

Server enable

interface l2tp-server server set enabled=yes use-ipsec=yes ipsec-secret="123Tamu"

Secret
ppp secret add name=tes password=tes321 service=l2tp local-address=192.168.10.1 remote-address=192.168.10.31 disabled=no

✅ SSTP:

Server enable

interface sstp-server server set enabled=yes

Secret
ppp secret add name=tes password=tes321 service=sstp local-address=192.168.10.1 remote-address=192.168.10.41 disabled=no

✅ OVPN:

Server enable

interface ovpn-server server set enabled=yes port=10100

_____Kategori IP_____

✅ IP Address:

ip address add address=192.168.10.1/24 interface=ether1

✅ IP DHCP-Client:

ip dhcp-client add interface=ether1 disabled=no default-route-distance=2 add-default-route=yes use-peer-dns=yes use-peer-ntp=yes comment="WAN"

✅ IP DHCP-Relay:

ip dhcp-relay add name="Relay-1" interface=ether3 dhcp-server=192.168.10.1 local-address=192.16.1.1

✅ IP DHCP-Server:

ip dhcp-server setup

Select interface to run DHCP server on

dhcp server interface: wlan1

Select network for DHCP addresses

dhcp address space: 192.168.10.0/24

Select gateway for given network

gateway for dhcp network: 192.168.10.1

If this is remote network, enter address of DHCP relay

There is no such IP network on selected interface

dhcp relay: 192.168.10.1

Select pool of ip addresses given out by DHCP server

addresses to give out: 192.168.10.2-192.168.10.254

Select DNS servers

dns servers: 8.8.8.8

Select lease time

lease time: 10m

✅ IP DNS:

ip dns set servers=8.8.8.8,1.1.1.1

atau

ip dns set servers=8.8.8.8,1.1.1.1 allow-remote-requests=yes

ip dns set servers=8.8.8.8,1.1.1.1 allow-remote-requests=no

✅ IP firewall:

Filter:

Blokir:

ip firewall filter add chain=forward protocol=icmp dst-address=172.20.1.12 src-address=!192.168.10.0/29 action=drop

NAT:

Internet:

ip firewall nat add chain=srcnat out-interface=ether1 action=masquerade

atau

ip firewall nat add chain=srcnat out-interface=ether1 action=src-nat to-addresses=172.20.1.2

atau spesifik ip

ip firewall nat add chain=srcnat src-address=192.168.10.0/29 out-interface=ether1 action=masquerade

Forwarding:

ip firewall nat add chain=dstnat dst-address=172.20.1.2 protocol=tcp dst-port=8087 action=dst-nat to-addresses=192.168.10.10 port=80

Mangle:

ip firewall mangle add chain=prerouting dst-address-list="sosmed_IP" action=mark-connection new-connection-mark="koneksi_sosmed" passthrough=yes

ip firewall mangle add chain=prerouting connection-mark="koneksi_sosmed" action=mark-packet new-packet-mark="paket-sosmed" passthrough=no

ip firewall mangle add chain=prerouting dst-address-list="IP-server-pusat" action=mark-routing new-routing-mark="route-ispA" passthrough=no

RAW:

/ip firewall raw

add action=add-dst-to-address-list address-list=Instagram address-list-timeout=none-dynamic chain=prerouting comment=Block_IG content=.cdninstagram.com protocol=tcp tls-host=*.cdninstagram.com

add action=add-dst-to-address-list address-list=Instagram address-list-timeout=1d chain=prerouting comment=Block_IG content=.instagram.com protocol=tcp time=0s-1d,sun,mon,tue,wed,thu,fri,sat tls-host=*.instagram.com

Address List:

ip firewall address-list add list="IP_server-pusat" address=172.200.10.1

Layer7 Protocol:

/ip firewall layer7-protocol

✅ IP Hotspot:

User Profile

ip hotspot user profile add name="guru-profile" shared-users=20 rate-limit=10M/10M mac-cookie-timeout="7d 00:00:00"

User

ip hotspot user add name=userA password=userA123 profile="guru-profile"

Hotspot Profile

ip hotspot profile add name=hotspot-umum hotspot-address=192.168.10.1 dns-name=ujicoba.ac.id html-directory=hotspot login-by=cookie,http-chap,http-pap,https,trial trial-uptime-limit="00:10:00" trial-uptime-reset="1d 00:00:00" trial-user-profile="user-trial"

Hotspot server

ip hotspot add name="hotspot-umum" interface="wlan1" address-pool="pool-umum" profile="hotspot-umum"

✅ IP Neighbor:

Disable

ip neighbor discovery set 0,1,2 discover=no

Enable

ip neighbor discovery set 0,1,2 discover=yes

✅ IP Pool:

ip pool add name="pool-umum" ranges="192.168.10.2-192.168.10.254"

✅ IP Route:

Internet

ip route add gateway=172.20.2.1

atau

ip route add dst-address=0.0.0.0/0 gateway=172.20.2.1

Internet multi UPlink

ip route add dst-address=0.0.0.0/0 gateway=172.20.2.1 distance=1 check-gateway=ping

ip route add dst-address=0.0.0.0/0 gateway=172.30.1.1 distance=2

Statik route

ip route add dst-address=192.168.200.0/24 gateway=192.168.10.24

jika sama, semakin kecil rentang ip tujuan maka akan di prioritaskan

ip route add dst-address=192.168.200.0/29 gateway=192.168.10.24

Jika antar ip private tidak bisa komunikasi karena firewall

ip route rule add dst-address=192.168.10.0/24 table=main

ip route rule add dst-address=192.168.20.0/24 table=main

ip route rule add dst-address=192.168.30.0/24 table=main

✅ IP smb Sharing folder:

Enable

ip smb set enabled=yes interfaces=wlan1 allow-guests=no

Users

ip smb users add name=guru password=guru321 read-only=no disabled=no

Shares

ip smb shares add name=guru directory=flash disabled=no

✅ IP SNMP:

Enable

snmp set enabled=yes contact=guru321@guru.ac.id location=indonesia-jawa-timur trap-community=server trap-version=1

Community

snmp community add name=server addresses=172.30.20.17

✅ IP Services:

Cek list

ip service print

Disable service

ip service set 0,1,2,3,4,5,7,8 disabled=yes

Ubah akses

ip service set 6 port=3284 address=192.168.10.0/24

✅ Trafik flow:

Enable

ip traffic-flow set enabled=yes interfaces=wlan1 cache-entries=128k

Add Target

ip traffic-flow target add dst-address=172.20.30.17 port=2057 version=9

✅ IP Proxy:

Enable

ip proxy set enabled=yes

Edit port

ip proxy set port=8050

_____Kategori System_____

✅ Set Clock:

system clock set time="12:14:00" date="sep/15/2023" time-zone-autodetect=yes

✅ Cek power dan suhu sistem:

system health print

✅ Ubah nama perangkat:

system identity set name="Router-utama"

✅ Cek update OS (Wajib tersambung internet):

system package update check-for-updates

✅ Reboot:

system reboot

✅ Reset:

system reset-configuration no-defaults=yes

✅ Cek resource (uptime, sisa penyimpanan):

system resource print

✅ Cek versi firmware dan OS:

system routerboard print

✅ Setting ntp client:

system ntp client set enabled=yes primary-ntp=172.30.20.1 secondary-ntp=172.30.20.18

✅ Script:

Contoh script disabled limit blokir koneksi sosmed

system script add name=limit-sosmed-On source="/ip firewall filter set 0,1,2,3,4 disabled=no"

Contoh script enabled limit blokir koneksi sosmed

system script add name=limit-sosmed-Off source="/ip firewall filter set 0,1,2,3,4 disabled=yes"

✅ Schedule:

Contoh schedule disabled limit blokir koneksi sosmed

system scheduler add name=jadwal-aktif-sosmed start-date=sep/15/2023 start-time=17:00:00 interval="1d 00:00:00" on-event="limit-sosmed-Off"

Contoh script enabled limit blokir koneksi sosmed

system scheduler add name=jadwal-pasif-sosmed start-date=sep/16/2023 start-time=08:00:00 interval="1d 00:00:00" on-event="limit-sosmed-On"

✅ Modify User:

Add user

user add name=guru password=guru123 group=full address=192.168.10.10,172.30.20.12 disabled=no

Atau

user add name=guru password=guru123 group=full disabled=no

Remove

user remove guru

Modify

user set guru disabled=yes

user set 0,1,2,3 disabled=yes

user set guru address=172.20.30.12

user set guru group=write

✅ Backup konfigurasi .rsc (hasil backup bisa di pahami human):

export file="backup15923"

✅ Backup konfigurasi .backup (hasil backup hanya bisa di pahami sistem):

system backup save dont-encrypt=yes name="backup15923"

_____Kategori Queue_____

✅ Simple Queue:

Simple Queue standart

queue simple add name="lokal" target=192.168.10.0/24 max-limit=5M/5M disabled=no

Simple Queue berdasarkan waktu dan hari

queue simple add name="lokal" target=192.168.10.0/24 max-limit=5M/5M time=8h-17h,mon,tue,wed,thu,fri disabled=no

Simple Queue Burst time

queue simple add name=PCku target=192.168.10.23/32 max-limit=5M/5M burst-limit=7M/7M burst-threshold=1100K/1100K burst-time=32/32

Rumus: burst-limit / burst-time = burst-threshold

7 / 32 = 219 Kbps, 14/32 = 438 Kbps, 21/32 = 656 Kbps, 28/32 = 875 Kbps, 35/32 = 1094 Kbps

Lama durasi burst: burst-threshold = burst-limit x ?

1094 = ((7 x 5) / 32 = 35 / 32)

Simple Queue Token Bucket

queue simple add name=PCku target=192.168.10.23/32 max-limit=5M/5M bucket-size=8/8 parent=lokal

Rumus: max-limit x bucket-size = kuota yang di berikan sementara

5 x 8 = 40 Mbps (maksimal kuota yang di berikan sementara)

Note: Jika spesifikasi router midle>low, bisa menerapkan simple queue token bucket.

✅ Queue Tree:

Mangle

Rule paket download user

ip firewall mangle add comment="Download" chain=forward dst-address-list="IP-lokal" action=mark-packet new-packet-mark="Download-user" passthrough=no disabled=no

Rule paket upload user

ip firewall mangle add comment="Upload" chain=forward src-address-list="IP-lokal" action=mark-packet new-packet-mark="Upload-user" passthrough=no disabled=no

Simple Queue, Queue Type

PCQ Upload

queue type add name="PCQ-upload" kind=pcq pcq-classifier=src-address,src-port

PCQ Download

queue type add name="PCQ-download" kind=pcq pcq-classifier=dst-address,dst-port

Rule Queue Tree

Download

Parent Download

queue tree add name="Download" parent="Bridge-lokal" max-limit=10M

Child Download

queue tree add name="user-download" parent="Download" packet-mark="Download-user" queue=PCQ-download limit-at=1M max-limit=10M

Upload

Parent Upload

queue tree add name="Upload" parent="Ether1-WAN" max-limit=10M

Child Upload

queue tree add name="user-upload" parent="Upload" packet-mark="Upload-user" queue=PCQ-upload limit-at=1M max-limit=10M

_____Kategori Tools_____

✅ Bandwidth test server:

Enable

tool bandwidth-server set enabled=yes authenticate=yes max-sessions=10

✅ Bandwidth test:

Test upload - pengetesan dari Pemancar

tool bandwidth-test address=192.168.10.17 protocol=tcp direction=receive user=admin password=admin123 duration=10s

Test download - pengetesan dari Pemancar

tool bandwidth-test address=192.168.10.17 protocol=tcp direction=send user=admin password=admin123 duration=10s

Test upload dan download - pengetesan dari Pemancar

tool bandwidth-test address=192.168.10.17 protocol=tcp direction=both user=admin password=admin123 duration=10s

✅ IP-Scan:

tool ip-scan interface="Bridge-lokal" duration=60s

tool ip-scan interface="Bridge-lokal" address-range="192.168.10.0/24" duration=60s

✅ Mac server:

Mac telnet server

tool mac-server set allowed-interface-list=all

Mac winbox server

tool mac-server mac-winbox set allowed-interface-list=all

Mac ping server

tool mac-server ping set enabled=yes

✅ Netwatch:

Contoh rule disabled / enabled tabel routing berdasarkan kondisi

/tool netwatch

add down-script="/ip route disable [/ip route find comment=remote-main];/ip route enable [/ip route find comment=remote-backup];:log info \"remote main down\";" host=192.168.10.1 interval=20s timeout=4s up-script=":delay 19;/ip route disable [/ip route find comment=remote-backup]; /ip route enable [/ip route find comment=remote-main];:log info \"remote main up\";"

✅ Ping:

ping 172.30.20.17 count=100 size=1500

✅ Profile:

tool profile duration=60s

✅ Romon:

tool romon set enabled=yes

Atau

tool romon set enabled=yes id=10 secrets=admin123

✅ Service Telnet:

system telnet address=172.30.20.17 port=238

system telnet address=172.30.20.17

✅ Service ssh:

system ssh address=172.30.20.17 user=admin

system ssh address=172.30.20.17 port=228 user=admin

✅ Service MAC-Telnet:

tool mac-telnet C4:AD:3X:XX:XX:XX

✅ Torch:

tool torch interface="Bridge-lokal" ip-protocol=any port=any src-address=0.0.0.0/0 dst-address=0.0.0.0/0 duration=60s

Note: entry-timeout bisa di besarkan supaya list yang terdaftar tidak cepat hilang

✅ Traceroute:

tool traceroute address=172.30.20.17 use-dns=yes duration=60s

Motto Hari ini

ryo 23.21 Add Comment

ryo

1. Berani ambil risiko, bermimpi besar, dan berharap besar.

2. Dengan pendidikan kamu bisa mengubah dunia.

3. Hiduplah seakan kamu mati besok, belajarlah seakan kamu hidup selamanya.

4. Tindakan adalah kunci menuju kesuksesan.

5. Fokus pada tujuan, bukan hambatan.

6. Ilmu adalah kehidupan bagi pikiran.

7. Jika mencari satu orang yang bisa mengubah hidupmu, lihatlah di cermin.

8. Kesuksesan yang besar dimulai dari langkah yang kecil.

9. Jika orang lain bisa maka aku juga harus bisa.

10. Jangan hanya menunggu, tapi ciptakan waktumu sendiri.

11. Tidak ada yang sia-sia dalam belajar karena ilmu akan bermanfaat pada waktunya.

12. Kita bisa karena terbiasa.

13. Hidup hanya sebentar, jangan habiskan waktumu hanya untuk berkeluh kesah.

14. Selesaikan apa yang sudah kamu mulai.

15. Sedikit bicara, banyak bertindak.

16. Hidup adalah sebuah perjalanan, bukan pertandingan

17. Gagal yang sebenarnya adalah ketika kamu berhenti untuk mencoba.

18. Bermalas-malasan hanya akan menghancurkan masa depanmu.

19. Jangan takut berjalan lambat, takutlah jika hanya berdiri diam.

20. Jangan berhenti ketika lelah. Berhentilah ketika selesai.

21. Tak pernah ada kata terlambat untuk belajar.

22. Belajar dari kesalahan, berkembang menjadi lebih baik.

23. Jangan pernah menunda pekerjaanmu sampai besok, sementara kau bisa mengerjakannya hari ini.

24. Kesempatan tidak muncul secara kebetulan. Kau harus menciptakannya.

25. Teruslah mencari ilmu, jangan puas dengan pengetahuan terbatas.

26. Kunci keberhasilan yang sebenarnya adalah konsistensi.

27. Waktumu terbatas, jangan habiskan untuk hidup orang lain.

28. Satu-satunya cara untuk melakukan pekerjaan yang hebat adalah dengan mencintai apa yang kamu lakukan.

29. Jangan bergantung pada siapa pun, bekerjalah lebih keras.

1. Learning is never done without errors and defeat.

2. What you learn is yours forever.

3. Teachers can open the door, but you must enter it yourself.

4. Learn from yesterday, live for today, hope for tomorrow.

5. Today a reader, tomorrow a leader.

6. Always be yourself and never be anyone else even if they look better than you.

7. To get a success, your courage must be greater than your fear.

8. Think big and act now!

9. Procrastination is the thief of time.

10. Even the greatest were beginners. Don't be afraid to take that first step.

11. Success is not a final and failure is not an initial.

12. Success is always accompanied with failure.

13. Think big, be consistent, and success will come naturally.

14. Hard work beats talent when talent doesn't work hard.

15. A winner is just a loser who tried one more time.

16. If opportunity doesn't knock, build a door.

17. You are braver than you believe, stronger than you seem, and smarter than you think.

18. Fall seven times, stand up eight.

19. Follow your passion. It will lead you to your purpose.

20. The sky is not the limit. It is only the beginning.

21. Every accomplishment starts with the decision to try.

22. All progress takes place outside the comfort zone.

23. The way to get started is to quit talking and begin doing.

24. Education is the most powerful weapon, which you can use to change the world.

25. It always seems impossible until it's done.

26. Skill is only developed by hours and hours of work.

27. Just one small positive thought in the morning can change your whole day.

28. Live as if you were to die tomorrow. Learn as if you were to live forever.

29. However difficult life may seem, there is always something you can do and succeed at.

30. Action is the foundational key to all success.

Adopt AP ruijie ke AC controler

ryo 17.53 Add Comment

ryo

1. Pastikan AP ruijie dapat tersambung ke jaringan lokal dan AC Controler.

2. Pastikan AP ruijie dalam mode Fit AP

3. Login ke AP ruijie menggunakan telnet

FAT AP:

user-pass: admin

no enable password

FIT AP:

user-pass: ruijie

enable password: apdebug

4. Masuk mode config "configure terminal"

5. Masuk menu cwmp "cwmp"

Cek status saat ini "show this"

6. Salin kode server url cwmp dari AC Controler

Lokasi: "Maintenance> system > CWMP/MACC > Advanced setting > server URL"

7. Paste pada remote telnet AP ruijie ketikkan

"acs url http://cwmpsvr-as.ruijienetworks.com/service/acs/G1NXXXXXXXXX" kemudian enter.

Jika belum Online lakukan perintah berikut:

Kembali ke menu config, ketikkan "acip ipv4 192.168.10.12" (ip AC Controler)

8. Keluar mode config "end"

9. Simpan perubahan "write memory"

10. Tunggu sampai AP ruijie terdeteksi Online dari AC Controler.

Manual script Mikrotik

ryo 17.42 Add Comment

ryo

1. Script Mikrotik add queue otomatis dari DHCP-Server:

:local queueName "Client- $leaseActMAC";:if ($leaseBound = "1") do={/queue simple add name=$queueName target=($leaseActIP . "/32") limit-at=1024k/1024k max-limit=5M/5M parent="none" comment=[/ip dhcp-server lease get [find where active-mac-address=$leaseActMAC && active-address=$leaseActIP] host-name];log info [/ip dhcp lease get [find where active-mac-address="$leaseActMAC"] host-name;]} else={/queue simple remove $queueName}

2. Script backup konfigurasi otomatis ke server ftp:

/system script

add comment=auto-backup-config-intinet dont-require-permissions=no name=Eko owner=indomie policy=ftp,reboot,read,write,policy,test,password,sniff,sensitive source="/system\

\_backup save name=(\"BACKUP\" . \"-\" . [/system identity get name] . \"-\" . \\\r\

\n[:pick [/system clock get date] 4 6] . [:pick [/system clock get date] 0 3] . [:pick [/system clock get date] 7 11]);\r\

\n/export file=(\"BACKUP\" . \"-\" . [/system identity get name] . \"-\" . \\\r\

\n[:pick [/system clock get date] 4 6] . [:pick [/system clock get date] 0 3] . [:pick [/system clock get date] 7 11]);\r\

\n:delay 10; \r\

\n:global backupname (\"BACKUP\" . \"-\" . [/system identity get name] . \"-\" . \\\r\

\n[:pick [/system clock get date] 4 6] . [:pick [/system clock get date] 0 3] . [:pick [/system clock get date] 7 11] . \".backup\");\r\

\n:global backuprsc (\"BACKUP\" . \"-\" . [/system identity get name] . \"-\" . \\\r\

\n[:pick [/system clock get date] 4 6] . [:pick [/system clock get date] 0 3] . [:pick [/system clock get date] 7 11] . \".rsc\");\r\

\n/tool fetch address=192.168.10.1 port=21 mode=ftp user=tes password=tes src-path=\$backupname dst-path=\"/home/tes/saya/\$backupname\" upload=yes\r\

\n/tool fetch address=192.168.10.1 port=21 mode=ftp user=tes password=tes src-path=\$backupname dst-path=\"/home/tes/saya/\$backuprsc\" upload=yes\r\

\n:delay 20; \r\

\n/file rem \$backupname \r\

\n/file rem \$backuprsc"

/system scheduler

add comment=auto-backup-config-ruter- interval=4w2d name=schedule1 on-event=tes policy=ftp,reboot,read,write,policy,test,password,sniff,sensitive start-date=may/01/2023 start-time=06:45:00

3. Buat limit queue banyak dengan cepat

:for x from=2 to=254 do={/queue simple add name="client-$x" target="192.168.10.$x" max-limit=1M/1M }

4. Otomatis fitur netwatch

/tool netwatch

add down-script="/interface ovpn-client set profile=default [/interface ovpn-client find comment=main];/interface ovpn-client set profile=profile1 [/interface ovpn-client find comment=remote];:log info \"main-link Down\";" host=192.168.8.1 interval=20s timeout=10s up-script=":delay 19;/interface ovpn-client set profile=default [/interface ovpn-client find comment=remote];/interface ovpn-client set profile=profile1 [/interface ovpn-client find comment=main];:log info \"main-link UP\";"

5. Blok sosmed di Firewall

/ip firewall layer7-protocol

/ip firewall raw

add action=add-dst-to-address-list address-list=blokir-youtube address-list-timeout=1d chain=prerouting comment=YOUTUBE content=.youtube.com dst-address-list=!allow \

protocol=tcp time=0s-1d,sun,mon,tue,wed,thu,fri,sat tls-host=*.youtube.com

add action=add-dst-to-address-list address-list=blokir-youtube address-list-timeout=1d chain=prerouting comment="GOOGLE VIDEO" content=.googlevideo.com dst-address-list=\

!allow protocol=tcp time=0s-1d,sun,mon,tue,wed,thu,fri,sat tls-host=*.googlevideo.com

add action=add-dst-to-address-list address-list=blokir-youtube address-list-timeout=1d chain=prerouting comment=INSTAGRAM content=.instagram.com dst-address-list=!allow \

protocol=tcp time=0s-1d,sun,mon,tue,wed,thu,fri,sat tls-host=*.instagram.com

add action=add-dst-to-address-list address-list=blokir-youtube address-list-timeout=1d chain=prerouting comment=FACEBOOK content=.facebook. dst-address-list=!allow \

protocol=tcp time=0s-1d,sun,mon,tue,wed,thu,fri,sat

add action=add-dst-to-address-list address-list=blokir-youtube address-list-timeout=1d chain=prerouting comment=TWITTER content=.twitter. dst-address-list=!allow \

protocol=tcp time=0s-1d,sun,mon,tue,wed,thu,fri,sat tls-host=*.twitter.com

add action=add-dst-to-address-list address-list=blokir-tiktok address-list-timeout=1d chain=prerouting comment=TIKTOK content=tiktok dst-address-list=!allow protocol=tcp \

time=0s-1d,sun,mon,tue,wed,thu,fri,sat

add action=add-dst-to-address-list address-list=blokir-tiktok address-list-timeout=1w chain=prerouting comment=TIKTOK content=.musical.ly protocol=tcp time=\

0s-1d,sun,mon,tue,wed,thu,fri,sat

add action=add-dst-to-address-list address-list=blokir-tiktok address-list-timeout=1d chain=prerouting comment=TIKTOK dst-address-list=!allow protocol=tcp time=\

0s-1d,sun,mon,tue,wed,thu,fri,sat tls-host=*.tiktokcdn.com

/ip firewall filter

add action=drop chain=forward comment=Youtube dst-address-list=blokir-youtube src-address-list=!White-List time=8h-16h,mon,tue,wed,thu,fri

add action=drop chain=forward comment=Sosmed layer7-protocol=all-sosmed src-address-list=!White-List time=8h-16h,mon,tue,wed,thu,fri

add action=drop chain=forward comment=Titktok dst-address-list=blokir-tiktok src-address-list=!White-List time=8h-16h,mon,tue,wed,thu,fri

add action=drop chain=forward comment=Browsec dst-address-list="IP Browsec" src-address-list=!White-List time=8h-16h,mon,tue,wed,thu,fri

Manual Book Excel

ryo 17.25 Add Comment

ryo

Daftar Isi:

✅ IF ✅ Left, Mid, Right ✅ Penjumlahan

✅ Vlookup Hlookup ✅ Count ✅ Lainnya

✅ Concatenate ✅ Kapital otomatis

1. IF

a. Hasil 2

=IF(C3>0;"benar";"salah")

b. Hasil beberapa kemungkinan

=IFS(C2=8;"benar";C2=10;"benar";C2=12;"benar")

c. supaya rumus tidak muncul eror jika kolom kriteria belum terisi

=IFERROR(VLOOKUP(C2;data_barang;3;FALSE);"Data_tidak_ditemukan")

d. seleksi nilai ganda

=J5&COUNTIF($J$5:J5;J5)

e. Hasil dari beberapa kemungkinan

=IFERROR(IFS(N4="Online";CONCATENATE(D4;" ";G4);N4="offline";"");"")

f. menjumlah berdasarkan kriteria tertentu

=IFERROR(COUNTIF(Acuan_data;X4);"")

2. Vlookup Hlookup

a. kriteria berdasarkan 2 kolom

=VLOOKUP(E5;data_barang;IF(E6="barang1";2;IF(E6="barang2";3)))

b. vlookup standart

=VLOOKUP(E5;data_barang;3;FALSE)

3. Concatenate

a. menggabungkan nilai di beberapa kolom

=CONCATENATE(E11;" dan ";F11)

b. menggabungkan nilai di beberapa kolom

=CONCATENATE($D4;" ";$X$3)

4. Left, Mid, Right

a. ambil 3 huruf paling kiri dari sebuah nilai dalam sel

=LEFT(G16;3)

b. ambil 3 huruf dari huruf ke 5 pada sebuah sel

=MID(G16;5;3)

c. ambil 3 huruf paling kanan dari sebuah nilai dalam sel

=RIGHT(G16;3)

5. Count

a. Menghitung banyak sel dengan nilai angka

=COUNT(M13:M19)

b. Menghitung banyak sel dengan nilai angka atau huruf

=COUNTA(M13:M19)

c. Menghitung banyak sel dengan nilai "A"

=COUNTIF(N13:N19;"Nilai A")

d. Menghitung banyak sel tanpa nilai

=COUNTBLANK(N13:N21)

e. Menghutung banyak sel dengan kriteria sama di beberapa kolom

=COUNTIFS(N26:N33;"10";O26:O33;"20")

6. Kapital otomatis

a. Menjadikan huruf kapital semua

=UPPER(H30)

b. Menjadikan huruf awal setiap kata besar

=PROPER(H30)

c. Menjadikan huruf kecil semua

=LOWER(H30)

7. Penjumlahan

a. Menjumlah nilai sel pada rentang tertentu

=SUM(H36:H39)

b. Mencari rata2 nilai sel pada rentang tertentu

=AVERAGE(H36:H39)

c. Mencari nilai terendah sel pada rentang tertentu

=MIN(H36:H39)

d. Mencari nilai tertinggi sel pada rentang tertentu

=MAX(H36:H39)

8. Lainnya

a. Mengubah bagian nilai dalam sel

=SUBSTITUTE(H30;H29;H31)

Password default AP ruijie

ryo 11.24 Add Comment

ryo

Fat ap :

default web magagement username/password: admin/admin

default console password: admin

default telnet password: admin

no enable password

Fit ap:

default web magagement username/password: admin/admin

default console password: ruijie

default telnet password: ruijie

default enable password: apdebug

ARTIKEL PEMULA Fokus pada tujuan, bukan hambatan

EPON Manual Book CLI

Manual Book Ruijie Cloud

Connect AC Controller to Wis CLoud

Setting RSSI Ruijie CLI

Manual book Mikrotik CLI

Motto Hari ini

Adopt AP ruijie ke AC controler

Manual script Mikrotik

Manual Book Excel

Password default AP ruijie