ARCHIVED: About the Libra retirement

Username:
Password:

On June 30, 2009, UITS retired the Libra Cluster, which had been in service since 2005. Accounts are available on the newer Quarry cluster, a general-purpose Unix computing environment. See At IU, what is Quarry? and At IU, if I already have some computing accounts, how do I get others?

The Research Database Cluster (RDC) is not included in this retirement, and will remain in service.

If you use the RDC

Oracle changes

If you connect to Oracle from libra.uits.iu.edu, you will need to instead log into rdc.uits.iu.edu.

Your database still lives on libra45 or libra46, so if you are using AquaData Studio or other Oracle Client software or you use PerlDBI to connect to your instance, you will not need to change your setup. Nodes libra45 and libra46 will remain in place and retain their current IP addresses.

When you log into rdc.uits.iu.edu, your home directory will still be /N/u/your_username/Libra, so all the data you currently have in your home directory on Libra will remain available to you.

MySQL changes

If you connect to MySQL from libra.uits.iu.edu (libra01 and libra02), you will need to log into rdc.uits.iu.edu (rdclogin1 and rdclogin2), and you also should have made an additional change before the retirement date of June 30: granting access to root from rdclogin1 and rdclogin2. If you didn't do this, as described below, you will not be able to connect to your database from the command line on rdc.uits.iu.edu after libra.uits.iu.edu is retired. To make the change:

Connect to your MySQL database from libra.uits.iu.edu.
Make sure that your database is up by entering: mysql_instance start
Once the instance starts, you can connect to your MySQL database: mysql --defaults-file=/N/u/your_username/Libra/.my.cnf -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 3 Server version: 5.0.60sp1-enterprise-gpl-log MySQL Enterprise Server (GPL) Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
Grant access to root from the new hosts (substitute your MySQL password for your_passwd and make sure it is in single quotes): mysql> GRANT ALL ON *.* TO root@'149.165.231.4' identified by 'your_passwd'; Query OK, 0 rows affected (0.00 sec) mysql> GRANT ALL ON *.* TO root@'rdclogin1.uits.iu.edu' identified by 'your_passwd'; Query OK, 0 rows affected (0.00 sec) mysql> GRANT ALL ON *.* TO root@'149.165.231.5' identified by 'your_passwd'; Query OK, 0 rows affected (0.00 sec) mysql> GRANT ALL ON *.* TO root@'rdclogin2.uits.iu.edu' identified by 'your_passwd'; Query OK, 0 rows affected (0.00 sec) mysql> flush privileges; Query OK, 0 rows affected (0.00 sec)
Verify that the new hosts have been added to the mysql.user table: mysql> SELECT user,host,password FROM mysql.user where user='root'; +------+----------------------- +-------------------------------------------+ | user | host | password | +------+----------------------- +-------------------------------------------+ | root | localhost | *589FE3B1534B1E5D39F73DC799E78B76D85ACCEB | | root | libra45 | | | root | 149.165.231.70 | *589FE3B1534B1E5D39F73DC799E78B76D85ACCEB | | root | 149.165.231.1 | *589FE3B1534B1E5D39F73DC799E78B76D85ACCEB | | root | 149.165.231.2 | *589FE3B1534B1E5D39F73DC799E78B76D85ACCEB | | root | 149.165.231.46 | *589FE3B1534B1E5D39F73DC799E78B76D85ACCEB | | root | libra45.uits.iu.edu | *589FE3B1534B1E5D39F73DC799E78B76D85ACCEB | | root | libra01.uits.iu.edu | *589FE3B1534B1E5D39F73DC799E78B76D85ACCEB | | root | libra02.uits.iu.edu | *589FE3B1534B1E5D39F73DC799E78B76D85ACCEB | | root | 149.165.231.4 | *589FE3B1534B1E5D39F73DC799E78B76D85ACCEB | | root | rdclogin1.uits.iu.edu | *589FE3B1534B1E5D39F73DC799E78B76D85ACCEB | | root | 149.165.231.5 | *589FE3B1534B1E5D39F73DC799E78B76D85ACCEB | | root | rdclogin2.uits.iu.edu | *589FE3B1534B1E5D39F73DC799E78B76D85ACCEB | +------+----------------------- +-------------------------------------------+ 13 rows in set (0.00 sec)
Log out by entering quit .
Log into rdc.uits.iu.edu and verify that you can connect to your MySQL database.

If you have questions, email the High Performance Systems (HPS) group.

For more information

The High Performance Applications team (HPA) can answer questions about Libra, compilers, programming, scientific and numerical libraries, or debuggers; email HPA.
If you have questions about statistical and mathematical software, contact the Stat/Math Center.
See information on statistical and mathematical software currently available from Quarry.

This is document axst in domain all.
Last modified on October 06, 2009.