OwnCloud with collabora online : token 999.. does not exist

I’ve managed to get collabora online working with owncloud and can readily use the office functionality when connected to wifi using ubuntu windows10 and android.

But when trying to edit online with 3g and sometimes on wifi outside my LAN, the loading of chosen files is frozen (spinner then sad face page icon).

I’m guessing there is a time limit setting somewhere but cannot see in any debug logs.

Can anyone guide me how to debug a little further?

Expected behaviour

On LAN, wifi or 3g I expect same functionality when using online editing i.e. click file, shows ‘connecting’ and few seconds later able to edit online.

Actual behaviour

When using 3g and sometimes external wifi depending on browser and if choose desktop site the documents fail to load, after many seconds of spinner get sad face icon.

Steps to reproduce

  1. using smartphone or table turn off wifi, reload oc page, document
  2. sometimes requesting desktop site works
  3. putting logs to debug still doesn’t produce clear errors

Server configuration

owncloud
Operating system: Raspbian stretch
Web server: Apache/2.4.25 (Raspbian)
Database: 10.1.38-MariaDB-0+deb9u1 - Raspbian 9.0
PHP version: PHP version:7.2.26-1+0~20191218.33+debian9~1.gbpb5a34b
ownCloud version: 10.2.1.4

Storage backend (external storage):
Here I put the domain server running CODE
Collabora online CODE loolwsd 4.2.0 on Ubuntu 18.04 with collobrora office 6.2.3

Client configuration

various smartphones, tablets PC with various browsers used chrome, mozilla, opera, midori, IE

Logs

  1. Web server error log:
  2. Server logfile: ownCloud log (data/owncloud.log):

The apache2, nginx and loolwsd logs don’t reveal errors just info and but owncloud appears to show a token issue extracted below which doesn’t appear if I’m using wifi:

{“reqId”:“J3Dia1ek9plZeSHwUhN4”,“level”:0,“time”:“2020-01-23T13:32:11+01:00”,“remoteAddr”:“192.168.1.173”,“user”:“Andrew”,“app”:“OC\User\Session::validateToken”,“method”:“GET”,“url”:"/owncloud/index.php/avatar/Andrew/64",“message”:“token 912db5d8b14a2ba68bcab2e6263956783f0aef43598d384ef71489cc37892acb627c438bd5997799a854e6c38bfe8eb0089e67b0c1584c4175a8c842532fec43 with token id 35509 found, validating”}
{“reqId”:“39ff6056-ff25-4294-bc15-72402a1338dd”,“level”:0,“time”:“2020-01-23T13:32:20+01:00”,“remoteAddr”:“192.168.1.173”,“user”:“pi”,“app”:“OC\Authentication\Token\DefaultTokenProvider::updateToken”,“method”:“PROPFIND”,“url”:"/owncloud/remote.php/dav/files/pi/",“message”:“updating token 35362, last check is now 1579188116”}
{“reqId”:“39ff6056-ff25-4294-bc15-72402a1338dd”,“level”:0,“time”:“2020-01-23T13:32:20+01:00”,“remoteAddr”:“192.168.1.173”,“user”:“pi”,“app”:“OC\Authentication\Token\DefaultTokenProvider::getToken”,“method”:“PROPFIND”,“url”:"/owncloud/remote.php/dav/files/pi/",“message”:“token 1ef28e85e167b6846c26328a66d408b02f17bfd84c475ccb6de09d0c311fce9c43f541a1c09a145f525dcc506812f5192b41688ca2704ec4479c711218879820 does not exist”}
{“reqId”:“053b3619-cd97-4c28-bf36-ac6d73cfbb89”,“level”:0,“time”:“2020-01-23T13:32:24+01:00”,“remoteAddr”:“192.168.1.173”,“user”:“Andrew”,“app”:“OC\Authentication\Token\DefaultTokenProvider::updateToken”,“method”:“PROPFIND”,“url”:"/owncloud/remote.php/dav/files/Andrew/",“message”:“updating token 35504, last check is now 1579766449”}
{“reqId”:“053b3619-cd97-4c28-bf36-ac6d73cfbb89”,“level”:0,“time”:“2020-01-23T13:32:24+01:00”,“remoteAddr”:“192.168.1.173”,“user”:“Andrew”,“app”:“OC\Authentication\Token\DefaultTokenProvider::getToken”,“method”:“PROPFIND”,“url”:"/owncloud/remote.php/dav/files/Andrew/",“message”:“token 7567186c4ec5e2abb7cb5eef3d12366cedbc18ffef3672f365f60c4cbb6ad5a65feff4e7b099bb8861c156d6cd0b7452fdfedeaa177592b2fe4d61576484d49e does not exist”}
{“reqId”:“b85e6fdc-8879-44e8-9c68-b39d24e41e31”,“level”:0,“time”:“2020-01-23T13:32:33+01:00”,“remoteAddr”:“192.168.1.173”,“user”:“pi”,“app”:“OC\Authentication\Token\DefaultTokenProvider::updateToken”,“method”:“PROPFIND”,“url”:"/owncloud/remote.php/dav/files/pi/",“message”:“updating token 35362, last check is now 1579188116”}
{“reqId”:“b85e6fdc-8879-44e8-9c68-b39d24e41e31”,“level”:0,“time”:“2020-01-23T13:32:33+01:00”,“remoteAddr”:“192.168.1.173”,“user”:“pi”,“app”:“OC\Authentication\Token\DefaultTokenProvider::getToken”,“method”:“PROPFIND”,“url”:"/owncloud/remote.php/dav/files/pi/",“message”:“token 1ef28e85e167b6846c26328a66d408b02f17bfd84c475ccb6de09d0c311fce9c43f541a1c09a145f525dcc506812f5192b41688ca2704ec4479c711218879820 does not exist”}
{“reqId”:“9200ad2d-a3a8-448d-b31e-029c333c2fd5”,“level”:0,“time”:“2020-01-23T13:32:42+01:00”,“remoteAddr”:“192.168.1.173”,“user”:“Andrew”,“app”:“OC\Authentication\Token\DefaultTokenProvider::updateToken”,“method”:“PROPFIND”,“url”:"/owncloud/remote.php/dav/files/Andrew/",“message”:“updating token 35504, last check is now 1579766449”}
{“reqId”:“9200ad2d-a3a8-448d-b31e-029c333c2fd5”,“level”:0,“time”:“2020-01-23T13:32:42+01:00”,“remoteAddr”:“192.168.1.173”,“user”:“Andrew”,“app”:“OC\Authentication\Token\DefaultTokenProvider::getToken”,“method”:“PROPFIND”,“url”:"/owncloud/remote.php/dav/files/Andrew/",“message”:“token 7567186c4ec5e2abb7cb5eef3d12366cedbc18ffef3672f365f60c4cbb6ad5a65feff4e7b099bb8861c156d6cd0b7452fdfedeaa177592b2fe4d61576484d49e does not exist”}

Is your Collabora instance accessible outside of your LAN? It needs to be. Otherwise, it will not work.
You can check that by accessing the URL https://hostname.example.com:9980/hosting/discovery (adapted to your environment).

2 Likes

Thanks Cornelius,

I wanted to respond “yes” immediately but on checking the /discovery URL outside LAN it fails as does the collabora admin URL!

It does appear to work without port i.e. curl https://url/hosting/discovery/

So back to router/nginx debug.

Anyhow I just checked:-

  1. router port forwards 9980 to main oc server
  2. ufw is open on 9980
  3. oc server is not listening on 9980 (expected since I reverse provy to 9980 on collabora server)
  4. collabora server is listening on *:9980, (no firewall ufw)
  5. external curl and traceroute on both servers root URL works, but not port 9980
  6. proxy-pass is working since I can curl the django backend server URL server port 8001 which is only open on backend.

I can’t identify what blocks 9980

I have open question on nginx forum. since I suspected I need both nginx servers duplicating the collabora reverse proxy stanzas even though it doesn’t make sense to me.

SOLVED
:blush:

So hidden in my router settings within the port forwarding section there is a toggle box against each rule. You guess it - 9980 was forwarded but toggled OFF

Thanks Cornelius, but sorry for false alarm.

3 Likes

Always happy to help :slight_smile: