Bug 142234 - [UI] Wrong example for PostgreSQL datasource URL from database wizard
Summary: [UI] Wrong example for PostgreSQL datasource URL from database wizard
Status: RESOLVED DUPLICATE of bug 132476
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
7.1.3.2 release
Hardware: All Windows (All)
: medium minor
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2021-05-12 11:58 UTC by Liaison to zh-CN User Community
Modified: 2021-05-12 18:21 UTC (History)
0 users

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 Liaison to zh-CN User Community 2021-05-12 11:58:32 UTC
This is a bug report forwarded and translated from a Chinese LibreOffice user chat group.

The original reporter complains that the example given by Base's database wizard for connecting to a PostgreSQL database is wrong.  The port number can not be specified like in the example.

Steps to reproduce:
1. Open Base, the Database Wizard dialog appears;
2. In "Select database" step, Select "Connect to an existing database", choose PostgreSQL from the dropdown list, click Next;
3. Now in "Connection settings" step, the text above the input box says "Datasource URL: (e.g. host=$host:$port dbname=$database)";
4. Type URL according to the example, "host=localhost:5432 dbname=test".

Expected Result:
Type URL like the example, "host=localhost:5432 dbname=test", and connect to the PostgreSQL database.

Actual Result:
Type URL like the example, "host=localhost:5432 dbname=test", but can not connect to the PostgreSQL database.  Use "host=localhost port=5432 dbname=test" instead, and correctly connect to the database.

Additional information:
The original reporter was using LO 7.1.3 on Windows 10, connecting to PostgreSQL 12.6:
Version: 7.1.3.2 (x64) / LibreOffice Community
Build ID: 47f78053abe362b9384784d31a6e56f8511eb1c1
CPU threads: 4; OS: Windows 10.0 Build 17763; UI render: Skia/Raster; VCL: win
Locale: zh-CN (zh_CN); UI: zh-CN
Calc: threaded

I myself don't have any experience about PostgreSQL or any SQL database, and therefore can not try to reproduce.
Comment 1 Julien Nabet 2021-05-12 18:21:35 UTC

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