Connor Ameres cameres

WOL with tp-link TG-3468 on Ubuntu 18.04.3

I'm putting this here for my own reference because I was up way too late figuring this out.

After installing the network card, I could see I already had the right driver for it. sudo lshw -c network showed that the card was disabled though. What ended up getting the card working was the following which I recorded here:

sudo ip l s dev enp6s0 up

Create Root CA (Done once)

Create Root Key

Attention: this is the key used to sign the certificate requests, anyone holding this can sign certificates on your behalf. So keep it in a safe place!

openssl genrsa -des3 -out rootCA.key 4096

Docker - How to cleanup (unused) resources

Once in a while, you may need to cleanup resources (containers, volumes, images, networks) ...

delete volumes

// see: https://github.com/chadoe/docker-cleanup-volumes

$ docker volume rm $(docker volume ls -qf dangling=true)

$ docker volume ls -qf dangling=true | xargs -r docker volume rm

Common Options

-#, --progress-bar Make curl display a simple progress bar instead of the more informational standard meter.

-b, --cookie <name=data> Supply cookie with request. If no =, then specifies the cookie file to use (see -c).

-c, --cookie-jar <file name> File to save response cookies to.

Spotify has heaps of genres but there not surfaced in the UI. Here's 1383 (perhaps all) of them.

Search for genre:"Genre Name"

A Cappella
Abstract
Abstract Beats
Abstract Hip Hop
Abstract Idm
Abstractro

distinct column -> For each row returned, return only the unique members of a set. Think of it as for each row in a projection, concatenate all the column values and return only the strings that are unique.

test_db=# SELECT DISTINCT parent_id, child_id, id FROM test.foo_table ORDER BY parent_id, child_id, id LIMIT 10;
parent_id | child_id | id
-----------+------------+-----------------------------
1000040 | 103 | 1000040|2645405726|0001|103

	#!/bin/bash

	# This installs alacritty terminal on ubuntu (https://github.com/jwilm/alacritty)
	# You have to have rust/cargo installed for this to work

	# Install required tools
	sudo apt-get install -y cmake libfreetype6-dev libfontconfig1-dev xclip

	# Download, compile and install Alacritty
	git clone https://github.com/jwilm/alacritty

	---
	- hosts: all
	tasks:
	- name: Install prerequisites for Docker repository
	apt:
	name: ['apt-transport-https', 'ca-certificates', 'curl', 'gnupg2', 'software-properties-common']
	update_cache: yes

	- name: Add Docker GPG key
	apt_key:

	# Linux
	# add the following to "~/.gitconfig" file

	[merge]
	tool = intellij
	[mergetool "intellij"]
	cmd = /usr/local/bin/idea merge $(cd $(dirname "$LOCAL") && pwd)/$(basename "$LOCAL") $(cd $(dirname "$REMOTE") && pwd)/$(basename "$REMOTE") $(cd $(dirname "$BASE") && pwd)/$(basename "$BASE") $(cd $(dirname "$MERGED") && pwd)/$(basename "$MERGED")
	trustExitCode = true

	[diff]