A link is formed to an external file with file://C: (three slash) And correctly two file://C:
What should be the bug? A path is written with three slashes: file:///c:/..... Its the normal behavior in LO Basic. Please give a little bit more information and describe where to find a buggy behavior.
It is worth trying to create an odb with an external Firebird file. I have tried on Windows 7 (installed version Libreoffice) and Windows 10 (portable version). An error occurs when I create a new database. LO can't find the file. If I remove unnecessary slash when you select a file creation passes without error. Maybe you should try?
I selected a connection to an existing database in the Wizard. Type in drop-down list the Firebird file.
I could only test with OpenSUSE 42.2 rpm Linux. I have tried to connect to a Firebird-file. It gives an error: ------- firebird_sdbc error: *unsupported on-disk structure for file /home/user/Dokumente/LibreOffice/Firebird/libretest.fdb; found 11.2, support 12.0 caused by 'isc_attach_database' ------- The path is this: file:///home/user/Dokumente/LibreOffice/Firebird/libretest.fdb If I will remove one slash after file:/ the whole LO crashes immediately when trying to connect to the database. I don't get any working connection to a Firebird-file directly.
Created attachment 139717 [details] Firebird external database file for testing.
Did it really work for you with two slashes, not three slashes? Please attach a database-file (no data inside needed) where it will work.
(In reply to robert from comment #4) > ... > firebird_sdbc error: > *unsupported on-disk structure for file > /home/user/Dokumente/LibreOffice/Firebird/libretest.fdb; found 11.2, support > 12.0 >... Reading https://stackoverflow.com/questions/43643098/why-do-i-get-an-unsupported-on-disk-structure-error-in-flamerobin, it would mean your ods file contains structure of Firebird 2.5 and you got Firebird server 3.0 However, I suppose it's a brand new ods file so it should be synchronized with Firebird 3.0 I'll give it a try as soon as my local build be finished. Tamas/Lionel: thought you might be interested in this one.
I think you need to check under Windows. Can there be an error only in case of Windows? In the content.xml generated string xlink:href="sdbc:firebird: file:///C:/my/testslash.fbd" This file is in LO opens but gives an error when navigating to the Tables folder. If you change to xlink:href="sdbc:firebird: file://C:/my/testslash.fbd" starts to work Now on computer does not have test-file FBD. If you want I can later send it to. You need file version Firebird 3.0
Hi Julien, (In reply to Julien Nabet from comment #7) > (In reply to robert from comment #4) > > ... > > firebird_sdbc error: > > *unsupported on-disk structure for file > > /home/user/Dokumente/LibreOffice/Firebird/libretest.fdb; found 11.2, support > > 12.0 > >... > > Reading > https://stackoverflow.com/questions/43643098/why-do-i-get-an-unsupported-on- > disk-structure-error-in-flamerobin, it would mean your ods file contains > structure of Firebird 2.5 and you got Firebird server 3.0 > However, I suppose it's a brand new ods file so it should be synchronized > with Firebird 3.0 Could be the database is Firebird 2.5. So I'm looking for an external database 3.0.
I can't test for the moment because I got a crash when just trying to launch Base. No pb with Writer, Calc or Impress
Created attachment 139761 [details] Firebird 3.0 file On pc Debian x86-64 with master sources updated today, I could open a Firebird 3.0 (attached file). Indeed, there are 3 slashes but it opens. I agree, that seeing 3 "/" is a bit weird.
I put in cc the bug which was preventing me to test it (entirely my fault but hopefully it's fixed now).
Test with OpenSUSE 42.2 64bit rpm Linux and Firebird 3.0 - file https://bugs.documentfoundation.org/attachment.cgi?id=139761 No problems to connect to the file with file:///home/user/Dokumente/LibreOffice/Firebird/example.fdb with Version: 6.0.0.3 Build-ID: 64a0f66915f38c6217de274f0aa8e15618924765 CPU-Threads: 4; BS: Linux 4.4; UI-Render: Standard; VCL: kde4; Gebietsschema: de-DE (de_DE.UTF-8); Calc: group
Tested on LO 6.0.1.1 (installation on windows 7). Received firebird_sdbc_error. But if on your OS everything is OK. I'm not going to argue.
Also WFM on Version: 6.0.0.3 Build ID: 64a0f66915f38c6217de274f0aa8e15618924765 Threads CPU : 8; OS : Mac OS X 10.13.3; UI Render : par défaut; Locale : fr-FR (fr_FR.UTF-8); Calc: group
Testing on Windows 10, with Version: 6.0.1.1 (x64) Build ID: 60bfb1526849283ce2491346ed2aa51c465abfe6 Threads CPU : 4; OS : Windows 10.0; UI Render : par défaut; Locale : fr-FR (fr_FR); Calc: group I get the following error message : firebird_sdbc error: *Unable to complete network request to host "MYHOSTNAME". *Failed to locate host machine. *The specified name was not found in the hosts file or Domain Name Services. caused by 'isc_attach_database
If I remove one of the slashes from the default triple slash path, I get the same error as reported here: Code d'erreur: 1 firebird_sdbc error: *unsupported on-disk structure for file C:\USERS\ALEXT\DOWNLOADS\LIBRETEST.FDB; found 11.2, support 12.0 caused by 'isc_attach_database'
Now, if I repeat the test with the sample db provided on 2018-02-10, and remove a single slash in the path, I can successfully open the fdb. There is therefore a difference in the fdb files provided as examples: - the first example, provided by Shar, doesn't work, irrespective of the number of slashes ; - the second example, provided by Robert, only works if I remove a single slash from the path to the file. @tamas : one for you ?
@Shar : did this work correctly in a previous version with a FB3.0 file ? If so, then, we can mark it as a regression.
Hi Alex, (In reply to Alex Thurgood from comment #18) > There is therefore a difference in the fdb files provided as examples: > > - the first example, provided by Shar, doesn't work, irrespective of the > number of slashes ; I had uploaded the first attachment. Was a Firebird 2.5-file. So I have set this to obsolet. > > - the second example, provided by Robert, only works if I remove a single > slash from the path to the file. Julien has added a new attachment with FB 3.0-file. This should work, but seems it doesn't with Windows.
*** Bug 121104 has been marked as a duplicate of this bug. ***
Dear shar, 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
Tested: Windows 10, LO : 6.3.2.2 Windows 7, LO 6.3.3.2 About: Version: 6.3.2.2 (x86) Build ID: 98b30e735bda24bc04ab42594c85f7fd8be07b9c CPU threads: 4; OS: Windows 10.0; UI render: default; VCL: win; Locale: ru-RU (ru_RU); UI-Language: en-US Calc: threaded Result: The connection to the data source "example" could not be established. firebird_sdbc error: *Unable to complete network request to host "SHAR". *Failed to locate host machine. *The specified name was not found in the hosts file or Domain Name Services. caused by 'isc_attach_database' For work need change to file://C:/shar/example.fdb
On Win10 with master sources updated 10 days ago +attachment Firebird 3.0 file, I could reproduce this.
Seems like a DUP of bug 106427 to me.
(In reply to avsharapov from comment #0) > And correctly two file://C: (In reply to Julien Nabet from comment #11) > Indeed, there are 3 slashes but it opens. > I agree, that seeing 3 "/" is a bit weird. Just FTR. The *correct* form for local file URL is using *three* forward slashes. The first two start "authority" part of file hierarchy; and the third coming immediately means "empty authority part, i.e. local system", and starts absolute path. Ref: RFC8089, which shows correct examples for URLs both on Unix-like, as well as Windows, paths. They indeed have three slashes. Two slashes and an absolute path without an "authority" (usually host) is invalid, although widely accepted as a commonly met variant.
(In reply to Mike Kaganski from comment #26) > (In reply to avsharapov from comment #0) > > And correctly two file://C: > > (In reply to Julien Nabet from comment #11) > > Indeed, there are 3 slashes but it opens. > > I agree, that seeing 3 "/" is a bit weird. > > Just FTR. > > The *correct* form for local file URL is using *three* forward slashes. The > first two start "authority" part of file hierarchy; and the third coming > immediately means "empty authority part, i.e. local system", and starts > absolute path. > > Ref: RFC8089, which shows correct examples for URLs both on Unix-like, as > well as Windows, paths. They indeed have three slashes. Two slashes and an > absolute path without an "authority" (usually host) is invalid, although > widely accepted as a commonly met variant. A very good theory. However, in practice, LO forms a link with three slashes. And an error occurs (Windows 10). If you change the link and make two slashes, then everything starts working. I vote for everything to work. :)(In reply to Mike Kaganski from comment #26) > (In reply to avsharapov from comment #0) > > And correctly two file://C: > > (In reply to Julien Nabet from comment #11) > > Indeed, there are 3 slashes but it opens. > > I agree, that seeing 3 "/" is a bit weird. > > Just FTR. > > The *correct* form for local file URL is using *three* forward slashes. The > first two start "authority" part of file hierarchy; and the third coming > immediately means "empty authority part, i.e. local system", and starts > absolute path. > > Ref: RFC8089, which shows correct examples for URLs both on Unix-like, as > well as Windows, paths. They indeed have three slashes. Two slashes and an > absolute path without an "authority" (usually host) is invalid, although > widely accepted as a commonly met variant. A very good theory. However, in practice, LO forms a link with three slashes. And an error occurs (Windows 10). If you change the link and make two slashes, then everything starts working. I vote for everything to work. :)
(In reply to avsharapov from comment #27) Which only means there's a bug where "An error occurs when I create a new database. LO can't find the file" - it should correctly treat proper URL.
(In reply to Mike Kaganski from comment #28) > (In reply to avsharapov from comment #27) > > Which only means there's a bug where "An error occurs when I create a new > database. LO can't find the file" - it should correctly treat proper URL. Ok. I agree.
https://gerrit.libreoffice.org/c/core/+/121885
Mike Kaganski committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/51269c4d28c04ebd2c0047772b7373e0bebec219 tdf#115547: Fix DB path handling It will be available in 7.3.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Mike Kaganski committed a patch related to this issue. It has been pushed to "libreoffice-7-2": https://git.libreoffice.org/core/commit/9601ca71b485bba6221e1e0ab88accf3e89a325b tdf#115547: Fix DB path handling It will be available in 7.2.2. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Mike Kaganski committed a patch related to this issue. It has been pushed to "libreoffice-7-1": https://git.libreoffice.org/core/commit/e4a87773d0f6a4a4eb8605cf8c3eb6c1cc8e7c27 tdf#115547: Fix DB path handling It will be available in 7.1.7. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.