My fisrt Postmortem in tech
SSH connection error, this problem happened when I was doing project 0x14. MySQL for Holberton school.
The purpose of this project was to learn how to configure a master-slave database in two remote servers.
Issue Summary
Around 4:00 pm Time zone in Colombia (GMT-5) by following the tutorial I found at https://www.digitalocean.com/community/tutorials/how-to-set-up-master-slave-replication-in-mysql. I was doing this work on two remote servers. Once the procedure is finished and I disconnect from the servers, I wanted to do tests and cannot reconnect to the server, preventing me from being able to enter the server and be able to continue configuring and managing the database configured within it and perform other types of activities within the server.
Timeline Time zone in Colombia (GMT-5)
- 4:00 PM: Configuration Master-Slave databases begins
- 4:46 PM: Outage begins
- 4:56 PM: SSH error alert — no access to server
- 5:00 PM: Ask for a new server to the staff
- 5:15 PM: The configuration of the new server begins
- 5:45 PM: Set up Master Slave replication in MySQL begins
- 6:00 PM: It is verified that the ssh port has not been deactivated
- 6:10 PM: Restart servers and access them
Root cause and resolution
Around 4:00 PM the connection to the server via ssh was interrupted, when trying to access the error indicated that the ssh port was disabled. preventing any type of activity within them.
Once it was discovered that the lack of access to the server was due to the ssh port being disabled, the staff was asked for a new server to configure again, being a new server, they had to do all the basic configuration from the beginning, and enable all SSH, HTTP, HTTPS ports again and see the procedure to do the database configuration.
Corrective and preventative measures
The problem was due to the fact that when the HTTP and HTTPS ports were activated and the changes were saved, port 22 SSH was disabled and I did not realize it, so to avoid this type of error, every time ports are activated on the server Let’s check the status of the ports before closing the server, in case some are deactivated, re-activate them and thus avoid connection problems.
