Bug 24672 - Libreoffice can't connect a Mysql database
Summary: Libreoffice can't connect a Mysql database
Status: RESOLVED OLD
Alias: None
Product: Mageia
Classification: Unclassified
Component: RPM Packages (show other bugs)
Version: 6
Hardware: All Linux
Priority: Normal normal
Target Milestone: ---
Assignee: Thierry Vignaud
QA Contact:
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2019-04-15 19:11 CEST by papoteur
Modified: 2020-08-23 15:23 CEST (History)
2 users (show)

See Also:
Source RPM:
CVE:
Status comment:


Attachments

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


Note You need to log in before you can comment on or make changes to this bug.