ODB file is located on server (smb) share (x_workdisk on 192.168.1.2), which gets mounted in my filesystem. 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." The problem only occurred after I installed Ubuntu 13.10 with LibreOffice 4.1.2.3 Build ID: 410m0(Build:3). The database can be opened and edited on other computers running Ubuntu 12.04 and 12.10. 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). I am able to open and edit ODT spreadsheets located in the same folder on the server without a problem. No configuration changes have been made to the server, which is running Ubuntu 11.04 (which has OpenOffice 3.2).
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
Migrating Whiteboard tags to Keywords: (bibisected) [NinjaEdit]
I'm migrating some Windows machines to Ubuntu 16.04 and I found this old annoying bug. It seems to open ODB files when are mounted in FSTAB, but I strictly need "smb://server/share" URL feature. FSTAB is not an option in my setup and I feel stuck.
(In reply to Guillermo Lo Coco from comment #23) > I'm migrating some Windows machines to Ubuntu 16.04 and I found this old > annoying bug. > > It seems to open ODB files when are mounted in FSTAB, but I strictly need > "smb://server/share" URL feature. > > FSTAB is not an option in my setup and I feel stuck. Hi Guillermo, Apologies that you feel stuck but this is a volunteer project. Thanks for confirming you hit this issue also but that will not push the bug to being fixed any faster. We have a few thousand open bugs, this is a volunteer project - volunteers fix bugs when they find them interesting. Base is hands down our least popular component and there aren't a lot of developers that enjoy working on it so it might be some time before it's resolved (it might never be resolved). So, you should figure out a solution that works for you given this constraint. Just want to be honest with you about the status of how bugs get fixed in our project. Best, Joel
Thanks Joel, I appreciate your sincerity and very fast reply.
Hi Joel, I tried ftp:// URL and also not work. Maybe you can point me out an alternative. A shared workstation, most of them share the same guest user, and connect to a server with different privileges. Fstab credentials are static. I need something a user can fill with user/pass, like "Connect to Server" dialog. (the small business I'm helping made a great effort to redesign there DB in Base, I never thought this gonna happend) Thanks for your patience.
(In reply to Guillermo Lo Coco from comment #26) > Hi Joel, > > I tried ftp:// URL and also not work. Maybe you can point me out an > alternative. I honestly have no idea - I don't do enterprise level stuff. Ask on ask.libreoffice.org or on the user mailing list. Best, Joel
Today I was trying to load a BASE ODB from my USB-connected mobile storage and found out the same error. LO Base is unable to load any file located in GVFS share (smb, ftp, mtp, and so on) Is this bug trivial ?
Adding Cc: to Caolán McNamara
(In reply to Guillermo Lo Coco from comment #26) > Maybe you can point me out an alternative. It's a long shot, but do you want to try again and see if it is fixed now (in 5.2.4 or higher). There was a similar sounding .xls problem in Bug 62625 that has been resolved. Alternatively, I know you don't want an fstab solution, but perhaps if you add options ,noauto,x-systemd.automount it might be acceptable? Then the mount will only happen if you try to access the database folder, and not automatically on every start.
(In reply to Justin L from comment #30) > It's a long shot, but do you want to try again and see if it is fixed now > (in 5.2.4 or higher). There was a similar sounding .xls problem in Bug > 62625 that has been resolved. I should have tested myself first. No, that doesn't work in this situation.
Still exists in 5.1.6.2 (UBUNTU 16.04). Since most Linux systems do not automount smb shares but rather use the smb URL protocol, it is not possible to fully access, from Linux, the LO Documents in shares. Adding this in case it has some useful info: running a file in: smb://MyFileServer/MyShare/ Παρουσιάστηκε ένα σφάλμα σκελετού σεναρίου κατά την εκτέλεση του σεναρίου Python vnd.sun.star.script:LibraryTA|mdlgeneral.py$initapp?language=Python&location=document. Μήνυμα: <class 'uno.com.sun.star.uno.RuntimeException'>: Couldn't convert file url to a system path for reason (21) /usr/lib/python3/dist-packages/unohelper.py:184 in function fileUrlToSystemPath() [return pyuno.fileUrlToSystemPath( url )] vnd.sun.star.tdoc:/48755696/Scripts/python/LibraryTA/mdlgeneral.py:34 in function <module>() [] /usr/lib/libreoffice/program/pythonscript.py:452 in function getModuleByUrl() [exec(code, entry.module.__dict__)] /usr/lib/libreoffice/program/pythonscript.py:993 in function getScript() [mod = self.provCtx.getModuleByUrl( fileUri )] python script: 33: thisODB = XSCRIPTCONTEXT.getDocument() 34: tmpurl = unohelper.fileUrlToSystemPath('{}/{}'.format(thisODB.URL,'Scripts/python/LibraryTA'))
Dear TriumphGuru, To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from http://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://kiwiirc.com/nextclient/irc.freenode.net/#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug
Je suis sur UBUNTU 18.04 LTS, et quand je veux ouvrir LIBRE OFFICE, une boîte apparait où il est écrit "JRE is defective", bon j'ai téléchargé Java, ùais je n'arrive pas à l'installer, que dois-je faire ? Merci pour votre aide. Gérard.
Thank you so much for your research. Our community often puts off medical advice and intervention let alone the stigma associated with mental illnesses. https://centralguide.net/subaru-customer-service-phone-number/
I like the helpful information you provide to your articles. I’ll bookmark your blog and test once more right here regularly.
Thanks all for your responses. It's helpful.
repro 7.2+. Error message is: The connection to the data source "FILENAME" could not be established. The connection to the external data source could not be established. No SDBC driver was found for the URL "sdbc:embedded:hsqldb'./path/to/git/libreoffice/connectivity/source/commontools/dbexception:400.
Dear TriumphGuru, To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from https://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://web.libera.chat/?settings=#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug
Tested today as per request #39 from QA Administrators. Test done with: LibreOffice version 7.3.6.2. Environment: CPU threads: 16; OS: Linux 5.15 User Interface: UI render: default; VCL: gtk3 Locale: en-AU (en_AU.UTF-8); UI: en-US Misc: Ubuntu package version: 1.7.3.6.2-0ubuntu0.22.04.2. Calc: threaded Problem still exists, as per error message box: "The connection to the data source "Database name" could not be established. SQL Status: HY000 The given URL contains no valid local file system path. Please check the location of your database file. ./connectivity/source/commontools/dbexception.cxx:413"