These steps are to set up an ssh client

so tom can have a simple desktop shortcut to cause the database to sync from production to dev.

These steps assume the IP you are connecting from is allowed to connect to the server in the first place.

Go to: https://www.chiark.greenend.org.uk/~sgtatham/putty/latest.html

Direct Download:

https://the.earth.li/~sgtatham/putty/latest/w64/putty-64bit-0.76-installer.msi

When installing, be sure “Put install directory on the PATH…” is enabled.

1. Enter cpanel.beacontechnology.com where it says Host Name
2. Where it says Saved Sessions, enter a name to know this server by. Using the hostname is fine.
3. Click Save

To connect to a server, just select a session in the list and click Open.

The first time you connect to a server, you will have to click Accept to acknowledge that you recognize the server fingerprint.

Key Based authentication allows the user to log in with a key rather than a password. This is more secure and allows unprompted access to the server.

Open PuTTYgen

1. At the bottom of the window, select “ECDSA” 2. click generate. 3. move the mouse around until it is done. 4. Where it says “Key comment:” paste in “dev.beacontechnology.com” without quotes 5. click save private key. Select yes without a password. 6. Where it says “File name” paste without quotes userprofile_dev.beacontechnology.com.ppk 7. Click Save 8. In the big box where it says “Public key for pasting into…” Copy everything in that box and email it to us. (click in the big box, then press control+a to copy all then press control+c to copy) 9. You can now close this window

When we get the key, we will install it into the file located at: “/home/tom/.ssh/authorized_keys” This will permit anyone with the matching private key to log in.

After that is done, we need to create the shortcut to sync the databases.

1. On an empty space on the desktop, right click New > Shortcut 2. Type the location of the item: pageant.exe “%UserProfile%\dev.beacontechnology.com.ppk” -c plink.exe -ssh -batch tom@dev.beacontechnology.com “sudo /root/scripts/beaconsync.sh” 3. Click next 4. Type a Name for this shortcut: BeaconSync 5. Finish

You can now just open this shortcut to sync the databases