Stat 6.3 - Install Notes

Update the System Maintenance table Install the Stat Central Agent

Installing the Stat Central Agent Configuring the Stat Central Agent

Before starting the Stat Central Agent Resolving port and firewall conflicts Stopping the Stat Central Agent Configuring the Stat Central Agent as a Windows service Installing DB2 Support for the Stat Central Agent Configure the Stat Central Agent character map Setting up support for AES256 Ciphers for SFTP Configure Web Client to use HTTPS Connection pool idle time Configure Web Client and Web Services to use custom URL Installing multiple servers on one host computer

Testing Database and Server Connections

Install the Stat Oracle Agent (Oracle E- Business Suite only)

Configuration Administration Dynamically changing log level Stat Oracle Agent version Custom products and file locations Base directory codes Verifying the Stat Oracle Agent

Configure the SYSTEM user account Update the PS Object Mover Instructions (PeopleSoft Only) Implement Stat

Edit the INI file

The Stat® INI Editor is a GUI application designed to create new INI files and edit existing ones. The INI Editor displays all the database profile records contained in the Stat.ini file in an easy-to-read format. For more detailed instructions, see the Stat System Administration Guide, Chapter 2, Administrative Utilities.

The Stat.ini file contains the information Stat needs to connect to Stat databases. Stat.ini is located in the Stat version-specific documents folders.

•

The location of the stat.ini file is C:\ProgramData\Quest Software\Stat\6.3.0.

IMPORTANT: The stat.ini file may be hidden depending on the file security settings on your computer.

The Database tab in the INI Editor lists the database(s) to which Stat can connect. From here you can edit an existing INI file entry or create a new one. The INI Editor helps edit a file by asking for the exact information it needs. For example, if the DSN field is not required for a particular database, that field is grayed out.

To create an INI file entry:

Select File | New.

Select Edit | New Record.

Enter the name of the database, and click OK.

The Stat INI Editor adds a new database profile to the record sheet.

In the DBMS field, select a DBMS.

The default is Microsoft® SQL Server®. Depending on the DBMS you select, the STAT INI Editor prompts you to define different values.

Enter the STATLOGIN password in the Encrypted Login Password field, either by entering an encrypted password from another stat.ini file or by clicking Change Password and entering the STATLOGIN password.

In the remaining fields, specify additional parameters as needed.

Select File | Save as, and specify a name for the INI file.

Click Save.

The following table contains general database connection settings for the Stat INI Editor. Each record in the Stat INI Editor represents a database in the INI file. For more general information on available DBMS settings, see any of the Environment Connection Maintenance sections in the Stat System Administration Guide, Chapter 4, General Maintenance Tables.

Table 3. General database connection settings for the Stat INI Editor

Value	Description
DBMS	Database interface identifier. This identifier is DBMS and DBMS release specific.
Server Name (SQL Server)	The name of the database server that houses the Stat Repository.
NET_SERVICE_NAME (Oracle)	TNS entry name (NET_SERVICE_NAME)
Database (SQL Server)	Database name
Loginid	The login ID used for the Stat first-pass login. Not used by all DBMS. This entry should always be STATLOGIN.
Encrypted Login Password	The encrypted password of STATLOGIN. This value can be changed, as described below.
Connect Time Out Secs	Number of seconds to wait for a connection to the database before timing out. Not supported by all RDBMS.
OtherDbParm	Additional database connection parameters, if needed. For Oracle databases that use a comma rather than a period as a decimal separator, enter the value: DecimalSeparator=','.
Unicode (SQL Server)	Type Y if you are running Stat on a Unicode database (in order to support PeopleSoft Unicode databases) and the DBMS is SQL Server. Otherwise leave blank.
Enable DB Trace	Configures Stat to write a trace log of all commands. Selecting this option impacts the client application’s processing speed and should only be selected if directed to by Support.

Update the System Maintenance table

After configuring the Stat® database, the next step is to login to Stat for the first time using the special SYSTEM user account and to update the System Maintenance table. The System Maintenance table is where you define global operating parameters for your installed copy of Stat and verify your license. For more information, see the Stat System Administration Guide, Chapter 4, General Maintenance Tables.

To update the System Maintenance table:

When prompted, enter a password that is easily remembered.

CAUTION: The SYSTEM account is the only way to log into the Stat Client until other users are defined. When prompted for the initial password, enter a password that is easily remembered. A more secure password can be defined later.

Full access to Stat 6.3.0 requires a license key. Until the license key is entered, you can only access the System Maintenance window in the client application.

Select Maintenance | General | System Maintenance.

In the General tab, enter the site name, address, phone number, etc.

In the License tab, do the following to enter the Stat license key:

Enter the License Key and Site Message.

Test the key by clicking Verify.

A valid key will include the following License Properties:

•

The type of license. Options include Commercial (permanent), Trial (temporary) and Term (a temporary enhancement of licensing rights for commercial users)

•

Number of Technical Licenses

•

Number of Functional Licenses

•

Licensed Modules - a check mark denotes the module is licensed; an X indicates the module is not licensed.

(Optional) Change the default Country on the Other Options tab. The default is USA.

When finished, click OK.

At this point, you should not perform any more configuration tasks within the Stat Client application until after you have installed the Stat Central Agent and (for users on Oracle® Applications) the Stat Oracle Agent. Later, once all the necessary components have been installed and configured, you will be instructed to log in again with the SYSTEM account and configure the client application, as described in the section, Configure the SYSTEM user account.

Exit the Stat application.

Install the Stat Central Agent

The Stat® Central Agent is a Java®-based application that contains the business logic for Stat and the UI for Stat Web client.

The following instructions apply to both Windows® and Unix® platforms. Be sure to adjust your path and environment settings to suit your platform. After installation, the startup may report errors. These are often caused by port conflicts. To resolve such conflicts, see Resolving Port and Firewall Conflicts.

Before you install the Stat Central Agent, you may want to log in to the Stat Client and perform certain configuration tasks, such as setting up service domains, defining users, and establishing connections between Stat and your native application environments and ftp file servers. It is not necessary that you configure Stat before installing the Stat Central Agent, but if installing on Windows®, this will allow you to test connectivity parameters. For PeopleSoft® users running on any platform except DB2®, this entails specifying the appropriate values in the Host Name, DB Listener Port, and (if running PeopleSoft on Oracle®) Service Name fields in the PeopleSoft Environment Connection Maintenance table. For more information, see Implement Stat and the Stat System Administration Guide, Chapter 4, General Maintenance Tables.

NOTE: If you are running PeopleSoft on a DB2 platform, see Installing DB2 Support for the Stat Central Agent for additional information.

Installing the Stat Central Agent

Stat® provides a platform on which you can install the Stat Central Agent.

You need to have a Java® Development Kit (Java SDK) installed and a system variable called JAVA_HOME
that points to the JDK installation root directory (e.g., C:\Program Files\Java\jdk1.8.0_191).

If you are running Windows® or Solaris and Java® is not installed, or if you have an older version of Java installed, go to http://www.oracle.com/technetwork/java/javase/downloads/index.html and download the appropriate version.

CAUTION: If running on a 64-bit environment, make sure the JDK installation root directory does not include spaces. The Stat Central Agent cannot run if it does.

To install the Stat Central Agent:

Insert the Stat CD.

The Stat Autorun program launches automatically.

Click Install Stat Central Agent.

Autorun opens the stat_server folder, which contains the subfolder, standalone.

Open the standalone folder, locate the file stat_standalone.zip, and unzip to the desired location on the host computer where you want to install the Stat Central Agent.

An example for Windows® might be c:\stat; on Unix®, this might be /usr/local. The location you choose for the installation is referred to as <STAT_HOME>. Use a file archive utility that supports .zip files to unpack the file on Windows or the unzip utility on Unix.

NOTE: Do not unzip the file stat_standalone.zip file to a directory that contains an exclamation point character (!). For Unix, use the -a modifier to unzip the file.

If copying the installation files to a Unix system, be sure the file transfer settings are set to binary as opposed to ascii.

Edit <STAT_HOME>\app\bin\standalone.conf.bat (Windows) or <STAT_HOME>/app/bin/standalone.conf (Linux/Unix) by locating the line with the setting STAT_HOME. Then uncomment the command and set the value for the variable.

Alternatively, you can create a system environment variable called STAT_HOME with a value of <STAT_HOME> from the previous step.

NOTE: Do not add a backslash character (\) to the end of the STAT_HOME variable.

To run the Stat Central Agent as a Windows Service instead, see Configuring the Stat Central Agent as a Windows Service. We recommend that you first configure and test the agent before creating the service.

Configure the Stat Central Agent as required by your environment.

These issues are documented in Configuring the Stat Central Agent Platform. Note that while you can address some configuration issues after you have completed installing the Stat Central Agent, you should address others before you proceed to the next step in the installation. These particular issues are documented in the subsection Before Starting the Stat Central Agent.

Use run.bat or run.sh to start the Stat Central Agent NOT as a service.

If you have configured the Stat Central Agent to run as a Windows service, use the Windows Service interface to start the agent. Otherwise, this is the typical command to start the server:

•

Windows: <STAT_HOME>\app\bin\run.bat

•

Unix: <STAT_HOME>/app/bin/run.sh

NOTE: If you have port conflicts during startup, the server will display one or more error messages. For instructions on resolving port conflicts, see Resolving Port and Firewall Conflicts.

Optionally you may set the STAT_HOME and JAVA_HOME variables in standalone.conf.bat or standalone.conf file instead of defining system environment variables.

NOTE: If you receive a Connection Refused error when your Stat Windows Client is trying to access the Stat Central Agent, you may need to start your Stat Central Agent with a -b parameter to specify the hostname of the agent. In this case, edit your run.bat (run.sh for Unix) and add -b=<hostname>, where <hostname> is the hostname for the machine running the Stat Central Agent.

For example, in run.bat:

standalone.bat -b=ALVWindows

For example, in run.sh:

./standalone.sh -b=ALVLinux

Wait for the Stat Central Agent startup process to complete

In the server console, you will see the line, Stat Configuration Assistant is ready.

Open your internet browser and go to http://<stat_server_host_machine>:8080/stat-config.

This opens the Configuration Assistant that guides you through the process of configuring the Stat database and the database type-mapping.

CAUTION: If you are not running the agent from the local computer (i.e. Telnet session), you must add the IP address to <STAT_HOME>/config/stat-config.properties or you will not have access to the Configuration Assistant. See Authorize Access to the Configuration Page.

In the Type/Vendor field, select the database platform you are using. Options include Oracle or SQL Server.

10 Enter appropriate information for the Stat database: Host Name, Port, DB/Service Name, Login ID, and Password.

For SQL Server users who have installed multiple instances of SQL Server, specify which instance the Stat Central Agent is running on in the Properties field. Also for users who have ssl enabled for SQL Server, include ssl=require in the Properties field. If you have more than one property, you can use semicolons between different properties. For example, if you are using an instance and also have ssl enbled, you can specify ssl=require;instance=database_instance_name; in the Properties field.

This field flexes to TNS Entry for Oracle users.

For RAC environments, paste the TNS entry for the Stat database in this field. Remove any spaces and any line feeds or carriage returns from the TNS string so that it is one long line.

Choose desired logging setting for the user interface and for the Stat Central Agent application. The default is INFO.

Optionally, specify a session timeout parameter.

The default value is 20 minutes. You can specify any value from 1 minute to 2880 minutes, but be aware that setting higher values may negatively affect performance.

Click Save.

Stat verifies that the Stat database parameters you entered are correct.