# Server and database

The server is hosted on Amazon Web Services (AWS).
The database is hosted on the server itself.

A backup of the database is done every 2 hours and saved for a period of 7 days

# Restart the server

• Sign in to AWS console with the credentials given in the Credentials.txt file
• Go to the EC2 service > Running instances
• Right click on Production > Instance State > Reboot

# Connect to the server by SSH

• Download Putty
• Download aws-putty.ppk

Negoti8or > SSH Keys > aws-putty.ppk

• Open Putty
• Set the hostname

13.236.252.168

• Leave the port to 22

• Go to the auth section

Connection > SSH > Auth

• Click on Private key file for authentication and select the aws-putty.ppk

• Click on the Open button in the bottom right corner

• When the server is asking you for a user, put forge

• Congrats! You are now connected to the server

# Restore a backup version of the database

• Connect to the server by SSH
• Type the following commands

# Change the date (YYYY-MM-DD)
cd backups/2018-10-30

# Change the time (H:m:s)
# You will need to enter the Sudo password included in the Credentials file
# Do not forget the backslash!!
sudo gunzip 04\:00\:01.sql.gz

mys -e "drop database negoti8or; create database negoti8or;"

mys negoti8or < 04\:00\:01.sql

# Apply Changes to the Negoti8or Server

• Connect to the server by SSH
• Type the following commands

# Run the deployment script
cd /home/forge

./deployment.sh