Root user access in synapse notebooks

[AdarshPanasri]

Hello Everyone, I am trying to install LibreOffice in fabric, I am using the below commands to downlad and extract the tar files.

wget https://download.documentfoundation.org/libreoffice/stable/24.2.5/rpm/x86_64/LibreOffice_24.2.5_Linux_x86-64_rpm_sdk.tar.gz

tar xzvf LibreOffice_24.2.5_Linux_x86-64_rpm_sdk.tar.gz.1

cd LibreOffice_24.2.5.2_Linux_x86-64_rpm_sdk/RPMS

But I am not able to install it, it seems I need to provide password to install the package, I used the below but still getting errors.

echo <password> | sudo -S yum install ./LibreOffice_24.2.5_Linux_x86-64_rpm_sdk.tar.gz

AND

echo '#!/bin/bash' > /tmp/askpass.sh

echo 'echo "<PASSWORD>"' >> /tmp/askpass.sh

chmod +x /tmp/askpass.sh

export SUDO_ASKPASS=/tmp/askpass.sh

sudo -A dnf install ./LibreOffice_7.6.4_Linux_x86-64_rpm.tar.gz

Has someone tried this ?

[Anonymous]

Hi @AdarshPanasri,

Do you mean you are try to install the library to the notebook environment root path and faced the permission requirement?

If that is the case, I don't thank you can directly use these high premissions commands.
For fabric notebook, you can try to use #pip command to install the library inline or directory attach them into the environments.

Here are the reference links.

Notebook magic commands:

Develop, execute, and manage notebooks - Microsoft Fabric | Microsoft Learn

Inline library install:

Manage Apache Spark libraries - Microsoft Fabric | Microsoft Learn

Library mange in fabric environment:

Library management in Fabric environments - Microsoft Fabric | Microsoft Learn

Regards,

Xiaoxin Sheng

[AdarshPanasri]

Thanks for the response, but this is not what I was looking for, I want to install a linux package LibreOffice, I dont think this can be done using pip cmnds.

I am using the %%sh magic cmds to run the shell cmds but when trying to install the package It says you are not a root user.

My doubt is how do I get the rights be a super user. I tried with the Admin credentials for the workspace but still got the same error.

Any support is appreciated. 

[lbendlin]

What do you plan to use LibreOffice for once it is installed?  Read Excel files?

[AdarshPanasri]

I intend to use it to Interact with doc files. As per my research I was not able to find a way to read/get content from doc file without converting it to docx first. And using LibreOffice should solve this.

[Anonymous]

HI @AdarshPanasri,

I'd like to suggest you try to use python-docx library to instead, it also can integrate notebook with docx files:

python-docx — python-docx 1.1.2 documentation

Regards,

Xiaoxin Sheng

[AdarshPanasri]

I tried with python-docx it is not compatible to work with doc files.

[Anonymous]

HI @AdarshPanasri,

If the above not suitable for your requirement, you can also take a look the following link about read data from doc/docx files if helps:

ms word - How do I extract data from a doc/docx file using Python - Stack Overflow

Regards,

Xiaoxin Sheng