private String getBase64HashValue(ResultSet rs) throws SQLException { if (dbControl == DbControl.XIPKI_OCSP_v4) { return rs.getString("HASH"); } else { // if (dbControl == DbControl.XIPKI_CA_v4) { if (certhashAlgo == HashAlgo.SHA1) { return rs.getString("SHA1"); } else { String b64Cert = rs.getString("CERT"); byte[] encodedCert = Base64.decodeFast(b64Cert); return certhashAlgo.base64Hash(encodedCert); } } } }
private String getBase64HashValue(ResultSet rs) throws SQLException { if (dbControl == DbControl.XIPKI_OCSP_v4) { return rs.getString("HASH"); } else { // if (dbControl == DbControl.XIPKI_CA_v4) { if (certhashAlgo == HashAlgo.SHA1) { return rs.getString("SHA1"); } else { String b64Cert = rs.getString("CERT"); byte[] encodedCert = Base64.decodeFast(b64Cert); return certhashAlgo.base64Hash(encodedCert); } } } }
private static Map<Integer, byte[]> getCas(DataSourceWrapper datasource, DbControl dbControl) throws DataAccessException { // get a list of available CAs in the target database String sql = "SELECT ID,CERT FROM "; if (dbControl == DbControl.XIPKI_CA_v4) { sql += "CA"; } else if (dbControl == DbControl.XIPKI_OCSP_v4) { sql += "ISSUER"; } else { throw new IllegalArgumentException("unknown dbControl " + dbControl); } Statement stmt = datasource.createStatement(); Map<Integer, byte[]> caIdCertMap = new HashMap<>(5); ResultSet rs = null; try { rs = stmt.executeQuery(sql); while (rs.next()) { caIdCertMap.put(rs.getInt("ID"), Base64.decodeFast(rs.getString("CERT"))); } } catch (SQLException ex) { throw datasource.translate(sql, ex); } finally { datasource.releaseResources(stmt, rs); } return caIdCertMap; }
private static Map<Integer, byte[]> getCas(DataSourceWrapper datasource, DbControl dbControl) throws DataAccessException { // get a list of available CAs in the target database String sql = "SELECT ID,CERT FROM "; if (dbControl == DbControl.XIPKI_CA_v4) { sql += "CA"; } else if (dbControl == DbControl.XIPKI_OCSP_v4) { sql += "ISSUER"; } else { throw new IllegalArgumentException("unknown dbControl " + dbControl); } Connection conn = datasource.getConnection(); Statement stmt = datasource.createStatement(conn); Map<Integer, byte[]> caIdCertMap = new HashMap<>(5); ResultSet rs = null; try { rs = stmt.executeQuery(sql); while (rs.next()) { caIdCertMap.put(rs.getInt("ID"), Base64.decodeFast(rs.getString("CERT"))); } } catch (SQLException ex) { throw datasource.translate(sql, ex); } finally { datasource.releaseResources(stmt, rs); } return caIdCertMap; }
hash = rs.getString("SHA1"); } else { hash = certhashAlgo.base64Hash(Base64.decodeFast(rs.getString("CERT")));
hash = rs.getString("SHA1"); } else { hash = certhashAlgo.base64Hash(Base64.decodeFast(rs.getString("CERT")));
public byte[] getEncodedCrl(NameId ca, BigInteger crlNumber) throws OperationException { Args.notNull(ca, "ca"); String sql = (crlNumber == null) ? sqlCrl : sqlCrlWithNo; ResultSet rs = null; PreparedStatement ps = borrowPreparedStatement(sql); String b64Crl = null; try { int idx = 1; ps.setInt(idx++, ca.getId()); if (crlNumber != null) { ps.setLong(idx++, crlNumber.longValue()); } rs = ps.executeQuery(); long currentThisUpdate = 0; // iterate all entries to make sure that the latest CRL will be returned while (rs.next()) { long thisUpdate = rs.getLong("THISUPDATE"); if (thisUpdate >= currentThisUpdate) { b64Crl = rs.getString("CRL"); currentThisUpdate = thisUpdate; } } } catch (SQLException ex) { throw new OperationException(DATABASE_FAILURE, datasource.translate(sql, ex).getMessage()); } finally { datasource.releaseResources(ps, rs); } return (b64Crl == null) ? null : Base64.decodeFast(b64Crl); } // method getEncodedCrl
byte[] encodedCert = Base64.decodeFast(b64Cert);
return (b64Req == null) ? null : Base64.decodeFast(b64Req);
byte[] encodedCert = Base64.decodeFast(b64Cert); X509Certificate cert = X509Util.parseCert(encodedCert); CertWithDbId certWithMeta = new CertWithDbId(cert, encodedCert);
byte[] certBytes = Base64.decodeFast(b64Cert); X509Certificate cert; try {
byte[] encodedCert = Base64.decodeFast(b64Cert); X509Certificate cert = X509Util.parseCert(encodedCert);
byte[] certBytes = Base64.decodeFast(rs.getString("CERT")); byte[] crlBytes = Base64.decodeFast(rs.getString("CRL")); byte[] dataBytes = Base64.decodeFast(rs.getString("DATA")); String sha1 = HashAlgo.SHA1.hexHash(dataBytes); final String dataFilename = sha1 + ".req";
byte[] certBytes = Base64.decodeFast(rs.getString("CERT")); ((CaCertstore.Certs) entriesInCurrentFile).add(cert); } else if (CaDbEntryType.CRL == type) { byte[] crlBytes = Base64.decodeFast(rs.getString("CRL")); ((CaCertstore.Crls) entriesInCurrentFile).add(crl); } else if (CaDbEntryType.REQUEST == type) { byte[] dataBytes = Base64.decodeFast(rs.getString("DATA")); String sha1 = HashAlgo.SHA1.hexHash(dataBytes); final String dataFilename = sha1 + ".req";
if (hdrValue.length() > 6) { String b64 = hdrValue.substring(6); byte[] userPwd = Base64.decodeFast(b64); int idx = -1; for (int i = 0; i < userPwd.length; i++) {