Please ensure that the database user used to deploy Open Specimen has the following privileges. Failing to grant any of the mentioned privileges will result in deployment failure. The attribute username on this page defines the username of the database and not the login name used to log on to Open Specimen.

MySQL

Port

Default port: 3306

If MySQL is on different server then you also need to open the MySQL port for communicating with OpenSpecimen

Privileges

Either the user should be a MySQL root user or have the following privileges

1. ALTER
2. ALTER ROUTINE
3. CREATE
4. CREATE ROUTINE
5. CREATE VIEW
6. DELETE
7. DROP
8. EXECUTE
9. INDEX
10. INSERT
11. LOCK TABLES
12. SELECT
13. TRIGGER
14. UPDATE
15. REFERENCES

...

In the case of an upgrade, take a manual backup of the database, this will create back updumpondatabase up dump on database server machine.

mysqldump -u [uname] -p[pass] --routines db_name > db_backup.sql

...

Default port: 1521

If Oracle is ondifferent serverthen on different server, then you also need to open the Oracle port for communicating with OpenSpecimen.

Privileges

1. Either the user should be a Oracle sysdba user or have the following privileges
2. CONNECT
3. RESOURCE
4. CREATE ANY TABLE
5. DROP ANY TABLE
6. CREATE ANY TRIGGER
7. DROP ANY TRIGGER
8. CREATE ANY VIEW
9. DROP ANY VIEW
10. CREATE ANY PROCEDURE
11. DROP ANY PROCEDURE

...

Import the dump and check the table count and records count per table, should match with original DB.

Best practices to follow

Setstrong Set strong password (combination of alpha numeric and special characters) for the database user.

MySQL

• Do not useroot userfor use root user for connection from OpenSpecimen. 
• Create a separate user for the database for OpenSpecimen and provide the access to this database only. Use below command:

...

• Create and assign separate tablespaceto the OpenSpecimen userseparate tablespaceto tablespace to the OpenSpecimen user.