_Black Duck Reporting Database

This page has been deprecated. Please see the official Kubernetes Black Duck Installation Guide here.

Black Duck ships with a reporting database. The database port will be exposed to the Kubernetes network for connections to the reporting user and reporting database.

Details:

• Exposed Port: 55436
• Reporting User Name: blackduck_reporter
• Reporting Database: bds_hub_report
• Reporting User Password: initially unset

Before connecting to the reporting database you'll need to set the password for the reporting user. There is a script included in './bin' of the docker-compose directory called 'hub_reportdb_changepassword.sh'.

To run this script, you must:

• Be on the Kubernetes node that is running the PostgreSQL database container
• Be able to run 'docker' commands. This might require being 'root' or in the 'docker' group depending on your docker setup.

To run the change password command:

./bin/hub_reportdb_changepassword.sh blackduck

Where 'blackduck' is the new password. This script can also be used to change the password for the reporting user after it has been set.

Once the password is set you should now be able to connect to the reporting database. An example of this with 'psql' is:

kubectl get service postgres -o wide

The above command will give you all the information about the internal and external IP for your postgres service.

Then you can take the external IP (if your Postgres client is outside the cluster)

and run a command such as:

psql -U blackduck_reporter -p 55436 -h $external_ip_from_above -W bds_hub_report