Encrypted database

[mhanu]

Good morning.
Is it possible to work with SC and a Mysql Encrypted database? Does encryption take place at the DB level or at the application level?
What are the impacts of such a scenario in terms of backup and usage?
Is it necessary to configure the database encryption key for every application of the project?
I’m sorry but I haven’t addressed this topic yet
Thanks

[jlboutin60]

Just encrypt the sensitive data

Encryption data?

To work with a form or grid you need to have 2 fields for the encrypted DATA. One plain field and one encrypted field set by default to ‘’. You set up the form using the normal field and hide the encrypted field. When you insert the data, the normal field will contain the plain info. In the onAfterInsert or onAfterUpdate event you do an update of your info $SQL = "UPDATE table SET encryptfield = AES_ENCRYPT({field}, UNHEX(SHA2('My secret passphrase',512))), field = '' WHERE ID = {ID}"; sc_ex…

[aducom]

The idea is that if the database get stolen, nobody can decrypt the data. You can transparent encrypt MySQL or mariadb. You have to work with private and public key and it is not hard to find tutorials to do so. I used maria and the database driver does all the work for you. Disadvantage is that if your server gets hacked, the hacker might gain access as the private key is on the server. But if he steals the db then he cannot decrypt. Security is a difficult matter. Encrypting on field level generates issus wit queries, report generators etc. No solution is perfect and perhaps you need both.

[mhanu]

I know i really would not whant to do it because of problems that can arise.

is this setting the one to fill?

Thank you

[mhanu]

@Encryption data?

UNHEX(SHA2('My s

Thank you sir. i guess using sc_encode, sc_decode is a different matter since it is encoding and not encrypting. By the way is it possible to know what algorithm uses the sc_encode macro?