Installing Moab Viewpoint

Installing Moab Viewpoint

These instructions describe how to install and start Moab Viewpoint.

To install Moab Viewpoint

  1. Create the Viewpoint database.
  2. MySQL 5.1 is the supported database for Moab HPC Suite. You must create the database and give the user full access to that database. For information on creating databases and granting access with other database vendors, consult the documentation for that vendor.

    While MySQL is the only supported database for Viewpoint, the use of other databases with Moab HPC Suite is possible. Please contact Adaptive Computing Support for more information.

    For information on creating databases and granting access with other database vendors, consult the documentation for that vendor.

    Do the following:

    1. Run these commands.
    2. [root]# chkconfig mysqld on

      [root]# service mysqld start

      [root]# /usr/bin/mysql_secure_installation

    3. When you are prompted for the current root password, press Enter. When you are asked to set the root password, use p@ssw0rd and select y for all options.
    4. Create the Viewpoint database and grant the following permissions (remember to run commands in context):
    5. [root]# mysql -u root –p

      Enter password:

      mysql> CREATE DATABASE viewpoint;

      Query OK, 1 row affected (0.08 sec)

      mysql> GRANT ALL ON viewpoint.* TO viewpoint@localhost IDENTIFIED BY 'p@ssw0rd';

      Query OK, 0 rows affected (0.31 sec)

      mysql> GRANT ALL ON viewpoint.* TO [email protected] IDENTIFIED BY 'p@ssw0rd';

      Query OK, 0 rows affected (0.31 sec)

      FLUSH PRIVILEGES;

      Query OK, 0 rows affected (0.31 sec)

    6. Verify that the script ran correctly by running a third party client such as SQuirrel SQL or by using your database vendor's own client tool (for instance, run mysql -u <username> -p <password>).
    7. As a best practice, create a schema if you are running PostgresSQL. It is recommended that you call the schema viewpoint. If you choose not to create one, set public as the schema name when you configure the setup.properties file.

  3. Untar the Viewpoint tarball, and create the initial tables required for an HPC Viewpoint.
  4. [root]# tar xzvf viewpoint-7.1.0.tar.gz

    [root]# mysql -u root -p viewpoint < viewpoint-7.1.0/sql/mysql/setup_hpc.sql

  5. Install the JDBC Driver for MySQL (available from MySQL or another trusted source).
  6. [root]# tar xvzf mysql-connector-java-x.x.x.tar.gz

    [root]# cd mysql-connector-java.x.x.x

    [root]# cp mysql-connector-java.x.x.x-bin.jar /usr/share/tomcat6/lib

  7. Create the Viewpoint home directory.
  8. [root]# mkdir /opt/viewpoint

  9. Navigate to the Viewpoint extraction directory, and deploy the war files (reporting.war is optional).
  10. [root]# cd viewpoint-7.1.0/

    [root]# cp dist/*.war /var/lib/tomcat6/webapps/

    It is recommended that you do not run more than one instance of Viewpoint within Tomcat.

  11. Copy the setup.properties.[db_type] file to the Viewpoint home directory and change the name to setup.properties (removing the .[db_type] extension).
  12. [root]# cp templates/setup.properties.mysql /opt/viewpoint/setup.properties

  13. Open setup.properties for modification.
  14. [root]# vi /opt/viewpoint/setup.properties

    Change the username and password to what you set when you configured the database.

    dbUser=<viewpoint>

    dbPassword=<p@ssw0rd>

  15. Set the Tomcat user as the owner of the Viewpoint home directory. Restart Tomcat.
  16. [root]# chown -R tomcat:tomcat /opt/viewpoint

    [root]# service tomcat6 restart

    If you are running Fedora, you must start Tomcat by navigating to $CATALINA_home/bin/ and run startup.sh as root:

    [root]# $CATALINA_HOME/bin/startup.sh

  17. Verify that Viewpoint was correctly installed by directing your browser to the Viewpoint URL (for example: http://[hostname or ip address]:8080/moab), and logging in with the default username and password (admin/admin).
  18. Update the Viewpoint connection to MWS.
    1. From the Administration > Configuration menu, click MWS connection.
    2. Update the Username and Password fields to match the username and password you configured in the /opt/mws/etc/mws-config.groovy file and click Update.
    3. Restart Tomcat.
    4. [root]# service tomcat6 restart

Related topics