L le_toubib Active Member Licensed User Longtime User May 28, 2016 #1 hi all i connect to a mysql db with a b4x <-> php <-> mysql i encrypted the passwords columns using the mysql function PASSWORD(`column`) while i can receive the row password in a post string and encrypt it in the SQL string inside the php b4 validation , but i would like to encrypt it in b4j b4 sending it to php ... how to encrypt it in b4j .. which library to use and which protocol to fit with the mysql PASSWORD function?
hi all i connect to a mysql db with a b4x <-> php <-> mysql i encrypted the passwords columns using the mysql function PASSWORD(`column`) while i can receive the row password in a post string and encrypt it in the SQL string inside the php b4 validation , but i would like to encrypt it in b4j b4 sending it to php ... how to encrypt it in b4j .. which library to use and which protocol to fit with the mysql PASSWORD function?
Erel B4X founder Staff member Licensed User Longtime User May 29, 2016 #2 I recommend you to switch to jRDC 2 instead of the PHP script. It will be more powerful and more secure. Based on the MySQL documentation you shouldn't use PASSWORD: http://dev.mysql.com/doc/refman/5.7/en/encryption-functions.html#function_password You can use MD5 or SHA2. You can implement these hash functions with the Encryption library. Upvote 0
I recommend you to switch to jRDC 2 instead of the PHP script. It will be more powerful and more secure. Based on the MySQL documentation you shouldn't use PASSWORD: http://dev.mysql.com/doc/refman/5.7/en/encryption-functions.html#function_password You can use MD5 or SHA2. You can implement these hash functions with the Encryption library.
