Uploaded image for project: 'Moodle'
  1. Moodle
  2. MDL-85180

"Unable to connect to PostgreSQL server" warning on PostgreSQL PHPUnit runs

XMLWordPrintable

    • MOODLE_500_STABLE

      Our unit tests in CI are passing, but they are showing the following warning:

      PHP Warning: pg_connect(): Unable to connect to PostgreSQL server: connection to server at "databasef27cca411363fa0f" (192.168.144.2), port 5432 failed: server does not support SSL, but SSL was required in /var/www/html/lib/dml/pgsql_native_moodle_database.php on line 214

      For example: https://ci.moodle.org/view/B%20-%20main/job/W.01.01%20-%20PHPUnit%20-%20Postgres/3202

      Running: php vendor/bin/phpunit --disallow-test-output --fail-on-risky --log-junit /shared/log.junit
       
      >>> PHPUnit run 1 at Fri Apr 11 10:04:48 PM UTC 2025 <<<
      Moodle 5.0rc3 (Build: 20250411), 095a8636747e985eaf85a4d97a47b91e5cb2bfc5
      Php: 8.4.5, pgsql: 14.17 (Debian 14.17-1.pgdg120+1), OS: Linux 5.15.0-126-generic x86_64
      PHPUnit 11.5.12 by Sebastian Bergmann and contributors.
       
      Runtime:       PHP 8.4.5
      Configuration: /var/www/html/phpunit.xml
       
      ...........................................................    59 / 24469 (  0%)
      ...........................................................   118 / 24469 (  0%)
      ...........................................SSS.............   177 / 24469 (  0%)
      ...........................................................   236 / 24469 (  0%)
      ...........................................................   295 / 24469 (  1%)
      ........SSSSSSSSSSSS.SS..........PHP Warning:  pg_connect(): Unable to connect to PostgreSQL server: connection to server at "databasef27cca411363fa0f" (192.168.144.2), port 5432 failed: server does not support SSL, but SSL was required in /var/www/html/lib/dml/pgsql_native_moodle_database.php on line 214
      S.........................   354 / 24469 (  1%)
      ...........................................................   413 / 24469 (  1%)
      ...........................................................   472 / 24469 (  1%)
      ...........................................................   531 / 24469 (  2%)
      ...........................................................   590 / 24469 (  2%)
      ...........................................................   649 / 24469 (  2%)
      

      More info:

      • This happens on both PHP versions 8.2 and 8.4.
      • This does not seem to happen on our runs from 405 and earlier versions.

            Unassigned Unassigned
            jpataleta Jun Pataleta
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:

                Error rendering 'clockify-timesheets-time-tracking-reports:timer-sidebar'. Please contact your Jira administrators.