Re: Kolab + Collabora?

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):

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

Collabora's log is like this:

Sep 27 02:30:40 mail.mydomain.com 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
Sep 27 02:30:40 mail.mydomain.com 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
Sep 27 02:30:40 mail.mydomain.com 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 [
https://mail.mydomain.com/chwala/api/wopi/files/w-OEA7dCZ70b5mV7XW?access_token=qj9F61I8tA7PRPmsd0Vi5gIGTj&access_token_ttl=1569555038000&permission=edit]:
WOPI::CheckFileInfo failed| wsd/DocumentBroker.cpp:1120
Sep 27 02:30:40 mail.mydomain.com 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=
https://mail.mydomain.com/chwala/api/wopi/files/w-OEA7dCZ70b5mV7XW?access_token=qj9F61I8tA7PRPmsd0Vi5gIGTj&access_token_ttl=1569555038000&permission=edit
readonly=0 lang=en-US| wsd/DocumentBroker.cpp:1770
Sep 27 02:30:40 mail.mydomain.com 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
Sep 27 02:30:41 mail.mydomain.com 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
Sep 27 02:30:41 mail.mydomain.com 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

So, Collabora cannot get back the document that should be opened.

How to make sure this is done correctly?

My Chwala related config in nginx looks like this:

    ##
    ## Chwala
    ##
    #location /chwala/api {
    #    rewrite ^/chwala/api/wopi/(.*)$
/chwala/api/index.php?wopi=1&method=$1 break;
    #    }

    location /chwala {
        index index.php;
        alias /usr/share/chwala/public_html;
        try_files $uri $uri/ @chwala-api;

        client_max_body_size 100M; # set maximum upload size

        # enable php
        location ~ .php$ {
            include fastcgi_params;
            fastcgi_param HTTPS on;
            fastcgi_pass
unix:/var/run/php-fpm/mail.ifi-experience.com_chwala.sock;
            fastcgi_param SCRIPT_FILENAME $request_filename;
            # Without this, PHPSESSION is replaced by webadmin-api
X-Session-Token
            fastcgi_param PHP_VALUE "session.auto_start=0
                session.use_cookies=0";
            fastcgi_pass_header X-Session-Token;
        }
    }
    location @chwala-api {
        rewrite ^/api/wopi/(.*)$ /api/index.php?wopi=1&method=$1 break;
        rewrite ^/api/document/(.*)$ /api/index.php?method=document&id=$1
break;
    }

And my roundcube config is like this now:

   // WOPI/Office service URL. Enables use of collaborative editor
supporting WOPI.
    // Note: this URL should be accessible from Chwala host and Roundcube
host as well.
    $config['fileapi_wopi_office'] = 'https://office.ifi-experience.com/';

    // Kolab WOPI service URL. Enables use of collaborative editor
supporting WOPI.
    // Note: this URL should be accessible from Chwala host and Office host
as well.
    $config['fileapi_wopi_service'] = '
https://mail.ifi-experience.com/chwala/api/';

    $config['kolab_files_url'] = '/chwala/';
    $config['file_api_url'] = '/chwala/api/';

Any help or hint appreciated!

On Thu, Sep 26, 2019 at 2:34 PM Milan Petrovic <[email protected]>
wrote:

> Alexander, thanks a lot for the help!
>
> 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.
>
> 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.
>
> 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):
> '''
>     location /chwala {
>         index index.php;
>         alias /usr/share/chwala/public_html;
>
>         client_max_body_size 100M; # set maximum upload size
>
>         # enable php
>         location ~ .php$ {
>             include fastcgi_params;
>             fastcgi_param HTTPS on;
>             fastcgi_pass
> unix:/var/run/php-fpm/mail.mydomain.com_chwala.sock;
>             fastcgi_param SCRIPT_FILENAME $request_filename;
>             # Without this, PHPSESSION is replaced by webadmin-api
> X-Session-Token
>             fastcgi_param PHP_VALUE "session.auto_start=0
>                 session.use_cookies=0";
>             fastcgi_pass_header X-Session-Token;
>         }
>         location /chwala/api {
>             rewrite ^/chwala/api/wopi/(.*)$
> /chwala/api/index.php?wopi=1&method=$1 break;
>         }
>     }
> '''
> loolwsd service throws the following:
>
> Sep 26 14:25:23 mail.mydomain.com 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
> Sep 26 14:25:23 mail.mydomain.com 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
> Sep 26 14:25:23 mail.mydomain.com 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 [
> https://mail.mydomain.com/chwala/api/wopi/files/w-OEA7dCZ70b5mV7XW?access_token=HCMTvTP7oh3xXOrLpeyvwslKSR&access_token_ttl=1569511521000&permission=edit]:
> WOPI::CheckFileInfo failed| wsd/DocumentBroker.cpp:1120
> Sep 26 14:25:23 mail.mydomain.com 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=
> https://mail.mydomain.com/chwala/api/wopi/files/w-OEA7dCZ70b5mV7XW?access_token=HCMTvTP7oh3xXOrLpeyvwslKSR&access_token_ttl=1569511521000&permission=edit
> readonly=0 lang=en-US| wsd/DocumentBroker.cpp:1770
> Sep 26 14:25:23 mail.mydomain.com 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
> Sep 26 14:25:24 mail.mydomain.com 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
> Sep 26 14:25:24 mail.mydomain.com 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
>
> Also, my "fileapi_wopi_service" and "file_api_url" are the same, not sure
> if that should be the case:
>
>     $config['fileapi_wopi_service'] = '
> https://mail.ifi-experience.com/chwala/api';
>
>     $config['file_api_url'] = 'https://mail.ifi-experience.com/chwala/api
> ';
>
>
>
> On Thu, Sep 26, 2019 at 7:40 AM Aleksander Machniak <[email protected]>
> wrote:
>
>> On 9/25/19 1:01 PM, Milan Petrovic wrote:
>> > Anyone?
>> > Any hint?
>>
>> In recent Kolab you don't need kolab-wopi, it has been replaced by code
>> built into chwala.
>>
>> I never used CODE, but I work with collabora official (partner) packages.
>>
>> 1. You have to configure chwala to talk to collabora
>>
>> // WOPI/Office service URL. Enables use of collaborative editor
>> supporting WOPI.
>> // Note: this URL should be accessible from Chwala host and Roundcube
>> host as well.
>> $config['fileapi_wopi_office'] = null;
>>
>> You need also this rule in http server:
>>
>> RewriteRule ^api/wopi/(.*)$ api/index.php?wopi=1&method=$1 [L,QSA]
>>
>> 2. You have to configure collabora to allow Chwala host.
>>
>> That's it. Note that Roundcube (kolab_files plugin) is talking to chwala.
>> Chwala is
>> talking to Collabora. Collabora is talking to Chwala. User browser is
>> talking to
>> Roundcube, Chwala and Collabora.
>>
>> That's why it is important to carefully setup DNS so hostnames are
>> resolvable properly on
>> server as well as on client-side. Also, be carefull with ssl certificates
>> and
>> cross-domain, etc. Look for errors on server (Roundcube, Chwala,
>> Collabora), but also in
>> the web browser console.
>>
>> Also note that some chwala capabilities are cached in session, so you
>> sometimes have to
>> re-login in Roundcube to notice changes. You may also unset
>> $config['fileapi_cache'] while
>> debugging.
>>
>> --
>> Aleksander Machniak
>> Senior Software Engineer
>> Kolab Systems AG: https://kolabsystems.com
>> PGP: 19359DC1
>> _______________________________________________
>> users mailing list
>> [email protected]
>> https://lists.kolab.org/mailman/listinfo/users
>>
>

_______________________________________________
users mailing list
[email protected]
https://lists.kolab.org/mailman/listinfo/users