Error Returned From Database: password authentication failed for user "postgres"

[DennisTheMenace780]

I am trying to run cargo test but I keep getting password authentication issues coming from sqlx that I can't quite debug. As far as I am aware, sqlx reads from a top-level .env file with a DB URL, this is what I have in my .env: DATABASE_URL="postgres://postgres:password@localhost:5432/newsletter"

I have included my tests below with sqlx and maybe something might spring out, but I can't really figure out why it won't pick up the password.

use newsletter::{config::get_configuration, startup::run};
use sqlx::{Connection, PgConnection};
use std::net::TcpListener;

#[tokio::test]
async fn health_check() {
    // Arrange
    let client = reqwest::Client::new(); // "web browser"
    let address = spawn_app();

    // Act
    let response = client
        .get(&format!("{}/health_check", &address))
        .send()
        .await
        .expect("Failed to execute request.");

    // Assert
    assert!(response.status().is_success());
    assert_eq!(Some(0), response.content_length());
}

#[tokio::test]
async fn subscribe_returns_200_for_valid_form_submission() {
    // Arrange
    let address = spawn_app();
    let configuration = get_configuration().expect("Failed to read configuration");
    let connection_string = configuration.database.connection_string();
    let mut connection = PgConnection::connect(&connection_string)
        .await
        .expect("Failed to connect to Postgres.");
    let client = reqwest::Client::new();
    let encoded_body = "name=le%20guin&email=ursula_le_guin%40gmail.com";

    // Act
    let response = client
        .post(&format!("{}/subscriptions", &address))
        .header("Content-Type", "application/x-www-form-urlencoded")
        .body(encoded_body)
        .send()
        .await
        .expect("Failed to execute request.");

    // Assert
    assert_eq!(200, response.status().as_u16());

    let saved = sqlx::query!("SELECT email, name from subscriptions")
        .fetch_one(&mut connection)
        .await
        .expect("Failed to fetch saved subscription");

    assert_eq!(saved.email, "[email protected]");
    assert_eq!(saved.name, "le guin");
}

fn spawn_app() -> String {
    // The function sets up a TcpListener that waits for requests on IP:PORT.
    // Since we have set a random port, we'll figure out which port the listener is active on.
    let listener = TcpListener::bind("127.0.0.1:0").expect("Failed to bind to random port");
    let port = listener
        .local_addr()
        .expect("Could not return port number")
        .port();
    // Once we know that active port we can pass the listener into the server and
    // run the application as a background Tokio task.
    let server = run(listener).expect("Failed to bind address");
    let _ = tokio::spawn(server);
    format!("http://127.0.0.1:{}", port)
}

[petarjuki7]

I see you are following the zero2prod book, I am having the same problem also.
I think everything is configured correctly so I don't understand what to problem is...
Have you maybe found a fix?

[hubchub]

Hey guys, this is definitely from the zero2prod book and I just got mine working. Happy to help out if you still need.

[Squshy]

@hubchub What was required to get this working? With a docker container running Postgres version 17, I am able to connect using the following:

docker exec -it postgres psql postgres://postgres:password@localhost:5432/postgres

However I run into a similar issue when I use sqlx:

DATABASE_URL=postgres://postgres:password@localhost:5432/postgres sqlx database create. This will fail with error: error returned from database: password authentication failed for user "postgres" (or any other user using sqlx version 0.8.3).

How were you able to get it to connect?