You will need the KeePass database file and .ppk files. To get the files, please connect with Charlie Fullford.

Download and install KeePass to open the provided database file. Contact Charlie Fullford for the database password.

To access the Safety Training server, you need to install PuTTY. You can download it here. After the installation, launch the background application Pageant. You can find it in the hidden icons option of the windows taskbar at the bottom right of your screen.

Expand the hidden icons and right click on the Pageant icon and select add key.

Locate the .ppk file and type in the passphrase that you can find in the KeePass database. After adding the key, open PuTTY and follow the steps below:

1. In Session, use the server IP address and port number in KeePass.
2. Navigate to Connection > Data and add the username in KeePass.
3. Go back to Session and type a name for Saved Sessions. I suggest using the Rackspace server name for easy identification.
4. Press save.

To establish a server connection, select the session name then click load. After it loads the session data, click open. For first-time connections, a prompt will appear and will ask you to add it to known hosts. Agree to continue.

To easily access the database, use MySQL Workbench. You need to download a specific version that supports the MySQL server running in the Rackspace cloud. The latest version I recommend downloading is v6.3.10.

Open MySQL Workbench after installation and create a new connection. Follow the steps below for the connection details:

1.  Type in a connection name, I suggest using the Rackspace server name.
2. Select Standard TCP/IP over SSH as the connection type.
3. In the parameters tab, type the IP address and port number of the server. Use the same IP address and port number used in the SSH Access section and follow the default value formatting.
4. Use the same username in SSH Access.
5. Locate the .ppk file with openssh in the file name.
6. Use the default values for MySQL Host Name and Server Port.
7. Use the MySQL username in KeePass.
8. Test the connection and enter the password from KeePass when prompted.

Install the VSCode editor and add the SSH FS extension. Please follow the extension guide on how to create a config file.

In the SSH FS config file, set the follow values.

• Name : safetytraining
• PuTTy : <Auto-detect>
• Host : Server IP
• Port : SSH server port
• Root : /home/www/project_files
• Agent : pageant
• Username : www

If set correctly, you can now access the project files directly in VSCode.