Hi,
The problem I have is that LO crashes whenever I try to create/open a firebird embedded database in a Libreoffice installation under CentOS 7.
I am running Libreoffice 6.4.2.2 under Windows 10 system and also 6.4.4.2 on a Linux CentOS 7 system. There is also a network storage device (WD standalone thing) which is effectively a minimal install Debian machine (32bit) using samba to windows and fusermount to linux, which works well enough for my purposes with all files accessible from both ends.
What I want to do is transcribe my various Libreoffice Calc ‘databases’, that are at the moment little more than individual spreadsheets with some validation, pull down filtering and pivot tables into proper databases with queries and reports. They will be stored on the NAS and accessible from the Linux (Home office) end and also from the Windows (Domestic) end of the home network, and using firebird am hopeful they might also be accessible from the Android and Appleworld devices that will be more dominant in the future.
1 - The Problem: Opening or creating any firebird embedded database on the Linux machine simply results in a crash.
I can create a test firebird database on the windows machine, saved to the network drive which appears to work. When I open on the Linux machine it opens, but if I click on tables or relationships it crashes Libreoffice to the send error report screen.
If I try to create a firebird embedded database on the Linux machine it also crashes the moment I click on the add a table wizard.
I can create an HSQML embedded database on the Linux installation (but not the Windows 10 one as I haven’t installed JRE yet.) So at the moment I can’t achieve a single .odb file that works from both the Windows system and Linux one. (but installing JRE on the Windows machine will probably solve, that. although I note the LO recommendation to only use HSQML for backwards compatability,)
crashreport.libreoffice.org/stats/crash_details/7ad1df84-fd04-41d4-9922-846820657742
1.1 - Am I missing something in the LibreOffice under Linux installation ?
After looking through the forum I have enabled ‘experimental features’ under Options-LibreOffice-Advanced.
Under Libreoffice base Connections I have the com.sun.star/comp.sdbc.firebirdDriver and ODBCDriver Pools enabled .
Is there another or different Driver needed ?
1.2 - Is there some network server I need to fire up, eg does the Windows LO instance need to be running as part of the registration or should I have not registered the database in one machine, because that might lock it out of the other.
- Is the way I am going about it the best way - i.e. a single .odb file in an network location accessible or should I aim for two copies on mirrored drives or run a database server on the Debian Network server ?
thankyou