RC6 - New encrypt option for Sqlite DB: SqlCipher

[tmighty2]

Dear Olaf,

we are currently working on manually decrypting database files where the cConnection.CodecType is set to CODEC_TYPE_AES256. To ensure that our approach aligns correctly with the encryption mechanisms used, we need to confirm the exact encryption parameters.

Could you please provide the values or confirm if the following details are correct for this encryption type?

(Javascript)

let salt = data.slice(0, 16);
let iv = data.slice(16, 32);
let encrypted = data.slice(32);

keySize: 256 / 8,
iterations: 256000

Additionally, if possible, could you share a snippet of the encryption code, similar to this example, to ensure we are implementing the decryption process correctly?

function decodeAes(pass, data) {
    let salt = data.slice(0, 16);
    let iv = data.slice(16, 32);
    let encrypted = data.slice(32);

    let key = CryptoJS.PBKDF2(pass, CryptoJS.enc.Hex.parse(salt.toString('hex')), {
        keySize: 256 / 8,
        iterations: 256000
    });

    let decrypted = CryptoJS.AES.decrypt(
        {
            ciphertext: CryptoJS.enc.Hex.parse(encrypted.toString('hex'))
        },
        key,
        {
            iv: CryptoJS.enc.Hex.parse(iv.toString('hex')),
            padding: CryptoJS.pad.Pkcs7,
            mode: CryptoJS.mode.CBC
        }
    );
    return Buffer.from(decrypted.toString(CryptoJS.enc.Latin1), 'latin1');
}

This information is crucial for ensuring compatibility and maintaining the high security standards of our application. Your assistance in this matter would be greatly appreciated.