Eugene Selivanov glavk

Common FastCGI Errors involving PHP-FPM

504 Gateway Timeout

upstream timed out (110: Connection timed out) while reading response header from upstream

Means NGINX timed out reading the HTTP response header from upstream. This

GeoIP Block NGINX Ubuntu 20.04

Block or filter IPs based on location in Nginx (tested on 1.18.0) on Ubuntu 20.04.

Install Nginx modules

To make use of the geographical filtering, we must first install the Nginx GeoIP module as well as the GeoIP database containing the mappings between visitors’ IP addresses and their respective countries. To do so, let’s execute:

$ sudo apt install libnginx-mod-http-geoip geoip-database

Backup MySQL to Amazon S3

This is a simple way to backup your MySQL tables to Amazon S3 for a nightly backup - this is all to be done on your server :-)

Sister Document - Restore MySQL from Amazon S3 - read that next

1 - Install s3cmd

this is for Centos 5.6, see http://s3tools.org/repositories for other systems like ubuntu etc

tmux cheat sheet

(C-x means ctrl+x, M-x means alt+x)

Prefix key

The default prefix is C-b. If you (or your muscle memory) prefer C-a, you need to add this to ~/.tmux.conf:

remap prefix to Control + a

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.

	#!/bin/bash

	# You need to uncomment two lines for the script work.
	# Please check the logic before use it.

	main () {
	#aws s3 ls $BUCKETNAME \| grep -v ' PRE ' \| grep -v ' 0 ' > data.txt
	UNIXDAYS=$(date -d "$DAYS days ago" +%s)
	while read LINE
	do

	log_format postdata '$time_local $request $request_body';

	location = /path {
	access_log /var/log/nginx/postdata.log postdata;
	proxy_pass http://localhost:8080; # <= set your port
	}