Use SCRAM-SHA for encrypted sessions

[Neustradamus]

Dear @ADOdb team,

Can you add supports of :

• SCRAM-SHA-1
• SCRAM-SHA-1-PLUS
• SCRAM-SHA-256
• SCRAM-SHA-256-PLUS
• SCRAM-SHA-512
• SCRAM-SHA-512-PLUS
• SCRAM-SHA3-512
• SCRAM-SHA3-512-PLUS

You can add too:

• SCRAM-SHA-224
• SCRAM-SHA-224-PLUS
• SCRAM-SHA-384
• SCRAM-SHA-384-PLUS

A "big" list has been done in last link of this ticket.

---

SCRAM-SHA-1(-PLUS):

• https://tools.ietf.org/html/rfc5802
• https://tools.ietf.org/html/rfc6120

SCRAM-SHA-256(-PLUS):

• https://tools.ietf.org/html/rfc7677 since 2015-11-02
• https://tools.ietf.org/html/rfc8600 since 2019-06-21: https://mailarchive.ietf.org/arch/msg/ietf-announce/suJMmeMhuAOmGn_PJYgX5Vm8lNA

SCRAM-SHA-512(-PLUS):

• https://tools.ietf.org/html/draft-melnikov-scram-sha-512

SCRAM-SHA3-512(-PLUS):

• https://tools.ietf.org/html/draft-melnikov-scram-sha3-512

SCRAM BIS: Salted Challenge Response Authentication Mechanism (SCRAM) SASL and GSS-API Mechanisms:

• https://tools.ietf.org/html/draft-melnikov-scram-bis

-PLUS variants:

• RFC5056: On the Use of Channel Bindings to Secure Channels: https://tools.ietf.org/html/rfc5056
• RFC5929: Channel Bindings for TLS: https://tools.ietf.org/html/rfc5929
• Channel-Binding Types: https://www.iana.org/assignments/channel-binding-types/channel-binding-types.xhtml
• RFC9266: Channel Bindings for TLS 1.3: https://tools.ietf.org/html/rfc9266

IMAP:

• RFC9051: Internet Message Access Protocol (IMAP) - Version 4rev2: https://tools.ietf.org/html/rfc9051

LDAP:

• RFC5803: Lightweight Directory Access Protocol (LDAP) Schema for Storing Salted: Challenge Response Authentication Mechanism (SCRAM) Secrets: https://tools.ietf.org/html/rfc5803

HTTP:

• RFC7804: Salted Challenge Response HTTP Authentication Mechanism: https://tools.ietf.org/html/rfc7804

JMAP:

• RFC8621: The JSON Meta Application Protocol (JMAP) for Mail: https://tools.ietf.org/html/rfc8621

2FA:

• Extensions to Salted Challenge Response (SCRAM) for 2 factor authentication: https://tools.ietf.org/html/draft-melnikov-scram-2fa

IANA:

• Simple Authentication and Security Layer (SASL) Mechanisms: https://www.iana.org/assignments/sasl-mechanisms/sasl-mechanisms.xhtml

Linked to:

• State of Play scram-sasl/info#1

[dregad]

@Neustradamus I'm sorry but I really don't know what this is all about, and what it has to do with ADOdb. Please clarify your expectations.

Also kindly note that ADOdb is community-maintained so if you wish some feature to be added, then we expect a contribution in the form of a pull request rather than al list of RFC's with no actual specification of how they should be applied to our library.

[Neustradamus]

@dregad: The goal is to have salted password hashes to be more secure and to be compatible with other products/softwares in the World since 2011. It replaces old unsecure MD5...

[dregad]

That does not quite explain how this would apply to ADOdb... We are just an abstraction layer on top of various databases, and we don't store any passwords - we just pass them on to the underlying DB.

[Neustradamus]

@dregad: The goal is to have a better security than unsecure "ADODB_Encrypt_MD5" and "ADODB_Encrypt_SHA1", etc.:

• https://github.com/search?q=repo%3AADOdb%2FADOdb+md5&type=code
• https://github.com/search?q=repo%3AADOdb%2FADOdb+sha1&type=code

[dregad]

OK I see what you mean now, it's related to sessions module.

As mentioned previously, feel free to submit a pull request with new encryption classes using your better algorithm to replace the legacy MD5 / SHA1.