This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision Last revision Both sides next revision | ||
onboarding_affiliates [2019/01/14 20:45] acallaha |
onboarding_affiliates [2021/07/07 13:40] acallaha |
||
---|---|---|---|
Line 12: | Line 12: | ||
- Protecting Patient Privacy - sign up via [[https:// | - Protecting Patient Privacy - sign up via [[https:// | ||
- Provide your certificates to Jason to get access | - Provide your certificates to Jason to get access | ||
- | - Get on the right mailing list | + | - Join the lab slack |
- Find the person in the lab who can explain the data you will use - talk to them! | - Find the person in the lab who can explain the data you will use - talk to them! | ||
- Set up a wiki page to document your project. [[: | - Set up a wiki page to document your project. [[: | ||
Line 19: | Line 19: | ||
* Data use agreement: Nigam Shah | * Data use agreement: Nigam Shah | ||
* Text processing: Jason Fries | * Text processing: Jason Fries | ||
- | * Data/ | + | * Data/ |
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 | ||
< | < |