QA:Testcase DB role cli

Associated release criterion
This test case is associated with the Database server role requirements. If that is a Featured server role and you are doing release validation testing, a failure of this test case may be a breach of the Alpha, Beta, or Final Fedora release criteria requiring Featured server roles to meet their functional requirements. If so, please file a bug and nominate it as blocking the appropriate milestone, using the blocker bug nomination page.

Description

Test basic functionality of the Database Server Role

Setup

1. Deploy a correctly-configured Database Server. You can follow:

   QA:Testcase_Server_role_deploy with the Database Server role to deploy a PostgreSQL database server on Fedora 22 or later.

2. Make note of the IP or hostname of the database server as well as the database name provided in the settings-file.
3. If the database was created with a default owner and auto-generated password, retrieve those with the command

   rolectl settings databaseserver/<instance>

   (You can use tab-completion if you don't know the instance name)

How to test

Test whether a remote psql client can communicate with the database

1. Install the postgresql package on another machine on the same network as the database server.
2. Run the following command to verify the presence of the database

   psql -h hostname -U db_owner -d database_name

Expected Results

The database role is working if

• You are presented with the password prompt and the correct password is accepted.
• No incorrect password is accepted.
• You are presented with the postgresql command shell on successful login.