The following fixed the issue on AWS EC2:

unset PYTHON_INSTALL_LAYOUT

/root/.local/share/letsencrypt/bin/pip install --upgrade certbot

mysql -h hostname.com -u user -p dbname --execute="select DISTINCT(column_name) from tablename" > file.txt

Get current timezone:

SELECT @@global.time_zone;

Set new timezone:

SET GLOBAL time_zone = 'Europe/Helsinki';

1. Check the nginx stub_status_module is enabled:

nginx -V 2>&1 | grep -o with-http_stub_status_module

This should result in:

with-http_stub_status_module

If not, install nginx with stub_status_module enabled.

2. Add the following code to the server block:

server {
listen 80 default_server;
# Define the document root of the server e.g /var/www/html
root /var/www/html;
location /nginx_status {
# Enable Nginx stats
stub_status on;
# Only allow access from your IP e.g 1.1.1.1 or localhost #
allow 127.0.0.1;
allow 1.1.1.1
# Other request should be denied
deny all;
}

*Set allow IP to the sources you need access from*

3. Browse to http(s)://example.com/nginx_status

Credit goes to – https://www.keycdn.com/support/nginx-status/

HSTS is enforced by the web server. To proceed to the website regardless carry out the following:

1: Go to chrome://net-internals/#hsts

2: Search domain under “Query domain” and lookout for the information from the cache.

3: To clear the cache of a domain, you need to delete the domain under “Delete domain” heading.

4: Website now accessible

Credit goes to https://techglimpse.com/chrome-https-website-hsts-failed/