{"action":"created","issue":{"url":"https://api.github.com/repos/nextcloud/richdocuments/issues/21","repository_url":"https://api.github.com/repos/nextcloud/richdocuments","labels_url":"https://api.github.com/repos/nextcloud/richdocuments/issues/21/labels{/name}","comments_url":"https://api.github.com/repos/nextcloud/richdocuments/issues/21/comments","events_url":"https://api.github.com/repos/nextcloud/richdocuments/issues/21/events","html_url":"https://github.com/nextcloud/richdocuments/issues/21","id":204759839,"node_id":"MDU6SXNzdWUyMDQ3NTk4Mzk=","number":21,"title":"Latest Nextcloud/Collabora cannot open documents.","user":{"login":"CodeMouse92","id":7471402,"node_id":"MDQ6VXNlcjc0NzE0MDI=","avatar_url":"https://avatars2.githubusercontent.com/u/7471402?v=4","gravatar_id":"","url":"https://api.github.com/users/CodeMouse92","html_url":"https://github.com/CodeMouse92","followers_url":"https://api.github.com/users/CodeMouse92/followers","following_url":"https://api.github.com/users/CodeMouse92/following{/other_user}","gists_url":"https://api.github.com/users/CodeMouse92/gists{/gist_id}","starred_url":"https://api.github.com/users/CodeMouse92/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/CodeMouse92/subscriptions","organizations_url":"https://api.github.com/users/CodeMouse92/orgs","repos_url":"https://api.github.com/users/CodeMouse92/repos","events_url":"https://api.github.com/users/CodeMouse92/events{/privacy}","received_events_url":"https://api.github.com/users/CodeMouse92/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":28,"created_at":"2017-02-02T01:43:22Z","updated_at":"2018-12-02T12:08:17Z","closed_at":null,"author_association":"NONE","body":"I just upgraded my Nextcloud server from 10.3 to 11.0.1, by way of 11.0. All went well, and then I updated the Collabora Office app and pulled down the latest Collabora docker...all following Nextcloud's official instructions.\r\n\r\nNow I can't open files in Collabora Office.\r\n\r\n### Steps to reproduce\r\n1. Ensure Collabora, Nextcloud, and the Collabora app are up to date. Also ensure Documents is NOT enabled.\r\n2. Try to open an .odt file via the web interface.\r\n\r\n### Expected behaviour\r\nThe document should open.\r\n\r\n### Actual behaviour\r\nOn Nextcloud, I get \"\"Well, this is embarrassing, we cannot connect to your document. Please try again.\"\r\nThis is true of *any* file I open, even a newly created one.\r\n\r\nOn the docker logs for Collabora (`sudo docker logs th3d0ck3rpr0c3ssid`), I see multiple copies of the following (with an actual token instead of [SCRUBBED], of course):\r\n\r\n```\r\nwsd-00026-0029 01:21:19.366410 [ client_req_hdl ] WRN  WOPI host did not pass optional access_token_ttl| wsd/FileServer.cpp:255\r\nwsd-00026-0030 01:21:20.182984 [ client_ws_0019 ] ERR  Unknown resource: /lool/https://nextcloud.mousepawmedia.net/index.php/apps/richdocuments/wopi/files/1694_ock4jvyh706l%3Faccess_token=[SCRUBBED]&access_token_ttl=0&permission=edit/ws| wsd/LOOLWSD.cpp:1223\r\n```\r\n\r\n### Server configuration\r\n**Operating system**:Ubuntu 16.04 LTS 64-bit Server\r\n\r\n**Web server:** LAMP\r\n\r\n**Database:** `mysql  Ver 14.14 Distrib 5.7.17, for Linux (x86_64)`\r\n\r\n**PHP version:** `PHP 5.6.30-1+deb.sury.org~xenial+1 (cli)`\r\n\r\n**Nextcloud version:** 11.0.1\r\n\r\n**Updated from an older Nextcloud/ownCloud or fresh install:** Updated from 11.0, which itself was a manual update from 10.3.\r\n\r\n**Where did you install Nextcloud from:**  Manual install from .ZIP originally, automatic updates to 10.3. (Everything worked to this point.) Manual upgrade from .zip for 10.3 -> 11.0.0. Automatic upgrade tool for 11.0.0 -> 11.0.1.\r\n\r\n**Signing status:**\r\n<details>\r\n<summary>Signing status</summary>\r\n\r\n```\r\nNo errors have been found.\r\n```\r\n</details>\r\n\r\n**List of activated apps:**\r\n<details>\r\n<summary>App list</summary>\r\n\r\n```\r\nEnabled:\r\n  - activity: 2.4.1\r\n  - admin_audit: 1.1.0\r\n  - apporder: 0.3.3\r\n  - comments: 1.1.0\r\n  - dav: 1.1.1\r\n  - federatedfilesharing: 1.1.1\r\n  - files: 1.6.1\r\n  - files_accesscontrol: 1.1.2\r\n  - files_pdfviewer: 1.0.1\r\n  - files_sharing: 1.1.1\r\n  - files_texteditor: 2.2\r\n  - files_trashbin: 1.1.0\r\n  - files_versions: 1.4.0\r\n  - files_videoplayer: 1.0.0\r\n  - firstrunwizard: 2.0\r\n  - gallery: 16.0.0\r\n  - logreader: 2.0.0\r\n  - lookup_server_connector: 1.0.0\r\n  - nextcloud_announcements: 1.0\r\n  - notifications: 1.0.1\r\n  - password_policy: 1.1.0\r\n  - provisioning_api: 1.1.0\r\n  - richdocuments: 1.1.25\r\n  - serverinfo: 1.1.1\r\n  - sharebymail: 1.0.1\r\n  - survey_client: 0.1.5\r\n  - systemtags: 1.1.3\r\n  - theming: 1.1.1\r\n  - twofactor_backupcodes: 1.0.0\r\n  - updatenotification: 1.1.1\r\n  - user_ldap: 1.1.1\r\n  - workflowengine: 1.1.1\r\nDisabled:\r\n  - bookmarks\r\n  - encryption\r\n  - external\r\n  - federation\r\n  - files_automatedtagging\r\n  - files_external\r\n  - files_retention\r\n  - templateeditor\r\n  - user_external\r\n  - user_saml\r\n```\r\n</details>\r\n\r\n**The content of config/config.php:**\r\n<details>\r\n<summary>Config report</summary>\r\n\r\n```\r\n{\r\n    \"system\": {\r\n        \"instanceid\": \"ock4jvyh706l\",\r\n        \"passwordsalt\": \"***REMOVED SENSITIVE VALUE***\",\r\n        \"secret\": \"***REMOVED SENSITIVE VALUE***\",\r\n        \"trusted_domains\": [\r\n            \"nextcloud.mousepawmedia.net\"\r\n        ],\r\n        \"datadirectory\": \"\\/opt\\/nextcloud\\/data\",\r\n        \"overwrite.cli.url\": \"https:\\/\\/nextcloud.mousepawmedia.net\",\r\n        \"dbtype\": \"mysql\",\r\n        \"version\": \"11.0.1.2\",\r\n        \"dbname\": \"nextcloud\",\r\n        \"dbhost\": \"localhost\",\r\n        \"dbport\": \"\",\r\n        \"dbtableprefix\": \"oc_\",\r\n        \"dbuser\": \"***REMOVED SENSITIVE VALUE***\",\r\n        \"dbpassword\": \"***REMOVED SENSITIVE VALUE***\",\r\n        \"logtimezone\": \"UTC\",\r\n        \"installed\": true,\r\n        \"memcache.local\": \"\\\\OC\\\\Memcache\\\\APCu\",\r\n        \"ldapIgnoreNamingRules\": false,\r\n        \"ldapProviderFactory\": \"\\\\OCA\\\\User_LDAP\\\\LDAPProviderFactory\",\r\n        \"mail_from_address\": \"hawksnest\",\r\n        \"mail_smtpmode\": \"smtp\",\r\n        \"mail_domain\": \"mousepawgames.com\",\r\n        \"mail_smtpauth\": 1,\r\n        \"mail_smtpauthtype\": \"LOGIN\",\r\n        \"mail_smtphost\": \"gator3102.hostgator.com\",\r\n        \"mail_smtpport\": \"465\",\r\n        \"mail_smtpname\": \"***REMOVED SENSITIVE VALUE***\",\r\n        \"mail_smtppassword\": \"***REMOVED SENSITIVE VALUE***\",\r\n        \"maintenance\": false,\r\n        \"mail_smtpsecure\": \"ssl\",\r\n        \"appstore.experimental.enabled\": true,\r\n        \"loglevel\": 2,\r\n        \"updater.secret\": \"***REMOVED SENSITIVE VALUE***\"\r\n    }\r\n}\r\n```\r\n</details>\r\n\r\n**Are you using external storage, if yes which one:** NO\r\n\r\n**Are you using encryption:** NO\r\n\r\n**Are you using an external user-backend, if yes which one:** LDAP\r\n\r\n#### LDAP configuration (delete this part if not used)\r\n<details>\r\n<summary>LDAP config</summary>\r\n\r\n```\r\n+-------------------------------+--------------------------------------------------------------------------------------+\r\n| Configuration                 |                                                                                      |\r\n+-------------------------------+--------------------------------------------------------------------------------------+\r\n| hasMemberOfFilterSupport      |                                                                                      |\r\n| hasPagedResultSupport         |                                                                                      |\r\n| homeFolderNamingRule          |                                                                                      |\r\n| lastJpegPhotoLookup           | 0                                                                                    |\r\n| ldapAgentName                 |                                                                                      |\r\n| ldapAgentPassword             | ***                                                                                  |\r\n| ldapAttributesForGroupSearch  |                                                                                      |\r\n| ldapAttributesForUserSearch   |                                                                                      |\r\n| ldapBackupHost                |                                                                                      |\r\n| ldapBackupPort                |                                                                                      |\r\n| ldapBase                      | ou=Users, dc=ldap, dc=mousepawmedia, dc=net                                          |\r\n| ldapBaseGroups                | ou=Groups, dc=ldap, dc=mousepawmedia, dc=net                                         |\r\n| ldapBaseUsers                 | ou=Users, dc=ldap, dc=mousepawmedia, dc=net                                          |\r\n| ldapCacheTTL                  | 600                                                                                  |\r\n| ldapConfigurationActive       | 1                                                                                    |\r\n| ldapDynamicGroupMemberURL     |                                                                                      |\r\n| ldapEmailAttribute            | mail                                                                                 |\r\n| ldapExperiencedAdmin          | 0                                                                                    |\r\n| ldapExpertUUIDGroupAttr       |                                                                                      |\r\n| ldapExpertUUIDUserAttr        |                                                                                      |\r\n| ldapExpertUsernameAttr        |                                                                                      |\r\n| ldapGroupDisplayName          | cn                                                                                   |\r\n| ldapGroupFilter               |                                                                                      |\r\n| ldapGroupFilterGroups         |                                                                                      |\r\n| ldapGroupFilterMode           | 0                                                                                    |\r\n| ldapGroupFilterObjectclass    |                                                                                      |\r\n| ldapGroupMemberAssocAttr      | uniqueMember                                                                         |\r\n| ldapHost                      | localhost                                                                            |\r\n| ldapIgnoreNamingRules         |                                                                                      |\r\n| ldapLoginFilter               | (&(|(objectclass=posixAccount))(|(uid=%uid)(|(mailPrimaryAddress=%uid)(mail=%uid)))) |\r\n| ldapLoginFilterAttributes     |                                                                                      |\r\n| ldapLoginFilterEmail          | 1                                                                                    |\r\n| ldapLoginFilterMode           | 0                                                                                    |\r\n| ldapLoginFilterUsername       | 1                                                                                    |\r\n| ldapNestedGroups              | 0                                                                                    |\r\n| ldapOverrideMainServer        |                                                                                      |\r\n| ldapPagingSize                | 500                                                                                  |\r\n| ldapPort                      | 389                                                                                  |\r\n| ldapQuotaAttribute            |                                                                                      |\r\n| ldapQuotaDefault              |                                                                                      |\r\n| ldapTLS                       | 0                                                                                    |\r\n| ldapUserDisplayName           | cn                                                                                   |\r\n| ldapUserDisplayName2          | sn                                                                                   |\r\n| ldapUserFilter                | (|(objectclass=posixAccount))                                                        |\r\n| ldapUserFilterGroups          |                                                                                      |\r\n| ldapUserFilterMode            | 0                                                                                    |\r\n| ldapUserFilterObjectclass     | posixAccount                                                                         |\r\n| ldapUuidGroupAttribute        | auto                                                                                 |\r\n| ldapUuidUserAttribute         | auto                                                                                 |\r\n| turnOffCertCheck              | 0                                                                                    |\r\n| turnOnPasswordChange          | 0                                                                                    |\r\n| useMemberOfToDetectMembership | 1                                                                                    |\r\n+-------------------------------+--------------------------------------------------------------------------------------+\r\n```\r\n</details>\r\n\r\n### Client configuration\r\n**Browser:** Vivaldi\r\n\r\n**Operating system:** Ubuntu 16.04 LTS 64-bit\r\n\r\n### Logs\r\n#### Web server error log\r\n<details>\r\n<summary>Web server error log</summary>\r\n\r\n```\r\n[Wed Feb 01 17:02:02.195599 2017] [authz_core:error] [pid 2326] [client 192.168.254.15:40636] AH01630: client denied by server configuration: /opt/nextcloud/data/.ocdata\r\n[Wed Feb 01 17:02:09.377073 2017] [authz_core:error] [pid 3984] [client 192.168.254.15:40642] AH01630: client denied by server configuration: /opt/nextcloud/data/.ocdata\r\n[Wed Feb 01 17:07:58.118941 2017] [authz_core:error] [pid 4055] [client 192.168.254.15:40858] AH01630: client denied by server configuration: /opt/nextcloud/data/.ocdata\r\n[Wed Feb 01 17:08:15.404360 2017] [authz_core:error] [pid 2328] [client 192.168.254.15:40872] AH01630: client denied by server configuration: /opt/nextcloud/data/.ocdata\r\n[Wed Feb 01 17:14:04.886810 2017] [proxy:warn] [pid 4013] [client 192.168.254.15:41004] AH01144: No protocol handler was valid for the URL /lool/adminws. If you are using a DSO version of mod_proxy, make sure the proxy submodules are included in the configuration using LoadModule.\r\n[Wed Feb 01 17:14:52.350296 2017] [authz_core:error] [pid 4013] [client 192.168.254.15:41036] AH01630: client denied by server configuration: /opt/nextcloud/data/.ocdata\r\n[Wed Feb 01 17:14:56.437057 2017] [authz_core:error] [pid 2329] [client 192.168.254.15:41030] AH01630: client denied by server configuration: /opt/nextcloud/data/.ocdata\r\n[Wed Feb 01 17:20:35.390297 2017] [authz_core:error] [pid 2330] [client 192.168.254.15:41166] AH01630: client denied by server configuration: /opt/nextcloud/data/.ocdata\r\n[Wed Feb 01 17:20:39.853842 2017] [authz_core:error] [pid 2326] [client 192.168.254.15:41168] AH01630: client denied by server configuration: /opt/nextcloud/data/.ocdata\r\n```\r\n</details>\r\n\r\n#### Nextcloud log (data/nextcloud.log)\r\n<details>\r\n<summary>Nextcloud log</summary>\r\n\r\n```\r\n{\"reqId\":\"WJJs6H8AAQEAAHAN2LAAAAAF\",\"remoteAddr\":\"192.168.254.15\",\"app\":\"PHP\",\"message\":\"Class 'OCA\\\\Richdocuments\\\\AppInfo\\\\Application' not found at \\/opt\\/nextcloud\\/apps\\/richdocuments\\/appinfo\\/app.php#28\",\"level\":3,\"time\":\"2017-02-01T23:19:04+00:00\",\"method\":\"GET\",\"url\":\"\\/ocs\\/v2.php\\/apps\\/notifications\\/api\\/v2\\/notifications\",\"user\":\"b99b5cd8-35af-1036-9f7c-e1f2a57c2622\",\"version\":\"11.0.1.2\"}\r\n{\"reqId\":\"WJJtA38AAQEAAHAyPKUAAAAK\",\"remoteAddr\":\"192.168.254.15\",\"app\":\"PHP\",\"message\":\"Class 'OCA\\\\Richdocuments\\\\AppInfo\\\\Application' not found at \\/opt\\/nextcloud\\/apps\\/richdocuments\\/appinfo\\/app.php#28\",\"level\":3,\"time\":\"2017-02-01T23:19:31+00:00\",\"method\":\"GET\",\"url\":\"\\/index.php\\/settings\\/apps\\/list?category=organization\",\"user\":\"b99b5cd8-35af-1036-9f7c-e1f2a57c2622\",\"version\":\"11.0.1.2\"}\r\n{\"reqId\":\"WJJtE38AAQEAAHAzOwYAAAAL\",\"remoteAddr\":\"192.168.254.15\",\"app\":\"PHP\",\"message\":\"Class 'OCA\\\\Richdocuments\\\\AppInfo\\\\Application' not found at \\/opt\\/nextcloud\\/apps\\/richdocuments\\/appinfo\\/app.php#28\",\"level\":3,\"time\":\"2017-02-01T23:19:47+00:00\",\"method\":\"GET\",\"url\":\"\\/index.php\\/settings\\/apps\\/list?category=social\",\"user\":\"b99b5cd8-35af-1036-9f7c-e1f2a57c2622\",\"version\":\"11.0.1.2\"}\r\n{\"reqId\":\"WJJtFX8AAQEAAHDCcyIAAAAI\",\"remoteAddr\":\"192.168.254.15\",\"app\":\"PHP\",\"message\":\"Class 'OCA\\\\Richdocuments\\\\AppInfo\\\\Application' not found at \\/opt\\/nextcloud\\/apps\\/richdocuments\\/appinfo\\/app.php#28\",\"level\":3,\"time\":\"2017-02-01T23:19:50+00:00\",\"method\":\"GET\",\"url\":\"\\/index.php\\/settings\\/apps\\/list?category=enabled\",\"user\":\"b99b5cd8-35af-1036-9f7c-e1f2a57c2622\",\"version\":\"11.0.1.2\"}\r\n{\"reqId\":\"WJJtGn8AAQEAAHALfPQAAAAB\",\"remoteAddr\":\"192.168.254.15\",\"app\":\"PHP\",\"message\":\"Class 'OCA\\\\Richdocuments\\\\AppInfo\\\\Application' not found at \\/opt\\/nextcloud\\/apps\\/richdocuments\\/appinfo\\/app.php#28\",\"level\":3,\"time\":\"2017-02-01T23:19:55+00:00\",\"method\":\"GET\",\"url\":\"\\/index.php\",\"user\":\"b99b5cd8-35af-1036-9f7c-e1f2a57c2622\",\"version\":\"11.0.1.2\"}\r\n{\"reqId\":\"WJJtHX8AAQEAAHAO39gAAAAH\",\"remoteAddr\":\"192.168.254.15\",\"app\":\"PHP\",\"message\":\"Class 'OCA\\\\Richdocuments\\\\AppInfo\\\\Application' not found at \\/opt\\/nextcloud\\/apps\\/richdocuments\\/appinfo\\/app.php#28\",\"level\":3,\"time\":\"2017-02-01T23:19:57+00:00\",\"method\":\"GET\",\"url\":\"\\/index.php\",\"user\":\"b99b5cd8-35af-1036-9f7c-e1f2a57c2622\",\"version\":\"11.0.1.2\"}\r\n{\"reqId\":\"WJKCqX8AAQEAABZfU8EAAAAE\",\"remoteAddr\":\"192.168.254.15\",\"app\":\"core\",\"message\":\"Login failed: 'b99b5cd8-35af-1036-9f7c-e1f2a57c2622' (Remote IP: '192.168.254.15')\",\"level\":2,\"time\":\"2017-02-02T00:51:54+00:00\",\"method\":\"POST\",\"url\":\"\\/index.php\\/login\\/confirm\",\"user\":\"b99b5cd8-35af-1036-9f7c-e1f2a57c2622\",\"version\":\"11.0.1.2\"}\r\n{\"reqId\":\"WJKGJn8AAQEAAA@up48AAAAL\",\"remoteAddr\":\"192.168.254.15\",\"app\":\"core\",\"message\":\"Login failed: 'b99b5cd8-35af-1036-9f7c-e1f2a57c2622' (Remote IP: '192.168.254.15')\",\"level\":2,\"time\":\"2017-02-02T01:06:49+00:00\",\"method\":\"POST\",\"url\":\"\\/index.php\\/login\\/confirm\",\"user\":\"b99b5cd8-35af-1036-9f7c-e1f2a57c2622\",\"version\":\"11.0.1.2\"}\r\n```\r\n</details>\r\n"},"comment":{"url":"https://api.github.com/repos/nextcloud/richdocuments/issues/comments/443502692","html_url":"https://github.com/nextcloud/richdocuments/issues/21#issuecomment-443502692","issue_url":"https://api.github.com/repos/nextcloud/richdocuments/issues/21","id":443502692,"node_id":"MDEyOklzc3VlQ29tbWVudDQ0MzUwMjY5Mg==","user":{"login":"daylicron","id":32066194,"node_id":"MDQ6VXNlcjMyMDY2MTk0","avatar_url":"https://avatars0.githubusercontent.com/u/32066194?v=4","gravatar_id":"","url":"https://api.github.com/users/daylicron","html_url":"https://github.com/daylicron","followers_url":"https://api.github.com/users/daylicron/followers","following_url":"https://api.github.com/users/daylicron/following{/other_user}","gists_url":"https://api.github.com/users/daylicron/gists{/gist_id}","starred_url":"https://api.github.com/users/daylicron/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/daylicron/subscriptions","organizations_url":"https://api.github.com/users/daylicron/orgs","repos_url":"https://api.github.com/users/daylicron/repos","events_url":"https://api.github.com/users/daylicron/events{/privacy}","received_events_url":"https://api.github.com/users/daylicron/received_events","type":"User","site_admin":false},"created_at":"2018-12-02T12:08:17Z","updated_at":"2018-12-02T12:08:17Z","author_association":"NONE","body":"> I just upgraded the nextcloud collabora app to 2.0.13 and nextcloud couldn't open any files in collabora.\r\n> restart of nextcloud and collabora server didn't solve the problem.\r\n> \r\n> I found this \"crazy\" solution here - may be completely irrelevant too.\r\n> \r\n> https://help.nextcloud.com/t/failure-please-ensure-the-file-type-is-supported-and-not-corrupted/8031/3\r\n> \r\n> 1. Run the Docker image as normal\r\n> 2. Keep trying to open docs on Nextcloud…\r\n> 3. Click “OK” on “Well, this is embarrassing, we cannot connect to your document. Please try again.”\r\n> 4. Click “OK” on “Service is unavailable. Please try again later and report to your administrator if the issue persists.”\r\n> 5. Keeping going back to step 3 until you finally get “Failed to load the document. Please ensure the file type is supported and not corrupted, and try again.”\r\n> 6. Click “OK” and exit to Files.\r\n> 7. Restart Docker itself (the service, not just the image).\r\n\r\nOMG, thank you so much. I wasted one and a half our on this. Restarting the docker service did the trick!"}}
{"actor":{"display_login":"daylicron"}}