Problem opening files with latest coolwsd/collabora office update

1

After a recent upgrade to collaboraonline from packages, I’ve got a problem that’s similar to topic 1031. When I try to open any file on any platform with either Firefox or a Chromium based browser it either stays “Loading …” at 0% or it complains it can’t connect to the server. All other indications are that it can, in fact, connect to the server at least to get to the initial screen.

The current version of collaboraoffice is 21.06.30-1 with coolwsd at 21.11.5.1-1 and code-brand at 21.11-27. I’m running on Debian 11 with Apache2. The Nextcloud app is version 4.2.7 and I’m running Nextcloud 22.2.8.

I’m getting the following errors from journalctl:

Jun 06 10:42:04 myhost coolwsd[2629394]: wsd-2629394-2629422 2022-06-06 10:42:04.061069 -0400 [ websrv_poll ] WRN  DocBroker with docKey [https://myhostname.org:443/index.php/apps/richdocuments/wopi/files/<mydocumentstring>] is unloading. Rejecting client request to load.| wsd/COOLWSD.cpp:2993
Jun 06 10:42:04 myhost coolwsd[2629394]: wsd-2629394-2629422 2022-06-06 10:42:04.061689 -0400 [ websrv_poll ] ERR  Error while handling Client WS Request: Failed to create DocBroker with docKey [https://myhostname.org:443/index.php/apps/richdocuments/wopi/files/<mydocumentstring>].| wsd/COOLWSD.cpp:4437
Jun 06 10:42:04 myhost coolwsd[2629394]: wsd-2629394-2629422 2022-06-06 10:42:04.061712 -0400 [ websrv_poll ] WRN  #32 is shutting down but 64 bytes couldn't be flushed and still remain in the output buffer.| net/WebSocketHandler.hpp:793
Jun 06 10:42:04 myhost coolwsd[2629394]: wsd-2629394-2629422 2022-06-06 10:42:04.061729 -0400 [ websrv_poll ] ERR  #32: attempted to remove: 999 which is > size: 0 clamped to 0| net/Socket.hpp:1224
Jun 06 10:42:04 myhost coolwsd[2629394]: wsd-2629394-2629422 2022-06-06 10:42:04.061742 -0400 [ websrv_poll ] WRN  Ignoring attempted read from 32| net/Socket.hpp:1102
Jun 06 10:42:04 myhost coolwsd[2629394]: wsd-2629394-2629422 2022-06-06 10:42:04.062285 -0400 [ websrv_poll ] ERR  #32 Error while handling poll at 0 in websrv_poll: #32BIO error: 337690831, rc: -1: error:1420C0CF:SSL routines:ssl_write_internal:protocol is shutdown:
Jun 06 10:42:04 myhost coolwsd[2629394]: 140510303516416:error:1420C0CF:SSL routines:ssl_write_internal:protocol is shutdown:../ssl/ssl_lib.c:1935:
Jun 06 10:42:04 myhost coolwsd[2629394]: | net/Socket.cpp:450
Jun 06 10:42:04 myhost coolwsd[2629394]: wsd-2629394-2629407 2022-06-06 10:42:04.519873 -0400 [ prisoner_poll ] WRN  Prisoner connection disconnected but without valid socket.| wsd/COOLWSD.cpp:3079
Jun 06 10:42:04 myhost coolwsd[2629394]: wsd-2629394-2629407 2022-06-06 10:42:04.519905 -0400 [ prisoner_poll ] WRN  Prisoner connection disconnected but without valid socket.| wsd/COOLWSD.cpp:3079
Jun 06 10:42:04 myhost coolwsd[2629394]: wsd-2629394-2631483 2022-06-06 10:42:04.620991 -0400 [ docbroker_005 ] ERR  No acceptable WOPI hosts found matching the target host [myhostname.org] in config.| wsd/Storage.cpp:259
Jun 06 10:42:04 myhost coolwsd[2629394]: wsd-2629394-2631483 2022-06-06 10:42:04.621050 -0400 [ docbroker_005 ] ERR  loading document exception: No acceptable WOPI hosts found matching the target host [myhostname.org] in config.| wsd/DocumentBroker.cpp:2216
Jun 06 10:42:04 myhost coolwsd[2629394]: wsd-2629394-2631483 2022-06-06 10:42:04.621067 -0400 [ docbroker_005 ] ERR  Failed to add session to [https://myhostname.org:443/index.php/apps/richdocuments/wopi/files/<mydocumentstring>] with URI [https://myhostname.org/index.php/apps/richdocuments/wopi/files/<mydocumentstring>?access_token=ZQkJJ2Zc9XhNSbcvQbAELOSRciFmO2Uk&access_token_ttl=0&permission=edit]: No acceptable WOPI hosts found matching the target host [myhostname.org] in config.| wsd/DocumentBroker.cpp:2178
Jun 06 10:42:04 myhost coolwsd[2629394]: wsd-2629394-2631483 2022-06-06 10:42:04.621083 -0400 [ docbroker_005 ] ERR  Unauthorized Request while starting session on https://myhostname.org:443/index.php/apps/richdocuments/wopi/files/<mydocumentstring> for socket #21. Terminating connection. Error: No acceptable WOPI hosts found matching the target host [myhostname.org] in config.| wsd/COOLWSD.cpp:4394
Jun 06 10:42:04 myhost coolwsd[2629394]: wsd-2629394-2631483 2022-06-06 10:42:04.621160 -0400 [ docbroker_005 ] WRN  Ignoring attempted read from 21| net/Socket.hpp:1102
Jun 06 10:42:04 myhost coolwsd[2629394]: wsd-2629394-2631483 2022-06-06 10:42:04.621179 -0400 [ docbroker_005 ] ERR  Invalid or unknown session [014] to remove.| wsd/DocumentBroker.cpp:2261

My next step is to load the prior version 21.06.29-1 as I have all the debs cached and see if that fixes anything. I’m hoping I can change something in my coolwsd.xml to try to fix this.

Let me know what other information I can provide.

2

@jimbolaya thanks for reporting
can you share your WOPI config from coolwsd.xml ?

3 
                <wopi allow="true" desc="Allow/deny wopi storage. Mutually exclusive with webdav.">
                        <host allow="true" desc="Regex pattern of hostname to allow or deny.">localhost</host>
                        <host allow="false" desc="Regex pattern of hostname to allow or deny.">10\.[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}</host>
                        <host allow="false" desc="Regex pattern of hostname to allow or deny.">172\.1[6789]\.[0-9]{1,3}\.[0-9]{1,3}</host>
                        <host allow="false" desc="Regex pattern of hostname to allow or deny.">172\.2[0-9]\.[0-9]{1,3}\.[0-9]{1,3}</host>
                        <host allow="false" desc="Regex pattern of hostname to allow or deny.">172\.3[01]\.[0-9]{1,3}\.[0-9]{1,3}</host>
                        <host allow="false" desc="Regex pattern of hostname to allow or deny.">192\.168\.[0-9]{1,3}\.[0-9]{1,3}</host>
                        <host allow="true" desc="Regex pattern of hostname to allow or deny.">192\.168\.40\.[0-9]{1,3}</host>
                        <host allow="false" desc="Regex pattern of hostname to allow or deny.">192\.168\.1\.1</host>
                        <max_file_size desc="Maximum document size in bytes to load. 0 for unlimited." type="uint">0</max_file_size>
                        <reuse_cookies default="false" desc="When enabled, cookies from the browser will be captured and set on WOPI requests." type="bool">false</reuse_cookies>
                        <locking desc="Locking settings">
                                <refresh default="900" desc="How frequently we should re-acquire a lock with the storage server, in seconds (default 15 mins) or 0 for no refresh" type="int">900</refresh>
                        </locking>
                        <alias_groups desc="default mode is 'first' it allows only the first host when groups are not defined. set mode to 'groups' and define group to allow multiple host and its aliases" mode="first">
                                <!-- If you need to use multiple wopi hosts, please change the mode to "groups" and
                                add the hosts below.  If one host is accessible under multiple ip addresses
                                or names, add them as aliases. -->
                                <!--<group>
                                <host desc="hostname to allow or deny." allow="true">scheme://hostname:port</host>
                                <alias desc="regex pattern of aliasname">scheme://aliasname1:port</alias>
                                <alias desc="regex pattern of aliasname">scheme://aliasname2:port</alias>
                        </group>-->
                                <!-- More "group"s possible here -->
                        </alias_groups>
                </wopi>

It’s mostly the default as comes in from the dpkg, but I’ve added

<host allow="true" desc="Regex pattern of hostname to allow or deny.">192\.168\.40\.[0-9]{1,3}</host>

For my local network