There are various options for database access for your research and class needs:
- MySQL - We offer MySQL database access for SoIC students, faculty, and staff for class and research use as well as for production school-wide projects. To request a database, please contact us and include the following information in your request:
- Expected maximum size of your database
- Expected project duration
- Course number or sponsoring faculty member. If this isn't for a SoIC course and isn't work for which you have a faculty sponsor, please just briefly explain the nature of your project.
Preferred database name (we will create the database and the mysql account using this same name). Please note that the database name must not exceed 16 alphanumeric characters.
We will create the database and send you the access information, including an initial password that you should change. You will also have access to your databases using PhpMyAdmin via the URL http://phpmyadmin.soic.indiana.edu/soic-phpmyadmin/. Please note that access to phpMyAdmin is limited to hosts in the indiana.edu and iu.edu domains. If you need to connect from outside of IU, we recommend that you use the IU VPN to get an IU IP address.
Please note that UITS also offers MySQL database access via the Research Database Complex (RDC).Please be aware that UITS blocks the mysql port (3306) at the border routers so you will not be able to reach the SoIC mysql server from a non-IU IP address. If you need remote access, you will need to use the VPN to get an IU IP address.
Furthermore, UITS also blocks the mysql port (3306) for students using the IU Secure wireless network. If you are using IU Secure and need to make mysql connections, please see At IUB and IUPUI, how can students have direct network access to databases and/or remote desktop?
- Oracle - We do not support Oracle but UITS does provide access to Oracle database via the Research Database Complex (RDC) for instructional purposes. See the associated KB article for details on getting accounts for instructional use. If this does not meet your needs, then contact us if you would like assistance with installing Oracle on a local system that you will manage.
- MS SQL - We do not support Microsoft SQL but UITS does provide access to MS SQL Server for instructional purposes. See Microsoft SQL Server (and IIS) Accounts for Classes at IU for details. If this does not meet your needs, then contact us if you would like assistance with installing MS SQL Server on a local system that you will manage.
- PostgreSQL - ILS maintains two PostgreSQL installations. (One for general coursework and student projects, the other for research projects that consist of larger datasets and which require an environment with less competition for CPU and memory resources.) Accounts for the first (db.ils.indiana.edu) can be requested by faculty, staff, or grad students in SOIC. Accounts for the latter (recall.ils.indiana.edu) can be requested by SOIC faculty. Request for recall accounts will require consultation with IT staff to ensure that various projects that might be active can coexist. After consultation, various parameters may be re-tuned by IT staff to maximize performance for (a) particular project(s). Requests should include all the information described in the MySQL section above. In addition, the IP address of the workstation(s) or server(s) that need access should be provided. The ILS PostgreSQL servers accept connections only from a known list of IP addresses and on port 5433 using ssl/tls.