Bug 72504

Hi,

(In reply to comment #0)
> ODB file is located on server (smb) share (x_workdisk on 192.168.1.2), which
> gets mounted in my filesystem.
How do you mount it?

> The database can be opened and edited on other computers running Ubuntu 12.04
> and 12.10.
With LibreOffice 4.1, or with an older version?

> My PC could also open and
> edit the ODB file when running Ubuntu 13.04 (and the version of LibreOffice
> that came with that version of OS).
Which is version 4.0 I guess. What happens if you open it on this PC from the command line (like 'libreoffice smb://192.168.1.2/share_name/doc_name.odb')?

(In reply to comment #1)
> Hi,
> 
> (In reply to comment #0)
> > ODB file is located on server (smb) share (x_workdisk on 192.168.1.2), which
> > gets mounted in my filesystem.
> How do you mount it?
Using GUI. Bookmarked in "Files", so clicking on bookmark mounts and opens folder. Originally as "Connect to Server".  I've been doing it the same way for years.
> 
> > The database can be opened and edited on other computers running Ubuntu 12.04
> > and 12.10.
> With LibreOffice 4.1, or with an older version?
With older version (3.5.7.2) on 12.04.
> 
> > My PC could also open and
> > edit the ODB file when running Ubuntu 13.04 (and the version of LibreOffice
> > that came with that version of OS).
> Which is version 4.0 I guess. What happens if you open it on this PC from
> the command line (like 'libreoffice
> smb://192.168.1.2/share_name/doc_name.odb')?
Exactly the same thing. Main database window opens OK, double-click on a table or form to open it, and the same error message is displayed.
LibreOffice 4.1.2.3 on my PC is able to open and edit ODS and ODT files that are located in the same folder on the server.  Problem is specific to ODB files, it seems.

Confirmed with 4.1.3.2 (GIO build) & master (GNOME-VFS build, Build ID: 93210ec3b3e7e773e998a3771136043748232f85) under Fedora 19 (64-bit). I get this error when trying to switch to 'Tables'.

As a workaround open /usr/share/applications/libreoffice-base.desktop file, and comment the line 'X-GIO-NoFuse=true'. Also make sure you have 'gvfs-fuse' package. This will bring back the old behavior.

(In reply to comment #3)
> As a workaround open /usr/share/applications/libreoffice-base.desktop file,
Note that this file will be replaced with every LibreOffice update.

I can reproduce this bug also with ftp (same env as above). I'll change the summary to reflect that.

(In reply to comment #3)
> Confirmed with 4.1.3.2 (GIO build) & master (GNOME-VFS build, Build ID:
> 93210ec3b3e7e773e998a3771136043748232f85) under Fedora 19 (64-bit). I get
> this error when trying to switch to 'Tables'.
> 
> As a workaround open /usr/share/applications/libreoffice-base.desktop file,
> and comment the line 'X-GIO-NoFuse=true'. Also make sure you have
> 'gvfs-fuse' package. This will bring back the old behavior.

Thank you for the workaround - it works as you predicted. To comment the line, I actually had to edit /usr/lib/libreoffice/share/xdg/base.desktop.  Also I note your comment #4.

(In reply to comment #4)
> Note that this file will be replaced with every LibreOffice update.
Just forgot: You can make a copy of this file to your user profile at .local/share/applications, and it should override the system one, so you won't need to edit it after every upgrade.

@Caolán: this seems to be a side-effect of

 commit f574e1defdb537bdd741edd2523563aa0b03be5a
 Author: Caolán McNamara <caolanm@redhat.com>
 Date:   Tue Apr 2 15:52:41 2013 +0100

    add X-GIO-NoFuse so we get url:// instead of file://~.gvfs/


The code in connectivity/source/drivers/hsqldb/HDriver.cxx
ODriverDelegator::connect
expects a file:// URL, which is exactly what your commit changes...

Do you have any hint for us on how to adapt that code to deal with non-file:// URLs, or "infer" the equivalent "file://~.gvfs/" or some other way out?

hmm... inferring the equivalent file://~.gvfs/ etc would only work for the specific Linux + gio mounted case, not other platforms or mechanisms.

(In reply to comment #9)
> hmm... inferring the equivalent file://~.gvfs/ etc would only work for the
> specific Linux + gio mounted case, not other platforms or mechanisms.

Well, it would solve the regression, which according to my understanding is *only* in the case of "gio mounted".

hacking on trying to get base to support remote files is seems that base is unhappy on anything that doesn't support the supposed optional XActiveDataStreamer in ucb. e.g. the attached patch breaks base on local files

Created attachment 90995 [details]
this breaks local files the same way attempting to allow remote files end up

some more debugging required here.

(This is an automated message.)

Setting priority to highest as this is a 4.1 MAB. This is part of an effort to make the importance of MAB reflected in priority too.

according to comment #8 broken since 4.1.0 release

please retest against current 4.2.4.2 release.
if issue is still there, please move it to mab4.2 list since 4.1.x is EOL

(In reply to comment #15)
> please retest against current 4.2.4.2 release.
> if issue is still there, please move it to mab4.2 list since 4.1.x is EOL
done.

Also exists in KUbuntu's LibreOffice version 1:4.2.3~rc3-0ubuntu2.

please retest with recent 4.3.x or 4.4.x versions and tell if bug persists.
if yes, move this bug to mab4.3 list (Bug 75025) since 4.2.x is END OF LIFE

TESTING with LO Daily build (2014-12-09) on Ubuntu 14.04
Version: 4.5.0.0.alpha0+
Build ID: df62a2c81bef2bcd96a5f14802e41815f0bdc2da
TinderBox: Linux-rpm_deb-x86_64@46-TDF, Branch:master

(In reply to TriumphGuru from comment #0)
>

REPRO Steps:

- Put these test files on the local system and the remote server
ODT (attachment 96587 [details])
ODS (attachment 110499 [details])
ODB (attachment 58813 [details])

I used an ftp server:
(Using the regular dialogs didn't work, so I used the LibreOffice dialogs:
  Tools -> Options -> General -> Use LibreOffice dialogs
Then click on the 'Server' button to add FTP server info)

- Check that you can open/edit the local files without error (For the ODB, just try to open a table)
- Check that you can open/edit the remote ODT and ODS files without error

That works

- Try to open the ODB file

> Able to open ODB file, but attempts to open a
> form for data entry or open a table results in error message: "SQL Status:
> HY000
> The given URL contains no valid local file system path. Please check the
> location of your database file."

RESULT:

File opens, but things look grayed-out. Clicking on the 'Tables' icon gives me a dialog "The connection to the data source "fdo45789" could not be established.... the given URL contains no valid local filesystem path..."

CONFIRMED with LO 4.5.0.0 (master)

mab4.2 -> mab4.3

Adding self to CC if not already on

Adding Keywords: bisected to indicate that a commit has already been identified for the regression