Repeated "Password authentication failed" on docker install

[rogueai]

Hi,

I'm experiencing several error messages in what seems to be the connection to the database. I'm running on docker using the provided compose template with koillection 1.4.13 and Postgres 16

From the start, it takes a few times for the container to connect to the db, it restarts a few times until it's finally able to authenticate. Docker logs report:

"An exception occurred in the driver: SQLSTATE[08006] [7] connection to server at "db" (10.0.5.14), port 5432 failed: FATAL:  password authentication failed for user "koillection""]

In ExceptionConverter.php line 77:

  An exception occurred in the driver: SQLSTATE[08006] [7] connection to server at "db" (10.0.5.14), port 5432 failed: FATAL:  password authentication failed for user "koillection"                                                 

In Exception.php line 28:

  SQLSTATE[08006] [7] connection to server at "db" (10.0.5.14), port 5432 failed: FATAL:  password authentication failed for user "koillection"           
                                                                        
In Driver.php line 34:
                                                                         
  SQLSTATE[08006] [7] connection to server at "db" (10.0.5.14), port 5432 failed: FATAL:  password authentication failed for user "koillection"    

Afer several container restarts, the server boots up and I'm able to register the first user, however i get seemingly random connection issues when navigating, here's a log after enabling app debug:

Doctrine\DBAL\Exception\ConnectionException:
An exception occurred in the driver: SQLSTATE[08006] [7] connection to server at "db" (10.0.5.14), port 5432 failed: FATAL:  password authentication failed for user "koillection"

  at vendor/doctrine/dbal/src/Driver/API/PostgreSQL/ExceptionConverter.php:77
  at Doctrine\DBAL\Driver\API\PostgreSQL\ExceptionConverter->convert()
     (vendor/doctrine/dbal/src/Connection.php:1935)
  at Doctrine\DBAL\Connection->handleDriverException()
     (vendor/doctrine/dbal/src/Connection.php:1884)
  at Doctrine\DBAL\Connection->convertException()
     (vendor/doctrine/dbal/src/Connection.php:377)
  at Doctrine\DBAL\Connection->connect()
     (vendor/doctrine/dbal/src/Connection.php:1652)
  at Doctrine\DBAL\Connection->getWrappedConnection()
     (vendor/doctrine/dbal/src/Connection.php:1079)
  at Doctrine\DBAL\Connection->executeQuery()
     (vendor/doctrine/orm/lib/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php:771)
  at Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load()
     (vendor/doctrine/orm/lib/Doctrine/ORM/EntityRepository.php:241)
  at Doctrine\ORM\EntityRepository->findOneBy()
     (vendor/symfony/doctrine-bridge/Security/User/EntityUserProvider.php:54)
  at Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->loadUserByIdentifier()
     (vendor/symfony/security-http/RememberMe/AbstractRememberMeHandler.php:63)
  at Symfony\Component\Security\Http\RememberMe\AbstractRememberMeHandler->consumeRememberMeCookie()
     (vendor/symfony/security-http/RememberMe/SignatureRememberMeHandler.php:63)
  at Symfony\Component\Security\Http\RememberMe\SignatureRememberMeHandler->consumeRememberMeCookie()
     (vendor/symfony/security-http/Authenticator/RememberMeAuthenticator.php:90)
  at Symfony\Component\Security\Http\Authenticator\RememberMeAuthenticator->Symfony\Component\Security\Http\Authenticator\{closure}()
     (vendor/symfony/security-http/Authenticator/Passport/Badge/UserBadge.php:87)
  at Symfony\Component\Security\Http\Authenticator\Passport\Badge\UserBadge->getUser()
     (vendor/symfony/security-http/Authenticator/Passport/Passport.php:56)
  at Symfony\Component\Security\Http\Authenticator\Passport\Passport->getUser()
     (vendor/symfony/security-http/EventListener/UserCheckerListener.php:42)
  at Symfony\Component\Security\Http\EventListener\UserCheckerListener->preCheckCredentials()
     (vendor/symfony/event-dispatcher/Debug/WrappedListener.php:116)
  at Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke()
     (vendor/symfony/event-dispatcher/EventDispatcher.php:220)
  at Symfony\Component\EventDispatcher\EventDispatcher->callListeners()
     (vendor/symfony/event-dispatcher/EventDispatcher.php:56)
  at Symfony\Component\EventDispatcher\EventDispatcher->dispatch()
     (vendor/symfony/event-dispatcher/Debug/TraceableEventDispatcher.php:139)
  at Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch()
     (vendor/symfony/security-http/Authentication/AuthenticatorManager.php:180)
  at Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator()
     (vendor/symfony/security-http/Authentication/AuthenticatorManager.php:158)
  at Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators()
     (vendor/symfony/security-http/Authentication/AuthenticatorManager.php:140)
  at Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest()
     (vendor/symfony/security-http/Firewall/AuthenticatorManagerListener.php:40)
  at Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate()
     (vendor/symfony/security-http/Authenticator/Debug/TraceableAuthenticatorManagerListener.php:66)
  at Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate()
     (vendor/symfony/security-bundle/Debug/WrappedLazyListener.php:46)
  at Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate()
     (vendor/symfony/security-bundle/Security/LazyFirewallContext.php:60)
  at Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke()
     (vendor/symfony/security-bundle/Debug/TraceableFirewallListener.php:80)
  at Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners()
     (vendor/symfony/security-http/Firewall.php:95)
  at Symfony\Component\Security\Http\Firewall->onKernelRequest()
     (vendor/symfony/event-dispatcher/Debug/WrappedListener.php:116)
  at Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke()
     (vendor/symfony/event-dispatcher/EventDispatcher.php:220)
  at Symfony\Component\EventDispatcher\EventDispatcher->callListeners()
     (vendor/symfony/event-dispatcher/EventDispatcher.php:56)
  at Symfony\Component\EventDispatcher\EventDispatcher->dispatch()
     (vendor/symfony/event-dispatcher/Debug/TraceableEventDispatcher.php:139)
  at Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch()
     (vendor/symfony/http-kernel/HttpKernel.php:157)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw()
     (vendor/symfony/http-kernel/HttpKernel.php:76)
  at Symfony\Component\HttpKernel\HttpKernel->handle()
     (vendor/symfony/http-kernel/Kernel.php:197)
  at Symfony\Component\HttpKernel\Kernel->handle()
     (vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:35)
  at Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run()
     (vendor/autoload_runtime.php:29)
  at require_once('/var/www/koillection/vendor/autoload_runtime.php')
     (public/index.php:5)                

[benjaminjonard]

Hi, it looks like a problem with database credentials or with the database itself.

Could you please check if your database is properly running ? docker compose logs -f db should give you some informations

[brkr1]

docker compose logs -f db

Same happens to me.

Here are the logs:

PostgreSQL Database directory appears to contain a database; Skipping initialization
db |
db | 2024-04-16 01:07:20.602 UTC [1] LOG: starting PostgreSQL 16.2 (Debian 16.2-1.pgdg120+2) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit
db | 2024-04-16 01:07:20.603 UTC [1] LOG: listening on IPv4 address "0.0.0.0", port 5432
db | 2024-04-16 01:07:20.603 UTC [1] LOG: listening on IPv6 address "::", port 5432
db | 2024-04-16 01:07:20.609 UTC [1] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
db | 2024-04-16 01:07:20.616 UTC [29] LOG: database system was shut down at 2024-04-16 01:07:19 UTC
db | 2024-04-16 01:07:20.624 UTC [1] LOG: database system is ready to accept connections
db | 2024-04-16 01:07:20.974 UTC [33] FATAL: password authentication failed for user "koillection"
db | 2024-04-16 01:07:20.974 UTC [33] DETAIL: Role "koillection" does not exist.
db | Connection matched file "/var/lib/postgresql/data/pg_hba.conf" line 128: "host all all all scram-sha-256"
db | 2024-04-16 01:07:21.654 UTC [34] FATAL: password authentication failed for user "koillection"
db | 2024-04-16 01:07:21.654 UTC [34] DETAIL: Role "koillection" does not exist.

[benjaminjonard]

I looks like a problem happened during the database container initialization. Could you try removing your database volume and then restarting the database container only with docker compose up db -d ?

[rodrigorega]

Same issue here.