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

From Dogtag
Jump to: navigation, search
m (See Also)
m
Line 12: Line 12:
 
     }
 
     }
 
}
 
}
 +
</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>
 
</pre>
  

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