Encountering issue while trying to run test cases and throwing error while running this command psql -U openadr -W openadr -h localhost openadr < fixtures/test_user_credentials.sql

[abhishek-ceremobility]

I am trying to run the testcases but not able to run the test cases successfully.

docker compose up db -d # start up a Postgres DB in the background
cargo sqlx migrate run # apply the DB scheme

Encountering issue while trying to run test cases and throwing error while running this psql
psql -U openadr -W openadr -h localhost openadr < fixtures/test_user_credentials.sql

cargo test --workspace # execute the tests

problem while runnig his psql -U openadr -W openadr -h localhost openadr < fixtures/test_user_credentials.sql

PS C:\Users\ABHI\OneDrive\Desktop\Openadr\openleadr-rs> psql -U openadr -W openadr -h localhost openadr fixtures/test_user_credentials.sql
psql: warning: extra command-line argument "openadr" ignored
psql: warning: extra command-line argument "fixtures/test_user_credentials.sql" ignored
Password:
psql: error: connection to server at "localhost" (::1), port 5432 failed: FATAL: password authentication failed for user "openadr"
PS C:\Users\ABHI\OneDrive\Desktop\Openadr\openleadr-rs>

[pohlm01]

Hi @abhishek-ceremobility,

It seems that you are running on a Windows PowerShell. I'm not too familiar with Windows, but apparently the command from the README does not work there literally. In the end, you have to make sure you set up a database that is reachable for the VTN and has the initial schema applied. Additionally, it's nice to run the commands from fixtures/test_user_credentials.sql to have the first user credentials, but this is not required to start up the VTN.

I hope that get's you a step further!

[pohlm01]

fixtures/test_user_credentials.sql is not a command but an SQL script. I doubt that the contained commands are successfully executed on your DB.

The error message shows that your password for the DB is incorrect. Can you provide me the DB URL that you use?

If you don't need to execute the tests but only set up a running VTN, you can also opt to run it completely containerized such that you have fewer possible configuration mistakes. To do so, simply run docker compose up, and you should be able to reach the VTN on http://localhost:3000

[abhishek-ceremobility]

DATABASE_URL=postgres://openadr:openadr@localhost:5432/openadr
VTN_PORT=3000
PG_PORT=5432
PG_USER=openadr
PG_DB=openadr
PG_PASSWORD=openadr
PG_TZ=Europe/Amsterdam

[abhishek-ceremobility]

On directing to http://localhost:3000 IT is showing {
"type": "about:blank",
"title": "404 Not Found",
"status": 404,
"instance": "eb5b9e6a-01b9-44c0-a12e-8675568b8d71"
} is this correct is VTN Server is running ?
For ur reference i have attached Screenshot plz guide further.

[abhishek-ceremobility]

On directing to this - http://localhost:3000/health
It is showing OK message
For ur reference i have attached Screenshot plz guide further.

[pohlm01]

Yes, the responses to the / and /health routes indicate that the VTN is running

[abhishek-ceremobility]

Plz guide regarding test cases how to execute

…

On Mon, 17 Feb, 2025, 8:50 pm Maximilian Pohl, ***@***.***> wrote: Yes, the responses to the / and /health routes indicate that the VTN is running — Reply to this email directly, view it on GitHub <#158 (reply in thread)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/A7RJJPKRBFOVRABBM5ZWCJD2QH437AVCNFSM6AAAAABXD623EKVHI2DSMVQWIX3LMV43URDJONRXK43TNFXW4Q3PNVWWK3TUHMYTEMRSGYYTKMY> . You are receiving this because you were mentioned.Message ID: ***@***.***>

[pohlm01]

@abhishek-ceremobility wrote in #162

Please provide a step-by-step guideline for executing the process of TEST CASES in the correct sequence, as I am facing difficulties. My VTN is successfully set up; please guide me further.

AND ALSO PLZ WRITE THE COMMAND AND SQL SCRIPT REQUIRED FOR THIS IN SEQUENCE.

AND ASLO PLZ CONFIRM IS THERE ANY CHANGES REQUIRED IN ENV FILE

DATABASE_URL=postgres://postgres:Kishan8051@localhost:5432/Openadr
VTN_PORT=3000
PG_PORT=5432
PG_USER=postgres
PG_DB=Openadr
PG_PASSWORD=Kishan8051
PG_TZ=Europe/Amsterdam
this is my local url setup

---

Dear @abhishek-ceremobility,

First of all, please do not constantly open new issues and discussions. If you encounter further problems of the same kind, please keep reusing this discussion thread.

To keep the number of possible misconfigurations minimal, I suggest that you do not modify the .env file or the docker-compose.yaml. As you showed in earlier comments, the problem seems related to a wrong DB password, i.e., some configuration mistake. I would also ask you to try bug-fixing your setup more autonomously. I'm happy to help where possible, but currently, it seems that the problems you describe are only loosely related to the codebase and are caused mainly by your setup.

[abhishek-ceremobility]

Setup completed as per the standard without changing in .env and docker-compose.yaml.

NEXT STEP I WANT TO RUN TEST CASE BUT I AM UNABLE TO RUN THE TESTS CASES PLZ GUIDE HOW TO DO THIS