...

Preparing the Database via Command Line

Follow the directions below that are appropriate for your database. Once you have prepared your database, see Connect to an Existing DTP Database below for information about connecting DTP to your database.

Preparing MySQL DB via Command Line

...

1. Click Configure Database Settings and select Create new DTP database, user, and schema in the window that appears.
   
2. Click Next.
   Image Modified
   
3. Select a database type: MySQL, Oracle, or PostgreSQL.
4. Enter the database URL and root credentials, then click Test Connection to confirm that it is correct.
5. Click Next.
   Image RemovedImage Added
   

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

   Info
   title 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.

...

1. Click Configure Database Settings and select Connect to existing DTP database in the window that appears.
   
2. Click Next.
   Image Modified
   
3. Select a database type: MySQL, Oracle, 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.

...

1. Click Configure Database Settings and select Create DTP database schema in the window that appears.
   
2. Click Next.
   Image Modified
   
3. Select a database type: MySQL, Oracle, or PostgreSQL.
4. Enter the database URL and user credentials, then click Test Connection to confirm that it is correct.
5. Click Create Schema.

...

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.

"Cannot connect to the DB" error

Check the rs.log for more information about the error, especially toward the end of the file; search for terms like "database", "jdbc", "mysql", "oracle", or "postgres". See Viewing Log Files for more information about DTP logs.