Author Topic: How do I anonymize my database to share with other developers? (Read 447 times)

Sean Madsen · May 27, 2014, 09:08:50 am

I've heard that I can use a tool within Civi to anonymize the data within my database so that it's safe to share with other developers for testing purposes. How can I do this? I know there is a PHP file here: <civi_root>/bin/encryptDB.php but when I try to execute it from the command line or visit the URL with a browser, I get the following error:

ERROR: You need to send a valid user name and password to execute this file

mathieu · May 27, 2014, 03:41:36 pm

IMPORTANT: encryptDB will hash most of the sensitive data in your database (contact names, phones, addresses, etc). Never run this on your production site. Run it on a copy. The operation cannot be reversed.

You need to pass the arguments for the username/password and site key.

For example:

http://example.org/path/to/civicrm/bin/encryptDB.php?user=[...]&pass=[...]&key=[sitekey]

The site key can be found in your civicrm.settings.php (if you are using Drupal, it is in sites/example.org/civicrm.settings.php, or in sites/default/civicrm.settings.php.

The username and password should be the one for an admin account. It might work with any account, but that's why it requires the "site key", which must remain secret

CiviCRM Community Forums (archive)

News:

Author Topic: How do I anonymize my database to share with other developers? (Read 447 times)

Sean Madsen

How do I anonymize my database to share with other developers?

mathieu

Re: How do I anonymize my database to share with other developers?