Cannot get python scripts with postMessage to work

Installation & Configuration
1

I followed the instructions to build Collabora Online on Ubuntu, I went to https://localhost:9980/loleaflet/dist/framed.doc.html?file_path=/home/michael/Documents/collabora-online/test/data/hello-world.ods and all postMessages are working except the CallPythonScript ones.

Am I missing something?

2

Have you done the following step, as written in the docs?

Additional security is provided by not enabling the Python script provider by default. You need to explicitly install the collaboraofficebasis6.x-python-script-provider and collaboraofficebasis6.x-pyuno packages (replace x with the respective version number) to enable Python scripts.

https://sdk.collaboraonline.com/docs/Using_Python_scripting_in_Collabora_Online.html

3

Yes I did, forgot to mention it.

michael@ubuntu:/opt/collaboraoffice6.4/share/Scripts/python$ ls
Capitalise.py  InsertText.py   pythonSamples
HelloWorld.py  NamedRanges.py  SetCellColor.py
5

Hi ,

How do you install for a docker image running in kubernetes?

6

Hello @Muruguru! :wave:

I hope this message finds you well.

For your reference, all the necessary instructions for installation using Kubernetes are detailed in the SDK documentation here: Kubernetes Installation Guide.

Additionally, there is a section dedicated to installation using Docker, which you may find helpful: Docker Installation Guide.

Best regards,
Darshan

7

Hi @darshan
Thank you for your quick reply. But what I am seeing is the docker image does not provide the collaborabasic provider and pyuno installation after looking into the scripts folder. How do I go about and is there any instructions?

Best,
Muru

8

Hello @Muruguru,

I’m not entirely clear on your use case. Could you provide more details?

Specifically, how are you trying to configure the Docker image in Kubernetes? Some additional context would be very helpful to better understand and assist you.

Thank you
Darshan

9

Hi Darshan,

Our use case is:

  1. we are using collabora online for document viewing in our webapp and have implemented the CheckFileInfo, GET and POST
  2. We have created a button that would like to send some selected text from the document and send it to our webapp, but since the postMessage API on the browser does not allow to collect the selected text from the iframe, we were looking into using PythonScripts on the collabora online self hosted server in k8s.
  3. The docker image has /opt/collaboraoffice/share/Scripts/python folder, but after putting a small python script (just a hello world to test) and using a postMessage with CallPythonScript is not actually triggering any output. I noticed that the full libreoffice or the pyuno library is not installed

How do I go about installing pyuno in the docker image and the collaborabasic* packages?

10

Hello @Muruguru,

I came across a helpful thread that might be a good starting point for you to get your script up and running:
How to install CollaboraOfficeBasis Python Script Provider and CollaboraOfficeBasis PyUNO

Best regards,
Darshan

11

Additionally we have a very basic example of a Collabora online ↔ web app available in our repository: collabora-online-sdk-examples/webapp/python at master · CollaboraOnline/collabora-online-sdk-examples · GitHub

12

Hi @darshan ,

I don’t see the examples that you pointed does any of doing the postMessage of CallPythonScript. I looked at the collaboraoffice online framed.html and framed.doc.html and I see some basic examples like Capitalize(), InsertText(), but I see the error when running it in my linux machine:

Dec 14 18:41:16 collabora-server coolwsd[35831]: kit-35831-35831 2024-12-14 18:41:16.398365 +0000 [ kitbroker_002 ] TRC drainQueue with 1 items: processing| kit/Kit.cpp:2393
Dec 14 18:41:16 collabora-server coolwsd[35831]: kit-35831-35831 2024-12-14 18:41:16.398376 +0000 [ kitbroker_002 ] TRC KitQueue(1) - pop child-00a uno vnd.sun.star.script:Capitalise.py$capitalisePython?language=Python&location=share| kit/KitQueue.cpp:421
Dec 14 18:41:16 collabora-server coolwsd[35831]: kit-35831-35831 2024-12-14 18:41:16.398382 +0000 [ kitbroker_002 ] TRC Kit handling queue message: child-00a uno vnd.sun.star.script:Capitalise.py$capitalisePython?language=Python&location=share| kit/Kit.cpp:2409
Dec 14 18:41:16 collabora-server coolwsd[35831]: kit-35831-35831 2024-12-14 18:41:16.398395 +0000 [ kitbroker_002 ] TRC ToMaster-00a: handling [uno vnd.sun.star.script:Capitalise.py$capitalisePython?language=Python&location=share]| kit/ChildSession.cpp:198
Dec 14 18:41:16 collabora-server coolwsd[35831]: kit-35831-35831 2024-12-14 18:41:16.398418 +0000 [ kitbroker_002 ] TRC ToMaster-00a: uno command vnd.sun.star.script:Capitalise.py$capitalisePython?language=Python&location=share notify: true| kit/ChildSession.cpp:2223
Dec 14 18:41:16 collabora-server coolwsd[35831]: kit-35831-35831 2024-12-14 18:41:16.400675 +0000 [ kitbroker_002 ] TRC Document::ViewCallback [4] [LOK_CALLBACK_UNO_COMMAND_RESULT] [{ “commandName”: “vnd.sun.star.script:Capitalise.py$capitalisePython?language=Python&location=share”, “success”: false, “result”: { “type”: “string”, “value”: “ScriptProtocolHandler::dispatch: caught com.sun.star.script.provider.ScriptFrameworkErrorException: invalid attempt to assign an empty interface of type com.sun.star.script.provider.XScriptProvider! at /opt/collaboraoffice/debugsource/include/com/sun/star/uno/Reference.hxx:105 at /opt/collaboraoffice/debugsource/scripting/source/provider/MasterScriptProvider.cxx:315”}, “wasModified”: true, “startUnixTimeMics”: 84532662149, “saveDurationMics”: 379}].| kit/Kit.cpp:1152

Our use case is as follows:

  1. We wanted to select the text in the document in iframe
  2. send the selected text to an external webservice outside of collabora
  3. receive the response from the external webservice and show the changes in collabora iframe
  4. I see CallPythonScript looks like an external way to call, but since the collaboraoffice is actually trying to call CallPythonScript, it is failing since the collabora is installed in /opt/collaboraoffice where as the libreoffice is in /usr/lib/libreoffice/ and the scripts are within libreoffice

Are there other alternatives?

13

I was able to resolve it after doing a installation of the provider and py-uno using local dpkg -i manually and the issue is resolved for me

1 Like