Go to: Main Content
Minnesota Supercomputer Institute
- Home
- >
- Laboratories
- >
- SDML
- >
- Techical Information
Scientific Data Management Laboratory Techical Information
Technical information specific to the lab.
Login to SDML
To connect, login to db1.msi.umn.edu via ssh:
ssh -l username db1.msi.umn.edu
You only need to use -l if your sdml login name is different than the login name you use on your own workstation.
Database Management System
Currently both Oracle and MySQL DBMS are available for SDML users. SDML users can request Oracle and/or MySQL account(s). Other database management system can be installed upon request. Please contact user support for direct assistance.
Oracle
Oracle home: /usr/local/oracle10g/product/10.2.0/db_1
To access Oracle sqlplus via the command line, you will need to set environment variable and then sqlplus command:
. /usr/local/oracle/oracle10g_client
sqlplus oracle_username@instance_name
MySQL
MySQL is installed at db0.msi.umn.edu (127.0.0.1) port 9903
To access MySQL via the command line, you will need to set environment variable and mysql command:
. /usr/local/mysql/mysql_client
mysql -h 127.0.0.1 -P 9903 -u mysql_username -p
Web Interface Development Environment
- Perl/CGI with necessary perl libraries (DBI, GD, etc.) are ready for use. (Other libraries can be installed upon request)
- PHP (connect to MySQL) are ready for use.
- Tomcat, Jboss and others can be installed upon request.