Load Balancing Mikrotik + External Proxy

Ternyata untuk membuat Load Balancing di Mikrotik itu sangat mudah…

tetapi jikalau menggunakan external proxy tanpa mengaktifkan fitur proxy di mikrotik baru ada sedikit trouble

akhirnya setelah googling sana-sini, ketemu juga cara setting Load Balancing + External Proxy

berikut cara settingannya:

IP Mikortik     : 192.168.1.2
IP Proxy          : 172.16.0.2 port 3128 [ SQUID ]
IP CLIENT       : 192.168.0.0/16 [ LAN ]
IP CBN              : 202.222.7.99/28 [ CBN ]
IP ASTINET    : 118.77.77.180/29 [ ASTINET ]

[ NAT ]
chain=srcnat action=src-nat to-addresses=202.222.7.99 src-address=192.168.0.0/16 out-interface=CBN
chain=srcnat action=src-nat to-addresses=118.77.77.180 src-address=192.168.0.0/16 out-interface=ASTINET
chain=srcnat action=src-nat to-addresses=202.222.77.99 src-address=172.16.0.0/24 out-interface=CBN
chain=srcnat action=src-nat to-addresses=118.77.77.180 src-address=172.16.0.0/24 out-interface=ASTINET

;;; Redirect SQUID
chain=dstnat action=dst-nat to-addresses=172.16.0.2 to-ports=3128 protocol=tcp src-address=192.168.0.0/16 dst-port=80

Read more…

September 27th, 2011 by Rius in Mikrotik | No Comments

Mengatasi Masalah Putus Nyambung ym pada load balancing mikrotik

Untuk mengatasi masalah putus nyambung ym atau beberapa website yang tidak mau menerima load balance mikrotik

pada RouterOS v4.17, adapun solusinya adalah dengan meroute IP target dengan salah satu gateway ISP kita

berikut list IP ym yang harus di router ke salah satu gateway ISP kita :

62.233.189.0/24
64.4.13.0/24
64.4.15.0/24
65.54.239.0/24
66.94.230.0/24
66.163.175.0/24
66.163.181.0/24
68.142.194.0/32
68.142.197.0/24
68.142.226.0/24
68.142.233.0/24
68.180.217.0/24
69.17.117.0/24

202.43.193.0/24
202.67.9.0/24
203.91.144.0/24
205.234.232.0/24
207.45.5.0/24
207.46.0.0/24
207.46.1.0/24
207.68.173.0/24
207.68.183.0/24
209.73.0.0/24
216.109.116.0/24
216.136.232.0/24
216.155.193.0/24
216.155.194.0/24

bagi yang ingin menambahkan silahkan..

Implementasi menggunakan winbox:

1. buka winbox

2. Klik IP -> Routes

3. pada tab General

- Dst. Address isikan salah satu IP ym : e .g : 216.155.194.0/24

- gateway : di isi dengan IP gateway ISP kita

4. Klik OK

Selamat Mencoba….

August 6th, 2011 by Rius in Mikrotik | No Comments

How to reset root password in MySQL

By default some installations of MySQL server come with no password for the root account. If you have set a password and forgot it you have to use the following procedure to reset it. The procedure is available for mysql instances installed on Linux operating systems. The passwords in MySQL are stored on the user table from the mysql database and are encrypted using the mysql PASSWORD() function. The used encryption algorithm is one way and cannot be reversed.

In this procedure we won’t recover the existing password for the root account but instead we will reset it by changing it with a new one.

1. # /etc/init.d mysql stop

2. # mysqld_safe –skip-grant-tables &

3. # mysql -u root

This will bring us at the mysql console.

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1588
Server version: 5.1.51-0 (Debian)

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.

mysql>

4. Run the following queries in order to reset the password:

mysql> use mysql;
mysql> UPDATE user set Password=PASSWORD(”NEW-PASSWORD”) WHERE User=’root’;
mysql> FLUSH PRIVILEGES;
mysql> quit;

Note: Replace NEW-PASSWORD with your chosen password for the mysql root account.

Here the UPDATE statement is used to update the “user” table from the mysql database with the new password for the root account. After the password has been updated the FLUSH PRIVILEGES statement is used to reload the privileges from the grant tables in the mysql database.

5. # /etc/init.d/mysql start

6. # mysql -u root -p

and input with new password!! good luck!!

August 3rd, 2011 by Rius in MySQL | No Comments

FIGHTING MASTURBATION

Five points below are the ways how to do it:

1.      Every file about pictures, books, words, our imagination, our habits to see tight-fitting dressed women, should be removed completely.

2.      If the desire to masturbate comes, we must reject it firmly by doing any activities.

3.      Make a strong commitment within yourself that you will never masturbate anymore from now on.

4.      Love your Creator with every single of your existence, your mind and your thought.

5.      By thinking that: the effect of masturbation is the muscles of our penis will be damaged.

Motto: “From today on I will never masturbate anymore.”

July 31st, 2011 by Rius in Others | No Comments

Puisi anak Kedokteran

Hari itu, ketika tubuhku pada metabolismenya yang terendah…

Mataku berakomodasi tak percaya…
Benarkah yang tertangkap oleh nervi optici-ku??

Dalam sms mu…
Katamu, akulah nukleus kehidupanmu…
Katamu, jika kau flagelatta, maka akulah ATP…
Katamu, jika kau inflamasi, akulah prostaglandin

Sadarkah kau??
Kau berhasil membuatku mengalami hipertensi fisiologis dan tachycardi
Perintahkan membrana tympani mu mendengar seluruh discuss vertebralis ku berkata…

Setiap cardiac output-ku membutuhkan pacemaker darimu.
Setiap detail gerakan glossus-mu merangsang saraf simpatisku.

Ucapan selamat malammu laksana diazepam
Ucapan “jangan menangis, sayang”-mu bagaikan valium bagiku…
Dan ketika kau pergi…terasa bagaikan imunosupresi untukku…

November 28th, 2010 by Rius in Humor | No Comments

Google
Web seseorang.org