]> WPIA git - gigi.git/blob - src/org/cacert/gigi/pages/LoginPage.java
Rename certs table.
[gigi.git] / src / org / cacert / gigi / pages / LoginPage.java
1 package org.cacert.gigi.pages;
2
3 import static org.cacert.gigi.Gigi.LOGGEDIN;
4 import static org.cacert.gigi.Gigi.USER;
5
6 import java.io.IOException;
7 import java.security.cert.X509Certificate;
8 import java.sql.PreparedStatement;
9 import java.sql.ResultSet;
10 import java.sql.SQLException;
11
12 import javax.servlet.http.HttpServletRequest;
13 import javax.servlet.http.HttpServletResponse;
14 import javax.servlet.http.HttpSession;
15
16 import org.cacert.gigi.User;
17 import org.cacert.gigi.database.DatabaseConnection;
18 import org.cacert.gigi.util.PasswordHash;
19
20 public class LoginPage extends Page {
21
22     public static final String LOGIN_RETURNPATH = "login-returnpath";
23
24     public LoginPage(String title) {
25         super(title);
26     }
27
28     @Override
29     public void doGet(HttpServletRequest req, HttpServletResponse resp) throws IOException {
30         resp.getWriter().println("<form method='POST' action='/login'>" + "<input type='text' name='username'>" + "<input type='password' name='password'> <input type='submit' value='login'></form>");
31     }
32
33     @Override
34     public boolean beforeTemplate(HttpServletRequest req, HttpServletResponse resp) throws IOException {
35         String redir = (String) req.getSession().getAttribute(LOGIN_RETURNPATH);
36         if (req.getSession().getAttribute("loggedin") == null) {
37             X509Certificate[] cert = (X509Certificate[]) req.getAttribute("javax.servlet.request.X509Certificate");
38             if (cert != null && cert[0] != null) {
39                 tryAuthWithCertificate(req, cert[0]);
40             }
41             if (req.getMethod().equals("POST")) {
42                 tryAuthWithUnpw(req);
43             }
44         }
45
46         if (req.getSession().getAttribute("loggedin") != null) {
47             String s = redir;
48             if (s != null) {
49                 if ( !s.startsWith("/")) {
50                     s = "/" + s;
51                 }
52                 resp.sendRedirect(s);
53             } else {
54                 resp.sendRedirect("/");
55             }
56             return true;
57         }
58         return false;
59     }
60
61     @Override
62     public boolean needsLogin() {
63         return false;
64     }
65
66     private void tryAuthWithUnpw(HttpServletRequest req) {
67         String un = req.getParameter("username");
68         String pw = req.getParameter("password");
69         try {
70             PreparedStatement ps = DatabaseConnection.getInstance().prepare("SELECT `password`, `id` FROM `users` WHERE `email`=? AND locked='0' AND verified='1'");
71             ps.setString(1, un);
72             ResultSet rs = ps.executeQuery();
73             if (rs.next()) {
74                 if (PasswordHash.verifyHash(pw, rs.getString(1))) {
75                     req.getSession().invalidate();
76                     HttpSession hs = req.getSession();
77                     hs.setAttribute(LOGGEDIN, true);
78                     hs.setAttribute(USER, new User(rs.getInt(2)));
79                 }
80             }
81             rs.close();
82         } catch (SQLException e) {
83             e.printStackTrace();
84         }
85     }
86
87     public static User getUser(HttpServletRequest req) {
88         return (User) req.getSession().getAttribute(USER);
89     }
90
91     private void tryAuthWithCertificate(HttpServletRequest req, X509Certificate x509Certificate) {
92         String serial = x509Certificate.getSerialNumber().toString(16).toUpperCase();
93         try {
94             PreparedStatement ps = DatabaseConnection.getInstance().prepare("SELECT `memid` FROM `certs` WHERE `serial`=? AND `disablelogin`='0' AND `revoked` = " + "'0000-00-00 00:00:00'");
95             ps.setString(1, serial);
96             ResultSet rs = ps.executeQuery();
97             if (rs.next()) {
98                 req.getSession().invalidate();
99                 HttpSession hs = req.getSession();
100                 hs.setAttribute(LOGGEDIN, true);
101                 hs.setAttribute(USER, new User(rs.getInt(1)));
102             }
103             rs.close();
104         } catch (SQLException e) {
105             e.printStackTrace();
106         }
107     }
108 }