Collabora not working anymore since NC26 (ARM)

[Bobmorton-TX]

Describe the bug

Since the update to NC26 Collabora does not work anymore.
This seems to be due to the forced update of Collabora to version 23.5.104. There is a stale bug report that this version does not work by @Pilzinsel64 CollaboraOnline/richdocumentscode#226

I managed to install the old working version 22.5.1301 and it was running ok for a while.
I suffered with high CPU load spikes after a few hours (#2457) and solved these by restarting the snap every 6 hours and replacing the Collabora version via script to 22.5.1301.

Since today Collabora wont start anymore. I have rebooted the device (Rock5), restarted NC snap. deactivated Collabora.
The

Error GuzzleHttp\Exception\ServerException: Server error: GET https://cloud.xxxxxxxx.com/extra-apps/richdocumentscode_arm64/proxy.php?req=/hosting/capabilities` resulted in a 500 Internal Server Error response`

To Reproduce

open office document.
blank screen - office not loading. no error message

Expected behavior

Open Office document

Screenshots

OS/snapd/snap version

Armbian 23.02.2 Jammy with Linux 5.10.110-rockchip-rk3588

Name Version Rev Tracking Publisher Notes
nextcloud 26.0.3snap1 35883 latest/stable nextcloud✓ -

snap 2.59.5
snapd 2.59.5
series 16
ubuntu 22.04

Logs

Error message when Collarbora app is enabled.

GuzzleHttp\Exception\ServerException: Server error: GET https://cloud.xxxxxxxxxx.com/extra-apps/richdocumentscode_arm64/proxy.php?req=/hosting/capabilities` resulted in a 500 Internal Server Error response

bug report snap 20230726.txt

[Pilzinsel64]

@Bobmorton-TX Thanks for your investigation. Please add your information to the upstream issue you already linked (CollaboraOnline/richdocumentscode#226) as this isn't a snap issue directly and came up with an update of collabora. They will need as much information as possible. ;)

[Bobmorton-TX]

would it be possible to revert to snap NC25 without losing data?

[Pilzinsel64]

would it be possible to revert to snap NC25 without losing data?

Not really. If you updated previously, then you can use the command sudo snap revert nextcloud. But this works is only if you updated previously, so your last update MUST be from NC25 to NC26 and you didn't add many new data since then. I don't recommend you to go back, especially as I don't think you made manual backups.

But the workaround with the script that downgrades the app should do the trick. The other issues (high cpu usage, error after few days) I haven't had.

[Bobmorton-TX]

I have daily database and config backups via nextcloud.export - and rsync backup of all data.

can I setup a new snap instance (NC25) with that?

I cannot do the revert trick anymore. As soon as the nextcloud office app is activated I get a stream of these error messages:
GuzzleHttp\Exception\ServerException: Server error: GET https://cloud.xxxxxxxxx.com/extra-apps/richdocumentscode_arm64/proxy.php?req=/hosting/capabilities` resulted in a 500 Internal Server Error response`

I cannot change the Coder Server settings via the web admin interface - says server is unreachable. It seems the whole office to collabora connection is messed up.

any idea how I can troubleshoot that?

[Pilzinsel64]

I have daily database and config backups via nextcloud.export - and rsync backup of all data.

This is brilliant! See the wiki entry for export & import how to handle that. With this you should be able to setup a fresh install of nc25 and import your last v25 backup.

any idea how I can troubleshoot that?

Not really, I absolutely have no idea, sorry. 😢
You may try your luck at https://help.nextcloud.com or create an issue at the corresponding GitHub repo (you can test if the Demo Servers does work).

[Bobmorton-TX]

I have setup a Collabora docker and this works with NC (i have to login to the admin interface of collabora once after container restart, otherwise it does not work)

searching for files in NC on the webfront end causes immediate reboot of the whole server. I fear my snap install is broken.
I tested Collarbora 23.5.104. with the current official NC docker image (NC27) and this works fine on my platform.

could a reinstall of the snap help (NC26 and import of database and data)?

[Pilzinsel64]

You can give it a try, of course! But if it still not work, you can try purging the collabora apps completely by uninstalling them, Remove the app data and remove the tables from the database. Then you can pefform a fresh install of collabora.

[Bobmorton-TX]

I ended up installing a fresh snap install (26.0.1) and restoring the db and data.
Using a script to replace Collabora Online - Built-in CODE Server (ARM64) with version 22.5.1301. Restarting NC snap every 6 hours because it the cpu load goes up significantly after a few hours. After restart back to very low level for some time.

I have tested NC26 docker with latest Collabora Online - Built-in CODE Server (ARM64) and this works well.
So this must be an issue with the snap, i think.

[Pilzinsel64]

I take the liberty of closing the issue here as won't fix / not planned. The main issue is up-stream and built-in code is not officially supported in Nextcloud Snap.
Anyway I continue to provide support to the upstream maintainers to get around the snap enviroment (at least as far as I have abilities to) to help them getting the app compatible with Nextcloud snap.

[Pilzinsel64]

Everyone who is still reading this:
See CollaboraOnline/richdocumentscode#226 (comment)

[scubamuc]

See working configuration here: https://github.com/nextcloud-snap/nextcloud-snap/wiki/Configure-CODE-and-Nextcloud-office-for-Nextcloud-snap

[Bobmorton-TX]

See working configuration here: https://github.com/nextcloud-snap/nextcloud-snap/wiki/Configure-CODE-and-Nextcloud-office-for-Nextcloud-snap

I ran the steps exactly like listed this is not working for my Rock5 (arm) armbian setup.

[Pilzinsel64]

For arm devices there is n actual bug upstream. Issue linked. The steps has been tested on an amd64 device.