...
Default port: 3306
If MySQL is on a different server then you also need to open the MySQL port for communicating with OpenSpecimen
...
Please set the property default-storage-engine=INNODB. After the changes made, the Mysql server restart is needed.
This property is available in my.ini file in case of Windows and my.cnf in a the case of Linux.
Backup
In the case of an upgrade, take a manual backup of the database, this will create back up a backup dump on the database server machine.
| Code Block |
|---|
mysqldump -u [uname] -p[pass] mysqldump -u<user> -p<password> --single-transaction --skip-lock-tables --routines db_name > db_backup.sqldatabase name | gzip > OPENSPECIMEN_`date +\%d-\%m-\%Y`.SQL.gz |
Oracle
Port
Default port: 1521
If Oracle is on different serverservers, then you also need to open the Oracle port for communicating with OpenSpecimen.
...
- Either the user should be a an Oracle sysdba user or have the following privileges
- CONNECT
- RESOURCE
- CREATE ANY TABLE
- DROP ANY TABLE
- CREATE ANY TRIGGER
- DROP ANY TRIGGER
- CREATE ANY VIEW
- DROP ANY VIEW
- CREATE ANY PROCEDURE
- DROP ANY PROCEDURE
...
| Note: If you are using the ORACLE database, it is mandatory to install the Oracle client on the machine that is hosting the Tomcat/JBoss server. Ensure that the system variable |
Backup
In case of an upgrade, take the manual of the database backup, this will create a back up backup dump on the database server machine.
...
- Do not 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:
...