peter279k

Install Remote Desktop (xRDP) for Ubuntu Server 18.04

Step 1 – Install xRDP:

sudo apt update
sudo apt install xrdp

Step 2 – Install XFCE4

sudo apt install xfce4

peter279k

• http://www.daniloaz.com/en/how-to-create-a-user-in-mysql-mariadb-and-grant-permissions-on-a-specific-database/
• https://stackoverflow.com/questions/22774739/change-mysql-user-password-using-command-line
• https://websiteforstudents.com/configure-remote-access-mysql-mariadb-databases/
• https://www.opencli.com/mysql/mysql-add-new-users-databases-privileges
• https://stackoverflow.com/questions/50177216/how-to-grant-all-privileges-to-root-user-in-mysql-8-0

MySQL V.S. PostgreSQL

• https://www.upguard.com/blog/postgresql-vs-mysql#database-constraint
• https://eng.uber.com/postgres-to-mysql-migration/

peter279k

#!/bin/bash

# References:
# https://www.mysterydata.com/update-apache-2-4-to-latest-version-on-ubuntu-16-04-server-vestacp/

sudo_prefix="sudo "

if [[ ${USER} == "root" ]]; then
  sudo_prefix=""
else

peter279k

# Copyright 2019-2022 Jonathan S. Katz
# 
# MIT License
#
# Permission is hereby granted, free of charge, to any person obtaining a copy
# of this software and associated documentation files (the "Software"), to deal
# in the Software without restriction, including without limitation the rights
# to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
# copies of the Software, and to permit persons to whom the Software is
# furnished to do so, subject to the following conditions:

peter279k

References

• https://www.postgresqltutorial.com/postgresql-backup-database/
• https://www.postgresqltutorial.com/postgresql-restore-database/
• https://stackoverflow.com/questions/6842393/import-sql-dump-into-postgresql-database

peter279k

Activating HTTP Public Key Pinning (HPKP) on Let's Encrypt

Source: https://lilleengen.io/blog/index.php/posts/activating-http-public-key-pinning-hpkp-on-lets-encrypt

• Disclaimer: This might break your website, don't preceded if you don't know what you're doing.

Since the letsencrypt seems to create a new private key every time the certificate is renewed and Let's Encrypt requires you to renew you certificate once every ~80 days pinning using your certificate's SPKI is probably not the way to go. So, what should we pin then? Let's Encrypt is currently issuing from Authority X3, and using Authority X4 as a backup, so these two is a great place to start. We should also include the ISRG Root so this might support new Authorities with other SPKIs as well.

Generate HASH of Private Keys

To generate the hash of the SPKI of these certificates run the following commands

peter279k

#!/bin/bash

# This bash script is referenced by https://www.hostinger.com/tutorials/how-to-install-docker-on-ubuntu
# Reference: https://docs.docker.com/engine/install/ubuntu/

echo 'Check your Linux Distribution....'

which lsb_release > /dev/null 2>&1

if [[ $? != 0 ]]; then

peter279k

Key-Type: 1
Key-Length: 2048
Subkey-Type: 1
Subkey-Length: 2048
Name-Real: Root Superuser
Name-Email: root@handbook.westarete.com
Expire-Date: 0

peter279k

#!/home/drspock/scripts/FBInvite/bin/python

import argparse
import requests
import pyquery

def login(session, email, password):
    
    '''
    Attempt to login to Facebook. Returns user ID, xs token and

peter279k

This Version Allow run as nobody AND ports below 1024

/etc/systemd/system/frps.service

Systems that has AmbientCapabilities support (usually kernel >= linux4.3)

[Unit]
Description=FRP Server Daemon