I LOVE NETWORKING

 Error saat import MySQL #1071 – Specified key was too long; max key length is 767 bytes

Mungkin teman-teman sedang mengalami error 1071 – Specified key was too long; max key length is 767 bytes pada saat melakukan import database di MySQL.

Kalau saya tidak salah menerka hal ini terjadi karena file kita terlalu besar dan mengandung banyak query didalamnya.

Saya sendiri mengalami hal ini ketika sedang melakukan import banyak database sekaligus pasca migrasi data dari perangkat lama ke perangkat baru.

Solusi untuk mengatasi hal tersebut adalah, teman-teman bisa login ke console mysql, pada terminal Linux, Mac atau pada CMD di Windows dengan cara:

mysql -u root -p

lalu enter dan masukkan passwordnya.

setelah itu, teman-teman bisa jalankan script berikut ini:

SET GLOBAL innodb_file_format=Barracuda;

SET GLOBAL innodb_file_per_table=on;

SET GLOBAL innodb_large_prefix=on;

setelah selesai, exit dari console mysql, lalu lakukan import ulang. InsyaAllah bisa, saya sudah membuktikannya, work ditempat saya.

 How to Setup PPTP Client on CENTOS 7

VPN

The Point-to-Point Tunneling Protocol (PPTP) is a method for implementing virtual private networks. Since it is marked as non secure and vulnerable, I don’t recommend it as a “final” VPN solution. The main reason for its popularity is probably the native MS Windows support (since win 95). Also, it can be easily implemented with Mikrotik RouterOS (like I said, use it for internal VPNs only).

To set up your CentOS 7 as a PPTP clients you will need the pptp package.

 [root@linggeh /]#yum install -y pptp

Open /etc/ppp/chap-secrets and add the next line (at the end). Also, replace the UserName and password with the correct details:

 [root@linggeh /]# nano /etc/ppp/chap-secrets

userName     PPTP     password     *

linggeh         PPTP     123123      *

Create profile file

 [root@linggeh /]# nano /etc/ppp/peers/myVPN

and paste the next content (replace IP_OR_HOSTNAME with PPTP server IP or Hostname)

pty "pptp IP_OR_HOSTNAME --nolaunchpppd"

name userName

remotename PPTP

require-mppe-128

file /etc/ppp/options.pptp

ipparam myVPN

Save the file and test the connection with

 

[root@linggeh /]#pppd call myVPN

ifconfig should return something like

....

ppp0      Link encap:Point-to-Point Protocol  

          inet addr:10.16.18.252  P-t-P:10.16.18.251  Mask:255.255.255.255

          UP POINTOPOINT RUNNING NOARP MULTICAST  MTU:1436  Metric:1

          RX packets:14 errors:0 dropped:0 overruns:0 frame:0

          TX packets:15 errors:0 dropped:0 overruns:0 carrier:0

          collisions:0 txqueuelen:3 

          RX bytes:2192 (2.1 KiB)  TX bytes:631 (631.0 b)

...

If you check your routes, you’ll probably notice that ppp0 connection is not used by any route(s). This is default behavior and you can easily switch/add default route with:

route add default dev ppp0

In my case, I don’t want to route the complete traffic (this VPN is just for management) so I’ll add only one static route

route add -net 192.168.0.0/16 dev ppp0

To start this connection on boot, add “pppd call myVPN” in rc.local.

Thank for Reading *-*

How to Configure Load Balancing 3 MODEM ( PCC Method )

Mikrotik RouterBoard

 /interface ethernet

set [ find default-name=ether1 ] comment="ICON+ name=ether1-WAN1

set [ find default-name=ether2 ] comment="ICON+ name=ether2-WAN2

set [ find default-name=ether3 ] comment=TELKOM name=ether3-WAN3

set [ find default-name=ether4 ] name=ether4-LAN

set [ find default-name=ether5 ] name=ether5-LAN

/interface bridge

add name=bridge-LAN

/interface bridge port

add bridge=bridge-LAN interface=ether4-LAN

add bridge=bridge-LAN interface=ether5-LAN

/ip address

add address=202.162.xxx.xxx/29 interface=ether1-WAN1 network=202.162.213.200

add address=10.110.xx.xx/22 interface=ether2-WAN2 network=10.110.0.0

add address=192.168.xxx.xx/24 interface=ether3-WAN3 network=192.168.100.0

add address=192.168.12.1/23 interface=bridge-LAN network=192.168.12.0

/ip dns

set servers=118.98.44.100,118.98.44.50,8.8.8.8

/ip pool

add name=dhcp_pool0 ranges=192.168.12.2-192.168.12.255

/ip dhcp-server

add address-pool=dhcp_pool0 disabled=no interface=bridge-LAN 

/ip dhcp-server network

add address=192.168.12.0/23 gateway=192.168.12.1

/ip firewall nat

add action=masquerade chain=srcnat disabled=yes out-interface=ether1-WAN1

add action=masquerade chain=srcnat disabled=yes out-interface=ether3-WAN3

add action=masquerade chain=srcnat disabled=yes out-interface=ether2-WAN2

/ip firewall mangle

add action=mark-connection chain=input in-interface=ether1-WAN1 \

    new-connection-mark=WAN1_conn passthrough=yes

add action=mark-connection chain=input in-interface=ether2-WAN2 \

    new-connection-mark=WAN2_conn passthrough=yes

add action=mark-connection chain=input in-interface=ether3-WAN3 \

    new-connection-mark=WAN3_conn passthrough=yes

add action=mark-routing chain=output connection-mark=WAN1_conn \

    new-routing-mark=to_WAN1 passthrough=yes

add action=mark-routing chain=output connection-mark=WAN2_conn \

    new-routing-mark=to_WAN2 passthrough=yes

add action=mark-routing chain=output connection-mark=WAN3_conn \

    new-routing-mark=to_WAN3 passthrough=yes

add action=accept chain=prerouting dst-address=202.162.xx.xx/29 \

    in-interface=bridge-LAN

add action=accept chain=prerouting dst-address=10.110.xx.xx/22 in-interface=\

    bridge-LAN

add action=accept chain=prerouting dst-address=192.168.xx.xx/24 in-interface=\

    bridge-LAN

add action=mark-connection chain=prerouting dst-address-type=!local \

    in-interface=bridge-LAN new-connection-mark=WAN1_conn passthrough=yes \

    per-connection-classifier=both-addresses-and-ports:4/0

add action=mark-connection chain=prerouting dst-address-type=!local \

    in-interface=bridge-LAN new-connection-mark=WAN2_conn passthrough=yes \

    per-connection-classifier=both-addresses-and-ports:4/1

add action=mark-connection chain=prerouting dst-address-type=!local \

    in-interface=bridge-LAN new-connection-mark=WAN3_conn passthrough=yes \

    per-connection-classifier=both-addresses-and-ports:4/2

add action=mark-connection chain=prerouting dst-address-type=!local \

    in-interface=bridge-LAN new-connection-mark=WAN3_conn passthrough=yes \

    per-connection-classifier=both-addresses-and-ports:4/3

add action=mark-routing chain=prerouting connection-mark=WAN1_conn \

    in-interface=bridge-LAN new-routing-mark=to_WAN1 passthrough=yes

add action=mark-routing chain=prerouting connection-mark=WAN2_conn \

    in-interface=bridge-LAN new-routing-mark=to_WAN2 passthrough=yes

add action=mark-routing chain=prerouting connection-mark=WAN3_conn \

    in-interface=bridge-LAN new-routing-mark=to_WAN3 passthrough=yes

/ip route

add distance=1 gateway=202.162.xx.xx routing-mark=to_WAN1

add distance=1 gateway=10.110.xx.xx routing-mark=to_WAN2

add distance=1 gateway=192.168.xxx.xx routing-mark=to_WAN3

/system clock

set time-zone-name=Asia/Jakarta

2 Wan Load Balancing with Hotspot

/interface set ether1 name=WAN1
/interface set ether2 name=WAN2
/interface set ether3 name=Local

/ip address
add address=192.168.0.1/24 network=192.168.0.0 broadcast=192.168.0.255 interface=Local
add address=192.168.1.10/24 network=192.168.1.0 broadcast=192.168.1.255 interface=WAN1
add address=192.168.2.10/24 network=192.168.2.0 broadcast=192.168.2.255 interface=WAN2

/ip dns
set allow-remote-requests=yes cache-max-ttl=1w cache-size=5000KiB max-udp-packet-size=512 servers=192.168.0.1,8.8.8.8,8.8.4.4

/ip firewall mangle
add chain=input in-interface=WAN1 action=mark-connection new-connection-mark=WAN1_conn
add chain=input in-interface=WAN2 action=mark-connection new-connection-mark=WAN2_conn

/ip firewall mangle
add chain=output connection-mark=WAN1_conn action=mark-routing new-routing-mark=to_WAN1
add chain=output connection-mark=WAN2_conn action=mark-routing new-routing-mark=to_WAN2

/ip firewall mangle
add chain=prerouting dst-address=192.168.1.0/24 action=accept in-interface=Local
add chain=prerouting dst-address=192.168.2.0/24 action=accept in-interface=Local

/ip firewall mangle
add chain=prerouting dst-address-type=!local in-interface=Local per-connection-classifier=both-addresses-and-ports:2/0 action=mark-connection new-connection-mark=WAN1_conn passthrough=yes
add chain=prerouting dst-address-type=!local in-interface=Local per-connection-classifier=both-addresses-and-ports:2/1 action=mark-connection new-connection-mark=WAN2_conn passthrough=yes

/ip firewall mangle
add chain=prerouting connection-mark=WAN1_conn in-interface=Local action=mark-routing new-routing-mark=to_WAN1
add chain=prerouting connection-mark=WAN2_conn in-interface=Local action=mark-routing new-routing-mark=to_WAN2

/ip route
add dst-address=0.0.0.0/0 gateway=192.168.1.1 routing-mark=to_WAN1 check-gateway=ping
add dst-address=0.0.0.0/0 gateway=192.168.2.1 routing-mark=to_WAN2 check-gateway=ping

/ip route
add dst-address=0.0.0.0/0 gateway=192.168.1.1 distance=1 check-gateway=ping
add dst-address=0.0.0.0/0 gateway=192.168.2.1 distance=2 check-gateway=ping

/ip firewall nat
add chain=srcnat out-interface=WAN1 action=masquerade
add chain=srcnat out-interface=WAN2 action=masquerade

/ip address
add address=192.168.0.1/24 disabled=no interface=Local network=192.168.0.0

/ip pool
add name=hs-pool-1 ranges=192.168.0.10-192.168.0.254

/ip dhcp-server
add address-pool=hs-pool-1 authoritative=after-2sec-delay bootp-support=static disabled=no interface=Local lease-time=1h name=dhcp1

/ip dhcp-server config
set store-leases-disk=5m

/ip dhcp-server network
add address=192.168.0.0/24 comment=”hotspot network” gateway=192.168.0.1

/ip hotspot profile
set default dns-name=”" hotspot-address=0.0.0.0 html-directory=hotspot http-cookie-lifetime=3d http-proxy=0.0.0.0:0 login-by=http-chap name=default rate-limit=”" smtp-server=0.0.0.0 split-user-domain=no use-radius=no
add dns-name=includealine.com hotspot-address=192.168.0.1 html-directory=hotspot http-cookie-lifetime=1d http-proxy=0.0.0.0:0 login-by=http-chap name=hsprof1 rate-limit=”" smtp-server=0.0.0.0 split-user-domain=no use-radius=no

/ip hotspot
add address-pool=hs-pool-1 addresses-per-mac=1 disabled=no idle-timeout=15m interface=ether2 keepalive-timeout=none name=hotspot1 profile=hsprof1

/ip hotspot user profile
set default idle-timeout=15m keepalive-timeout=2m name=default shared-users=1 status-autorefresh=1m transparent-proxy=no
add address-pool=hs-pool-1 advertise=no idle-timeout=none keepalive-timeout=2m name=”512k Limit” open-status-page=always rate-limit=512k/512k shared-users=1 status-autorefresh=1m transparent-proxy=yes
add address-pool=hs-pool-1 advertise=no idle-timeout=none keepalive-timeout=2m name=”256k Limit” open-status-page=always rate-limit=256k/256k shared-users=1 status-autorefresh=1m transparent-proxy=yes

/ip hotspot service-port
set ftp disabled=yes ports=21

/ip hotspot walled-garden ip
add action=accept disabled=no dst-address=192.168.0.1

/ip hotspot
set numbers=hotspot1 address-pool=none

/ip firewall nat
add action=masquerade chain=srcnat disabled=no

/ip hotspot user
add disabled=no name=admin password=123 profile=default
add disabled=no name=test1 password=1234 profile=”512k Limit” server=hotspot1
add disabled=no name=test2 password=1234 profile=”256k Limit” server=hotspot1

Remove Bill Gates BotNet

• Identify and kill process running

• Verify crontab

• Remove calls from start scripts

• Remove physical files

References

1. http://lpages.info/billgates-linux-botnet/
2. https://isc.sans.edu/forums/diary//17282
3. https://help.1and1.com/hosting-c37630/scripts-and-programming-languages-c85099/cron-jobs-c37727/delete-a-cron-job-a757264.html