Mysql Pem

Support
1

Hi,
This could be beyond the scope of this forum but just in-case someone has
got over the same problem
I used openSSL to create public and private keys for my form encryption.

  • this works fine all submitted data in MySQL is encrypted
    I can download data using briefcase after providing the decryption key
    (PEM).

Problem;
I sometimes need to edit my data that is still in MySQL (Data error
correction) e.g change value of age from 36 to 63. However because my data
in MySQL is encrypted I can not edit.
How do I decrypt the data whilst in MySQL.

Thankx

2

Ayoub,

The XML of the submission is encrypted all at once so you'd have to
grab that entire blob, decrypt it, find the right field, change value,
re-encrypt the entire blob and write to the database.

I bet this is technically possible
(https://dev.mysql.com/doc/refman/5.6/en/enterprise-encryption-functions.html#function_asymmetric-decrypt),
but seems very painful. Either don't use form encryption or do the
edits after export and decryption.

Yaw

ยทยทยท -- Need ODK services? http://nafundi.com provides form design, server setup, professional support, and software development for ODK.

On Mon, Sep 7, 2015 at 8:43 AM, Ayoub Kakande akakande@gmail.com wrote:

Hi,
This could be beyond the scope of this forum but just in-case someone has
got over the same problem
I used openSSL to create public and private keys for my form encryption. -
this works fine all submitted data in MySQL is encrypted
I can download data using briefcase after providing the decryption key
(PEM).

Problem;
I sometimes need to edit my data that is still in MySQL (Data error
correction) e.g change value of age from 36 to 63. However because my data
in MySQL is encrypted I can not edit.
How do I decrypt the data whilst in MySQL.

Thankx

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

You received this message because you are subscribed to the Google Groups
"ODK Community" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.