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 ...

2011-10-18T19:03:28Z

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 ...

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 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.

Research Computing At HBS - Revision history

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 ...