grep "error" error_log |awk -F[ {'print $4'} \
| sort | sed -e 's/]//g' | grep -v "/var/www/html/" \
| grep -v "/usr/local/src/code" | awk {'print $2'} \
| grep -v "75.142.246.205" |uniq | awk -F. {'print $1"."$2"."$3"/24"'} |uniq

114.80.93/24
119.63.193/24
124.115.0/24
205.234.253/24

SET @rank = 0, @prev_val = NULL;

SELECT rank, correct FROM (
SELECT @rank := IF(@prev_val=correct,@rank,@rank+1) AS rank,
@prev_val := correct AS correct, uid
FROM quiz_user ORDER BY correct DESC
)as result WHERE uid=xxxxxxxxxxxx

This is the python way of calculating the date that is 14 days ago.

import datetime
(datetime.datetime.now() - datetime.timedelta(days = 14)).date()

And this is pandas way of getting the same results:

import pandas as pd
(pd.datetime.today() - pd.offsets.Day(14)).floor('D')

Here are 5 commands to run docker on ARM processors:

sudo apt-get update
sudo apt-get upgrade
curl -fsSL get.docker.com -o get-docker.sh && sh get-docker.sh
sudo usermod -aG docker $USER
sudo docker run --rm -it -p 80:80 jasonrandrews/php-example

A docker wrapper for the Cloudmapper application, used for visualizing AWS infrastructure.

git clone https://github.com/sebastientaggart/docker-cloudmapper.git
cd docker-cloudmapper
Edit .env file and add your AWS key, secret, region, and account name.
docker-compose build (go get a cup of coffee)
docker-compose up -d

Go to http://localhost:8000 and enjoy!

enable Weekly Email Notification from the Trusted Advisor.

1) Open the AWS Management Console.
2) Go to the Trusted Advisor service.
3) Select Preferences from the sub-navigation.
4) Enable weekly email notifications.

from functools import partialmethod
pd.DataFrame.head = partialmethod(pd.DataFrame.head, n=3)

apt-get update && apt-get upgrade
mkdir -p /usr/share/man/man1
apt-get install default-jdk
apt install openjdk-11-jdk

1. Open the AWS SNS Management Console
2. Create and select a SNS topic
3. Click on Actions > Subscribe to Topic

4. Choose HTTPS as the protocol and set the endpint to:
https://api.marbot.io/v1/sns/ea5e

5. Configure your CloudWatch Alarms to send notifications to the SNS topic.

lsblk prints all block devices in a tree-like format.

lsblk
NAME    MAJ:MIN RM SIZE RO TYPE MOUNTPOINT
xvda    202:0    0   8G  0 disk
└─xvda1 202:1    0   8G  0 part /
xvdf    202:80   0  90G  0 disk

If file command on the disk identifier "xvdf" shows simply "data", then there is no file system on the device and you need to create one.

file -s /dev/xvdf
/dev/xvdf: data