AES_DECRYPTION on nodejs

Viewed 133

I created sample test table with aes encryption 256 bit, my steps as below description.

SET @@session.block_encryption_mode = 'aes-256-ecb';

Insert data

INSERT INTO test_aes ( des_one, des_two ) 
values ( aes_encrypt('react', 'key'), aes_encrypt('china', 'key'));

View data from below query

SELECT CAST(AES_DECRYPT(des_one, 'key') as char) as des_one, 
CAST(AES_DECRYPT(des_two, 'key') as char) as des_two from test_aes;

Then I created nodejs project and added sequelize. My issue is I can successfully retrieve data by executing select query, but in nodejs project I retrieved data as null values.

Nodejs code

const encryptTwo = await sequelize.query( "SELECT CAST(AES_DECRYPT(des_one, 'key') as char) 
 as des_one from test_aes;" );
console.log('encryptTwo', encryptTwo[0]);

What I am missing,

Even tried with below link scenarios MySql WorkBench AES 256 Decryption

Same issue happening. Any suggestions ? Thank you

0 Answers
Related