Duc Hoa, Nguyen saikocat

The Best Medium-Hard Data Analyst SQL Interview Questions

By Zachary Thomas ([email protected], Twitter, LinkedIn)

**Tip: **See the Table of Contents (document outline) by hovering over the vertical line on the right side of the page

Background & Motivation

Caused by: com.jcraft.jsch.JSchException: invalid privatekey: [B@e4487af

The root cause was discovered to be the ssh private key mismatch. The exception only happened for users with key of newer kind ed25519, which outputs this key header:

-----BEGIN OPENSSH PRIVATE KEY-----

Movements

Pressing j will move the cursor down 1 physical line.
Pressing gj will move the cursor down 1 displayed line.
Alt to `. is g;

Formating

Wrap lines after setting textwidth: in visual mode, gq
set shiftround

Searching

Source: https://old.reddit.com/r/getdisciplined/comments/alqpx4/advice_summary_of_atomic_habits/

"We are what we repeatedly do. Excellence, then, is not an act, but a habit." - Aristotle

I highly recommend buying the book or audiobook. I believe doing that, then using the summary to review the key ideas, is the best bet for transformation.

https://www.samuelthomasdavies.com/book-summaries/self-help/atomic-habits/

https://www.goodreads.com/book/show/40121378-atomic-habits

After performing a reboot, when the system kernel upgrade failed due to no disk space left (hence initramfs failed to regenerate)

Failed to execute /init (error -8)
Starting init: /sbin/init exists but couldn't execute it (error -8)
Starting init: /bin/init exists but couldn't execute it (error -8)

Mounting for chroot environment

Symptoms

Firefox - Google Meet | Zoom - can't share screen.
Chromium - Google Meet | Zoom - can share only tab, and not windows or desktop.
Slack - Share Screen - gray pop-up without any options to select.
Obs - Screen Capture (Pipewire) option is not available.
'loop->recurse > 0' failed at ../pipewire/src/pipewire/thread-loop.c:... pw_thread_loop_wait()

Troubleshooting

For some reasons, I noticed that WAYLAND_DISPLAY & XDG_CURRENT_DESKTOP are not set in the shell env, which might point to the login manager / systemd not setting the values correctly.

	FROM debian:buster-slim AS builder

	ARG XAR_VERSION=19.4.22

	WORKDIR /src

	RUN set -ex; \
	apt-get update; \
	apt-get install -y g++ curl cmake squashfs-tools; \
	curl -L https://github.com/facebookincubator/xar/archive/${XAR_VERSION}.tar.gz \| tar -zxv --strip-components=1 --directory .; \

	COMB(WORD_BSPC_KL, C(KC_BSPC), KC_I, KC_O)

	COMB(SFT_OS_ASCLN, OSM(MOD_LSFT), KC_A, KC_SCLN)
	COMB(SFT_OS_WE, OSM(MOD_RSFT), KC_W, KC_E)
	COMB(SFT_OS_SD, OSM(MOD_LSFT), KC_S, KC_D)
	COMB(CTL_OS_DF, OSM(MOD_LCTL), KC_D, KC_F)
	COMB(ALT_OS_ZX, OSM(MOD_LALT), KC_Z, KC_X)
	COMB(GUI_OS_OP, OSM(MOD_LGUI), KC_O, KC_P)

	COMB(RET_PLOVER, KC_ENT, KC_F, KC_J)

	# Real file location since gist doesn't allow pathing: ~/.config/pipewire/pipewire.conf.d/01-clock-rates.conf

	context.properties = {
	default.clock.rate = 48000
	default.clock.allowed-rates = [ 192000 96000 48000 44100 ]
	}

	tar cvpf - . \| pv \| nc -l -w 5 -p 9999

	tar cvpf - . \| pv \| netcat -l -w5 -p 9999

	netcat -w 5 -q 5 192.168.1.253 9999 \| pv \| tar xvpf -

	export GPG_PASSPHRASE="urpass"

	tar cvpf - . \| gpg --symmetric --cipher-algo AES256 --batch --passphrase "$GPG_PASSPHRASE" \| pv \| nc -l -w 5 -p 9999
	netcat -w 5 <ip> <port> \| pv \| gpg --decrypt --batch --passphrase <pass> \| tar xvpf -