Configuring Viewpoint > Configuring Viewpoint through the interface > Configuring the Viewpoint database via the interface

2.1.2 Configuring the Viewpoint database via the interface

To configure the Viewpoint database through the interface

  1. Run the db_setup.sql script to set up the database.
  2. > mysql -u <USER> -p < pathToVpInstallationDirectory/db_setup.sql

  3. Create the hibernate.cfg.xml file.
  4. If you have not already done so, increase Tomcat's memory from its default setting (for more information, see step 1 in Before installing Viewpoint ).
  5. Open Viewpoint in a browser using the following URL: http://[localhost]:8080/moab. Log in with the default User name and Password (admin/admin). For information about changing the default password, see Changing user passwords in the User Guide.
  6. Click the Configuration button in the navigation bar.
  7. In the left navigation pane, click Viewpoint Config in the Configuration Objects section.
  8. A configuration form appears on the right.

  9. Fill in each field with the requested information.
  10. Field Description
    Type

    Type of database Viewpoint uses.

    The options are mysql and  oracle.

    Host Location where the database server is running.
    Name Unique name of the database on the server.
    User Username used to log in to the database server.
    Password Password for the username of the database server.
    Port Port the database server is listening on.
  11. Click Update.
  12. When you are redirected to Config Home, verify that no errors are present in the Viewpoint database connection. If an error does appear under the Viewpoint header, click the error to be taken back to the configuration page and make any necessary modifications.
  13. Restart the Tomcat server.
  14. > service tomcat stop

    > service tomcat start

Related topics