This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision Next revision Both sides next revision | ||
onboarding_affiliates [2018/10/25 19:36] nigam [Onboarding steps] |
onboarding_affiliates [2021/01/20 11:54] jfries |
||
---|---|---|---|
Line 7: | Line 7: | ||
- Complete the necessary training | - Complete the necessary training | ||
- IF you will access data containing PHI (e.g. clinical notes), you need to complete the following training: | - IF you will access data containing PHI (e.g. clinical notes), you need to complete the following training: | ||
- | - Protecting Patient Privacy - sign up via [[https:// | + | - Protecting Patient Privacy - sign up via [[https:// |
- Protection of Human Subjects - GROUP 7: IRB BioMed/GCP Research - done via [[https:// | - Protection of Human Subjects - GROUP 7: IRB BioMed/GCP Research - done via [[https:// | ||
- IF you will access ONLY de-identified patient data, you need to complete the following training: | - IF you will access ONLY de-identified patient data, you need to complete the following training: | ||
Line 32: | Line 32: | ||
* All __publications or presentations__ relating to the data will be cleared in advance through Shah lab. | * All __publications or presentations__ relating to the data will be cleared in advance through Shah lab. | ||
- | ===== How to connect to Dev2 ====== | + | ===== How to connect to shahlab-compute (formerly dev2) ====== |
If you are off-campus (or on the wireless network), you will need [[https:// | If you are off-campus (or on the wireless network), you will need [[https:// | ||
SSH command to connect (open a terminal): | SSH command to connect (open a terminal): | ||
- | < | + | < |
The first time you do this it will ask you to store the RSA key, just type yes. After the first time, this should not appear anymore. | The first time you do this it will ask you to store the RSA key, just type yes. After the first time, this should not appear anymore. | ||
- | ===== How to connect to DB1 ====== | + | ===== How to connect to shahlab-database (formerly db1) ====== |
There are multiple different ways of connecting to the database server. If you are off-campus, you will need [[https:// | There are multiple different ways of connecting to the database server. If you are off-campus, you will need [[https:// | ||
- | **NOTE: Your DB1 password is NOT the same as your dev2 password. It is found on the .my.cnf file file on your home/ | + | **NOTE: Your DB1 password is NOT the same as your shahlab-compute |
1) (The easiest way) Set up a MySQL GUI:\\ | 1) (The easiest way) Set up a MySQL GUI:\\ | ||
Line 60: | Line 60: | ||
3) (hard and confusing) Create a tunnel from the database server to your computer: | 3) (hard and confusing) Create a tunnel from the database server to your computer: | ||
- | - To connect to //shahlab-db1.stanford.edu//, | + | - To connect to //shahlab-database.stanford.edu//, |
- | < | + | < |
- Use your local copy of MySQL (you need to instal the MySQL client on your computer) \\ | - Use your local copy of MySQL (you need to instal the MySQL client on your computer) \\ | ||
- Then connect to the database of interest | - Then connect to the database of interest | ||
< | < |