/Bash-Scripts

This repository contains bash scripts designed to streamline common system administration tasks, including a powerful SQL database backup utility that seamlessly integrates with GitHub for robust data protection.

Primary LanguageShell

System Admin Scripts

This repository contains bash scripts designed to streamline common system administration tasks, including a powerful SQL database backup utility that seamlessly integrates with GitHub for robust data protection, and a script to set up a Flask web application with NGINX, a domain, and SSL/TLS on an Ubuntu VM.

SQL Database Backup to GitHub (gitsql.sh)

This script automates the process of backing up your MySQL database and securely uploading it to your designated GitHub repository.

How to Use

  1. Download: Copy the sql_to_git.sh script to your server.

  2. Provide Credentials: Update the script with the following information before running:

  • MySQL Username
  • MySQL Password
  • Database Name
  • GitHub Username
  • GitHub Personal Access Token (with 'repo' permissions)
  • Temporary Backup Directory
  1. Execute: Run the script using ./sql_to_git.sh.

Prerequisites:

Flask Application Setup Script (setup_flask.sh)

This script sets up a Flask web application with NGINX, a domain, and SSL/TLS on an Ubuntu VM.

How to Use

  1. Download: Copy the setup_flask.sh script to your Ubuntu VM.
  2. Make Executable: Run chmod +x setup_flask.sh.
  3. Execute: Run the script ./setup_flask.sh and follow the interactive prompts to enter your domain name, Flask app name, and the port number for your Flask app.

Prerequisites:

  • An Ubuntu VM with a non-root user with sudo privileges
  • A Flask application file with the same name as your app name (e.g., myapp.py)

What the Script Does:

  • Installs required packages: Python 3, venv, pip, NGINX, and Certbot.
  • Sets up a virtual environment for Flask and installs the Flask package.
  • Configures NGINX as a reverse proxy to forward requests to the Flask app.
  • Obtains an SSL/TLS certificate from Let's Encrypt for the specified domain.
  • Starts the Flask app on the specified port.

Development Server Setup Script (setup_dev_server.sh)

This script simplifies the process of preparing a newly created development server. It installs a comprehensive set of essential tools and packages, laying the foundation for various development workflows.

Key Features

Core Tools:** Installs build tools (e.g., build-essential), version control (Git), and utilities like cURL and Wget.

Language Environments:** Sets up common development environments like Python (with pip and venv), Java (JDK), and optionally Node.js.

Customization:** Designed with flexibility in mind, allowing for easy addition or removal of packages.

Menu-Driven:** Features a user-friendly menu for selecting specific installation categories or an option to install everything.

Usage

  1. Download: Copy the setup_dev_server.sh script to your new server.

  2. Execute: Run the script ./setup_dev_server.sh and follow the interactive menu.

Example Customization

To include PostgreSQL in the database options:

6) echo "Database Options (Choose one):"
echo " a. MySQL"
echo " b. PostgreSQL"
read -p "Enter your choice (a/b): " database_choice

if [[ $database_choice == "a" ]]; then
  install_package mysql-server
elif [[ $database_choice == "b" ]]; then
  install_package postgresql
else
  echo "Invalid database choice"
fi
;;

Contributing

We welcome contributions to expand this repository's utility for fellow system administrators. If you have a script you'd like to share, please follow the template below:

Script Name: (Name of your new script)

Description: (A concise explanation of what the script does)

Requirements: (List any specific dependencies for the script)

Usage Instructions: (Clear steps on how to use the script)

Disclaimer

While these scripts are designed to be helpful, always exercise caution when performing system administration tasks. Thoroughly test scripts in a non-production environment before deployment.