Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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.

...

  1. Either the user should be a an 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

...

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 ORACLE_HOME is set properly and the system variable PATH contains ORACLE_HOME/bin.

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:

...