Changes
Jump to navigation
Jump to search
Research Computing At HBS (view source)
Revision as of 15:03, 18 October 2011
, 15:03, 18 October 2011New 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 ...
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.
==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.