Unable to open odt documents with self signed certificate on collabora

Hello community

I installed nextcloud and implemented there self signed certificates. I created a nextcloud.conf file, where i defined the 443 port fort nextcloud. Implemented the self signed certificates. So with this configuration ,nextcloud works well

After that i created a office.conf and configured there also self signer certificates. Unfortunatelly collabora is not able to open odt documents.

In my apache log file I see a client error bad request.

have a look in the file

{“reqId”:“NLmUtUej9VGSuCAH158I”,“level”:3,“time”:“2019-07-23T07:59:25+00:00”,“remoteAddr”:“192.168.88.1”,“user”:“admin”,“app”:“richdocuments”,“method”:“GET”,“url”:"/index.php/apps/richdocuments/index?fileId=280&requesttoken=H%2F%2BAI2a%2FlM%2FBAgMiRnG2bFdpb3%2Br%2Fay7XDYxr%2BGRsi0%3D%3AKq3MSxb446HqbVdaAFrRBTokHS3hvMH5PVhe%2FIbwwV8%3D",“message”:{“Exception”:“GuzzleHttp\Exception\ClientException”,“Message”:“Client error: GET https:\/\/collabora.lustrati.local\/hosting\/discovery resulted in a 400 Bad Request response:\n\n<html class=“ng-csp” data-placeholder-focus=“false” lang=“en” data-locale=“en” >\n\t<head\n data-requesttok (truncated…)\n”,“Code”:400,“Trace”:[{“file”:"/var/www/nextcloud/3rdparty/guzzlehttp/guzzle/src/Middleware.php",“line”:66,“function”:“create”,“class”:“GuzzleHttp\Exception\RequestException”,“type”:"::",“args”:[{“class”:“GuzzleHttp\Psr7\Request”},"*** sensitive parameter replaced "]},{“file”:"/var/www/nextcloud/3rdparty/guzzlehttp/promises/src/Promise.php",“line”:203,“function”:“GuzzleHttp\{closure}”,“class”:“GuzzleHttp\Middleware”,“type”:"::",“args”:[" sensitive parameters replaced "]},{“file”:"/var/www/nextcloud/3rdparty/guzzlehttp/promises/src/Promise.php",“line”:156,“function”:“callHandler”,“class”:“GuzzleHttp\Promise\Promise”,“type”:"::",“args”:[1," sensitive parameter replaced ",[{“class”:“GuzzleHttp\Promise\Promise”},{“class”:“Closure”},null]]},{“file”:"/var/www/nextcloud/3rdparty/guzzlehttp/promises/src/TaskQueue.php",“line”:47,“function”:“GuzzleHttp\Promise\{closure}”,“class”:“GuzzleHttp\Promise\Promise”,“type”:"::",“args”:[" sensitive parameters replaced "]},{“file”:"/var/www/nextcloud/3rdparty/guzzlehttp/promises/src/Promise.php",“line”:246,“function”:“run”,“class”:“GuzzleHttp\Promise\TaskQueue”,“type”:"->",“args”:[true]},{“file”:"/var/www/nextcloud/3rdparty/guzzlehttp/promises/src/Promise.php",“line”:223,“function”:“invokeWaitFn”,“class”:“GuzzleHttp\Promise\Promise”,“type”:"->",“args”:[]},{“file”:"/var/www/nextcloud/3rdparty/guzzlehttp/promises/src/Promise.php",“line”:267,“function”:“waitIfPending”,“class”:“GuzzleHttp\Promise\Promise”,“type”:"->",“args”:[]},{“file”:"/var/www/nextcloud/3rdparty/guzzlehttp/promises/src/Promise.php",“line”:225,“function”:“invokeWaitList”,“class”:“GuzzleHttp\Promise\Promise”,“type”:"->",“args”:[]},{“file”:"/var/www/nextcloud/3rdparty/guzzlehttp/promises/src/Promise.php",“line”:62,“function”:“waitIfPending”,“class”:“GuzzleHttp\Promise\Promise”,“type”:"->",“args”:[]},{“file”:"/var/www/nextcloud/3rdparty/guzzlehttp/guzzle/src/Client.php",“line”:131,“function”:“wait”,“class”:“GuzzleHttp\Promise\Promise”,“type”:"->",“args”:[]},{“file”:"/var/www/nextcloud/lib/private/Http/Client/Client.php",“line”:161,“function”:“request”,“class”:“GuzzleHttp\Client”,“type”:"->",“args”:[“get”,“https://collabora.lustrati.local/hosting/discovery",{“verify”:false,“timeout”:5,“synchronous”:true}]},{“file”:"/var/www/nextcloud/apps/richdocuments/lib/WOPI/DiscoveryManager.php",“line”:106,“function”:“get”,“class”:“OC\Http\Client\Client”,“type”:"->”,“args”:[“https://collabora.lustrati.local/hosting/discovery",{“timeout”:5,“verify”:false}]},{“file”:"/var/www/nextcloud/apps/richdocuments/lib/WOPI/DiscoveryManager.php",“line”:78,“function”:“fetchFromRemote”,“class”:“OCA\Richdocuments\WOPI\DiscoveryManager”,“type”:"->”,“args”:[]},{“file”:"/var/www/nextcloud/apps/richdocuments/lib/WOPI/Parser.php",“line”:41,“function”:“get”,“class”:“OCA\Richdocuments\WOPI\DiscoveryManager”,“type”:"->",“args”:[]},{“file”:"/var/www/nextcloud/apps/richdocuments/lib/TokenManager.php",“line”:177,“function”:“getUrlSrc”,“class”:“OCA\Richdocuments\WOPI\Parser”,“type”:"->",“args”:[“application/vnd.oasis.opendocument.text”]},{“file”:"/var/www/nextcloud/apps/richdocuments/lib/Controller/DocumentController.php",“line”:176,“function”:“getToken”,“class”:“OCA\Richdocuments\TokenManager”,“type”:"->",“args”:[" sensitive parameters replaced "]},{“file”:"/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php",“line”:166,“function”:“index”,“class”:“OCA\Richdocuments\Controller\DocumentController”,“type”:"->",“args”:[" sensitive parameter replaced ***"]},{“file”:"/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php",“line”:99,“function”:“executeController”,“class”:“OC\AppFramework\Http\Dispatcher”,“type”:"->",“args”:[{“class”:“OCA\Richdocuments\Controller\DocumentController”},“index”]},{“file”:"/var/www/nextcloud/lib/private/AppFramework/App.php",“line”:126,“function”:“dispatch”,“class”:“OC\AppFramework\Http\Dispatcher”,“type”:"->",“args”:[{“class”:“OCA\Richdocuments\Controller\DocumentController”},“index”]},{“file”:"/var/www/nextcloud/lib/private/AppFramework/Routing/RouteActionHandler.php",“line”:47,“function”:“main”,“class”:“OC\AppFramework\App”,“type”:"::",“args”:[“OCA\Richdocuments\Controller\DocumentController”,“index”,{“class”:“OC\AppFramework\DependencyInjection\DIContainer”},{"_route":“richdocuments.document.index”}]},{“function”:"__invoke",“class”:“OC\AppFramework\Routing\RouteActionHandler”,“type”:"->",“args”:[{"_route":“richdocuments.document.index”}]},{“file”:"/var/www/nextcloud/lib/private/Route/Router.php",“line”:297,“function”:“call_user_func”,“args”:[{“class”:“OC\AppFramework\Routing\RouteActionHandler”},{"_route":“richdocuments.document.index”}]},{“file”:"/var/www/nextcloud/lib/base.php",“line”:975,“function”:“match”,“class”:“OC\Route\Router”,“type”:"->",“args”:["/apps/richdocuments/index"]},{“file”:"/var/www/nextcloud/index.php",“line”:42,“function”:“handleRequest”,“class”:“OC”,“type”:"::",“args”:[]}],“File”:"/var/www/nextcloud/3rdparty/guzzlehttp/guzzle/src/Exception/RequestException.php",“Line”:113,“CustomMessage”:"–"},“userAgent”:“Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:68.0) Gecko/20100101 Firefox/68.0”,“version”:“16.0.3.0”}

What could be the cause of this error?

If you use nc/code in your internal LAN - IMHO - you do not need encrypted connected. Try this

first …

Hi Ralfi

Unfortunatelly it doesn’t work.

Would it be possible to start a quick remote session so that you can see what happens?

Remote is not possible at this moment caused by FW blocking …

If you have a matrix.org account (or oftc / freenode) we can chat if you like.
Quick tryout from collabora do not working? Curios…

Hi Ralfi

I don’t have matrix.org. But i could you contact with skype.
IF this is possible where can I send you my skype informations per email? It’s possible to send you a private message here?

regards Ramon

I do not use skype and will never use it…
Try matrix. Its anonym, encrypted, multi-platformed, file- / video- /audio chat and more things…

I’m online. how can I reach you?

Whats your matrix id (“id”@matrix.org) …
Then is send you a invitation

Whats your matrix id ?
Then i send you a invitation

@ansans:matrix.org