Dell Security Management Server Virtual Fails to Upgrade with an Error Specifying an Unauthenticated Postgresql Package

Affected Products:

• Dell Security Management Server Virtual

Affected Versions:

• v10.1.0 and Later

When performing an upgrade to the Dell Security Management Server Virtual, a warning or an error may appear indicating that the postgresql-contrib-9.5, postgresql-client-9.5 and, postgresql-9.5 packages could not be properly authenticated.

Figure 1: (English Only) This warning and error are shown in the updated user interface

This failure is happening because the key used to sign the packages for postgresql has been updated and is not in the default repository for Ubuntu. The key that is used for authentication must be manually updated on the Dell Security Management Server Virtual, to resolve the error. To update the key, perform the following steps.

1. Log in to the console with the delluser account (Default password: delluser).

Figure 2: (English Only) Log in to the console

2. Go to the option Launch Shell.

Figure 3: (English Only) Select Launch Shell

3. Switch user to dellsupport with the command su dellsupport (Default Password: dellsupport).

Figure 4: (English Only) Switch user

4. Run the command sudo apt-get update && sudo apt-key update.

Figure 5: (English Only) Run the command sudo apt-get update && sudo apt-key updat

Figure 6: (English Only) Example of output from command on screen

5. Run the command: sudo apt-get install curl ca-certificates gnupg and accept the prompt asking if it is OK to us additional disk space.

Figure 7: (English Only) Run  sudo apt-get install curl ca-certificates gnupg

6. Run the command: curl https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -.

Figure 8: (English Only) Run curl https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -

7. Exit the dellsupport user context by typing exit.
8. Return to the console by typing exit again.
9. Rerun the update by going to Basic Configuration, then to Update Dell Security Management Server Virtual….

Figure 9: (English Only) Rerun the update

Appendix A

If updating the key for PostgreSQL fails, a method can be invoked to download the keys directly from the Ubuntu keyservers, though this method bypasses the validation of the key.

Within the shell, and logged in as dellsupport run the command below. This command is case insensitive.

sudo apt-key adv --keyserver keyserver.ubuntu.com --recv-keys 7FCC7D46ACCC4CF8

Figure 10: (English Only) Run sudo apt-key adv --keyserver keyserver.ubuntu.com --recv-keys 7FCC7D46ACCC4CF8

This should result in the key being updated within the local keystore and allow updates involving PostgreSQL to proceed. The example below is an example of the PostgreSQL key already being imported. On successful import, multiple keys are imported.

Figure 11: (English Only) Example of the PostgreSQL key already being imported

To contact support, reference Dell Data Security International Support Phone Numbers.
Go to TechDirect to generate a technical support request online.
For additional insights and resources, join the Dell Security Community Forum.