Nextcloud Office not displaying documents

[Multipass]

Hi,

Not sure where to post this : I was loosing my mind with Nextcloud office not displaying documents. Absolutely everything seemed to be working properly and yet, I couldn’t visualize nor obviously edit or do antyhing with my documents.

I won’t describe all the rabbit holes I’ve explored, to finally realize that uBlock Origin was blocking my server domain for that specific ‘task’…

Once I added my nextcloud domain in the trusted site in uBlock, it worked.

I know, sounds so silly, noob kind of mistake, it was right in front of my eyes, and I missed it.

Just in case it help someone.

[Mornsgrans]

Because we do not know anything about your configuration, please fill the support template as you were been asked for while creating this thread.

[Multipass]

Hi,

Apologize, I deliberatly didn’t fill in the template as I think/thought it was not related to my NC config…

But you’re right, who knows…

here you go :

Here is my config :

Nextcloud version : 28.0.8.1
Operating system and version : Linux 6.6.18 aarch64
Apache or nginx version : Apache 2.4.61 (Debian)
PHP version : 8.1.28

There really was not specific error messages from nextcloud since it was in fact uBlock Origin blocking the page/process.

Here are few things that uBlock is blocking if I don’t white list my.cloud.domain

my.cloud.domain	1	post	xhr	https://my.cloud.domain/apps/text/session/486/sync
my.cloud.domain 1	post	xhr	https://my.cloud.domain/apps/text/session/486/sync
my.cloud.domain	1	post	xhr	https://my.cloud.domain/apps/notify_push/pre_auth
my.cloud.domain	1	post	xhr	https://my.cloud.domain/apps/text/session/486/push
my.cloud.domain	3	get	websocket	wss://myhostname/push/ws
my.cloud.domain	1	put	xhr	https://my.cloud.domain/ocs/v2.php/apps/user_status/api/v1/heartbeat?format=json

And one thing was in red (but not at firs, only if I waited or refreshed the page) :

||my.domain/*.php$frame -- my.cloud.domain 1 post frame https://my.cloud.domain/apps/richdocumentscode_arm64/proxy.php?req=/browser/ca2ed20/cool.html?WOPISrc=https%3A%2F%2Fedmy.cloud.domain%2Findex.php%2Fapps%2Frichdocuments%2Fwopi%2Ffiles%2F485_oczezo0o0hcf&title=%2FDocuments%2FWelcome%20to%20Nextcloud%20Hub.docx&lang=en&closebutton=1&revisionhistory=1

Voilà

[Mornsgrans]

Did you check the nextcloud.log?
In Browser under Administrative settings - Logging:

an error message like this?

[Multipass]

Like the cURL 60 issue in richdocuments ? Nope…

I had DbalException related to some dupe key for files (I cleaned trash bins, and it did the trick, at least, it seems for now).

That said I had few other ones with richdocuments :

RedisException Redis server /var/run/redis/redis.sock:0 went away
Error during app loading: Redis server /var/run/redis/redis.sock:0 went away

Exception Not enough storage → which is weird cause I have 4T HDD attached, but maybe it’s some process happening on the SD card ? (I have a SD card for the pi, and HDD attached with USB for the Data)

And WOPI request denied but I think it was when I was trying to make it work and I was trying to understand that WOPI field : I added the IP mentionned in the log, and it worked, but I have no idea what this IP is attached to (I looked and found a hostname, but I don’t know what that is, who it belongs to…)

[Mornsgrans]

So you first should repair Redis. Maybe you will find a hook here:

[SOLVED] REDIS socket issue : RedisException: Redis server went away

Nextcloud version (eg, 20.0.5): 27.0.0 Operating system and version (eg, Ubuntu 20.04): AlmaLinux release 8.8 (Sapphire Caracal) Apache or nginx version (eg, Apache 2.4.25): Apache/2.4.37 (AlmaLinux) PHP version (eg, 7.4): PHP 8.1.20 When i set up memcache with redis, web UI is not working anymore. Is this the first time you’ve seen this error? (Y/N): N Steps to replicate it: in config.php ‘memcache.local’ => ‘\OC\Memcache\APCu’, ‘filelocking.enabled’ => true, ‘memcache.distribute…

[Multipass]

Sooo… I did some tests and few improvement like updating :

sudo nano /lib/systemd/system/[apache2@.service
sudo nano /lib/systemd/system/apache2.service

Adding mysql.service in the line “After=mysql.service network.target remote-fs.target nss-lookup.target”

Per this topic Doctrine\DBAL\DBALException: Failed to connect to the database: An exception occurred in driver: SQLSTATE[HY000] [2002] No such file or directory · Issue #22119 · nextcloud/server · GitHub

Which allowed me to get rid off these errors

Doctrine\DBAL\DBALException: Failed to connect to the database: An exception occurred in driver: SQLSTATE[HY000] [2002] No such file or directory

But the Redis ones… I tried the changes in the post you sent, no luck, I looked at few other tips and tricks, did the pind / pong thing, and it’s all ok…

Everytime I reboot the server I have :

RedisException Redis server /var/run/redis/redis.sock:0 went away
RedisException read error on connection to /var/run/redis/redis.sock:0

Everything is up and running though : redis status is ok…

Any ideas ?

[Mornsgrans]

Maybe the forum-search for the Redis error message might help:
https://help.nextcloud.com/search?q=RedisException%20Redis%20server%20%2Fvar%2Frun%2Fredis%2Fredis.sock%3A0%20went%20away%20order%3Alatest

[Multipass]

No shit Sherlock !! Sorry for my sarcasm, but yeah, I’ve done these searches and tested most of those suggestions, some of them didn’t change anything, some others throw more errors…

That said, I’m pretty sure it is some sort of a combinaison of those various suggestions and fixes, I just have to find the ones that works for me…

I guess I was hopping for a “magical idea” Like “oh, doh, sure, here you go”

Thanks for taking the time anyway

[Mornsgrans]

Please check your Redis-settings:

Installing Redis for Memcache

I also changed the port on the config/php file to 6379, but even after restarting the server it still gives me the Internal Server Error.

How to setup redis cache on php 8.1?

Hi, so my system is: VPS: ARM64, 4cpu/8GB RAM Ubuntu 22. Installed NC via Hestia CP. Running on PHP 8.1. Could someone help me, with how to set up the Redis cache? Thanks. Redis is running successfully on my WordPress sites.

and last but not least:
https://docs.nextcloud.com/server/latest/admin_manual/configuration_server/caching_configuration.html

[Multipass]

I tried… I even reinstalled Redis, and now I can’t connect to redis

Redis at 127.0.0.1:6379: Connection refused

Despite I updated the Port to 0, updated to the path to the newly created redis-server.sock file, (both in the redis.conf and the config.php)…

I removed the password, ensure that www-data was in the redis group and vice-versa…

I’m considering refreshing the ncp config back to the default, which might actually make it worse… I have backups though…

Since I have a workaround for now to make Nextcloud Office work by simply allowing “my.nextcloud.domain.com” in uBlock Origin, I will leave it that way for now…

It might bite me later, but 2 days on this, is a bit too much in regards to my original issue for which… again… I do have a workaround.