src/org/cacert/gigi/pages/main/Signup.java

   1 package org.cacert.gigi.pages.main;
   2
   3 import java.io.IOException;
   4 import java.io.PrintWriter;
   5 import java.sql.PreparedStatement;
   6 import java.sql.ResultSet;
   7 import java.sql.SQLException;
   8 import java.sql.Date;
   9 import java.util.HashMap;
  10 import java.util.Map;
  11
  12 import javax.servlet.http.HttpServletRequest;
  13
  14 import org.cacert.gigi.EmailAddress;
  15 import org.cacert.gigi.Language;
  16 import org.cacert.gigi.User;
  17 import org.cacert.gigi.database.DatabaseConnection;
  18 import org.cacert.gigi.email.EmailProvider;
  19 import org.cacert.gigi.output.DateSelector;
  20 import org.cacert.gigi.output.Form;
  21 import org.cacert.gigi.output.template.Template;
  22 import org.cacert.gigi.pages.Page;
  23 import org.cacert.gigi.util.HTMLEncoder;
  24 import org.cacert.gigi.util.Notary;
  25 import org.cacert.gigi.util.PasswordStrengthChecker;
  26
  27 public class Signup extends Form {
  28
  29     User buildup = new User();
  30
  31     Template t;
  32
  33     boolean general = true, country = true, regional = true, radius = true;
  34
  35     public Signup(HttpServletRequest hsr) {
  36         super(hsr);
  37         t = new Template(Signup.class.getResource("Signup.templ"));
  38         buildup.setFname("");
  39         buildup.setMname("");
  40         buildup.setLname("");
  41         buildup.setSuffix("");
  42         buildup.setEmail("");
  43         buildup.setDob(new Date(0));
  44     }
  45
  46     DateSelector myDoB = new DateSelector("day", "month", "year");
  47
  48     @Override
  49     public void outputContent(PrintWriter out, Language l, Map<String, Object> outerVars) {
  50         HashMap<String, Object> vars = new HashMap<String, Object>();
  51         vars.put("fname", HTMLEncoder.encodeHTML(buildup.getFname()));
  52         vars.put("mname", HTMLEncoder.encodeHTML(buildup.getMname()));
  53         vars.put("lname", HTMLEncoder.encodeHTML(buildup.getLname()));
  54         vars.put("suffix", HTMLEncoder.encodeHTML(buildup.getSuffix()));
  55         vars.put("dob", myDoB);
  56         vars.put("email", HTMLEncoder.encodeHTML(buildup.getEmail()));
  57         vars.put("general", general ? " checked=\"checked\"" : "");
  58         vars.put("country", country ? " checked=\"checked\"" : "");
  59         vars.put("regional", regional ? " checked=\"checked\"" : "");
  60         vars.put("radius", radius ? " checked=\"checked\"" : "");
  61         vars.put("helpOnNames", String.format(l.getTranslation("Help on Names %sin the wiki%s"), "<a href=\"//wiki.cacert.org/FAQ/HowToEnterNamesInJoinForm\" target=\"_blank\">", "</a>"));
  62         vars.put("csrf", getCSRFToken());
  63         t.output(out, l, vars);
  64     }
  65
  66     private void update(HttpServletRequest r) {
  67         if (r.getParameter("fname") != null) {
  68             buildup.setFname(r.getParameter("fname"));
  69         }
  70         if (r.getParameter("lname") != null) {
  71             buildup.setLname(r.getParameter("lname"));
  72         }
  73         if (r.getParameter("mname") != null) {
  74             buildup.setMname(r.getParameter("mname"));
  75         }
  76         if (r.getParameter("suffix") != null) {
  77             buildup.setSuffix(r.getParameter("suffix"));
  78         }
  79         if (r.getParameter("email") != null) {
  80             buildup.setEmail(r.getParameter("email"));
  81         }
  82         general = "1".equals(r.getParameter("general"));
  83         country = "1".equals(r.getParameter("country"));
  84         regional = "1".equals(r.getParameter("regional"));
  85         radius = "1".equals(r.getParameter("radius"));
  86         myDoB.update(r);
  87     }
  88
  89     @Override
  90     public synchronized boolean submit(PrintWriter out, HttpServletRequest req) {
  91         update(req);
  92         boolean failed = false;
  93         out.println("<div class='formError'>");
  94         if (buildup.getFname().equals("") || buildup.getLname().equals("")) {
  95             outputError(out, req, "First and/or last names were blank.");
  96             failed = true;
  97         }
  98         if ( !myDoB.isValid()) {
  99             outputError(out, req, "Invalid date of birth");
 100             failed = true;
 101         }
 102         if ( !"1".equals(req.getParameter("cca_agree"))) {
 103             outputError(out, req, "You have to agree to the CAcert Community agreement.");
 104             failed = true;
 105         }
 106         if (buildup.getEmail().equals("")) {
 107             outputError(out, req, "Email Address was blank");
 108             failed = true;
 109         }
 110         String pw1 = req.getParameter("pword1");
 111         String pw2 = req.getParameter("pword2");
 112         if (pw1 == null || pw1.equals("")) {
 113             outputError(out, req, "Pass Phrases were blank");
 114             failed = true;
 115         } else if ( !pw1.equals(pw2)) {
 116             outputError(out, req, "Pass Phrases don't match");
 117             failed = true;
 118         }
 119         int pwpoints = PasswordStrengthChecker.checkpw(pw1, buildup);
 120         if (pwpoints < 3) {
 121             outputError(out, req, "The Pass Phrase you submitted failed to contain enough" + " differing characters and/or contained words from" + " your name and/or email address.");
 122             failed = true;
 123         }
 124         if (failed) {
 125             out.println("</div>");
 126             return false;
 127         }
 128         try {
 129             PreparedStatement q1 = DatabaseConnection.getInstance().prepare("select * from `emails` where `email`=? and `deleted`=0");
 130             PreparedStatement q2 = DatabaseConnection.getInstance().prepare("select * from `users` where `email`=? and `deleted`=0");
 131             q1.setString(1, buildup.getEmail());
 132             q2.setString(1, buildup.getEmail());
 133             ResultSet r1 = q1.executeQuery();
 134             ResultSet r2 = q2.executeQuery();
 135             if (r1.next() || r2.next()) {
 136                 outputError(out, req, "This email address is currently valid in the system.");
 137                 failed = true;
 138             }
 139             r1.close();
 140             r2.close();
 141             PreparedStatement q3 = DatabaseConnection.getInstance().prepare("select `domain` from `baddomains` where `domain`=RIGHT(?, LENGTH(`domain`))");
 142             q3.setString(1, buildup.getEmail());
 143
 144             ResultSet r3 = q3.executeQuery();
 145             if (r3.next()) {
 146                 String domain = r3.getString(1);
 147                 out.print("<div>");
 148                 out.print(String.format(Page.translate(req, "We don't allow signups from people using email addresses from %s"), domain));
 149                 out.println("</div>");
 150                 failed = true;
 151             }
 152             r3.close();
 153         } catch (SQLException e) {
 154             e.printStackTrace();
 155             failed = true;
 156         }
 157         String mailResult = EmailProvider.FAIL;
 158         try {
 159             mailResult = EmailProvider.getInstance().checkEmailServer(0, buildup.getEmail());
 160         } catch (IOException e) {
 161         }
 162         if ( !mailResult.equals(EmailProvider.OK)) {
 163             if (mailResult.startsWith("4")) {
 164                 outputError(out, req, "The mail server responsible for your domain indicated" + " a temporary failure. This may be due to anti-SPAM measures, such" + " as greylisting. Please try again in a few minutes.");
 165             } else {
 166                 outputError(out, req, "Email Address given was invalid, or a test connection" + " couldn't be made to your server, or the server" + " rejected the email address as invalid");
 167             }
 168             if (mailResult.equals(EmailProvider.FAIL)) {
 169                 outputError(out, req, "Failed to make a connection to the mail server");
 170             } else {
 171                 out.print("<div>");
 172                 out.print(mailResult);
 173                 out.println("</div>");
 174             }
 175             failed = true;
 176         }
 177
 178         out.println("</div>");
 179         if (failed) {
 180             return false;
 181         }
 182         try {
 183             run(req, pw1);
 184         } catch (SQLException e) {
 185             e.printStackTrace();
 186         }
 187         return true;
 188     }
 189
 190     private void run(HttpServletRequest req, String password) throws SQLException {
 191         try {
 192             DatabaseConnection.getInstance().beginTransaction();
 193
 194             buildup.setDob(myDoB.getDate());
 195             buildup.insert(password);
 196             int memid = buildup.getId();
 197             EmailAddress ea = new EmailAddress(buildup.getEmail(), buildup);
 198             ea.insert(Page.getLanguage(req));
 199
 200             PreparedStatement ps = DatabaseConnection.getInstance().prepare("insert into `alerts` set `memid`=?," + " `general`=?, `country`=?, `regional`=?, `radius`=?");
 201             ps.setInt(1, memid);
 202             ps.setString(2, general ? "1" : "0");
 203             ps.setString(3, country ? "1" : "0");
 204             ps.setString(4, regional ? "1" : "0");
 205             ps.setString(5, radius ? "1" : "0");
 206             ps.execute();
 207             Notary.writeUserAgreement(memid, "CCA", "account creation", "", true, 0);
 208
 209             DatabaseConnection.getInstance().commitTransaction();
 210         } finally {
 211             DatabaseConnection.getInstance().quitTransaction();
 212         }
 213
 214     }
 215 }