2. PHPRunner General questions
  3. [SOLVED]  phprunner 6.1 data decryption
This topic is locked
[SOLVED]

 phprunner 6.1 data decryption

 		4/2/2012 3:37:25 AM
PHPRunner General questions
F
 Francesco_5000 author

hi,
for security reasons I've encrypted all the fields of a table, now I need the the values of the fields unencrypted to work with them in an event. The encryption method that I've choose is database-based so I'm wondering if this post: http://www.asprunner.com/forums/topic/15692-encrypt-and-decrypt-data-in-the-database-with-phprunner-5-3/ is still valid, if yes I will use the function described in: "Scenario 2. Using MySQL functions" .
F
 		Francesco_5000 author 4/3/2012

well, for what I can see the method of encryption used by phprunner is not AES, infact this code don't works:



$key="my_key";

$sql1 = "SELECT AES_DECRYPT(grey_field, ".$key.") as white_field

FROM table";


I've also tried to use the code alternative,



function decrypt($alpha)

{

global $encryption_key;

if(function_exists("mcrypt_ecb"))

{

$temp = mcrypt_ecb(MCRYPT_3DES, $encryption_key, $alpha, MCRYPT_DECRYPT);

return rtrim($temp, "\0");

}

else return $alpha;

}


but the decryption fails, so I have to ask here what is the method of encryption natively supported from the software.
Sergey Kornilov admin 4/5/2012

I recommend to post your application to Demo Account and to contact support team directly. Once we see how encryption is configured in your project we can help you with decryption.