$app = new \Espo\Core\Application();
$config = $app->getContainer()->get('config');
$entityManager = $app->getContainer()->get('entityManager');
$user = $entityManager->getEntity('User', 'system');
$entityManager->setUser($user);
echo "User name is " . $user->get('name') . "\n";
$app->getContainer()->setUser($user);
$upgradeManager = new \Espo\Core\UpgradeManager($app->getContainer());
class AfterUpgrade
{
public function run($container)
{
$entityManager = $container->get('entityManager');
$config = $container->get('config');
function mcryptDecryptOld($encryptedString, $key) {
$encryptedString = base64_decode($encryptedString);
$string = substr($encryptedString, 0, strlen($encryptedString) - 16);
$iv = substr($encryptedString, -16);
return trim(mcrypt_decrypt(MCRYPT_RIJNDAEL_128, $key, $string, MCRYPT_MODE_CBC, $iv));
}
function mcryptEncrypt($string, $key, $iv) {
$block = mcrypt_get_block_size(MCRYPT_RIJNDAEL_128, 'cbc');
$pad = $block - (strlen($string) % $block);
$string .= str_repeat(chr($pad), $pad);
return base64_encode(mcrypt_encrypt(MCRYPT_RIJNDAEL_128, $key, $string, MCRYPT_MODE_CBC, $iv) . $iv);
}
function opensslDecrypt($encryptedString, $key) {
$encryptedString = base64_decode($encryptedString);
$string = substr($encryptedString, 0, strlen($encryptedString) - 16);
$iv = substr($encryptedString, -16);
return trim(openssl_decrypt($string, 'aes-256-cbc', $key, OPENSSL_RAW_DATA, $iv));
}
function mcryptDecrypt($encryptedString, $key) {
$encryptedString = base64_decode($encryptedString);
$string = substr($encryptedString, 0, strlen($encryptedString) - 16);
$iv = substr($encryptedString, -16);
$string = mcrypt_decrypt(MCRYPT_RIJNDAEL_128, $key, $string, MCRYPT_MODE_CBC, $iv);
$block = mcrypt_get_block_size(MCRYPT_RIJNDAEL_128, 'cbc');
$len = strlen($string);
$pad = ord($string[$len - 1]);
return substr($string, 0, strlen($string) - $pad);
}
$iv = mcrypt_create_iv(16, MCRYPT_RAND);
$cryptKey = $config->get('cryptKey');
if (!$cryptKey) {
$newCryptKey = md5(uniqid());
$config->set('cryptKey', $newCryptKey);
$config->save();
} else {
$newCryptKey = $cryptKey;
}
$key = hash('sha256', $cryptKey, true);
$newKey = hash('sha256', $newCryptKey, true);
foreach ($entityManager->getRepository('EmailAccount')->find() as $entity) {
foreach (['password', 'smtpPassword'] as $attribute) {
$value = $entity->get($attribute);
if (empty($value)) continue;
$valueDecrypted = mcryptDecryptOld($value, $key);
$valueEncrypted = mcryptEncrypt($valueDecrypted, $newKey, $iv);
$entity->set($attribute, $valueEncrypted);
}
$entityManager->saveEntity($entity);
}
foreach ($entityManager->getRepository('InboundEmail')->find() as $entity) {
foreach (['password'] as $attribute) {
$value = $entity->get($attribute);
if (empty($value)) continue;
$valueDecrypted = mcryptDecryptOld($value, $key);
$valueEncrypted = mcryptEncrypt($valueDecrypted, $newKey, $iv);
$entity->set($attribute, $valueEncrypted);
}
$entityManager->saveEntity($entity);
}
foreach ($entityManager->getRepository('User')->find() as $user) {
$entity = $entityManager->getEntity('Preferences', $user->id);
if (!$entity) continue;
foreach (['smtpPassword'] as $attribute) {
$value = $entity->get($attribute);
if (empty($value)) continue;
$valueDecrypted = mcryptDecryptOld($value, $key);
$valueEncrypted = mcryptEncrypt($valueDecrypted, $newKey, $iv);
$entity->set($attribute, $valueEncrypted);
}
$entityManager->saveEntity($entity);
}
}
}
Leave a comment: