<div dir="ltr"><div>I have found that the following URL is being the issue for the document opening process (office* is Collabora's subdomain, and mail* Kolab's): <br></div><div><br></div><div><a href="https://office.mydomain.com/lool/https://mail.mydomain.com/chwala/api/wopi/files/w-OEA7dCZ70b5mV7XW?access_token=AuopF7kr4dCWXfECOcQ6j7yVt5&access_token_ttl=1569548237000&permission=edit/ws?WOPISrc=https://mail.mydomain.com/chwala/api/wopi/files/w-OEA7dCZ70b5mV7XW&compat=/ws">https://office.mydomain.com/lool/https://mail.mydomain.com/chwala/api/wopi/files/w-OEA7dCZ70b5mV7XW?access_token=AuopF7kr4dCWXfECOcQ6j7yVt5&access_token_ttl=1569548237000&permission=edit/ws?WOPISrc=https://mail.mydomain.com/chwala/api/wopi/files/w-OEA7dCZ70b5mV7XW&compat=/ws</a></div><div><br></div><div>Collabora's log is like this:</div><div><br></div><div>Sep 27 02:30:40 <a href="http://mail.mydomain.com">mail.mydomain.com</a> loolwsd[7108]: wsd-07108-11171 2019-09-27 00:30:40.149310 [ docbroker_012 ] ERR WOPI::CheckFileInfo failed with 404 Not Found| wsd/Storage.cpp:495<br>Sep 27 02:30:40 <a href="http://mail.mydomain.com">mail.mydomain.com</a> loolwsd[7108]: wsd-07108-11171 2019-09-27 00:30:40.149447 [ docbroker_012 ] ERR loading document exception: WOPI::CheckFileInfo failed| wsd/DocumentBroker.cpp:1158<br>Sep 27 02:30:40 <a href="http://mail.mydomain.com">mail.mydomain.com</a> loolwsd[7108]: wsd-07108-11171 2019-09-27 00:30:40.149471 [ docbroker_012 ] ERR Failed to add session to [/chwala/api/wopi/files/w-OEA7dCZ70b5mV7XW] with URI [<a href="https://mail.mydomain.com/chwala/api/wopi/files/w-OEA7dCZ70b5mV7XW?access_token=qj9F61I8tA7PRPmsd0Vi5gIGTj&access_token_ttl=1569555038000&permission=edit">https://mail.mydomain.com/chwala/api/wopi/files/w-OEA7dCZ70b5mV7XW?access_token=qj9F61I8tA7PRPmsd0Vi5gIGTj&access_token_ttl=1569555038000&permission=edit</a>]: WOPI::CheckFileInfo failed| wsd/DocumentBroker.cpp:1120<br>Sep 27 02:30:40 <a href="http://mail.mydomain.com">mail.mydomain.com</a> loolwsd[7108]: wsd-07108-11171 2019-09-27 00:30:40.226632 [ docbroker_012 ] WRN Child session [0145] not found to forward message: load url=<a href="https://mail.mydomain.com/chwala/api/wopi/files/w-OEA7dCZ70b5mV7XW?access_token=qj9F61I8tA7PRPmsd0Vi5gIGTj&access_token_ttl=1569555038000&permission=edit">https://mail.mydomain.com/chwala/api/wopi/files/w-OEA7dCZ70b5mV7XW?access_token=qj9F61I8tA7PRPmsd0Vi5gIGTj&access_token_ttl=1569555038000&permission=edit</a> readonly=0 lang=en-US| wsd/DocumentBroker.cpp:1770<br>Sep 27 02:30:40 <a href="http://mail.mydomain.com">mail.mydomain.com</a> loolwsd[7108]: wsd-07108-11171 2019-09-27 00:30:40.236437 [ docbroker_012 ] ERR Invalid or unknown session [0145] to remove.| wsd/DocumentBroker.cpp:1194<br>Sep 27 02:30:41 <a href="http://mail.mydomain.com">mail.mydomain.com</a> loolwsd[7108]: wsd-07108-07114 2019-09-27 00:30:41.150687 [ prisoner_poll ] WRN Prisoner connection disconnected but without valid socket.| wsd/LOOLWSD.cpp:1799<br>Sep 27 02:30:41 <a href="http://mail.mydomain.com">mail.mydomain.com</a> loolwsd[7108]: kit-11079-07115 2019-09-27 00:30:41.150798 [ loolkit ] WRN Kit connection lost without exit arriving from wsd. Setting TerminationFlag| kit/Kit.cpp:2241</div><div><br></div><div>So, Collabora cannot get back the document that should be opened.</div><div><br></div><div>How to make sure this is done correctly?</div><div><br></div><div>My Chwala related config in nginx looks like this:</div><div><br></div><div> ##<br> ## Chwala<br> ##<br> #location /chwala/api {<br> # rewrite ^/chwala/api/wopi/(.*)$ /chwala/api/index.php?wopi=1&method=$1 break;<br> # }<br><br> location /chwala {<br> index index.php;<br> alias /usr/share/chwala/public_html;<br> try_files $uri $uri/ @chwala-api;<br><br> client_max_body_size 100M; # set maximum upload size<br><br> # enable php<br> location ~ .php$ {<br> include fastcgi_params;<br> fastcgi_param HTTPS on;<br> fastcgi_pass unix:/var/run/php-fpm/mail.ifi-experience.com_chwala.sock;<br> fastcgi_param SCRIPT_FILENAME $request_filename;<br> # Without this, PHPSESSION is replaced by webadmin-api X-Session-Token<br> fastcgi_param PHP_VALUE "session.auto_start=0<br> session.use_cookies=0";<br> fastcgi_pass_header X-Session-Token;<br> }<br> }<br> location @chwala-api {<br> rewrite ^/api/wopi/(.*)$ /api/index.php?wopi=1&method=$1 break;<br> rewrite ^/api/document/(.*)$ /api/index.php?method=document&id=$1 break;</div><div> }</div><div><br></div><div>And my roundcube config is like this now:</div><div><br></div><div> // WOPI/Office service URL. Enables use of collaborative editor supporting WOPI.<br> // Note: this URL should be accessible from Chwala host and Roundcube host as well.<br> $config['fileapi_wopi_office'] = '<a href="https://office.ifi-experience.com/">https://office.ifi-experience.com/</a>';<br><br> // Kolab WOPI service URL. Enables use of collaborative editor supporting WOPI.<br> // Note: this URL should be accessible from Chwala host and Office host as well.<br> $config['fileapi_wopi_service'] = '<a href="https://mail.ifi-experience.com/chwala/api/">https://mail.ifi-experience.com/chwala/api/</a>';<br><br> $config['kolab_files_url'] = '/chwala/';<br> $config['file_api_url'] = '/chwala/api/';</div><div><br></div><div>Any help or hint appreciated!<br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Thu, Sep 26, 2019 at 2:34 PM Milan Petrovic <<a href="mailto:petrovic.milan@gmail.com">petrovic.milan@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div>Alexander, thanks a lot for the help!</div><div><br></div><div>I have found that I had the wrong $config['fileapi_wopi_office'] set. I don't need the /hosting/discovery at the end of the URL. just the Collabora's host name.</div><div><br></div><div>Now the editor opens (although, it looks like from the Manticore times), but theerror is thrown that the file cannot be found ("Failed to read document from storage"). So, I guess my Chwala settings should be somehow updated.</div><div><br></div><div>I have put the rewrite rule (I'm using nginx, all of the Kolab is on the same subdomain, Collabora uses another, both are on the same host):</div><div>'''<br></div><div> location /chwala {<br> index index.php;<br> alias /usr/share/chwala/public_html;<br><br> client_max_body_size 100M; # set maximum upload size<br><br> # enable php<br> location ~ .php$ {<br> include fastcgi_params;<br> fastcgi_param HTTPS on;<br> fastcgi_pass unix:/var/run/php-fpm/mail.mydomain.com_chwala.sock;<br> fastcgi_param SCRIPT_FILENAME $request_filename;<br> # Without this, PHPSESSION is replaced by webadmin-api X-Session-Token<br> fastcgi_param PHP_VALUE "session.auto_start=0<br> session.use_cookies=0";<br> fastcgi_pass_header X-Session-Token;<br> }<br> location /chwala/api {<br> rewrite ^/chwala/api/wopi/(.*)$ /chwala/api/index.php?wopi=1&method=$1 break;<br> }<br> }</div><div>'''<br></div><div>loolwsd service throws the following:</div><div><br></div><div>Sep 26 14:25:23 <a href="http://mail.mydomain.com" target="_blank">mail.mydomain.com</a> loolwsd[4957]: wsd-04957-09382 2019-09-26 12:25:23.157369 [ docbroker_019 ] ERR WOPI::CheckFileInfo failed with 500 Internal Server Error| wsd/Storage.cpp:495<br>Sep 26 14:25:23 <a href="http://mail.mydomain.com" target="_blank">mail.mydomain.com</a> loolwsd[4957]: wsd-04957-09382 2019-09-26 12:25:23.158112 [ docbroker_019 ] ERR loading document exception: WOPI::CheckFileInfo failed| wsd/DocumentBroker.cpp:1158<br>Sep 26 14:25:23 <a href="http://mail.mydomain.com" target="_blank">mail.mydomain.com</a> loolwsd[4957]: wsd-04957-09382 2019-09-26 12:25:23.158135 [ docbroker_019 ] ERR Failed to add session to [/chwala/api/wopi/files/w-OEA7dCZ70b5mV7XW] with URI [<a href="https://mail.mydomain.com/chwala/api/wopi/files/w-OEA7dCZ70b5mV7XW?access_token=HCMTvTP7oh3xXOrLpeyvwslKSR&access_token_ttl=1569511521000&permission=edit" target="_blank">https://mail.mydomain.com/chwala/api/wopi/files/w-OEA7dCZ70b5mV7XW?access_token=HCMTvTP7oh3xXOrLpeyvwslKSR&access_token_ttl=1569511521000&permission=edit</a>]: WOPI::CheckFileInfo failed| wsd/DocumentBroker.cpp:1120<br>Sep 26 14:25:23 <a href="http://mail.mydomain.com" target="_blank">mail.mydomain.com</a> loolwsd[4957]: wsd-04957-09382 2019-09-26 12:25:23.270254 [ docbroker_019 ] WRN Child session [01b0] not found to forward message: load url=<a href="https://mail.mydomain.com/chwala/api/wopi/files/w-OEA7dCZ70b5mV7XW?access_token=HCMTvTP7oh3xXOrLpeyvwslKSR&access_token_ttl=1569511521000&permission=edit" target="_blank">https://mail.mydomain.com/chwala/api/wopi/files/w-OEA7dCZ70b5mV7XW?access_token=HCMTvTP7oh3xXOrLpeyvwslKSR&access_token_ttl=1569511521000&permission=edit</a> readonly=0 lang=en-US| wsd/DocumentBroker.cpp:1770<br>Sep 26 14:25:23 <a href="http://mail.mydomain.com" target="_blank">mail.mydomain.com</a> loolwsd[4957]: wsd-04957-09382 2019-09-26 12:25:23.289352 [ docbroker_019 ] ERR Invalid or unknown session [01b0] to remove.| wsd/DocumentBroker.cpp:1194<br>Sep 26 14:25:24 <a href="http://mail.mydomain.com" target="_blank">mail.mydomain.com</a> loolwsd[4957]: wsd-04957-04963 2019-09-26 12:25:24.159340 [ prisoner_poll ] WRN Prisoner connection disconnected but without valid socket.| wsd/LOOLWSD.cpp:1799<br>Sep 26 14:25:24 <a href="http://mail.mydomain.com" target="_blank">mail.mydomain.com</a> loolwsd[4957]: kit-09330-04964 2019-09-26 12:25:24.159425 [ loolkit ] WRN Kit connection lost without exit arriving from wsd. Setting TerminationFlag| kit/Kit.cpp:2241</div><div><br></div><div>Also, my "fileapi_wopi_service" and "file_api_url" are the same, not sure if that should be the case:</div><div><br></div><div> $config['fileapi_wopi_service'] = '<a href="https://mail.ifi-experience.com/chwala/api" target="_blank">https://mail.ifi-experience.com/chwala/api</a>';<br><br> $config['file_api_url'] = '<a href="https://mail.ifi-experience.com/chwala/api" target="_blank">https://mail.ifi-experience.com/chwala/api</a>';</div><div><br></div><div><br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Thu, Sep 26, 2019 at 7:40 AM Aleksander Machniak <<a href="mailto:machniak@kolabsys.com" target="_blank">machniak@kolabsys.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">On 9/25/19 1:01 PM, Milan Petrovic wrote:<br>
> Anyone?<br>
> Any hint?<br>
<br>
In recent Kolab you don't need kolab-wopi, it has been replaced by code built into chwala.<br>
<br>
I never used CODE, but I work with collabora official (partner) packages.<br>
<br>
1. You have to configure chwala to talk to collabora<br>
<br>
// WOPI/Office service URL. Enables use of collaborative editor supporting WOPI.<br>
// Note: this URL should be accessible from Chwala host and Roundcube host as well.<br>
$config['fileapi_wopi_office'] = null;<br>
<br>
You need also this rule in http server:<br>
<br>
RewriteRule ^api/wopi/(.*)$ api/index.php?wopi=1&method=$1 [L,QSA]<br>
<br>
2. You have to configure collabora to allow Chwala host.<br>
<br>
That's it. Note that Roundcube (kolab_files plugin) is talking to chwala. Chwala is<br>
talking to Collabora. Collabora is talking to Chwala. User browser is talking to<br>
Roundcube, Chwala and Collabora.<br>
<br>
That's why it is important to carefully setup DNS so hostnames are resolvable properly on<br>
server as well as on client-side. Also, be carefull with ssl certificates and<br>
cross-domain, etc. Look for errors on server (Roundcube, Chwala, Collabora), but also in<br>
the web browser console.<br>
<br>
Also note that some chwala capabilities are cached in session, so you sometimes have to<br>
re-login in Roundcube to notice changes. You may also unset $config['fileapi_cache'] while<br>
debugging.<br>
<br>
-- <br>
Aleksander Machniak<br>
Senior Software Engineer<br>
Kolab Systems AG: <a href="https://kolabsystems.com" rel="noreferrer" target="_blank">https://kolabsystems.com</a><br>
PGP: 19359DC1<br>
_______________________________________________<br>
users mailing list<br>
<a href="mailto:users@lists.kolab.org" target="_blank">users@lists.kolab.org</a><br>
<a href="https://lists.kolab.org/mailman/listinfo/users" rel="noreferrer" target="_blank">https://lists.kolab.org/mailman/listinfo/users</a><br>
</blockquote></div>
</blockquote></div>