Hi guys,
I’m trying to decrypt all files for user (ABC) on a hoster based NV 9.0.51 system (All-INKL) w/ PHP 7.01
Unfortunately the decryption process never comes to a defined end but gets interrupted by PHP errors
like:
PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 81 bytes) in /www/htdocs
/w005850c/wwwcloud/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php on line 128
or:
Doctrine\DBAL\Exception\DriverException]
An exception occurred while executing ‘UPDATE ZIuXd_appconfig
SET configvalue
= ? WHERE (appid
= ?) AND (configkey
=
?) AND (configvalue
<> ?)’ with params [“yes”, “core”, “encryption_enabled”, “yes”]:
SQLSTATE[HY000]: General error: 2006 MySQL server has gone away
[Doctrine\DBAL\Driver\PDOException]
SQLSTATE[HY000]: General error: 2006 MySQL server has gone away
[PDOException]
SQLSTATE[HY000]: General error: 2006 MySQL server has gone away
It seems, when observing the /data directory for the specified user (ABC), that most, if not all files have successfully been decrypted already… but after a couple of tries I have also a couple of decrypted files for each encrypted one in that directory (see below)
occ command chain:
php occ maintenance:singleuser --on
php occ encryption:enable
php occ encryption:decrypt-all ABC
decrypt files for user ABC (1 of 1): /o815/files/XX__IMG3537.jpg
decrypt files for user ABC (1 of 1): /o815/files/XX/__IMG3537.jpg.decrypted.1475774188
decrypt files for user ABC (1 of 1): /o815/files/XX/__IMG3537.jpg.decrypted.1475775536
ecrypt files for user ABC (1 of 1): /o815/files/XX/__IMG3537.jpg.decrypted.1475781045
How shall I deal with this ??
- The effect of course is also that I’m reaching my storage maximum this way… I actually quadrupelled the amout of used storage by three tries of decryption so far…
Can I delete manually through FTPing and DELETING into the /data directory ??
- if YES, Which files should I delete manually ?? the encrypted or all decrypted versions ??
- if NO, same question for the WebGUI …which files to delete
I assume that, if the decryption would have finished “normally” without errors, the script would have automatically replaced the formerly encrypted files with the decrypted files… and deleted all -in between files- CORRECT ??
Any other hints ??
Besides:
-
when FTP downloading some files (jpgs) directly from the /data directory, I can confirm that all “marked decrypted” files have been correctly decrypted and can be opened without issue
-
when viewing the files through the WebGui, all file versions, original encrypted and all decrypted ones are visible, but only the original encrypted can be opened and viewed (jpg)
Thank’s for any support and/or hints in this matter…
Oliver