]> WPIA git - gigi.git/blob - tests/org/cacert/gigi/testUtils/ManagedTest.java
fix: SQL change database call pattern
[gigi.git] / tests / org / cacert / gigi / testUtils / ManagedTest.java
1 package org.cacert.gigi.testUtils;
2
3 import static org.junit.Assert.*;
4
5 import java.io.BufferedReader;
6 import java.io.DataOutputStream;
7 import java.io.IOException;
8 import java.io.InputStreamReader;
9 import java.io.OutputStream;
10 import java.io.UnsupportedEncodingException;
11 import java.net.HttpURLConnection;
12 import java.net.InetSocketAddress;
13 import java.net.MalformedURLException;
14 import java.net.Socket;
15 import java.net.URL;
16 import java.net.URLConnection;
17 import java.net.URLEncoder;
18 import java.nio.file.Files;
19 import java.nio.file.Paths;
20 import java.security.KeyManagementException;
21 import java.security.NoSuchAlgorithmException;
22 import java.security.Principal;
23 import java.security.PrivateKey;
24 import java.security.cert.X509Certificate;
25 import java.sql.SQLException;
26 import java.util.Locale;
27 import java.util.Properties;
28 import java.util.regex.Matcher;
29 import java.util.regex.Pattern;
30
31 import javax.net.ssl.HttpsURLConnection;
32 import javax.net.ssl.KeyManager;
33 import javax.net.ssl.SSLContext;
34 import javax.net.ssl.X509KeyManager;
35
36 import org.cacert.gigi.DevelLauncher;
37 import org.cacert.gigi.GigiApiException;
38 import org.cacert.gigi.database.GigiPreparedStatement;
39 import org.cacert.gigi.database.GigiResultSet;
40 import org.cacert.gigi.database.SQLFileManager.ImportType;
41 import org.cacert.gigi.dbObjects.Domain;
42 import org.cacert.gigi.dbObjects.DomainPingType;
43 import org.cacert.gigi.dbObjects.EmailAddress;
44 import org.cacert.gigi.dbObjects.Group;
45 import org.cacert.gigi.dbObjects.ObjectCache;
46 import org.cacert.gigi.dbObjects.User;
47 import org.cacert.gigi.pages.Manager;
48 import org.cacert.gigi.pages.account.MyDetails;
49 import org.cacert.gigi.pages.main.RegisterPage;
50 import org.cacert.gigi.testUtils.TestEmailReceiver.TestMail;
51 import org.cacert.gigi.util.DatabaseManager;
52 import org.cacert.gigi.util.ServerConstants;
53 import org.cacert.gigi.util.SimpleSigner;
54 import org.junit.After;
55 import org.junit.AfterClass;
56 import org.junit.BeforeClass;
57
58 /**
59  * Base class for test suites who require a launched Gigi instance. The instance
60  * is cleared once per test suite.
61  */
62 public class ManagedTest extends ConfiguredTest {
63
64     static {
65         System.setProperty("sun.net.http.allowRestrictedHeaders", "true");
66     }
67
68     /**
69      * Some password that fulfills the password criteria.
70      */
71     public static final String TEST_PASSWORD = "xvXV12°§";
72
73     private static TestEmailReceiver ter;
74
75     private static Process gigi;
76
77     private static String url = "localhost:4443";
78
79     private static String acceptLanguage = null;
80
81     public static void setAcceptLanguage(String acceptLanguage) {
82         ManagedTest.acceptLanguage = acceptLanguage;
83     }
84
85     public static String getServerName() {
86         return url;
87     }
88
89     static {
90         InitTruststore.run();
91         HttpURLConnection.setFollowRedirects(false);
92     }
93
94     @BeforeClass
95     public static void initEnvironment() {
96         try {
97             ConfiguredTest.initEnvironment();
98
99             purgeDatabase();
100             String type = testProps.getProperty("type");
101             Properties mainProps = generateMainProps();
102             ServerConstants.init(mainProps);
103             if (type.equals("local")) {
104                 url = testProps.getProperty("name.www") + ":" + testProps.getProperty("serverPort.https");
105                 String[] parts = testProps.getProperty("mail").split(":", 2);
106                 ter = new TestEmailReceiver(new InetSocketAddress(parts[0], Integer.parseInt(parts[1])));
107                 ter.start();
108                 return;
109             }
110             url = testProps.getProperty("name.www") + ":" + testProps.getProperty("serverPort.https");
111             gigi = Runtime.getRuntime().exec(testProps.getProperty("java"));
112             DataOutputStream toGigi = new DataOutputStream(gigi.getOutputStream());
113             System.out.println("... starting server");
114
115             byte[] cacerts = Files.readAllBytes(Paths.get("config/cacerts.jks"));
116             byte[] keystore = Files.readAllBytes(Paths.get("config/keystore.pkcs12"));
117
118             DevelLauncher.writeGigiConfig(toGigi, "changeit".getBytes("UTF-8"), "changeit".getBytes("UTF-8"), mainProps, cacerts, keystore);
119             toGigi.flush();
120
121             final BufferedReader br = new BufferedReader(new InputStreamReader(gigi.getErrorStream(), "UTF-8"));
122             String line;
123             while ((line = br.readLine()) != null && !line.contains("System successfully started.")) {
124                 System.err.println(line);
125             }
126             new Thread() {
127
128                 @Override
129                 public void run() {
130                     String line;
131                     try {
132                         while ((line = br.readLine()) != null) {
133                             System.err.println(line);
134                         }
135                     } catch (IOException e) {
136                         e.printStackTrace();
137                     }
138                 }
139             }.start();
140             if (line == null) {
141                 throw new Error("Server startup failed");
142             }
143             ter = new TestEmailReceiver(new InetSocketAddress("localhost", 8473));
144             ter.start();
145             SimpleSigner.runSigner();
146         } catch (IOException e) {
147             throw new Error(e);
148         } catch (SQLException e1) {
149             e1.printStackTrace();
150         } catch (InterruptedException e) {
151             e.printStackTrace();
152         }
153
154     }
155
156     public static void purgeDatabase() throws SQLException, IOException {
157         System.out.print("... resetting Database");
158         long ms = System.currentTimeMillis();
159         try {
160             DatabaseManager.run(new String[] {
161                     testProps.getProperty("sql.driver"), testProps.getProperty("sql.url"), testProps.getProperty("sql.user"), testProps.getProperty("sql.password")
162             }, ImportType.TRUNCATE);
163         } catch (ClassNotFoundException e) {
164             e.printStackTrace();
165         }
166         System.out.println(" in " + (System.currentTimeMillis() - ms) + " ms");
167         clearCaches();
168     }
169
170     public static void clearCaches() throws IOException {
171         ObjectCache.clearAllCaches();
172         // String type = testProps.getProperty("type");
173         URL u = new URL("https://" + getServerName() + "/manage");
174         u.openConnection().getHeaderField("Location");
175     }
176
177     private static Properties generateMainProps() {
178         Properties mainProps = new Properties();
179         mainProps.setProperty("testrunner", "true");
180         mainProps.setProperty("host", "127.0.0.1");
181         mainProps.setProperty("name.secure", testProps.getProperty("name.secure"));
182         mainProps.setProperty("name.www", testProps.getProperty("name.www"));
183         mainProps.setProperty("name.static", testProps.getProperty("name.static"));
184         mainProps.setProperty("name.api", testProps.getProperty("name.api"));
185
186         mainProps.setProperty("https.port", testProps.getProperty("serverPort.https"));
187         mainProps.setProperty("http.port", testProps.getProperty("serverPort.http"));
188         mainProps.setProperty("emailProvider", "org.cacert.gigi.email.TestEmailProvider");
189         mainProps.setProperty("emailProvider.port", "8473");
190         mainProps.setProperty("sql.driver", testProps.getProperty("sql.driver"));
191         mainProps.setProperty("sql.url", testProps.getProperty("sql.url"));
192         mainProps.setProperty("sql.user", testProps.getProperty("sql.user"));
193         mainProps.setProperty("sql.password", testProps.getProperty("sql.password"));
194         mainProps.setProperty("testing", "true");
195         return mainProps;
196     }
197
198     @AfterClass
199     public static void tearDownServer() {
200         String type = testProps.getProperty("type");
201         ter.destroy();
202         if (type.equals("local")) {
203             return;
204         }
205         gigi.destroy();
206         try {
207             SimpleSigner.stopSigner();
208         } catch (InterruptedException e) {
209             e.printStackTrace();
210         }
211     }
212
213     public final String uniq = createUniqueName();
214
215     @After
216     public void removeMails() {
217         ter.reset();
218     }
219
220     @After
221     public void clearAcceptLanguage() {
222         ManagedTest.setAcceptLanguage(null);
223     }
224
225     public static TestEmailReceiver getMailReciever() {
226         return ter;
227     }
228
229     public static String runRegister(String param) throws IOException {
230         URL regist = new URL("https://" + getServerName() + RegisterPage.PATH);
231         HttpURLConnection uc = (HttpURLConnection) regist.openConnection();
232         HttpURLConnection csrfConn = (HttpURLConnection) regist.openConnection();
233         if (acceptLanguage != null) {
234             csrfConn.setRequestProperty("Accept-Language", acceptLanguage);
235             uc.setRequestProperty("Accept-Language", acceptLanguage);
236         }
237
238         String headerField = csrfConn.getHeaderField("Set-Cookie");
239         headerField = stripCookie(headerField);
240
241         String csrf = getCSRF(csrfConn);
242         uc.addRequestProperty("Cookie", headerField);
243         uc.setDoOutput(true);
244         uc.getOutputStream().write((param + "&csrf=" + csrf).getBytes("UTF-8"));
245         String d = IOUtils.readURL(uc);
246         return d;
247     }
248
249     public static String fetchStartErrorMessage(String d) throws IOException {
250         String formFail = "<div class='formError'>";
251         int idx = d.indexOf(formFail);
252         if (idx == -1) {
253             return null;
254         }
255         String startError = d.substring(idx + formFail.length(), idx + 100).trim();
256         return startError;
257     }
258
259     public static void registerUser(String firstName, String lastName, String email, String password) {
260         try {
261             String query = "fname=" + URLEncoder.encode(firstName, "UTF-8") + "&lname=" + URLEncoder.encode(lastName, "UTF-8") + "&email=" + URLEncoder.encode(email, "UTF-8") + "&pword1=" + URLEncoder.encode(password, "UTF-8") + "&pword2=" + URLEncoder.encode(password, "UTF-8") + "&day=1&month=1&year=1910&cca_agree=1";
262             String data = fetchStartErrorMessage(runRegister(query));
263             assertNull(data);
264         } catch (UnsupportedEncodingException e) {
265             throw new Error(e);
266         } catch (IOException e) {
267             throw new Error(e);
268         }
269     }
270
271     public static int createVerifiedUser(String firstName, String lastName, String email, String password) {
272         registerUser(firstName, lastName, email, password);
273         try {
274             ter.receive().verify();
275
276             try (GigiPreparedStatement ps = new GigiPreparedStatement("SELECT `id` FROM `users` WHERE `email`=?")) {
277                 ps.setString(1, email);
278
279                 GigiResultSet rs = ps.executeQuery();
280                 if (rs.next()) {
281                     return rs.getInt(1);
282                 }
283             }
284
285             throw new Error();
286         } catch (IOException e) {
287             throw new Error(e);
288         }
289     }
290
291     public static void grant(String email, Group g) throws IOException {
292         HttpURLConnection huc = (HttpURLConnection) new URL("https://" + getServerName() + Manager.PATH).openConnection();
293         huc.setDoOutput(true);
294         huc.getOutputStream().write(("addpriv=y&priv=" + URLEncoder.encode(g.getDatabaseName(), "UTF-8") + "&email=" + URLEncoder.encode(email, "UTF-8")).getBytes("UTF-8"));
295         assertEquals(200, huc.getResponseCode());
296     }
297
298     /**
299      * Creates a new user with 100 Assurance points given by an (invalid)
300      * assurance.
301      * 
302      * @param firstName
303      *            the first name
304      * @param lastName
305      *            the last name
306      * @param email
307      *            the email
308      * @param password
309      *            the password
310      * @return a new userid.
311      */
312     public static int createAssuranceUser(String firstName, String lastName, String email, String password) {
313         int uid = createVerifiedUser(firstName, lastName, email, password);
314
315         makeAssurer(uid);
316
317         return uid;
318     }
319
320     public static void makeAssurer(int uid) {
321         try (GigiPreparedStatement ps1 = new GigiPreparedStatement("INSERT INTO `cats_passed` SET `user_id`=?, `variant_id`=?")) {
322             ps1.setInt(1, uid);
323             ps1.setInt(2, 1);
324             ps1.execute();
325         }
326
327         try (GigiPreparedStatement ps2 = new GigiPreparedStatement("INSERT INTO `notary` SET `from`=?, `to`=?, points='100'")) {
328             ps2.setInt(1, uid);
329             ps2.setInt(2, uid);
330             ps2.execute();
331         }
332     }
333
334     protected static String stripCookie(String headerField) {
335         return headerField.substring(0, headerField.indexOf(';'));
336     }
337
338     public static final String SECURE_REFERENCE = MyDetails.PATH;
339
340     public static boolean isLoggedin(String cookie) throws IOException {
341         URL u = new URL("https://" + getServerName() + SECURE_REFERENCE);
342         HttpURLConnection huc = (HttpURLConnection) u.openConnection();
343         huc.addRequestProperty("Cookie", cookie);
344         return huc.getResponseCode() == 200;
345     }
346
347     public static String login(String email, String pw) throws IOException {
348         URL u = new URL("https://" + getServerName() + "/login");
349         HttpURLConnection huc = (HttpURLConnection) u.openConnection();
350
351         String csrf = getCSRF(huc);
352         String headerField = stripCookie(huc.getHeaderField("Set-Cookie"));
353
354         huc = (HttpURLConnection) u.openConnection();
355         cookie(huc, headerField);
356         huc.setDoOutput(true);
357         OutputStream os = huc.getOutputStream();
358         String data = "username=" + URLEncoder.encode(email, "UTF-8") + "&password=" + URLEncoder.encode(pw, "UTF-8") + "&csrf=" + URLEncoder.encode(csrf, "UTF-8");
359         os.write(data.getBytes("UTF-8"));
360         os.flush();
361         headerField = huc.getHeaderField("Set-Cookie");
362         if (headerField == null) {
363             return "";
364         }
365         return stripCookie(headerField);
366     }
367
368     public static String login(final PrivateKey pk, final X509Certificate ce) throws NoSuchAlgorithmException, KeyManagementException, IOException, MalformedURLException {
369
370         HttpURLConnection connection = (HttpURLConnection) new URL("https://" + getServerName().replaceFirst("^www.", "secure.") + "/login").openConnection();
371         authenticateClientCert(pk, ce, connection);
372         if (connection.getResponseCode() == 302) {
373             assertEquals("https://" + getServerName().replaceFirst("^www.", "secure.").replaceFirst(":443$", "") + "/", connection.getHeaderField("Location").replaceFirst(":443$", ""));
374             return stripCookie(connection.getHeaderField("Set-Cookie"));
375         } else {
376             return null;
377         }
378     }
379
380     public static void authenticateClientCert(final PrivateKey pk, final X509Certificate ce, HttpURLConnection connection) throws NoSuchAlgorithmException, KeyManagementException {
381         KeyManager km = new X509KeyManager() {
382
383             @Override
384             public String chooseClientAlias(String[] arg0, Principal[] arg1, Socket arg2) {
385                 return "client";
386             }
387
388             @Override
389             public String chooseServerAlias(String arg0, Principal[] arg1, Socket arg2) {
390                 return null;
391             }
392
393             @Override
394             public X509Certificate[] getCertificateChain(String arg0) {
395                 return new X509Certificate[] {
396                     ce
397                 };
398             }
399
400             @Override
401             public String[] getClientAliases(String arg0, Principal[] arg1) {
402                 return new String[] {
403                     "client"
404                 };
405             }
406
407             @Override
408             public PrivateKey getPrivateKey(String arg0) {
409                 if (arg0.equals("client")) {
410                     return pk;
411                 }
412                 return null;
413             }
414
415             @Override
416             public String[] getServerAliases(String arg0, Principal[] arg1) {
417                 return new String[] {
418                     "client"
419                 };
420             }
421         };
422         SSLContext sc = SSLContext.getInstance("TLS");
423         sc.init(new KeyManager[] {
424             km
425         }, null, null);
426         if (connection instanceof HttpsURLConnection) {
427             ((HttpsURLConnection) connection).setSSLSocketFactory(sc.getSocketFactory());
428         }
429     }
430
431     public static String getCSRF(URLConnection u) throws IOException {
432         return getCSRF(u, 0);
433     }
434
435     public static String getCSRF(URLConnection u, int formIndex) throws IOException {
436         String content = IOUtils.readURL(u);
437         return getCSRF(formIndex, content);
438     }
439
440     public static String getCSRF(int formIndex, String content) throws Error {
441         Pattern p = Pattern.compile("<input type='hidden' name='csrf' value='([^']+)'>");
442         Matcher m = p.matcher(content);
443         for (int i = 0; i < formIndex + 1; i++) {
444             if ( !m.find()) {
445                 throw new Error("No CSRF Token");
446             }
447         }
448         return m.group(1);
449     }
450
451     public static String executeBasicWebInteraction(String cookie, String path, String query) throws MalformedURLException, UnsupportedEncodingException, IOException {
452         return executeBasicWebInteraction(cookie, path, query, 0);
453     }
454
455     public static String executeBasicWebInteraction(String cookie, String path, String query, int formIndex) throws IOException, MalformedURLException, UnsupportedEncodingException {
456         URLConnection uc = post(cookie, path, query, formIndex);
457         String error = fetchStartErrorMessage(IOUtils.readURL(uc));
458         return error;
459     }
460
461     public static HttpURLConnection post(String cookie, String path, String query, int formIndex) throws IOException, MalformedURLException, UnsupportedEncodingException {
462         URLConnection uc = new URL("https://" + getServerName() + path).openConnection();
463         uc.addRequestProperty("Cookie", cookie);
464         String csrf = getCSRF(uc, formIndex);
465
466         uc = new URL("https://" + getServerName() + path).openConnection();
467         uc.addRequestProperty("Cookie", cookie);
468         uc.setDoOutput(true);
469         OutputStream os = uc.getOutputStream();
470         os.write(("csrf=" + URLEncoder.encode(csrf, "UTF-8") + "&" //
471         + query//
472         ).getBytes("UTF-8"));
473         os.flush();
474         return (HttpURLConnection) uc;
475     }
476
477     public HttpURLConnection get(String cookie, String path) throws IOException {
478         URLConnection uc = new URL("https://" + getServerName() + path).openConnection();
479         uc.addRequestProperty("Cookie", cookie);
480         return (HttpURLConnection) uc;
481     }
482
483     public static EmailAddress createVerifiedEmail(User u) throws InterruptedException, GigiApiException {
484         EmailAddress adrr = new EmailAddress(u, createUniqueName() + "test@test.tld", Locale.ENGLISH);
485         TestMail testMail = getMailReciever().receive();
486         assertEquals(adrr.getAddress(), testMail.getTo());
487         String hash = testMail.extractLink().substring(testMail.extractLink().lastIndexOf('=') + 1);
488         adrr.verify(hash);
489         getMailReciever().clearMails();
490         return adrr;
491     }
492
493     public static URLConnection cookie(URLConnection openConnection, String cookie) {
494         openConnection.setRequestProperty("Cookie", cookie);
495         return openConnection;
496     }
497
498     public static void verify(Domain d) {
499         try {
500             System.out.println(d.getId());
501             d.addPing(DomainPingType.EMAIL, "admin");
502             TestMail testMail = ter.receive();
503             testMail.verify();
504             assertTrue(d.isVerified());
505         } catch (GigiApiException e) {
506             throw new Error(e);
507         } catch (IOException e) {
508             throw new Error(e);
509         }
510     }
511
512 }