Difference between revisions of "PKI ACME Responder with PostgreSQL Database"

From Dogtag
Jump to: navigation, search
(Created page with "= See Also = * PKI ACME Service * PostgreSQL")
 
m
(One intermediate revision by the same user not shown)
Line 1: Line 1:
 +
= Configuration =
 +
 +
The configuration will be stored in /etc/pki/pki-tomcat/acme/database.json, for example:
 +
 +
<pre>
 +
{
 +
    "class": "org.dogtagpki.acme.database.PostgreSQLDatabase",
 +
    "parameters": {
 +
        "url": "jdbc:postgresql://localhost:5432/acme",
 +
        "user": "acme",
 +
        "password": "Secret.123"
 +
    }
 +
}
 +
</pre>
 +
 +
= Nonces Table =
 +
 +
To create the nonces table:
 +
 +
<pre>
 +
psql=> create table nonces (
 +
    value          varchar(40) primary key,
 +
    expirationTime date not null
 +
);
 +
</pre>
 +
 +
To drop the nonces table:
 +
 +
<pre>
 +
psql=> drop table nonces;
 +
</pre>
 +
 
= See Also =
 
= See Also =
  
 
* [[PKI ACME Service]]
 
* [[PKI ACME Service]]
 
* [[PostgreSQL]]
 
* [[PostgreSQL]]

Revision as of 19:47, 7 November 2019

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