PgAdmin failing to connect

[nathanAjacobs]

I'm trying to run PgAdmin but it is failing to connect and I am unsure why. I'm using Docker Desktop and I have tried both with and without WSL.

IResourceBuilder<ParameterResource>? postgresPassword = builder.AddParameter("postgresspassword", secret: true);

var db = builder.AddPostgres(ServiceNames.LINK_DATABASE.SERVER_NAME, postgresPassword)
    .WithDataVolume()
    .WithPgAdmin()
    .AddDatabase(ServiceNames.LINK_DATABASE.NAME);

[davidfowl]

What version of aspire are you using and what container runtime are you using?

[nathanAjacobs]

Hi David! Thanks for the quick response, I'm using latest.

I found one mistake on my part. I left out the password: specified parameter, so it was passing the password as the username. I've corrected that, but I'm still seeing the issue.

builder.AddPostgres(ServiceNames.LINK_DATABASE.SERVER_NAME, password: postgresPassword)

[nathanAjacobs]

I'm using Docker Desktop, I've tried with and without WSL.

[nathanAjacobs]

So my EntityFramework migration service is also failing to connect, I'm not sure what I am missing.

{
  "Logging": {
    "LogLevel": {
      "Default": "Information",
      "Microsoft.AspNetCore": "Warning",
      "Aspire.Hosting.Dcp": "Warning"
    }
  },
  "Parameters": {
    "postgresspassword": "LinkPassword"
  }
}

builder.AddProject<Projects.LinkApi_Service_DatabaseMigration>(ServiceNames.MIGRATION)
    .WithReference(db);

Npgsql.PostgresException (0x80004005): 28P01: password authentication failed for user "postgres"
   at Npgsql.Internal.NpgsqlConnector.ReadMessageLong(Boolean async, DataRowLoadingMode dataRowLoadingMode, Boolean readingNotifications, Boolean isReadingPrependedMessage)
   at System.Runtime.CompilerServices.PoolingAsyncValueTaskMethodBuilder`1.StateMachineBox`1.System.Threading.Tasks.Sources.IValueTaskSource<TResult>.GetResult(Int16 token)
   at Npgsql.Internal.NpgsqlConnector.AuthenticateSASL(List`1 mechanisms, String username, Boolean async, CancellationToken cancellationToken)
   at Npgsql.Internal.NpgsqlConnector.Authenticate(String username, NpgsqlTimeout timeout, Boolean async, CancellationToken cancellationToken)
   at Npgsql.Internal.NpgsqlConnector.<Open>g__OpenCore|213_1(NpgsqlConnector conn, SslMode sslMode, NpgsqlTimeout timeout, Boolean async, CancellationToken cancellationToken, Boolean isFirstAttempt)
   at Npgsql.Internal.NpgsqlConnector.Open(NpgsqlTimeout timeout, Boolean async, CancellationToken cancellationToken)
   at Npgsql.UnpooledDataSource.Get(NpgsqlConnection conn, NpgsqlTimeout timeout, Boolean async, CancellationToken cancellationToken)
   at Npgsql.NpgsqlConnection.<Open>g__OpenAsync|42_0(Boolean async, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.OpenInternalAsync(Boolean errorsExpected, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.OpenInternalAsync(Boolean errorsExpected, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.OpenAsync(CancellationToken cancellationToken, Boolean errorsExpected)
   at Npgsql.EntityFrameworkCore.PostgreSQL.Storage.Internal.NpgsqlDatabaseCreator.Exists(Boolean async, CancellationToken cancellationToken)
   at Npgsql.EntityFrameworkCore.PostgreSQL.Storage.Internal.NpgsqlDatabaseCreator.Exists(Boolean async, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Migrations.HistoryRepository.ExistsAsync(CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Migrations.HistoryRepository.GetAppliedMigrationsAsync(CancellationToken cancellationToken)
   at Npgsql.EntityFrameworkCore.PostgreSQL.Migrations.Internal.NpgsqlMigrator.MigrateAsync(String targetMigration, CancellationToken cancellationToken)
   at LinkApi.Service.DatabaseMigration.Worker.ExecuteAsync(CancellationToken stoppingToken) in C:\Users\natha\source\LinkApi\LinkApi.Service.DatabaseMigration\Worker.cs:line 35
   at Microsoft.Extensions.Hosting.Internal.Host.TryExecuteBackgroundServiceAsync(BackgroundService backgroundService)
  Exception data:
    Severity: FATAL
    SqlState: 28P01
    MessageText: password authentication failed for user "postgres"
    File: auth.c
    Line: 323
    Routine: auth_failed```

[davidfowl]

Try deleting the volume and retrying?