MySQL Database Configuration
Stages uses per default a local MySQL database. To use a different configuration – either a different database type or a different database host – modify the configuration file
<STAGESHOME>/conf/database.properties. As this file contains the database password in cleartext, protect it from unauthorized access with appropriate permissions.
The default configuration is connected to a MySQL database server running on the same server like the Stages application. The database name is pkit. Stages connects to the database with the username/ password pair specified in the configuration file. The database administrator account is called root and has the same password as the user in the configuration file.
It is sufficient to change the following four lines in the configuration file:
torque.database.default.driver=org.gjt.mm.mysql.Driver torque.database.default.url=jdbc:mysql://localhost/pkit torque.database.default.username=<DATABASEUSER> torque.database.default.password=<PASSWORD>
Important: The rest of the configuration file should not be changed.
The MySQL configuration can be found in the configuration file
C:\winnt\my.ini, resp., if using a Linux OS at
/opt/projectkit/mysql/data/my.cnf. Detailed information about MySQL configuration and tuning can be found under http://www.mysql.com/documentation/.
Oracle Database Configuration
In addition to MySQL, Stages is also able to interact with an Oracle database system. The configuration of an Oracle based Stages installation is similar to the setup described in section MySQL database configuration.
To enable the connection to the Oracle database you need to modify the file
<STAGESHOME>/conf/database.properties and set the parameters DB_HOST, DB_PORT, SID, ORACLE_USERNAME and PASSWORD appropriately. The parameter DB_HOST identifies the name of the Oracle server and DB_PORT the port number on which the Oracle server listens for incoming connections (port 1521 per default). The parameter SID is a unique name for your Oracle system. Please ask your Oracle database administrator to provide the necessary information.
torque.database.default.driver=oracle.jdbc.driver.OracleDriver torque.database.default.url=jdbc:oracle:thin:@<DB_HOST>:<PORT>:<SID> torque.database.default.username=<ORACLE_USERNAME> torque.database.default.password=<PASSWORD>
Note: Please notice that in contrast to a MSySQL based Stages installation the setup of the database has to be performed manually, you can find more informations in the Upgrade Guide.
To be able to use Stages with an Oracle database it is necessary to send the “tablespace name” as well as Oracle “user name” to the Stages support to receive an appropriate dump of an empty Stages database.