Hey there, i am having trouble installing collabora for nextcloud.
I am running nextcloud 19.0.1 on debian buster. to install it i have followed this howto: https://nextcloud.com/collaboraonline/ at the bottom of the page. then i installed collabora as app in nextcloud, set up my adress (https://docs.mydomain.de) and got a green light that it works.
when i try to create a document, it takes aprox 20s then i get this errormessage: “Collabora Online Development Edition konnte nicht geladen werden - Bitte versuche es später noch einmal” ("could not be loaded, please try again later or so…)
there are no errormessages in /var/log/apache2/error or apache
i created a collabora.conf in /etc/apache2/sites-availabe/ (and then a2ensite of course and reloaded apache) wich looks like this:
-------------------------
<VirtualHost *:443>
ServerName docs.mydomain.de:443
# SSL configuration, you may want to take the easy route instead and use Lets Encrypt!
SSLEngine on
SSLCertificateFile /etc/letsencrypt/live/docs.mydomain.de/fullchain.pem
#SSLCertificateChainFile /path/to/intermediate_certificate
SSLCertificateKeyFile /etc/letsencrypt/live/docs.mydomain.de/privkey.pem
SSLProtocol all -SSLv2 -SSLv3
SSLCipherSuite ECDHE-ECDSA-CHACHA20-POLY1305:ECDHE-RSA-CHACHA20-POLY1305:ECDHE-ECDSA-AES128-GCM-SHA256:ECDHE-RSA-AES128-GCM-SHA256:ECDHE-ECDSA-AES256-GCM-SHA384:ECDHE-RSA-AES256-GCM-SHA384:DHE-RSA-AES128-GCM-SHA256:DHE-RSA-AES256-GCM-SHA384:ECDHE-ECDSA-AES128-SHA256:ECDHE-RSA-AES128-SHA256:ECDHE-ECDSA-AES128-SHA:ECDHE-RSA-AES256-SHA384:ECDHE-RSA-AES128-SHA:ECDHE-ECDSA-AES256-SHA384:ECDHE-ECDSA-AES256-SHA:ECDHE-RSA-AES256-SHA:DHE-RSA-AES128-SHA256:DHE-RSA-AES128-SHA:DHE-RSA-AES256-SHA256:DHE-RSA-AES256-SHA:ECDHE-ECDSA-DES-CBC3-SHA:ECDHE-RSA-DES-CBC3-SHA:EDH-RSA-DES-CBC3-SHA:AES128-GCM-SHA256:AES256-GCM-SHA384:AES128-SHA256:AES256-SHA256:AES128-SHA:AES256-SHA:DES-CBC3-SHA:!DSS
SSLHonorCipherOrder on
# Encoded slashes need to be allowed
AllowEncodedSlashes NoDecode
# Container uses a unique non-signed certificate
SSLProxyEngine On
SSLProxyVerify None
SSLProxyCheckPeerCN Off
SSLProxyCheckPeerName Off
# keep the host
ProxyPreserveHost On
# static html, js, images, etc. served from loolwsd
# loleaflet is the client part of LibreOffice Online
ProxyPass /loleaflet https://127.0.0.1:9980/loleaflet retry=0
ProxyPassReverse /loleaflet https://127.0.0.1:9980/loleaflet
# WOPI discovery URL
ProxyPass /hosting/discovery https://127.0.0.1:9980/hosting/discovery retry=0
ProxyPassReverse /hosting/discovery https://127.0.0.1:9980/hosting/discovery
# Main websocket
ProxyPassMatch "/lool/(.*)/ws$" wss://127.0.0.1:9980/lool/$1/ws nocanon
# Admin Console websocket
ProxyPass /lool/adminws wss://127.0.0.1:9980/lool/adminws
# Download as, Fullscreen presentation and Image upload operations
ProxyPass /lool https://127.0.0.1:9980/lool
ProxyPassReverse /lool https://127.0.0.1:9980/lool
# Endpoint with information about availability of various features
ProxyPass /hosting/capabilities https://127.0.0.1:9980/hosting/capabilities retry=0
ProxyPassReverse /hosting/capabilities https://127.0.0.1:9980/hosting/capabilities
</VirtualHost>
when i let docker show me the logs, this is what i get:
-------------------------------
| ./net/WebSocketHandler.hpp:733
wsd-00006-00033 2020-08-13 13:03:35.361682 [ prisoner_poll ] TRC #19: Wrote outgoing data 129 bytes of 129 bytes buffered.| ./net/Socket.hpp:1163
wsd-00006-00033 2020-08-13 13:03:35.361791 [ prisoner_poll ] INF ChildProcess ctor [36].| wsd/LOOLWSD.hpp:57
wsd-00006-00033 2020-08-13 13:03:35.361833 [ prisoner_poll ] DBG Removing socket #19 (of 3) from prisoner_poll| net/Socket.cpp:316
wsd-00006-00033 2020-08-13 13:03:35.361876 [ prisoner_poll ] DBG #19 Thread affinity set to 0 (was 0x7fc604d97700).| ./net/Socket.hpp:288
wsd-00006-00033 2020-08-13 13:03:35.361913 [ prisoner_poll ] TRC Calling addNewChild in disposition's move thing to add to NewChildren| wsd/LOOLWSD.cpp:2078
wsd-00006-00033 2020-08-13 13:03:35.361945 [ prisoner_poll ] TRC Adding one child to NewChildren| wsd/LOOLWSD.cpp:476
wsd-00006-00033 2020-08-13 13:03:35.361971 [ prisoner_poll ] INF Have 1 spare child after adding [36].| wsd/LOOLWSD.cpp:480
wsd-00006-00033 2020-08-13 13:03:35.362003 [ prisoner_poll ] TRC Notifying NewChildrenCV| wsd/LOOLWSD.cpp:483
wsd-00006-00033 2020-08-13 13:03:35.362075 [ prisoner_poll ] TRC #18: Incoming data buffer 0 bytes, closeSocket? false| ./net/Socket.hpp:1093
wsd-00006-00006 2020-08-13 13:03:35.362089 [ loolwsd ] TRC Have 1 new children.| wsd/LOOLWSD.cpp:3769
wsd-00006-00006 2020-08-13 13:03:35.362169 [ loolwsd ] INF WSD initialization complete: setting log-level to [warning] as configured.| wsd/LOOLWSD.cpp:3776
wsd-00006-00033 2020-08-13 13:03:35.362120 [ prisoner_poll ] TRC #18: Wrote outgoing data 10 bytes of 10 bytes buffered.| ./net/Socket.hpp:1163
Ready to accept connections on port 9980.
wsd-00006-00038 2020-08-13 13:12:59.139335 [ websrv_poll ] WRN client - server version mismatch, disabling browser cache. Expected: ed4f732| wsd/FileServer.cpp:287
wsd-00006-00038 2020-08-13 13:12:59.140041 [ websrv_poll ] WRN FileServerRequestHandler: File not found: Invalid URI request: [/loleaflet].| wsd/FileServer.cpp:489
wsd-00006-00038 2020-08-13 13:13:07.355475 [ websrv_poll ] WRN client - server version mismatch, disabling browser cache. Expected: ed4f732| wsd/FileServer.cpp:287
wsd-00006-00038 2020-08-13 13:13:07.355609 [ websrv_poll ] WRN FileServerRequestHandler: File not found: Invalid URI request: [/loleaflet].| wsd/FileServer.cpp:489
----------------------------------------
if anyone has an idea what i could do here, it would be really great!!!
Hello,
I will try to understand the cause of your problem.
Can you try first to integrate apache config on your main nextcloud site and then stop, remove and start docker with
this seems to be a very strange problem… i also tried to remove the docker server install and installed the "collabora integrated CODE Server"App, to see if this would work.
I still get the same error…
(i installed the app, then selected “use internal CODE server”. i also get the green “ok” sign on top of the settings page)
but when i create a document, or open a document, there is a spinning wheel for around 30s and then i get “couldnt load collabora… please try again later”
in what log file should i look for the error message?!
Thank you so much !!
PS.: yes i changed the config and then restarted apache2.
PPS.: i finally found the log files for nextcloud. And there are some errors:
Here is a snipped of the logfile (last lines when i tried to open a document with collabora):
[richdocuments] Error: Doctrine\DBAL\Exception\InvalidFieldNameException: An exception occurred while executing ‘INSERT INTO oc_richdocuments_wopi(fileid,owner_uid,editor_uid,version,canwrite,server_host,token,expiry,template_destination,hide_download,direct,is_remote_token,template_id) VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?)’ with params [271139, “user”, “user”, 0, true, “https://cloud.domain.de/”, “vdnZe4VcAtTYvLBywbMVFeQ4lCA6hi7J”, 1597757907, 0, false, false, false, 0]:
SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘hide_download’ in ‘field list’ at <>
/var/www/nextcloud/lib/private/Route/Router.php line 297
call_user_func(OC\AppFramework\ … {}, {_route: “richdocuments.document.index”})
/var/www/nextcloud/lib/base.php line 1007
OC\Route\Router->match("/apps/richdocuments/index")
/var/www/nextcloud/index.php line 37
OC::handleRequest()
GET /index.php/apps/richdocuments/index?fileId=271139&requesttoken=xNr%2B2GOtJL3iuLOBAkD8WKrIy1dRRnD%2FglnGV7pqSbM%3D%3A8q%2BonlTgVc2g08PTehmvH825nDJ6dTqt1zHwE9QYHNs%3D
from 62.91.xxx.xxx by userat 2020-08-18T13:08:27+00:00