Collabora with reverseproxy not working after upgrade to Nextcloud 23 #1904
Comments
|
Seems like But after changing this, I still got an error using the docker code image and NC23 until I deleted my Browser-Cache. Keep in Mind, that the ws configuration for Apache: Nginx: It's working now again, yay! |
|
@maurerle just a little hint, according to the official documentation, the matching location for download, presentation and image upload is now |
|
Thanks, I updated my comment above, so that it is correct if someone else copies from it. I never found the official documentation you provided. The nextcloud documentation https://nextcloud.com/collaboraonline/ gives you the old apache config, a link to an old blog post for nginx config and a broken link to the collabora online official documentation. Besides that, the new richdocuments runs very well. If LibreOffice Calc would get the feature to create sortable tables like Excel does, I'd probably could stop using Excel at all. |
Thank you! This fixed the issue for me, I was unaware of the changes until now |
|
I'm unable to get Collabora Online (5.0.1) working even after updating my Apache config to match what @maurerle posted above and clearing my cache. I have pulled the latest Collabora container. This error is showing up in my console:
If I query collabora using |
|
@grickard |
|
Have the same issue here, after upgrading to 23.0.0 it stopped working. Just upgraded to Collabora Online v5.0.1 and hoped the issue would been fixed, apparently not. Says it can't load Nextcloud Office. Running Arch Linux (in a VM), Apache and Collabora service (not CODE). Using Apache proxy, and it's set up as stated in the documents. Everything seems to be running as it should, but Nextcloud can't load it. [EDIT] The demo server works, but neither built-in code or standalone server works.
|
|
Are there any logs of the Collabora service? With docker, you can read them with By the way, I remember that I had a similar problem where I had to completely restart docker instead of restarting the container only. |
|
I get some errors, mainly "WOPI::CheckFileInfo failed" for some reason. I don't use docker, have the server installed from AUR package collabora-online-server-nodocker. Messed around with tons of different solutions, and also removed Collabora app for NextCloud and cleaned the database. No luck. Checking the link itself (https://mydomain.org/index.php/apps/richdocuments/wopi/files/174560_oc9u11yp5294?access_token=qQi2y801E2bXUQcOEAIQB8LitUAZQkhR&access_token_ttl=0) that seems to fail, I get data from it. Also see this in apache error log, not sure if it's related to the issue. |
|
Found the problem that has haunted me for weeks now, I forced the connection to use TLSv1.3. This is why I got the socket error in the logs. Adding TLSv1.2 in Apache config made it work! Feels a bit odd because I don't use SSL to coolwsd itself, so it shouldn't be an issue, but it apparently was. SSLProtocol -all +TLSv1.3 +TLSv1.2 [EDIT] Just noticed I just needed to add TSLv1.2 on the NextCloud virtual host config, not in the coolwsd reverse proxy part. NextCloud itself works with just TLSv1.3, but not in combination with Collabora Online. |
|
@drudgede Thanks for the response. My proxy config already matches the vhost definition you have specified. I went ahead and rechecked that all the Apache modules were enabled. What actually fixed it for me was changing the Protocol to TLSv1.2 as per @zynexiz. Collabora is functioning as it should now. |
This comment has been minimized.
This comment has been minimized.
|
Hi, The same issue. I use a simple configuration, traefik as edge RP and a docker stack with nextcloud-fpm (with caddy) and collabora. Both services are publisheds through https with separate subdomain name. Everything is fine since few years now, and upgraded at each release ... at this time i use docker image nextcloud 22.2.3 and collabora 21.11.1.1.1. In nextcloud, i in richdocuments settings, i use the published url of collabora. Just upgraded to nextcloud 23.0.0 and collabora is broken and can't downgrade nextcloud. I'm searching how to get log or something else. |
|
For those bit by this problem I suggest to enable the The problem, at least in my installation, is that nginx decodes the embedded url in the initial websocket connection which makes the location pattern fail. Enabling |
|
I just disable and remove the plugin. Reconnect one browser on NC and install the plugin Return to the files and open an existing excel file.... I try fews start/stock of my stack, many browses and from many places to be sure it's working. Note : my docker images are NC 23.0.0.0 (plugin collaboraonline is 5.0.1) and Collabora is 21.11.1.1.1 |
|
Well, I presume there are at least two problems with my setup, and one seems to be the current app for Nextcloud 23.
I did the |
|
Look in your browser's inspector->Network and inspector->Console which connections are failing; in my case it was the websocket connection. Once you know which connection fails try to open such a connection from the command line by using "Copy as curl" (on the culprit in the Network tab) and executing the command while keeping an eye on the log (either This is the relevant section of my nginx config: And, in |
|
I still have this problem. I cant get it to work and I am also
I am running the 6 container nextcloud fpm, database, nginx, cron and redis and collabora. I can reach collabora via browser and get a OK. What can I try?.. |
|
A 5.0.2 version of the richdocument app was released yesterday... Still not try. |
Turns out, I was SOOO wrong. Not to say there isn't any bug in Collabora app, but that was on me, excuse me for my accusation. I missed to include IPv6 |
|
Right now I am not able to use ipv6. Can someone confirm that this issue (or atleast on of the issues) resolves by enabling ipv6? |
|
I have resolved the issue with the documentation since quite some time now. The problem for me is that the client gets disconnects every few seconds. This makes it impossible to write anything. It looks like the client gets disconnected or disconnects every few seconds. |
|
Don't know is it related. After Try to save "URL (and Port) of Collabora Online-server": Fixed this with: coolconfig set ssl.termination true So it's work now for me. But anyway it need fix during create table oc_richdocuments_wopi - column template_destination. |
|
Hi thanks for the report. Github is not the ideal place to track configuration issues. I am in the process of cleaning up the repository to keep only the relevant issues (bugs, security issues and feature requests). Here you can find some resources which should allow you to fix your issue: |
|
NC 24 I get this issue, can be a regression??
I test it on nginx without luck |
|
im experiencing the same issue.. documented in here: #752 (comment) im sure its a regression, cause im using ansible for setting up the reverse proxy... and the old version and new version are failing, anyway there should be a guide to troubleshoot this issue easier... |
|
Just solved my "document loading failed" too by disabling TLS1.3 (HTTP/3). When using TLS1.2 (HTTP/2) everything is working fine. edit: This is only needed, when using build-in CODE server. When running an external Collabora server, everthing is fine with TLS1.3. |
|
Nothing relate to tls, security or permissions.. Unfortunately I don't have the link of who was the author of the solution at hand (that guy saved my life) (I think he was on stackoverflow)
|
|
i solved the problem setting the dns of collabora server (centos 8) in /etc/hosts to 127.0.0.1 collabora.domain.tld |
Thank you, first I followed you advice, changed my protocal to http2, but it doesn't work, still got this error , then I empty my config in nextcloud admin Office setting
|
Steps to reproduce
Expected behaviour
document opens
Actual behaviour
got 404 fpr request:
maybe this is related to #1895
Server configuration
Server configuration detail
Operating system: Linux 5.4.0-91-generic #102-Ubuntu SMP Fri Nov 5 16:31:28 UTC 2021 x86_64
Webserver: Apache (fpm-fcgi)
Database: mysql 10.3.32
PHP version: 7.4.3
Modules loaded: Core, date, libxml, openssl, pcre, zlib, filter, hash, Reflection, SPL, session, standard, sodium, cgi-fcgi, mysqlnd, PDO, xml, apcu, bcmath, bz2, calendar, ctype, curl, dom, mbstring, FFI, fileinfo, ftp, gd, gettext, gmp, iconv, imagick, intl, json, exif, mysqli, pdo_mysql, pdo_sqlite, apc, posix, readline, shmop, SimpleXML, sockets, sqlite3, sysvmsg, sysvsem, sysvshm, tokenizer, xmlreader, xmlwriter, xsl, zip, Phar, Zend OPcache
Nextcloud version: 23.0.0 - 23.0.0.10
Updated from an older Nextcloud/ownCloud or fresh install:
Where did you install Nextcloud from: unknown
Signing status
Array ( )
List of activated apps
Enabled:
Disabled:
Configuration (config/config.php)
{
"instanceid": "REMOVED SENSITIVE VALUE",
"passwordsalt": "REMOVED SENSITIVE VALUE",
"datadirectory": "REMOVED SENSITIVE VALUE",
"dbtype": "mysql",
"version": "23.0.0.10",
"dbname": "REMOVED SENSITIVE VALUE",
"dbhost": "REMOVED SENSITIVE VALUE",
"dbtableprefix": "oc_",
"dbuser": "REMOVED SENSITIVE VALUE",
"dbpassword": "REMOVED SENSITIVE VALUE",
"installed": true,
"loglevel": 3,
"forcessl": true,
"theme": "",
"maintenance": false,
"trusted_domains": [
"darkvoice.dyndns.org",
"ms07.de"
],
"mail_smtpmode": "smtp",
"mail_smtphost": "REMOVED SENSITIVE VALUE",
"mail_smtpsecure": "ssl",
"mail_smtpauth": 1,
"mail_smtpname": "REMOVED SENSITIVE VALUE",
"mail_smtppassword": "REMOVED SENSITIVE VALUE",
"logtimezone": "Europe/Berlin",
"log_authfailip": true,
"secret": "REMOVED SENSITIVE VALUE",
"overwrite.cli.url": "https://ms07.de/nc",
"mail_from_address": "REMOVED SENSITIVE VALUE",
"mail_domain": "REMOVED SENSITIVE VALUE",
"mail_smtpport": "465",
"appstore.experimental.enabled": true,
"trashbin_retention_obligation": "60, 180",
"updater.release.channel": "stable",
"htaccess.RewriteBase": "/nc/",
"memcache.local": "\OC\Memcache\APCu",
"simpleSignUpLink.shown": false,
"log_rotate_size": 104857600,
"mysql.utf8mb4": true,
"defaultapp": "files",
"preview_max_x": 2048,
"preview_max_y": 2048,
"default_phone_region": "DE"
}
Cron Configuration: Array ( [backgroundjobs_mode] => cron [lastcron] => 1638981301 )
External storages: files_external is disabled
Encryption: no
User-backends:
OC\User\Database
Talk configuration:
STUN servers
stun.nextcloud.com:443
TURN servers
turn:ms07.de:5349 - udp,tcp
Signaling servers (mode: internal):
no custom server configured
Browser: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:94.0) Gecko/20100101 Firefox/94.0
The text was updated successfully, but these errors were encountered: