solving problem Error 404 cwpsrv phpmyadmin - Centos Web Panel
1. login to root account via putty / terminal
2. update yum server
yum -y update
sh /scripts/mysql_phpmyadmin_update
/ip firewall layer7-protocol
add name=IPA regexp="\\.(ipa)"
add name=IPSW regexp="\\.(ipsw)"
add name=APK regexp="^.*get.+\\.apk.*\$"
add comment="PLAY STORE" name="Google Play Store" regexp=\
"^.+.c.android.clients.google.com.*\$"
/ip firewall mangle
add action=mark-connection chain=forward comment=APK connection-mark=!Game \
disabled=no layer7-protocol=APK new-connection-mark=APK packet-mark=\
!Game_pkt passthrough=yes
add action=mark-packet chain=forward connection-mark=APK disabled=no \
new-packet-mark=APK passthrough=no
add action=mark-connection chain=forward comment=IPA connection-mark=!Game \
disabled=no layer7-protocol=IPA new-connection-mark=IPA packet-mark=\
!Game_pkt passthrough=yes
add action=mark-packet chain=forward connection-mark=IPA disabled=no \
new-packet-mark=IPA passthrough=no
add action=mark-connection chain=forward comment=IPSW connection-mark=!Game \
disabled=no layer7-protocol=IPSW new-connection-mark=IPSW packet-mark=\
!Game_pkt passthrough=yes
add action=mark-packet chain=forward connection-mark=IPSW disabled=no \
new-packet-mark=IPSW passthrough=no
add action=mark-connection chain=forward connection-mark=!Game disabled=no \
layer7-protocol="Google Play Store" new-connection-mark="PLAY STORE" \
packet-mark=!Game_pkt passthrough=yes
add action=mark-packet chain=forward connection-mark="PLAY STORE" disabled=no \
new-packet-mark="PLAY STORE" passthrough=no
/queue type
add kind=pcq name=que-down pcq-burst-rate=1M pcq-burst-threshold=256k \
pcq-burst-time=30s pcq-classifier=dst-address pcq-dst-address-mask=32 \
pcq-dst-address6-mask=64 pcq-limit=50 pcq-rate=384k pcq-src-address-mask=\
32 pcq-src-address6-mask=64 pcq-total-limit=2000
/queue tree
add burst-limit=0 burst-threshold=0 burst-time=0s disabled=no limit-at=0 \
max-limit=1M name=ANDROID packet-mark="" parent=V.DOWNLOAD priority=6
add burst-limit=0 burst-threshold=0 burst-time=0s disabled=no limit-at=50k \
max-limit=1M name=APEKA packet-mark=APK parent=ANDROID priority=6 queue=\
que-down
add burst-limit=0 burst-threshold=0 burst-time=0s disabled=no limit-at=186k \
max-limit=1M name=IPESWE packet-mark=IPSW parent=ANDROID priority=8 queue=\
que-down
add burst-limit=0 burst-threshold=0 burst-time=0s disabled=no limit-at=50k \
max-limit=756k name=IPS packet-mark=IPA parent=ANDROID priority=8 queue=\
que-down
add burst-limit=0 burst-threshold=0 burst-time=0s disabled=no limit-at=50k \
max-limit=1M name="PLAY STORE" packet-mark="PLAY STORE" parent=ANDROID \
priority=6 queue=que-down
Blokir Windows Update dengan Mikrotik
/ip firewall raw add action=drop chain=prerouting comment="Blok Windows Update" protocol=tcp tls-host=windowsupdate.microsoft.com add action=drop chain=prerouting comment="Blok Windows Update" protocol=tcp tls-host=download.microsoft.com add action=drop chain=prerouting comment="Blok Windows Update" protocol=tcp tls-host=test.stats.update.microsoft.com add action=drop chain=prerouting comment="Blok Windows Update" protocol=tcp tls-host=ntservicepack.microsoft.com add action=drop chain=prerouting comment="Blok Windows Update" protocol=tcp tls-host=*.download.windowsupdate.com add action=drop chain=prerouting comment="Blok Windows Update" protocol=tcp tls-host=*.update.microsoft.com add action=drop chain=prerouting comment="Blok Windows Update" protocol=tcp tls-host=download.windowsupdate.com add action=drop chain=prerouting comment="Blok Windows Update" protocol=tcp tls-host=*.windowsupdate.microsoft.com
Insert Colom ke nomor A.2
masukkan rumus ini
=ARRAYFORMULA ("ABC" & text (ROW (B1:INDEX (B:B, COUNTA (B:B)-1)), "000"))
dan hasilnya adalah seperti ini:
ABC001
ABC002
ABC003
ABC004
wifi merupakan sebuah kebutuhan yang sangat penting,wifi juga dapat mempengaruhi apakan pengunjung akan kembali lagi atau tidak dari wifi yang anda sediakan,bagaimana jika pengunjung anda mengakses jaringan wifi anda namun mengalami kendala,seperti lambat ataupun susah untuk konek otomasti pengunjung tersebut tidak akan kembali lagi ke tempat anda
Berikut beberapa tips Optimize Wifi network pada mikrotik
Hanya gunakan channel 1,6,11
Jangan gunakan channel auto
Perhatikan peletakan access point
Supported rate A/G 12Mbps,18Mbps,24Mbps,36Mbps,48Mbps,54Mbps
Basic rate A/G 12Mbps,18Mbps
Band 2GHz-G/N
Channel Width 20MHz
Untuk frekuensi 5GHz cukup gunakan 40MHz atau 20MHz
Batasi Tx Power
Gunakanlah SSID yang sama
Pastikan jumlah IP Pool mencukupi untuk jumlah pengunjuna
/24 = 256 ip
/23 = 512 ip
/22 = 1024 ip
Jangan membatasi VPN
Gunakan Bandwith management
Untuk kenyamanan hindari pengunjung harus sering login
Jika tidak membutuhkan hotspot,gunakanlah security pada wireless WPA2-PSK dengan AES
Jika gunakan hotspot besarkan session time out
Setting idle time out ke none
Keep alive time ke none
Set Minimum Singal Strength ke -75
Non aktifkan default authenticate
Non aktifkan default forward
Turn of wps mode
Itulah beberapa tips untuk Optimize Wifi network pada mikrotik
sumber : sharkwifi.com
