Solved LibreOffice Base Connection Problems

Q

Quarter Wave Vertical

I'm running an installation of FreeBSD 10 with Mate as the desktop. I added LibreOffice5 using:

pkg install libreoffice

but I can't run Base. I get an error window with a message which contains the following:

Code: 
The connection to the external data source could not be established.  No SDBC driver was found for the URL 'sdbc:embedded:hsqldb'.

Checking the details, it says that the SQL status is HY000. What did I do wrong? Please advise. Thank you.

By the way, I searched the forums but I didn't find anything which might answer my question.
 
Last edited by a moderator:
I installed it from ports and did the following:

cd /usr/ports/editors/libreoffice
# make install clean

All attempts to run Base gave me the same response as before. I then tried variations on:

  • # make deinstall
  • # make config
  • # make reinstall

I installed databases/hsqldb and dns/dnsdbck from packages, went through the previous procedure and Base still don't run without that error message.

I can get it to run on Linux but not on this FreeBSD installation. What did I overlook or do wrong? Please advise. Thanks.
 
Quarter Wave Vertical said:
I installed it from ports and did the following:

cd /usr/ports/editors/libreoffice
# make install clean

All attempts to run Base gave me the same response as before. I then tried variations on:

  • # make deinstall
  • # make config
  • # make reinstall

I installed databases/hsqldb and dns/dnsdbck from packages, went through the previous procedure and Base still don't run without that error message.

I can get it to run on Linux but not on this FreeBSD installation. What did I overlook or do wrong? Please advise. Thanks.
Click to expand...
Since you didn't mention it in your post, did you enable the JAVA option in the port options dialog when running # make config in the port's directory?
 
protocelt said:
Since you didn't mention it in your post, did you enable the JAVA option in the port options dialog when running # make config in the port's directory?
Click to expand...
Thank you.

I should have mentioned it earlier but, yes, I did set it. Was there anything else that I should have set or disabled in that window before running it? I'm wondering if those settings might have caused a conflict.

Is there a Java library or function that should be installed before installing LibreOffice? The reason I'm asking this is that, in some of the Google links I found on this subject, there's often mention of Java dependencies. Though there weren't specific details about it, I assumed that something had to be installed prior to installing LO.

With all my tinkering with this over the past few days, I seem to have trashed something, so I did a fresh installation of FreeBSD.

I'm sure that I'm close to a solution and that I've missed some small detail somewhere in the process.
 
So I looked at this a bit more closely last night. It seems for LibreOffice Base to work, you need both the JAVA and the PGSQL options in the port turned on when building it. It pulls in quite a bit more dependencies too just so your aware.

I created a blank test database after building editors/libreoffice with the options I just mentioned and it seemed to work fine.
 
protocelt said:
So I looked at this a bit more closely last night. It seems for LibreOffice Base to work, you need both the JAVA and the PGSQL options in the port turned on when building it. It pulls in quite a bit more dependencies too just so your aware.

I created a blank test database after building editors/libreoffice with the options I just mentioned and it seemed to work fine.
Click to expand...
I set the PGSQL option as well. I'll try building editors/libreoffice again and see what happens.
 
There's good news. LibreOffice Base was installed and actually works. I successfully accessed a database that I had created on another machine and encountered no problems.

I think my error in my first attempt was overlooking to run make config. I missed that when I looked at LO's Freshports page as it was about halfway down.

It took more than 15 hours to install it, though. All the libraries and such which were required had to be set up first as I was working with a fresh FreeBSD installation. In addition, it may have taken so much time as I was installing it on an external hard drive.

Thank you for your advice and patience.
 
Glad you got things working, and thanks for marking the thread solved. :)

For future reference, when having problems with a ports or packages, reinstalling the operating system is not needed. Unlike Windows and most Linux distributions, one of the advantages of FreeBSD is a clear separation between the base operating system and ports/packages. You can uninstall/delete all installed packages and start over without having to reinstall the OS when needed saving a lot of time.
 
protocelt said:
Glad you got things working, and thanks for marking the thread solved. :)

For future reference, when having problems with a ports or packages, reinstalling the operating system is not needed. Unlike Windows and most Linux distributions, one of the advantages of FreeBSD is a clear separation between the base operating system and ports/packages. You can uninstall/delete all installed packages and start over without having to reinstall the OS when needed saving a lot of time.
Click to expand...
I tried that but I kept getting messages about missing files, some of which I couldn't figure out where they might have come from.

Rather than spending time looking for them, I thought it was quicker and easier to start again from scratch.
 
You must log in or register to reply here.
Back
Top