Postgresql cheatsheat
Connecting to MySQL: mysql -u user_name -p Connecting to PostgreSQL: sudo -u postgres psql Description MySQL command PostgreSQL equivalent Show databases SHOW DATABASES; \l Use/Connect to a database named ‘some_database’…
DTLS, DTLS-SRTP
DTLS: Basically DTLS is to construct TLS over datagram (UDP, DCCP, etc.) DTLS is similar to TLS intentionally except that DTLS has to solve two problems: packet lost and reordering.…
OpenPGP vs S/MIME
S/MIME and OpenPGP similarity: both depends on public/private keys to encrypt/authenticate msg ( emails), difference: how to distribute the public keys. S/MIME is similar to TLS, need to depends on…
What is the difference between srtp and zrtp
SRTP sdp msg: v=0 o=jdoe 2890844526 2890842807 IN IP4 10.47.16.5 s=SDP Seminar i=A Seminar on the session description protocol u=http://www.example.com/seminars/sdp.pdf e=j.doe@example.com (Jane Doe) c=IN IP4 161.44.17.12/127 t=2873397496 2873404696 m=video 51372…
systemctl cheatsheat
Systemd template and instance (@) from: https://wiki.archlinux.org/index.php/systemd Note: Some unit names contain an @ sign (e.g. name@string.service): this means that they are instances of a template unit, whose actual file…
SSH protocol
How SSH2 works: (1) When a TCP connection is made by a client, the server responds with the protocol versions it supports. If the client can match one of the…