CyberRota Analysis
AI-GeneratedPostgreSQL versions prior to 18.5, 17.11, 16.15, 15.19, and 14.24 are vulnerable due to cleartext storage of data when using certain disabled ciphers in the pgcrypto module, which can lead to the recovery of plaintext data through direct observation of ciphertext. The impact includes the potential exposure of sensitive information, as decryption may succeed even with incorrect keys, undermining the integrity of the Modification Detection Code (MDC). Organizations utilizing affected PostgreSQL versions, particularly those handling sensitive encrypted data, should prioritize remediation to mitigate the risk of data exposure.
Original NVD Description
Cleartext storage in PostgreSQL pgcrypto disabled ciphers allows a user to recover cleartext, via direct observation of the faulty ciphertext. The OpenSSL version and OpenSSL configuration determine the disabled ciphers. If the application accepts encrypted data as input, decryption will succeed even with the wrong key. This in turn loses the modest protection from the Modification Detection Code (MDC). Affected functions are pgp_sym_encrypt, pgp_sym_decrypt, pgp_pub_encrypt, pgp_pub_decrypt, pgp_sym_encrypt_bytea, pgp_sym_decrypt_bytea, pgp_pub_encrypt_bytea, and pgp_pub_decrypt_bytea. Versions before PostgreSQL 18.5, 17.11, 16.15, 15.19, and 14.24 are affected.