B4J Question b4xencryption

L

le_toubib

Active Member
Licensed User
Longtime User
hi all
in mysql i encrypted a field using the sql :
UPDATE `TABLE` SET `FIELD1` = AES_ENCRYPT(`FIELD2`,'PASSWORD123456')
Click to expand...
(both fields are varchar(100))

I fetched data using php json encode
in b4j i tryed to decrypt using the code :
B4X: 
Sub decrypt (s As String) As String
    Dim su As StringUtils
            Dim Cipher As B4XCipher
             Dim bc As ByteConverter   
   s=bc.StringFromBytes(Cipher.Decrypt(s.GetBytes("UTF8"), "PASSWORD123456"),"UTF8")
   Return s
End Sub

but i get the error :
what am i missing ?
 
Sort by date Sort by votes

EnriqueGonzalez

Well-Known Member
Licensed User
Longtime User
It is only part of the answer but. s.getBytes() is not enough. you must decode it with base64 like this.

B4X: 
Dim byt() As Byte = SU.DecodeBase64(text)
    Dim bytEn() As Byte = Cipher.Decrypt(byt,"PASSWORD123456")
    Return BytesToString(bytEn,0,bytEn.Length,"UTF-8")
 
Upvote 0
L

le_toubib

Active Member
Licensed User
Longtime User
Thanks for reply ...
Should I encode it in base64 in mysql as well ?
 
Upvote 0

EnriqueGonzalez

Well-Known Member
Licensed User
Longtime User
That is why i said that it was a partial answer. i know that for encryption to work FROM and TO B4x, you should use base64, but i do not know if this line is already doing it.

AES_ENCRYPT(`FIELD2`,'PASSWORD123456')
 
Upvote 0
L

le_toubib

Active Member
Licensed User
Longtime User
Enrique Gonzalez R said:
That is why i said that it was a partial answer. i know that for encryption to work FROM and TO B4x, you should use base64, but i do not know if this line is already doing it.

AES_ENCRYPT(`FIELD2`,'PASSWORD123456')
Click to expand...
I used
B4X: 
  Update table SET `FIELD 1` = TO_BASE64 (AES_ENCRYPT(`FIELD2`,'PASSWORD123456'))
In mysql . But still some result ..
 
Upvote 0
You must log in or register to reply here.

Similar Threads

W
  • Question
Android Question [B4X] B4XEncryption not working
Replies
2
Views
823
WhiteWizard
W
  • Question
B4J Question [ B4XEncryption ] Problem with password size
Replies
1
Views
735
drgottjr
  • Question
B4J Question [ B4XEncryption ] Problem in Encrypt
Replies
2
Views
825
Waldemar Lima
A
  • Question
B4J Question B4XEncryption Decryption help needed [Solved]
Replies
3
Views
2K
Anser
A
  • Article
B4J Library jB4XEncryption
2
Replies
21
Views
14K
Shalu Samtani
Menu
Log in
Register
Cookies are required to use this site. You must accept them to continue using the site. Learn more…