InstallationThis document describes how to install the Profile Setup software web application contained in the profile-manager package. The following topics can be found in this document: System RequirementsThe Profile Setup web application was developed using Java and jQuery and will run under a standard Java Application Server. The application was specifically developed under Sun Java version 1.6, so the tool will execute correctly under versions 1.6 or later. Since the tool was developed using Sun's Java, the target Java Application Server should support Sun's Java Runtime Environment (JRE). The application was tested using Apache's Tomcat version 5.5.X, which is the preferred Java Application Server for deployment. The software can be obtained from the Apache Tomcat web site. Other Java Application Servers should be compatible. The Profile Setup software also requires a MySQL Server installation for hosting the Report Service database. The application was tested using the Community Server 5.X.X. The web application also requires that Sawmill (8.X.X) be installed on the local machine in order for the software to perform its duty of configuring profiles for the service as needed. See the Sawmill Installation instructions for more detail. Unpacking the PackageDownload the profile-manager package from the PDS FTP site. The binary distribution is available in identical zip or tar/gzip packages. Unpack the selected binary distribution file with one of the following commands: [node: ~] unzip profile-manager-1.4.0.zip or [node: ~] tar -xzvf profile-manager-1.4.0.tar.gz Note: Depending on the platform, the native version of tar may produce an error when attempting to unpack the distribution file because many of the file paths are greater than 100 characters. If available, the GNU version of tar will resolve this problem. If that is not available or cannot be installed, the zipped package will work just fine in a UNIX environment. The commands above result in the creation of the profile-manager-1.4.0 directory with the following directory structure:
Creating and Loading the DatabaseThe Profile Setup software requires a MySQL Server instance to host the Report Service database. If the target environment does not already have a MySQL Server instance installed, have an instance installed before continuing the installation. The software can be obtained from the MySQL web site. Once the MySQL Server instance is installed and/or identified, the database and user account for theProfile Setup software must be created. The following commands detail the steps for logging into the server, creating the database and creating the user account to access the database: % mysql -u root -p Enter password: mysql> create database {database}; Query OK, 1 row affected (0.00 sec) mysql> grant all on {database}.* to {username}@localhost identified by '{password}'; Query OK, 0 rows affected (0.00 sec) The values contained in the {} must correspond with the values in the database.properties file. See the Configuring Database Access section for more details. Now that the database and corresponding account are available, it is time to load the database with a MySQL dump that contains the necessary tables for the database. The following commands will load the database: % cd profile-manager-1.4.0/conf % mysql -u {username} -p{password} {database} < report_service_db.sql The above command can be run against a previously populated database since the script drops and recreates the tables each time it is loaded. Also note that there are no spaces between the -p argument and the password value. Deploying the ApplicationThe Profile Setup web application is packaged as a WAR file and is intended for installation under a standard Java Application Server. Prior to installation the WAR file should be renamed from profile-manager-1.4.0.war to profile-manager.war. A WAR file is normally copied directly to the webapps directory or installed via the Manager interface. Once this step is complete, the application is ready for operation. Configuring Database AccessThe Profile Setup sofware comes preconfigured to access the MySQL database instance on the operational machine. If this configuration requires modification, the WAR file will need to be unpacked and the ./WEB-INF/classes/database.properties file modified. The file contents are as follows: datasource.url=jdbc:mysql://{machine-name}/{database} datasource.driver=com.mysql.jdbc.Driver datasource.user=pdssaw datasource.password={password} The machine-name value is the only value that is required to be updated, depending on the machine the software is loaded on. The remaining fields should remain the same. If updated, restart Tomcat. Configuring EnvironmentThe Profile Setup software comes preconfigured to create and modify Sawmill profiles as well as transfer web logs from remote locations. In order to ensure stable functionality, several environment variables must be set prior to application deployment. If this configuration requires modification, the WAR file will need to be unpacked and the ./WEB-INF/classes/environment.properties file modified. The file contents are as follows: sawmill.home=/usr/local/report/sawmill sawmill.profile.home=/usr/local/report/sawmill/LogAnalysisInfo/profiles sawmill.log.home=/usr/local/report/logs The values in this properties file should remain unchanged, however, update them as needed per the current environment. If updated, restart Tomcat for the changes to take effect.
|