On the Research Database Complex at IU, how do I access my Oracle or MySQL database?

Username:
Password:

The Research Database Complex (RDC) is dedicated to research-related databases and data-intensive applications that require a database. Oracle and MySQL databases are supported, and the default database size is 15MB. The RDC also provides an environment for database-driven web applications with a research focus. This system, rdcweb.uits.iu.edu, runs Red Hat Enterprise Linux 5. User home directories reside on the IBM N5500 NAS storage device, with disk storage of 10GB per user. This space is shared by your Big Red and Quarry accounts, if you have accounts on those systems.

On this page:

Connecting to the RDC

Note: The Indiana University Research Database Complex (RDC) is currently being migrated to new hardware. If you obtained an MySQL server after March 21, 2011, it was created on the new Linux server (rdc04.uits.iu.edu). Also, a new front-end server (rdc.uits.iu.edu) is in production. Your welcome letter specified the server to which you should connect. Below are procedures for each system:

New server

To connect to your account on the new RDC front-end server:

In your SSH client, enter: ssh username@rdc.uits.iu.edu
Replace username with your Network ID username.
Read the message of the day (MOTD). It contains news and information about the status of the RDC.

Note: Your login shell is automatically set to Bash.

For more, see Getting started on the IU Research Database Complex.

Retiring server

Both rdclogin1 and rdclogin2 have been retired and replaced with rdc.uits.iu.edu, currently being used as the front end to libra45, libra46, and rdc01-rdc04. To connect to your account:

In your SSH client, enter: ssh username@rdc.uits.iu.edu
Replace username with your Network ID username.
Read the message of the day (MOTD). It contains news and information about the status of the RDC.

Note: If you're logging into the RDC for the first time, the changeshell program will prompt you to select your preferred login shell: jdoe@rdc:~> changeshell This program will assist you in changing your login shell on all nodes of the RDC . . . . 1) bash 2) tcsh . . . 5) quit Select 1-5: 2 Changing login shell for jdoe Password: Shell changed. Your shell has been changed to the Cornell tcsh shell This will take effect on all nodes within 15 minutes

If you use the Bash, Bourne, or Korn shells, the system will automatically read and execute commands from the /etc/profile file and your own ~/.profile (and ~/.bash_profile for Bash). With the csh and tcsh shells, the .login and .cshrc (or .tcshrc) files are read. For details, see In Unix, what is the shell? or the Unix man pages.

For more, see Getting started on the IU Research Database Complex.

Connecting to your Oracle database using SQL*Plus

Note: Your RDC Oracle Database welcome letter contains information you need to connect to your database:

Your Oracle database login (username)
The Oracle instance name or Security Identifier (SID)
Information about your initial database password

If you don't have the welcome letter, email the High Performance Systems group for assistance.

To connect to your RDC database using SQL*Plus:

At the system prompt, enter the following, replacing username with your database login, and oracle_instance_name with the SID: sqlplus username@oracle_instance_name
Note: For security reasons, you should not enter your password on the SQL*Plus command line.
When prompted, enter your Oracle database password, as shown below: SQL*Plus: Release 10.2.0.1.0 - Production on Fri Mar 14 13:49:03 2008 Copyright (c) 1982, 2005, Oracle. All rights reserved. Enter password:
When you've logged in successfully, you'll see: Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production With the Partitioning, OLAP and Data Mining options SQL>

Connecting to your Oracle database using Aqua Data Studio

To connect to your Oracle database using Aqua Data Studio:

Start Aqua Data Studio. On the left, choose the appropriate server name.
Select Schema, and then select your database.

For more, see How do I access my Oracle database on the IU Research Database complex using Aqua Data Studio?

Connecting to your MySQL database

Note: Your RDC MySQL Database welcome letter contains information you need to connect to your database:

Your MySQL database login (username)
Information about your initial database password
Your database port number

If you don't have the welcome letter, email the High Performance Systems group for assistance.

To connect to your RDC database using MySQL:

At the system prompt, enter the following, replacing your_username with your Network ID username. Do not change root. Because you are the database administrator (DBA) for your MySQL database, you need to log into your database as root. mysql --defaults-file=~/.my.cnf -u root -p
Note: For security reasons, do not enter your password on the MySQL command line.
When prompted, enter your MySQL database password.
When you've logged in successfully, you'll see: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 11 Server version: 5.0.60sp1-enterprise-gpl-log MySQL Enterprise Server (GPL) Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

Connecting to your MySQL database from Quarry

To connect to your MySQL database from Quarry, you must first add access to your database's mysql.user table.

Note: For the purposes of this example:

RDC Unix account username: tester
MySQL user: root
MySQL password for the root user: 12tstr45
If you are connecting to MySQL using the MySQL root account, use the following syntax. Otherwise, substitute the appropriate MySQL username.

To allow access to MySQL from all nodes on Quarry:

From the RDC, log into your database as root: mysql --defaults-file=~/.my.cnf -u root -p
At the MySQL prompt, enter: grant all on *.* to root@'quarry.uits.indiana.edu' identified by '12tstr45';
And then:
grant all on *.* to root@'149.165.230.%' identified by '12tstr45';
MySQL should respond:
Query OK, 0 rows affected (0.03 sec)
To reload the grant table, enter: flush privileges;
MySQL should respond:
Query OK, 0 rows affected (0.04 sec)
To verify that the new grant is in the user table, enter: SELECT user,host,password FROM mysql.user where user='root';
In the resulting table, check for two entries similar to:
+------+-------------------------+-------------------------------------------+ | user | host | password | +------+-------------------------+-------------------------------------------+ | root | quarry.uits.indiana.edu | *74D03D4FC2540A848F27296C062A83FA1ACDC53A | | root | 149.165.230.% | *74D03D4FC2540A848F27296C062A83FA1ACDC53A | +------+-------------------------+-------------------------------------------+
To exit MySQL, enter: quit
MySQL should respond:
Bye
To connect to your MySQL database using all the defaults configured on the RDC:
1. From your account on the RDC, enter: cd /N/u/tester/Quarry
2. Copy your MySQL preference file to Quarry: cp ~/.my.cnf /N/u/tester/Quarry/.my.cnf
3. Verify the copy is complete: ls -al /N/u/tester/Quarry/.my.cnf

You should now be able to connect to your MySQL database from Quarry. If you have other systems from which you want to connect, you'll have to add additional entries to the user table for those systems.

Using phpMyAdmin to administer your MySQL database

The phpMyAdmin application provides a web interface for the administration of MySQL databases. For IU-specific instructions, see On the Research Database Complex at IU, how do I use phpMyAdmin to administer my MySQL database?

Getting help

For help connecting to your Oracle or MySQL database, email the High Performance Systems group.

This is document awqb in domain all.
Last modified on November 17, 2011.