Top
Enterprise Postgres 17 Installation and Setup Guide for Server

B.1.2 Certificate Settings For Secure Connection Support

Describes how to support secure connections.

You must replace the certificate used for HTTPS and client authentication with a CA-signed certificate. To determine if it has been replaced, check the certificate in the "keystore" to ensure that it has been replaced with a CA-signed certificate.

Certificate Storage Directory

If you specify Use HTTPS or Use HTTPS Client Authentication during setup, a new subdirectory "keystore" for storing certificates is added to the WebAdmin Tomcat installation directory.

Example: If WebAdmin is installed in /opt/fsepv<x>webadmin:
Tomcat installation directory (/opt/fsepv<x>webadmin/tomcat/)
├── bin
├── Building.txt
├── conf
├── CONTRIBUTING.md
├── keystore
│   ├── keystore.p12             → For HTTPS
│   ├── clientbrowser.p12        → For client authentication
│   ├── clientkeystore.p12       → For client authentication
│   ├── truststore.p12           → For client authentication
│   ├── clientkeystore.conf      → For client authentication
├── …

Certificate Configuration

To configure a certificate:

1. Prepare CA-signed certificates

Certificate

Summary

keystore.p12
(private and public keys included)

One server certificate for HTTPS.
Used for data encryption.

clientbrowser.p12
(private key included)

One client certificate to authenticate the browser between the browser and the server.
It is registered in the user's browser.
The number of certificates generated corresponds to the number of clients (browsers) accessing WebAdmin.

clientkeystore.p12
(private key included)

One client certificate for server-to-server authentication. Used internally by WebAdmin.

truststore.p12
(clientbrowser.p12 and clientkeystore.p12)

Imported public keys for all client certificates.

2. Place certificates in keystore directory
Single-server configuration
  1. Place keystore.p12, truststore.p12 and clientkeystore.p12 files in "keystore" directory

  2. Import clientbrowser.p12 into your browser.
    If you use multiple clients (browsers), import the certificate into each browser.

Multi-server configuration
  1. Place keystore.p12, truststore.p12 and clientkeystore.p12 files in "keystore" directory

  2. Import clientbrowser.p12 into your browser.
    If you use multiple clients (browsers), import the certificate into each browser.

  3. Import the public key corresponding to the private key in clientkeystore.p12 into truststore.p12 on the other server you want to connect to.

3. Update certificate information in server.xml and clientkeystore.conf files
4. Back up

Back up the certificates and server.xml file.

Point

When you uninstall WebAdmin, all certificates in the keystore directory are deleted. Also, when you reinstall WebAdmin, the server.xml file is overwritten with the default settings. Back up your data in case of incorrect operation.

5. Restart WebAdmin

Stop WebAdmin and start it again.

Refer to "B.1.4 Stopping the Web Server Feature of WebAdmin" and "B.1.3 Starting the Web Server Feature of WebAdmin" for detailed instructions.

Point

If certificates or connection failures occur, refer to the Tomcat log directory (/opt/fsepv<x>webadmin/tomcat/logs/) for detailed error messages.