Description: Description: 1) Load an ODB file that is configured to connect to a postgres database instance using the native postgres 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 where necessary, an error message is displayed : Unable to establish connection to external datasource. No SDBC driver found for the URL 'sdbc:postgresql:host=127.0.0.1 port=5435 dbname=lotest'. Unable to establish connection to datasource « PGsdbctestlocal ». A connection for the following URL was required « sdbc:postgresql:host=127.0.0.1 port=5435 dbname=lotest ». No tables are listed / display in the bottom pane where the Table list should appear. No further UI work is possible with the database file. Steps to Reproduce: See above Actual Results: It is impossible to do any UI work with the ODB file as the db connection is not established. Expected Results: The connection should be made, and at least the Table list visible in the bottom Base pane Reproducible: Always User Profile Reset: Yes Additional Info: Tested with 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
Not reproducible in TDF LO release : 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
This is really interesting post, You are a very skilled blogger.I have joined your feed and look forward to seeking more of your fantastic post.The problem is something which not enough folks are speaking intelligently about. Now i’m very happy that I came across this in my search for something concerning this.Also, I have shared your site in my social networks! apple id verification failed | apple id verification problem | hbomax tv sign in code | apple id verification failed unknown error https://www.mygeekshelp.com/apple-id-verification-failed/
Have reset this to new as neither LOVanilla nor Collabora Productivity available through the AppStore now contain a postgres sdbc driver with versions : LO Vanilla Version: 7.2.0.4 / LibreOffice Community Build ID: 9a9c6381e3f7a62afc1329bd359cc48accb6435b CPU threads: 8; OS: Mac OS X 11.6; UI render: default; VCL: osx Locale: fr-FR (fr_FR.UTF-8); UI: fr-FR Calc: threaded Collabora Productivity Version: 21.06.4.1 Build ID: 5ad6bfb54ffec15fe311ed990aa1518979b8f086 CPU threads: 8; OS: Mac OS X 11.6; UI render: default; VCL: osx Locale: fr-FR (fr_FR.UTF-8); UI: fr-FR Calc: threaded
Additionally, the "Create New Database" wizard does not even list the possibility of connecting to an existing postgres database server, cf. screenshot.
Created attachment 175860 [details] Collabora Productivity - screenshot of list of possible database sources to which to connect via wizard.
That's unfortunate. On recent-ish versions of MacOS X, we don't even need to ship the PostgreSQL C client library, it is provided by the OS :-|
Created attachment 175861 [details] Screenshot of available existing datasource connection possibilities via wizard There are even fewer choices of possible datasource connections in LOVanilla from the AppStore.
Created attachment 175862 [details] LibreOffice Vanilla - screenshot of available datasource connection possibilities via wizard
How can this be bibisected against Collabora's codebase/release ? With TDF Version: 7.2.1.2 / LibreOffice Community Build ID: 87b77fad49947c1441b67c559c339af8f3517e22 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 it still works just fine, the postgres SDBC connector is still there. So, the problem appears to lie specifically with the way Collabora builds their own release and the LO Vanilla release.
With Collabora Office Version: 21.06.15.1 Build ID: 60a66e4bf6afbf5d4221dab436bb1aca744a7ddf CPU threads: 8; OS: Mac OS X 12.2; UI render: default; VCL: osx Locale: fr-FR (fr_FR.UTF-8); UI: fr-FR Calc: threaded In the list of fixes (cf. screenshot) displayed on the AppStore, it says postgres upgraded to 13.5, yet, there is still no way to either create a new connection to a running postgres instance (Step 1 of Create Database Wizard), or successully load and read data from an existing postgres configured ODB.
Created attachment 178184 [details] Collabora AppStore list of announced bug fixes
This works with LibreOffice from the Apple app store: 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