Bug 151074

Summary:	LibreOffice from macOS appstore - can not create connection to mysql database via database creation wizard
Product:	LibreOffice	Reporter:	Alex Thurgood <iplaw67>
Component:	Base	Assignee:	Not Assigned <libreoffice-bugs>
Status:	NEW ---
Severity:	normal	CC:	cloph, heiko.tietze
Priority:	medium	Keywords:	notBibisectable, regression
Version:	7.3.6.2 release
Hardware:	ARM
OS:	macOS (All)
Whiteboard:
Crash report or crash signature:		Regression By:
Bug Depends on:
Bug Blocks:	42082
Attachments:	Screenshot of connect to existing database dialog Screenshot of dropdown menu choices in Connect to existing database of Database Wizard

Description Alex Thurgood 2022-09-20 08:43:04 UTC

Description:
1) Paid, downloaded, and installed LibreOffice from macOS appstore

2) Start up LibreOffice and File > New > Database

3) Database creation wizard on first screen shows no mysql listing as a connection possibility in "Connect to an existing database".

4) Impossible to connect to an existing mysql database.

Steps to Reproduce:
See above

Actual Results:
Impossible to set up connection to a mysql database

Expected Results:
Connection to an existing mysql database should be possible


Reproducible: Always


User Profile Reset: Yes



Additional Info:
Version: 7.3.6.2 / LibreOffice Community
Build ID: c28ca90fd6e1a19e189fc16c05f8f8924961e12e
CPU threads: 8; OS: Mac OS X 12.6; UI render: default; VCL: osx
Locale: fr-FR (fr_FR.UTF-8); UI: fr-FR
Calc: threaded

Comment 1 Alex Thurgood 2022-09-20 08:51:01 UTC

The irony is that you can load an existing ODB file configured to connect to an existing mysql instance using the native connector, and it will work.

For some reason, the mysql entry is missing from the connect to database dialog list.

Comment 2 Alex Thurgood 2022-09-26 15:24:19 UTC

@cloph, @heiko : any idea why the MySQL connection entry might be missing from the Apple AppStore release ?

Comment 3 Alex Thurgood 2022-12-30 10:08:09 UTC

Bug still present in AppStore version

Version: 7.4.3.2 / LibreOffice Community
Build ID: 1048a8393ae2eeec98dff31b5c133c5f1d08b890
CPU threads: 8; OS: Mac OS X 13.0.1; UI render: default; VCL: osx
Locale: fr-FR (fr_FR.UTF-8); UI: fr-FR
Calc: threaded

Comment 4 Alex Thurgood 2023-03-15 10:25:21 UTC

Bug still present in:

Version: 7.4.6.2 / LibreOffice Community
Build ID: 5b1f5509c2decdade7fda905e3e1429a67acd63d
CPU threads: 8; OS: Mac OS X 13.2.1; UI render: default; VCL: osx
Locale: fr-FR (fr_FR.UTF-8); UI: fr-FR
Calc: threaded

Attaching screenshot of database wizard "Connect to existing database" dialog.

Comment 5 Alex Thurgood 2023-03-15 10:26:36 UTC

Created attachment 185971 [details]
Screenshot of connect to existing database dialog

Comment 6 Alex Thurgood 2023-03-15 10:29:36 UTC

Comment on attachment 185971 [details]
Screenshot of connect to existing database dialog

Typically, the dropdown dialog folded back up before I took the screenshot, so setting this as obsolete

Comment 7 Alex Thurgood 2023-03-15 10:30:41 UTC

Created attachment 185972 [details]
Screenshot of dropdown menu choices in Connect to existing database of Database Wizard