Bug 141830 - LibreOffice Vanilla / Collabora Productivity fails to open mysql connected ODB file using the native mysql connector
Summary: LibreOffice Vanilla / Collabora Productivity fails to open mysql connected OD...
Status: RESOLVED DUPLICATE of bug 138949
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
7.1.2.2 release
Hardware: ARM macOS (All)
: highest critical
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: regression
Depends on:
Blocks:
 
Reported: 2021-04-22 10:48 UTC by Alex Thurgood
Modified: 2021-05-01 23:10 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Alex Thurgood 2021-04-22 10:48:09 UTC
Description:
1) Load an ODB file that is configured to connect to a mysql database instance using the native mysql C connector.

2) Click on any of the icons on the left hand side of the main Base application window, e.g. Tables

3) After entering the pwd/id combination, an error message is displayed :

Unable to establish connection to the datasource "MyDataSource" (translated from French into English).

Status SQL: HY000
Unable to establish connection to external datasource. No SDBC driver can be found for the URL 'sdbc:mysql:mysqlc:127.0.0.1:3306/mydatasource'.

A connection for the following URL was required « sdbc:mysql:mysqlc:127.0.0.1:3306/mydatasource ».

The table fails to open/display any data.
No further UI work is possible.



Steps to Reproduce:
See above

Actual Results:
See above

Expected Results:
The table view mode should be activated and the table data displayed in the grid view.


Reproducible: Always


User Profile Reset: No



Additional Info:
Version: 7.1.2.3 / LibreOffice Community
Build ID: a393d9064b7eb849da7f488ab43f56a404be32ae
CPU threads: 8; OS: Mac OS X 11.2.3; UI render: default; VCL: osx
Locale: fr-FR (fr_FR.UTF-8); UI: fr-FR
Calc: threaded
Comment 1 Alex Thurgood 2021-04-22 10:50:57 UTC
Same issue with

Collabora Productivity
Version : 6.4-20
Build ID : 8f9231b97d06858b598c6fa819546ca3391d11c7
Threads CPU : 8; OS : Mac OS X 11.2.3; UI Render : par défaut; VCL: osx; 
Locale : fr-FR (fr_FR.UTF-8); Langue IHM : fr-FR
Calc: threaded
Comment 2 Alex Thurgood 2021-04-22 10:52:47 UTC
Works fine with :

TDF
Version: 7.1.2.2 / LibreOffice Community
Build ID: 8a45595d069ef5570103caea1b71cc9d82b2aae4
CPU threads: 8; OS: Mac OS X 10.16; UI render: default; VCL: osx
Locale: fr-FR (fr_FR.UTF-8); UI: fr-FR
Calc: threaded
Comment 3 Aron Budea 2021-04-29 03:17:32 UTC
Isn't this the same as bug 138949?
Comment 4 Xisco Faulí 2021-04-29 14:13:45 UTC
(In reply to Aron Budea from comment #3)
> Isn't this the same as bug 138949?

Setting to NEEDINFO until Alex responses
Comment 5 Alex Thurgood 2021-05-01 15:38:15 UTC
Ah crap, had forgotten about that other report, despite searching BZ beforehand. 

If this can't be resolved, it means that LO Vanilla on Mac M1 has currently virtually no database support at all (except maybe DBF?). 

Not even Firebird works.

No postgres native support
No MySQL native support 
No Java DB Support, obviously, irrespective of DB engine.
No ODBC support. 

Is this really the route that these products are going down?
Comment 6 Alex Thurgood 2021-05-01 15:46:31 UTC

*** This bug has been marked as a duplicate of bug 138949 ***