Deployment Guide › Technical Information › Command Line Parameters for Msiexec.exe › Database Variables

Previous Topic: List of Components

Next Topic: Examples

Database Variables

When installing a CMS or gateway from a command line, you can use these variables to configure the database engine and the database account used by CA DLP. For key variables, you must supply a new value; for others, you only need to include the variable if you want to use a non-default value. Examples are shown at the end of this section.

Note: Note that these database details cannot not be validated during the installation; you must ensure that you have entered them correctly, otherwise the installation will fail.

Important! All database variables and their values must be in uppercase.

These variables are described below.

WGNDATABASETYPE=<type>

Identifies the database engine that you will use on the CMS. <type> is either MSSQL or ORACLE. If you omit this variable, the database engine defaults to MSSQL.

WGNDATABASESERVER=<server>

Identifies the host server for your database, where <server> is the name or IP address of the database server. If you specify a computer name, you must enclose the name in double quotes.

If you omit this variable, the database server defaults to localhost. This specifies a database on the local machine.

WGNDATABASEIPPORT=CA Portal

Specifies the TCP/IP port number used by the database host server. If you omit this variable, the default depends on the type of database engine (as specified by WGNDATABASETYPE). Note that you do not normally need to change these defaults, meaning you can normally omit this variable. The default port numbers are:

1433 for SQL Server.

1521 for Oracle.

WGNDATABASESERVICENAME=<service>

For Oracle databases, this specifies a service name to identify the correct database tables, where <service> is the name of the Oracle service.

Important! Do not omit this variable; you must supply a service name.

Note: This is not required for SQL Server databases.

WGNDATABASENAME=<dbname>

For SQL Server databases, this specifies the name of the database, where <dbname> is the database you want to create or (if already created) use on the database server.

If you omit this variable, the database name defaults to WGN_<machine name> where <machine name> is the name of the server on which you are installing the CMS or gateway.

Note: This is not required for Oracle databases.

WGNDATABASEUSERNAME=<username>

Specifies the user name for a valid database account, where <username> is the user name. WGNDATABASEUSERNAME must be in upper case. CA DLP uses this account to access the CMS database. You must ensure that the account has appropriate roles and privileges.

Note: This value is still supported, but has been superseded by WGNDBPRIMARYUSERNAME.

WGNDATA=<path>

Specifies the name and network location of the data folder. This folder contains all the configuration data and captured data used by the CA DLP installation. <path> is the full path to this folder.

To specify a remote location, you cannot specify a mapped network drive. Instead, you must enter a network file share, using the universal naming convention, for example:

\\MyMachine\share_name\target_folder

If you omit this variable, the folder defaults to CA’s \data\log subfolder of the Windows All Users profile.

WGNDATABASEPASSWORD=<password>

Specifies the password for the database account used by CA DLP, that is, the account specified by WGNDATABASEUSERNAME. If you omit this variable, the password defaults to null (that is, no password is needed to access the database).

Note: This value is still supported, but has been superseded by WGNDBPRIMARYPASSWORD.

WGNDBPRIMARYUSERNAME=<username>

Specifies the user name for a valid CA DLP database user account, where <username> is the user name. CA DLP uses this account to access the CMS database. You must ensure that the account has appropriate roles and privileges, unless you intend to specify WGNDBPRIMARYCREATEACCOUNT which assigns the appropriate roles and privileges automatically.

WGNDBPRIMARYPASSWORD=<password>

Specifies the password for the database account used by CA DLP, that is, the account specified by WGNDBPRIMARYUSERNAME. If you omit this variable, the password defaults to null (that is, no password is needed to access the database).

WGNDBPRIMARYCREATEACCOUNT=1

Set this optional variable to 1 to specify that if no valid database account exists on the server, then CA DLP will automatically create one with the appropriate roles and privileges.

WGNDBPRIMARYTABLESPACENAME=<name>

(Oracle only) This specifies a valid name name to identify the correct tablespace for the primary database account, where <name> is the name of the Oracle database tablespace.

Important! Do not omit this variable; you must supply a tablespace name.

WGNDBSEARCHUSERNAME=<username>

Specifies the user name for the database search user account, where <username> is the user name. CA DLP uses this account when searching

the CMS database for events. You must ensure that the account has appropriate roles and privileges, unless you specify WGNDBSEARCHCREATEACCOUNT which assigns the appropriate roles and privileges automatically.

Note: This is a secure account that is subject to ‘row level security’ when searching the database for events. This ensures that reviewers cannot see events associated with users outside of their management groups.

WGNDBSEARCHPASSWORD=<password>

Specifies the password for the database search user account used by CA DLP, that is, the account specified by WGNDBSEARCHUSERNAME. If you omit this variable, the password defaults to null (that is, no password is needed to search the database).

WGNDBSEARCHCREATEACCOUNT=1

Set this optional variable to 1 to specify that if no valid search user account exists on the server, then CA DLP will automatically create one with the appropriate roles and privileges.

WGNDBSEARCHTABLESPACENAME=<name>

(Oracle only) This specifies a valid name to identify the correct tablespace for the search user account, where <name> is the name of the Oracle database tablespace.

Important! Do not omit this variable; you must supply a tablespace name.

WGNDBOWNERUSERNAME=<username>

(Oracle only) This optional variable specifies the user name for the database owner user account, where <username> is the user name. This account owns the database schema in preference to the primary user. You must ensure that the account has appropriate roles and privileges.

WGNDBOWNERPASSWORD=<password>

(Oracle only) This optional variable specifies the password for the database owner account used by CA DLP, that is, the account specified by WGNDBOWNERPASSWORD. If you specify WGNDBOWNERUSERNAME but omit this variable, the password defaults to null (that is, no password is needed to access the database).

WGNDBOWNERCREATEACCOUNT=1

(Oracle only) Set this optional variable to 1 to specify that if no valid database owner account exists on the server, then CA DLP will automatically create one with the appropriate roles and privileges.

WGNDBOWNERTABLESPACENAME=<name>

(Oracle only) This specifies a valid name to identify the correct tablespace for the database owner account, where <name> is the name of the Oracle database tablespace.

Important! Do not omit this variable; you must supply a tablespace name.

WGNDBADMINUSERNAME=<username>

Specifies the user name for database administrator account, where <username> is the user name. CA DLP uses this account to create users. You must ensure that the account has appropriate roles and privileges.

This variable is only required if any of the following are set to 1:

WGNDBADMINPASSWORD=<password>

Specifies the password for the database administrator account used by CA DLP. That is, the account specified by WGNDBADMINUSERNAME.

Important! Do not omit this variable; you must supply a password for this account.