Code Monkey home page Code Monkey logo

richdocuments's Introduction

ownCloud application to integrate Collabora Online

Quality Gate Status Security Rating Coverage

Collabora Online for ownCloud provides collaborating editing functions for text documents, spreadsheets and presentations inside ownCloud for improved productivity.

See also: https://owncloud.com/collabora/collaborative-editing/

Configuration

  • Set WOPI Server URL

    $ occ config:app:set richdocuments wopi_url --value [your-host-public-ip]:8098 
    
  • Enable/Disable Secure View and set its settings

    $ occ config:app:set richdocuments secure_view_option --value true
    $ occ config:app:set richdocuments watermark_text --value "Restricted to {viewer-email}" 
    $ occ config:app:set richdocuments secure_view_open_action_default --value true
    

Developing

The easiest way to integrate Collabora with development instance of ownCloud is by disabling SSL for Collabora.

  • Start Collabora Server with default settings

    $ docker run -t -d -p 9980:9980 -e "extra_params=--o:ssl.enable=false" -e "username=admin" -e "password=admin" --name collabora --cap-add MKNOD collabora/code:6.4.8.6
    
  • Access Collabora Admin at http://[your-host-public-ip]:9980/loleaflet/dist/admin/admin.html e.g. 172.16.12.95,

  • Set in Settings -> Admin -> Additional -> Collabora Online server -> http://[your-host-public-ip]:9980

Installation

NOTE: Collabora server needs to be reachable from ownCloud server, and Collabora server needs to be able to reach ownCloud server

NOTE: it is possible to use Collabora Online’s integration with re-compiled and/or re-branded backends.

Installing connector for ownCloud Web

You will need:

To enable work within ownCloud web, register the connector in the ownCloud Web config.json:

  • If you installed ownCloud Web from the official marketplace, the path is <owncloud-root-catalog>/config/config.json
  • If you compiled it from source code yourself using this instruction, the path is <owncloud-web-root-catalog>/config/config.json.

To register the connector, use these lines:

"external_apps": [
    {
        "id": "richdocuments",
        "path": "http(s)://<owncloud-10-server-address>/index.php/apps/richdocuments/js/richdocuments.js"
    }
]

Compiling the connector for ownCloud Web

Build all the dependencies:

yarn install

Build the resulting file js/web/richdocuments.js:

yarn build

richdocuments's People

Contributors

adityab avatar ashod avatar butonic avatar deepdiver1975 avatar dependabot[bot] avatar dpakach avatar dschmidt avatar georgehrke avatar hcvcastro avatar individual-it avatar jancborchardt avatar jnweiger avatar jvillafanez avatar karakayasemi avatar kendy avatar kulmann avatar lukasreschke avatar micbar avatar mihai-varga avatar morrisjobke avatar mrow4a avatar ownclouders avatar phil-davis avatar pranavk avatar pvince81 avatar skshetry avatar swikritit avatar timar avatar vgezer avatar vicdeo avatar

Stargazers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

Watchers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

richdocuments's Issues

List view for app

Hello,

A list view would be great instead of huge icons.

Maybe a list view with details of date and size?

Resizable columns in spreadsheet editor

Hi,

I can't seem to work out how to resize the columns in spreadsheet editing.

In Excel/Libreoffice - double clicking auto-resizes, but you can also hover over a column separator and a new icon appears and you can click and resize.

None of this works on the online version.

Is this a bug with richdocuments - or other underlying bits (libreoffice or Loolswd)??

Or - is there something I am missing ?
(using master copy from yesterday 1.1.4)

Cheers

documents won't open if app is restricted to user group

Found an issue by restricting Collabora Online connector 1.1.4 to an specific ownCloud/nextcloud user-group.
image

Maybe this happens only when using collabora online within an docker container on an other server than ownCloud/nextcloud is hosted.
If configured as mentioned above the document file can be clicked but won't be opened by collabora online. "unexpected error" message appears.

It seems collabora cant communicate with the ownCloud/nextcloud app.
image

Further information about the setup can be found here (german only by now - sorry):
https://www.2good4you.net/blog/19-web-stuff/6-collabora-online-unter-debian-8

File duplication issue

Hello,

I installed richdocuments app on OC and NC instances but there is something I can't understand. I'm not sure this is a bug, but I want to understand the philosophy behind this if it is not.

  1. Create a folder with documents inside it (odt, doc, docx, xls, or whatever can be opened with Collabora).
  2. Share the folder to an user.
  3. Edit the file with this user account.
  4. Save modifications.
  5. Constat the problem.

There is now two identical files:

  • One is in the folder (the one was shared with me) ;
  • One is in my root folder.
    The two docs are exactly the same. The only difference is that the version in my root folder is not shared with anyone.

I do not know if I am explicit but ask me If you want precisions.

Thanks :).

Can't install it says missing file

Trying to install this, I got stuck on the second step, I get this:

"error: failed to stat /owncloud/apps/richdocuments/owncloud-collaborate-online.spec: No such file or directory"

I looked in there but I just found this file collabora-online.spec.in , should I just remove the .in from this file and try again the rpmbuild?

Unable to open files stored in an external storage

I'm currently messing around with the CODE vm and manage to recreate this error with every instance a created.

on the owncloud of the vm itself
on another server running ubuntu server 14.4 and owncloud 9.0.2

everything works fine as long as you work on the data folder of owncloud, but when you try to open a file located somewhere else on the server (that is the external storage type I use : local)

Collabora Online lauch itself, try to load the file for a few seconds then give the message :
'We are sorry, this is an unexpected connection error. Please try again.'

and the log look like :

Exception: {"Exception":"Exception","Message":"Invalid file path.","Code":0,"Trace":"#0 /srv/www/htdocs/owncloud/apps/richdocuments/controller/documentcontroller.php(391): OCA\Richdocuments\Db\Wopi->getPathForToken('38', '0', 'Kxh6BNdidV8xTKY...')\n#1 [internal function]: OCA\Richdocuments\Controller\DocumentController->wopiCheckFileInfo('38')\n#2 /srv/www/htdocs/owncloud/lib/private/appframework/http/dispatcher.php(159): call_user_func_array(Array, Array)\n#3 /srv/www/htdocs/owncloud/lib/private/appframework/http/dispatcher.php(89): OC\AppFramework\Http\Dispatcher->executeController(Object(OCA\Richdocuments\Controller\DocumentController), 'wopiCheckFileIn...')\n#4 /srv/www/htdocs/owncloud/lib/private/appframework/app.php(108): OC\AppFramework\Http\Dispatcher->dispatch(Object(OCA\Richdocuments\Controller\DocumentController), 'wopiCheckFileIn...')\n#5 /srv/www/htdocs/owncloud/lib/private/appframework/routing/routeactionhandler.php(45): OC\AppFramework\App::main('DocumentControl...', 'wopiCheckFileIn...', Object(OC\AppFramework\DependencyInjection\DIContainer), Array)\n#6 [internal function]: OC\AppFramework\routing\RouteActionHandler->__invoke(Array)\n#7 /srv/www/htdocs/owncloud/lib/private/route/router.php(291): call_user_func(Object(OC\AppFramework\routing\RouteActionHandler), Array)\n#8 /srv/www/htdocs/owncloud/lib/base.php(853): OC\Route\Router->match('/apps/richdocum...')\n#9 /srv/www/htdocs/owncloud/index.php(39): OC::handleRequest()\n#10 {main}","File":"/srv/www/htdocs/owncloud/apps/richdocuments/lib/db/wopi.php","Line":128}

Previews for the documents

Is it planned/possible to have previews of the documents shown in the app? Cause right now it’s just a grid of giant icons – would be cool to make that a bit nicer. :)

The idea would be to still have the grid, but a big preview and then the filetype icon a bit smaller in the corner.

cc @timar @pranavk and @LukasReschke for security

Default Font:

Hi,

The default font when opening a document is "Open Sans"

How can this be tweaked so that there is the ability to change the default font.
(And where does this app get it's list of available fonts from ?)

Cheers
KR

Cannot connect to document

Since updating to the latest docker image of collabora with nextcloud I always get a "Well, this is embarrassing, we cannot connect to your document. Please try again." althought the interface loads (see sreenshot). 2016-10-16 02_29_35-map3womo xls - office - nextcloud - iron

Are there any known incompatibilities, as the setup used to work with the same settings before...

change "remote user"

Tengo instalado el owncloud 9.1.1 con Collabora Online 1.1.4. con LDAP para validar los usuarios
Cuando voy la "actividad" del usuario despues de modificar un archivo tengo la leyenda:
"cambiado por usuario remoto"
owncloud-remoteuser
Esto es correcto o estoy omitiendo alguna configuración entre el owncloud y el collabora online?
Saludos.

help me about error : cURL error 56

my system
OS ; ubuntu 16.04
owncloud : 8.2.3
PHP : 5.6.22-4
apache : 2.4.18
mysql : Ver 14.14 Distrib 5.7.12, for Linux (x86_64) using EditLine wrapper

I compiled loolwsd and loleaflet.
and enabled richdocuments in owncloud 8.2.3.
I got error.
"Collabora Online unknown error: cURL error 56: Recv failure: Connection reset by peer
Please contact the "http://118.131.9.226:9980" administrator."

what is the problem? any idea about it?
Tell me please.

I got cURL error 7. help me please.

I just complied loolwsd and loleaflet.
and enable richdocuments in owncloud.
but i got this error
"cURL error 7: Failed to connect to 192.168.38.107 port 9980: Connection refused"
How can i solve it?

my system
OS ; ubuntu 16.04
owncloud : 8.2.3
PHP : 5.6.22-4
apache : 2.4.18
mysql : Ver 14.14 Distrib 5.7.12, for Linux (x86_64) using EditLine wrapper

PLEASE! HELP! I need working release of LibreOffice Online into OwnCloud

Hi!

i need a working release, please help me to configure a correct combination of

  • OS: Ubuntu or another one?
  • Server: Apache with/what PHP version?
  • Which use the correct version owncloud to make the system work?
  • there are particural server configuration or optimization?

PLEASE it is another question:
what is the expected date for the release of functioning beta is easy to use?

occ config:system and config:app do not exist on 8.1

Hi,
the readme says one should use the config:system and config:app commands for the installation, but apparently those are not available on oc 8.1. See https://github.com/owncloud/core/tree/stable8.1/core/command

(found out while a user in #owncloud asked for help):

[08:38:01] Perdouille: Hello ! I need help
[08:38:14] Perdouille: I'm trying to install this : https://github.com/owncloud/richdocuments
[08:38:15] AppropriateBot: Title: GitHub - owncloud/richdocuments (at github.com)
[08:38:29] Perdouille: But every occ commands doesn't work
[08:38:36] Perdouille: Wait, I will give you the error
[08:39:53] Perdouille: "There are no commands defined in the "config:system" namespace." for the first one (occ config:system:set --value='\OC\Memcache\APCu' memcache.local), and "There are no commands defined in the "config:app" namespace." for the last one (./occ config:app:set --value='https://<hostname or IP address>:<port>' richdocuments wopi_url)
[08:43:40] ChristophWurst: Perdouille: which ownCloud version? Did you finish the ownCloud setup?
[08:44:27] Perdouille: I'm using the 8.something, i'm updating to 8.2.5 right now
[08:44:41] Perdouille: 8.1.8 if I remember correctly
[08:44:56] Perdouille: And yes I finished the installation and it's working correctly
[08:46:15] Perdouille: Ah it seems to work
[08:47:11] ChristophWurst: Perdouille: I checked the ownCloud code, apparently that command didn't exist on 8.1
[08:47:21] ChristophWurst: with 8.2?
[08:48:30] Perdouille: Yeah it was that, thanks for your help
[08:48:39] ChristophWurst: you're welcome :)
[08:48:41] Perdouille: I should've seen the update before coming here ^^
[08:49:29] ChristophWurst: Perdouille: well, the app says it's compatible with 8.1

Collabora/CODE and Richdocuments plugin error with OwnCloud 9.1

Hi All

I'm construct owncloud9.1.0 in AWS using image in bitnami.
So to use Collabora Online, by making reference to the following web page, richdocument, install.

http://askubuntu.com/questions/775766/how-to-install-the-richdocuments-plugin-on-owncloud

A plug-in of richdocument, install, I made docker in t Collabora Online Development Edition (CODE) start in following CLI.

$ docker pull collabora/code
$ docker run -t -d -p 127.0.0.1:9980:9980 -e
"domain=" --cap-add MKNOD collabora/code
After environment building of Collabora Online Development Edition (CODE)
offie-> test. doc.
this document is clicked, the following error is recorded in owncloud.log.

Error PHP Argument 4 passed to OCA\Richdocuments\Controller\DocumentController::__construct() must implement interface OCP\IConfig, instance of OCA\Richdocuments\AppConfig given, called in /opt/bitnami/apps/owncloud/htdocs/apps/richdocuments/appinfo/application.php on line 55 and defined at /opt/bitnami/apps/owncloud/htdocs/apps/richdocuments/controller/documentcontroller.php#56 2016-09-09T06:52:01+00:00
It isn't possible to edit document in such state, when how doing do, would I be able to settle it?

How to Input Chinese in CODE

when I try Chinese typing, it cant input to file by Microsoft IME or Linux SCIM...
I tried copy/paste from a notepad to screen , it works fine

so maybe it's a problem in PC's?(I haven't tried a tablet with owncloud)

Install Error

Hi Guys,

i would love to test this plugin. I downloaded the Code VM and i did fill in the ip of that vm into the wopi client field. After browsing to the plugin i get this error. any idea?

image

Include warnings on personal page

I see many of those warnings when a user accesses its personal settings page:

include(richdocuments/personal.php): failed to open stream: No such file or directory at /var/www/html/lib/private/legacy/app.php#759

and

include(): Failed opening 'richdocuments/personal.php' for inclusion (include_path='/var/www/html/3rdparty/pear/console_getopt:/var/www/html/3rdparty/pear/pear_exception:/var/www/html/3rdparty/pear/pear-core-minimal/src:/var/www/html/3rdparty/pear/archive_tar:/var/www/html/3rdparty/phpseclib/phpseclib/phpseclib:/var/www/html/lib/private:/var/www/html/config/:/var/www/html/3rdparty:/var/www/html/apps:.:/usr/share/php:/var/www/html') at /var/www/html/lib/private/legacy/app.php#759

cc @timar @kendy @LukasReschke

Large number of files

If the user has a large number of files when opening the file "was not found on this server." the logs can be seen that there is no reference to libreoffice-online. If the file is not enough everything works well. What could be the problem?

richdocuments 0.15.2
owncloud 8.2.5
libreoffice latest version
libreoffice-online latest version

Installing collabora-dockerimage for richdocuments via nginx

Hello all,

as i read in bugreports, people already see and tried the new docker-image for collabora.

I try to install this as well and fail. I've tried:

  • installing in docker via
    docker pull collabora/code
    docker run -t -d -p 9980:9980 -e "domain=localhost" --net host --cap-add MKNOD collabora/code
    #advanced for localhost as wrote in nextcloud-manual

  • making folders for nginx:

    static files

    location ^~ /loleaflet {
    proxy_pass https://localhost:9980;
    proxy_set_header Host $http_host;
    }

    WOPI discovery URL

    location ^~ /hosting/discovery {
    proxy_pass https://localhost:9980;
    proxy_set_header Host $http_host;
    }

    websockets, download, presentation and image upload

    location ^~ /lool {
    proxy_pass https://localhost:9980/;
    proxy_http_version 1.1;
    proxy_set_header Upgrade $http_upgrade;
    proxy_set_header Connection "upgrade";
    proxy_read_timeout 86400;
    }

  • Moving cert
    docker cp 716a4c99ce67:/etc/loolwsd/ca-chain.cert.pem /tmp/
    cat /tmp/ca-chain.cert.pem >> /yourown/cloudroot/resources/config/ca-bundle.crt

that's about what was done, now on the richdocuments-part;

the defaultvalue https://localhost:9980 detects the wrong ssl-cert (when you did not the moving-step above) and is able to load the document-raster/mainmenu (which needs a discovery.xml-file, which i get). If i choose a file, it's not able to load any file - load-circle loads infinite long.

this looks other when i choose the servername provided by nginx (in my case https://cloud.energiewandler.ch). it loads the editor partialy and tells me it looses connection and i should try again (a owncloud-message).

a docker logs gives me this for one complete try to open it:

wsd-00031-02 00:48:54.457418 [ client_req_hdl ] Request from 127.0.0.1:35186: GET /hosting/discovery HTTP/1.0 / Host: cloud.energiewandler.ch / Connection: close / User-Agent: ownCloud Server Crawler
wsd-00031-02 00:48:54.457526 [ client_ws_0010 ] Thread started.
wsd-00031-02 00:48:54.463811 [ client_ws_0010 ] Sent discovery.xml successfully.
wsd-00031-02 00:48:54.463996 [ client_ws_0010 ] Thread finished.
wsd-00031-04 00:48:56.411516 [ client_req_hdl ] Request from 127.0.0.1:35192: POST /loleaflet/1.7.2/loleaflet.html?WOPISrc=https%3A%2F%2Fcloud.energiewandler.ch%2Findex.php%2Fapps%2Frichdocuments%2Fwopi%2Ffiles%2F183694&title=Neue%20Kalkulationstabelle.ods&lang=de&closebutton=1&revisionhistory=1 HTTP/1.0 / Host: cloud.energiewandler.ch / Connection: close / Content-Length: 45 / User-Agent: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:47.0) Gecko/20100101 Firefox/47.0 / Accept: text/html,application/xhtml+xml,application/xml;q=0.9,/;q=0.8 / Accept-Language: en-US,en;q=0.5 / Accept-Encoding: gzip, deflate, br / Cookie: ocr2mvgsw895b=MayTd5cC5sKD7IwBMy0%2Cb1; oc_sessionPassphrase=1YHaGSQzivHyWujlYqhW%2BdAMJYgq9lwdxb8eNvL10Br9%2FZZXqDZNTcJag4KJ3u3KrVYIn5ofzr16TEjL9Wc16uzXCwuc7%2F6i6Q02vsOhIY%2BpYJYr72OT%2F%2FCYF%2F5XtVKe / Content-Type: application/x-www-form-urlencoded
wsd-00031-04 00:48:56.411790 [ client_req_hdl ] Preprocessing file: /usr/share/loolwsd//loleaflet/dist/loleaflet.html
wsd-00031-02 00:48:58.080141 [ client_req_hdl ] Request from 127.0.0.1:35194: GET //ws/https:/cloud.energiewandler.ch/index.php/apps/richdocuments/wopi/files/183694?access_token=fg2yRz99ABCdTXu5DPbPdG3AgmsxCJBU HTTP/1.0 / Upgrade: websocket / Connection: upgrade / Host: cloud.energiewandler.ch / User-Agent: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:47.0) Gecko/20100101 Firefox/47.0 / Accept: text/html,application/xhtml+xml,application/xml;q=0.9,/;q=0.8 / Accept-Language: en-US,en;q=0.5 / Accept-Encoding: gzip, deflate, br / Sec-WebSocket-Version: 13 / Origin: https://cloud.energiewandler.ch / Sec-WebSocket-Extensions: permessage-deflate / Sec-WebSocket-Key: tPlhQFPhi2otDKXK4IqZbg== / Cookie: ocr2mvgsw895b=MayTd5cC5sKD7IwBMy0%2Cb1; oc_sessionPassphrase=1YHaGSQzivHyWujlYqhW%2BdAMJYgq9lwdxb8eNvL10Br9%2FZZXqDZNTcJag4KJ3u3KrVYIn5ofzr16TEjL9Wc16uzXCwuc7%2F6i6Q02vsOhIY%2BpYJYr72OT%2F%2FCYF%2F5XtVKe / Pragma: no-cache / Cache-Control: no-cache
wsd-00031-02 00:48:58.080303 [ client_ws_0011 ] Thread started.
wsd-00031-02 00:48:58.080337 [ client_ws_0011 ] Unknown resource: //ws/https:/cloud.energiewandler.ch/index.php/apps/richdocuments/wopi/files/183694?access_token=fg2yRz99ABCdTXu5DPbPdG3AgmsxCJBU
wsd-00031-02 00:48:58.080401 [ client_ws_0011 ] Thread finished.

the main-failure is this

Unknown resource: //ws/https:/cloud.energiewandler.ch/index.php/apps/richdocuments/wopi/files/183694?access_token=fg2yRz99ABCdTXu5DPbPdG3AgmsxCJBU

so it did not find the adress/"ressource" - but it is the only way (for me) to get ANY reaction out of this daemon (loolwsd)

EDIT: i've tried the url withouth //ws/ . Result:
{"BaseFileName":"Neues Dokument (3).odt","Size":8449,"Version":"0"}
so, this seems to work. EDITEND

Maybe someone has a idea with nginx, forwarding, or may the development on loolwsd is too fast? Or should i free the port 9980 (would need to be in serverplace)?

I've tried to disable, enable and search other nginx-options cause i think the problem is there.. and maybe it's also a missformed url in richtexts? i just could speculate :s

hope, this bugreport will be productive, thanks a lot in advance :)

BIG EDIT:

Problem is solved. This was uncommented and was in the serverpart (for owncloud)

add_header X-Download-Options noopen;

add_header X-Permitted-Cross-Domain-Policies none;

Commenting those out is a first workaround.. This flags are from the owncloud-documentation where i share the domain with.

Final lool-location which works for me:
location ^~ /lool {
gzip off;
proxy_pass https://localhost:9980;
proxy_set_header X-Real-IP $remote_addr;
proxy_set_header Host $host;
add_header X-Download-Options open;
add_header X-Permitted-Cross-Domain-Policies all;
proxy_http_version 1.1;
proxy_set_header Upgrade $http_upgrade;
proxy_set_header Connection $connection_upgrade;
proxy_read_timeout 86400;
}

I let the bugreport be since it's may usefull as a documentation which is kind of rare atm. Now i wanna write text! :)))))

"Save As" missing feature.

Hi All,

When opening a document - there is the option to save - either via "File -> Save" or the floppy disk icon, however, there is no option to choose to save the document as a separate name.

In order to save a document as new name, one currently has to open a new document, then save, exit the Richdocs app, then rename the document (and potentially move to the location that they want it) and then re-open/re-edit the document.

Cheers

KR

Editor don't work, but I can see the file

When I open a file i can only see the content, but not edit it.

Look like a front-end error.

I use Collabora Office 5.1-11 and richdocuments 1.1.13.

The browser's console show this errors.

Translation Bug in Files "+"-Menu

In general Document, Spreadsheet and Presentation are translated.
hello2

However: The Files "+"-Menu does not use these translations currently 😕
hello1

Collabora/CODE and Richdocuments plugin error with OwnCloud 9.1

Hi guys,

I'm trying to get the Collabora Online suite working in Owncloud 9.1 and running into an internal server error in Owncloud. Everything else in Owncloud is working fine as I've been running Owncloud for a couple years now. Recently upgraded from Ubuntu 14.04 to 16.04 and upgraded Owncloud from 8.1 to 8.2 to 9.0 to 9.1 in the process. Everything looks good, my sync clients work, web UI works great, etc.

Steps to reproduce

  1. Download docker image:
    docker pull collabora/code
  2. Run docker image:
    docker run -t -d -p 127.0.0.1:9980:9980 -e "domain=my\.domain\.com" --restart always --cap-add MKNOD collabora/code
  3. Follow instructions to install and configure the Richdocuments plugin: https://github.com/owncloud/richdocuments
  4. Enable richdocuments plugin and set Collabora Online URL in admin area to:
    https://localhost:9980 (have also tried hostname and some other combinations)
  5. Because the container uses a self-signed cert, but we'll only ever connect from localhost from the Owncloud server, let's just trust that cert in Owncloud:
    openssl s_client -connect localhost:9980
    Copy/paste the server certificate presented by the CODE container to a CODE.pem file.
    cat CODE.pem >> owncloud/resources/config/ca-bundle.crt
  6. Restart Apache for good measure:
    sudo service apache2 restart
  7. Login to Owncloud web UI and attempt to open any Office document (.doc, .docx, .xlsx, etc)

Expected behaviour
Document should open in the Collabora Online web-based editors depending on document type.

Actual behaviour
Owncloud drops an internal server error:
Internal Server Error The server encountered an internal error and was unable to complete your request. Please contact the server administrator if this error reappears multiple times, please include the technical details below in your report. More details can be found in the server log.

Log entry from /var/www/owncloud/data/owncloud.log:
{"reqId":"5s2U4L55Jqq\/TKs\/VMsK","remoteAddr":"172.29.1.104","app":"index","message":"Exception: {\"Exception\":\"TypeError\",\"Message\":\"Argument 4 passed to OCA\\\\Richdocuments\\\\Controller\\\\DocumentController::__construct() must implement interface OCP\\\\IConfig, instance of OCA\\\\Richdocuments\\\\AppConfig given, called in \\\/var\\\/www\\\/owncloud\\\/apps\\\/richdocuments\\\/appinfo\\\/application.php on line 54\",\"Code\":0,\"Trace\":\"#0 \\\/var\\\/www\\\/owncloud\\\/apps\\\/richdocuments\\\/appinfo\\\/application.php(54): OCA\\\\Richdocuments\\\\Controller\\\\DocumentController->__construct('richdocuments', Object(OC\\\\AppFramework\\\\Http\\\\Request), Object(OC\\\\AllConfig), Object(OCA\\\\Richdocuments\\\\AppConfig), Object(OC\\\\L10N\\\\L10N), 'rwhite', Object(OC\\\\Memcache\\\\Factory), Object(OC\\\\Log))\\n#1 \\\/var\\\/www\\\/owncloud\\\/3rdparty\\\/pimple\\\/pimple\\\/src\\\/Pimple\\\/Container.php(113): OCA\\\\Richdocuments\\\\AppInfo\\\\Application->OCA\\\\Richdocuments\\\\AppInfo\\\\{closure}(Object(OC\\\\AppFramework\\\\DependencyInjection\\\\DIContainer))\\n#2 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/AppFramework\\\/Utility\\\/SimpleContainer.php(102): Pimple\\\\Container->offsetGet('DocumentControl...')\\n#3 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/AppFramework\\\/App.php(93): OC\\\\AppFramework\\\\Utility\\\\SimpleContainer->query('DocumentControl...')\\n#4 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/AppFramework\\\/Routing\\\/RouteActionHandler.php(46): OC\\\\AppFramework\\\\App::main('DocumentControl...', 'index', Object(OC\\\\AppFramework\\\\DependencyInjection\\\\DIContainer), Array)\\n#5 [internal function]: OC\\\\AppFramework\\\\Routing\\\\RouteActionHandler->__invoke(Array)\\n#6 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/Route\\\/Router.php(280): call_user_func(Object(OC\\\\AppFramework\\\\Routing\\\\RouteActionHandler), Array)\\n#7 \\\/var\\\/www\\\/owncloud\\\/lib\\\/base.php(891): OC\\\\Route\\\\Router->match('\\\/apps\\\/richdocum...')\\n#8 \\\/var\\\/www\\\/owncloud\\\/index.php(39): OC::handleRequest()\\n#9 {main}\",\"File\":\"\\\/var\\\/www\\\/owncloud\\\/apps\\\/richdocuments\\\/controller\\\/documentcontroller.php\",\"Line\":56}","level":3,"time":"2016-09-05T17:54:07+00:00","method":"GET","url":"\/index.php\/apps\/richdocuments\/index","user":"rwhite"}

Server configuration
Operating system: Ubuntu 16.04 (latest patches as of today)
Web server: Apache 2.4.18-2ubuntu3.1
Database: MariaDB 10.0.25-0ubuntu0.16.04.1
PHP version: 7.0.8-0ubuntu0.16.04.2
ownCloud version: ownCloud 9.1.0 (stable)
Richdocuments version: 1.1.5
Updated from an older ownCloud or fresh install: Updated, occ upgrade and migrate tasks completed successfully.
ownCloud log: See above log output

Special configuration (external storage, external authentication, reverse proxy, server-side-encryption):

  • Using LDAP auth
  • Documents plugin DISABLED

Integrity status for oC9+
No errors have been found.

Localization of 'richdocuments' app

Hello @deepdiver and @felixboehm,

The current contents of richdocuments/l10n directory is outdated, and
most of the strings are unused.

I read
https://doc.owncloud.org/server/9.1/developer_manual/app/l10n.html and I
learned that ownCloud’s translation system is powered by Transifex. Can
you please help me to add 'richdocuments' to Transifex? I'd like to know
more about the translation process, i.e.,

  1. how to extract translatable strings
  2. how to update templates in Transifex
  3. how to download translations from Transifex
    Is there a HOWTO about this somewhere?

My user name at transifex.com is 'timar'.

Thanks,

Andras Timar
Product Development Manager
Collabora Productivity Ltd.
https://collaboraoffice.com/

cURL error 3: <url> malformed

git clone ....
enabled module
click to uploaded odt file
I got "cURL error 3: malformed" message
Not have any relevant message in owncloud.log

Confusing Name for End-Users

Isn't the Name "Collabora Online" a bit confusing for end-users? A name like "Documents" would be much more clear for them (e.g. app-menu, personal settings).

Can't set the server name in admin

I'm trying to set the correct server name in the connector but I am unable to get it to save. No matter what I enter it tried to connect to localhost. What am I doing wrong?

Creating new document works, opening existing one fails

I'm running this setup:

  • owncloud 9.0.1
  • latest libreoffice (git)
  • latest libreoffice-online (git)
  • latest richdocuments (git)
    (Ubuntu 16.04 x86_64)

When creating new documents via "Collabora Online" -> "Create ..."
richdocuments works as expected, however trying to open an existing
Document fails.

The redirect to richdocuments works:

http://looc.local.de/owncloud/index.php/apps/richdocuments/index#43

But in the content area I get:

Not Found

The requested URL /owncloud/index.php/apps/richdocuments/undefinedWOPISrc=http://looc.local.de/owncloud/index.php/apps/richdocuments/wopi/files/43&title=New Document.odt&closebutton=1 was not found on this server.

After some research I found a very dirty hack, to pass the right settings
(by statically using the URL, that should be provided by parsing the xml
of loolwsd in http://looc.local.de:9980/hosting/discovery):

So i Modified apps/richdocuments/js/documents.js:

// var urlsrc = $('li[data-id='+ documentsMain.fileId +']>a').attr('urlsrc') +
var urlsrc = "http://looc.local.de:9980/loleaflet/1.6.2/loleaflet.html?" +
"WOPISrc=" + wopisrc +
"&title=" + encodeURIComponent(title) +
"&closebutton=1";

Somehow the "urlsrc" attribute (and maybe more) seems to miss.

bug/problem?

Hi,

Some error when trying to open document.

get this in my collabora docker log:
wsd-00024-0027 0:03:25.175165 [ client_ws_0007 ] ERR WOPI::CheckFileInfo is missing JSON payload
wsd-00024-0027 0:03:25.175670 [ client_ws_0007 ] ERR Invalid fileinfo for URI [https://some.server.net/index.php/apps/richdocuments/wopi/files/2123686?access_token=JrYnfTJD08HFQMLlI5L1aXg4t8sMelaq&permission=readonly].
wsd-00024-0027 0:03:25.175887 [ client_ws_0007 ] ERR Failed to load document with URI [https://some.server.net/index.php/apps/richdocuments/wopi/files/2123686?access_token=JrYnfTJD08HFQMLlI5L1aXg4t8sMelaq&permission=readonly].
wsd-00024-0027 0:03:25.175986 [ client_ws_0007 ] ERR Error in client request handler: Failed to load document with URI [https://some.server.net/index.php/apps/richdocuments/wopi/files/2123686?access_token=JrYnfTJD08HFQMLlI5L1aXg4t8sMelaq&permission=readonly].

any ide?

Richdocuments: spreadsheet columns can't be resized

Hi,
I don't really know if this is a richdocuments or a libreoffice online ticket that must be open, but there is a problem with the app: Columns inside a spreadsheet cannot be resized. When we do it, there is a blue line indicating that the column is being resized, but when we finish the drag and release the mouse button, the column is not resized ! (But there are logs in loolwsd indicating that the action was performed). Nevertheless, it would be nice to be fixed.

SSL: certificate subject name 'localhost' does not match target host

Hello,

I have this error if I parameter richdocuments with ssl url

Collabora Online unknown error: cURL error 51: SSL: certificate subject name 'localhost' does not match target host name 'libreoffice.mydomain.com'

I done that :
cat ca-chain.cert.pem >> www/resources/config/ca-bundle.crt

Thanks for you're help

Not found - The requested document was not found on this server.

Hello, i have activation this application to my ownCloud Server 8.2.2
So, if i want to open an example document the url is switching to /index.php/apps/richdocuments/index#4 and i see "Collabora Online" in the header - but in the content area it shows me an error "Not found - The requested document was not found on this server." This happens to all .ODT and .ODS files i tested.

richdocuments not working with encryption

Hi,

I also posted this issue in the nextcloud support forum but they suggested to post this issue here:
https://help.nextcloud.com/t/collabora-not-working-with-encryption/1913

I am using Collabora via the docker container. OS is Ubuntu 14.04. Before you ask ... CONFIG_AUFS_XATTR=y is activated in the kernel.

The Nextcloud configuration:
"system":
{
"instanceid": "oc42b8zohyfj",
"passwordsalt": "_REMOVED SENSITIVE VALUE",
"secret": "_REMOVED SENSITIVE VALUE
",
"trusted_domains": [
"localhost",
"_REMOVED SENSITIVE VALUE"
],
"datadirectory": "_REMOVED SENSITIVE VALUE
",
"overwrite.cli.url": "http://localhost/owncloud",
"dbtype": "mysql",
"version": "9.0.52.0",
"dbname": "nextcloud_database",
"dbhost": "localhost",
"dbtableprefix": "nc_",
"dbuser": "_REMOVED SENSITIVE VALUE",
"dbpassword": "_REMOVED SENSITIVE VALUE
",
"logtimezone": "UTC",
"installed": true,
"mail_smtpmode": "php",
"mail_smtpsecure": "tls",
"mail_smtpport": "587",
"mail_smtphost": "smtp.gmail.com",
"mail_from_address": "_REMOVED SENSITIVE VALUE",
"mail_domain": "gmail.com",
"mail_smtpauth": 1,
"mail_smtpname": "_REMOVED SENSITIVE VALUE
",
"mail_smtppassword": "_REMOVED SENSITIVE VALUE_",
"memcache.local": "\OC\Memcache\APCu",
"theme": "fancy",
"loglevel": 3,
"maintenance": false,
"singleuser": false,
"htaccess.RewriteBase": "/owncloud",
"integrity.check.disabled": true,
"mail_smtpauthtype": "LOGIN",
"default_language": "de",
"defaultapp": "files",
"enable_previews": true,
"preview_max_scale_factor": 10,
"preview_max_filesize_image": 5,
"forcessl": true,
"forceSSLforSubdomains": true
}

"apps": {
"richdocuments": {
"enabled": "yes",
"installed_version": "1.1.3",
"ocsid": "174727",
"types": "",
"wopi_url": "https://owncloud.spigomaniac.de"
}
}

So i get the following error if I try to open any document with richdocuments:
screenshot 2016-07-25 14 11 20

I guess the key error message is: Private Key missing for user: please try to log-out and log-in again.

Fristly I already confirmed the encryption as the reason, because with a test user and temporairily disabled encryption it is fully working.
Secondly I used the CODE VM for testing. I upgraded owncloud to the latest version of nextcloud, enabled encryption and it's working! Under the assumption that this richdocuments app is just an updeted version of the app used in the CODE VM some updates between this versions seems to have broken the encryption support.

Another issue that could be connected to this one is the file loading delay (20s - 30s):
screenshot 2016-07-30 20 19 16

After updating collabora on Nextcloud cannot access documents

I did have a working Collabora office app working, but recently updated. Now I am unable to open any documents. The post-update error message states:

Well, this is embarrassing, we cannot connect to your document. Please try again.

My docker log [urls and ips changed] states:

wsd-00024-05 00:06:02.225755 [ client_req_hdl ] Request from 172.17.0.1:47716: POST /loleaflet/1.8.4/loleaflet.html?WOPISrc=https%3A%2F%2Fwww.dom134.com%2Fnextcloud%2Findex.php%2Fapps%2Frichdocuments%2Fwopi%2Ffiles%2F203620&title=php.odt&lang=en&closebutton=1&revisionhistory=1 HTTP/1.1 / Host: office.dom134.com / User-Agent: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:49.0) Gecko/20100101 Firefox/49.0 / Accept: text/html,application/xhtml+xml,application/xml;q=0.9,/;q=0.8 / Accept-Language: en-US,en;q=0.5 / Accept-Encoding: gzip, deflate, br / DNT: 1 / Upgrade-Insecure-Requests: 1 / Content-Type: application/x-www-form-urlencoded / X-Forwarded-For: 88.88.888.888 / X-Forwarded-Host: office.dom134.com / X-Forwarded-Server: office.dom134.com / Connection: Keep-Alive / Content-Length: 45
wsd-00024-05 00:06:02.226076 [ client_req_hdl ] Preprocessing file: /usr/share/loolwsd//loleaflet/dist/loleaflet.html
wsd-00024-02 00:06:03.634363 [ client_req_hdl ] Request from 172.17.0.1:47720: GET /lool/https%253A%252F%252Fwww.dom134.com%252Fnextcloud%252Findex.php%252Fapps%252Frichdocuments%252Fwopi%252Ffiles%252F203620%3Faccess_token=qeUnp2EEXI6F0IlJLBU7cwiSmV8PiLwd/ws HTTP/1.1 / Host: office.dom134.com / User-Agent: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:49.0) Gecko/20100101 Firefox/49.0 / Accept: text/html,application/xhtml+xml,application/xml;q=0.9,/;q=0.8 / Accept-Language: en-US,en;q=0.5 / Accept-Encoding: gzip, deflate, br / Sec-WebSocket-Version: 13 / origin: https://office.dom134.com / Sec-WebSocket-Extensions: permessage-deflate / Sec-WebSocket-Key: 5JfxEr5wtG4iVaUk/ToVJQ== / DNT: 1 / Pragma: no-cache / Cache-Control: no-cache / X-Forwarded-For: 88.88.888.888 / X-Forwarded-Host: office.dom134.com / X-Forwarded-Server: office.dom134.com / Connection: Keep-Alive
wsd-00024-02 00:06:03.634495 [ client_req_hdl ] Handling GET: /lool/https%253A%252F%252Fwww.dom134.com%252Fnextcloud%252Findex.php%252Fapps%252Frichdocuments%252Fwopi%252Ffiles%252F203620%3Faccess_token=qeUnp2EEXI6F0IlJLBU7cwiSmV8PiLwd/ws
wsd-00024-02 00:06:03.634559 [ client_ws_0004 ] Thread started.
wsd-00024-02 00:06:03.634606 [ client_ws_0004 ] Post request: [/lool/https%253A%252F%252Fwww.dom134.com%252Fnextcloud%252Findex.php%252Fapps%252Frichdocuments%252Fwopi%252Ffiles%252F203620%3Faccess_token=qeUnp2EEXI6F0IlJLBU7cwiSmV8PiLwd/ws]
wsd-00024-02 00:06:03.634723 [ client_ws_0004 ] ClientRequestHandler::handleRequest: BadRequestException: Invalid or unknown request.
wsd-00024-02 00:06:03.634801 [ client_ws_0004 ] Thread finished.

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.