Ask Your Question
0

Created a database in MySQL, unable to connect via SBDC to LO Base

asked 2018-08-17 03:30:19 +0100

Liberty Belle gravatar image

updated 2018-08-17 03:38:06 +0100

  • Mac desktop (64 bit)
  • OS High Sierra 10.13.6
  • LO 6.0.6.2
  • Java Runtime Environment 10.0.2 installed and currently in use (LO Preferences > Advanced)

This is my first time creating a MySQL database and connecting it to LO. I successfully created the database via the mysql command line: "Query OK, 1 row affected". I can also see this database in MySQL Workbench.

I downloaded and installed the native SBDC driver from https://www.arielch.org/aoo/aoo-my-sdbc/ (Mac OSX Version Apache OpenOffice4.1). I restarted LO. When I open a Writer doc and go to Tools > Extensions, I see this SBDC driver listed there.

I then perform the following steps to connect my new database:

  1. New Database
  2. Connect to existing > MySQL
  3. Connect directly
  4. Database name: myfirstsqldb
  5. Server: localhost
  6. Port: 3306 (verified this is correct in MySQL Workbench; there is an active connection on this port)
  7. User name: root
  8. Tick the “password required” box
  9. Input my root password I set up originally with MySQL.
  10. Click the Test Connection box.

I get the following error message, “A driver is not registered for the URL sdbc:mysql:mysqlc:localhost:3306:myfirstsqldb"

What did I do wrong?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
1

answered 2018-08-17 04:20:40 +0100

Ratslinger gravatar image

updated 2018-08-17 04:57:03 +0100

Hello,

From what you have listed these are the same settings as on my current system (Linux Mint 18.3). Have been using v1.2 for a few years now and other SDBC versions have never worked for me. You may want to try the other version posted there for Mac (the one for AOO 4.0) or even the older v1.1.0 as it can't really hurt & changing extensions is quick ( delete old & add in new).

If still not working, I have also connected using JDBC and ODBC connector from MySQL. Takes more to set up and they are somewhat slower than SDBC but work.

JDBC -> Connector/J 5.1.46

Install instructions -> Setting up LibreOffice to access MySQL database with JDBC driver

and

How to connect LibreOffice Base to MySQL using JDBC on Mac OS X

ODBC -> Connector/ODBC 8.0.12

Will assist wherever possible but have little background in Mac - know about Java situation & that LO menus are a bit different to access :)

edit flag offensive delete link more

Comments

Ratslinger, thanks for your response.

Regarding the AOO SBDC driver— I tried both of the older OS X versions (4.0 and 1.1.0), but was not able to open them after downloading. Each one gave me the error message, "The extension 'MySQL SDBC Driver for Apache OpenOffice' does not work on this computer.”.

Liberty Belle gravatar imageLiberty Belle ( 2018-08-17 17:01:13 +0100 )edit

I can look into the OBDC and JDBC drivers, but I really wanted to use the SBDC driver, as I understand that it works better / faster / smoother in connecting MySQL databases to Base. Is there really no other option for me?

Liberty Belle gravatar imageLiberty Belle ( 2018-08-17 17:01:27 +0100 )edit

Sorry but none I know of. The SDBC driver has not been updated in years. If what you have tried doesn't work, I don't see much difference by using a JDBC or ODBC connector. At least these are being updated. I did use JDBC for some time when I first installed MySQL and had no problems. Currently I am migrating to PostgreSQL (Firebird 3 Server was second choice) each performing better with more capabilities than MySQL.

Ratslinger gravatar imageRatslinger ( 2018-08-17 18:08:06 +0100 )edit

Thanks again. So maybe it's worthwhile for me to switch to PostgreSQL instead of MySQL?

Liberty Belle gravatar imageLiberty Belle ( 2018-08-17 18:37:22 +0100 )edit

That's tough to say. What you haven't mentioned is what you are using Base for. With the inclusion of Firebird 3 embedded getting closer why isn't this a consideration? I just finished a side by side test using my main DB from MySQL (almost daily use) and ran same in PostgreSQL, Firebird 3 server & Firebird 3 embedded and saw no problem in any with data or relative performance. I am moving to PostgreSQL for other reasons.

Ratslinger gravatar imageRatslinger ( 2018-08-17 18:48:20 +0100 )edit

I am using Base for a number of things: uploading financial and online sales channel spreadsheets so that I can more easily obtain the info I need (spreadsheets weren't working well); business and personal bookkeeping; inventory management and purchase orders; personal recipe database; personal books and media database, etc. I have future plans to integrate a database with a website, so I would need to be able to use something like phpmyadmin.

Liberty Belle gravatar imageLiberty Belle ( 2018-08-18 22:03:33 +0100 )edit

As far as using the Firebird 3 embedded database, right now I am using the latest stable version of LO, which I don't think has this as an option. I've been wary of using something that's still in experimental mode. I'm trying to make this all as easy as possible on myself. But I'm open to the possibility of using it, if you think that might be a better option.

Liberty Belle gravatar imageLiberty Belle ( 2018-08-18 22:09:32 +0100 )edit

OK. Ultimately it's your decision. I'm gravitating toward PostgreSQL because of spatial capabilities. Not a concern for you. Have tested a lot with many different DB's and will keep most around for testing.

One impressive thing about using Firebird 3 server (been around for decades now) is that you can also take a DB, create what is a backup (.fbk file) and put it into a LO Firebird embedded .odb and it becomes portable. LO can also connect to a Firebird file (read DB).

Ratslinger gravatar imageRatslinger ( 2018-08-18 22:24:09 +0100 )edit

BTW You can turn on Firebird embedded thru menu Tools->options->LibreOffice->Advanced & click checkbox to turn on experimental features.

Now PostgreSQL has been around longer & is a bit more sophisticated than Firebird which is better than MySQL (or it's sister MariaDB) at least from the use & research I've done (MY opinion). And as far as use on Websites, this is not an area I am comfortable in discussing.

Bottom line is that it's a choice you will need to make.

Ratslinger gravatar imageRatslinger ( 2018-08-18 22:31:43 +0100 )edit

@Liberty Belle Just a note about php & databases. From php manual -

Yes, PHP can access virtually any database available today.

Also about Firebird - Interfacing PHP and Firebird

Also - phpMyAdmin is a free and open source administration tool for MySQL and MariaDB

Ratslinger gravatar imageRatslinger ( 2018-08-20 01:57:06 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-08-17 03:30:19 +0100

Seen: 170 times

Last updated: Aug 17 '18