Feature Unit/System Tests PR-5.1-dev Pending

User tests: Successful: Unsuccessful:

avatar alikon
alikon
15 Aug 2024

Draft partial Pull Request for Feature request #43902 .

Summary of Changes

add db host port filed

Testing Instructions

ìnstall and play with different setup db hostname and db port

Actual result BEFORE applying this Pull Request

postgres pdo doesn't work if port different from default (5432)

Expected result AFTER applying this Pull Request

you can set a db port

Link to documentations

Please select:

  • Documentation link for docs.joomla.org:

  • No documentation changes for docs.joomla.org needed

  • Pull Request link for manual.joomla.org:

  • No documentation changes for manual.joomla.org needed

avatar joomla-cms-bot joomla-cms-bot - change - 15 Aug 2024
Category Administration com_config Installation Libraries
avatar alikon alikon - open - 15 Aug 2024
avatar alikon alikon - change - 15 Aug 2024
Status New Pending
avatar muhme
muhme - comment - 16 Aug 2024

Thank you @alikon for this draft PR, I added a language overwrite and did a picture:

shoot

There are arguments for (e.g. using 2001:db8::1 and 1066) and against an additional field for the port number (e.g. using [2001:db8::1]:1066). I vote for a new field because two reasons:

  1. The documentation. We have to give help on screen and to describe it in detail and this is easier with separate field and not using additional square brackets for IPv6 addresses
  2. Security checks with two separate fields for host and port number are easier to implement and maintain as with single field

Why do we need backwards compatibility here? And there is no hurry, from my point of view we can have it 5.2.

Another point: I would make the field optional and blank by default if the default database port is used. This again for simplicity: If we display the default port number, then we have to change it when the database is changed.

avatar alikon alikon - change - 16 Aug 2024
Labels Added: PR-5.1-dev
de4b81c 16 Aug 2024 avatar alikon cs
avatar degobbis
degobbis - comment - 24 Aug 2024

I like the idea behind this PR, but I don't think it makes sense to make the field required.
If the field is empty, the default port should be used automatically.
In addition, it would certainly make sense to check the previous entry in “Host” to see whether a port was already specified there and, if necessary, to move it to the new field and to change the configuration.php.

avatar joomla-cms-bot joomla-cms-bot - change - 25 Aug 2024
Category Administration com_config Installation Libraries Unit Tests Administration com_config Installation Libraries JavaScript
avatar alikon alikon - change - 25 Aug 2024
Labels Added: Unit/System Tests
avatar alikon alikon - change - 31 Aug 2024
Labels Added: Feature
avatar alikon
alikon - comment - 1 Sep 2024

with joomla-framework/database#310 no more needed

in cypress.config.mjs db_host: 'localhost:5433'

avatar alikon alikon - close - 1 Sep 2024
avatar alikon alikon - change - 1 Sep 2024
Status Pending Closed
Closed_Date 0000-00-00 00:00:00 2024-09-01 08:00:16
Closed_By alikon

Add a Comment

Login with GitHub to post a comment