Zenario supports the encryption of personal data at rest, while that data is stored in Zenario's database.
All versions of Zenario support one-way encryption (also known as hashing) for passwords, for both User Accounts and Administrator Accounts.
Both kinds of passwords are hashed using an SHA256 algorithm and salted using a different randomly generated "salt" for each user account. The salt is stored in the database.
There is no way to decrypt a password field. When a user or administrator comes to log in to Zenario, the password they enter is encrypted and compared with the stored string.
If a user or administrator loses their password, Zenario cannot remind them of the stored password. It can only generate a link and send it to them by email, so that they can create a new password.
Personal data such as users' email addresses, names, addresses and other text-type fields can be encrypted using a two-way encryption method.
Zenario uses an implementation of the Defuse php-encryption library. This system is currently only make available to Tribal-hosted customers.
The encryption method used is AES256-CTR.
This can be used to encrypt the values of columns when they are saved to the database, and decrypt the values of columns on the fly when they are read from the database. We often refer to this as "two-way encryption" to distinguish this from the one-way encryption/hashing used for passwords.
When two-way encryption is enabled for a column, the decrypted value is never stored in the database. Both the encryption and the decryption of the column requires the values of two encryption keys, and the values of these keys are stored in the filesystem and not in the database.
The two-way encryption system makes encrypted strings have a many-to-one relationship with the original string. In other words, for any given original string, many encrypted strings are possible. This prevents original strings from being "guessed" from the encrypted string,
One issue is, this makes it hard to run a search in the database for rows matching some input. So for example, if you have a users table storing names in encrypted form, it is hard for an administrator to search by name. To get around this, Zenario supports a hashed — one-way encrypted — form of the data as well. Then when a search is run, the entered string is hashed at input, and the matching rows found from the hashed value rather than the two-way encrypted value.
Zenario's encryption system relies on two keys:
Data be decrypted only by possessing both keys, making it near-impossible to decrypt the data with merely a copy of the data.
Zenario's core technology allows for any text field in the database to be encrypted. We typically use it for the users table (which stores data on extranet users and contacts), and on the consents table (which stores a log of people giving their consent to have their data stored).
However, use of PDE can be much wider, and any Zenario modules or its plugins can use encryption. Thus a custom application could be made to use encryption, even if it's not strictly personal data.
The system only currently works on textual columns, and not columns that contain foreign keys, i.e. IDs of rows in other tables that are joined.