rolfen

let getElement, crawlDom, getCats, save, rowify; // functions
let urlBase, pages; // input data

// config
let waitInterval = 500; // how much to wait between fetching pages

// selectors
let catRe = /\{\s*productcategories\s*\:\s*(\[\s*\{[\s\S]*\}\s*\])\s*\}/m;
let selectors = {
	'name'	: '#showroomTopContentDiv .showroom-header h1',

rolfen

#!/bin/bash

# Import and organize into subfolders by date taken (YYYY/MM/DD)

scriptname=`basename "$0"`

if [[ $# -ne 2 ]]; then
    echo "Usage: $scriptname /source/dir /archive/dir"
else
	(cd "$2"; exiftool -progress -ext MTS -ext ARW -ext ORF -ext xmp -r -m -d %Y/%m/%d "-Directory<DateTimeOriginal" "$1")

rolfen

This

find -type f -exec mv {} ./ \;

turns this

/folder

rolfen

This little script resumes an interrupted dd copy at a given offset.

Before resuming, it rolls back (the amount of roll-back is OVERLAP_SIZE * CHUNK) then calculate the checksum of the overlap on both files to make sure that they are valid images of each other.

The checksums have to be checked manually by the operator (todo: automate).

rolfen

Setting up multiple user write permission to WWW directory

addgroup www-admin
adduser joe
adduser www-admin joe
setfacl -R -m g:www-admin:rwx /var/www
setfacl -R -m -d g:www-admin:rwx /var/www
chmod -R g+s /var/www

rolfen

Warning These are for educative purposes (examples, tips, etc.). Do not blindly execute them.

Fix double separator in hash-file (double or more space -> single space)

cat meta/hash-file.list | sed -E 's/^(\S+)\s{2,}(\S.+)$/\1 \2/'

Fix windows newlines in file

rolfen

You will need to connect your phone first, using USB.

With the USB cable:

adb tcpip 5555

Find out the IP address of your phone

rolfen

De	En
störrischer	stubborn
bemühunngen	efforts
vorübergehend	temporarily
verdrangen	to displace
Einschätzung	assessment
fällig	due
Gegenstand	object
Reichweite	reach

rolfen

Follow this:

https://thomas-leister.de/en/mailserver-debian-stretch/

Notes: See this section DKIM is a single domain setup. For multiple domains we need multiple DKIM keys. In /etc/rspamd/local.d/dkim_signing.conf, we would rather need something like this (source):

path = "/var/lib/rspamd/dkim/$domain.$selector.key";

rolfen

Exporting multiple blobs from an SQL database.

This is tested for MySQL with Linux or OSX

I was in a situation where I had images saved into an SQL table, as "blobs" and needed to export them into proper jpg files.

This relies on the SQL syntax SELECT INTO DUMPFILE. However this command can only export one row at a time.

1. Get the IDs of the rows we want to export