Bug 92268 - Can't open document via webdav link + SSO
Summary: Can't open document via webdav link + SSO
Status: RESOLVED INSUFFICIENTDATA
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: LibreOffice (show other bugs)
Version:
(earliest affected)
4.4.3.2 release
Hardware: x86-64 (AMD64) Linux (All)
: medium minor
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: bibisectRequest, regression
Depends on:
Blocks:
 
Reported: 2015-06-23 07:39 UTC by Victor
Modified: 2017-10-30 10:51 UTC (History)
6 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Victor 2015-06-23 07:39:43 UTC
Dear all, We want to use LibreOffice as a production system in our env.

So, We have alfresco 4.2.4 as a our ECM system. Alfresco has configured with SSO support and it works fine with firefox browser.

So, for online edit with libreoffice we have installed zk-online-edition-0.2.jar and now we have link in alfresco for online edit.

If I use LibreOffice 4.2.8 (it comes from ubuntu 14.04), when I click on a link in firefox (online edit), I see open libreoffice with my document without ask a password (SSO works!).


But if I use Libreoffice 4.3+ or 4.4+ or even 5.0 - I can't open document from alfresco.


Technically it looks like this:

When I click "edit online" button in alfresco, firefox call libreoffice with the following command: libreoofice davs://myalfresco.com/documentPath

Libreoffice 4.2.8, can open this link with use my kerberos ticket, but new release libreoffice can't to do it (it just show libreoffice logo for 1 sec and closes without any error message).


I'll glad for any help to me.

We really want to use libreoffice in our env.

Best regards,
Victor.
Comment 1 Björn Michaelsen 2015-06-23 19:35:59 UTC
Prioritizing as per https://wiki.documentfoundation.org/images/0/06/Prioritizing_Bugs_Flowchart.jpg.

"... require users to not use some feature" -> minor/medium. (webdav is not a core feature)
Comment 2 Victor 2015-06-23 19:56:42 UTC
Thank for you attention. It is a very critical problem for production use. I'll glad for any help to me with it. I think many people use alfresco with LO.

We use LO 4.2.8 but it is not good idea becaue 4.2 is EOL.
Comment 3 Cor Nouws 2015-07-07 08:57:39 UTC
@bjoern,

(In reply to Björn Michaelsen from comment #1)
> "... require users to not use some feature" -> minor/medium. (webdav is not
> a core feature)

Basically this prevents the use of all features in the desired set up?
(sorry for adding you to cc)
Comment 4 tommy27 2015-08-15 18:44:38 UTC
@Giuseppe
can you retest this one with LibO 5.0.0.5 and tell if issue persists?
Comment 5 Giuseppe Castagno (aka beppec56) 2015-08-17 10:04:02 UTC
(In reply to tommy27 from comment #4)
> @Giuseppe
> can you retest this one with LibO 5.0.0.5 and tell if issue persists?

Need to setup a Alfresco Community server to test it.
It'll need some time, hoping the community version con be used to test this.

Looks similar to tdf#93327, though not exactly the same.
Comment 6 Giuseppe Castagno (aka beppec56) 2015-08-21 15:08:01 UTC
Victor:

I checked the bug as follow;

I installed Alfresco Community v 5.0.d, installed zk-online-edition-0.2.jar from:
https://code.google.com/p/alfresco-share-online-edition-addon

Looking at:
https://code.google.com/p/alfresco-share-online-edition-addon/#Registering_the_dav_protocol_in_Linux

the configuration seemed to be for a 'resident' LO installation, so I changed it:

----------------- *** ----------------------
Create file /usr/share/applications/libreoffice5-alf.desktop

[Desktop Entry]
Encoding=UTF-8
Version=1.0
Name=LibreOffice 5 for Alfresco
GenericName=LibreOffice 5 for Alfresco
Comment=Online Editing in Alfresco via webdav
Icon=libreoffice5-writer
TryExec=/opt/libreoffice5.0/program/soffice
Exec=/opt/libreoffice5.0/program/soffice %U
Terminal=false
Type=Application
Categories=Office;
MimeType=x-scheme-handler/davs;x-scheme-handler/dav

In /usr/share/applications/mimeinfo.cache add the following lines,

x-scheme-handler/davs=libreoffice5-alf.desktop;
x-scheme-handler/dav=libreoffice5-alf.desktop;

And finally,

$ sudo update-desktop-database

----------------- *** ----------------------
If it's the case, adjust the LO 5 path used in the .desktop file as
suited for your installation.

After all this restart the browser, so the new conf will be read.

Then, following the instruction at:
https://code.google.com/p/alfresco-share-online-edition-addon/#Action_menu_link

I logged in to Alfresco, opened the action menu on the test file, selected Edit Online, I was offered a choice to open it using the new configuration:
LibreOffice 5 for Alfresco.

LO 5 started, asked my credentials the opened the file.

Probably with more than one of the configuration above, more choice
will be presented.

Please check it.
Comment 7 Victor 2015-08-21 21:17:01 UTC
Dear, Giuseppe Castagno
 
Very BIG THANK for you test!
 
But bug is about SSO. Not for plain text login. For a full correct test, you need to configure SSO alfresco (kerberos+ldap), and configure your linux host with kerberos too. After that, you need to configure a web-dav linux clt for use kerberos, like this:
 

    apt-get install davfs2
    dpkg-reconfigure davfs2 - allow mount for any user
    mkdir /mnt/alfresco
    chown user:user /mnt/alfresco
    fstab: https://alfresco/alfresco/webdav /mnt/alfresco davfs user,noauto,file_mode=600,dir_mode=700 0 1
    /etc/davfs2/davfs2.conf - ask_auth 0
    add your user to davfs2: usermod -a -G davfs2 user ; newgrp davfs2
    chmod 600 /home/user/.davfs2/secrets
    $ mount /mnt/alfresco/ ---- it should to mount without a password

After this step Edit Online - should open your document without ask your password! -- That is SSO!
 
So, if you have a time for this test, it will be GOOD.
 
Thank you,
best regards, Victor.
Comment 8 tommy27 2016-12-03 06:38:30 UTC
@Victor and Giuseppe Castagno
is this bug still reproducible with LibO 5.2.3.3?

status NEEDINFO.

set back to UNCONFIRMED if bug is still there (NEW if there's an independent confirmation) or RESOLVED WORKSFORME if the bug is gone.
Comment 9 Victor 2017-03-25 20:59:34 UTC
(In reply to tommy27 from comment #8)
> @Victor and Giuseppe Castagno
> is this bug still reproducible with LibO 5.2.3.3?
> 
> status NEEDINFO.
> 
> set back to UNCONFIRMED if bug is still there (NEW if there's an independent
> confirmation) or RESOLVED WORKSFORME if the bug is gone.

Dear tommy27, we have switched from libreoffice to MS office because of this bug. If we will test it again I will reply to this topic. Thank a lot for you answer.
Comment 10 QA Administrators 2017-09-29 08:57:46 UTC Comment hidden (obsolete)
Comment 11 Xisco Faulí 2017-10-30 10:51:25 UTC
Dear Bug Submitter,

Please read this message in its entirety before proceeding.

Your bug report is being closed as INSUFFICIENTDATA due to inactivity and
a lack of information which is needed in order to accurately
reproduce and confirm the problem. We encourage you to retest
your bug against the latest release. If the issue is still
present in the latest stable release, we need the following
information (please ignore any that you've already provided):

a) Provide details of your system including your operating
   system and the latest version of LibreOffice that you have
   confirmed the bug to be present

b) Provide easy to reproduce steps – the simpler the better

c) Provide any test case(s) which will help us confirm the problem

d) Provide screenshots of the problem if you think it might help

e) Read all comments and provide any requested information

Once all of this is done, please set the bug back to UNCONFIRMED
and we will attempt to reproduce the issue. Please do not:

a) respond via email 

b) update the version field in the bug or any of the other details
   on the top section of our bug tracker

Warm Regards,
QA Team

MassPing-NeedInfo-20171030