1 package org.cacert.gigi.pages.account;
3 import java.io.IOException;
4 import java.io.PrintWriter;
5 import java.security.GeneralSecurityException;
6 import java.security.cert.X509Certificate;
7 import java.sql.PreparedStatement;
8 import java.sql.ResultSet;
9 import java.sql.SQLException;
10 import java.util.HashMap;
12 import javax.servlet.ServletOutputStream;
13 import javax.servlet.http.HttpServletRequest;
14 import javax.servlet.http.HttpServletResponse;
16 import org.cacert.gigi.Certificate;
17 import org.cacert.gigi.User;
18 import org.cacert.gigi.database.DatabaseConnection;
19 import org.cacert.gigi.output.CertificateTable;
20 import org.cacert.gigi.pages.LoginPage;
21 import org.cacert.gigi.pages.Page;
22 import org.cacert.gigi.util.PEM;
24 public class MailCertificates extends Page {
26 CertificateTable myTable = new CertificateTable("mailcerts");
28 public static final String PATH = "/account/certs/email";
30 public MailCertificates() {
31 super("Email Certificates");
35 public boolean beforeTemplate(HttpServletRequest req, HttpServletResponse resp) throws IOException {
37 String pi = req.getPathInfo().substring(PATH.length());
38 if (pi.length() == 0) {
44 resp.setContentType("application/pkix-cert");
45 if (pi.endsWith(".crt")) {
47 pi = pi.substring(0, pi.length() - 4);
48 } else if (pi.endsWith(".cer")) {
49 if (req.getParameter("install") != null) {
50 resp.setContentType("application/x-x509-user-cert");
53 pi = pi.substring(0, pi.length() - 4);
54 } else if (pi.endsWith(".cer")) {
56 pi = pi.substring(0, pi.length() - 4);
60 Certificate c = Certificate.getBySerial(serial);
61 if (c == null || getUser(req).getId() != c.getOwnerId()) {
65 X509Certificate cert = c.cert();
69 ServletOutputStream out = resp.getOutputStream();
71 out.println(PEM.encode("CERTIFICATE", cert.getEncoded()));
73 out.write(cert.getEncoded());
75 } catch (IllegalArgumentException e) {
78 } catch (GeneralSecurityException e) {
81 } catch (SQLException e) {
90 public void doGet(HttpServletRequest req, HttpServletResponse resp) throws IOException {
91 PrintWriter out = resp.getWriter();
92 String pi = req.getPathInfo().substring(PATH.length());
93 if (pi.length() != 0) {
97 Certificate c = Certificate.getBySerial(serial);
98 if (c == null || LoginPage.getUser(req).getId() != c.getOwnerId()) {
102 out.print("<a href='");
105 out.print(translate(req, "PEM encoded Certificate"));
106 out.println("</a><br/>");
108 out.print("<a href='");
111 out.print(translate(req, "DER encoded Certificate"));
112 out.println("</a><br/>");
113 out.print("<a href='");
115 out.print(".cer?install'>");
116 out.print(translate(req, "Install into browser."));
117 out.println("</a><br/>");
119 out.println("<pre>");
121 X509Certificate cert = c.cert();
123 } catch (GeneralSecurityException e) {
125 } catch (SQLException e) {
128 out.println("</pre>");
132 HashMap<String, Object> vars = new HashMap<String, Object>();
133 User us = LoginPage.getUser(req);
135 PreparedStatement ps = DatabaseConnection.getInstance().prepare("SELECT `id`, `CN`, `serial`, `revoked`, `expire`, `disablelogin` FROM `emailcerts` WHERE `memid`=?");
136 ps.setInt(1, us.getId());
137 ResultSet rs = ps.executeQuery();
138 vars.put("mailcerts", rs);
139 myTable.output(out, getLanguage(req), vars);
141 } catch (SQLException e) {