throw new IllegalStateException("already running");
}
running = true;
- readyCerts = DatabaseConnection.getInstance().prepare("SELECT emailcerts.id AS id, emailcerts.csr_name, emailcerts.subject, jobs.id AS jobid, csr_type, md, keyUsage, extendedKeyUsage FROM jobs " + //
- "INNER JOIN emailcerts ON emailcerts.id=jobs.targetId " + //
- "INNER JOIN profiles ON profiles.id=emailcerts.profile " + //
+ readyCerts = DatabaseConnection.getInstance().prepare("SELECT certs.id AS id, certs.csr_name, certs.subject, jobs.id AS jobid, csr_type, md, keyUsage, extendedKeyUsage FROM jobs " + //
+ "INNER JOIN certs ON certs.id=jobs.targetId " + //
+ "INNER JOIN profiles ON profiles.id=certs.profile " + //
"WHERE jobs.state='open' "//
+ "AND task='sign'");
getSANSs = DatabaseConnection.getInstance().prepare("SELECT contents, type FROM subjectAlternativeNames " + //
"WHERE certId=?");
- updateMail = DatabaseConnection.getInstance().prepare("UPDATE emailcerts SET crt_name=?," + " created=NOW(), serial=? WHERE id=?");
+ updateMail = DatabaseConnection.getInstance().prepare("UPDATE certs SET crt_name=?," + " created=NOW(), serial=? WHERE id=?");
warnMail = DatabaseConnection.getInstance().prepare("UPDATE jobs SET warning=warning+1, state=IF(warning<3, 'open','error') WHERE id=?");
- revoke = DatabaseConnection.getInstance().prepare("SELECT emailcerts.id, emailcerts.csr_name,jobs.id FROM jobs INNER JOIN emailcerts ON jobs.targetId=emailcerts.id" + " WHERE jobs.state='open' AND task='revoke'");
- revokeCompleted = DatabaseConnection.getInstance().prepare("UPDATE emailcerts SET revoked=NOW() WHERE id=?");
+ revoke = DatabaseConnection.getInstance().prepare("SELECT certs.id, certs.csr_name,jobs.id FROM jobs INNER JOIN certs ON jobs.targetId=certs.id" + " WHERE jobs.state='open' AND task='revoke'");
+ revokeCompleted = DatabaseConnection.getInstance().prepare("UPDATE certs SET revoked=NOW() WHERE id=?");
finishJob = DatabaseConnection.getInstance().prepare("UPDATE jobs SET state='done' WHERE id=?");
String[] call = new String[] {
"openssl", "ca",//
"-cert",
- "testca.crt",//
+ "../unassured.crt",//
"-keyfile",
- "testca.key",//
+ "../unassured.key",//
"-revoke",
- "../" + crt.getPath(),//
+ "../../" + crt.getPath(),//
"-batch",//
"-config",
- "selfsign.config"
+ "../selfsign.config"
};
- Process p1 = Runtime.getRuntime().exec(call, null, new File("keys"));
+ Process p1 = Runtime.getRuntime().exec(call, null, new File("keys/unassured.ca"));
System.out.println("revoking: " + crt.getPath());
if (p1.waitFor() == 0) {
worked = true;
String[] call = new String[] {
"openssl", "ca",//
"-cert",
- "testca.crt",//
+ "../unassured.crt",//
"-keyfile",
- "testca.key",//
+ "../unassured.key",//
"-gencrl",//
"-crlhours",//
"12",//
"-out",
- "testca.crl",//
+ "../unassured.crl",//
"-config",
- "selfsign.config"
+ "../selfsign.config"
};
- Process p1 = Runtime.getRuntime().exec(call, null, new File("keys"));
+ Process p1 = Runtime.getRuntime().exec(call, null, new File("keys/unassured.ca"));
if (p1.waitFor() != 0) {
System.out.println("Error while generating crl.");
}
String[] call = new String[] {
"openssl", "ca",//
"-in",
- "../" + csrname,//
+ "../../" + csrname,//
"-cert",
- "testca.crt",//
+ "../unassured.crt",//
"-keyfile",
- "testca.key",//
+ "../unassured.key",//
"-out",
- "../" + crt.getPath(),//
+ "../../" + crt.getPath(),//
+ "-utf8",
"-days",
"356",//
"-batch",//
"-md",
rs.getString("md"),//
"-extfile",
- f.getName(),//
+ "../" + f.getName(),//
"-subj",
rs.getString("subject"),//
"-config",
- "selfsign.config"//
+ "../selfsign.config"//
};
if (ct == CSRType.SPKAC) {
call[2] = "-spkac";
}
- Process p1 = Runtime.getRuntime().exec(call, null, new File("keys"));
+ Process p1 = Runtime.getRuntime().exec(call, null, new File("keys/unassured.ca"));
int waitFor = p1.waitFor();
f.delete();