Research Computing At HBS

From edegan.com
Revision as of 14:03, 18 October 2011 by imported>Ed (New page: This is page provides a rough guide for competent users to get going with HBS's RCS (Research Computing Services) remotely. ==VPN== Getting the VPN up was problematic for me (there were ...)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

This is page provides a rough guide for competent users to get going with HBS's RCS (Research Computing Services) remotely.

VPN

Getting the VPN up was problematic for me (there were account issues), but it should be as simple as going to:

vpn.hbs.edu

Enter your username and password. And clicking "start".

SSHing onto Research Grid

Just do it. Open Putty and SSH onto researchgrid.hbs.edu. Give your username and password.

Connecting to MYSQL

Type:

 mysql -h rcsmysql.hbs.edu -u username -p --ssl-ca=rcsmysql

(with your username!).

Then work away on any databases which you have permissions for. Useful MYSQL specific commands include:

SET PASSWORD = PASSWORD('newpassword');   #Change your password
SHOW GRANTS FOR username;  #See your access permissions
SHOW DATABASES;   #See all the databases you can see
USE somedbase;   #Use a database
SHOW TABLES;    #See the tables in a database
DESC sometable;   #Describe a table
SHOW PROCESSLIST;   #See a list of processes you have running
KILL xxxx;   #Kill process number xxxx

Export and Import to MYSQL

Create two symbolic links to the MYSQL import and export directories:

ln -s /export/mysql/export export
ln -s /export/mysql/import import

Map a drive (Mount)

With the VPN up, map two drive letters to:

\\research.hbs.edu\username
\\research.hbs.edu\projects

Connect using different credentials:

HBS\username
yourpassword

Note the HBS workgroup/domain above - this will be crucial. In theory you shoudl be able to map to the samba share \\research (i.e. without the full domain), but this didn't work for me.