| 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 clone the repo | 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":185add the name of the servers you want to be able to connect to the list before you run the 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.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 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 connects you to the server 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. Most of the information required can be found in the README of the respective project, but here 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 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 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 to connect to 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 the list before you run the 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"}]}]}]}]}]}]},"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":"5_Rim65enwZ1eqYmGLtnegBcIagRk1jUTdLPzjjYyo"}],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"O1juLYOxV5I_EEOFcEVuGrEToyfVmK6fyGtqJaw3p6","name":"column","children":[],"params":{"borderRadiusname":{"alltext":0,"btlparams":0,{"bbltemplateId":0,"btrsimple paragraph":0,"bbrvalue":0,[{"isIndividualCornerstype":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"hmAabHUrdxFd08opVToQS","name":"column"paragraph","children":[{"type":"paragraph","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding{"fontSize":16,"lineHeight":"24px","color":"#555","letterSpacing":0,"gaptext":20"Radar","verticalAlignmentfontFamily":"top"}},{"id":"QX1KboA0oU5GkfkHK_i9Q","name":"columnOpen Sans, sans-serif","fontWeight":700}]},{"type":"paragraph","children":[],"params":{"borderRadiusfontSize":{16,"alllineHeight":0,"btl24px":0,"bblcolor":0,"btr#555":0,"bbrletterSpacing":0,"isIndividualCornersfontFamily":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"8AgmqvDifaQ9hs3s3b_zV","name":"column","children":["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":"MfBG3kNo1Ys8XMqZKWB2LhZqL7CVBnWF1CWCryyYlz","name":"column","children":[],"params":{"borderRadiusname":{"alltext":0,"btlparams":0,{"bbltemplateId":0,"btrsimple paragraph":0,"bbrvalue":0,[{"isIndividualCornerstype":false},"paddingparagraph":0,"gapchildren":20,[{"verticalAlignmenttype":"topparagraph"}}],"paramschildren":[{"layoutfontSize":[1]16,"gaplineHeight":10"24px","minHeightcolor":100,"padding#555":10,"borderRadiusletterSpacing":0}},{"idtext":"MWC4BH0FWQDxjmd1irbMKRR","namefontFamily":"rowOpen Sans, sans-serif","childrenfontWeight":[700}]},{"idtype":"3dC8m0ZwcI9V6esgXI9i9paragraph","namechildren":[{"columnfontSize":16,"childrenlineHeight":[{"name"24px","color":"text#555","paramsletterSpacing":{0,"templateIdfontFamily":"headline and paragraph","value":[{"typeOpen Sans, sans-serif","text":"paragraph"🗝️ renalreg_live"}]}]}]},"children":[{],"typeid":"paragraphpV33udK-kEOMcHu6iSybc"}],"childrenparams":[{"typeborderRadius":{"paragraphall":0,"childrenbtl":[{0,"textbbl":0,"Connection Managerbtr":0,"fontWeightbbr":7000,"letterSpacingisIndividualCorners":-1false},"lineHeightpadding":"unset"0,"fontSizegap":3220,"fontFamilyverticalAlignment":"Poppins, sans-seriftop"}]},{"alignid":"center"}]},{"type5K-0FjwD603lWBZKx_1ER","name":"paragraphcolumn","children":[],"params":{"textborderRadius":{"all":0,"fontSizebtl":160,"lineHeightbbl":0,"24pxbtr":0,"colorbbr":0,"#555isIndividualCorners":false},"letterSpacingpadding":0,"gap":20,"fontFamilyverticalAlignment":"Open Sans, sans-seriftop"}]},{"type"id":"ZtkVCkUOnx5jwP4cUqkde","name":"paragraphcolumn","children":[{],"typeparams":{"paragraphborderRadius",:{"childrenall":[{0,"fontSizebtl":160,"lineHeightbbl":0,"24pxbtr":0,"colorbbr":0,"#555isIndividualCorners":false},"letterSpacingpadding":0,"text":"If you want to connect easily to one of our databases, this is the tool for you. Primarily, the information required can be found in the README of each project, but there are a few steps required before this will work.","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"}]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":{"borderRadiustemplateId":{"allsolid long":0,"btlcolor":0,{"bbllight":0"#000000","btrdark":0"#ffffff"},"bbralignment":0"start","isIndividualCornersfontSize":false}24,"paddingfontColor":0,{"gaplight":20"#000000","verticalAlignmentdark":"top#ffffff"}},{"idheight":"o4Uv4bmc6V5DoFDD9ktNE"1,"nameborderStyle":"columnsolid"},"children":[],"id":"pnOdMFs2mnmWNRoRrZFwG"}],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"EjqR0d1qGxlRPuVC9A5SbMG_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":"C-FfFSuNOFuHRGMw7tMrWRVI3ymNSsu_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":"HdgOfTISxCKK93NA7Yr9yfSuGe7YT_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":"gzneaTFOjaTp9HJFzB0VKSJVjG-CRipWoSg8G0UTx-","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}}],{"paramsid":{"layout1AQw3nlDm3DiRgKnrGAcm":[1],"gapname":10"column","minHeightchildren":200[],"paddingparams":10,{"borderRadius":0}},{"idall":0,"Ba47T0TRdbf6q0LUo8yF3btl":0,"namebbl":"row"0,"childrenbtr":[{0,"idbbr":"tdood_-RZ5ArpYwcmXNaj"0,"isIndividualCorners":false},"namepadding":"column"0,"childrengap":[{20,"nameverticalAlignment":"texttop"}}],"params":{"templateIdlayout":"simple paragraph"[1],"gap":10,"valueminHeight":[{0,"typepadding":10,"paragraphborderRadius":0,"childrensize":["full"}},{"typeid":"paragraph7AH9wDVN6OxSZxBbVodeb","children":[{"typename":"paragraphrow","children":[{"textid":"Before You StartiUi9l7qQbeXsItzLcBYaA","name":"fontWeightcolumn":700,"letterSpacingchildren":-1,"lineHeight[{"name":"unsettext","fontSizeparams":32,{"fontFamilytemplateId":"headline and paragraph"Poppins, sans-serif"}]}]},"value":[{"type":"paragraph","children":[{"fontSizetype":16"paragraph","lineHeightchildren":"24px","color[{"type":"#555paragraph","letterSpacingchildren":0,[{"fontFamilytype":"Poppins, sans-serifparagraph","textchildren":""}]},[{"type":"paragraph","align"children":[{"type":"leftparagraph","children":[{"fontSize":16,[{"lineHeighttext":"24pxSSH Keys","colorfontWeight":"#555"700,"letterSpacing":0-1,"fontFamilylineHeight":"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.unset","fontSize":32,"fontFamily":"Poppins, sans-serif"}]}]}]},{"type":"paragraph","children":[]{"fontSize":16,"idlineHeight":"d16zhVOt6TkvskOSJ15nG24px"},{"namecolor":"divider#555","paramsletterSpacing":{0,"templateIdfontFamily":"solid longPoppins, sans-serif","colortext":{"light":"#000000","dark"}]},{"type":"#ffffffparagraph"},"alignmentalign":"startleft","fontSizechildren":24,[{"fontColorfontSize":{16,"lightlineHeight":"#00000024px","darkcolor":"#ffffff#555"},"heightletterSpacing":10,"borderStylefontFamily":"solidPoppins, sans-serif"},"childrentext":[],"id"As part of the process of using the "},{"type":"Zn9eLvBA7n2yXP9Z89gUUlink"}],"paramslink":{"borderRadiusvalue":{"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"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."}]},{"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":""}]}]}]}]}]}]},{"typechildren":"paragraph"[],"alignid":"leftFdgzTqTdpLjR44EmfZIwo"},{"childrenname":[{"fontSize"divider","params":16,{"lineHeighttemplateId":"24pxsolid long","color":{"#555light",:"letterSpacing#000000":0,"fontFamilydark":"Poppins, sans-serif#ffffff"},"textalignment":"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 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 "},{"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"}"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":"Nbi0ZKyX1YsFNW_B9pBxe9aYGAkMkptEf397oFAysX","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"UlGi0Ju4AaYn66AaaDF1TF2-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":"toprow"}},"children":[{"id":"WzJUPgGzrsdJooEyrSrg-gWgXIhYcEDJoaPSD4yri","name":"column","children":[]{"name":"text","params":{"borderRadiustemplateId":{"allheadline and paragraph":0,"btlvalue":0,[{"bbltype":0"paragraph","btrchildren":0,[{"bbrtype":0"paragraph","isIndividualCornerschildren":false},"padding[{"type":0"paragraph","gapchildren":20,[{"verticalAlignmenttype":"topparagraph"}},"children":[{"idtype":"OZY-jkkcV4qE32g6dxxSe","name"paragraph","children":[{"type":"columnparagraph","children":[],{"paramstext":{"borderRadiusConnection Wizardry":{,"allfontWeight":0700,"btlletterSpacing":0-1,"bbllineHeight":0"unset","btrfontSize":032,"bbrfontFamily":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""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 connects you to the server 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","color":"#555","letterSpacing":0,"fontFamily":"Poppins, sans-serif","text":"README"}]},{"typecolor":"paragraph#0091FF","align":"left","childrenunderline":[true}]},{"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, 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":"https://www.keepassx.org/att2632351762","target":"_blank","type":"attachment"},"width":567,"linkheight":211},"children":[{],"fontSizeid":16,"lineHeight"KUt59-a6OqUjvQhvRZNpv"},{"name":"24pxdivider","letterSpacingparams":0,{"fontFamilytemplateId":"solid long"Poppins, sans-serif","text"color":{"light":"keepassx#000000","colordark":"#0091FF#ffffff"},"underlinealignment":true}]},{"start","fontSize":1624,"lineHeightfontColor":{"24px","colorlight":"#555#000000","letterSpacingdark":0,"fontFamily#ffffff":"Poppins, sans-serif","text":" file with the required server and database credentials for connecting to our servers. To begin you will need to clone the repo"}]}]}]}]}]}]},"height":1,"borderStyle":"solid"},"children":[],"id":"tQDZotDqMAIplzGktcL6GuR2aI0ff2HqMtoGrzcGLM"}],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"udGAuH0TSUxg5d1aMOD7Qa_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":"jXkR_WBhJha68OJ-IV2vchnxbyJvYmu7VU12ZX7YVP","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"AnjIpeuz7YPiKZgwsV9FE9_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":"dKqUgWk6tMuHoC4pZBO42Qvd1m-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":"GtpM2lMBgRKOdBhrR0mMzQoRHeWCCD_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"} |
|---|
|