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

From Dogtag
Jump to: navigation, search
m
m
Line 19: Line 19:
  
 
<pre>
 
<pre>
psql=> create table nonces (
+
psql> create table nonces (
 
     value          varchar(40) primary key,
 
     value          varchar(40) primary key,
 
     expirationTime date not null
 
     expirationTime date not null
Line 28: Line 28:
  
 
<pre>
 
<pre>
psql=> drop table nonces;
+
psql> drop table nonces;
 
</pre>
 
</pre>
  

Revision as of 19:48, 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