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.
Table of Contents
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
- ALTER
- ALTER ROUTINE
- CREATE
- CREATE ROUTINE
- CREATE VIEW
- DELETE
- DROP
- EXECUTE
- INDEX
- INSERT
- LOCK TABLES
- SELECT
- TRIGGER
- UPDATE
- REFERENCES
...
Backup
In case of upgrade, take back upmanual the manual of the database backup, this will create a back up dump on the database server machine.
| Code Block |
|---|
expdp <user name>/<password here>@<database name> schemas=<user name> DIRECTORY=DATA_PUMP_DIR DUMPFILE=CATISSUEPLUS_BACKUP.DMP flashback_time=systimestamp |
Import the dump and check the table count and records count per table, should match with original DB.
Best practices to follow
Set a strong password (the combination of alpha numeric alphanumeric and special characters) for the database user.
...