Differences
This shows you the differences between two versions of the page.
79:database_config [2024/03/06 01:22] – created - external edit 127.0.0.1 | 79:database_config [2024/03/08 10:19] (current) – removed Weinlein, Thomas | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | [[: | ||
- | |||
- | ====== Database Configuration ====== | ||
- | |||
- | === 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 ''< | ||
- | |||
- | 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: | ||
- | torque.database.default.username=< | ||
- | torque.database.default.password=< | ||
- | </ | ||
- | |||
- | // | ||
- | |||
- | The MySQL configuration can be found in the configuration file '' | ||
- | |||
- | === 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 ''< | ||
- | |||
- | < | ||
- | torque.database.default.driver=oracle.jdbc.driver.OracleDriver | ||
- | torque.database.default.url=jdbc: | ||
- | torque.database.default.username=< | ||
- | torque.database.default.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 " | ||
- | |||