Support Guides

VPS Guides

Guides for Virtual Private Server users, covering control panel installation, CLI usage, and server management.

How to connect to PostgreSQL with psql

Connect to the server over Secure Shell (SSH), then run sudo -u postgres psql followed by the database name. Type \conninfo at the psql prompt to confirm which database and user you are connected as. Commands such as \dt, which lists tables, start with a…

How to connect to MySQL remotely using an SSH tunnel

In PuTTY, expand the Secure Shell (SSH) category, click Tunnels, enter 3307 as the source port and localhost:3306 as the destination, then click Add. Open the PuTTY session, then point your MySQL client at localhost on port 3307 with your usual database…

How to run a traceroute to diagnose network issues

On Windows, open Command Prompt and run tracert followed by a domain or IP address, such as tracert google.co.uk. On a Mac or Linux, run traceroute with the destination in Terminal. Each output line is one router hop with three round-trip times in…

How to install Docker Compose on Linux

Download the Docker Compose binary from GitHub with curl into /usr/local/bin/docker-compose, then run chmod +x on it to make it executable. Alternatively, install it through Python's package manager with pip3 install docker-compose. Either way, docker-compose…

How to install Yarn on Linux

Run sudo npm install -g yarn to install Yarn globally on a Linux system that already has Node.js. Without npm, fetch the official Yarn install script with cURL, pipe it to bash and reload your shell with source ~/.bashrc. Running yarn --version confirms the…

How to check file ownership in Linux

Run ls -la filename and read the third column for the owner and the fourth for the group. For more detail, stat filename shows the owner and group alongside their numeric user and group IDs and the file's timestamps. Access Control Lists can grant extra…

How to secure your VPS

Patch the server first, running dnf update -y for AlmaLinux packages and the control panel's own updater. Switch Secure Shell (SSH) to key-only logins and move it off port 22. Add a firewall: ConfigServer Security & Firewall on cPanel servers, or Fail2Ban on…

How to install the MERN stack on AlmaLinux

The MERN stack is MongoDB, Express, React and Node.js. On AlmaLinux, update packages with dnf update -y and allow HTTP and HTTPS through firewall-cmd. Install Node.js from the NodeSource repository, then add the official MongoDB 7.0 repository and install…

How to install a LEMP stack on AlmaLinux

On AlmaLinux 8, open HTTP and HTTPS with firewall-cmd, then install NGINX, MariaDB and PHP 8.2 using dnf module enable and dnf install. A LEMP stack is Linux, NGINX, MariaDB and PHP working together. Run mysql_secure_installation to set a MariaDB root…

How to install LAMP stack on AlmaLinux

Update packages with dnf update, then allow HTTP and HTTPS through the firewall with firewall-cmd and reload it. Install Apache with dnf install httpd and start it with systemctl. Install MySQL with dnf install mysql mysql-server, then secure it with…