Dari Milis Tetangga cara seting Mikrotik Buat game online,

SETTING MIKROTIK UNTUK GAME ONLINE CAMPUR BROWSING

Pada tutor kali ini saya coba uraikan settingan mikrotik untuk game online dicampur dengan kepentingan browsing (ngenet) agar berjalan serasi dan seimbang.
Note:

• Script di bawah hanya berjalan pada mikrotik versi 3.30 ke atas.
• Bandwidth yang diimplementasikan 1Mbps/256Kbps (SPEEDY)

Langsung ke TKP..!!!

Code:

/interface
set 0 name=speedy ----------->(public)
set 1 name=lan ----------------> (local)


/ip address
add address=192.168.0.200/24 interface=speedy
add address=192.168.1.1/24 interface=lan


/ip route
add gateway=192.168.0.1 -------->(alamat modem ADSL)


/ip dns
set primary-dns=222.124.204.34
set secondary-dns=202.134.0.155
set allow-remote-requests=yes


/ip fi nat
add chain=srcnat action=masquerade out-interface=speedy


INI ROUTING UNTUK GAME ONLINE:
/ip firewall mangle \
add action=mark-connection chain=prerouting \
comment="GAME ONLINE" dst-port=\
"1818,2001,3010,4300,5105,5121,5126,5171,5340-5352,6000-6001,6000-6152,7777" \
new-connection-mark="zar-goc" passthrough=yes protocol=tcp

/ip firewall mangle \
add action=mark-connection chain=prerouting \
disabled=no dst-port="7341-7350,7451,8085,9600,9601-9602,9300,9400,9700,93\
76-9377,10001-10011,40000" \
new-connection-mark="zar-goc" passthrough=yes protocol=tcp

/ip firewall mangle \
add action=mark-connection chain=prerouting \
dst-port="10009,13008,16666,28012,11011-11041,10402,11031,12011,12110,13413,15000-15002,15001,15002" \
new-connection-mark="zar-goc" \
passthrough=yes protocol=tcp

/ip firewall mangle \
add action=mark-connection chain=prerouting \
disabled=no dst-port="16402-16502,18901-18909,19000,19101,22100,27780,29000,29200,39100,39110,39220,39190,49100" \
new-connection-mark="zar-goc" passthrough=yes protocol=tcp

/ip firewall mangle \
add action=mark-connection chain=prerouting \
dst-port=14009-14010 new-connection-mark="zar-goc" \
passthrough=yes protocol=tcp

/ip firewall mangle \
add action=mark-connection chain=prerouting \
dst-port="1293,1479,6100-6152,7777-7977,9401,9600-9602,12020-12080,30000,40000-40010" \
new-connection-mark="zar-goc" passthrough=yes protocol=udp

/ip firewall mangle \
add action=mark-connection chain=prerouting \
dst-port=42051-42052,11100-11125,11440-11460 \
new-connection-mark="zar-goc" passthrough=yes protocol=udp

/ip firewall mangle \
add action=mark-connection chain=prerouting \
dst-port=14009-14010 new-connection-mark="zar-goc" \
passthrough=yes protocol=udp

GAME DIBUAT PREROUTING AGAR TIDAK BERLIKU DI TUBUH ROUTER
/ip firewall mangle \
add action=mark-packet chain=prerouting \
connection-mark="zar-goc"  \
new-packet-mark="zar-gopd" passthrough=no

INI ROUTING UNTUK GAME FACEBOOK
/ip firewall mangle \
add action=mark-connection chain=prerouting \
comment="GAME FACEBOOK" dst-port=843,9339 \
new-connection-mark="zar-gfc" passthrough=yes \
protocol=tcp

/ip firewall mangle \
add action=mark-packet chain=forward \
connection-mark="zar-gfc" disabled=no \
dst-address=192.168.1.0/24 new-packet-mark="zar-gfpd" \
passthrough=no

/ip firewall mangle \
add action=mark-packet chain=forward \
connection-mark="zar-gfc" new-packet-mark="zar-gfpu"\
passthrough=no src-address=192.168.1.0/24

INI PCQ UNTUK SPEED BAGI RATA
/queue type \
add kind=pcq name=DOWN \
pcq-classifier=dst-address,dst-port

/queue type \
add kind=pcq name=UP \
pcq-classifier=src-address,src-port

INI QUEUE UNTUK GAME ONLINE
/queue tree \
add name="2.GAME DOWN" \
parent=global-out priority=2

/queue tree \
add name="3.GAME UPLOAD" \
parent=speedy priority=2

/queue tree \
add name="1.GAME ONLINE DOWN" \
packet-mark="zar-gopd" \
parent="2.GAME DOWN" priority=2 queue=DOWN

/queue tree \
add max-limit=256000 \
name="2.GAME FACEBOOK DOWN" \
packet-mark="zar-gfpd" \
parent="2.GAME DOWN" priority=3 queue=DOWN

/queue tree \
add name="1.GAME ONLINE UPLOAD" \
packet-mark="zar-gopd" \
parent="3.GAME UPLOAD" priority=2 queue=UP

/queue tree \
add limit-at=0 max-limit=128000 \
name="2.GAME FACEBOOK UPLOAD" \
packet-mark="zar-gfpu" \
parent="3.GAME UPLOAD" priority=3 queue=UP

INI UNTUK LIMIT FILE EXTENSI, SEPERTI .EXE .RAR .YOUTUBE, DLL

/ip firewall layer7-protocol

add name="YOUTUBE DOWNLOAD" \

regexp="http/(0\\.9|1\\.0|1\\.1) \

[\\x09-\\x0d ][1-5][0-9][0-9] \

[\\x09-\\x0d -~]*(content-type: video)"

add name=EXE regexp="\\.(exe)"

add name=RAR regexp="\\.(rar)"

add name=ZIP regexp="\\.(zip)"

add name=7z regexp="\\.(7z)"

add name=WMV regexp="\\.(wmv)"

add name=MPG regexp="\\.(mpg)"

add name=MPEG regexp="\\.(mpeg)"

add name=AVI regexp="\\.(avi)"

add name=FLV regexp="\\.(flv)"

add name=WAV regexp="\\.(wav)"

add name=MP3 regexp="\\.(mp3)"

add name=MP4 regexp="\\.(mp4)"

add name=ISO regexp="\\.(iso)"

add name=3GP regexp="\\.(3gp)"

add name=MOV regexp="\\.(mov)"

add name=MKV regexp="\\.(mkv)"

add name="YOUTUBE STREAMING" regexp=youtube

add name=PORN regexp=porn

add name=TUBE regexp=tube

add name=VIDEO regexp=video

add name=MOVIE regexp=movie

INI ROUTING UNTUK EXTENSI

/ip firewall mangle

add action=mark-packet chain=forward \

comment="LIMIT EXTENTION" disabled=no \

layer7-protocol="YOUTUBE DOWNLOAD" \

new-packet-mark="YOUTUBE DOWNLOAD" \

passthrough=no

add action=mark-packet chain=forward \

disabled=no layer7-protocol="YOUTUBE STREAMING" \

new-packet-mark="YOUTUBE STREAMING" \

passthrough=no

add action=mark-packet chain=forward \

disabled=no layer7-protocol=TUBE \

new-packet-mark=PORN1 passthrough=no

add action=mark-packet chain=forward disabled=no \

layer7-protocol=PORN \

new-packet-mark=PORN2 passthrough=no

add action=mark-packet chain=forward \

disabled=no layer7-protocol=VIDEO \

new-packet-mark=PORN3 passthrough=no

add action=mark-packet chain=forward \

disabled=no layer7-protocol=MOVIE \

new-packet-mark=PORN4 passthrough=no

add action=mark-packet chain=forward \

disabled=no layer7-protocol=MKV \

new-packet-mark=MKV passthrough=no

add action=mark-packet chain=forward \

disabled=no layer7-protocol=MP3 \

new-packet-mark=MP3 passthrough=no

add action=mark-packet chain=forward \

disabled=no layer7-protocol=MP4 \

new-packet-mark=MP4 passthrough=no

add action=mark-packet chain=forward \

disabled=no layer7-protocol=ZIP \

new-packet-mark=ZIP passthrough=no

add action=mark-packet chain=forward \

disabled=no layer7-protocol=EXE \

new-packet-mark=EXE passthrough=no

add action=mark-packet chain=forward \

disabled=no layer7-protocol=FLV \

new-packet-mark=FLV passthrough=no

add action=mark-packet chain=forward \

disabled=no layer7-protocol=ISO \

new-packet-mark=ISO passthrough=no

add action=mark-packet chain=forward \

disabled=no layer7-protocol=MOV \

new-packet-mark=MOV passthrough=no

add action=mark-packet chain=forward \

disabled=no layer7-protocol=MPEG \

new-packet-mark=MPEG passthrough=no

add action=mark-packet chain=forward \

disabled=no layer7-protocol=MPG \

new-packet-mark=MPG passthrough=no

add action=mark-packet chain=forward \

disabled=no layer7-protocol=RAR \

new-packet-mark=RAR passthrough=no

add action=mark-packet chain=forward \

disabled=no layer7-protocol=WAV \

new-packet-mark=WAV passthrough=no

add action=mark-packet chain=forward \

disabled=no layer7-protocol=WMV \

new-packet-mark=WMV passthrough=no

add action=mark-packet chain=forward \

disabled=no layer7-protocol=ISO \

new-packet-mark=3GP passthrough=no

add action=mark-packet chain=forward \

disabled=no layer7-protocol=7z \

new-packet-mark=7z passthrough=no

INI ROUTING UNTUK BROWSING (DOWNLOAD/UPLOAD)

/ip firewall mangle \

add action=mark-connection chain=prerouting \

comment=HTTP  dst-port=21,80 \

new-connection-mark="browsing-con" passthrough=yes protocol=tcp

/ip firewall mangle \

add action=mark-packet chain=forward \

connection-mark="browsing-con" disabled=no \

dst-address=192.168.1.0/24 \

new-packet-mark="download" passthrough=no

/ip firewall mangle \

add action=mark-packet chain=forward \

connection-mark="browsing-con" disabled=no \

new-packet-mark="upload" \

passthrough=no src-address=192.168.1.0/24

INI QUEUE UNTUK KEGIATAN  BROWSING-DOWNLOAD-UPLOAD

/queue tree \

add max-limit=128000 \

name="UPLOAD-BROWSING" \

packet-mark="upload" parent=speedy \

priority=4 queue=UP

/queue tree \

add max-limit=750000 \

name="1.2 HTTP-DOWN" \

parent=global-out priority=2

/queue tree \

add max-limit=750000 \

name="1.3 BROWSING DOWN" \

packet-mark="download" \

parent="1.2 HTTP-DOWN" \

priority=4 queue=DOWN

/queue tree \

add max-limit=512000 \

name="1.4 LIMIT EXTENTION" \

parent="1.2 HTTP-DOWN" priority=5

/queue tree

add name=YOUTUBE \

parent="1.4 LIMIT EXTENTION" priority=5

add name="YOUTUBE STREAMING" \

packet-mark="YOUTUBE STREAMING" \

parent=YOUTUBE priority=5 queue=DOWN

add name=MKV packet-mark=MKV \

parent="1.4 LIMIT EXTENTION" \

priority=5 queue=DOWN

add name=MP3 packet-mark=MP3 \

parent="1.4 LIMIT EXTENTION" \

priority=5 queue=DOWN

add name=MP4 packet-mark=MP4 \

parent="1.4 LIMIT EXTENTION" \

priority=5 queue=DOWN

add name=ZIP packet-mark=ZIP \

parent="1.4 LIMIT EXTENTION" \

priority=5 queue=DOWN

add name=EXE packet-mark=EXE \

parent="1.4 LIMIT EXTENTION" \

priority=5 queue=DOWN

add name=ISO packet-mark=ISO \

parent="1.4 LIMIT EXTENTION" \

priority=5 queue=DOWN

add name=AVI packet-mark=AVI \

parent="1.4 LIMIT EXTENTION" \

priority=5 queue=DOWN

add name=MOV packet-mark=MOV \

parent="1.4 LIMIT EXTENTION" \

priority=5 queue=DOWN

add name=MPEG packet-mark=MPEG \

parent="1.4 LIMIT EXTENTION" \

priority=5 queue=DOWN

add name=MPG packet-mark=MPG \

parent="1.4 LIMIT EXTENTION" \

priority=5 queue=DOWN

add name=RAR packet-mark=RAR \

parent="1.4 LIMIT EXTENTION" \

priority=5 queue=DOWN

add name=WAV packet-mark=WAV \

parent="1.4 LIMIT EXTENTION" \

priority=5 queue=DOWN

add name=WMV packet-mark=WMV \

parent="1.4 LIMIT EXTENTION" \

priority=5 queue=DOWN

add name=3GP packet-mark=3GP \

parent="1.4 LIMIT EXTENTION" \

priority=5 queue=DOWN

add name=7z packet-mark=7z \

parent="1.4 LIMIT EXTENTION" priority=5 \

queue=DOWN

add name="YOUTUBE DOWNLOAD" \

packet-mark="YOUTUBE DOWNLOAD" \

parent=YOUTUBE priority=5 queue=DOWN

add name=PORN \

parent="1.4 LIMIT EXTENTION" priority=5

add name=PORN1 \

packet-mark=PORN1 parent=PORN \

priority=5 queue=DOWN

add name=PORN2 packet-mark=PORN2 \

parent=PORN priority=5 queue=DOWN

add name=PORN3 packet-mark=PORN3 \

parent=PORN priority=5 queue=DOWN

add name="MIVO TV" \

packet-mark="MIVO TV" parent=\

"1.4 LIMIT EXTENTION" \

priority=5 queue=DOWN

add name=PORN4 packet-mark=PORN4 \

parent=PORN priority=5 queue=DOWN

Setting Proxy Lusca... UBUNTU pengalaman yang mengesankan !!!

Melakukan Export dan Import script Mikrotik

Ketika anda mulai masuk ke tanah bisnis mikrotik seharusnya anda sudah meninggalkan pola by manual.. kenapa ? manual kalau skala belajar ok.. ok sajalah.. namaun kalau sudah masuk ke skala bisnis kita memulai berfikir bagaimana kerja cepat dan tepat...

Berpatokan pada hal tersebut diatas maka saya menyarankan anda harus sudah beralih ke script... saya masih belajar memperbaiki diri dan belajar beralih ke script. berikut tag yang saya ambil dari bloger mikrotikblogspot.  yang sangat mengispirasi .. saya, semoga allah memuliakan atas ilmunya
silahkan dipelajari script dibawah ini kalau anda ingin menpelajari cara melakukan export dan import...

Cara Export & Import Konfigurasi/Setingan Mikrotik sebagai berikut :

1. Buka terminal  masukkan command berikut :

export file=namafile

Ganti namafile sesuai keinginan anda.

Selain itu kita juga bisa melakukan export untuk konfigurasi spesifik, misal mau export konfigurasi firewall saja jadi command nya gini :

ip firewall export file=namafile

2. Hasil file export nya tersimpan di file, coba lihat dengan command 

file print

3. Untuk meng-copy file konfigurasi tersebut, buka menu file --> pilih file konfigurasi mana saja yang mau di-copy --> klik tombol copy di toolbar --> masuk ke folder Windows Explorer --> Paste di folder mana terserah anda.

4. Extensi file export ini adalah .rsc. Kita bisa membuka file ini dengan notepad.

5. Jika ingin meng-import file konfigurasi ini buka terminal --> ketikkan command :

import file-name=namafile

How to start SQL Server Agent when Agent XPs show disabled

Problem

The other day we found that SQL Server Agent was stopped with the following message in SSMS "SQL Server Agent (Agent XPs disabled)" for one of our SQL Server instances, but the service was running according to the services console.  I tried to start the service from SQL Server Management Studio, but this did not work.  What is the issue and how do I fix this?

Solution

The other day I changed an implementation on one of our SQL Server instances. After the change, I started all of the SQL Server services from the services.msc console and everything started successfully. But when I launched SQL Server Management Studio, SQL Server Agent showed that is was not running with 'Agent XPs disabled' message as shown below. I tried to restart the service from SSMS, but it did not work. The interesting thing was that the service showed as 'started' when I was looking at it in the services.msc console.

As SQL Server Agent was not running in SSMS, we were not able to access any of the contents like jobs, error logs, etc... 
It appears, that this issue appears when 'Agent XPs' advance configuration option is disabled and set to 0 for the SQL Server configuration..
Agent XPs is an advanced configuration option which enables the SQL Server Agent extended stored procedures on the server.  When this is not enable SQL Server Agent will not be active in SSMS. Most of the time when you start the SQL Server services it automatically enables 'Agent XPs', but sometime it fails to enable or sets the value to 0 and then this issue will appear.
To fix this issue we should first set the 'Agent XPs' to 1 and then run RECONFIGURE to bring it into effect.
Step 1. 
Run sp_configure to check 'Agent XPs' value.

EXEC SP_CONFIGURE 'Agent XPs'

Step 2The above screenshot shows that advanced options is not enabled on this instance, so we must first enable advanced option to see all of the advanced configuration values.

EXEC SP_CONFIGURE 'show advanced options',1
GO
RECONFIGURE
GO
EXEC SP_CONFIGURE 'show advanced options'

You can see 'show advanced options' is set to 1 this means that advanced options are enabled and we can see and change the values.
Step 3Run sp_configure again to check the value for Agent XPs. Here we can see the run value is set to 0.

Now we need to change this setting from 0 to 1 to run SQL Server Agent in SQL Server Management Studio.

EXEC SP_CONFIGURE 'Agent XPs',1
GO
RECONFIGURE

Step 4Now restart your SQL Server Agent service from SQL Server Configuration Manager. This time the service should come up and we can successfully access all of the content for SQL Server Agent.

Next Steps

• Always use SQL Server Configuration Manager to start SQL Server services
• If you get this message in SQL Server, check the configuration settings to enable the Agent XPs
• Read the additional articles on SQL Server Agent

Cara Remote Mikrotik via Internet

Bagaimana cara remote Mikrotik via internet ya ???

cara remote mikrotik warnet speedynya jarak jauh Kasus pertama :
Modem ADSL PPOE Mode artinya modem yang dial Speedy, username dan password tersimpan di modem lebih mudahnya ketika modem kita nyalakan maka akan melakukan panggilan ke internet. IP Publik akan didapat ketika koneksi terhubung ke internet.
Berikut solusinya :
1. Perlu diketahui ip publik dari ISP , caranya masuk ke browser ketik http://www.whatismyip.com

2. Set port forward pada modem (pada contoh ini saya menggunakan modem TP LINK) 

Rule Index : 1
Application : Mikrotik
Protocol : ALL
Start Port Number : 80
End Port Number : 8291
Local IP Address : 192.168.1.1 ( IP Address Mikrotik – Interface Ethernet yang konek ke Modem ADSL)
Sekarang coba remote melalui internet pake winbox, masukkan ip publik, username dan password 

arahkan connec to ke Ip address dari mikrotik yang akan kita remote : 125.163.164.198

 Jika progress remote berhasil maka akan terliat proses downloading dari ip public yang kita masukan

Berikut adalah hasilnya


Selamat mencoba dan semoga bermanfaat

Budi Anggoro