Bug 134046 - FIREBIRD fails to create database
Summary: FIREBIRD fails to create database
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
6.4.4.2 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2020-06-16 17:49 UTC by Robert Großkopf
Modified: 2020-08-11 14:10 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Robert Großkopf 2020-06-16 17:49:49 UTC
Have had this error with different databases.
I will start the database and get

firebird_sdbc error:
*Use of database at location /tmp/lu3502i6bvpe.tmp/lu3502i6bvpo.tmp/firebird.fdb is not allowed by server configuration
*failed to create database /tmp/lu3502i6bvpe.tmp/lu3502i6bvpo.tmp/firebird.fdb
*unknown ISC error 336330835
caused by
'isc_service_query'

There is no possibility to contact to the database, but the path is allowed for writing for me.

Then I close LO, rename the database and start LO again. Now I get connection to the database.

I close this, rename it to the old name and could connect also.

I don't know how to reproduce this behavior. I have had a look to the folder, which isn't protected. I have had a look to my Firebird-server, which I hadn't started and which isn't running.

All this happens under LO 6.4.4.2 on OpenSUSE 15.1 64bit rpm Linux.
Comment 1 Alex Thurgood 2020-07-01 07:03:36 UTC
@Robert : 

Which version of Firebird server were you running that was used to create the fdb file in the first place ? Just so that I can see whether I can attempt to reproduce this.


I take it that you don't get this problem when trying to access a standalone FDB file ?

I'm not sure I'll be able to try and reproduce this, given how restrictive reading/writing outside of the allowed disk areas is on macOS, but I'll try and take a look.
Comment 2 Robert Großkopf 2020-07-01 07:11:09 UTC
(In reply to Alex Thurgood from comment #1)
> @Robert : 
> 
> Which version of Firebird server were you running that was used to create
> the fdb file in the first place ? Just so that I can see whether I can
> attempt to reproduce this.

I have created the Firebird-database by using the migration wizard. It appears with different internal Firebird databases here - also databases other people send to me. 
> 
> I take it that you don't get this problem when trying to access a standalone
> FDB file ?

No, it's the internal Firebird-database, which I can't connect to at this moment.

... and the Firebird-server isn't running. Renaming the database after closing LO will solve the problem. Then renaming to the original name will also work.
Comment 3 Alex Thurgood 2020-07-01 11:29:39 UTC
@Robert : thanks for the update.

Unfortunately, I am getting a different error when trying to access the default employee database provided with current Firebird release on macOS:

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'


will file a separate report.
Comment 4 Xisco Faulí 2020-08-11 10:51:12 UTC
Hello Robert,
Is this issue still reproducible with LibreOffice 7.0.0.3 ?
Comment 5 Robert Großkopf 2020-08-11 14:10:35 UTC
(In reply to Xisco Faulí from comment #4)
> Hello Robert,
> Is this issue still reproducible with LibreOffice 7.0.0.3 ?

I haven't had the same behavior again - with LO 6.4.4.2 on the same machine. Also couldn't reproduce with LO 7.0.0.3. Will close this bug as Worksforme and reopen it, if I could reproduce the behavior.