On 3 Mar 2009, at 10:37, Ram wrote:
>
> 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")
>
Watch out for the type of the column you are storing the data in - if
it is a text column with encoding utf8 mysql will truncate if it
encounters an invalid utf8 sequence.
Fred
> #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:in `final'
> from /Users/fire/Sites/Vinay/ROR/RealApps/fi_rest_auth/config/
> initializers/aes_crypt.rb:20:in `decrypt'
> from (irb):3
>>> y = 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!
>
>
> >
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Ruby
on Rails: Talk" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---
