Summary of Changes

Currently, Unix sockets do not work in Cypress System Tests. This enhancement is aimed at enabling their functionality.

See backend | Global Configuration | Server Database:

Check if db_host is a Unix socket by verifying the unix:/ prefix. All JavaScript drivers does not handle this prefix, it needs to be stripped. This approach maintains compatibility with the PHP drivers and allows to have Cypress.config.mjs working for installation step (PHP driver) and custom database commands (JavaScript driver).

This change has already been tested with the NPM module pg replacment from #44084.

Testing Instructions

One option for testing is using JBT >= 1.0.24, as described here. Doing installation with MariaDB and MySQLi driver, test one spec with database custom commands. Installation step is already executed == tested with scripts/created or scripts/database. Watching progress and errors with noVNC:

scripts/create 44 mariadbi socket
scripts/test 44 system novnc administrator/components/com_users/Users.cy.js 

Repeat for the other four database variants:

foreach variant in "mysqli" "mysql" "mariadb" "pgsql"; do
  scripts/database 44 $variant socket
  scripts/test 44 system novnc administrator/components/com_users/Users.cy.js 
done

Install Joomla Patch Tester and "Apply Patch" 44092 in backend

scripts/patchtester 

And repeat the tests:

foreach variant in "mariadbi"  "mysqli" "mysql" "mariadb" "pgsql"; do
  scripts/database 44 $variant socket
  scripts/test 44 system novnc administrator/components/com_users/Users.cy.js 
done

Final run overall System Tests suite for one database variant:

scripts/test 44 system

Actual result BEFORE applying this Pull Request

The administrator/components/com_users/Users.cy.js 4 of the 6 tests fail with e.g.
getaddrinfo ENOTFOUND unix:/jbt/run/mariadb-socket/mysqld.sock

Expected result AFTER applying this Pull Request

Installation step and System Tests with custom database commands work for all database variants.

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