summary | Connection ManagerIf 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. 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 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 our 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 servers you want to be able to connect to clone the repo | page | {"name":"page","children":[{"id":"aZRmFOXpD3EomGMVVvfqc","params":{"background":{"light":"#ffffff","dark":"#1d2125"},"padding":20,"gap":10},"children":[{"id":"FKvhWz0r9Hn7JZFMsQ16Uhere before you run it. 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 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 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 you to the servers you have added keys to. 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, 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"}],"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 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 our 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 servers you want to be able to connect to here before you run it. 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":"9f-aFTBWNOcMMeJGDS7oqioIHDuIP6DeWuniqOr8uS","name":"column","children":[{"name":"imagetext","params":{"templateId":"full-widthsimple paragraph","alignmentvalue":"center","position[{"type":"center centerparagraph","borderRadiuschildren":[{"alltype":0,"bblparagraph":0,"bbrchildren":0,[{"btlfontSize":016,"btrlineHeight":0,"isIndividualCorners24px":false},"image":{"valuecolor":"att2615771137#555","targetletterSpacing":"_blank"0,"typetext":"attachmentUKRDC"},"widthfontFamily":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":["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":"hmAabHUrdxFd08opVToQSrEToyfVmK6fyGtqJaw3p6","name":"column","children":[]{"name":"text","params":{"borderRadius"templateId":"simple paragraph","value":[{"alltype":0"paragraph","btlchildren":0,[{"bbltype":0"paragraph","btrchildren":0,[{"bbrfontSize":016,"isIndividualCornerslineHeight":false}"24px","paddingcolor":0"#555","gapletterSpacing":200,"verticalAlignmenttext":"topRadar"}},{"idfontFamily":"QX1KboA0oU5GkfkHK_i9Q","nameOpen Sans, sans-serif","fontWeight":700}]},{"type":"columnparagraph","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":[]{"name":"text","params":{"borderRadiustemplateId":{"allsimple paragraph":0,"btlvalue":0,[{"bbltype":0"paragraph","btrchildren":0,[{"bbrtype":0"paragraph","isIndividualCornerschildren":false},"padding[{"fontSize":016,"gaplineHeight":20"24px","verticalAlignmentcolor":"top#555"}}],"paramsletterSpacing":{0,"layouttext":[1],"gapRR":10,"minHeightfontFamily":100,"padding":10,"borderRadius":0}"Open Sans, sans-serif","fontWeight":700}]},{"idtype":"MWC4BH0FWQDxjmd1irbMK","name":"rowparagraph","children":[{"idfontSize":"3dC8m0ZwcI9V6esgXI9i9"16,"namelineHeight":"column24px","childrencolor":[{"name":"text"#555","paramsletterSpacing":{0,"templateIdfontFamily":"headline and paragraphOpen Sans, sans-serif","valuetext":[{"type":"paragraph""🗝️ renalreg_live"}]}]}]},"children":[{],"typeid":"paragraphpV33udK-kEOMcHu6iSybc"}],"childrenparams":[{"typeborderRadius":"paragraph","children{"all":[{0,"textbtl":0,"Connection Managerbbl":0,"fontWeightbtr":7000,"letterSpacingbbr":-10,"lineHeightisIndividualCorners":false},"unsetpadding":0,"fontSizegap":3220,"fontFamilyverticalAlignment":"Poppins, sans-seriftop"}]},{"alignid":"center"}]},{"type5K-0FjwD603lWBZKx_1ER","name":"paragraphcolumn","children":[],"params":{"textborderRadius":{"all":0,"btl":0,"fontSizebbl":160,"lineHeightbtr":0,"24pxbbr":0,"colorisIndividualCorners":false},"#555padding":0,"letterSpacinggap":020,"fontFamilyverticalAlignment":"Open Sans, sans-seriftop"}]},{"typeid":"paragraphZtkVCkUOnx5jwP4cUqkde","children":[{"typename":"paragraphcolumn","children":[{"fontSize":16],"lineHeightparams":{"24px","colorborderRadius":{"#555","letterSpacingall":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":"centerbtl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"WhhBJVPQ_IsxtqTsSB-ec","name":"column","children":[{"fontSize":16,"lineHeight":"24px","color":"#555","letterSpacing],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"fontFamilygap":"Poppins20, sans-serif","text"verticalAlignment":"top"}}]},"params":{"typelayout":"paragraph"[1,1,1],"gap":50,"childrenminHeight":[{10,"typepadding":10,"paragraphborderRadius":0,"alignsize":"centerfull","childrenbackgroundSize":[{"fontSizecover":16}},{"lineHeightid":"24pxdSb0JD4Mwha0-VZJTr4Tg","colorname":"#555row","letterSpacingchildren":0,[{"fontFamilyid":"Poppins, sans-serifRjTkK94RczVqszMNRFmT3","textname":""}]}]}]}]}]}column","children":[],{"idname":"oYn2fn0g2IxgVoOo1Dd-idivider"}],"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"}}],"params":{"layout":[1],"gap":10,"minHeight":200,"padding":10,"borderRadius":0}},{"id":"Ba47T0TRdbf6q0LUo8yF3","name":"row","children":[,{"id":"tdood_-RZ5ArpYwcmXNaj1AQw3nlDm3DiRgKnrGAcm","name":"column","children":[],"params":{"nameborderRadius":{"textall":0,"paramsbtl":{0,"templateIdbbl":0,"simple paragraphbtr":0,"valuebbr":[{0,"typeisIndividualCorners":false},"paragraphpadding":0,"childrengap":[{20,"typeverticalAlignment":"paragraphtop"}}],"params":{"childrenlayout":[{"type1],"gap":10,"minHeight":0,"paragraphpadding":10,"childrenborderRadius":[{0,"textsize":"Before You Startfull"}},{"fontWeightid":700,"letterSpacing7AH9wDVN6OxSZxBbVodeb":-1,"lineHeightname":"unsetrow","fontSizechildren":32,[{"fontFamilyid":"Poppins, sans-serif"}]}]},{"typeiUi9l7qQbeXsItzLcBYaA","name":"paragraphcolumn","children":[{"fontSizename":16"text","lineHeightparams":{"24px","colortemplateId":"#555headline and paragraph","letterSpacingvalue":0,[{"fontFamilytype":"Poppins, sans-serifparagraph","textchildren":""}]},[{"type":"paragraph","align"children":[{"type":"leftparagraph","children":[{"fontSizetype":16"paragraph","lineHeightchildren":"24px","color[{"type":"#555paragraph","letterSpacingchildren":0,[{"fontFamilytype":"paragraph"Poppins, sans-serif","children":[{"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.SSH Keys","fontWeight":700,"letterSpacing":-1,"lineHeight":"unset","fontSize":32,"fontFamily":"Poppins, sans-serif"}]}]}]},"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":[,{"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 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":"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 ""}]}]}]}]}]}]},"children":[],"id":"FdgzTqTdpLjR44EmfZIwo"},{"typename":"linkdivider","linkparams":{"valuetemplateId":"https://github.com/renalreg/rr-key-managersolid long","targetcolor":{"light":"_blank#000000","typedark":"link#ffffff"},"childrenalignment":[{"start","fontSize":1624,"lineHeightfontColor":{"24pxlight",:"letterSpacing#000000":0,"fontFamilydark":"Poppins, sans-serif","text#ffffff"},"height":1,"borderStyle":"rr-key-managersolid"},"colorchildren":[],"#0091FFid","underline":true}]},{"fontSize":16,"lineHeight":"24px","color":"#555","letterSpacing:"xvZ-Jmd-BfIa_N82y-HJL"}],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"fontFamilybbr":"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"}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":"Nbi0ZKyX1YsFNW_B9pBxerj9DJAjccOq2rvtvnlomS","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"UlGi0Ju4AaYn66AaaDF1T9aYGAkMkptEf397oFAysX","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"WzJUPgGzrsdJooEyrSF2-gWkGCX7D9IRTCEpcLOrZ","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}}],"params":{"idlayout":"OZY-jkkcV4qE32g6dxxSe"[1],"gap":0,"nameminHeight":1,"columnpadding":0,"childrenborderRadius":[]0,"paramssize":"full"}},{"borderRadiusid":{"allbYtBnp7UPObI-3s0M7KFX":0,"btlname":0"row","bblchildren":0,[{"btrid":0,"bbrrg-gXIhYcEDJoaPSD4yri":0,"isIndividualCornersname":false},"paddingcolumn":0,"gapchildren":20,[{"verticalAlignmentname":"toptext"}},"params":{"idtemplateId":"1LnGGhQRT6zCdC5GP0gTFheadline and paragraph","name"value":[{"type":"columnparagraph","children":[]{"type":"paragraph","paramschildren":[{"borderRadiustype":{"allparagraph":0,"btlchildren":0,[{"bbltype":0,"btrparagraph":0,"bbrchildren":0,[{"isIndividualCornerstype":false},"paddingparagraph":0,"gapchildren":20,[{"verticalAlignmenttype":"topparagraph"}}],"paramschildren":[{"layouttext":[1]"Connection Wizardry","gapfontWeight":100700,"minHeightletterSpacing":-1,"paddinglineHeight":10"unset","borderRadiusfontSize":032,"sizefontFamily":"full"}Poppins, sans-serif"}]}]},{"idtype":"t-gTipArDQVJ24lsiWKJqparagraph","name":"row","children":[{"idfontSize":"nQmq5k774D7TU5zLiv57D"16,"namelineHeight":"column24px","childrencolor":[{"name#555":,"textletterSpacing":0,"paramsfontFamily":{"templateId":"headline and paragraph","value":[Poppins, sans-serif","text":""}]},{"type":"paragraph","children":[{"typealign":"paragraphleft","children":[{"typefontSize":16,"paragraphlineHeight",:"children24px":[{,"typecolor":"paragraph#555","childrenletterSpacing":[{0,"typefontFamily":"paragraphPoppins, sans-serif","children":[text":"If you have completed all the earlier steps, you should find that, as if by magic, connection manager should connect you to the servers you have added keys to. It is worth reading the full description on the repos "},{"type":"paragraphlink","childrenlink":[{"textvalue":"RR-Key-Managerhttps://github.com/renalreg/rr-connection-manager/blob/main/README.md","fontWeighttarget":700,"letterSpacing_blank":-1,"lineHeighttype":"unset","fontSize":32,"fontFamily":"Poppins, sans-serif"}]}]},{"type":"paragraph","link"},"children":[{"fontSize":16,"lineHeight":"24px","color":"#555","letterSpacing":0,"fontFamily":"Poppins, sans-serif","text":""}]},{"type"text":"paragraphREADME","aligncolor":"left#0091FF","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", but for your convenience there is a built-in connection test which you can use as follows."}]}]}]}]}]}]},"children":[{],"fontSizeid":16"ekYEDMqajAtCtPT0tvHOA"},{"lineHeightname":"24pximage","letterSpacingparams":0,{"fontFamilytemplateId":"Poppins, sansfull-serifwidth","textalignment":"rr-key-managerstart","colorposition":"#0091FFcenter center","underlineborderRadius":true}]},{"fontSizeall":160,"lineHeightbbl":"24px"0,"colorbbr":"#555"0,"letterSpacingbtl":0,"fontFamily":"Poppins, sans-serif","text":" is a tool for populating a "},{"typebtr":0,"linkisIndividualCorners":false},"linkimage":{"value":"https://www.keepassx.org/att2632351762","target":"_blank","type":"linkattachment"},"childrenwidth":[{567,"fontSizeheight":16211},"lineHeightchildren":[],"24pxid",:"letterSpacing":0,"fontFamily":"Poppins, sans-serif","text":"keepassxKUt59-a6OqUjvQhvRZNpv"},{"name":"divider","params":{"templateId":"solid long","color":{"light":"#0091FF#000000","underlinedark":true}]"#ffffff"},{"fontSizealignment":16"start","lineHeightfontSize":24,"24pxfontColor",:{"colorlight":"#555#000000","letterSpacingdark":0"#ffffff"},"fontFamilyheight":"Poppins, sans-serif"1,"textborderStyle":" file with the required server and database credentials for connecting to our servers. To begin you will need to clone the repo"}]}]}]}]}]}]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"} |
---|
|