Bug 24672

Summary:	Libreoffice can't connect a Mysql database
Product:	Mageia	Reporter:	papoteur <yvesbrungard>
Component:	RPM Packages	Assignee:	Thierry Vignaud <thierry.vignaud>
Status:	RESOLVED OLD	QA Contact:
Severity:	normal
Priority:	Normal	CC:	lewyssmith, ouaurelien
Version:	6
Target Milestone:	---
Hardware:	All
OS:	Linux
Whiteboard:
Source RPM:		CVE:
Status comment:

Description papoteur 2019-04-15 19:11:04 CEST

I have a working database in mysql.
I tried to access the database from Libreoffice following the steps of this tuto:
https://www.techrepublic.com/article/how-to-connect-libreoffice-base-to-a-remote-mysql-database/
In particular, I have:
- installed mysql-connector-java
- added the JDBC Connector to LibreOffice
- started to create a new database
- selected to create a connector Mysql using JDBC
- tested the Mysql JDBC connector class (OK)
- provided my information about mysql database: server 127.0.0.1, default port, database name
- tested the connection to the database, providing user name and password.
At this step, the application becomes unresponsive.


Version-Release number of selected component (if applicable):
Libreoffice 5.3.7
mysql-connector-java-5.1.42-1.mga6.noarch
java
mariadb-10.1.38-1.mga6.x86_64
java-1.8.0-openjdk-1.8.0.201-1.b09.2.mga6.x86_64

How reproducible:
always

Comment 1 Lewis Smith 2019-04-15 20:34:20 CEST

Assigning to tv as the registered LibreOffice maintainer, for starters.

Assignee: bugsquad => thierry.vignaud
CC: (none) => lewyssmith

Comment 2 papoteur 2019-07-25 16:30:20 CEST

mysql can now be connected from Libreoffice without JDBC connector, by a direct connection, starting from Libreoffice 6.2.

Comment 3 Lewis Smith 2019-07-29 20:34:13 CEST

My up-to-date Mageia 6 system has libreoffice-*-6.1.5.2-1.2.mga6
@Thierry: are we likely to see Libreoffice 6.2 in Mageia 6?
If not, this bug should be pursued; I am surprised that Papoteur is the first to hit it for M6.

Comment 4 Aurelien Oudelet 2020-08-23 15:23:51 CEST

Hi, thanks for reporting this bug.
We are sorry, but we no longer maintains this version of Mageia. Please upgrade to the latest version and reopen this bug against that version if this bug exists there.
As a result we are setting this bug to CLOSED:OLD

Status: NEW => RESOLVED
CC: (none) => ouaurelien
Resolution: (none) => OLD