[Libreoffice-bugs] [Bug 141846] Firebird 3 - failure to connect to Firebird file - file structure incompatibility on macOS
https://bugs.documentfoundation.org/show_bug.cgi?id=141846
--- Comment #20 from Mike Kaganski ---
(In reply to Alex Thurgood from comment #16)
> If I've understood your big/little endian comment, it basically means that
> in an enterprise setting, or for an association or club, that it will be
> impossible to have one single ODB file covering all OS arch.
As said, LibreOffice's embedded DB stores a *backup*, not the FDB itself. And
the backups are platform-independent; that means that ODBs with embedded
databases *are* cross-platform: on any platform, LibreOffice first expands the
internal FBK to an FDB native for current host, then works with it, and finally
backs up the end result and stores the new FBK into ODB, ready for work on any
other system.
Also working with a FB server would ne problem-free: the server runs on its
platform, and connecting to if from anywhere is OK (just not implemented using
our SDBC driver yet).
What would be (expectedly) problematic is working with a separate FDB ("connect
to existing Firebird file"): the FDBs are platform- and version-specific.
--
You are receiving this mail because:
You are the assignee for the bug.
[Libreoffice-bugs] [Bug 141846] Firebird 3 - failure to connect to Firebird file - file structure incompatibility on macOS
https://bugs.documentfoundation.org/show_bug.cgi?id=141846 Alex Thurgood changed: What|Removed |Added Status|RESOLVED|VERIFIED --- Comment #19 from Alex Thurgood --- Also verified fixed in Version: 7.2.1.2 / LibreOffice Community Build ID: 87b77fad49947c1441b67c559c339af8f3517e22 CPU threads: 8; OS: Mac OS X 11.5.2; UI render: default; VCL: osx Locale: fr-FR (fr_FR.UTF-8); UI: fr-FR Calc: threaded Unfortunately, still not fixed however in Collabora Office Version: 21.06.4.1 Build ID: 5ad6bfb54ffec15fe311ed990aa1518979b8f086 CPU threads: 8; OS: Mac OS X 11.5.2; UI render: default; VCL: osx Locale: fr-FR (fr_FR.UTF-8); UI: fr-FR Calc: threaded -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 141846] Firebird 3 - failure to connect to Firebird file - file structure incompatibility on macOS
https://bugs.documentfoundation.org/show_bug.cgi?id=141846 --- Comment #18 from Alex Thurgood --- Confirmed fixed when testing with Version: 7.2.0.4 / LibreOffice Community Build ID: 9a9c6381e3f7a62afc1329bd359cc48accb6435b CPU threads: 8; OS: Mac OS X 11.5.2; UI render: default; VCL: osx Locale: fr-FR (fr_FR.UTF-8); UI: fr-FR Calc: threaded -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 141846] Firebird 3 - failure to connect to Firebird file - file structure incompatibility on macOS
https://bugs.documentfoundation.org/show_bug.cgi?id=141846 --- Comment #17 from Alex Thurgood --- (In reply to Mike Kaganski from comment #15) > (In reply to Mike Kaganski from comment #14) > > since LO 7.2, where FB was upgraded from 3.0.0 to 3.0.7 [1], the > > ODS 12.2 (from 3.0.4) should be supported > > So resolved fixed by the mentioned commit. Thanks for doing this ! -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 141846] Firebird 3 - failure to connect to Firebird file - file structure incompatibility on macOS
https://bugs.documentfoundation.org/show_bug.cgi?id=141846 --- Comment #16 from Alex Thurgood --- (In reply to Mike Kaganski from comment #13) > The overall policy of the project seems to require use of > backup-move-restore procedure whenever you want to move a BD to a different > system; LibreOffice embedded engine itself save the backup of the FDB, not > the FDB itself, for that reason. By the way, IIRC the ODS even of the same > version will differ on Big-Endian vs Little-Endian machines, making direct > move of a FDB of the same ODS version impossible. > This is hugely awkward for cross-platform compatibility with regard to the project's choice of embedded database which is slated to become the default. If I've understood your big/little endian comment, it basically means that in an enterprise setting, or for an association or club, that it will be impossible to have one single ODB file covering all OS arch. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 141846] Firebird 3 - failure to connect to Firebird file - file structure incompatibility on macOS
https://bugs.documentfoundation.org/show_bug.cgi?id=141846 Mike Kaganski changed: What|Removed |Added Status|UNCONFIRMED |RESOLVED Resolution|--- |FIXED --- Comment #15 from Mike Kaganski --- (In reply to Mike Kaganski from comment #14) > since LO 7.2, where FB was upgraded from 3.0.0 to 3.0.7 [1], the > ODS 12.2 (from 3.0.4) should be supported So resolved fixed by the mentioned commit. The problem related to support of ODSv13 (i.e., upgrading embedded Firebird engine to v4) needs a separate issue, with its own regressions ;) -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 141846] Firebird 3 - failure to connect to Firebird file - file structure incompatibility on macOS
https://bugs.documentfoundation.org/show_bug.cgi?id=141846 --- Comment #14 from Mike Kaganski --- (In reply to Alex Thurgood from comment #0) > firebird_sdbc error: > *unsupported on-disk structure for file > /Library/Frameworks/Firebird.framework/Versions/A/Resources/examples/ > empbuild/employee.fdb; found 12.2, support 12.0 > caused by > 'isc_attach_database' By the way, since LO 7.2, where FB was upgraded from 3.0.0 to 3.0.7 [1], the ODS 12.2 (from 3.0.4) should be supported on macOS, but then 12.0 would be unsupported, for the reasons described in comment 13. [1] https://gerrit.libreoffice.org/c/core/+/105440 -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 141846] Firebird 3 - failure to connect to Firebird file - file structure incompatibility on macOS
https://bugs.documentfoundation.org/show_bug.cgi?id=141846 --- Comment #13 from Mike Kaganski --- Firebird itself does not support older on-disk structures (ODS). This is true both for version 3 [1], and version 4 [2]. (Release notes for v4 do mention a hack to support ODSv12 by copying a library from older version to /plugins; while it could in theory be made for Windows, it's likely totally impossible for Linux, where we rely on system FB, and thus custom (self-built?) library for FB3.0 could fail to work with system FB4.0.) The 12 vs 12.2 change was described in FB 3.0.4 release notes [3]. It is described to have impact on macOS and 32-bit Linux; and note this excerpt: > Existing databases ... are always opened successfully with Firebird 3.0.4 > on the platform *where they were initially created* The overall policy of the project seems to require use of backup-move-restore procedure whenever you want to move a BD to a different system; LibreOffice embedded engine itself save the backup of the FDB, not the FDB itself, for that reason. By the way, IIRC the ODS even of the same version will differ on Big-Endian vs Little-Endian machines, making direct move of a FDB of the same ODS version impossible. And hence I consider this issue to be NOTABUG (assuming that it was a user error not using the proper procedure when moving the database), or NOTOURBUG (taking into account the phrase "A legacy provider for databases with ODS 8 to 11.2 is planned for a future sub-release" from 3.0 release notes, which is curiously absent from 4.0 release notes). [1] https://firebirdsql.org/file/documentation/release_notes/html/en/3_0/rlsnotes30.html#_other_providers [2] https://firebirdsql.org/file/documentation/release_notes/html/en/4_0/rlsnotes40.html#rnfb40-general [3] https://firebirdsql.org/file/documentation/release_notes/html/en/3_0/rlsnotes30.html#rnfb30-apiods-ods-12-2 -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 141846] Firebird 3 - failure to connect to Firebird file - file structure incompatibility on macOS
https://bugs.documentfoundation.org/show_bug.cgi?id=141846 Julien Nabet changed: What|Removed |Added CC||serval2...@yahoo.fr See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=11 ||5547 --- Comment #12 from Julien Nabet --- Now that tdf#115547 is fixed (from next releases 7.2.2/7.1.7), does it change something or is it still exactly the same error? -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 141846] Firebird 3 - failure to connect to Firebird file - file structure incompatibility on macOS
https://bugs.documentfoundation.org/show_bug.cgi?id=141846 steve changed: What|Removed |Added Summary|Firebird 3 - failure to |Firebird 3 - failure to |connect to Firebird file - |connect to Firebird file - |file structure |file structure |incompatibility (MacOS) |incompatibility on macOS -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 141846] Firebird 3 - failure to connect to Firebird file - file structure incompatibility (MacOS)
https://bugs.documentfoundation.org/show_bug.cgi?id=141846 --- Comment #11 from Alex Thurgood --- Yes, the path construction error is a relatively old and known bug on Windows, which has nothing to do with the FB engine version support. Neither FB4, which has a 13.0 engine disk structure, nor currently released versions of FB3 > 12.0 are supported by LO. Basically, the following commits need to be reworked to take account of current Firebird releases : https://cgit.freedesktop.org/libreoffice/core/commit/?id=45f42681f4d1260c42140a313560534e605f81a4 -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 141846] Firebird 3 - failure to connect to Firebird file - file structure incompatibility (MacOS)
https://bugs.documentfoundation.org/show_bug.cgi?id=141846 --- Comment #10 from Robert Großkopf --- (In reply to juancsanzc from comment #9) > > But if in step 5 I change the url to > "file://C:/Users/jc/BD/employee_FB3.fdb" (with two slashes after file:) I > can connect succesfully This is bug 115547 -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 141846] Firebird 3 - failure to connect to Firebird file - file structure incompatibility (MacOS)
https://bugs.documentfoundation.org/show_bug.cgi?id=141846 --- Comment #9 from juancsa...@hotmail.com --- (In reply to Robert Großkopf from comment #8) > (In reply to juancsanzc from comment #7) > > > > > You are using the example, which comes with Firebird 4. This will give the > > > same error here on OpenSUSE 15.2. But the bug is reported for Firebird 3 > > > (and also the employee.fdb of Firebird 3) > > > > Yes, that's right, I was using a Firebir 4, but the error is the same if I > > use your sample database. > > Really the same with "found 13.0, support 12.0"? > > > > > On the other hand, I think I found the error: > > If I use the wizard to connect, and I browse to find the file, I obtain a > > full path like "file:///C:/Users/jc/BD/employee_FB3.fdb", that produce the > > error. > > But if I delete one slash after "file:" so the path is > > "file://C:/Users/jc/BD/employee_FB3.fdb", I can connect > > So connection is working with FB3, isn't it? > I have thought the first path would be the right, but I have no Windows to > test. So we should have a look at the connection-string for Windows. No, sorry, I´ve explained it badly and may be differen error. If I use the wizard to connect to a file: 1 Open Base 2 Select connect to an existing database 3 Select Firebird file 4 Select Browse button 5 Browse to the file an obtain a ¿url? like "file:///C:/Users/jc/BD/employee_FB3.fdb" 6 Clic Finish 7 Save the odb file 8 I obtain the error "firebird_sdbc error: *Unable to complete network request to host "servidor1". *Failed to locate host machine. *The specified name was not found in the hosts file or Domain Name Services. caused by 'isc_attach_database' But if in step 5 I change the url to "file://C:/Users/jc/BD/employee_FB3.fdb" (with two slashes after file:) I can connect succesfully -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 141846] Firebird 3 - failure to connect to Firebird file - file structure incompatibility (MacOS)
https://bugs.documentfoundation.org/show_bug.cgi?id=141846 --- Comment #8 from Robert Großkopf --- (In reply to juancsanzc from comment #7) > > > You are using the example, which comes with Firebird 4. This will give the > > same error here on OpenSUSE 15.2. But the bug is reported for Firebird 3 > > (and also the employee.fdb of Firebird 3) > > Yes, that's right, I was using a Firebir 4, but the error is the same if I > use your sample database. Really the same with "found 13.0, support 12.0"? > > On the other hand, I think I found the error: > If I use the wizard to connect, and I browse to find the file, I obtain a > full path like "file:///C:/Users/jc/BD/employee_FB3.fdb", that produce the > error. > But if I delete one slash after "file:" so the path is > "file://C:/Users/jc/BD/employee_FB3.fdb", I can connect So connection is working with FB3, isn't it? I have thought the first path would be the right, but I have no Windows to test. So we should have a look at the connection-string for Windows. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 141846] Firebird 3 - failure to connect to Firebird file - file structure incompatibility (MacOS)
https://bugs.documentfoundation.org/show_bug.cgi?id=141846 --- Comment #7 from juancsa...@hotmail.com --- > You are using the example, which comes with Firebird 4. This will give the > same error here on OpenSUSE 15.2. But the bug is reported for Firebird 3 > (and also the employee.fdb of Firebird 3) Yes, that's right, I was using a Firebir 4, but the error is the same if I use your sample database. On the other hand, I think I found the error: If I use the wizard to connect, and I browse to find the file, I obtain a full path like "file:///C:/Users/jc/BD/employee_FB3.fdb", that produce the error. But if I delete one slash after "file:" so the path is "file://C:/Users/jc/BD/employee_FB3.fdb", I can connect -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 141846] Firebird 3 - failure to connect to Firebird file - file structure incompatibility (MacOS)
https://bugs.documentfoundation.org/show_bug.cgi?id=141846 --- Comment #6 from Robert Großkopf --- Created attachment 173490 --> https://bugs.documentfoundation.org/attachment.cgi?id=173490=edit Firebird 3 employee database for testing -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 141846] Firebird 3 - failure to connect to Firebird file - file structure incompatibility (MacOS)
https://bugs.documentfoundation.org/show_bug.cgi?id=141846 --- Comment #5 from Robert Großkopf --- (In reply to juancsanzc from comment #4) > Bug also present in: > > Version: 7.1.4.1 (x64) / LibreOffice Community > Build ID: f67b1ddedeb24fca1c5938e7cebfab73d708b35b > CPU threads: 2; OS: Windows 10.0 Build 19042; UI render: Skia/Raster; VCL: > win > Locale: es-ES (es_ES); UI: es-ES > Calc: threaded > > Firebird server version: WI-V4.0.0.2496 fIREBIRD 4.0 > > Error Message: > firebird_sdbc error: > *unsupported on-disk structure for file C:\PROGRAM > FILES\FIREBIRD\FIREBIRD_4_0\EXAMPLES\EMPBUILD\EMPLOYEE.FDB; found 13.0, > support 12.0 > caused by > 'isc_attach_database' You are using the example, which comes with Firebird 4. This will give the same error here on OpenSUSE 15.2. But the bug is reported for Firebird 3 (and also the employee.fdb of Firebird 3) -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 141846] Firebird 3 - failure to connect to Firebird file - file structure incompatibility (MacOS)
https://bugs.documentfoundation.org/show_bug.cgi?id=141846 --- Comment #4 from juancsa...@hotmail.com --- Bug also present in: Version: 7.1.4.1 (x64) / LibreOffice Community Build ID: f67b1ddedeb24fca1c5938e7cebfab73d708b35b CPU threads: 2; OS: Windows 10.0 Build 19042; UI render: Skia/Raster; VCL: win Locale: es-ES (es_ES); UI: es-ES Calc: threaded Firebird server version: WI-V4.0.0.2496 fIREBIRD 4.0 Error Message: firebird_sdbc error: *unsupported on-disk structure for file C:\PROGRAM FILES\FIREBIRD\FIREBIRD_4_0\EXAMPLES\EMPBUILD\EMPLOYEE.FDB; found 13.0, support 12.0 caused by 'isc_attach_database' -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 141846] Firebird 3 - failure to connect to Firebird file - file structure incompatibility (MacOS)
https://bugs.documentfoundation.org/show_bug.cgi?id=141846 --- Comment #3 from Alex Thurgood --- Bug still present in Collabora Office Version: 21.06.3.1 Build ID: af9fc08c876737f17aed2427c2645ca8b82fdaf9 CPU threads: 8; OS: Mac OS X 11.4; UI render: default; VCL: osx Locale: fr-FR (fr_FR.UTF-8); UI: fr-FR Calc: threaded AND Different error message in LibreOffice Vanilla Version: 7.1.4.2 / LibreOffice Community Build ID: a529a4fab45b75fefc5b6226684193eb000654f6 CPU threads: 8; OS: Mac OS X 11.4; UI render: default; VCL: osx Locale: fr-FR (fr_FR.UTF-8); UI: fr-FR Calc: threaded firebird_sdbc error: *I/O error during "open O_CREAT" operation for file "/Users/alex/Downloads/employee.fdb" *Error while trying to create file *File exists caused by 'isc_create_database' AND LibreOffice Version: 7.1.4.2 / LibreOffice Community Build ID: a529a4fab45b75fefc5b6226684193eb000654f6 CPU threads: 8; OS: Mac OS X 10.16; UI render: default; VCL: osx Locale: fr-FR (fr_FR.UTF-8); UI: en-US Calc: threaded firebird_sdbc error: *unsupported on-disk structure for file /Users/alex/Downloads/employee.fdb; found 12.2, support 12.0 caused by 'isc_attach_database' -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 141846] Firebird 3 - failure to connect to Firebird file - file structure incompatibility (MacOS)
https://bugs.documentfoundation.org/show_bug.cgi?id=141846 --- Comment #2 from Alex Thurgood --- (In reply to Robert Großkopf from comment #1) > Tested it with LO 7.1.3.2 on OpenSUSE 15.2 64bit rpm Linux. > Could connect to the database employee.fdb of Firebird-3.0.7-33374 without > any problems. > First I don't recognize the file is only readable after extraction of the > package, but then it worked. > So I couldnt find any buggy behavior here on Linux. Thanks Robert, I'm guessing that this is a macOS issue. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 141846] Firebird 3 - failure to connect to Firebird file - file structure incompatibility (MacOS)
https://bugs.documentfoundation.org/show_bug.cgi?id=141846 Alex Thurgood changed: What|Removed |Added Summary|Firebird 3 - failure to |Firebird 3 - failure to |connect to Firebird file - |connect to Firebird file - |file structure |file structure |incompatibility |incompatibility (MacOS) -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 141846] Firebird 3 - failure to connect to Firebird file - file structure incompatibility
https://bugs.documentfoundation.org/show_bug.cgi?id=141846 QA Administrators changed: What|Removed |Added Whiteboard| QA:needsComment| -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 141846] Firebird 3 - failure to connect to Firebird file - file structure incompatibility
https://bugs.documentfoundation.org/show_bug.cgi?id=141846 Robert Großkopf changed: What|Removed |Added CC||rob...@familiegrosskopf.de --- Comment #1 from Robert Großkopf --- Tested it with LO 7.1.3.2 on OpenSUSE 15.2 64bit rpm Linux. Could connect to the database employee.fdb of Firebird-3.0.7-33374 without any problems. First I don't recognize the file is only readable after extraction of the package, but then it worked. So I couldnt find any buggy behavior here on Linux. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 141846] Firebird 3 - failure to connect to Firebird file - file structure incompatibility
https://bugs.documentfoundation.org/show_bug.cgi?id=141846 QA Administrators changed: What|Removed |Added Whiteboard|| QA:needsComment -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 141846] Firebird 3 - failure to connect to Firebird file - file structure incompatibility
https://bugs.documentfoundation.org/show_bug.cgi?id=141846 Alex Thurgood changed: What|Removed |Added Keywords||regression Priority|medium |high Severity|normal |major -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
