| summary | Connection ManagerIf you want to connect easily to one of our databases, this is the tool for you. Primarily, Most of the information required can be found in the README of each the respective project, but there are a few steps required before this will workhere you will find details of a few things that aren't covered. Before You StartYou will need to make sure you have poetry installed on your system to allow you to use the connection manager and the key manager. It's also worth considering the fact that the connection manager is written in and tested in python 3.11. It may very well be backwards compatible, but right now that is not guaranteed. Furthermore, it also uses SQLAlchemy ^V2.0 meaning if you try and use any of the models that require 1.4 poetry will run into a dependency conflict. First StepsIf you navigate to R:\Connection Manager on the shared drives, you should see a folder with your name on it. This will be where you your copy of the database credentials live. If not, then you need to contact Michael and ask him to create you one. Once you have confirmed you have a folder ready to go, you need to clone the rr-key-manager. RR-Key-ManagerThe rr-key-manager is a tool for populating a keepassx file with the required server and database credentials for connecting to connect to our the servers. To begin, you can follow the instruction in the repo to clone the repo locally and open it in a text editor. Inside the function called main, you will see a list of servers. You need to add the name of the servers you want to be able to connect to here the list before you run itthe script. The names you put here must match those as provided in the systems keepass found at R:\Connection\systems which you can open using keepassx. Some of the most common ones will be UKRDC🗝️ ukrdc_live 🗝️ ukrdc_staging 🗝️ ukrdc_dev Radar🗝️ radar_live 🗝️ radar_staging RR🗝️ renalreg_live SSH KeysAs part of the process of using the rr-key-manager it will check to see if you have SSH keys present and if not it will create some. These keys will need adding to any server you wish to connect to. Currently, there is no automated way to do this however the process for adding a key to a server isSSH into the server you want to add keys to as root using the password found in the systems keepass using the root user.Change directory into .ssh and open the authorized_keys file using vim.Copy and paste your key from the id_rsa.pub file on your local system, save and exit the file, then exit the SSH session.Test that it was successful by attempting to reconnect. If you are not asked for a password, you were successful. If 😏If you have read all that and have no idea what any of it means, you might be best off dropping Andy a line and asking for a hand. Connection WizardryIf you have completed all the earlier steps, you should find that, as if by magic, connection manager should connect connects you to the servers you have added keys toserver of your choosing, provided you added it with the rr_key_manager. It is worth reading the full description on the repos README, but for your convenience there is a built-in connection test which you can use as follows. |
|---|
| page | {"name":"page","children":[{"id":"aZRmFOXpD3EomGMVVvfqc","params":{"background":{"light":"#ffffff","dark":"#1d2125"},"padding":20,"gap":10},"children":[{"id":"FKvhWz0r9Hn7JZFMsQ16U","name":"row","children":[{"id":"9f-aFTBWNOcMMeJGDS7oq","name":"column","children":[{"name":"image","params":{"templateId":"full-width","alignment":"center","position":"center center","borderRadius":{"all":0,"bbl":0,"bbr":0,"btl":0,"btr":0,"isIndividualCorners":false},"image":{"value":"att2615771137","target":"_blank","type":"attachment"},"width":370,"height":185},"children":[],"id":"5_Rim65enwZ1eqYmGLtne"}],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"O1juLYOxV5I_EEOFcEVuG","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"hmAabHUrdxFd08opVToQS","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"QX1KboA0oU5GkfkHK_i9Q","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"8AgmqvDifaQ9hs3s3b_zV","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"MfBG3kNo1Ys8XMqZKWB2L","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}}],"params":{"layout":[1],"gap":10,"minHeight":100,"padding":10,"borderRadius":0}},{"id":"MWC4BH0FWQDxjmd1irbMK","name":"row","children":[{"id":"3dC8m0ZwcI9V6esgXI9i9","name":"column","children":[{"name":"text","params":{"templateId":"headline and paragraph","value":[{"type":"paragraph","children":[{"type":"paragraph","children":[{"type":"paragraph","children":[{"text":"Connection Manager","fontWeight":700,"letterSpacing":-1,"lineHeight":"unset","fontSize":32,"fontFamily":"Poppins, sans-serif"}],"align":"center"}]},{"type":"paragraph","children":[{"text":"","fontSize":16,"lineHeight":"24px","color":"#555","letterSpacing":0,"fontFamily":"Open Sans, sans-serif"}]},{"type":"paragraph","children":[{"type":"paragraph","children":[{"fontSize":16,"lineHeight":"24px","color":"#555","letterSpacing":0,"text":"If you want to connect easily to one of our databases, this is the tool for you. Primarily, Most of the information required can be found in the README of each the respective project, but there are a few steps required before this will workhere you will find details of a few things that aren't covered.","fontFamily":"Poppins, sans-serif"}],"align":"center"},{"type":"paragraph","align":"center","children":[{"fontSize":16,"lineHeight":"24px","color":"#555","letterSpacing":0,"fontFamily":"Poppins, sans-serif","text":""}]},{"type":"paragraph","children":[{"type":"paragraph","align":"center","children":[{"fontSize":16,"lineHeight":"24px","color":"#555","letterSpacing":0,"fontFamily":"Poppins, sans-serif","text":""}]}]}]}]}]},"children":[],"id":"oYn2fn0g2IxgVoOo1Dd-i"}],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"o4Uv4bmc6V5DoFDD9ktNE","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"EjqR0d1qGxlRPuVC9A5Sb","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"C-FfFSuNOFuHRGMw7tMrW","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"HdgOfTISxCKK93NA7Yr9y","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"gzneaTFOjaTp9HJFzB0VK","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}}],"params":{"layout":[1],"gap":10,"minHeight":200,"padding":10,"borderRadius":0}},{"id":"Ba47T0TRdbf6q0LUo8yF3","name":"row","children":[{"id":"tdood_-RZ5ArpYwcmXNaj","name":"column","children":[{"name":"text","params":{"templateId":"simple paragraph","value":[{"type":"paragraph","children":[{"type":"paragraph","children":[{"type":"paragraph","children":[{"text":"Before You Start","fontWeight":700,"letterSpacing":-1,"lineHeight":"unset","fontSize":32,"fontFamily":"Poppins, sans-serif"}]}]},{"type":"paragraph","children":[{"fontSize":16,"lineHeight":"24px","color":"#555","letterSpacing":0,"fontFamily":"Poppins, sans-serif","text":""}]},{"type":"paragraph","align":"left","children":[{"fontSize":16,"lineHeight":"24px","color":"#555","letterSpacing":0,"fontFamily":"Poppins, sans-serif","text":"You will need to make sure you have poetry installed on your system to allow you to use the connection manager and the key manager. It's also worth considering the fact that the connection manager is written in and tested in python 3.11. It may very well be backwards compatible, but right now that is not guaranteed. Furthermore, it also uses SQLAlchemy ^V2.0 meaning if you try and use any of the models that require 1.4 poetry will run into a dependency conflict."}]}]}]},"children":[],"id":"d16zhVOt6TkvskOSJ15nG"},{"name":"divider","params":{"templateId":"solid long","color":{"light":"#000000","dark":"#ffffff"},"alignment":"start","fontSize":24,"fontColor":{"light":"#000000","dark":"#ffffff"},"height":1,"borderStyle":"solid"},"children":[],"id":"Zn9eLvBA7n2yXP9Z89gUU"}],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"pH-Xwl4Z-LRbfV1149KAs","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"lJbR-fGAp2tZxknCNMrdJ","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"BKmXYeE70OIkKgR8esWsE","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"yqw8Y8jEDP6YZBbWfGpCe","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"J2k34chDp06N1CJNhQG6j","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}}],"params":{"layout":[1],"gap":100,"minHeight":100,"padding":10,"borderRadius":0,"size":"full"}},{"id":"jkQMugMWLNdIwjGr-Bnv5","name":"row","children":[{"id":"RA1ErDF2qfZ7OyL4bi354","name":"column","children":[{"name":"text","params":{"templateId":"simple paragraph","value":[{"type":"paragraph","children":[{"type":"paragraph","children":[{"type":"paragraph","children":[{"type":"paragraph","children":[{"type":"paragraph","children":[{"text":"First Steps","fontWeight":700,"letterSpacing":-1,"lineHeight":"unset","fontSize":32,"fontFamily":"Poppins, sans-serif"}]}]},{"type":"paragraph","children":[{"fontSize":16,"lineHeight":"24px","color":"#555","letterSpacing":0,"fontFamily":"Poppins, sans-serif","text":""}]},{"type":"paragraph","align":"left","children":[{"fontSize":16,"lineHeight":"24px","color":"#555","letterSpacing":0,"fontFamily":"Poppins, sans-serif","text":"If you navigate to R:\\Connection Manager on the shared drives, you should see a folder with your name on it. This will be where you your copy of the database credentials live. If not, then you need to contact "},{"type":"link","link":{"value":"michael.ruston@ukkidney.org","target":"_blank","type":"mail"},"children":[{"fontSize":16,"lineHeight":"24px","letterSpacing":0,"fontFamily":"Poppins, sans-serif","text":"Michael","color":"#0091FF","underline":true}]},{"fontSize":16,"lineHeight":"24px","color":"#555","letterSpacing":0,"fontFamily":"Poppins, sans-serif","text":" and ask him to create you one. Once you have confirmed you have a folder ready to go, you need to clone the "},{"type":"link","link":{"value":"https://github.com/renalreg/rr-key-manager","target":"_blank","type":"link"},"children":[{"fontSize":16,"lineHeight":"24px","letterSpacing":0,"fontFamily":"Poppins, sans-serif","text":"rr-key-manager","color":"#0091FF","underline":true}]},{"fontSize":16,"lineHeight":"24px","color":"#555","letterSpacing":0,"fontFamily":"Poppins, sans-serif","text":"."}]}]}]}]}]},"children":[],"id":"geg_iDJx3zOuJHC7Q_BJk"},{"name":"divider","params":{"templateId":"solid long","color":{"light":"#000000","dark":"#ffffff"},"alignment":"start","fontSize":24,"fontColor":{"light":"#000000","dark":"#ffffff"},"height":1,"borderStyle":"solid"},"children":[],"id":"H1g3DR0q42--7w3vhQiFa"}],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"Nbi0ZKyX1YsFNW_B9pBxe","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"UlGi0Ju4AaYn66AaaDF1T","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"WzJUPgGzrsdJooEyrS-gW","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"OZY-jkkcV4qE32g6dxxSe","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"1LnGGhQRT6zCdC5GP0gTF","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}}],"params":{"layout":[1],"gap":100,"minHeight":1,"padding":10,"borderRadius":0,"size":"full"}},{"id":"t-gTipArDQVJ24lsiWKJq","name":"row","children":[{"id":"nQmq5k774D7TU5zLiv57D","name":"column","children":[{"name":"text","params":{"templateId":"headline and paragraph","value":[{"type":"paragraph","children":[{"type":"paragraph","children":[{"type":"paragraph","children":[{"type":"paragraph","children":[{"type":"paragraph","children":[{"type":"paragraph","children":[{"text":"RR-Key-Manager","fontWeight":700,"letterSpacing":-1,"lineHeight":"unset","fontSize":32,"fontFamily":"Poppins, sans-serif"}]}]},{"type":"paragraph","children":[{"fontSize":16,"lineHeight":"24px","color":"#555","letterSpacing":0,"fontFamily":"Poppins, sans-serif","text":""}]},{"type":"paragraph","align":"left","children":[{"fontSize":16,"lineHeight":"24px","color":"#555","letterSpacing":0,"fontFamily":"Poppins, sans-serif","text":"The "},{"type":"link","link":{"value":"https://github.com/renalreg/rr-key-manager","target":"_blank","type":"link"},"children":[{"fontSize":16,"lineHeight":"24px","letterSpacing":0,"fontFamily":"Poppins, sans-serif","text":"rr-key-manager","color":"#0091FF","underline":true}]},{"fontSize":16,"lineHeight":"24px","color":"#555","letterSpacing":0,"fontFamily":"Poppins, sans-serif","text":" is a tool for populating a "},{"type":"link","link":{"value":"https://www.keepassx.org/","target":"_blank","type":"link"},"children":[{"fontSize":16,"lineHeight":"24px","letterSpacing":0,"fontFamily":"Poppins, sans-serif","text":"keepassx","color":"#0091FF","underline":true}]},{"fontSize":16,"lineHeight":"24px","color":"#555","letterSpacing":0,"fontFamily":"Poppins, sans-serif","text":" file with the required server and database credentials for connecting to connect to our the servers. To begin, you can follow the instruction in the repo to clone the repo locally and open it in a text editor. Inside the function called main, you will see a list of servers. You need to add the name of the servers you want to be able to connect to here the list before you run itthe script. The names you put here must match those as provided in the systems keepass found at "}]},{"type":"paragraph","align":"left","children":[{"fontSize":16,"lineHeight":"24px","color":"#555","letterSpacing":0,"fontFamily":"Poppins, sans-serif","text":" R:\\Connection\\systems which you can open using keepassx. Some of the most common ones will be"}]}]}]}]}]}]},"children":[],"id":"tQDZotDqMAIplzGktcL6G"}],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"udGAuH0TSUxg5d1aMOD7Q","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"jXkR_WBhJha68OJ-IV2vc","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"AnjIpeuz7YPiKZgwsV9FE","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"dKqUgWk6tMuHoC4pZBO42","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"GtpM2lMBgRKOdBhrR0mMz","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}}],"params":{"layout":[1],"gap":0,"minHeight":1,"padding":0,"borderRadius":0,"size":"full"}},{"id":"kOsHU4ftcfEY6ZJcu08lv","name":"row","children":[{"id":"ioIHDuIP6DeWuniqOr8uS","name":"column","children":[{"name":"text","params":{"templateId":"simple paragraph","value":[{"type":"paragraph","children":[{"type":"paragraph","children":[{"fontSize":16,"lineHeight":"24px","color":"#555","letterSpacing":0,"text":"UKRDC","fontFamily":"Open Sans, sans-serif","fontWeight":700}]},{"type":"paragraph","children":[{"fontSize":16,"lineHeight":"24px","color":"#555","letterSpacing":0,"fontFamily":"Open Sans, sans-serif","text":"🗝️ ukrdc_live 🗝️ ukrdc_staging 🗝️ ukrdc_dev"}]}]}]},"children":[],"id":"gBcIagRk1jUTdLPzjjYyo"}],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"rEToyfVmK6fyGtqJaw3p6","name":"column","children":[{"name":"text","params":{"templateId":"simple paragraph","value":[{"type":"paragraph","children":[{"type":"paragraph","children":[{"fontSize":16,"lineHeight":"24px","color":"#555","letterSpacing":0,"text":"Radar","fontFamily":"Open Sans, sans-serif","fontWeight":700}]},{"type":"paragraph","children":[{"fontSize":16,"lineHeight":"24px","color":"#555","letterSpacing":0,"fontFamily":"Open Sans, sans-serif","text":"🗝️ radar_live 🗝️ radar_staging"}]}]}]},"children":[],"id":"jIko-zdLZAad4izIADDlt"}],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"hZqL7CVBnWF1CWCryyYlz","name":"column","children":[{"name":"text","params":{"templateId":"simple paragraph","value":[{"type":"paragraph","children":[{"type":"paragraph","children":[{"fontSize":16,"lineHeight":"24px","color":"#555","letterSpacing":0,"text":"RR","fontFamily":"Open Sans, sans-serif","fontWeight":700}]},{"type":"paragraph","children":[{"fontSize":16,"lineHeight":"24px","color":"#555","letterSpacing":0,"fontFamily":"Open Sans, sans-serif","text":"🗝️ renalreg_live"}]}]}]},"children":[],"id":"pV33udK-kEOMcHu6iSybc"}],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"5K-0FjwD603lWBZKx_1ER","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"ZtkVCkUOnx5jwP4cUqkde","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"WhhBJVPQ_IsxtqTsSB-ec","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}}],"params":{"layout":[1,1,1],"gap":50,"minHeight":10,"padding":10,"borderRadius":0,"size":"full","backgroundSize":"cover"}},{"id":"dSb0JD4Mwha0-VZJTr4Tg","name":"row","children":[{"id":"RjTkK94RczVqszMNRFmT3","name":"column","children":[{"name":"divider","params":{"templateId":"solid long","color":{"light":"#000000","dark":"#ffffff"},"alignment":"start","fontSize":24,"fontColor":{"light":"#000000","dark":"#ffffff"},"height":1,"borderStyle":"solid"},"children":[],"id":"pnOdMFs2mnmWNRoRrZFwG"}],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"MG_Of6JOfaEJU-W2tSR5f","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"RVI3ymNSsu_dwbN1IS9Qd","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"fSuGe7YT_337_YPHyzPwH","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"SJVjG-CRipWoSg8G0UTx-","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"1AQw3nlDm3DiRgKnrGAcm","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}}],"params":{"layout":[1],"gap":10,"minHeight":0,"padding":10,"borderRadius":0,"size":"full"}},{"id":"7AH9wDVN6OxSZxBbVodeb","name":"row","children":[{"id":"iUi9l7qQbeXsItzLcBYaA","name":"column","children":[{"name":"text","params":{"templateId":"headline and paragraph","value":[{"type":"paragraph","children":[{"type":"paragraph","children":[{"type":"paragraph","children":[{"type":"paragraph","children":[{"type":"paragraph","children":[{"type":"paragraph","children":[{"text":"SSH Keys","fontWeight":700,"letterSpacing":-1,"lineHeight":"unset","fontSize":32,"fontFamily":"Poppins, sans-serif"}]}]},{"type":"paragraph","children":[{"fontSize":16,"lineHeight":"24px","color":"#555","letterSpacing":0,"fontFamily":"Poppins, sans-serif","text":""}]},{"type":"paragraph","align":"left","children":[{"fontSize":16,"lineHeight":"24px","color":"#555","letterSpacing":0,"fontFamily":"Poppins, sans-serif","text":"As part of the process of using the "},{"type":"link","link":{"value":"https://github.com/renalreg/rr-key-manager","target":"_blank","type":"link"},"children":[{"fontSize":16,"lineHeight":"24px","letterSpacing":0,"fontFamily":"Poppins, sans-serif","text":"rr-key-manager","color":"#0091FF","underline":true}]},{"fontSize":16,"lineHeight":"24px","color":"#555","letterSpacing":0,"fontFamily":"Poppins, sans-serif","text":" it will check to see if you have SSH keys present and if not it will create some. These keys will need adding to any server you wish to connect to. Currently, there is no automated way to do this however the process for adding a key to a server is"}]},{"type":"numbered-list","children":[{"type":"list-item","align":"left","children":[{"fontSize":16,"lineHeight":"24px","color":"#555","letterSpacing":0,"fontFamily":"Poppins, sans-serif","text":"SSH into the server you want to add keys to as root using the password found in the systems keepass using the root user."}]},{"type":"list-item","align":"left","children":[{"fontSize":16,"lineHeight":"24px","color":"#555","letterSpacing":0,"fontFamily":"Poppins, sans-serif","text":"Change directory into .ssh and open the authorized_keys file using vim."}]},{"type":"list-item","align":"left","children":[{"fontSize":16,"lineHeight":"24px","color":"#555","letterSpacing":0,"fontFamily":"Poppins, sans-serif","text":"Copy and paste your key from the id_rsa.pub file on your local system, save and exit the file, then exit the SSH session."}]},{"type":"list-item","align":"left","children":[{"fontSize":16,"lineHeight":"24px","color":"#555","letterSpacing":0,"fontFamily":"Poppins, sans-serif","text":"Test that it was successful by attempting to reconnect. If you are not asked for a password, you were successful. 😏"}]}]},{"type":"paragraph","align":"left","children":[{"fontSize":16,"lineHeight":"24px","color":"#555","letterSpacing":0,"fontFamily":"Poppins, sans-serif","text":"If you have read all that and have no idea what any of it means, you might be best off dropping "},{"type":"link","link":{"value":"andrew.atterton@ukkidney,org","target":"_blank","type":"mail"},"children":[{"fontSize":16,"lineHeight":"24px","letterSpacing":0,"fontFamily":"Poppins, sans-serif","text":"Andy","color":"#0091FF","underline":true}]},{"fontSize":16,"lineHeight":"24px","color":"#555","letterSpacing":0,"fontFamily":"Poppins, sans-serif","text":" a line and asking for a hand."}]},{"type":"paragraph","align":"left","children":[{"fontSize":16,"lineHeight":"24px","color":"#555","letterSpacing":0,"fontFamily":"Poppins, sans-serif","text":""}]}]}]}]}]}]},"children":[],"id":"FdgzTqTdpLjR44EmfZIwo"},{"name":"divider","params":{"templateId":"solid long","color":{"light":"#000000","dark":"#ffffff"},"alignment":"start","fontSize":24,"fontColor":{"light":"#000000","dark":"#ffffff"},"height":1,"borderStyle":"solid"},"children":[],"id":"xvZ-Jmd-BfIa_N82y-HJL"}],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"lzklle5-cJfF3mNDvlzsX","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"tujvFJ1wM7MNdMUT_QgXK","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"rj9DJAjccOq2rvtvnlomS","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"9aYGAkMkptEf397oFAysX","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"F2-kGCX7D9IRTCEpcLOrZ","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}}],"params":{"layout":[1],"gap":0,"minHeight":1,"padding":0,"borderRadius":0,"size":"full"}},{"id":"bYtBnp7UPObI-3s0M7KFX","name":"row","children":[{"id":"rg-gXIhYcEDJoaPSD4yri","name":"column","children":[{"name":"text","params":{"templateId":"headline and paragraph","value":[{"type":"paragraph","children":[{"type":"paragraph","children":[{"type":"paragraph","children":[{"type":"paragraph","children":[{"type":"paragraph","children":[{"type":"paragraph","children":[{"text":"Connection Wizardry","fontWeight":700,"letterSpacing":-1,"lineHeight":"unset","fontSize":32,"fontFamily":"Poppins, sans-serif"}]}]},{"type":"paragraph","children":[{"fontSize":16,"lineHeight":"24px","color":"#555","letterSpacing":0,"fontFamily":"Poppins, sans-serif","text":""}]},{"type":"paragraph","align":"left","children":[{"fontSize":16,"lineHeight":"24px","color":"#555","letterSpacing":0,"fontFamily":"Poppins, sans-serif","text":"If you have completed all the earlier steps, you should find that, as if by magic, connection manager should connect connects you to the servers you have added keys toserver of your choosing, provided you added it with the "},{"type":"link","link":{"value":"https://github.com/renalreg/rr-key-manager","target":"_blank","type":"link"},"children":[{"fontSize":16,"lineHeight":"24px","letterSpacing":0,"fontFamily":"Poppins, sans-serif","text":"rr_key_manager","color":"#0091FF","underline":true}]},{"fontSize":16,"lineHeight":"24px","color":"#555","letterSpacing":0,"fontFamily":"Poppins, sans-serif","text":". It is worth reading the full description on the repos "},{"type":"link","link":{"value":"https://github.com/renalreg/rr-connection-manager/blob/main/README.md","target":"_blank","type":"link"},"children":[{"fontSize":16,"lineHeight":"24px","letterSpacing":0,"fontFamily":"Poppins, sans-serif","text":"README","color":"#0091FF","underline":true}]},{"fontSize":16,"lineHeight":"24px","color":"#555","letterSpacing":0,"fontFamily":"Poppins, sans-serif","text":", but for your convenience there is a built-in connection test which you can use as follows."}]}]}]}]}]}]},"children":[],"id":"ekYEDMqajAtCtPT0tvHOA"},{"name":"image","params":{"templateId":"full-width","alignment":"start","position":"center center","borderRadius":{"all":0,"bbl":0,"bbr":0,"btl":0,"btr":0,"isIndividualCorners":false},"image":{"value":"att2632351762","target":"_blank","type":"attachment"},"width":567,"height":211},"children":[],"id":"KUt59-a6OqUjvQhvRZNpv"},{"name":"divider","params":{"templateId":"solid long","color":{"light":"#000000","dark":"#ffffff"},"alignment":"start","fontSize":24,"fontColor":{"light":"#000000","dark":"#ffffff"},"height":1,"borderStyle":"solid"},"children":[],"id":"uR2aI0ff2HqMtoGrzcGLM"}],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"a_Cm-Xm1eWnwxSODm5QEl","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"hnxbyJvYmu7VU12ZX7YVP","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"9_o42SqIsli_bva8XPqup","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"Qvd1m-zOgiAizJmgy0fGx","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"QoRHeWCCD_xwgfcpeR3Fb","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}}],"params":{"layout":[1],"gap":0,"minHeight":1,"padding":0,"borderRadius":0,"size":"full"}}],"name":"section"}],"id":"30pBDEr2IwtTYTas1VSQo"} |
|---|
|