(Windows) optionsFile.txt

This section provides the list and description of the Windows silent install options, and examples of the option settings needed for each database (Derby, Oracle, MySQL, and MS SQL Server).

Table 9. (Windows) Server silent install options

Option Default Description
AgreeToLicense Yes must be set to "Yes"
SRA_USER_INSTALLDIR c:\Documents and Settings\Administrator\.serena\ra directory to install the Serena Release Automation server.
DB_TYPE derby Use to specify a database vendor other than the default: MYSQL|ORA|SQLSVR
<DB>_USER password database user ID, where <DB> is: DERBY|MYSQL|ORA|SQLSVR
<DB>_PASSWORD password password for database user ID, where <DB> is: DERBY|MYSQL|ORA|SQLSVR
ORA_DB_SCHEMA serena_ra (Required for Oracle) database schema
<DB>_JDBC_DRIVER   (Required)For database other than Derby, JDBC database driver file, where <DB> is DERBY|MYSQL|ORA|SQLSVR
DERBY_PORT 11377 (Required for Derby) specify the Derby port.
<DB>_DB_CONN   (Required)For database other than Derby, database connection, where <DB> is MYSQL|ORA|SQLSVR
AGENT_MUTUAL_AUTH N agent mutual authentication option: y|N
JMS_PORT 7918 server port
IS_INSTALL_MODE silent must be set to: "silent"
TC_PORT 8080 Tomcat port. Only used for new Serena Common Tomcat installations. See the SctFoundLoc option.

(Windows) Examples: Silent Mode Server Installation

This section contains examples of Windows options files configured for each of the databases (Derby, MySQL, Oracle, and MS SQL Server).

Derby Database optionsFile.txt example
AgreeToLicense=Yes
SRA_USER_INSTALLDIR=C:\Documents and Settings\Administrator\.serena\ra
JMS_PORT=7918
AGENT_MUTUAL_AUTH=Y
TC_PORT=8080
DB_TYPE=derby
DERBY_PORT=11377
DERBY_USER=serena_ra
DERBY_PASSWORD=serena_ra
		
MySQL Database optionsFile.txt example
AgreeToLicense=Yes
SRA_USER_INSTALLDIR=C:\Documents and Settings\Administrator\.serena\ra
JMS_PORT=7918
AGENT_MUTUAL_AUTH=Y
TC_PORT=8080
DB_TYPE=mysql
JDBC_DRIVER_SOURCE=c:\TestArea\libloc\mysql-connector-java-5.1.22-bin.jar
MYSQL_JDBC_DRIVER=com.mysql.jdbc.Driver
MYSQL_DB_CONN=jdbc:mysql://localhost:3306/serena_ra
MYSQL_USER=serena_ra
MYSQL_PASSWORD=serena_ra
Oracle Database optionsFile.txt example
...
...
DB_TYPE=oracle
JDBC_DRIVER_SOURCE=c:\TestArea\libloc\oracle-connector-java-5.1.22-bin.jar
ORA_JDBC_DRIVER=oracle.jdbc.driver.OracleDriver
ORA_DB_CONN=jdbc:oracle:thin:@localhost:1521/serena_ra
ORA_DB_SCHEMA=serena_ra
ORA_PASSWORD=serena_ra 
		
SQL Server Database optionsFile.txt example
...
...
DB_TYPE=sqlserver
SQLSVR_JDBC_DRIVER=com.microsoft.sqlserver.jdbc.SQLServerDriver
SQLSVR_JDBC_DRIVER=com.microsoft.sqlserver.jdbc.SQLServerDriver
SQLSVR_DB_CONN=jdbc:sqlserver://localhost:1433;DatabaseName=serena_ra	
SQLSVR_USER=serena_ra
SQLSVR_PASSWORD=serena_ra 
loading table of contents...