Error 500 Internal Server Error

GET https://jdenes.lyceestvincent.fr/bts-2025-2026-symfony-coffeeshop-coffeeshop-julie/public/produits

IP
47.128.96.239
Profiled on
Token
57fb04
Forwarded to ErrorController (fe8274)

Exceptions

PDOException Exception ConnectionException

HTTP 500 Internal Server Error

An exception occurred in the driver: SQLSTATE[HY000] [2002] Connection refused

Exceptions 3

Doctrine\DBAL\Exception\ ConnectionException

Show exception properties 
Doctrine\DBAL\Exception\ConnectionException {#625
  -query: null
}
in vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php (line 91)
  1. 1227,
  2. 1370,
  3. 1429,
  4. 2002,
  5. 2005,
  6. 2054 => new ConnectionException($exception, $query),
  7. 2006,
  8. 4031 => new ConnectionLost($exception, $query),
  9. 1048,
  10. 1121,
  11. 1138,
in vendor/doctrine/dbal/src/Connection.php -> convert (line 1456)
  1. private function handleDriverException(
  2. Driver\Exception $driverException,
  3. ?Query $query,
  4. ): DriverException {
  5. $this->exceptionConverter ??= $this->driver->getExceptionConverter();
  6. $exception = $this->exceptionConverter->convert($driverException, $query);
  8. if ($exception instanceof ConnectionLost) {
  9. $this->close();
  10. }
in vendor/doctrine/dbal/src/Connection.php -> handleDriverException (line 1398)
  1. }
  3. /** @internal */
  4. final public function convertException(Driver\Exception $e): DriverException
  5. {
  6. return $this->handleDriverException($e, null);
  7. }
  9. /**
  10. * @param list<mixed>|array<string, mixed> $params
  11. * @phpstan-param WrapperParameterTypeArray $types
in vendor/doctrine/dbal/src/Connection.php -> convertException (line 224)
  1. }
  3. try {
  4. $connection = $this->_conn = $this->driver->connect($this->params);
  5. } catch (Driver\Exception $e) {
  6. throw $this->convertException($e);
  7. }
  9. if ($this->autoCommit === false) {
  10. $this->beginTransaction();
  11. }
in vendor/doctrine/dbal/src/Connection.php -> connect (line 792)
  1. ): Result {
  2. if ($qcp !== null) {
  3. return $this->executeCacheQuery($sql, $params, $types, $qcp);
  4. }
  6. $connection = $this->connect();
  8. try {
  9. if (count($params) > 0) {
  10. [$sql, $params, $types] = $this->expandArrayParameters($sql, $params, $types);
in vendor/doctrine/orm/src/Persisters/Entity/BasicEntityPersister.php -> executeQuery (line 963)
  1. ): array {
  2. $this->switchPersisterContext($offset, $limit);
  4. $sql = $this->getSelectSQL($criteria, null, null, $limit, $offset, $orderBy);
  5. [$params, $types] = $this->expandParameters($criteria);
  6. $stmt = $this->conn->executeQuery($sql, $params, $types);
  8. $hydrator = $this->em->newHydrator($this->currentPersisterContext->selectJoinSql ? Query::HYDRATE_OBJECT : Query::HYDRATE_SIMPLEOBJECT);
  10. return $hydrator->hydrateAll($stmt, $this->currentPersisterContext->rsm, [UnitOfWork::HINT_DEFEREAGERLOAD => true]);
  11. }
in vendor/doctrine/orm/src/EntityRepository.php -> loadAll (line 110)
  1. */
  2. public function findBy(array $criteria, array|null $orderBy = null, int|null $limit = null, int|null $offset = null): array
  3. {
  4. $persister = $this->em->getUnitOfWork()->getEntityPersister($this->entityName);
  6. return $persister->loadAll($criteria, $orderBy, $limit, $offset);
  7. }
  9. /**
  10. * Finds a single entity by a set of criteria.
  11. *
in vendor/doctrine/doctrine-bundle/src/Repository/ServiceEntityRepositoryProxy.php -> findBy (line 73)
  1. * @psalm-suppress InvalidReturnType This proxy is used only in combination with newer parent class
  2. */
  3. public function findBy(array $criteria, array|null $orderBy = null, int|null $limit = null, int|null $offset = null): array
  4. {
  5. return ($this->repository ??= $this->resolveRepository())
  6. ->findBy($criteria, $orderBy, $limit, $offset);
  7. }
  9. /** {@inheritDoc} */
  10. public function findOneBy(array $criteria, array|null $orderBy = null): object|null
  11. {
in vendor/doctrine/orm/src/EntityRepository.php -> findBy (line 96)
  1. *
  2. * @phpstan-return list<T> The entities.
  3. */
  4. public function findAll(): array
  5. {
  6. return $this->findBy([]);
  7. }
  9. /**
  10. * Finds entities by a set of criteria.
  11. *
EntityRepository->findAll() in src/Controller/TwigController.php (line 73)
  1. $selectedCategory = $request->query->get('category', '');
  2. $selectedBrand = $request->query->get('brand', '');
  3. $maxPrice = $request->query->get('max_price', '');
  5. // --- Récupération des catégories & marques de la BDD ---
  6. $categories = $categorieRepository->findAll();
  7. $marques = $marqueRepository->findAll();
  9. // --- Construction dynamique du filtre ---
  10. $criteria = [];
in vendor/symfony/http-kernel/HttpKernel.php -> products (line 183)
  1. $this->dispatcher->dispatch($event, KernelEvents::CONTROLLER_ARGUMENTS);
  2. $controller = $event->getController();
  3. $arguments = $event->getArguments();
  5. // call controller
  6. $response = $controller(...$arguments);
  8. // view
  9. if (!$response instanceof Response) {
  10. $event = new ViewEvent($this, $request, $type, $response, $event);
  11. $this->dispatcher->dispatch($event, KernelEvents::VIEW);
in vendor/symfony/http-kernel/HttpKernel.php -> handleRaw (line 76)
  1. $request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
  3. $this->requestStack->push($request);
  4. $response = null;
  5. try {
  6. return $response = $this->handleRaw($request, $type);
  7. } catch (\Throwable $e) {
  8. if ($e instanceof \Error && !$this->handleAllThrowables) {
  9. throw $e;
  10. }
in vendor/symfony/http-kernel/Kernel.php -> handle (line 182)
  1. $this->boot();
  2. ++$this->requestStackSize;
  3. $this->resetServices = true;
  5. try {
  6. return $this->getHttpKernel()->handle($request, $type, $catch);
  7. } finally {
  8. --$this->requestStackSize;
  9. }
  10. }
in vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php -> handle (line 35)
  1. ) {
  2. }
  4. public function run(): int
  5. {
  6. $response = $this->kernel->handle($this->request);
  8. if (Kernel::VERSION_ID >= 60400) {
  9. $response->send(false);
  11. if (\function_exists('fastcgi_finish_request') && !$this->debug) {
in vendor/autoload_runtime.php -> run (line 29)
  1. $app = $app(...$args);
  3. exit(
  4. $runtime
  5. ->getRunner($app)
  6. ->run()
  7. );
require_once('/home/lyceestvincent/www/jdenes/bts-2025-2026-symfony-coffeeshop-coffeeshop-julie/vendor/autoload_runtime.php') in public/index.php (line 5)
  1. <?php
  3. use App\Kernel;
  5. require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
  7. return function (array $context) {
  8. return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);
  10. };

Doctrine\DBAL\Driver\PDO\ Exception

SQLSTATE[HY000] [2002] Connection refused

in vendor/doctrine/dbal/src/Driver/PDO/Exception.php (line 24)
  1. } else {
  2. $code = $exception->getCode();
  3. $sqlState = null;
  4. }
  6. return new self($exception->getMessage(), $sqlState, $code, $exception);
  7. }
  8. }
in vendor/doctrine/dbal/src/Driver/PDO/MySQL/Driver.php :: new (line 52)
  1. $params['user'] ?? '',
  2. $params['password'] ?? '',
  3. $driverOptions,
  4. );
  5. } catch (PDOException $exception) {
  6. throw Exception::new($exception);
  7. }
  9. return new Connection($pdo);
  10. }
in vendor/doctrine/dbal/src/Driver/Middleware/AbstractDriverMiddleware.php -> connect (line 27)
  1. */
  2. public function connect(
  3. #[SensitiveParameter]
  4. array $params,
  5. ): DriverConnection {
  6. return $this->wrappedDriver->connect($params);
  7. }
  9. public function getDatabasePlatform(ServerVersionProvider $versionProvider): AbstractPlatform
  10. {
  11. return $this->wrappedDriver->getDatabasePlatform($versionProvider);
in vendor/symfony/doctrine-bridge/Middleware/Debug/Driver.php -> connect (line 37)
  1. parent::__construct($driver);
  2. }
  4. public function connect(array $params): ConnectionInterface
  5. {
  6. $connection = parent::connect($params);
  8. if ('void' !== (string) (new \ReflectionMethod(ConnectionInterface::class, 'commit'))->getReturnType()) {
  9. return new DBAL3\Connection(
  10. $connection,
  11. $this->debugDataHolder,
in vendor/doctrine/dbal/src/Driver/Middleware/AbstractDriverMiddleware.php -> connect (line 27)
  1. */
  2. public function connect(
  3. #[SensitiveParameter]
  4. array $params,
  5. ): DriverConnection {
  6. return $this->wrappedDriver->connect($params);
  7. }
  9. public function getDatabasePlatform(ServerVersionProvider $versionProvider): AbstractPlatform
  10. {
  11. return $this->wrappedDriver->getDatabasePlatform($versionProvider);
in vendor/symfony/doctrine-bridge/Middleware/IdleConnection/Driver.php -> connect (line 35)
  1. }
  3. public function connect(array $params): ConnectionInterface
  4. {
  5. $timestamp = time();
  6. $connection = parent::connect($params);
  7. $this->connectionExpiries[$this->connectionName] = $timestamp + $this->ttl;
  9. return $connection;
  10. }
  11. }
in vendor/doctrine/dbal/src/Connection.php -> connect (line 222)
  1. if ($this->_conn !== null) {
  2. return $this->_conn;
  3. }
  5. try {
  6. $connection = $this->_conn = $this->driver->connect($this->params);
  7. } catch (Driver\Exception $e) {
  8. throw $this->convertException($e);
  9. }
  11. if ($this->autoCommit === false) {
in vendor/doctrine/dbal/src/Connection.php -> connect (line 792)
  1. ): Result {
  2. if ($qcp !== null) {
  3. return $this->executeCacheQuery($sql, $params, $types, $qcp);
  4. }
  6. $connection = $this->connect();
  8. try {
  9. if (count($params) > 0) {
  10. [$sql, $params, $types] = $this->expandArrayParameters($sql, $params, $types);
in vendor/doctrine/orm/src/Persisters/Entity/BasicEntityPersister.php -> executeQuery (line 963)
  1. ): array {
  2. $this->switchPersisterContext($offset, $limit);
  4. $sql = $this->getSelectSQL($criteria, null, null, $limit, $offset, $orderBy);
  5. [$params, $types] = $this->expandParameters($criteria);
  6. $stmt = $this->conn->executeQuery($sql, $params, $types);
  8. $hydrator = $this->em->newHydrator($this->currentPersisterContext->selectJoinSql ? Query::HYDRATE_OBJECT : Query::HYDRATE_SIMPLEOBJECT);
  10. return $hydrator->hydrateAll($stmt, $this->currentPersisterContext->rsm, [UnitOfWork::HINT_DEFEREAGERLOAD => true]);
  11. }
in vendor/doctrine/orm/src/EntityRepository.php -> loadAll (line 110)
  1. */
  2. public function findBy(array $criteria, array|null $orderBy = null, int|null $limit = null, int|null $offset = null): array
  3. {
  4. $persister = $this->em->getUnitOfWork()->getEntityPersister($this->entityName);
  6. return $persister->loadAll($criteria, $orderBy, $limit, $offset);
  7. }
  9. /**
  10. * Finds a single entity by a set of criteria.
  11. *
in vendor/doctrine/doctrine-bundle/src/Repository/ServiceEntityRepositoryProxy.php -> findBy (line 73)
  1. * @psalm-suppress InvalidReturnType This proxy is used only in combination with newer parent class
  2. */
  3. public function findBy(array $criteria, array|null $orderBy = null, int|null $limit = null, int|null $offset = null): array
  4. {
  5. return ($this->repository ??= $this->resolveRepository())
  6. ->findBy($criteria, $orderBy, $limit, $offset);
  7. }
  9. /** {@inheritDoc} */
  10. public function findOneBy(array $criteria, array|null $orderBy = null): object|null
  11. {
in vendor/doctrine/orm/src/EntityRepository.php -> findBy (line 96)
  1. *
  2. * @phpstan-return list<T> The entities.
  3. */
  4. public function findAll(): array
  5. {
  6. return $this->findBy([]);
  7. }
  9. /**
  10. * Finds entities by a set of criteria.
  11. *
EntityRepository->findAll() in src/Controller/TwigController.php (line 73)
  1. $selectedCategory = $request->query->get('category', '');
  2. $selectedBrand = $request->query->get('brand', '');
  3. $maxPrice = $request->query->get('max_price', '');
  5. // --- Récupération des catégories & marques de la BDD ---
  6. $categories = $categorieRepository->findAll();
  7. $marques = $marqueRepository->findAll();
  9. // --- Construction dynamique du filtre ---
  10. $criteria = [];
in vendor/symfony/http-kernel/HttpKernel.php -> products (line 183)
  1. $this->dispatcher->dispatch($event, KernelEvents::CONTROLLER_ARGUMENTS);
  2. $controller = $event->getController();
  3. $arguments = $event->getArguments();
  5. // call controller
  6. $response = $controller(...$arguments);
  8. // view
  9. if (!$response instanceof Response) {
  10. $event = new ViewEvent($this, $request, $type, $response, $event);
  11. $this->dispatcher->dispatch($event, KernelEvents::VIEW);
in vendor/symfony/http-kernel/HttpKernel.php -> handleRaw (line 76)
  1. $request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
  3. $this->requestStack->push($request);
  4. $response = null;
  5. try {
  6. return $response = $this->handleRaw($request, $type);
  7. } catch (\Throwable $e) {
  8. if ($e instanceof \Error && !$this->handleAllThrowables) {
  9. throw $e;
  10. }
in vendor/symfony/http-kernel/Kernel.php -> handle (line 182)
  1. $this->boot();
  2. ++$this->requestStackSize;
  3. $this->resetServices = true;
  5. try {
  6. return $this->getHttpKernel()->handle($request, $type, $catch);
  7. } finally {
  8. --$this->requestStackSize;
  9. }
  10. }
in vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php -> handle (line 35)
  1. ) {
  2. }
  4. public function run(): int
  5. {
  6. $response = $this->kernel->handle($this->request);
  8. if (Kernel::VERSION_ID >= 60400) {
  9. $response->send(false);
  11. if (\function_exists('fastcgi_finish_request') && !$this->debug) {
in vendor/autoload_runtime.php -> run (line 29)
  1. $app = $app(...$args);
  3. exit(
  4. $runtime
  5. ->getRunner($app)
  6. ->run()
  7. );
require_once('/home/lyceestvincent/www/jdenes/bts-2025-2026-symfony-coffeeshop-coffeeshop-julie/vendor/autoload_runtime.php') in public/index.php (line 5)
  1. <?php
  3. use App\Kernel;
  5. require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
  7. return function (array $context) {
  8. return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);
  10. };

PDOException

SQLSTATE[HY000] [2002] Connection refused

in vendor/doctrine/dbal/src/Driver/PDO/PDOConnect.php (line 25)
  1. #[SensitiveParameter]
  2. string $password,
  3. array $options,
  4. ): PDO {
  5. if (PHP_VERSION_ID < 80400) {
  6. return new PDO($dsn, $username, $password, $options);
  7. }
  9. return PDO::connect($dsn, $username, $password, $options);
  10. }
  11. }
in vendor/doctrine/dbal/src/Driver/PDO/PDOConnect.php -> __construct (line 25)
  1. #[SensitiveParameter]
  2. string $password,
  3. array $options,
  4. ): PDO {
  5. if (PHP_VERSION_ID < 80400) {
  6. return new PDO($dsn, $username, $password, $options);
  7. }
  9. return PDO::connect($dsn, $username, $password, $options);
  10. }
  11. }
in vendor/doctrine/dbal/src/Driver/PDO/MySQL/Driver.php -> doConnect (line 45)
  2. $safeParams = $params;
  3. unset($safeParams['password']);
  5. try {
  6. $pdo = $this->doConnect(
  7. $this->constructPdoDsn($safeParams),
  8. $params['user'] ?? '',
  9. $params['password'] ?? '',
  10. $driverOptions,
  11. );
in vendor/doctrine/dbal/src/Driver/Middleware/AbstractDriverMiddleware.php -> connect (line 27)
  1. */
  2. public function connect(
  3. #[SensitiveParameter]
  4. array $params,
  5. ): DriverConnection {
  6. return $this->wrappedDriver->connect($params);
  7. }
  9. public function getDatabasePlatform(ServerVersionProvider $versionProvider): AbstractPlatform
  10. {
  11. return $this->wrappedDriver->getDatabasePlatform($versionProvider);
in vendor/symfony/doctrine-bridge/Middleware/Debug/Driver.php -> connect (line 37)
  1. parent::__construct($driver);
  2. }
  4. public function connect(array $params): ConnectionInterface
  5. {
  6. $connection = parent::connect($params);
  8. if ('void' !== (string) (new \ReflectionMethod(ConnectionInterface::class, 'commit'))->getReturnType()) {
  9. return new DBAL3\Connection(
  10. $connection,
  11. $this->debugDataHolder,
in vendor/doctrine/dbal/src/Driver/Middleware/AbstractDriverMiddleware.php -> connect (line 27)
  1. */
  2. public function connect(
  3. #[SensitiveParameter]
  4. array $params,
  5. ): DriverConnection {
  6. return $this->wrappedDriver->connect($params);
  7. }
  9. public function getDatabasePlatform(ServerVersionProvider $versionProvider): AbstractPlatform
  10. {
  11. return $this->wrappedDriver->getDatabasePlatform($versionProvider);
in vendor/symfony/doctrine-bridge/Middleware/IdleConnection/Driver.php -> connect (line 35)
  1. }
  3. public function connect(array $params): ConnectionInterface
  4. {
  5. $timestamp = time();
  6. $connection = parent::connect($params);
  7. $this->connectionExpiries[$this->connectionName] = $timestamp + $this->ttl;
  9. return $connection;
  10. }
  11. }
in vendor/doctrine/dbal/src/Connection.php -> connect (line 222)
  1. if ($this->_conn !== null) {
  2. return $this->_conn;
  3. }
  5. try {
  6. $connection = $this->_conn = $this->driver->connect($this->params);
  7. } catch (Driver\Exception $e) {
  8. throw $this->convertException($e);
  9. }
  11. if ($this->autoCommit === false) {
in vendor/doctrine/dbal/src/Connection.php -> connect (line 792)
  1. ): Result {
  2. if ($qcp !== null) {
  3. return $this->executeCacheQuery($sql, $params, $types, $qcp);
  4. }
  6. $connection = $this->connect();
  8. try {
  9. if (count($params) > 0) {
  10. [$sql, $params, $types] = $this->expandArrayParameters($sql, $params, $types);
in vendor/doctrine/orm/src/Persisters/Entity/BasicEntityPersister.php -> executeQuery (line 963)
  1. ): array {
  2. $this->switchPersisterContext($offset, $limit);
  4. $sql = $this->getSelectSQL($criteria, null, null, $limit, $offset, $orderBy);
  5. [$params, $types] = $this->expandParameters($criteria);
  6. $stmt = $this->conn->executeQuery($sql, $params, $types);
  8. $hydrator = $this->em->newHydrator($this->currentPersisterContext->selectJoinSql ? Query::HYDRATE_OBJECT : Query::HYDRATE_SIMPLEOBJECT);
  10. return $hydrator->hydrateAll($stmt, $this->currentPersisterContext->rsm, [UnitOfWork::HINT_DEFEREAGERLOAD => true]);
  11. }
in vendor/doctrine/orm/src/EntityRepository.php -> loadAll (line 110)
  1. */
  2. public function findBy(array $criteria, array|null $orderBy = null, int|null $limit = null, int|null $offset = null): array
  3. {
  4. $persister = $this->em->getUnitOfWork()->getEntityPersister($this->entityName);
  6. return $persister->loadAll($criteria, $orderBy, $limit, $offset);
  7. }
  9. /**
  10. * Finds a single entity by a set of criteria.
  11. *
in vendor/doctrine/doctrine-bundle/src/Repository/ServiceEntityRepositoryProxy.php -> findBy (line 73)
  1. * @psalm-suppress InvalidReturnType This proxy is used only in combination with newer parent class
  2. */
  3. public function findBy(array $criteria, array|null $orderBy = null, int|null $limit = null, int|null $offset = null): array
  4. {
  5. return ($this->repository ??= $this->resolveRepository())
  6. ->findBy($criteria, $orderBy, $limit, $offset);
  7. }
  9. /** {@inheritDoc} */
  10. public function findOneBy(array $criteria, array|null $orderBy = null): object|null
  11. {
in vendor/doctrine/orm/src/EntityRepository.php -> findBy (line 96)
  1. *
  2. * @phpstan-return list<T> The entities.
  3. */
  4. public function findAll(): array
  5. {
  6. return $this->findBy([]);
  7. }
  9. /**
  10. * Finds entities by a set of criteria.
  11. *
EntityRepository->findAll() in src/Controller/TwigController.php (line 73)
  1. $selectedCategory = $request->query->get('category', '');
  2. $selectedBrand = $request->query->get('brand', '');
  3. $maxPrice = $request->query->get('max_price', '');
  5. // --- Récupération des catégories & marques de la BDD ---
  6. $categories = $categorieRepository->findAll();
  7. $marques = $marqueRepository->findAll();
  9. // --- Construction dynamique du filtre ---
  10. $criteria = [];
in vendor/symfony/http-kernel/HttpKernel.php -> products (line 183)
  1. $this->dispatcher->dispatch($event, KernelEvents::CONTROLLER_ARGUMENTS);
  2. $controller = $event->getController();
  3. $arguments = $event->getArguments();
  5. // call controller
  6. $response = $controller(...$arguments);
  8. // view
  9. if (!$response instanceof Response) {
  10. $event = new ViewEvent($this, $request, $type, $response, $event);
  11. $this->dispatcher->dispatch($event, KernelEvents::VIEW);
in vendor/symfony/http-kernel/HttpKernel.php -> handleRaw (line 76)
  1. $request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
  3. $this->requestStack->push($request);
  4. $response = null;
  5. try {
  6. return $response = $this->handleRaw($request, $type);
  7. } catch (\Throwable $e) {
  8. if ($e instanceof \Error && !$this->handleAllThrowables) {
  9. throw $e;
  10. }
in vendor/symfony/http-kernel/Kernel.php -> handle (line 182)
  1. $this->boot();
  2. ++$this->requestStackSize;
  3. $this->resetServices = true;
  5. try {
  6. return $this->getHttpKernel()->handle($request, $type, $catch);
  7. } finally {
  8. --$this->requestStackSize;
  9. }
  10. }
in vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php -> handle (line 35)
  1. ) {
  2. }
  4. public function run(): int
  5. {
  6. $response = $this->kernel->handle($this->request);
  8. if (Kernel::VERSION_ID >= 60400) {
  9. $response->send(false);
  11. if (\function_exists('fastcgi_finish_request') && !$this->debug) {
in vendor/autoload_runtime.php -> run (line 29)
  1. $app = $app(...$args);
  3. exit(
  4. $runtime
  5. ->getRunner($app)
  6. ->run()
  7. );
require_once('/home/lyceestvincent/www/jdenes/bts-2025-2026-symfony-coffeeshop-coffeeshop-julie/vendor/autoload_runtime.php') in public/index.php (line 5)
  1. <?php
  3. use App\Kernel;
  5. require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
  7. return function (array $context) {
  8. return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);
  10. };

Logs

Level Message
info 19:32:30 Matched route "_profiler". 
{
    "route": "_profiler",
    "route_parameters": {
        "_route": "_profiler",
        "_controller": "web_profiler.controller.profiler::panelAction",
        "token": "57fb04"
    },
    "request_uri": "https://jdenes.lyceestvincent.fr/bts-2025-2026-symfony-coffeeshop-coffeeshop-julie/public/_profiler/57fb04",
    "method": "GET"
}
debug 19:32:30 Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\DebugHandlersListener::configure"
}
debug 19:32:30 Notified event "kernel.request" to listener "Nelmio\SecurityBundle\EventListener\ContentSecurityPolicyListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Nelmio\\SecurityBundle\\EventListener\\ContentSecurityPolicyListener::onKernelRequest"
}
debug 19:32:30 Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\ValidateRequestListener::onKernelRequest"
}
debug 19:32:30 Notified event "kernel.request" to listener "Symfony\Bridge\Doctrine\Middleware\IdleConnection\Listener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Bridge\\Doctrine\\Middleware\\IdleConnection\\Listener::onKernelRequest"
}
debug 19:32:30 Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\SessionListener::onKernelRequest"
}
debug 19:32:30 Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::setDefaultLocale". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleListener::setDefaultLocale"
}
debug 19:32:30 Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\RouterListener::onKernelRequest"
}
debug 19:32:30 Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleListener::onKernelRequest"
}
debug 19:32:30 Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleAwareListener::onKernelRequest"
}
debug 19:32:30 Notified event "kernel.request" to listener "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::configureLogoutUrlGenerator". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Bundle\\SecurityBundle\\Debug\\TraceableFirewallListener::configureLogoutUrlGenerator"
}
debug 19:32:30 Notified event "kernel.request" to listener "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Bundle\\SecurityBundle\\Debug\\TraceableFirewallListener::onKernelRequest"
}
debug 19:32:30 Notified event "kernel.controller" to listener "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController". 
{
    "event": "kernel.controller",
    "listener": "Symfony\\Bundle\\FrameworkBundle\\DataCollector\\RouterDataCollector::onKernelController"
}
debug 19:32:30 Notified event "kernel.controller" to listener "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController". 
{
    "event": "kernel.controller",
    "listener": "Symfony\\Component\\HttpKernel\\DataCollector\\RequestDataCollector::onKernelController"
}
debug 19:32:30 Notified event "kernel.controller_arguments" to listener "Symfony\Component\Security\Http\EventListener\IsCsrfTokenValidAttributeListener::onKernelControllerArguments". 
{
    "event": "kernel.controller_arguments",
    "listener": "Symfony\\Component\\Security\\Http\\EventListener\\IsCsrfTokenValidAttributeListener::onKernelControllerArguments"
}
debug 19:32:30 Notified event "kernel.controller_arguments" to listener "Symfony\Component\Security\Http\EventListener\IsGrantedAttributeListener::onKernelControllerArguments". 
{
    "event": "kernel.controller_arguments",
    "listener": "Symfony\\Component\\Security\\Http\\EventListener\\IsGrantedAttributeListener::onKernelControllerArguments"
}
debug 19:32:30 Notified event "kernel.controller_arguments" to listener "Symfony\Component\HttpKernel\EventListener\CacheAttributeListener::onKernelControllerArguments". 
{
    "event": "kernel.controller_arguments",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\CacheAttributeListener::onKernelControllerArguments"
}
debug 19:32:30 Notified event "kernel.controller_arguments" to listener "Symfony\Component\HttpKernel\EventListener\ErrorListener::onControllerArguments". 
{
    "event": "kernel.controller_arguments",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\ErrorListener::onControllerArguments"
}

Stack Traces 3

[3/3] ConnectionException 
Doctrine\DBAL\Exception\ConnectionException:
An exception occurred in the driver: SQLSTATE[HY000] [2002] Connection refused

  at vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:91
  at Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter->convert(object(Exception), null)
     (vendor/doctrine/dbal/src/Connection.php:1456)
  at Doctrine\DBAL\Connection->handleDriverException(object(Exception), null)
     (vendor/doctrine/dbal/src/Connection.php:1398)
  at Doctrine\DBAL\Connection->convertException(object(Exception))
     (vendor/doctrine/dbal/src/Connection.php:224)
  at Doctrine\DBAL\Connection->connect()
     (vendor/doctrine/dbal/src/Connection.php:792)
  at Doctrine\DBAL\Connection->executeQuery('SELECT t0.id AS id_1, t0.nom AS nom_2 FROM categorie t0', array(), array())
     (vendor/doctrine/orm/src/Persisters/Entity/BasicEntityPersister.php:963)
  at Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll(array(), null, null, null)
     (vendor/doctrine/orm/src/EntityRepository.php:110)
  at Doctrine\ORM\EntityRepository->findBy(array(), null, null, null)
     (vendor/doctrine/doctrine-bundle/src/Repository/ServiceEntityRepositoryProxy.php:73)
  at Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy(array())
     (vendor/doctrine/orm/src/EntityRepository.php:96)
  at Doctrine\ORM\EntityRepository->findAll()
     (src/Controller/TwigController.php:73)
  at App\Controller\TwigController->products(object(Request), object(ProduitRepository), object(CategorieRepository), object(MarqueRepository))
     (vendor/symfony/http-kernel/HttpKernel.php:183)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw(object(Request), 1)
     (vendor/symfony/http-kernel/HttpKernel.php:76)
  at Symfony\Component\HttpKernel\HttpKernel->handle(object(Request), 1, true)
     (vendor/symfony/http-kernel/Kernel.php:182)
  at Symfony\Component\HttpKernel\Kernel->handle(object(Request))
     (vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:35)
  at Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run()
     (vendor/autoload_runtime.php:29)
  at require_once('/home/lyceestvincent/www/jdenes/bts-2025-2026-symfony-coffeeshop-coffeeshop-julie/vendor/autoload_runtime.php')
     (public/index.php:5)
[2/3] Exception 
Doctrine\DBAL\Driver\PDO\Exception:
SQLSTATE[HY000] [2002] Connection refused

  at vendor/doctrine/dbal/src/Driver/PDO/Exception.php:24
  at Doctrine\DBAL\Driver\PDO\Exception::new(object(PDOException))
     (vendor/doctrine/dbal/src/Driver/PDO/MySQL/Driver.php:52)
  at Doctrine\DBAL\Driver\PDO\MySQL\Driver->connect(object(SensitiveParameterValue))
     (vendor/doctrine/dbal/src/Driver/Middleware/AbstractDriverMiddleware.php:27)
  at Doctrine\DBAL\Driver\Middleware\AbstractDriverMiddleware->connect(object(SensitiveParameterValue))
     (vendor/symfony/doctrine-bridge/Middleware/Debug/Driver.php:37)
  at Symfony\Bridge\Doctrine\Middleware\Debug\Driver->connect(array('use_savepoints' => true, 'driver' => 'pdo_mysql', 'idle_connection_ttl' => 600, 'host' => '127.0.0.1', 'port' => 3306, 'user' => 'root', 'password' => '', 'driverOptions' => array(), 'defaultTableOptions' => array(), 'dbname' => 'artcraft', 'serverVersion' => 'mariadb-10.4.32', 'charset' => 'utf8mb4'))
     (vendor/doctrine/dbal/src/Driver/Middleware/AbstractDriverMiddleware.php:27)
  at Doctrine\DBAL\Driver\Middleware\AbstractDriverMiddleware->connect(object(SensitiveParameterValue))
     (vendor/symfony/doctrine-bridge/Middleware/IdleConnection/Driver.php:35)
  at Symfony\Bridge\Doctrine\Middleware\IdleConnection\Driver->connect(array('use_savepoints' => true, 'driver' => 'pdo_mysql', 'idle_connection_ttl' => 600, 'host' => '127.0.0.1', 'port' => 3306, 'user' => 'root', 'password' => '', 'driverOptions' => array(), 'defaultTableOptions' => array(), 'dbname' => 'artcraft', 'serverVersion' => 'mariadb-10.4.32', 'charset' => 'utf8mb4'))
     (vendor/doctrine/dbal/src/Connection.php:222)
  at Doctrine\DBAL\Connection->connect()
     (vendor/doctrine/dbal/src/Connection.php:792)
  at Doctrine\DBAL\Connection->executeQuery('SELECT t0.id AS id_1, t0.nom AS nom_2 FROM categorie t0', array(), array())
     (vendor/doctrine/orm/src/Persisters/Entity/BasicEntityPersister.php:963)
  at Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll(array(), null, null, null)
     (vendor/doctrine/orm/src/EntityRepository.php:110)
  at Doctrine\ORM\EntityRepository->findBy(array(), null, null, null)
     (vendor/doctrine/doctrine-bundle/src/Repository/ServiceEntityRepositoryProxy.php:73)
  at Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy(array())
     (vendor/doctrine/orm/src/EntityRepository.php:96)
  at Doctrine\ORM\EntityRepository->findAll()
     (src/Controller/TwigController.php:73)
  at App\Controller\TwigController->products(object(Request), object(ProduitRepository), object(CategorieRepository), object(MarqueRepository))
     (vendor/symfony/http-kernel/HttpKernel.php:183)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw(object(Request), 1)
     (vendor/symfony/http-kernel/HttpKernel.php:76)
  at Symfony\Component\HttpKernel\HttpKernel->handle(object(Request), 1, true)
     (vendor/symfony/http-kernel/Kernel.php:182)
  at Symfony\Component\HttpKernel\Kernel->handle(object(Request))
     (vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:35)
  at Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run()
     (vendor/autoload_runtime.php:29)
  at require_once('/home/lyceestvincent/www/jdenes/bts-2025-2026-symfony-coffeeshop-coffeeshop-julie/vendor/autoload_runtime.php')
     (public/index.php:5)
[1/3] PDOException 
PDOException:
SQLSTATE[HY000] [2002] Connection refused

  at vendor/doctrine/dbal/src/Driver/PDO/PDOConnect.php:25
  at PDO->__construct('mysql:host=127.0.0.1;port=3306;dbname=artcraft;charset=utf8mb4;', 'root', object(SensitiveParameterValue), array())
     (vendor/doctrine/dbal/src/Driver/PDO/PDOConnect.php:25)
  at Doctrine\DBAL\Driver\PDO\MySQL\Driver->doConnect(object(SensitiveParameterValue), 'root', object(SensitiveParameterValue), array())
     (vendor/doctrine/dbal/src/Driver/PDO/MySQL/Driver.php:45)
  at Doctrine\DBAL\Driver\PDO\MySQL\Driver->connect(object(SensitiveParameterValue))
     (vendor/doctrine/dbal/src/Driver/Middleware/AbstractDriverMiddleware.php:27)
  at Doctrine\DBAL\Driver\Middleware\AbstractDriverMiddleware->connect(object(SensitiveParameterValue))
     (vendor/symfony/doctrine-bridge/Middleware/Debug/Driver.php:37)
  at Symfony\Bridge\Doctrine\Middleware\Debug\Driver->connect(array('use_savepoints' => true, 'driver' => 'pdo_mysql', 'idle_connection_ttl' => 600, 'host' => '127.0.0.1', 'port' => 3306, 'user' => 'root', 'password' => '', 'driverOptions' => array(), 'defaultTableOptions' => array(), 'dbname' => 'artcraft', 'serverVersion' => 'mariadb-10.4.32', 'charset' => 'utf8mb4'))
     (vendor/doctrine/dbal/src/Driver/Middleware/AbstractDriverMiddleware.php:27)
  at Doctrine\DBAL\Driver\Middleware\AbstractDriverMiddleware->connect(object(SensitiveParameterValue))
     (vendor/symfony/doctrine-bridge/Middleware/IdleConnection/Driver.php:35)
  at Symfony\Bridge\Doctrine\Middleware\IdleConnection\Driver->connect(array('use_savepoints' => true, 'driver' => 'pdo_mysql', 'idle_connection_ttl' => 600, 'host' => '127.0.0.1', 'port' => 3306, 'user' => 'root', 'password' => '', 'driverOptions' => array(), 'defaultTableOptions' => array(), 'dbname' => 'artcraft', 'serverVersion' => 'mariadb-10.4.32', 'charset' => 'utf8mb4'))
     (vendor/doctrine/dbal/src/Connection.php:222)
  at Doctrine\DBAL\Connection->connect()
     (vendor/doctrine/dbal/src/Connection.php:792)
  at Doctrine\DBAL\Connection->executeQuery('SELECT t0.id AS id_1, t0.nom AS nom_2 FROM categorie t0', array(), array())
     (vendor/doctrine/orm/src/Persisters/Entity/BasicEntityPersister.php:963)
  at Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll(array(), null, null, null)
     (vendor/doctrine/orm/src/EntityRepository.php:110)
  at Doctrine\ORM\EntityRepository->findBy(array(), null, null, null)
     (vendor/doctrine/doctrine-bundle/src/Repository/ServiceEntityRepositoryProxy.php:73)
  at Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy(array())
     (vendor/doctrine/orm/src/EntityRepository.php:96)
  at Doctrine\ORM\EntityRepository->findAll()
     (src/Controller/TwigController.php:73)
  at App\Controller\TwigController->products(object(Request), object(ProduitRepository), object(CategorieRepository), object(MarqueRepository))
     (vendor/symfony/http-kernel/HttpKernel.php:183)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw(object(Request), 1)
     (vendor/symfony/http-kernel/HttpKernel.php:76)
  at Symfony\Component\HttpKernel\HttpKernel->handle(object(Request), 1, true)
     (vendor/symfony/http-kernel/Kernel.php:182)
  at Symfony\Component\HttpKernel\Kernel->handle(object(Request))
     (vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:35)
  at Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run()
     (vendor/autoload_runtime.php:29)
  at require_once('/home/lyceestvincent/www/jdenes/bts-2025-2026-symfony-coffeeshop-coffeeshop-julie/vendor/autoload_runtime.php')
     (public/index.php:5)