SUNScholar/Install DSpace/S09

NEXT - STEP 10

Step 9: Perform system tests

Database Tests

Type the following in a terminal:

cd

Test Connection

sudo $HOME/bin/dspace database test

PLEASE NOTE: This command changed with the release of DSpace versions =>5.X. The previous command was: test database.

Example Output

Attempting to connect to database: 
 - URL: jdbc:postgresql://localhost:5432/dspace
 - Driver: org.postgresql.Driver
 - Username: XXXXXXX
 - Password: XXXXXXX
 - Schema: null

Testing connection...
Connected successfully!

Test Schema Updates

sudo $HOME/bin/dspace database info

Example Output

Database Type: postgres
Database URL: jdbc:postgresql://localhost:5432/dspace
Database Schema: public
Database Username: dspace
Database Software: PostgreSQL version 9.5.19
Database Driver: PostgreSQL JDBC Driver version 42.2.1
PostgreSQL 'pgcrypto' extension installed/up-to-date? true (version=1.2)

+----------------+-----------------------------------------------------+---------------------+---------+
| Version        | Description                                         | Installed on        | State   |
+----------------+-----------------------------------------------------+---------------------+---------+
| 1.1            | Initial DSpace 1.1 database schema                  |                     | <Baseln |
| 1.2            | Upgrade to DSpace 1.2 schema                        |                     | <Baseln |
| 1.3            | Upgrade to DSpace 1.3 schema                        |                     | <Baseln |
| 1.3.9          | Drop constraint for DSpace 1 4 schema               |                     | <Baseln |
| 1.4            | Upgrade to DSpace 1.4 schema                        |                     | <Baseln |
| 1.5            | Upgrade to DSpace 1.5 schema                        |                     | <Baseln |
| 1.5.9          | Drop constraint for DSpace 1 6 schema               |                     | <Baseln |
| 1.6            | Upgrade to DSpace 1.6 schema                        |                     | <Baseln |
| 1.7            | Upgrade to DSpace 1.7 schema                        |                     | <Baseln |
| 1.8            | Upgrade to DSpace 1.8 schema                        |                     | <Baseln |
| 3.0            | Upgrade to DSpace 3.x schema                        |                     | <Baseln |
| 4.0            | Initializing from DSpace 4.0 database schema        | 2015-06-29 11:41:18 | Success |
| 4.9.2015.10.26 | DS-2818 registry update                             |                     | Ignored |
| 5.0.2014.08.08 | DS-1945 Helpdesk Request a Copy                     | 2015-06-29 11:41:19 | Success |
| 5.0.2014.09.25 | DS 1582 Metadata For All Objects drop constraint    | 2015-06-29 11:41:20 | Success |
| 5.0.2014.09.26 | DS-1582 Metadata For All Objects                    | 2015-06-29 11:48:34 | Success |
| 5.6.2016.08.23 | DS-3097                                             | 2018-11-21 11:03:07 | Success |
| 5.7.2017.04.11 | DS-3563 Index metadatavalue resource type id column | 2018-11-21 11:18:17 | Success |
| 5.7.2017.05.05 | DS 3431 Add Policies for BasicWorkflow              | 2018-11-21 11:18:18 | Success |
| 6.0.2015.03.06 | DS 2701 Dso Uuid Migration                          | 2018-11-21 11:18:19 | Success |
| 6.0.2015.03.07 | DS-2701 Hibernate migration                         | 2018-11-21 11:26:26 | Success |
| 6.0.2015.08.31 | DS 2701 Hibernate Workflow Migration                | 2018-11-21 11:28:06 | Success |
| 6.0.2016.01.03 | DS-3024                                             | 2018-11-21 11:28:06 | Success |
| 6.0.2016.01.26 | DS 2188 Remove DBMS Browse Tables                   | 2018-11-21 11:28:06 | Success |
| 6.0.2016.02.25 | DS-3004-slow-searching-as-admin                     | 2018-11-21 11:28:06 | Success |
| 6.0.2016.04.01 | DS-1955 Increase embargo reason                     | 2018-11-21 11:28:06 | Success |
| 6.0.2016.04.04 | DS-3086-OAI-Performance-fix                         | 2018-11-21 11:28:06 | Success |
| 6.0.2016.04.14 | DS-3125-fix-bundle-bitstream-delete-rights          | 2018-11-21 11:28:08 | Success |
| 6.0.2016.05.10 | DS-3168-fix-requestitem item id column              | 2018-11-21 11:28:08 | Success |
| 6.0.2016.07.21 | DS-2775                                             | 2018-11-21 11:28:08 | Success |
| 6.0.2016.07.26 | DS-3277 fix handle assignment                       | 2018-11-21 11:28:08 | Success |
| 6.0.2016.08.23 | DS-3097                                             | 2018-11-21 11:28:08 | Success |
| 6.1.2017.01.03 | DS 3431 Add Policies for BasicWorkflow              | 2018-11-21 11:28:09 | Success |
+----------------+-----------------------------------------------------+---------------------+---------+

Email Test

Type the following in a terminal:

cd

sudo $HOME/bin/dspace test-email

Check your DSpace admin email account to see if you received a message.

Example Output

About to send test email:
 - To: XXXXXX@XXX.XX.XX
 - Subject: DSpace test email
 - Server: mail.sun.ac.za

Email sent successfully!

PREVIOUS - STEP 8