Sam-R

#!/bin/bash

OUTPUT_DIR=/root
BACKUP_USER=backupuser
BACKUP_DIR=/home/backupuser/

# Identify the databases on this server
databases=$(mysql -s -r -N -e 'show databases where `Database` not in("information_schema", "performance_schema", "accounts", "mysql", "sys")')

for database in $databases; do

Sam-R

cat /etc/hosts | grep -Eo '[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}' | awk '{ print $1 }'

Sam-R

<?php

// Webpage to load
$url = "https://uk.trustpilot.com/review/your-page-here";

// Contents of webpage
$contents = file_get_contents($url);

// Declair a new DOM
$doc = new DOMDocument('1.0', 'UTF-8');

Sam-R

Create a basic PHP and nginx container pair, mounting their local working directory.

docker-compose.yml

version: '3'

services:
    nginx:

Sam-R

Ansible notes

plays

tasks actions to take inside a play

registers capture output from a task

handlers handle errors and can execute an action

Sam-R

mailq | \
  grep -E "Connection (refused|timed out)" -B1 | \
  grep -E "^[A-Z0-9]{11}\s+" | \
  awk '{print $1}' | \
  postsuper -d -

Sam-R

mailq | \
  grep -E "Connection (refused|timed out)" -B1 | \
  grep -E "^[A-Z0-9]{10}\s+" | \
  awk '{print $1}' | \
  postsuper -d -

Sam-R

grep -v -F -x -f file_sorted.csv file2_sorted.csv

Sam-R

MySQL

Create a MySQL instance in a docker container that's bound to the hosts standard MySQL ports. This is useful if you're developing locally without a docker-compose enviornment and don't want to run MySQL on your local or virtual machine.

sudo docker run --name mysql5 -e MYSQL_ROOT_PASSWORD=toor -P 3306:3306 -d mysql:5

You should be able to connect to the server using root and toor as credentials.

Sam-R

sudo nano /etc/fail2ban/filter.d/nextcloud.conf

[Definition]
failregex=^{"reqId":".*","remoteAddr":".*","app":"core","message":"Login failed: '.*' \(Remote IP: '<HOST>'\)","level":2,"time":".*"}$
	^{"reqId":".*","level":2,"time":".*","remoteAddr":".*","app":"core".*","message":"Login failed: '.*' \(Remote IP: '<HOST>'\)".*}$
	^.*\"remoteAddr\":\"<HOST>\".*Trusted domain error.*$