Ust. Oemar Mitta - Jalan Yang Lurus

 

Postgresql

untuk masuk sebagai user postgres, ketikan perintah ini:
sudo su - postgres

kemudian terkoneksi ke database menggunakan psql client, caranya ketik perintah:
psql -U postgres
nanti akan muncul tampilan seperti ini:
postgres=#

\list -> lists all databases
\dt -> lists all tables in the current database

\c testdatabase -> use database
\q -> keluar dari postgreSQL

cisco point to point

router A
>enable
'masukin password
#conf t
(config)#end 'keluar
#show run 'liat2
space or enter 'liat2
^c 'keluar
'create WAN
(config)#interface ethernet 0
(config-if)#ip add 10.10.10.1 255.255.255.252
'create LAN
(config)#ip add 192.168.40.1 255.255.255.0
'create route ip tujuan
(config-if)#ip route 192.168.57.0 255.255.255.0
nb : kenapa 57.0 karena ngeroute 1 segmen, klo mau ngeroute beberapa PC bikin SMnya jadi 0.0.0.jmlPC
nb : WAN itu IP dari provider
(config-if)#wr mem

router B
'create WAN
ip add 10.10.10.2 255.255.255.252
'create LAN
ip add 192.168.57.1 255.255.255.0
'create route
ip route 192.168.40.0 255.255.255.0

edit file linux

dalam kasus ini saya akan mengedit alamat IP pada linux.

cd /etc/sysconfig/network-scripts/
vi ifcfg-eth0

[esc][esc][i] ini untuk ngedit
[esc][esc][w][q][!] ini untuk ngesave dan exit

service network restart

blok ip yg coba masuk pake ssh ke mikrotik

/ ip firewall filter

add chain=input protocol=tcp dst-port=22 src-address-list=black_list action=drop |
comment="drop ssh brute forcers" disabled=no

add chain=input protocol=tcp dst-port=22 connection-state=new |
src-address-list=ssh_stage3 action=add-src-to-address-list address-list=black_list address-list-timeout=1d |
comment="" disabled=no

add chain=input protocol=tcp dst-port=22 connection-state=new |
src-address-list=ssh_stage2 action=add-src-to-address-list address-list=ssh_stage3 address-list-timeout=1m |
comment="" disabled=no

add chain=input protocol=tcp dst-port=22 connection-state=new |
src-address-list=ssh_stage1 action=add-src-to-address-list address-list=ssh_stage2 address-list-timeout=1m |
comment="" disabled=no

add chain=input protocol=tcp dst-port=22 connection-state=new |
action=add-src-to-address-list address-list=ssh_stage1 address-list-timeout=1m comment="" |
disabled=no

sumber : http://www.forummikrotik.com/beginner-basics/553-%5Bask%5D-blok-ip-yg-coba-masuk-pake-ssh-n-telnet.html