[SOLVED] Can't open files with collabora

Hello,

I’ve a problem with Nextcloud and collabora.
When I try to open a document, I’ve the errors:

wsd-00029-00056 2019-06-24 13:06:58.366134 [ docbroker_005 ] ERR  Cannot get file info from WOPI storage uri [https://cloud.noobie.fr/index.php/apps/richdocuments/wopi/files/1021828_ocyr35unf1m8?access_token=dG2uwlYCTUG7a7GHzjQjzVp9ovuIIIDM&access_token_ttl=0&permission=edit]. Error: Timeout: connect timed out: 90.88.16.237:443| wsd/Storage.cpp:474
wsd-00029-00056 2019-06-24 13:06:58.366519 [ docbroker_005 ] ERR  Failed to add session to [/index.php/apps/richdocuments/wopi/files/1021828_ocyr35unf1m8] with URI [https://cloud.noobie.fr/index.php/apps/richdocuments/wopi/files/1021828_ocyr35unf1m8?access_token=dG2uwlYCTUG7a7GHzjQjzVp9ovuIIIDM&access_token_ttl=0&permission=edit]: Timeout| wsd/DocumentBroker.cpp:1111
wsd-00029-00056 2019-06-24 13:06:58.366730 [ docbroker_005 ] ERR  Error while loading : Timeout| wsd/LOOLWSD.cpp:2680
wsd-00029-00056 2019-06-24 13:06:58.367276 [ docbroker_005 ] WRN  Child session [001e] not found to forward message: load url=https://cloud.noobie.fr/index.php/apps/richdocuments/wopi/files/1021828_ocyr35unf1m8?access_token=dG2uwlYCTUG7a7GHzjQjzVp9ovuIIIDM&access_token_ttl=0&permission=edit readonly=0 lang=fr| wsd/DocumentBroker.cpp:1756
wsd-00029-00056 2019-06-24 13:06:58.368452 [ docbroker_005 ] ERR  Invalid or unknown session [001e] to remove.| wsd/DocumentBroker.cpp:1180
wsd-00029-00030 2019-06-24 13:06:59.368265 [ prisoner_poll ] WRN  Prisoner connection disconnected but without valid socket.| wsd/LOOLWSD.cpp:1783
kit-00053-00031 2019-06-24 13:06:59.368382 [ loolkit ] WRN  Kit connection lost without exit arriving from wsd. Setting TerminationFlag| kit/Kit.cpp:2234

This is my apache virtualhost:

<VirtualHost *:443>
ServerName office.noobie.fr:443

# SSL configuration, you may want to take the easy route instead and use Lets Encrypt!
SSLEngine on
SSLCertificateFile    /etc/letsencrypt/live/office.noobie.fr/fullchain.pem
SSLCertificateKeyFile /etc/letsencrypt/live/office.noobie.fr/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
Include /etc/letsencrypt/options-ssl-apache.conf

# 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 </VirtualHost>

# 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

</VirtualHost>

I can access to the https://office.noobie.fr/loleaflet/dist/admin/admin.html with no error.

This is my docker files:

docker run -t -d -p 127.0.0.1:9980:9980 -e "domain=cloud\\.noobie\\.fr" -e "username=USER" -e "password=PASSWORD" --name=COLLABORAOFFICE --restart always --cap-add MKNOD collabora/code

And to finish this is my configuration on nextcloud:

thanks for you support.

Hello,

I’ve solved my problem.
I’ve add a entry of my host file on my collabora container.
I add

192.168.0.250 cloud.noobie.fr
192.168.0.250 office.noobie.fr

After test this, I’ve configure my dns server for my internel LAN.