From: Felix Dörre <felix@dogcraft.de>
Date: Fri, 4 Jul 2014 23:10:33 +0000 (+0200)
Subject: Add a primitive signer code.
X-Git-Url: https://code.wpia.club/?p=gigi.git;a=commitdiff_plain;h=35bcc89d642174960596b13d523793f5bc637b94

Add a primitive signer code.
---

diff --git a/util/org/cacert/gigi/util/SimpleSigner.java b/util/org/cacert/gigi/util/SimpleSigner.java
new file mode 100644
index 00000000..812705c9
--- /dev/null
+++ b/util/org/cacert/gigi/util/SimpleSigner.java
@@ -0,0 +1,78 @@
+package org.cacert.gigi.util;
+
+import java.io.File;
+import java.io.FileReader;
+import java.io.IOException;
+import java.sql.PreparedStatement;
+import java.sql.ResultSet;
+import java.sql.SQLException;
+import java.util.Properties;
+
+import org.cacert.gigi.database.DatabaseConnection;
+
+public class SimpleSigner {
+	private static PreparedStatement warnMail;
+	private static PreparedStatement updateMail;
+	private static PreparedStatement readyMail;
+
+	public static void main(String[] args) throws IOException, SQLException,
+			InterruptedException {
+		Properties p = new Properties();
+		p.load(new FileReader("config/gigi.properties"));
+		DatabaseConnection.init(p);
+
+		readyMail = DatabaseConnection.getInstance().prepare(
+				"SELECT id, csr_name FROM emailcerts" + " WHERE csr_name!=null"//
+						+ " AND created=0"//
+						+ " AND crt_name=''"//
+						+ " AND warning<3");
+
+		updateMail = DatabaseConnection.getInstance().prepare(
+				"UPDATE emailcerts SET crt_name=?,"
+						+ " created=NOW() WHERE id=?");
+		warnMail = DatabaseConnection.getInstance().prepare(
+				"UPDATE emailcerts SET warning=warning+1 WHERE id=?");
+		while (true) {
+			System.out.println("ping");
+			executeOutstanders();
+			Thread.sleep(5000);
+		}
+	}
+
+	private static void executeOutstanders() throws SQLException, IOException,
+			InterruptedException {
+		ResultSet rs = readyMail.executeQuery();
+		while (rs.next()) {
+			String csrname = rs.getString(2);
+			System.out.println("sign: " + csrname);
+			int id = rs.getInt(1);
+			File crt = KeyStorage.locateCrt(id);
+			String[] call = new String[]{"openssl", "ca",//
+					"-cert", "testca.crt",//
+					"-keyfile", "testca.key",//
+					"-in", "../" + csrname,//
+					"-out", "../" + crt.getPath(),//
+					"-days", "356",//
+					"-batch",//
+					"-config", "selfsign.config"
+
+			};
+			Process p1 = Runtime.getRuntime()
+					.exec(call, null, new File("keys"));
+
+			int waitFor = p1.waitFor();
+			if (waitFor == 0) {
+				updateMail.setString(1, crt.getPath());
+				updateMail.setInt(2, id);
+				updateMail.execute();
+				System.out.println("sign: " + id);
+			} else {
+				System.out.println("ERROR: " + id);
+				warnMail.setInt(1, id);
+				warnMail.execute();
+			}
+
+		}
+		rs.close();
+	}
+}