I Cannot login. "OCP AutoloadNotAllowedException" in "apps/files_external/lib/config.php"

My Files are disappeared, and if I enable “files_external” with occ or occ web, then the error appears again.

I think, I may mounted a location where my files resides.

With locate I found this place:

root@nextcloud:/usr/local/www/nextcloud # du -sh /usr/local/www/nextcloud/data/floogy/files/
9.5G    /usr/local/www/nextcloud/data/floogy/files/

Ooops, okay, that’s because I’m logged in as admin …

So the most is fine now.

During upgrade I had to create or extent two tables manually.

MariaDB [nextcloud]> describe oc_flow_operations_scope;
+--------------+-------------+------+-----+---------+----------------+
| Field        | Type        | Null | Key | Default | Extra          |
+--------------+-------------+------+-----+---------+----------------+
| id           | bigint(20)  | NO   | PRI | NULL    | auto_increment |
| operation_id | int(11)     | NO   | MUL | 0       |                |
| type         | int(11)     | NO   |     | 0       |                |
| value        | varchar(64) | YES  |     |         |                |
+--------------+-------------+------+-----+---------+----------------+
4 rows in set (0.01 sec)

MariaDB [nextcloud]> describe oc_flow_operations;
+-----------+--------------+------+-----+---------+----------------+
| Field     | Type         | Null | Key | Default | Extra          |
+-----------+--------------+------+-----+---------+----------------+
| id        | int(11)      | NO   | PRI | NULL    | auto_increment |
| class     | varchar(256) | NO   |     | NULL    |                |
| name      | varchar(256) | NO   |     | NULL    |                |
| checks    | longtext     | YES  |     | NULL    |                |
| operation | longtext     | YES  |     | NULL    |                |
| entity    | varchar(256) | NO   |     |         |                |
| events    | longtext     | NO   |     | NULL    |                |
+-----------+--------------+------+-----+---------+----------------+
7 rows in set (0.01 sec)

And then upgrade, check integrity and optimize db with occ.

Now there are still three issues in security & configuration

  1. [Files Integrity, I guess due to the chaotic upgrade pass] Einige Dateien haben die Integritätsprüfung nicht bestanden. Weiterführende Informationen befinden sich in unserer Dokumentation. (Liste der ungültigen Dateien… / [Erneut analysieren…]
  2. [getenv(“PATH” seems to return an empty response] PHP scheint zur Abfrage von Systemumgebungsvariablen nicht richtig eingerichtet zu sein. Der Test mit getenv(“PATH”) liefert nur eine leere Antwort zurück. Bitte die Installationsdokumentation :arrow_upper_right: auf Hinweise zur PHP-Konfiguration durchlesen sowie die PHP-Konfiguration Deines Servers überprüfen, insbesondere dann, wenn PHP-FPM eingesetzt wird.
  3. I cannot use “files_external”, because it throws the ‘Cannot login. OCP\AutoloadNotAllowedException: Autoload path not allowed: /usr/local/www/nextcloud/apps/files_external/lib/config.php’
  4. I had an error message on the header line: »Falscher privater Schlüssel für die Verschlüsselungs-App. Bitte aktualisieren Sie Ihren privaten Schlüssel in Ihren persönlichen Einstellungen um wieder Zugriff auf die verschlüsselten Dateien zu erhalten« “Invalid private key for encryption app. Please update your private key password in your personal settings to recover access to your encrypted files”
  5. There is an issue with some PDF Files for the internal Viewer.
PDF.js v2.1.266 (build: 81f5835c)
Message: Unexpected server response (503) while retrieving PDF  https://nextcloud.floogy.myhost.eu/remote.php/webdav/Nextcloud%20Manual%20(2).pdf".

1: Is it safe to delete those files?? https://pastebin.pl/view/64e13cfd

2: Strange, because it returns the $PATH

root@nextcloud:/usr/local/www/nextcloud # php -r 'print getenv("PATH") . "\n";'
/sbin:/bin:/usr/sbin:/usr/bin:/usr/local/sbin:/usr/local/bin:/root/bin

3: Anyone?

4: Falscher privater Schlüssel für die Verschlüsselungs-App. Bitte aktualisieren Sie Ihren privaten Schlüssel in Ihren persönlichen Einstellungen um wieder Zugriff auf die verschlüsselten Dateien zu erhalten
(Invalid private key for encryption app. Please update your private key password in your personal settings to recover access to your encrypted files)

root@nextcloud:/usr/local/www/nextcloud # grep '"SAMEORIGIN"' /usr/local/etc/nginx/nginx.conf
root@nextcloud:/usr/local/www/nextcloud # grep '"SAMEORIGIN"' /usr/local/etc/nginx/conf.d/nextcloud.conf
  add_header X-Frame-Options "SAMEORIGIN" always;
    add_header X-Frame-Options "SAMEORIGIN" always;
root@nextcloud:/usr/local/www/nextcloud # grep '"SAMEORIGIN"' .htaccess
    Header always set X-Frame-Options "SAMEORIGIN"

5: Seems to happen only on one particular file, maybe it’s corrupt, or to big?