LO Base 6.2x plus issues with MYSQL JDBC connector

dBase, Calc, CSV, MS ACCESS, MySQL, PostgrSQL, OTHER

LO Base 6.2x plus issues with MYSQL JDBC connector

Postby DaddySmack66 » Sat Sep 14, 2019 3:13 pm

When I upgraded to LibreOffice Office 6.2x my database cannot connect to MySql. Anyone else having this issue? I had to uninstall LO 6.2x and install LO 6.1x to get the JDBC connector working. This happens on Ubuntu 18.04 and 19.04. I am running MYSQL 5.7 on a server. I am running the Oracle 5.45 connector
LibreOffice 6, Ubuntu 18.04 19.04 MySQL
User avatar
DaddySmack66
 
Posts: 4
Joined: Sun Jun 17, 2018 4:51 pm

Re: LO Base 6.2x plus issues with MYSQL JDBC connector

Postby Villeroy » Sat Sep 14, 2019 5:07 pm

Possibly some weird privilege settings:
viewtopic.php?f=13&t=98371&p=473879#p473879 where I had to log-in as Linux root in order to be able to add a valid database account.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 27570
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: LO Base 6.2x plus issues with MYSQL JDBC connector

Postby DaddySmack66 » Sun Sep 15, 2019 3:28 am

Villeroy, Thank you for your response. I spent many hours trying to track down the issue. I am not a programmer, but a "jack of all trades" IT guy who still prefers a GUI but is learning to appreciate the command line. I love data and databases. Thank you OO and LO for Base and the Frugal Computer Guy for his you tube videos and you too Villeroy for all your contributions to this forum. I just wanted to see if others where having issues with LO Base 6.2x and MySQL connections. I am going to stay with the rolled back LO Base 6.1x for now and spend time trying to get my forms programmed and such. Maybe someone will try to spin a virtual Ubuntu 19.04 and MySQL local instance 5.7 and get a connection working and post here. I have tried that and could not get it to work. I discovered the issue when I upgraded and it broke my BASE from end database (forms and queries) and had to roll back. I will just wait a little and see if anyone else reports an issue.
LibreOffice 6, Ubuntu 18.04 19.04 MySQL
User avatar
DaddySmack66
 
Posts: 4
Joined: Sun Jun 17, 2018 4:51 pm

Re: LO Base 6.2x plus issues with MYSQL JDBC connector

Postby Villeroy » Sun Sep 15, 2019 11:43 am

I will just wait a little and see if anyone else reports an issue.
You are the one to do this. It may be cumbersome because someone at Document Foundation has to reproduce your problem which requires a MySQL setup similar to yours. Meanwhile you could simply use the built-in driver or ODBC.
I do not use MySQL and in the other topic I've llinked I tried to setup a local database from scratch in order to reproduce another issue. I stumbled upon a crude problem between my operating system and MySQL. Once this was solved, the database was connected to a Base document which worked with LO 6.0 and LO 6.2.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 27570
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: LO Base 6.2x plus issues with MYSQL JDBC connector

Postby DaddySmack66 » Sun Sep 15, 2019 3:53 pm

Got you, I will do that... report the issue/bug to LO. I use Ubuntu 18.04 on my main machines and have rolled out 19.04 for testing. I assume ODBC is Windows only?

What database backend do you use?
LibreOffice 6, Ubuntu 18.04 19.04 MySQL
User avatar
DaddySmack66
 
Posts: 4
Joined: Sun Jun 17, 2018 4:51 pm

Re: LO Base 6.2x plus issues with MYSQL JDBC connector

Postby robleyd » Mon Sep 16, 2019 1:18 am

Wikipedia wrote:In computing, Open Database Connectivity is a standard application programming interface for accessing database management systems. The designers of ODBC aimed to make it independent of database systems and operating systems. An application written using ODBC can be ported to other platforms, both on the client and server side, with few changes to the data access code.


Same question posted at AskLibreOffice
Cheers
David
Apache OpenOffice 420m2(Build:9821) - Slackware 14.2 - 64 bit
LibreOffice 6.0.7.3 - Slackware 14.2 - 64 bit
Apache OpenOffice 4.1.4 - Windows 7 Virtual machine
User avatar
robleyd
Moderator
 
Posts: 3094
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: LO Base 6.2x plus issues with MYSQL JDBC connector

Postby DaddySmack66 » Mon Sep 16, 2019 4:16 am

Thanks David. I will test in my VM using ODBC and MySQL.
LibreOffice 6, Ubuntu 18.04 19.04 MySQL
User avatar
DaddySmack66
 
Posts: 4
Joined: Sun Jun 17, 2018 4:51 pm


Return to External Data Sources

Who is online

Users browsing this forum: No registered users and 1 guest