Collabora internal Server Error

ℹ️ Support 📄 Collabora
1

Hey!
I´ve tried to install Collabora/Code via the docker image.
https://office.verwaltungsmanagement.at/hosting/discovery works fine

My Nextcloud Instance usees a wildcard ssl zert.
I added the self-signed cert from the docker to the trusted cert bundle of nextcloud.
Still Collabora wont open in Nextcloud, I attatched the logs below.
Anybody familiar with this issue? It drives me mad :smiley:

Greets,
Alex

Heres my Vhost Config:

<VirtualHost *:443>

ServerName office.xxx.**
ServerAdmin webmaster@localhost
SSLEngine on

            SSLCertificateFile      /etc/apache2/ssl/domain.cer
            SSLCertificateKeyFile /etc/apache2/ssl/domain.key

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

when i try to link my collabora instance (https://offce.***.xx:443) I get an internal Server error saying:
Anfragekennung: SDu4CEpowtncpB0RqEpx
Typ: GuzzleHttp\Exception\RequestException
Code: 0
Nachricht: cURL error 60: SSL certificate problem: unable to get local issuer certificate
Datei: /var/www/html/nextcloud/3rdparty/guzzlehttp/guzzle/src/Exception/RequestException.php
Zeile: 51

Trace

#0 /var/www/html/nextcloud/3rdparty/guzzlehttp/guzzle/src/RequestFsm.php(103): GuzzleHttp\Exception\RequestException::wrapException(Object(GuzzleHttp\Message\Request), Object(GuzzleHttp\Ring\Exception\RingException))
#1 /var/www/html/nextcloud/3rdparty/guzzlehttp/guzzle/src/RequestFsm.php(132): GuzzleHttp\RequestFsm->__invoke(Object(GuzzleHttp\Transaction))
#2 /var/www/html/nextcloud/3rdparty/react/promise/src/FulfilledPromise.php(25): GuzzleHttp\RequestFsm->GuzzleHttp{closure}(Array)
#3 /var/www/html/nextcloud/3rdparty/guzzlehttp/ringphp/src/Future/CompletedFutureValue.php(55): React\Promise\FulfilledPromise->then(Object(Closure), NULL, NULL)
#4 /var/www/html/nextcloud/3rdparty/guzzlehttp/guzzle/src/Message/FutureResponse.php(43): GuzzleHttp\Ring\Future\CompletedFutureValue->then(Object(Closure), NULL, NULL)
#5 /var/www/html/nextcloud/3rdparty/guzzlehttp/guzzle/src/RequestFsm.php(134): GuzzleHttp\Message\FutureResponse::proxy(Object(GuzzleHttp\Ring\Future\CompletedFutureArray), Object(Closure))
#6 /var/www/html/nextcloud/3rdparty/guzzlehttp/guzzle/src/Client.php(165): GuzzleHttp\RequestFsm->__invoke(Object(GuzzleHttp\Transaction))
#7 /var/www/html/nextcloud/3rdparty/guzzlehttp/guzzle/src/Client.php(125): GuzzleHttp\Client->send(Object(GuzzleHttp\Message\Request))
#8 /var/www/html/nextcloud/lib/private/Http/Client/Client.php(138): GuzzleHttp\Client->get(‘https://office…’, Array)
#9 /var/www/html/nextcloud/apps/richdocuments/lib/WOPI/DiscoveryManager.php(84): OC\Http\Client\Client->get(‘https://office…’)
#10 /var/www/html/nextcloud/apps/richdocuments/lib/WOPI/Parser.php(41): OCA\Richdocuments\WOPI\DiscoveryManager->get()
#11 /var/www/html/nextcloud/apps/richdocuments/lib/TokenManager.php(122): OCA\Richdocuments\WOPI\Parser->getUrlSrc(‘application/vnd…’)
#12 /var/www/html/nextcloud/apps/richdocuments/lib/Controller/DocumentController.php(168): OCA\Richdocuments\TokenManager->getToken(‘61961’)
#13 [internal function]: OCA\Richdocuments\Controller\DocumentController->index(‘61961’)
#14 /var/www/html/nextcloud/lib/private/AppFramework/Http/Dispatcher.php(160): call_user_func_array(Array, Array)
#15 /var/www/html/nextcloud/lib/private/AppFramework/Http/Dispatcher.php(90): OC\AppFramework\Http\Dispatcher->executeController(Object(OCA\Richdocuments\Controller\DocumentController), ‘index’)
#16 /var/www/html/nextcloud/lib/private/AppFramework/App.php(114): OC\AppFramework\Http\Dispatcher->dispatch(Object(OCA\Richdocuments\Controller\DocumentController), ‘index’)
#17 /var/www/html/nextcloud/lib/private/AppFramework/Routing/RouteActionHandler.php(47): OC\AppFramework\App::main(‘OCA\Richdocumen…’, ‘index’, Object(OC\AppFramework\DependencyInjection\DIContainer), Array)
#18 [internal function]: OC\AppFramework\Routing\RouteActionHandler->__invoke(Array)
#19 /var/www/html/nextcloud/lib/private/Route/Router.php(299): call_user_func(Object(OC\AppFramework\Routing\RouteActionHandler), Array)
#20 /var/www/html/nextcloud/lib/base.php(1004): OC\Route\Router->match(’/apps/richdocum…’)
#21 /var/www/html/nextcloud/index.php(48): OC::handleRequest()
#22 {main}

2

When you defined already “Proxy” for Collabora server, the parameter to define in NC is only https://office.xxx.yy (without PORT number).

3

Its also not working without the port number :frowning: I think it is an issue with my wildcard cert : Nachricht: cURL error 60: SSL certificate problem: unable to get local issuer certificate
strange thing is that no other app has problems with it

4

I used Let’s Encrypt certificates. It works like a charm :wink: