Ask Your Question
0

LO Base 6.2x plus issues with MYSQL JDBC connector

asked 2019-09-15 15:57:20 +0200

Joewylie gravatar image

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 an Ubuntu 16.04 server. I am running the Oracle 5.45 connector

edit retag flag offensive close merge delete

Comments

Cross posted here -> LO Base 6.2x plus issues with MYSQL JDBC connector

@Joewylie,

Please make note in all locations when doing this. It may help save duplicate effort.

Ratslinger gravatar imageRatslinger ( 2019-09-15 17:43:01 +0200 )edit

Ratslinger, you mean note if I put the same question in another forum?? Sorry posting and community support newbie here

Joewylie gravatar imageJoewylie ( 2019-09-15 19:06:54 +0200 )edit

1 Answer

Sort by » oldest newest most voted
0

answered 2019-09-15 22:47:35 +0200

Ratslinger gravatar image

Hello,

Have Ubuntu 18.04 and installed MySQL locally - v5.7.27

Used Oracle connector v5.1.45

Had LO v6.3.1.2 installed

JDBC connection had no problem.

Removed LO & installed v6.2.4.2 (you don't mention specific version)

Had no problem with same connection.

Using:

mysql://127.0.0.1:3306/MY_DB_NAME?useLegacyDatetimeCode=false&serverTimezone=A

Have used JDBC connector in other OS's such as Mint 18.3 without problem and with a variety of LO versions.

edit flag offensive delete link more

Comments

Note: LO versions used were from TDF (The Document Foundation) and not PPA or Distro versions.

Edit: Have also installed & tested with Mint 19.2 & LO v6.3.1.2 - all OK. Also on Ubuntu 18.04 tried with MySQL(JDBC) connection with LO v6.3.1.2 - all OK.

If you still have problems, maybe try resetting your user profile - LibreOffice user profile

Ratslinger gravatar imageRatslinger ( 2019-09-15 22:56:43 +0200 )edit

Thanks Ratslinger! I will follow your tests this week and see what my issue seems to be.

Joewylie gravatar imageJoewylie ( 2019-09-16 04:20:50 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2019-09-15 15:57:20 +0200

Seen: 34 times

Last updated: Sep 15