Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance. Project price only 1 $
You can buy this project and download/modify it how often you want.
/*
* Copyright (c) 2012-2019 Snowflake Computing Inc. All rights reserved.
*/
package net.snowflake.client.util;
import net.snowflake.client.log.SFLogger;
import net.snowflake.client.log.SFLoggerFactory;
import java.util.ArrayList;
import java.util.Arrays;
import java.util.HashSet;
import java.util.List;
import java.util.Set;
import java.util.regex.Matcher;
import java.util.regex.Pattern;
/**
* Search for credentials in sql and/or other text
*/
public class SecretDetector
{
// We look for long base64 encoded (and perhaps also URL encoded - hence the
// '%' character in the regex) strings.
// This will match some things that it shouldn't. The minimum number of
// characters is essentially a random choice - long enough to not mask other
// strings but not so long that it might miss things.
private static final Pattern GENERIC_CREDS_PATTERN = Pattern.compile(
"([a-z0-9+/%]{18,})", Pattern.CASE_INSENSITIVE);
private static final Pattern AWS_KEY_PATTERN = Pattern.compile(
"(aws_key_id)|(aws_secret_key)|(access_key_id)|(secret_access_key)",
Pattern.CASE_INSENSITIVE);
// Used for detecting tokens in serialized JSON
private static final Pattern AWS_TOKEN_PATTERN = Pattern.compile(
"(accessToken|tempToken|keySecret)\"\\s*:\\s*\"([a-z0-9/+]{32,}={0,2})\"",
Pattern.CASE_INSENSITIVE);
// Signature added in the query string of a URL in SAS based authentication
// for S3 or Azure Storage requests
private static final Pattern SAS_TOKEN_PATTERN = Pattern.compile(
"(sig|signature|AWSAccessKeyId|password|passcode)=(?[a-z0-9%/+]{16,})",
Pattern.CASE_INSENSITIVE);
private static final Pattern PASSWORD_KEY_PATTERN = Pattern.compile(
"(password|passcode)=",
Pattern.CASE_INSENSITIVE);
// "-----BEGIN PRIVATE KEY-----\n[PRIVATE-KEY]\n-----END PRIVATE KEY-----"
private static final Pattern PRIVATE_KEY_PATTERN = Pattern.compile(
"-----BEGIN PRIVATE KEY-----\\\\n([a-z0-9/+=\\\\n]{32,})\\\\n-----END PRIVATE KEY-----",
Pattern.MULTILINE | Pattern.CASE_INSENSITIVE);
// "privateKeyData": "[PRIVATE-KEY]"
private static final Pattern PRIVATE_KEY_DATA_PATTERN = Pattern.compile(
"\"privateKeyData\": \"([a-z0-9/+=\\\\n]{10,})\"",
Pattern.MULTILINE | Pattern.CASE_INSENSITIVE);
private static final int LOOK_AHEAD = 10;
// only attempt to find secrets in its leading 100Kb SNOW-30961
private static final int MAX_LENGTH = 100 * 1000;
private static final SFLogger LOGGER = SFLoggerFactory.getLogger(
SecretDetector.class);
private static String[] SENSITIVE_NAMES = {
"access_key_id",
"accesstoken",
"aws_key_id",
"aws_secret_key",
"awsaccesskeyid",
"keysecret",
"passcode",
"password",
"privatekey",
"privatekeydata",
"secret_access_key",
"sig",
"signature",
"temptoken",
};
private static Set SENSITIVE_NAME_SET = new HashSet<>(Arrays.asList(SENSITIVE_NAMES));
/**
* Check whether the name is sensitive
*
* @param name
*/
public static boolean isSensitive(String name)
{
return SENSITIVE_NAME_SET.contains(name.toLowerCase());
}
/**
* Find all the positions of aws key id and aws secret key.
* The time complexity is O(n)
*
* @param text the sql text which may contain aws key
* @return Return a list of begin/end positions of aws key id and
* aws secret key.
*/
private static List getAWSSecretPos(String text)
{
Matcher matcher = AWS_KEY_PATTERN.matcher(text);
ArrayList awsSecretRanges = new ArrayList<>();
while (matcher.find())
{
int beginPos = Math.min(matcher.end() + LOOK_AHEAD, text.length());
while (beginPos > 0 && beginPos < text.length() &&
isBase64(text.charAt(beginPos)))
{
beginPos--;
}
int endPos = Math.min(matcher.end() + LOOK_AHEAD, text.length());
while (endPos < text.length() && isBase64(text.charAt(endPos)))
{
endPos++;
}
if (beginPos < text.length() && endPos <= text.length()
&& beginPos >= 0 && endPos >= 0)
{
awsSecretRanges.add(new SecretRange(beginPos + 1, endPos));
}
}
return awsSecretRanges;
}
/**
* Find all the positions of long base64 encoded strings that are typically
* indicative of secrets or other keys.
* The time complexity is O(n)
*
* @param text the sql text which may contain secrets
* @return Return a list of begin/end positions of keys in the string
*/
private static List getGenericSecretPos(String text)
{
// log before and after in case this is causing StackOverflowError
LOGGER.debug("pre-regex getGenericSecretPos");
Matcher matcher = GENERIC_CREDS_PATTERN.matcher(
text.length() <= MAX_LENGTH ? text : text.substring(0, MAX_LENGTH));
ArrayList awsSecretRanges = new ArrayList<>();
while (matcher.find())
{
awsSecretRanges.add(new SecretRange(matcher.start(), matcher.end()));
}
LOGGER.debug("post-regex getGenericSecretPos");
return awsSecretRanges;
}
/**
* Finds positions of occurrences of all sensitive fields of SAS tokens in the
* given text.
*
* @param text text which may contain SAS tokens
* @return A list of begin/end positions of sensitive fields of SAS tokens
*/
private static List getSASTokenPos(String text)
{
// log before and after in case this is causing StackOverflowError
LOGGER.debug("pre-regex getSASTokenPos");
Matcher matcher = SAS_TOKEN_PATTERN.matcher(
text.length() <= MAX_LENGTH ? text : text.substring(0, MAX_LENGTH));
List secretRanges = new ArrayList<>();
while (matcher.find())
{
// Gets begin/end position of only 'secret' group in the matched regex
secretRanges.add(
new SecretRange(
matcher.start("secret"), matcher.end("secret")));
}
LOGGER.debug("post-regex getSASTokenPos");
return secretRanges;
}
/**
* Finds positions of occurrences of all password fields in the
* given text.
*
* @param text text which may contain passwords
* @return A list of begin/end positions of password fields
*/
private static List getPasswordPos(String text)
{
// log before and after in case this is causing StackOverflowError
LOGGER.debug("pre-regex getPasswordPos");
Matcher matcher = PASSWORD_KEY_PATTERN.matcher(
text.length() <= MAX_LENGTH ? text : text.substring(0, MAX_LENGTH));
List secretRanges = new ArrayList<>();
while (matcher.find())
{
// Gets begin/end position of only 'secret' group in the matched regex
int begin = matcher.end();
int end = begin + 1;
while (end < text.length())
{
if (text.charAt(end) == '&' || text.charAt(end) == '"')
{
break;
}
end++;
}
secretRanges.add(new SecretRange(begin, end));
}
LOGGER.debug("post-regex getPasswordPos");
return secretRanges;
}
private static boolean isBase64(char ch)
{
return ('A' <= ch && ch <= 'Z')
|| ('a' <= ch && ch <= 'z')
|| ('0' <= ch && ch <= '9')
|| ch == '+'
|| ch == '/'
|| ch == '=';
}
/**
* mask AWS secret in the input string
*
* @param sql The sql text to mask
* @return masked string
*/
public static String maskAWSSecret(String sql)
{
List secretRanges = SecretDetector.getAWSSecretPos(sql);
return maskText(sql, secretRanges);
}
/**
* Masks SAS token(s) in the input string
*
* @param text Text which may contain SAS token(s)
* @return Masked string
*/
public static String maskSASToken(String text)
{
List secretRanges = SecretDetector.getSASTokenPos(text);
return maskText(text, secretRanges);
}
/**
* Masks any secrets present in the input string. This currently checks for
* SAS tokens ({@link SecretDetector#maskSASToken(String)}) and AWS keys
* ({@link SecretDetector#maskAWSSecret(String)}.
*
* @param text Text which may contain secrets
* @return Masked string
*/
public static String maskSecrets(String text)
{
List secretRanges = SecretDetector.getAWSSecretPos(text);
secretRanges.addAll(SecretDetector.getAWSSecretPos(text));
secretRanges.addAll(SecretDetector.getSASTokenPos(text));
secretRanges.addAll(SecretDetector.getPasswordPos(text));
text = maskText(text, secretRanges);
text = filterAccessTokens(text);
return text;
}
/**
* Masks given text between given list of begin/end positions.
*
* @param text text to mask
* @param ranges List of begin/end positions of text that need to be masked
* @return masked text
*/
private static String maskText(String text, List ranges)
{
if (ranges.isEmpty())
{
return text;
}
// Convert the text to a char array to be able to modify it.
char[] chars = text.toCharArray();
for (SecretRange range : ranges)
{
int beginPos = range.beginPos;
int endPos = range.endPos;
for (int curPos = beginPos; curPos < endPos; curPos++)
{
chars[curPos] = '☺';
}
}
// Convert it back to a string
return String.valueOf(chars);
}
static class SecretRange
{
final int beginPos;
final int endPos;
SecretRange(int beginPos, int endPos)
{
this.beginPos = beginPos;
this.endPos = endPos;
}
}
/**
* Filter access tokens that might be buried in JSON. Currently only used
* to filter the scopedCreds passed for XP binary downloads
*
* @param message the message text which may contain secrets
* @return Return filtered message
*/
public static String filterAccessTokens(String message)
{
Matcher awsMatcher = AWS_TOKEN_PATTERN.matcher(message);
// aws
if (awsMatcher.find())
{
message = awsMatcher.replaceAll("$1\":\"XXXX\"");
}
// azure
Matcher azureMatcher = SAS_TOKEN_PATTERN.matcher(message);
if (azureMatcher.find())
{
message = azureMatcher.replaceAll("sig=XXXX");
}
// GCS
Matcher gcsMatcher = PRIVATE_KEY_PATTERN.matcher(message);
if (gcsMatcher.find())
{
message = gcsMatcher.replaceAll("-----BEGIN PRIVATE KEY-----\\\\nXXXX\\\\n-----END PRIVATE KEY-----");
}
gcsMatcher = PRIVATE_KEY_DATA_PATTERN.matcher(message);
if (gcsMatcher.find())
{
message = gcsMatcher.replaceAll("\"privateKeyData\": \"XXXX\"");
}
return message;
}
}
