groundcat

## Full-Screen-iFrame
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title>Home</title>
<style>
body{
  margin:0;
  padding:0;
  overflow-y:hidden

## Import CSV to MySQL by PHP
<?php

// Debug

error_reporting(E_ALL);
ini_set('display_errors', 1);

// Connect

$conn = mysqli_connect("IP", "USERNAME", "PASSWORD", "DBNAME");

## Fix-Debian-8-apt-sources.list.md

      
              1 file
            
          
              0 forks
            
          
                0 comments
              
            
              0 stars
            
          
                groundcat
                / Fix-Debian-8-apt-sources.list.md
            
            
              Last active
              August 23, 2019 20:37
            
              
                Fix Debian 8 sources.list and 404 issues
              
          
    Edit sources.list
nano /etc/apt/sources.list

Replace it with:
deb http://ftp.debian.org/debian jessie main contrib
deb http://ftp.debian.org/debian jessie-updates main contrib
deb http://security.debian.org jessie/updates main contrib


## cloudflared-install.md

      
              1 file
            
          
              0 forks
            
          
                0 comments
              
            
              0 stars
            
          
                groundcat
                / cloudflared-install.md
            
            
              Last active
              October 21, 2019 03:39
            
              
                DNS over HTTPS for MacOS
              
          
    Install Cloudflared

Install via Terminal:
curl https://bin.equinox.io/c/VdrWdbjqyF/cloudflared-stable-darwin-amd64.tgz | tar xzC /usr/local/bin

Create and edit  /usr/local/etc/cloudflared/config.yml

  
## keep-rclone-running.md

      
              1 file
            
          
              0 forks
            
          
                0 comments
              
            
              0 stars
            
          
                groundcat
                / keep-rclone-running.md
            
            
              Last active
              May 16, 2020 02:31
            
              
                Keep rclone running with cronjob
              
          
    Install rclone:
curl https://rclone.org/install.sh | sudo bash

Configure rclone remote:
rclone config


## Allows Read and Write Access to S3 Bucket.md

      
              1 file
            
          
              0 forks
            
          
                0 comments
              
            
              0 stars
            
          
                groundcat
                / Allows Read and Write Access to S3 Bucket.md
            
            
              Created
              July 18, 2020 21:21
            
              
                IAM Users - Allows Read and Write Access to S3 Bucket
              
          
    Step 1. Create IAM user

https://console.aws.amazon.com/iam/home#/users
For example, user is arn:aws:iam::AccountA-ID:user/Dave.
Step 2. Create IAM user policy

Add as JSON, under permission tab:

  
## Optimize_Oracle_Cloud_VPS.md

      
              1 file
            
          
              0 forks
            
          
                0 comments
              
            
              1 star
            
          
                groundcat
                / Optimize_Oracle_Cloud_VPS.md
            
            
              Created
              May 27, 2021 04:04
            
              
                Optimize Oracle Cloud VPS
              
          
    Ubuntu iptables

The Oracle Cloud Ubuntu images come with somewhat restrictive iptables rules by default. Docker manages the instance firewall and we have the Oracle Cloud firewall in front, so let's remove the current firewall to avoid trouble:
apt purge netfilter-persistent iptables-persistent

Remove useless stuff (optional)


## hardern-ssh.md

      
              1 file
            
          
              0 forks
            
          
                0 comments
              
            
              0 stars
            
          
                groundcat
                / hardern-ssh.md
            
            
              Last active
              March 10, 2022 05:32
            
              
                Harden the SSHD login and configuration
              
          
    Create the user, replacing example_user with your desired username. You’ll then be asked to assign the user a password:
adduser ubuntu

Add the user to the sudo group so you’ll have administrative privileges:


## swap.sh
#!/usr/bin/env bash
#Blog:https://www.moerats.com/

Green="\033[32m"
Font="\033[0m"
Red="\033[31m"

#root权限
root_need(){
    if [[ $EUID -ne 0 ]]; then

## block-country-ip.sh
#! /bin/bash
#Block-IPs-from-countries
#Github:https://github.com/iiiiiii1/Block-IPs-from-countries
#Blog:https://www.moerats.com/

Green="\033[32m"
Font="\033[0m"

#root权限
root_need(){
	<!DOCTYPE html>
	<html>
	<head>
	<meta charset="utf-8">
	<title>Home</title>
	<style>
	body{
	margin:0;
	padding:0;
	overflow-y:hidden
	<?php

	// Debug

	error_reporting(E_ALL);
	ini_set('display_errors', 1);

	// Connect

	$conn = mysqli_connect("IP", "USERNAME", "PASSWORD", "DBNAME");
	#!/usr/bin/env bash
	#Blog:https://www.moerats.com/

	Green="\033[32m"
	Font="\033[0m"
	Red="\033[31m"

	#root权限
	root_need(){
	if [[ $EUID -ne 0 ]]; then
	#! /bin/bash
	#Block-IPs-from-countries
	#Github:https://github.com/iiiiiii1/Block-IPs-from-countries
	#Blog:https://www.moerats.com/

	Green="\033[32m"
	Font="\033[0m"

	#root权限
	root_need(){