Created attachment 1607195 [details] Screenshot of error dialog Description of problem: Attempt to create Firebird Embedded database results in error: firebird_sdbc error *Unable to complete network request to host "localhost". *Failed to establish a connection. caused by 'isc_create_database' Version-Release number of selected component (if applicable): libreoffice-6.2.6.2-1.fc30 How reproducible: Every time. Steps to Reproduce: 1. In LibreOffice startup window, select Base Database. 2. Select: Create a new database; Firebird Embedded; Next 3. Select: Open the database for editing; Finish 4. Observe error dialog. Actual results: 1. Error dialog is displayed. 2. Database document is opened for work, but attempts to create a table, query, form, or report all fail with the same isc_create_database error. Expected results: Database created successfully. Additional info: Same error is produced regardless of whether or not database is registered during creation, and regardless of whether it is opened for work when it is created or saved and opened afterward.
Same behavior reported on Manjaro distro: https://forum.manjaro.org/t/libre-office-base-6-2-0-3-cannot-open-or-create-firebird-embedded-databases/77109
Same version of LibreOffice here shows no problem, and this is the only report to date. What is the output of rpm -q libfbclient2 ? In my working case its libfbclient2-3.0.4.33054-2.fc30.x86_64
~]$ rpm -q libfbclient2 libfbclient2-3.0.4.33054-2.fc30.x86_64
Maybe a strace might be helpful in this case. sudo dnf -y install strace strace -f /usr/lib64/libreoffice/program/soffice.bin --base --nologo --norestore > ~/soffice.log 2>&1 attempt to create the firebird embedded db, close all soffice windows and then attach the soffice.log in your home dir here
This doesn't seem the be the problem of https://bugs.documentfoundation.org/show_bug.cgi?id=125284 which is triggered by a Turkish locale which I debugged and found a fix for earlier, but worth including the output of locale as well in case there is some hint in there.
Created attachment 1607678 [details] strace ~]$ locale LANG=en_US.UTF-8 LC_CTYPE="en_US.UTF-8" LC_NUMERIC="en_US.UTF-8" LC_TIME="en_US.UTF-8" LC_COLLATE="en_US.UTF-8" LC_MONETARY="en_US.UTF-8" LC_MESSAGES="en_US.UTF-8" LC_PAPER="en_US.UTF-8" LC_NAME="en_US.UTF-8" LC_ADDRESS="en_US.UTF-8" LC_TELEPHONE="en_US.UTF-8" LC_MEASUREMENT="en_US.UTF-8" LC_IDENTIFICATION="en_US.UTF-8" LC_ALL=
[pid 32641] openat(AT_FDCWD, "/etc/firebird/plugins.conf", O_RDONLY) = -1 ENOENT (No such file or directory) looks like the problem how about sudo dnf -y install firebird seems we have a missing dependency on it
Installing firebird solves the issue. I was able to create a new firebird database and convert an existing HSQLDB database to firebird.
Why is firebird now being installed on my system? It is not my mail client. Seems like a better error message output when ENOENT is returned should tell the user to install firebird. This way people needing this feature understand what is wrong and can fix it. And those of us that do not use the feature keep our systems uncluttered.
OK, so firebird is a database. There does seem to be something strange with the dependencies. If I try to uninstall firebird, it says: Removing dependent packages: libreoffice-emailmerge x86_64 1:6.2.6.2-2.fc30 @updates 26 k libreoffice-help-en x86_64 1:6.2.6.2-2.fc30 @updates 25 M libreoffice-ogltrans x86_64 1:6.2.6.2-2.fc30 @updates 351 k libreoffice-writer2latex x86_64 1.0.2-25.fc30 @fedora 505 k unoconv OK, that seems good as that is a small subset of packages that I wouldn't use. So, if I try to remove those # rpm -e firebird libreoffice-emailmerge libreoffice-help-en libreoffice-ogltrans libreoffice-writer2latex unoconv error: Failed dependencies: firebird is needed by (installed) libreoffice-core So, core needs it? Looking at the spec file shows only base getting it explicitly. So, let's try to remove base # rpm -q libreoffice-base package libreoffice-base is not installed Wonder if dnf/rpm has a problem with dependencies?
Now libreoffice-core require firebird. Please revert to previous spec version. I don't want to install this on my desktop.