[Libreoffice-bugs] [Bug 142234] New: [UI] Wrong example for PostgreSQL datasource URL from database wizard

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=142234

            Bug ID: 142234
           Summary: [UI] Wrong example for PostgreSQL datasource URL from
                    database wizard
           Product: LibreOffice
           Version: 7.1.3.2 release
          Hardware: All
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: minor
          Priority: medium
         Component: Base
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: plateauwolf at qq.com

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.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210512/58915d2f/attachment-0001.htm>