You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

In this section:

Preparing the Database Table Structure

DTP uses a database called "DTP" to store data and retrieve data. You can create the database structure from the UI when you log into DTP for the first time.

You also can run the database creation script located in the DTP_HOME/bin/ directory to quickly set up the databases. Run the script after the initial DTP installation but before the services are started. See Stopping DTP Services for instructions on how to stop services if they are already running.

A defect in the MySQL 8.x JDBC connector may cause the database creation process may fail.

Check the dtpconsole-db.log log for the following error (the log may include additional messages):  

The server time zone value 'PDT' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc time zone value if you want to utilize time zone support.

The error message will specify your timezone. If you see this error after a database creation script failure, set the serverTimezone property in MySQL to your timezone and re-run the script.

Running the Database Creation Script on Windows

The database creation script packaged in the Windows installer will only create new database schemas and schema objects. Administrative privileges is required to execute this script.

  1. Open the DTP_HOME/bin directory in Windows Explorer.
  2. Right-click databasesetup.bat and choose Run as administrator from the contextual menu.
    The script checks for previously configured database connection settings. Provide the database connection settings if necessary. Default values for prompts will be shown in brackets if available.
  3. Start up the DTP services after the script completes successfully. See Starting DTP Applications.

Running the Database Creation Script on Linux

  1. Open the DTP_HOME/bin directory and run the dtpconsole.sh script.
  2. Choose Option 5 - Database configuration when the console opens.
  3. The script checks for previously configured database connection settings. If a database has not been previously configured, then you will be prompted to either create a new database schema, populate an existing schema with schema objects, use a previously configured database schema, or perform no actions.
  4. Provide the database connection settings parameters when prompted. Default values for prompts will be shown in brackets if available.
  5. Start up the DTP services after the script completes successfully. See Starting DTP Applications.

Connecting to the Database

When the database creation scripts have run successfully, you can set the authentication settings for connecting to the database through the web UI. After logging in and the license code is accepted, Parasoft checks the database structure and redirects you to the Database Settings page if applicable. If you have not met the JDBC driver requirement (see JDBC Drivers), you will receive a message prompting you to download the driver.

Default Database Passwords

The default password for connecting to the database is U%Cew2d6

The validate_password option is enabled and set to MEDIUM for new DTP installations. When enabled, MySQL checks for password length; numeric, lowercase/uppercase, and special characters.

See the MySQL documentation for additional information:

https://dev.mysql.com/doc/refman/8.0/en/validate-password-options-variables.html

When the JDBC driver is installed, you can configure your database connections or create new databases. There are three options available:

If you are connecting to an Oracle database on Amazon RDS, you will need to create the database structure first. See Creating DTP database structure at Amazon RDS for Oracle. When the database structure has been created, proceed to Create a DTP schema for an existing database below.

Connect to an existing DTP database

To connect to an existing DTP database using existing user credentials:

  1. Click Configure Database Settings and select Connect to existing DTP database in the window that appears.
  2. Click Next.

  3. Select a database type: MySQLOracle, or PostgreSQL.
  4. Enter the database URL and user credentials, then click Test Connection to confirm that it is correct.

  5. Click Save & Connect to connect to the database.

Create a new DTP database, user, and schema

To create a new DTP database and schema as well as new user credentials:

  1. Click Configure Database Settings and select Create new DTP database, user, and schema in the window that appears.
  2. Click Next.

  3. Select a database type: MySQLOracle, or PostgreSQL.
  4. Enter the database URL and root credentials, then click Test Connection to confirm that it is correct.
  5. Click Next.

  6. Enter new user and credentials and click Create Database.

    Existing Parasoft Users

    The processes will fail if the Parasoft default "dtp" user already exists. In this rare scenario, you can manually create the database and users, then go through the Create a DTP schema for an existing database described below. Alternatively, you can drop the "dtp" user before running this process.

Create a DTP schema for an existing database

To create a DTP schema for an existing database with existing user credentials:

  1. Click Configure Database Settings and select Create DTP database schema in the window that appears.
  2. Click Next.

  3. Select a database type: MySQLOracle, or PostgreSQL.
  4. Enter the database URL and user credentials, then click Test Connection to confirm that it is correct.
  5. Click Create Schema.


Switching to an External Database

If you installed the DTP distribution with an embedded database, you can switch to an external database at your convenience. Be aware that once DTP has been configured to use an external database, it cannot be configured to use an embedded database again (though it can be configured to use a different external database). Make sure that your database meets the requirements described in Database Requirements.
  1. Choose Report Center Settings from the main menu (gear icon).
  2. Click Database Settings.
  3. Click Configure Database Settings and follow the instructions for preparing and configuring the external database as described in Connecting to the Database.

Follow the instructions for preparing and configuring the external database as described in Connecting to the Database.

  • No labels