PKI ACME Responder with PostgreSQL Database

From Dogtag
Revision as of 19:47, 7 November 2019 by Edewata (talk | contribs)

Jump to: navigation, search

Configuration

The configuration will be stored in /etc/pki/pki-tomcat/acme/database.json, for example:

{
    "class": "org.dogtagpki.acme.database.PostgreSQLDatabase",
    "parameters": {
        "url": "jdbc:postgresql://localhost:5432/acme",
        "user": "acme",
        "password": "Secret.123"
    }
}

Nonces Table

To create the nonces table:

psql=> create table nonces (
    value          varchar(40) primary key,
    expirationTime date not null
);

To drop the nonces table:

psql=> drop table nonces;

See Also