Magento encrypts the sensitive information that it stores in the database.<\/p>\n
That’s great for security, but it means if you need information that only exists as encrypted in the database, it can be hard to get to.<\/p>\n
To get the data out of there, you need to have access to the file system that runs the magento store.<\/p>\n
Step 1, get the data from the database.\u00a0 It’s stored in core_config_data.\u00a0 You can get to it through a MySQL CLI or phpmyadmin, Navicat, etc.\u00a0 The below example is to get the authorize.net api login id and transaction key.\u00a0 The same logic will work for any encrypted value in the database.<\/p>\n
SELECT value FROM core_config_data WHERE path IN (\"payment\/authorizenet\/login\", \"payment\/authorizenet\/trans_key\");<\/pre>\nThen take the values from that and put them into a file.\u00a0 The easiest way is to create a file called decrypt.php and put it at the root of the web server.\u00a0 Place this code in that file, load the page at: http:\/\/www.mystore.com\/decrypt.php and read the values.\u00a0 Then delete the file immediately.<\/p>\n
<?php\r\n\r\nrequire_once('app\/Mage.php');\r\nMage::app();\r\n\r\necho 'API Login ID: ' . Mage::helper('core')->decrypt('login id from database');\r\necho '<br \/>';\r\necho 'API Transaction Key: ' . Mage::helper('core')->decrypt('transaction key from database');<\/pre>\nLoad the page and you’ll see the values.<\/p>\n
Remember to delete the file after you’re done.<\/p>\n","protected":false},"excerpt":{"rendered":"
Magento encrypts the sensitive information that it stores in the database. That’s great for security, but it means if you need information that only exists as encrypted in the database,… Read more »<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[22,37],"tags":[],"_links":{"self":[{"href":"https:\/\/www.evermoretechnologies.com\/blog\/wp-json\/wp\/v2\/posts\/288"}],"collection":[{"href":"https:\/\/www.evermoretechnologies.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.evermoretechnologies.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.evermoretechnologies.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.evermoretechnologies.com\/blog\/wp-json\/wp\/v2\/comments?post=288"}],"version-history":[{"count":2,"href":"https:\/\/www.evermoretechnologies.com\/blog\/wp-json\/wp\/v2\/posts\/288\/revisions"}],"predecessor-version":[{"id":290,"href":"https:\/\/www.evermoretechnologies.com\/blog\/wp-json\/wp\/v2\/posts\/288\/revisions\/290"}],"wp:attachment":[{"href":"https:\/\/www.evermoretechnologies.com\/blog\/wp-json\/wp\/v2\/media?parent=288"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.evermoretechnologies.com\/blog\/wp-json\/wp\/v2\/categories?post=288"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.evermoretechnologies.com\/blog\/wp-json\/wp\/v2\/tags?post=288"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}