コード例 #1
0
 public List<DNS53ResourceRecord> listResourceRecords(
     String tableName, String type, String name, String rdata) throws ErrorResponse {
   List<DNS53ResourceRecord> records = new LinkedList<DNS53ResourceRecord>();
   boolean whereFlag = false;
   if (tableName == null) {
     // TODO throw InternalError
   }
   String query = "select * from `" + tableName + "`";
   if (type != null && !type.equals("")) {
     type = "\'" + type + "\'";
     if (whereFlag) {
       // probably never reached:
       query += " AND rdtype = " + type;
     } else {
       query += " WHERE rdtype = " + type;
       whereFlag = true;
     }
   }
   if (name != null && !name.equals("")) {
     name = "\'" + name + "\'";
     if (whereFlag) {
       query += " AND name = " + name;
     } else {
       query += " WHERE name = " + name;
       whereFlag = true;
     }
   }
   if (rdata != null && !rdata.equals("")) {
     rdata = "\'" + rdata + "\'";
     if (whereFlag) {
       query += " AND rdata = " + rdata;
     } else {
       query += " WHERE rdata = " + rdata;
       whereFlag = true;
     }
   }
   query += ";";
   // now query is created
   try {
     Statement stmt = this.sqlConnection.createStatement();
     ResultSet rs = stmt.executeQuery(query);
     while (rs.next()) {
       DNS53ResourceRecord temp = new DNS53ResourceRecord();
       temp.setName(rs.getString("name"));
       temp.setTtl(rs.getLong("ttl"));
       temp.setRdtype(rs.getString("rdtype"));
       temp.setRdata(rs.getString("rdata"));
       records.add(temp);
     }
   } catch (SQLException e) {
     e.printStackTrace();
     throw DNS53Faults.InternalError();
   }
   return records;
 }
コード例 #2
0
  @Override
  public List<DNS53ResourceRecord> listResourceRecords(
      Session sess,
      String zoneId,
      String name,
      String value,
      String type,
      String sid,
      long ttl,
      long weight)
      throws ErrorResponse {
    List<DNS53ResourceRecord> records = new LinkedList<DNS53ResourceRecord>();

    String zoneName = getZoneName(zoneId);
    if (zoneName.equals("FAILED")) {
      throw DNS53Faults.NoSuchHostedZone(zoneId);
    }

    String query = "SELECT * FROM `msi`.`rrSet` WHERE zoneName = \'" + zoneName + "\'";
    if (type != null && !type.equals("")) {
      type = "\'" + type + "\'";
      query += " AND rdtype = " + type;
    }
    if (name != null && !name.equals("")) {
      String nameDot = name;
      if (name.charAt(name.length() - 1) != '.') {
        nameDot += ".";
      } else {
        name = name.substring(0, name.length() - 1);
      }
      name = "\'" + nameDot + "\'";
      query += " AND name = " + name;
    }
    if (value != null && !value.equals("")) {
      value = "\'" + value + "\'";
      query += " AND rdata = " + value;
    }
    if (sid != null && !sid.equals("")) {
      sid = "\'" + sid + "\'";
      query += " AND sid = " + sid;
    }
    if (ttl != -1) {
      query += " AND ttl = " + ttl;
    }
    if (weight != -1) {
      query += " AND weight = " + weight;
    }
    query += ";";
    // now query is created
    try {
      Statement stmt = this.sqlConnection.createStatement();
      ResultSet rs = stmt.executeQuery(query);
      while (rs.next()) {
        DNS53ResourceRecord temp = new DNS53ResourceRecord();
        temp.setName(rs.getString("name"));
        temp.setTtl(rs.getLong("ttl"));
        temp.setRdtype(rs.getString("rdtype"));
        temp.setRdata(rs.getString("rdata"));
        temp.setSid(rs.getString("sid"));
        temp.setWeight(rs.getLong("weight"));
        records.add(temp);
      }
    } catch (SQLException e) {
      e.printStackTrace();
      throw DNS53Faults.InternalError();
    }
    return records;
  }
コード例 #3
0
  /**
   * Populate the new hosted zone data into MySQL database
   *
   * @param domainName name of the hosted zone
   * @param callerRef unique caller reference for this request
   * @param comment user's comment for this request
   * @return ID of the new hosted zone (automatically issued); "DUPLICATE_NAME" is returned if
   *     target name already exists
   * @throws InternalErrorException
   */
  @Override
  public List<String> createHostedZone(
      final Session session, String domainName, String callerRef, String comment, long acid)
      throws ErrorResponse {
    List<String> result = new LinkedList<String>();
    // String tableName = acid + callerRef;
    String tableName = "B" + UUID.randomUUID().toString().replace("-", "").toUpperCase();
    if (callerReferenceIsUsed(callerRef, acid)) {
      result.add("DUPLICATE_REFERENCE");
      return result; // response: signal that the name is already in use
    }
    String domainNameDot = domainName;
    if (domainName.charAt(domainName.length() - 1) != '.') {
      domainNameDot += ".";
    } else {
      domainName = domainName.substring(0, domainName.length() - 1);
    }

    if (domainExists(domainNameDot, acid)) {
      result.add("DUPLICATE_NAME");
      return result;
    }
    String query =
        "CREATE TABLE `"
            + tableName
            + "` ("
            + "		  name varchar(255) default NULL,"
            + "		  ttl int(11) default NULL,"
            + "		  rdtype varchar(255) default NULL,"
            + "		  rdata varchar(255) default NULL"
            + "		) ENGINE=MyISAM DEFAULT CHARSET=latin1;";
    try {
      Statement stmt = this.sqlConnection.createStatement();
      stmt.executeUpdate(query);
      stmt.close();
    } catch (SQLException e) {
      System.err.println("Failed to create a new schema in MySQL database.");
      e.printStackTrace();
      throw DNS53Faults.InternalError(); // just put some bogus UUID
      // unless RequestID becomes
      // important this layer
    }
    // insert this new ID-name mapping entry including caller reference and
    // comment
    String uniqueID = "Z" + UUID.randomUUID().toString().replace("-", "").toUpperCase();
    final DNS53HostedZone zone = new DNS53HostedZone();
    zone.setId(uniqueID);
    zone.setName(domainNameDot);
    zone.setCallerRefernce(callerRef);
    zone.setComment(comment);
    zone.setAccount(acid);
    zone.setTableName(tableName);
    session.save(zone);

    addRecord(
        tableName,
        domainName,
        259200,
        "SOA",
        domainName + ". hostmaster." + domainName + ". 200309181 28800 7200 86400 28800");
    DNS53ResourceRecord recordSOA = new DNS53ResourceRecord();
    recordSOA.setName(domainNameDot);
    recordSOA.setTtl(259200);
    recordSOA.setRdata(
        domainName + ". hostmaster." + domainName + ". 200309181 28800 7200 86400 28800");
    recordSOA.setRdtype("SOA");
    recordSOA.setZoneId(uniqueID);
    recordSOA.setZoneName(domainNameDot);
    session.save(recordSOA);

    addRecord(tableName, domainName, 259200, "NS", "ns0." + domainName + ".");
    DNS53ResourceRecord recordNS0 = new DNS53ResourceRecord();
    recordNS0.setName(domainNameDot);
    recordNS0.setTtl(259200);
    recordNS0.setRdata("ns0." + domainName + ".");
    recordNS0.setRdtype("NS");
    recordNS0.setZoneId(uniqueID);
    recordNS0.setZoneName(domainNameDot);
    session.save(recordNS0);

    addRecord(tableName, domainName, 259200, "NS", "ns1." + domainName + ".");
    DNS53ResourceRecord recordNS1 = new DNS53ResourceRecord();
    recordNS1.setName(domainNameDot);
    recordNS1.setTtl(259200);
    recordNS1.setRdata("ns1." + domainName + ".");
    recordNS1.setRdtype("NS");
    recordNS1.setZoneId(uniqueID);
    recordNS1.setZoneName(domainNameDot);
    session.save(recordNS1);

    final String nameserverIp =
        (String) ConfigurationUtil.getConfiguration(Arrays.asList(new String[] {"DNS_IP"}));
    String ns0name = "ns0." + domainName;
    String ns1name = "ns1." + domainName;
    String ns0nameDot = "ns0." + domainNameDot;
    String ns1nameDot = "ns1." + domainNameDot;
    addRecord(tableName, ns0name, 259200, "A", nameserverIp);
    DNS53ResourceRecord recordA0 = new DNS53ResourceRecord();
    recordA0.setName(ns0nameDot);
    recordA0.setTtl(259200);
    recordA0.setRdata(nameserverIp);
    recordA0.setRdtype("A");
    recordA0.setZoneId(uniqueID);
    recordA0.setZoneName(domainNameDot);
    session.save(recordA0);

    addRecord(tableName, ns1name, 259200, "A", nameserverIp);
    DNS53ResourceRecord recordA1 = new DNS53ResourceRecord();
    recordA1.setName(ns1nameDot);
    recordA1.setTtl(259200);
    recordA1.setRdata(nameserverIp);
    recordA1.setRdtype("A");
    recordA1.setZoneId(uniqueID);
    recordA1.setZoneName(domainNameDot);
    session.save(recordA1);

    result.add(uniqueID);
    result.add(tableName);
    result.add(ns0name);
    result.add(ns1name);

    session.save(zone);

    return result;
  }