Im trying to encrypt a string and store it in the DB. But there seems
to be some interpretation problems both in Ruby and in MySQL. Here’s
what Ive tried and the results… (the data to be encrypted is the
string “1231821029”)
#Crypt MODULE has
def AESCrypt.decrypt(encrypted_data, key, iv, cipher_type=“aes-256-
cbc”)
aes = OpenSSL::Cipher::Cipher.new(cipher_type)
aes.decrypt
aes.key = key
aes.iv = iv if iv != nil
aes.update(encrypted_data) + aes.final
end
def AESCrypt.encrypt(data, key, iv, cipher_type=“aes-256-cbc”)
aes = OpenSSL::Cipher::Cipher.new(cipher_type)
aes.encrypt
aes.key = key
aes.iv = iv if iv != nil
aes.update(data) + aes.final
end
#Raising the encrypted data after form submit and before save in yaml
format
“\x8E\xEDP\xB4&U\xA6\xDA[\xCC\xFD\xB11m\xDB\x14”
#Console tests
x = AESCrypt.encrypt(“1231821029”, “X”*32, “I”*32)
=> “\216?P?&U\246?[??\2611m?”y = AESCrypt.decrypt("\216?P?&U\246?[??\2611m?", “X”*32, “I”*32)
OpenSSL::CipherError: wrong final block length
from /Users/fire/Sites/Vinay/ROR/RealApps/fi_rest_auth/config/
initializers/aes_crypt.rb:20:infinal' from /Users/fire/Sites/Vinay/ROR/RealApps/fi_rest_auth/config/ initializers/aes_crypt.rb:20:indecrypt’
from (irb):3y = AESCrypt.decrypt(x, “X”*32, “I”*32)
=> “1231821029”y = AESCrypt.decrypt("\x8E\xEDP\xB4&U\xA6\xDA[\xCC\xFD\xB11m\xDB\x14", “X”*32, “I”*32)
=> “1231821029” # notice the string i used here is the one i raised
before save. that too, works. although it is different from what the
console returns for the encrypt function.x
=> “\216?P?&U\246?[??\2611m?”
#Encrypted data stored in DB
??P?&U??[???1m?
even the SQL insert call has ??P?&U??[???1m? if I check the logs.
Im basically getting 3 different values at 3 different points for the
same encrypted data. ie.
before_save - “\x8E\xEDP\xB4&U\xA6\xDA[\xCC\xFD\xB11m\xDB\x14”
after_save in DB - ??P?&U??[???1m?
in the console - “\216?P?&U\246?[??\2611m?”
And when i try to decrypt using whats there in the DB, I get “bad
decrypt - wrong final block length”.
Any idea what im missing here? Ive done some serious digging and ive
hit bedrock and no water. Hoping someone here’s got the answer.
Cheers!