108 const char *shadow_pass);
110 char **
output,
int *outputlen,
111 const char **logdetail);
182 int *
iterations,
int *key_length,
char **salt,
212 if (
port->ssl_in_use)
257 state->channel_binding_in_use =
true;
261 state->channel_binding_in_use =
false;
264 (
errcode(ERRCODE_PROTOCOL_VIOLATION),
265 errmsg(
"client selected an invalid SASL authentication mechanism")));
289 (
errmsg(
"invalid SCRAM secret for user \"%s\"",
290 state->port->user_name)));
300 state->logdetail =
psprintf(
_(
"User \"%s\" does not have a valid SCRAM secret."),
301 state->port->user_name);
327 state->doomed =
true;
351 char **
output,
int *outputlen,
const char **logdetail)
379 (
errcode(ERRCODE_PROTOCOL_VIOLATION),
380 errmsg(
"malformed SCRAM message"),
382 if (inputlen != strlen(
input))
384 (
errcode(ERRCODE_PROTOCOL_VIOLATION),
385 errmsg(
"malformed SCRAM message"),
386 errdetail(
"Message length does not match input length.")));
388 switch (
state->state)
417 (
errcode(ERRCODE_PROTOCOL_VIOLATION),
418 errmsg(
"invalid SCRAM response"),
455 elog(
ERROR,
"invalid SCRAM exchange state");
460 *logdetail =
state->logdetail;
463 *outputlen = strlen(*
output);
487 const char *errstr = NULL;
496 password = (
const char *) prep_password;
501 (
errcode(ERRCODE_INTERNAL_ERROR),
502 errmsg(
"could not generate random salt")));
510 pfree(prep_password);
536 const char *errstr = NULL;
539 &encoded_salt, stored_key, server_key))
551 saltlen =
pg_b64_decode(encoded_salt, strlen(encoded_salt), salt,
568 salted_password, &errstr) < 0 ||
570 computed_key, &errstr) < 0)
572 elog(
ERROR,
"could not compute server key: %s", errstr);
576 pfree(prep_password);
582 return memcmp(computed_key, server_key, key_length) == 0;
600 char **salt,
uint8 *stored_key,
uint8 *server_key)
606 char *iterations_str;
610 uint8 *decoded_salt_buf;
611 uint8 *decoded_stored_buf;
612 uint8 *decoded_server_buf;
620 scheme_str =
strsep(&v,
"$");
623 iterations_str =
strsep(&v,
":");
626 salt_str =
strsep(&v,
"$");
629 storedkey_str =
strsep(&v,
":");
635 if (strcmp(scheme_str,
"SCRAM-SHA-256") != 0)
642 if (*p || errno != 0)
650 decoded_salt_buf =
palloc(decoded_len);
652 decoded_salt_buf, decoded_len);
661 decoded_stored_buf =
palloc(decoded_len);
662 decoded_len =
pg_b64_decode(storedkey_str, strlen(storedkey_str),
663 decoded_stored_buf, decoded_len);
664 if (decoded_len != *key_length)
666 memcpy(stored_key, decoded_stored_buf, *key_length);
669 decoded_server_buf =
palloc(decoded_len);
670 decoded_len =
pg_b64_decode(serverkey_str, strlen(serverkey_str),
671 decoded_server_buf, decoded_len);
672 if (decoded_len != *key_length)
674 memcpy(server_key, decoded_server_buf, *key_length);
696 int *
iterations,
int *key_length,
char **salt,
716 if (raw_salt == NULL)
721 encoded_salt = (
char *)
palloc(encoded_len + 1);
727 encoded_salt[encoded_len] =
'\0';
729 *salt = encoded_salt;
743 char *begin = *
input;
748 (
errcode(ERRCODE_PROTOCOL_VIOLATION),
749 errmsg(
"malformed SCRAM message"),
750 errdetail(
"Expected attribute \"%c\" but found \"%s\".",
756 (
errcode(ERRCODE_PROTOCOL_VIOLATION),
757 errmsg(
"malformed SCRAM message"),
758 errdetail(
"Expected character \"=\" for attribute \"%c\".", attr)));
762 while (*end && *end !=
',')
790 if (*p < 0x21 || *p > 0x7E || *p == 0x2C )
809 if (
c >= 0x21 &&
c <= 0x7E)
827 static char buf[30 + 1];
830 for (
i = 0;
i <
sizeof(
buf) - 1;
i++)
837 if (
c >= 0x21 &&
c <= 0x7E)
855 char *begin = *
input;
861 (
errcode(ERRCODE_PROTOCOL_VIOLATION),
862 errmsg(
"malformed SCRAM message"),
863 errdetail(
"Attribute expected, but found end of string.")));
871 if (!((attr >=
'A' && attr <=
'Z') ||
872 (attr >=
'a' && attr <=
'z')))
874 (
errcode(ERRCODE_PROTOCOL_VIOLATION),
875 errmsg(
"malformed SCRAM message"),
876 errdetail(
"Attribute expected, but found invalid character \"%s\".",
884 (
errcode(ERRCODE_PROTOCOL_VIOLATION),
885 errmsg(
"malformed SCRAM message"),
886 errdetail(
"Expected character \"=\" for attribute \"%c\".", attr)));
890 while (*end && *end !=
',')
914 char *channel_binding_type;
981 state->cbind_flag = *p;
990 if (
state->channel_binding_in_use)
992 (
errcode(ERRCODE_PROTOCOL_VIOLATION),
993 errmsg(
"malformed SCRAM message"),
994 errdetail(
"The client selected SCRAM-SHA-256-PLUS, but the SCRAM message does not include channel binding data.")));
999 (
errcode(ERRCODE_PROTOCOL_VIOLATION),
1000 errmsg(
"malformed SCRAM message"),
1001 errdetail(
"Comma expected, but found character \"%s\".",
1012 if (
state->channel_binding_in_use)
1014 (
errcode(ERRCODE_PROTOCOL_VIOLATION),
1015 errmsg(
"malformed SCRAM message"),
1016 errdetail(
"The client selected SCRAM-SHA-256-PLUS, but the SCRAM message does not include channel binding data.")));
1019 if (
state->port->ssl_in_use)
1021 (
errcode(ERRCODE_INVALID_AUTHORIZATION_SPECIFICATION),
1022 errmsg(
"SCRAM channel binding negotiation error"),
1023 errdetail(
"The client supports SCRAM channel binding but thinks the server does not. "
1024 "However, this server does support channel binding.")));
1029 (
errcode(ERRCODE_PROTOCOL_VIOLATION),
1030 errmsg(
"malformed SCRAM message"),
1031 errdetail(
"Comma expected, but found character \"%s\".",
1041 if (!
state->channel_binding_in_use)
1043 (
errcode(ERRCODE_PROTOCOL_VIOLATION),
1044 errmsg(
"malformed SCRAM message"),
1045 errdetail(
"The client selected SCRAM-SHA-256 without channel binding, but the SCRAM message includes channel binding data.")));
1053 if (strcmp(channel_binding_type,
"tls-server-end-point") != 0)
1055 (
errcode(ERRCODE_PROTOCOL_VIOLATION),
1056 errmsg(
"unsupported SCRAM channel-binding type \"%s\"",
1061 (
errcode(ERRCODE_PROTOCOL_VIOLATION),
1062 errmsg(
"malformed SCRAM message"),
1063 errdetail(
"Unexpected channel-binding flag \"%s\".",
1072 (
errcode(ERRCODE_FEATURE_NOT_SUPPORTED),
1073 errmsg(
"client uses authorization identity, but it is not supported")));
1076 (
errcode(ERRCODE_PROTOCOL_VIOLATION),
1077 errmsg(
"malformed SCRAM message"),
1078 errdetail(
"Unexpected attribute \"%s\" in client-first-message.",
1093 (
errcode(ERRCODE_FEATURE_NOT_SUPPORTED),
1094 errmsg(
"client requires an unsupported SCRAM extension")));
1107 (
errcode(ERRCODE_PROTOCOL_VIOLATION),
1108 errmsg(
"non-printable characters in SCRAM nonce")));
1127 int client_nonce_len = strlen(
state->client_nonce);
1128 int server_nonce_len = strlen(
state->server_nonce);
1129 int final_nonce_len = strlen(
state->client_final_nonce);
1131 if (final_nonce_len != client_nonce_len + server_nonce_len)
1133 if (memcmp(
state->client_final_nonce,
state->client_nonce, client_nonce_len) != 0)
1135 if (memcmp(
state->client_final_nonce + client_nonce_len,
state->server_nonce, server_nonce_len) != 0)
1153 const char *errstr = NULL;
1163 strlen(
state->client_first_message_bare)) < 0 ||
1167 strlen(
state->server_first_message)) < 0 ||
1170 (
uint8 *)
state->client_final_message_without_proof,
1171 strlen(
state->client_final_message_without_proof)) < 0 ||
1174 elog(
ERROR,
"could not calculate client signature: %s",
1181 for (
i = 0;
i <
state->key_length;
i++)
1182 state->ClientKey[
i] =
state->ClientProof[
i] ^ ClientSignature[
i];
1186 client_StoredKey, &errstr) < 0)
1187 elog(
ERROR,
"could not hash stored key: %s", errstr);
1189 if (memcmp(client_StoredKey,
state->StoredKey,
state->key_length) != 0)
1237 (
errcode(ERRCODE_INTERNAL_ERROR),
1238 errmsg(
"could not generate random nonce")));
1244 state->server_nonce, encoded_len);
1245 if (encoded_len < 0)
1247 (
errcode(ERRCODE_INTERNAL_ERROR),
1248 errmsg(
"could not encode random nonce")));
1249 state->server_nonce[encoded_len] =
'\0';
1251 state->server_first_message =
1267 char *channel_binding;
1272 uint8 *client_proof;
1273 int client_proof_len;
1311 if (
state->channel_binding_in_use)
1314 const char *cbind_data = NULL;
1315 size_t cbind_data_len = 0;
1316 size_t cbind_header_len;
1318 size_t cbind_input_len;
1320 int b64_message_len;
1329 if (cbind_data == NULL || cbind_data_len == 0)
1330 elog(
ERROR,
"could not get server certificate hash");
1332 cbind_header_len = strlen(
"p=tls-server-end-point,,");
1333 cbind_input_len = cbind_header_len + cbind_data_len;
1334 cbind_input =
palloc(cbind_input_len);
1335 snprintf(cbind_input, cbind_input_len,
"p=tls-server-end-point,,");
1336 memcpy(cbind_input + cbind_header_len, cbind_data, cbind_data_len);
1340 b64_message =
palloc(b64_message_len + 1);
1342 b64_message, b64_message_len);
1343 if (b64_message_len < 0)
1344 elog(
ERROR,
"could not encode channel binding data");
1345 b64_message[b64_message_len] =
'\0';
1351 if (strcmp(channel_binding, b64_message) != 0)
1353 (
errcode(ERRCODE_INVALID_AUTHORIZATION_SPECIFICATION),
1354 errmsg(
"SCRAM channel binding check failed")));
1357 elog(
ERROR,
"channel binding not supported by this build");
1368 if (!(strcmp(channel_binding,
"biws") == 0 &&
state->cbind_flag ==
'n') &&
1369 !(strcmp(channel_binding,
"eSws") == 0 &&
state->cbind_flag ==
'y'))
1371 (
errcode(ERRCODE_PROTOCOL_VIOLATION),
1372 errmsg(
"unexpected SCRAM channel-binding attribute in client-final-message")));
1382 }
while (attr !=
'p');
1385 client_proof =
palloc(client_proof_len);
1387 client_proof_len) !=
state->key_length)
1389 (
errcode(ERRCODE_PROTOCOL_VIOLATION),
1390 errmsg(
"malformed SCRAM message"),
1391 errdetail(
"Malformed proof in client-final-message.")));
1392 memcpy(
state->ClientProof, client_proof,
state->key_length);
1393 pfree(client_proof);
1397 (
errcode(ERRCODE_PROTOCOL_VIOLATION),
1398 errmsg(
"malformed SCRAM message"),
1399 errdetail(
"Garbage found at the end of client-final-message.")));
1401 state->client_final_message_without_proof =
palloc(proof - begin + 1);
1402 memcpy(
state->client_final_message_without_proof,
input, proof - begin);
1403 state->client_final_message_without_proof[proof - begin] =
'\0';
1413 char *server_signature_base64;
1421 strlen(
state->client_first_message_bare)) < 0 ||
1425 strlen(
state->server_first_message)) < 0 ||
1428 (
uint8 *)
state->client_final_message_without_proof,
1429 strlen(
state->client_final_message_without_proof)) < 0 ||
1432 elog(
ERROR,
"could not calculate server signature: %s",
1440 server_signature_base64 =
palloc(siglen + 1);
1442 state->key_length, server_signature_base64,
1445 elog(
ERROR,
"could not encode server signature");
1446 server_signature_base64[siglen] =
'\0';
1459 return psprintf(
"v=%s", server_signature_base64);
1483 "salt length greater than SHA256 digest length");
static void * scram_init(Port *port, const char *selected_mech, const char *shadow_pass)
static char * build_server_first_message(scram_state *state)
const pg_be_sasl_mech pg_be_scram_mech
static void read_client_first_message(scram_state *state, const char *input)
bool parse_scram_secret(const char *secret, int *iterations, pg_cryptohash_type *hash_type, int *key_length, char **salt, uint8 *stored_key, uint8 *server_key)
static bool verify_client_proof(scram_state *state)
static bool verify_final_nonce(scram_state *state)
static char * sanitize_str(const char *s)
char * pg_be_scram_build_secret(const char *password)
static int scram_exchange(void *opaq, const char *input, int inputlen, char **output, int *outputlen, const char **logdetail)
static bool is_scram_printable(char *p)
static char * sanitize_char(char c)
bool scram_verify_plain_password(const char *username, const char *password, const char *secret)
static char * read_attr_value(char **input, char attr)
static void read_client_final_message(scram_state *state, const char *input)
static void mock_scram_secret(const char *username, pg_cryptohash_type *hash_type, int *iterations, int *key_length, char **salt, uint8 *stored_key, uint8 *server_key)
static char * read_any_attr(char **input, char *attr_p)
static char * build_server_final_message(scram_state *state)
static void scram_get_mechanisms(Port *port, StringInfo buf)
int scram_sha_256_iterations
static uint8 * scram_mock_salt(const char *username, pg_cryptohash_type hash_type, int key_length)
int pg_b64_enc_len(int srclen)
int pg_b64_encode(const uint8 *src, int len, char *dst, int dstlen)
int pg_b64_dec_len(int srclen)
int pg_b64_decode(const char *src, int len, uint8 *dst, int dstlen)
char * be_tls_get_certificate_hash(Port *port, size_t *len)
#define StaticAssertDecl(condition, errmessage)
PasswordType get_password_type(const char *shadow_pass)
@ PASSWORD_TYPE_SCRAM_SHA_256
int pg_cryptohash_update(pg_cryptohash_ctx *ctx, const uint8 *data, size_t len)
pg_cryptohash_ctx * pg_cryptohash_create(pg_cryptohash_type type)
int pg_cryptohash_init(pg_cryptohash_ctx *ctx)
void pg_cryptohash_free(pg_cryptohash_ctx *ctx)
int pg_cryptohash_final(pg_cryptohash_ctx *ctx, uint8 *dest, size_t len)
int errdetail(const char *fmt,...)
int errcode(int sqlerrcode)
int errmsg(const char *fmt,...)
#define ereport(elevel,...)
Assert(PointerIsAligned(start, uint64))
pg_hmac_ctx * pg_hmac_create(pg_cryptohash_type type)
void pg_hmac_free(pg_hmac_ctx *ctx)
const char * pg_hmac_error(pg_hmac_ctx *ctx)
int pg_hmac_update(pg_hmac_ctx *ctx, const uint8 *data, size_t len)
int pg_hmac_init(pg_hmac_ctx *ctx, const uint8 *key, size_t len)
int pg_hmac_final(pg_hmac_ctx *ctx, uint8 *dest, size_t len)
if(TABLE==NULL||TABLE_index==NULL)
char * pstrdup(const char *in)
void pfree(void *pointer)
void * palloc0(Size size)
#define MOCK_AUTH_NONCE_LEN
char * strsep(char **stringp, const char *delim)
bool pg_strong_random(void *buf, size_t len)
char * psprintf(const char *fmt,...)
#define PG_MAX_SASL_MESSAGE_LENGTH
#define PG_SASL_EXCHANGE_FAILURE
#define PG_SASL_EXCHANGE_CONTINUE
#define PG_SASL_EXCHANGE_SUCCESS
pg_saslprep_rc pg_saslprep(const char *input, char **output)
int scram_ServerKey(const uint8 *salted_password, pg_cryptohash_type hash_type, int key_length, uint8 *result, const char **errstr)
int scram_SaltedPassword(const char *password, pg_cryptohash_type hash_type, int key_length, const uint8 *salt, int saltlen, int iterations, uint8 *result, const char **errstr)
char * scram_build_secret(pg_cryptohash_type hash_type, int key_length, const uint8 *salt, int saltlen, int iterations, const char *password, const char **errstr)
int scram_H(const uint8 *input, pg_cryptohash_type hash_type, int key_length, uint8 *result, const char **errstr)
#define SCRAM_SHA_256_PLUS_NAME
#define SCRAM_SHA_256_NAME
#define SCRAM_RAW_NONCE_LEN
#define SCRAM_DEFAULT_SALT_LEN
#define SCRAM_MAX_KEY_LEN
#define SCRAM_SHA_256_KEY_LEN
#define SCRAM_SHA_256_DEFAULT_ITERATIONS
#define PG_SHA256_DIGEST_LENGTH
void appendStringInfoString(StringInfo str, const char *s)
void appendStringInfoChar(StringInfo str, char ch)
uint8 scram_ServerKey[SCRAM_MAX_KEY_LEN]
uint8 scram_ClientKey[SCRAM_MAX_KEY_LEN]
char * client_final_nonce
char * client_first_message_bare
char * client_final_message_without_proof
char * server_first_message
bool channel_binding_in_use
pg_cryptohash_type hash_type
char * GetMockAuthenticationNonce(void)