Encryption allows you to encrypt important data in the database, such as credit card numbers or Social Security Numbers. You need to select the encryption method, enter the encryption key, and choose the fields to be encrypted.
Press the Encryption button on the Security screen to open the Encryption popup.
You can select a Database-based or Code-based encryption method.
The Database-based method is preferable since it has more features than the Code-based method. With the Database-based encryption, for example, the encrypted fields can be sorted and grouped, the search offers suggestions and includes all operators (CONTAINS, EQUALS, MORE THAN, etc.).
Database-based encryption requirements
•install the pgcrypto module.
•give users full rights to the SYS.DBMS_CRYPTO package;
•the Oracle version must be 10 or higher.
•enable SSL support.
Code-based encryption requirements
To use the PHP encryption, enable the mcrypt extension in php.ini (PHP 5.3 and higher includes this extension by default).
We recommend using the encryption key that is at least 10 characters long. You can also use the Generate button to generate a random key.
PHPRunner can encrypt only text fields. Since the encrypted value usually is at least 2-3 times longer than source value, you should choose the maximum length fields such as TEXT in MySQL or MEMO in MS Access.
Here is an example of encrypted data in the application:
MS SQL Server:
•Encryption: EncryptByPassPhrase(), EncryptByKey()
•Decryption: DecryptByPassPhrase(), DecryptByKey()
•Encryption: DES_ENCRYPT(), AES_ENCRYPT()
•Decryption: DES_DECRYPT(), AES_DECRYPT()
Functions used for code-based encryption
PHPRunner uses DES or AES-128 encryption algorithms.
1. Before enabling encryption export your table data to CSV or Excel
2. Turn on the encryption
3. If this table has key columns selected, simply import the data back. It will update the existing data with encrypted values.
4. If this table doesn't have key columns selected then delete all the data first and then run the import.
MySQL, AES encryption
The key variable should contain the encryption key specified in PHPRunner on the Encryption screen.
More about security: