Grant Pullen grantpullen

Setting Up a Python Virtual Environment (venv) on a Mac

Install Python (if not already installed)

Check if Python is installed:

python3 --version

CSS Selectors Cheatsheet

Element selectors

Element -- selects all h2 elements on the page

h2 {
    foo: bar;

Display live HTTP traffic to console on a specified port for all interfaces

tcpdump -A -i any 'port 1333 and (((ip[2:2] - ((ip[0]&0xf)<<2)) - ((tcp[12]&0xf0)>>2)) != 0)'

The example above captures all TCP traffic at port 133 and filter out the TCP session setup (SYN / FIN / ACK)

-A Print each packet (minus its link level header) in ASCII. Handy for capturing web pages.
-i any Include all interfaces
port 1333 Only look at TCP traffic to/from port 1333
(((ip[2:2] - ((ip[0]&0xf)<<2)) - ((tcp[12]&0xf0)>>2)) != 0) filter out the TCP session setup (SYN / FIN / ACK)

SMTP Ports and Troubleshooting in Go

SMTP Port Overview

Port 25: SMTP port 25 (RFC 821) is used for SMTP relay, where email is relayed email from email server to email server. This port is not supported by most modern email clients.
Port 465: Internet Assigned Numbers Authority (IANA), registered port 465 for SMTPS using SSL. The port was revoked a year later, and is not used by most modern mail servers since it's not RFC compliant.

Replace the IN with ANY

v := []string{"1", "2", "3", "4"}
id := 1
q := "UPDATE users SET deleted = true WHERE id = $1 and org_id = ANY($2::bigint[])"
in := "{" + strings.Join(v, ",") + "}"

res, err := Db.Exec(q, id, param)

Extract .aac Audio from multiple mp4 or mkv

DL avconv from https://libav.org/download/
extract e.g. assuming Windows in the folder c:\tools\avconv
execute commands in linux shell e.g. gitbash

 for i in *.mp4; do /c/tools/avconv/bin/avconv -i "$i" -acodec copy "${i/.mp4/.aac}"; done

SMSPP Delviery Reports and Kannel

This info page relates to the DLR values which are returned by kannel when requesting DLR. Some SMPP related information is also listed for reference.

dlr-mask

This [send-sms][1] parameter is used to request for delivery reports with the state of the sent message. This requires the [dlr-url][1] on sendsms-user group or use the dlr-url CGI variable to be set. The value is a bit mask composed of:

Value	Description

	0039.cf
	0039.ga
	0039.ml
	007addict.com
	00b2bcr51qv59xst2.cf
	00b2bcr51qv59xst2.ga
	00b2bcr51qv59xst2.ml
	020.co.uk
	02466.cf
	02466.ga

	set GOARCH=amd64
	set GOOS=linux
	set NOW=%date% %time%
	rem save the results from 'git describe --tags --dirty --always' to variable 'GINFO'
	for /f %%i in ('git describe --tags --dirty --always') do set GINFO=%%i
	rem set var GitInfo & var BuildDate in the go code
	go build -ldflags "-X 'main.GitInfo=%GINFO%' -X 'main.BuildDate=%NOW%'" -o ./bin/gw

	/* not it using @nebular, this must reside outside of @include nb-install-component() {..} */
	::ng-deep .modal-content {
	/* change border */
	border: none;
	/* change background */
	background-color: red !important;
	}