Page MenuHomeDevCentral
Create Task
Maniphest T2185

Create PostgreSQL database on WindRiver to test keruald Keruald Database
Closed, ResolvedPublic
Actions

Description

I'm in the process to upgrade PHPUnit from 10 to 12 for all Keruald components currently managed in the monorepo.

For that, I'd like a clean way to run the tests from WindRiver, *as is*.

At best, we can create a database with user/pass as configured in the tests
At worst, we can edit phpunit.xml default values if not.

Revisions and Commits

rOPS Nasqueron Operations
D3872rOPS05c8a48cd35d Create PostgreSQL database for Keruald tests

Related Objects

Event Timeline

dereckson triaged this task as Normal priority.Tue, Nov 11, 01:41
dereckson created this task.
dereckson added a comment.Tue, Nov 11, 01:47

Actually, we use the same database name than for MariaDB / MySQl:

BasePDOPostgreSQLTestCase.php

13: const string DB_NAME = "test_keruald_db";

dereckson added a comment.Tue, Nov 11, 02:30

Each test run produces this:

Nov 11 02:29:33 windriver postgres[63389]: [19-1] 2025-11-11 02:29:33.804 UTC [63389] ERROR:  relation "nonexisting" does not exist at character 13
Nov 11 02:29:33 windriver postgres[63389]: [19-2] 2025-11-11 02:29:33.804 UTC [63389] STATEMENT:  DELETE FROM nonexisting
Nov 11 02:29:34 windriver postgres[63402]: [19-1] 2025-11-11 02:29:34.181 UTC [63402] ERROR:  relation "nonexisting" does not exist at character 15
Nov 11 02:29:34 windriver postgres[63402]: [19-2] 2025-11-11 02:29:34.181 UTC [63402] STATEMENT:  SELECT * FROM nonexisting
Nov 11 02:29:34 windriver postgres[63403]: [19-1] 2025-11-11 02:29:34.209 UTC [63403] ERROR:  relation "nonexisting" does not exist at character 15
Nov 11 02:29:34 windriver postgres[63403]: [19-2] 2025-11-11 02:29:34.209 UTC [63403] STATEMENT:  SELECT * FROM nonexisting
Nov 11 02:29:34 windriver postgres[63408]: [19-1] 2025-11-11 02:29:34.357 UTC [63408] ERROR:  relation "not_existing_table" does not exist
Nov 11 02:29:34 windriver postgres[63408]: [19-2] 2025-11-11 02:29:34.357 UTC [63408] STATEMENT:  TRUNCATE not_existing_table
Nov 11 02:29:34 windriver postgres[63409]: [19-1] 2025-11-11 02:29:34.385 UTC [63409] ERROR:  relation "not_existing" does not exist
Nov 11 02:29:34 windriver postgres[63409]: [19-2] 2025-11-11 02:29:34.385 UTC [63409] STATEMENT:  TRUNCATE not_existing
Nov 11 02:29:34 windriver postgres[63416]: [19-1] 2025-11-11 02:29:34.591 UTC [63416] FATAL:  password authentication failed for user "notexisting"
Nov 11 02:29:34 windriver postgres[63416]: [19-2] 2025-11-11 02:29:34.591 UTC [63416] DETAIL:  Role "notexisting" does not exist.
Nov 11 02:29:34 windriver postgres[63416]: [19-3]       Connection matched pg_hba.conf line 22: "host    all             all             127.0.0.1/32            scram-sha-256"

I guess we could avoid to post PostgreSQL logs directly in /var/log/messages.

dereckson mentioned this in T2187: Create a separate PostgreSQL log.Tue, Nov 11, 02:33
dereckson added a revision: D3872: Create PostgreSQL database for Keruald tests.Tue, Nov 11, 02:37
dereckson added a commit: rOPS05c8a48cd35d: Create PostgreSQL database for Keruald tests.Tue, Nov 11, 02:38
dereckson closed this task as Resolved.Tue, Nov 11, 02:42
Nasqueron DevCentral · If it had been much bigger the moon would have had a core of ice. · Powered by Phabricator