EECS Technical Database

User Tools

Site Tools

You are here: Technical Database » Departmental Services » Database Access
Trace: • Database Access
services:database

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
services:database [2024/02/06 15:45] – jasservices:database [2024/02/07 11:00] (current) – jas
Line 1: Line 1:
-====== Database Access (Undergrad) ======+====== Database Access ======
  
-A Postgres database is available for EECS courses requiring database use.  Faculty who want to use the database in their course can send a request to tech including the respective course and section numbers. The tech team will create a database for each student in each course.  +A Postgres database is available for EECS courses requiring database use.  Faculty who want to use the database in their course can send a request to tech including the respective session, term, course and section numbers. The tech team will create a database for each student in each course.  Faculty should also request access to the database for their course TAs. 
 + 
 +At the end of the term, all user databases will be removed.
  
 ===== Access Database By CLI ===== ===== Access Database By CLI =====
  
-In order to access the database by command line, students can issue the "psql" command from any EECS tech-supported Linux system.  Students must be enrolled in a course that has requested database access.  The student will be logged into Postgres, and connected to a database that has the same name as their EECS username.+In order to access the database by command line, students use the "psql" command from any EECS tech-supported Linux system.  Students must be enrolled in a course that has requested database access.  Students will be automatically logged into the database, and connected to their own database which has the same name as their EECS username. 
  
 ===== Access Database By GUI ===== ===== Access Database By GUI =====
  
-An enterprise database GUI called [[https://dbeaver.com/dbeaver-enterprise/|DBeaver Enterprise]] is available for students to access the database.  Students will need to complete the steps below one time:+An enterprise database management tool called [[https://dbeaver.com/dbeaver-enterprise/|DBeaver Enterprise]] is available for students to access the database via a GUI.  Students will need to complete the steps below one time:
  
-  * From the Linux terminal, type "id -u".  You will get back a number.  Record that number. +  * From the Linux terminal, type "id -u".  You will get back a number.  Record that number as it will be used in a later step. 
-  * Start DBeaver with the "dbeaver" command.+  * Start DBeaver either from the command line with the "dbeaver" command, or via GNOME (Click on "Activities", then type "dbeaver" in the search).
   * When DBeaver starts, you will be prompted: "Do you want to create sample database? It can be used as an example to explore basic DBeaver Enterprise features".  You can select Yes/No.   * When DBeaver starts, you will be prompted: "Do you want to create sample database? It can be used as an example to explore basic DBeaver Enterprise features".  You can select Yes/No.
   * From the "File" menu, choose "New", then open "DBeaver" folder, then select "Database Connection".   * From the "File" menu, choose "New", then open "DBeaver" folder, then select "Database Connection".
Line 20: Line 23:
   * In the "Connect to a database" window, change:     * In the "Connect to a database" window, change:  
     * Hostname: db.eecs.yorku.ca     * Hostname: db.eecs.yorku.ca
-    * Database: <specify your username>+    * Database: <your EECS username>
     * Authentication: change to "PostgreSQL Kerberos"     * Authentication: change to "PostgreSQL Kerberos"
     * Username: <your EECS username>     * Username: <your EECS username>
Line 28: Line 31:
     * Password: <enter your EECS password>     * Password: <enter your EECS password>
   * Next, click on "Extra Configuration" which opens up a few options.   * Next, click on "Extra Configuration" which opens up a few options.
-  * Check off: "Use kinit" and specify: /tmp/krb5cc_<uid> where <uid> is the number you recorded in the first step.  +    * Check off: "Use kinit" and replace the contents of the text field with: /tmp/krb5cc_<uid> where <uid> is the number you recorded in the first step.  
-  * Click "Finish". +    * Click "Finish". 
-  * Under "Database Navigator" tab, you will see: "<your EECS-username> - db.eecs.yorku.ca:5432" +  * Under "Database Navigator" tab, you will now see: "<your EECS-username> - db.eecs.yorku.ca:5432" 
-  * Open this up, and you will be connected to your personal database. +  * Click on the down arrow, and you will be connected to your personal database.
- +
- +
- +
- +
- +
- +
- +
- +
- +
- +
-First time connection is a little challenging, and requires the following steps: +
- +
  
 +When you start dbeaver in the future, these settings will already be saved.
  
services/database.1707252319.txt.gz · Last modified: by jas