X-Git-Url: https://code.wpia.club/?a=blobdiff_plain;f=src%2Forg%2Fcacert%2Fgigi%2Fping%2FPingerDaemon.java;h=e543ca1cd4dd60ed41f922aa11edf451f2ad7de7;hb=0dbbc40ce4e48c40e08ab43f6e5a02441ed6c90c;hp=ac61f14cdcb0b6517809342d6ca379a107bd544a;hpb=06b41fa06bd488f943eae0a16a71babdd2745e24;p=gigi.git diff --git a/src/org/cacert/gigi/ping/PingerDaemon.java b/src/org/cacert/gigi/ping/PingerDaemon.java index ac61f14c..e543ca1c 100644 --- a/src/org/cacert/gigi/ping/PingerDaemon.java +++ b/src/org/cacert/gigi/ping/PingerDaemon.java @@ -1,80 +1,93 @@ package org.cacert.gigi.ping; -import java.io.FileReader; -import java.io.IOException; -import java.sql.PreparedStatement; -import java.sql.ResultSet; -import java.sql.SQLException; +import java.security.KeyStore; import java.util.HashMap; -import java.util.Properties; +import java.util.LinkedList; +import java.util.Queue; -import org.cacert.gigi.Domain; -import org.cacert.gigi.User; import org.cacert.gigi.database.DatabaseConnection; +import org.cacert.gigi.database.GigiPreparedStatement; +import org.cacert.gigi.database.GigiResultSet; +import org.cacert.gigi.dbObjects.Domain; +import org.cacert.gigi.dbObjects.DomainPingConfiguration; +import org.cacert.gigi.dbObjects.DomainPingConfiguration.PingType; import org.cacert.gigi.util.RandomToken; public class PingerDaemon extends Thread { - HashMap pingers = new HashMap<>(); + HashMap pingers = new HashMap<>(); - private PreparedStatement searchNeededPings; + private GigiPreparedStatement searchNeededPings; - private PreparedStatement enterPingResult; + private GigiPreparedStatement enterPingResult; + + private KeyStore truststore; + + private Queue toExecute = new LinkedList<>(); + + public PingerDaemon(KeyStore truststore) { + this.truststore = truststore; + } @Override public void run() { - try { - searchNeededPings = DatabaseConnection.getInstance().prepare("SELECT pingconfig.*, domains.domain, domains.memid FROM pingconfig LEFT JOIN domainPinglog ON domainPinglog.configId=pingconfig.id INNER JOIN domains ON domains.id=pingconfig.domainid WHERE domainPinglog.configId IS NULL "); - enterPingResult = DatabaseConnection.getInstance().prepare("INSERT INTO domainPinglog SET configId=?, state=?, result=?, challenge=?"); - pingers.put("email", new EmailPinger()); - pingers.put("ssl", new SSLPinger()); - pingers.put("http", new HTTPFetch()); - pingers.put("dns", new DNSPinger()); - } catch (SQLException e) { - e.printStackTrace(); - } + searchNeededPings = DatabaseConnection.getInstance().prepare("SELECT `pingconfig`.`id` FROM `pingconfig` LEFT JOIN `domainPinglog` ON `domainPinglog`.`configId` = `pingconfig`.`id` INNER JOIN `domains` ON `domains`.`id` = `pingconfig`.`domainid` WHERE ( `domainPinglog`.`configId` IS NULL) AND `domains`.`deleted` IS NULL GROUP BY `pingconfig`.`id`"); + enterPingResult = DatabaseConnection.getInstance().prepare("INSERT INTO `domainPinglog` SET `configId`=?, `state`=?::`pingState`, `result`=?, `challenge`=?"); + pingers.put(PingType.EMAIL, new EmailPinger()); + pingers.put(PingType.SSL, new SSLPinger(truststore)); + pingers.put(PingType.HTTP, new HTTPFetch()); + pingers.put(PingType.DNS, new DNSPinger()); + while (true) { - try { - execute(); - } catch (SQLException e) { - e.printStackTrace(); + synchronized (this) { + DomainPingConfiguration conf; + while ((conf = toExecute.peek()) != null) { + handle(conf); + toExecute.remove(); + } + notifyAll(); + } + + GigiResultSet rs = searchNeededPings.executeQuery(); + while (rs.next()) { + handle(DomainPingConfiguration.getById(rs.getInt("id"))); } try { Thread.sleep(5000); } catch (InterruptedException e) { - e.printStackTrace(); } } } - private void execute() throws SQLException { - - ResultSet rs = searchNeededPings.executeQuery(); - while (rs.next()) { - String type = rs.getString("type"); - String config = rs.getString("info"); - DomainPinger dp = pingers.get(type); - if (dp != null) { - String token = null; - if (dp instanceof EmailPinger) { - token = RandomToken.generateToken(16); - config = config + ":" + token; - } - enterPingResult.setInt(1, rs.getInt("id")); - String resp = dp.ping(Domain.getById(rs.getInt("domainid")), config, User.getById(rs.getInt("memid"))); - enterPingResult.setString(2, DomainPinger.PING_STILL_PENDING == resp ? "open" : DomainPinger.PING_SUCCEDED.equals(resp) ? "success" : "failed"); - enterPingResult.setString(3, resp); - enterPingResult.setString(4, token); - enterPingResult.execute(); + private void handle(DomainPingConfiguration conf) { + PingType type = conf.getType(); + String config = conf.getInfo(); + DomainPinger dp = pingers.get(type); + if (dp != null) { + String token = null; + if (dp instanceof EmailPinger) { + token = RandomToken.generateToken(16); + config = config + ":" + token; } + enterPingResult.setInt(1, conf.getId()); + Domain target = conf.getTarget(); + String resp = dp.ping(target, config, target.getOwner()); + enterPingResult.setString(2, DomainPinger.PING_STILL_PENDING == resp ? "open" : DomainPinger.PING_SUCCEDED.equals(resp) ? "success" : "failed"); + enterPingResult.setString(3, resp); + enterPingResult.setString(4, token); + enterPingResult.execute(); } } - public static void main(String[] args) throws IOException { - Properties conf = new Properties(); - conf.load(new FileReader("config/gigi.properties")); - DatabaseConnection.init(conf); - new PingerDaemon().run(); - + public synchronized void queue(DomainPingConfiguration toReping) { + interrupt(); + toExecute.add(toReping); + while (toExecute.size() > 0) { + try { + wait(); + } catch (InterruptedException e) { + e.printStackTrace(); + } + } } }