https://annuairesdz.com/search?page=4079&page%3D306=

Exceptions

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

Exceptions 3

Doctrine\DBAL\Exception\ ConnectionException

  1.             case 1370:
  2.             case 1429:
  3.             case 2002:
  4.             case 2005:
  5.             case 2054:
  6.                 return new ConnectionException($exception$query);
  7.             case 2006:
  8.                 return new ConnectionLost($exception$query);
  9.             case 1048:
  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);
  7.         if ($exception instanceof ConnectionLost) {
  8.             $this->close();
  9.         }
in vendor/doctrine/dbal/src/Connection.php -> handleDriverException (line 1891)
  1.     }
  2.     /** @internal */
  3.     final public function convertException(Driver\Exception $e): DriverException
  4.     {
  5.         return $this->handleDriverException($enull);
  6.     }
  7.     /**
  8.      * @param array<int, mixed>|array<string, mixed>                               $params
  9.      * @param array<int, int|string|Type|null>|array<string, int|string|Type|null> $types
in vendor/doctrine/dbal/src/Connection.php -> convertException (line 380)
  1.         }
  2.         try {
  3.             $this->_conn $this->_driver->connect($this->params);
  4.         } catch (Driver\Exception $e) {
  5.             throw $this->convertException($e);
  6.         }
  7.         if ($this->autoCommit === false) {
  8.             $this->beginTransaction();
  9.         }
  1.             'https://github.com/doctrine/dbal/issues/4966',
  2.             'Connection::getWrappedConnection() is deprecated.'
  3.                 ' Use Connection::getNativeConnection() to access the native connection.',
  4.         );
  5.         $this->connect();
  6.         return $this->_conn;
  7.     }
  8.     /** @return resource|object */
in vendor/doctrine/dbal/src/Connection.php -> getWrappedConnection (line 1082)
  1.     ): Result {
  2.         if ($qcp !== null) {
  3.             return $this->executeCacheQuery($sql$params$types$qcp);
  4.         }
  5.         $connection $this->getWrappedConnection();
  6.         $logger $this->_config->getSQLLogger();
  7.         if ($logger !== null) {
  8.             $logger->startQuery($sql$params$types);
  9.         }
  1.     /**
  2.      * {@inheritDoc}
  3.      */
  4.     public function execute(Connection $conn, array $params, array $types): Result
  5.     {
  6.         return $conn->executeQuery($this->sqlStatements$params$types$this->queryCacheProfile);
  7.     }
  8. }
in vendor/doctrine/orm/src/Query.php -> execute (line 284)
  1.             $sqlParams,
  2.             $types,
  3.             $this->em->getConnection()->getParams(),
  4.         );
  5.         return $executor->execute($this->em->getConnection(), $sqlParams$types);
  6.     }
  7.     /**
  8.      * @param array<string,mixed> $sqlParams
  9.      * @param array<string,Type>  $types
  1.             $setCacheEntry = static function ($data) use ($cache$result$cacheItem$realCacheKey): void {
  2.                 $cache->save($cacheItem->set($result + [$realCacheKey => $data]));
  3.             };
  4.         }
  5.         $stmt $this->_doExecute();
  6.         if (is_numeric($stmt)) {
  7.             $setCacheEntry($stmt);
  8.             return $stmt;
in vendor/doctrine/orm/src/AbstractQuery.php -> executeIgnoreQueryCache (line 891)
  1.     ): mixed {
  2.         if ($this->cacheable && $this->isCacheEnabled()) {
  3.             return $this->executeUsingQueryCache($parameters$hydrationMode);
  4.         }
  5.         return $this->executeIgnoreQueryCache($parameters$hydrationMode);
  6.     }
  7.     /**
  8.      * Execute query ignoring second level cache.
  9.      *
  1.      *
  2.      * @return mixed[]
  3.      */
  4.     public function getScalarResult(): array
  5.     {
  6.         return $this->execute(nullself::HYDRATE_SCALAR);
  7.     }
  8.     /**
  9.      * Get exactly one result or null.
  10.      *
  1.     public function count(): int
  2.     {
  3.         if ($this->count === null) {
  4.             try {
  5.                 $this->count = (int) array_sum(array_map('current'$this->getCountQuery()->getScalarResult()));
  6.             } catch (NoResultException) {
  7.                 $this->count 0;
  8.             }
  9.         }
Paginator->count()
  1.         $paginator = new Paginator($event->target$fetchJoinCollection);
  2.         $paginator->setUseOutputWalkers($useOutputWalkers);
  3.         if (($count $event->target->getHint(self::HINT_COUNT)) !== false) {
  4.             $event->count = (int) $count;
  5.         } else {
  6.             $event->count count($paginator);
  7.         }
  8.         $event->items iterator_to_array($paginator);
  9.     }
  10.     public static function getSubscribedEvents(): array
  1.         $this->called true;
  2.         $this->priority ??= $dispatcher->getListenerPriority($eventName$this->listener);
  3.         $e $this->stopwatch->start($this->name'event_listener');
  4.         ($this->optimizedListener ?? $this->listener)($event$eventName$dispatcher);
  5.         if ($e->isStarted()) {
  6.             $e->stop();
  7.         }
  1.         foreach ($listeners as $listener) {
  2.             if ($stoppable && $event->isPropagationStopped()) {
  3.                 break;
  4.             }
  5.             $listener($event$eventName$this);
  6.         }
  7.     }
  8.     /**
  9.      * Sorts the internal list of listeners for the given event by priority.
  1.         } else {
  2.             $listeners $this->getListeners($eventName);
  3.         }
  4.         if ($listeners) {
  5.             $this->callListeners($listeners$eventName$event);
  6.         }
  7.         return $event;
  8.     }
  1.         try {
  2.             $this->beforeDispatch($eventName$event);
  3.             try {
  4.                 $e $this->stopwatch->start($eventName'section');
  5.                 try {
  6.                     $this->dispatcher->dispatch($event$eventName);
  7.                 } finally {
  8.                     if ($e->isStarted()) {
  9.                         $e->stop();
  10.                     }
  11.                 }
  1.         $this->eventDispatcher->dispatch($beforeEvent'knp_pager.before');
  2.         // items
  3.         $itemsEvent = new Event\ItemsEvent($offset$limit);
  4.         $itemsEvent->options = &$options;
  5.         $itemsEvent->target = &$target;
  6.         $this->eventDispatcher->dispatch($itemsEvent'knp_pager.items');
  7.         if (!$itemsEvent->isPropagationStopped()) {
  8.             throw new \RuntimeException('One of listeners must count and slice given target');
  9.         }
  10.         if ($page ceil($itemsEvent->count $limit)) {
  11.             $pageOutOfRangeOption $options[PaginatorInterface::PAGE_OUT_OF_RANGE] ?? $this->defaultOptions[PaginatorInterface::PAGE_OUT_OF_RANGE];
Paginator->paginate(object(Query), 4079, 21) in src/Controller/SearchController.php (line 48)
  1.           
  2.           
  3.   //$repository = $this->getDoctrine()->getRepository(BusinessInformation::class);
  4. $business=$paginator->paginate($repository->findAllVisibleQuery($search),
  5.          $request->query->getInt('page'1),
  6.          21);
  7.              return $this->render('search/index.html.twig', [
  8.           "keyword" => $keyword,
  9.             "place" => $place,
  10.             "business"=>$business
  1.         $this->dispatcher->dispatch($eventKernelEvents::CONTROLLER_ARGUMENTS);
  2.         $controller $event->getController();
  3.         $arguments $event->getArguments();
  4.         // call controller
  5.         $response $controller(...$arguments);
  6.         // view
  7.         if (!$response instanceof Response) {
  8.             $event = new ViewEvent($this$request$type$response);
  9.             $this->dispatcher->dispatch($eventKernelEvents::VIEW);
  1.     {
  2.         $request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
  3.         $this->requestStack->push($request);
  4.         try {
  5.             return $this->handleRaw($request$type);
  6.         } catch (\Exception $e) {
  7.             if ($e instanceof RequestExceptionInterface) {
  8.                 $e = new BadRequestHttpException($e->getMessage(), $e);
  9.             }
  10.             if (false === $catch) {
  1.         $this->boot();
  2.         ++$this->requestStackSize;
  3.         $this->resetServices true;
  4.         try {
  5.             return $this->getHttpKernel()->handle($request$type$catch);
  6.         } finally {
  7.             --$this->requestStackSize;
  8.         }
  9.     }
  1.         $this->request $request;
  2.     }
  3.     public function run(): int
  4.     {
  5.         $response $this->kernel->handle($this->request);
  6.         $response->send();
  7.         if ($this->kernel instanceof TerminableInterface) {
  8.             $this->kernel->terminate($this->request$response);
  9.         }
in vendor/autoload_runtime.php -> run (line 29)
  1. $app $app(...$args);
  2. exit(
  3.     $runtime
  4.         ->getRunner($app)
  5.         ->run()
  6. );
require_once('/home/annuairepn/www/aea/vendor/autoload_runtime.php') in public/index.php (line 5)
  1. <?php
  2. use App\Kernel;
  3. require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
  4. return function (array $context) {
  5.     return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);
  6. };

Doctrine\DBAL\Driver\PDO\ Exception

SQLSTATE[HY000] [2002] Connection refused

  1.         } else {
  2.             $code     $exception->getCode();
  3.             $sqlState null;
  4.         }
  5.         return new self($exception->getMessage(), $sqlState$code$exception);
  6.     }
  7. }
  1.                 $params['user'] ?? '',
  2.                 $params['password'] ?? '',
  3.                 $driverOptions,
  4.             );
  5.         } catch (PDOException $exception) {
  6.             throw Exception::new($exception);
  7.         }
  8.         return new Connection($pdo);
  9.     }
  1.      */
  2.     public function connect(
  3.         #[SensitiveParameter]
  4.         array $params
  5.     ) {
  6.         return $this->wrappedDriver->connect($params);
  7.     }
  8.     /**
  9.      * {@inheritDoc}
  10.      */
  1.         array $params
  2.     ) {
  3.         $this->logger->info('Connecting with parameters {params}', ['params' => $this->maskPassword($params)]);
  4.         return new Connection(
  5.             parent::connect($params),
  6.             $this->logger,
  7.         );
  8.     }
  9.     /**
  1.      */
  2.     public function connect(
  3.         #[SensitiveParameter]
  4.         array $params
  5.     ) {
  6.         return $this->wrappedDriver->connect($params);
  7.     }
  8.     /**
  9.      * {@inheritDoc}
  10.      */
  1.     }
  2.     public function connect(array $params): Connection
  3.     {
  4.         return new Connection(
  5.             parent::connect($params),
  6.             $this->debugDataHolder,
  7.             $this->stopwatch,
  8.             $this->connectionName,
  9.         );
  10.     }
  1.         if ($this->_conn !== null) {
  2.             return false;
  3.         }
  4.         try {
  5.             $this->_conn $this->_driver->connect($this->params);
  6.         } catch (Driver\Exception $e) {
  7.             throw $this->convertException($e);
  8.         }
  9.         if ($this->autoCommit === false) {
  1.             'https://github.com/doctrine/dbal/issues/4966',
  2.             'Connection::getWrappedConnection() is deprecated.'
  3.                 ' Use Connection::getNativeConnection() to access the native connection.',
  4.         );
  5.         $this->connect();
  6.         return $this->_conn;
  7.     }
  8.     /** @return resource|object */
in vendor/doctrine/dbal/src/Connection.php -> getWrappedConnection (line 1082)
  1.     ): Result {
  2.         if ($qcp !== null) {
  3.             return $this->executeCacheQuery($sql$params$types$qcp);
  4.         }
  5.         $connection $this->getWrappedConnection();
  6.         $logger $this->_config->getSQLLogger();
  7.         if ($logger !== null) {
  8.             $logger->startQuery($sql$params$types);
  9.         }
  1.     /**
  2.      * {@inheritDoc}
  3.      */
  4.     public function execute(Connection $conn, array $params, array $types): Result
  5.     {
  6.         return $conn->executeQuery($this->sqlStatements$params$types$this->queryCacheProfile);
  7.     }
  8. }
in vendor/doctrine/orm/src/Query.php -> execute (line 284)
  1.             $sqlParams,
  2.             $types,
  3.             $this->em->getConnection()->getParams(),
  4.         );
  5.         return $executor->execute($this->em->getConnection(), $sqlParams$types);
  6.     }
  7.     /**
  8.      * @param array<string,mixed> $sqlParams
  9.      * @param array<string,Type>  $types
  1.             $setCacheEntry = static function ($data) use ($cache$result$cacheItem$realCacheKey): void {
  2.                 $cache->save($cacheItem->set($result + [$realCacheKey => $data]));
  3.             };
  4.         }
  5.         $stmt $this->_doExecute();
  6.         if (is_numeric($stmt)) {
  7.             $setCacheEntry($stmt);
  8.             return $stmt;
in vendor/doctrine/orm/src/AbstractQuery.php -> executeIgnoreQueryCache (line 891)
  1.     ): mixed {
  2.         if ($this->cacheable && $this->isCacheEnabled()) {
  3.             return $this->executeUsingQueryCache($parameters$hydrationMode);
  4.         }
  5.         return $this->executeIgnoreQueryCache($parameters$hydrationMode);
  6.     }
  7.     /**
  8.      * Execute query ignoring second level cache.
  9.      *
  1.      *
  2.      * @return mixed[]
  3.      */
  4.     public function getScalarResult(): array
  5.     {
  6.         return $this->execute(nullself::HYDRATE_SCALAR);
  7.     }
  8.     /**
  9.      * Get exactly one result or null.
  10.      *
  1.     public function count(): int
  2.     {
  3.         if ($this->count === null) {
  4.             try {
  5.                 $this->count = (int) array_sum(array_map('current'$this->getCountQuery()->getScalarResult()));
  6.             } catch (NoResultException) {
  7.                 $this->count 0;
  8.             }
  9.         }
Paginator->count()
  1.         $paginator = new Paginator($event->target$fetchJoinCollection);
  2.         $paginator->setUseOutputWalkers($useOutputWalkers);
  3.         if (($count $event->target->getHint(self::HINT_COUNT)) !== false) {
  4.             $event->count = (int) $count;
  5.         } else {
  6.             $event->count count($paginator);
  7.         }
  8.         $event->items iterator_to_array($paginator);
  9.     }
  10.     public static function getSubscribedEvents(): array
  1.         $this->called true;
  2.         $this->priority ??= $dispatcher->getListenerPriority($eventName$this->listener);
  3.         $e $this->stopwatch->start($this->name'event_listener');
  4.         ($this->optimizedListener ?? $this->listener)($event$eventName$dispatcher);
  5.         if ($e->isStarted()) {
  6.             $e->stop();
  7.         }
  1.         foreach ($listeners as $listener) {
  2.             if ($stoppable && $event->isPropagationStopped()) {
  3.                 break;
  4.             }
  5.             $listener($event$eventName$this);
  6.         }
  7.     }
  8.     /**
  9.      * Sorts the internal list of listeners for the given event by priority.
  1.         } else {
  2.             $listeners $this->getListeners($eventName);
  3.         }
  4.         if ($listeners) {
  5.             $this->callListeners($listeners$eventName$event);
  6.         }
  7.         return $event;
  8.     }
  1.         try {
  2.             $this->beforeDispatch($eventName$event);
  3.             try {
  4.                 $e $this->stopwatch->start($eventName'section');
  5.                 try {
  6.                     $this->dispatcher->dispatch($event$eventName);
  7.                 } finally {
  8.                     if ($e->isStarted()) {
  9.                         $e->stop();
  10.                     }
  11.                 }
  1.         $this->eventDispatcher->dispatch($beforeEvent'knp_pager.before');
  2.         // items
  3.         $itemsEvent = new Event\ItemsEvent($offset$limit);
  4.         $itemsEvent->options = &$options;
  5.         $itemsEvent->target = &$target;
  6.         $this->eventDispatcher->dispatch($itemsEvent'knp_pager.items');
  7.         if (!$itemsEvent->isPropagationStopped()) {
  8.             throw new \RuntimeException('One of listeners must count and slice given target');
  9.         }
  10.         if ($page ceil($itemsEvent->count $limit)) {
  11.             $pageOutOfRangeOption $options[PaginatorInterface::PAGE_OUT_OF_RANGE] ?? $this->defaultOptions[PaginatorInterface::PAGE_OUT_OF_RANGE];
Paginator->paginate(object(Query), 4079, 21) in src/Controller/SearchController.php (line 48)
  1.           
  2.           
  3.   //$repository = $this->getDoctrine()->getRepository(BusinessInformation::class);
  4. $business=$paginator->paginate($repository->findAllVisibleQuery($search),
  5.          $request->query->getInt('page'1),
  6.          21);
  7.              return $this->render('search/index.html.twig', [
  8.           "keyword" => $keyword,
  9.             "place" => $place,
  10.             "business"=>$business
  1.         $this->dispatcher->dispatch($eventKernelEvents::CONTROLLER_ARGUMENTS);
  2.         $controller $event->getController();
  3.         $arguments $event->getArguments();
  4.         // call controller
  5.         $response $controller(...$arguments);
  6.         // view
  7.         if (!$response instanceof Response) {
  8.             $event = new ViewEvent($this$request$type$response);
  9.             $this->dispatcher->dispatch($eventKernelEvents::VIEW);
  1.     {
  2.         $request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
  3.         $this->requestStack->push($request);
  4.         try {
  5.             return $this->handleRaw($request$type);
  6.         } catch (\Exception $e) {
  7.             if ($e instanceof RequestExceptionInterface) {
  8.                 $e = new BadRequestHttpException($e->getMessage(), $e);
  9.             }
  10.             if (false === $catch) {
  1.         $this->boot();
  2.         ++$this->requestStackSize;
  3.         $this->resetServices true;
  4.         try {
  5.             return $this->getHttpKernel()->handle($request$type$catch);
  6.         } finally {
  7.             --$this->requestStackSize;
  8.         }
  9.     }
  1.         $this->request $request;
  2.     }
  3.     public function run(): int
  4.     {
  5.         $response $this->kernel->handle($this->request);
  6.         $response->send();
  7.         if ($this->kernel instanceof TerminableInterface) {
  8.             $this->kernel->terminate($this->request$response);
  9.         }
in vendor/autoload_runtime.php -> run (line 29)
  1. $app $app(...$args);
  2. exit(
  3.     $runtime
  4.         ->getRunner($app)
  5.         ->run()
  6. );
require_once('/home/annuairepn/www/aea/vendor/autoload_runtime.php') in public/index.php (line 5)
  1. <?php
  2. use App\Kernel;
  3. require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
  4. return function (array $context) {
  5.     return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);
  6. };

PDOException

SQLSTATE[HY000] [2002] Connection refused

  1.         $safeParams $params;
  2.         unset($safeParams['password'], $safeParams['url']);
  3.         try {
  4.             $pdo = new PDO(
  5.                 $this->constructPdoDsn($safeParams),
  6.                 $params['user'] ?? '',
  7.                 $params['password'] ?? '',
  8.                 $driverOptions,
  9.             );
  10.         } catch (PDOException $exception) {
  1.         $safeParams $params;
  2.         unset($safeParams['password'], $safeParams['url']);
  3.         try {
  4.             $pdo = new PDO(
  5.                 $this->constructPdoDsn($safeParams),
  6.                 $params['user'] ?? '',
  7.                 $params['password'] ?? '',
  8.                 $driverOptions,
  9.             );
  10.         } catch (PDOException $exception) {
  1.      */
  2.     public function connect(
  3.         #[SensitiveParameter]
  4.         array $params
  5.     ) {
  6.         return $this->wrappedDriver->connect($params);
  7.     }
  8.     /**
  9.      * {@inheritDoc}
  10.      */
  1.         array $params
  2.     ) {
  3.         $this->logger->info('Connecting with parameters {params}', ['params' => $this->maskPassword($params)]);
  4.         return new Connection(
  5.             parent::connect($params),
  6.             $this->logger,
  7.         );
  8.     }
  9.     /**
  1.      */
  2.     public function connect(
  3.         #[SensitiveParameter]
  4.         array $params
  5.     ) {
  6.         return $this->wrappedDriver->connect($params);
  7.     }
  8.     /**
  9.      * {@inheritDoc}
  10.      */
  1.     }
  2.     public function connect(array $params): Connection
  3.     {
  4.         return new Connection(
  5.             parent::connect($params),
  6.             $this->debugDataHolder,
  7.             $this->stopwatch,
  8.             $this->connectionName,
  9.         );
  10.     }
  1.         if ($this->_conn !== null) {
  2.             return false;
  3.         }
  4.         try {
  5.             $this->_conn $this->_driver->connect($this->params);
  6.         } catch (Driver\Exception $e) {
  7.             throw $this->convertException($e);
  8.         }
  9.         if ($this->autoCommit === false) {
  1.             'https://github.com/doctrine/dbal/issues/4966',
  2.             'Connection::getWrappedConnection() is deprecated.'
  3.                 ' Use Connection::getNativeConnection() to access the native connection.',
  4.         );
  5.         $this->connect();
  6.         return $this->_conn;
  7.     }
  8.     /** @return resource|object */
in vendor/doctrine/dbal/src/Connection.php -> getWrappedConnection (line 1082)
  1.     ): Result {
  2.         if ($qcp !== null) {
  3.             return $this->executeCacheQuery($sql$params$types$qcp);
  4.         }
  5.         $connection $this->getWrappedConnection();
  6.         $logger $this->_config->getSQLLogger();
  7.         if ($logger !== null) {
  8.             $logger->startQuery($sql$params$types);
  9.         }
  1.     /**
  2.      * {@inheritDoc}
  3.      */
  4.     public function execute(Connection $conn, array $params, array $types): Result
  5.     {
  6.         return $conn->executeQuery($this->sqlStatements$params$types$this->queryCacheProfile);
  7.     }
  8. }
in vendor/doctrine/orm/src/Query.php -> execute (line 284)
  1.             $sqlParams,
  2.             $types,
  3.             $this->em->getConnection()->getParams(),
  4.         );
  5.         return $executor->execute($this->em->getConnection(), $sqlParams$types);
  6.     }
  7.     /**
  8.      * @param array<string,mixed> $sqlParams
  9.      * @param array<string,Type>  $types
  1.             $setCacheEntry = static function ($data) use ($cache$result$cacheItem$realCacheKey): void {
  2.                 $cache->save($cacheItem->set($result + [$realCacheKey => $data]));
  3.             };
  4.         }
  5.         $stmt $this->_doExecute();
  6.         if (is_numeric($stmt)) {
  7.             $setCacheEntry($stmt);
  8.             return $stmt;
in vendor/doctrine/orm/src/AbstractQuery.php -> executeIgnoreQueryCache (line 891)
  1.     ): mixed {
  2.         if ($this->cacheable && $this->isCacheEnabled()) {
  3.             return $this->executeUsingQueryCache($parameters$hydrationMode);
  4.         }
  5.         return $this->executeIgnoreQueryCache($parameters$hydrationMode);
  6.     }
  7.     /**
  8.      * Execute query ignoring second level cache.
  9.      *
  1.      *
  2.      * @return mixed[]
  3.      */
  4.     public function getScalarResult(): array
  5.     {
  6.         return $this->execute(nullself::HYDRATE_SCALAR);
  7.     }
  8.     /**
  9.      * Get exactly one result or null.
  10.      *
  1.     public function count(): int
  2.     {
  3.         if ($this->count === null) {
  4.             try {
  5.                 $this->count = (int) array_sum(array_map('current'$this->getCountQuery()->getScalarResult()));
  6.             } catch (NoResultException) {
  7.                 $this->count 0;
  8.             }
  9.         }
Paginator->count()
  1.         $paginator = new Paginator($event->target$fetchJoinCollection);
  2.         $paginator->setUseOutputWalkers($useOutputWalkers);
  3.         if (($count $event->target->getHint(self::HINT_COUNT)) !== false) {
  4.             $event->count = (int) $count;
  5.         } else {
  6.             $event->count count($paginator);
  7.         }
  8.         $event->items iterator_to_array($paginator);
  9.     }
  10.     public static function getSubscribedEvents(): array
  1.         $this->called true;
  2.         $this->priority ??= $dispatcher->getListenerPriority($eventName$this->listener);
  3.         $e $this->stopwatch->start($this->name'event_listener');
  4.         ($this->optimizedListener ?? $this->listener)($event$eventName$dispatcher);
  5.         if ($e->isStarted()) {
  6.             $e->stop();
  7.         }
  1.         foreach ($listeners as $listener) {
  2.             if ($stoppable && $event->isPropagationStopped()) {
  3.                 break;
  4.             }
  5.             $listener($event$eventName$this);
  6.         }
  7.     }
  8.     /**
  9.      * Sorts the internal list of listeners for the given event by priority.
  1.         } else {
  2.             $listeners $this->getListeners($eventName);
  3.         }
  4.         if ($listeners) {
  5.             $this->callListeners($listeners$eventName$event);
  6.         }
  7.         return $event;
  8.     }
  1.         try {
  2.             $this->beforeDispatch($eventName$event);
  3.             try {
  4.                 $e $this->stopwatch->start($eventName'section');
  5.                 try {
  6.                     $this->dispatcher->dispatch($event$eventName);
  7.                 } finally {
  8.                     if ($e->isStarted()) {
  9.                         $e->stop();
  10.                     }
  11.                 }
  1.         $this->eventDispatcher->dispatch($beforeEvent'knp_pager.before');
  2.         // items
  3.         $itemsEvent = new Event\ItemsEvent($offset$limit);
  4.         $itemsEvent->options = &$options;
  5.         $itemsEvent->target = &$target;
  6.         $this->eventDispatcher->dispatch($itemsEvent'knp_pager.items');
  7.         if (!$itemsEvent->isPropagationStopped()) {
  8.             throw new \RuntimeException('One of listeners must count and slice given target');
  9.         }
  10.         if ($page ceil($itemsEvent->count $limit)) {
  11.             $pageOutOfRangeOption $options[PaginatorInterface::PAGE_OUT_OF_RANGE] ?? $this->defaultOptions[PaginatorInterface::PAGE_OUT_OF_RANGE];
Paginator->paginate(object(Query), 4079, 21) in src/Controller/SearchController.php (line 48)
  1.           
  2.           
  3.   //$repository = $this->getDoctrine()->getRepository(BusinessInformation::class);
  4. $business=$paginator->paginate($repository->findAllVisibleQuery($search),
  5.          $request->query->getInt('page'1),
  6.          21);
  7.              return $this->render('search/index.html.twig', [
  8.           "keyword" => $keyword,
  9.             "place" => $place,
  10.             "business"=>$business
  1.         $this->dispatcher->dispatch($eventKernelEvents::CONTROLLER_ARGUMENTS);
  2.         $controller $event->getController();
  3.         $arguments $event->getArguments();
  4.         // call controller
  5.         $response $controller(...$arguments);
  6.         // view
  7.         if (!$response instanceof Response) {
  8.             $event = new ViewEvent($this$request$type$response);
  9.             $this->dispatcher->dispatch($eventKernelEvents::VIEW);
  1.     {
  2.         $request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
  3.         $this->requestStack->push($request);
  4.         try {
  5.             return $this->handleRaw($request$type);
  6.         } catch (\Exception $e) {
  7.             if ($e instanceof RequestExceptionInterface) {
  8.                 $e = new BadRequestHttpException($e->getMessage(), $e);
  9.             }
  10.             if (false === $catch) {
  1.         $this->boot();
  2.         ++$this->requestStackSize;
  3.         $this->resetServices true;
  4.         try {
  5.             return $this->getHttpKernel()->handle($request$type$catch);
  6.         } finally {
  7.             --$this->requestStackSize;
  8.         }
  9.     }
  1.         $this->request $request;
  2.     }
  3.     public function run(): int
  4.     {
  5.         $response $this->kernel->handle($this->request);
  6.         $response->send();
  7.         if ($this->kernel instanceof TerminableInterface) {
  8.             $this->kernel->terminate($this->request$response);
  9.         }
in vendor/autoload_runtime.php -> run (line 29)
  1. $app $app(...$args);
  2. exit(
  3.     $runtime
  4.         ->getRunner($app)
  5.         ->run()
  6. );
require_once('/home/annuairepn/www/aea/vendor/autoload_runtime.php') in public/index.php (line 5)
  1. <?php
  2. use App\Kernel;
  3. require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
  4. return function (array $context) {
  5.     return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);
  6. };

Logs

Level Channel Message
DEBUG 00:19:08 php Warning: Zend OPcache API is restricted by "restrict_api" configuration directive
{
    "exception": {
        "severity": 2,
        "file": "/home/annuairepn/www/aea/vendor/symfony/error-handler/DebugClassLoader.php",
        "line": 290,
        "trace": [
            {
                "file": "/home/annuairepn/www/aea/vendor/symfony/stopwatch/StopwatchEvent.php",
                "line": 94,
                "function": "loadClass",
                "class": "Symfony\\Component\\ErrorHandler\\DebugClassLoader",
                "type": "->"
            }
        ],
        "count": 153
    }
}
INFO 00:19:08 request Matched route "_profiler".
{
    "route": "_profiler",
    "route_parameters": {
        "_route": "_profiler",
        "_controller": "web_profiler.controller.profiler::panelAction",
        "token": "latest"
    },
    "request_uri": "https://annuairesdz.com/_profiler/latest?ip=54.87.62.248",
    "method": "GET"
}
DEBUG 00:19:08 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure".
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\DebugHandlersListener::configure"
}
DEBUG 00:19:08 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest".
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\ValidateRequestListener::onKernelRequest"
}
DEBUG 00:19:08 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest".
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\SessionListener::onKernelRequest"
}
DEBUG 00:19:08 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::setDefaultLocale".
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleListener::setDefaultLocale"
}
DEBUG 00:19:08 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest".
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\RouterListener::onKernelRequest"
}
DEBUG 00:19:08 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest".
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleListener::onKernelRequest"
}
DEBUG 00:19:08 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelRequest".
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleAwareListener::onKernelRequest"
}
DEBUG 00:19:08 event Notified event "kernel.request" to listener "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::configureLogoutUrlGenerator".
{
    "event": "kernel.request",
    "listener": "Symfony\\Bundle\\SecurityBundle\\Debug\\TraceableFirewallListener::configureLogoutUrlGenerator"
}
DEBUG 00:19:08 event Notified event "kernel.request" to listener "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelRequest".
{
    "event": "kernel.request",
    "listener": "Symfony\\Bundle\\SecurityBundle\\Debug\\TraceableFirewallListener::onKernelRequest"
}
DEBUG 00:19:08 event Notified event "kernel.request" to listener "Knp\Bundle\PaginatorBundle\Subscriber\SlidingPaginationSubscriber::onKernelRequest".
{
    "event": "kernel.request",
    "listener": "Knp\\Bundle\\PaginatorBundle\\Subscriber\\SlidingPaginationSubscriber::onKernelRequest"
}
DEBUG 00:19:08 event Notified event "kernel.request" to listener "EasyCorp\Bundle\EasyAdminBundle\EventListener\AdminRouterSubscriber::onKernelRequest".
{
    "event": "kernel.request",
    "listener": "EasyCorp\\Bundle\\EasyAdminBundle\\EventListener\\AdminRouterSubscriber::onKernelRequest"
}
DEBUG 00:19:08 php Warning: Zend OPcache API is restricted by "restrict_api" configuration directive
{
    "exception": {
        "severity": 2,
        "file": "/home/annuairepn/www/aea/vendor/symfony/error-handler/DebugClassLoader.php",
        "line": 290,
        "trace": [
            {
                "file": "/home/annuairepn/www/aea/vendor/symfony/stopwatch/StopwatchEvent.php",
                "line": 94,
                "function": "loadClass",
                "class": "Symfony\\Component\\ErrorHandler\\DebugClassLoader",
                "type": "->"
            }
        ],
        "count": 153
    }
}
DEBUG 00:19:08 event Notified event "kernel.controller" to listener "EasyCorp\Bundle\EasyAdminBundle\EventListener\AdminRouterSubscriber::onKernelController".
{
    "event": "kernel.controller",
    "listener": "EasyCorp\\Bundle\\EasyAdminBundle\\EventListener\\AdminRouterSubscriber::onKernelController"
}
DEBUG 00:19:08 event Notified event "kernel.controller" to listener "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController".
{
    "event": "kernel.controller",
    "listener": "Symfony\\Bundle\\FrameworkBundle\\DataCollector\\RouterDataCollector::onKernelController"
}
DEBUG 00:19:08 event Notified event "kernel.controller" to listener "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController".
{
    "event": "kernel.controller",
    "listener": "Symfony\\Component\\HttpKernel\\DataCollector\\RequestDataCollector::onKernelController"
}
DEBUG 00:19:08 event Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\ControllerListener::onKernelController".
{
    "event": "kernel.controller",
    "listener": "Sensio\\Bundle\\FrameworkExtraBundle\\EventListener\\ControllerListener::onKernelController"
}
DEBUG 00:19:08 event Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\ParamConverterListener::onKernelController".
{
    "event": "kernel.controller",
    "listener": "Sensio\\Bundle\\FrameworkExtraBundle\\EventListener\\ParamConverterListener::onKernelController"
}
DEBUG 00:19:08 event Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\HttpCacheListener::onKernelController".
{
    "event": "kernel.controller",
    "listener": "Sensio\\Bundle\\FrameworkExtraBundle\\EventListener\\HttpCacheListener::onKernelController"
}
DEBUG 00:19:08 event Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\TemplateListener::onKernelController".
{
    "event": "kernel.controller",
    "listener": "Sensio\\Bundle\\FrameworkExtraBundle\\EventListener\\TemplateListener::onKernelController"
}
DEBUG 00:19:08 event Notified event "kernel.controller_arguments" to listener "Symfony\Component\HttpKernel\EventListener\ErrorListener::onControllerArguments".
{
    "event": "kernel.controller_arguments",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\ErrorListener::onControllerArguments"
}
DEBUG 00:19:08 event Notified event "kernel.controller_arguments" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\SecurityListener::onKernelControllerArguments".
{
    "event": "kernel.controller_arguments",
    "listener": "Sensio\\Bundle\\FrameworkExtraBundle\\EventListener\\SecurityListener::onKernelControllerArguments"
}
DEBUG 00:19:08 event Notified event "kernel.controller_arguments" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\IsGrantedListener::onKernelControllerArguments".
{
    "event": "kernel.controller_arguments",
    "listener": "Sensio\\Bundle\\FrameworkExtraBundle\\EventListener\\IsGrantedListener::onKernelControllerArguments"
}
DEBUG 00:19:08 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure".
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\DebugHandlersListener::configure"
}
DEBUG 00:19:08 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest".
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\ValidateRequestListener::onKernelRequest"
}
DEBUG 00:19:08 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest".
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\SessionListener::onKernelRequest"
}
DEBUG 00:19:08 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::setDefaultLocale".
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleListener::setDefaultLocale"
}
DEBUG 00:19:08 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest".
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\RouterListener::onKernelRequest"
}
DEBUG 00:19:08 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest".
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleListener::onKernelRequest"
}
DEBUG 00:19:08 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelRequest".
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleAwareListener::onKernelRequest"
}
DEBUG 00:19:08 event Notified event "kernel.request" to listener "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::configureLogoutUrlGenerator".
{
    "event": "kernel.request",
    "listener": "Symfony\\Bundle\\SecurityBundle\\Debug\\TraceableFirewallListener::configureLogoutUrlGenerator"
}
DEBUG 00:19:08 event Notified event "kernel.request" to listener "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelRequest".
{
    "event": "kernel.request",
    "listener": "Symfony\\Bundle\\SecurityBundle\\Debug\\TraceableFirewallListener::onKernelRequest"
}
DEBUG 00:19:08 event Notified event "kernel.request" to listener "Knp\Bundle\PaginatorBundle\Subscriber\SlidingPaginationSubscriber::onKernelRequest".
{
    "event": "kernel.request",
    "listener": "Knp\\Bundle\\PaginatorBundle\\Subscriber\\SlidingPaginationSubscriber::onKernelRequest"
}
DEBUG 00:19:08 event Notified event "kernel.request" to listener "EasyCorp\Bundle\EasyAdminBundle\EventListener\AdminRouterSubscriber::onKernelRequest".
{
    "event": "kernel.request",
    "listener": "EasyCorp\\Bundle\\EasyAdminBundle\\EventListener\\AdminRouterSubscriber::onKernelRequest"
}
DEBUG 00:19:08 event Notified event "kernel.controller" to listener "EasyCorp\Bundle\EasyAdminBundle\EventListener\AdminRouterSubscriber::onKernelController".
{
    "event": "kernel.controller",
    "listener": "EasyCorp\\Bundle\\EasyAdminBundle\\EventListener\\AdminRouterSubscriber::onKernelController"
}
DEBUG 00:19:08 event Notified event "kernel.controller" to listener "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController".
{
    "event": "kernel.controller",
    "listener": "Symfony\\Bundle\\FrameworkBundle\\DataCollector\\RouterDataCollector::onKernelController"
}
DEBUG 00:19:08 event Notified event "kernel.controller" to listener "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController".
{
    "event": "kernel.controller",
    "listener": "Symfony\\Component\\HttpKernel\\DataCollector\\RequestDataCollector::onKernelController"
}
DEBUG 00:19:08 event Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\ControllerListener::onKernelController".
{
    "event": "kernel.controller",
    "listener": "Sensio\\Bundle\\FrameworkExtraBundle\\EventListener\\ControllerListener::onKernelController"
}
DEBUG 00:19:08 event Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\ParamConverterListener::onKernelController".
{
    "event": "kernel.controller",
    "listener": "Sensio\\Bundle\\FrameworkExtraBundle\\EventListener\\ParamConverterListener::onKernelController"
}
DEBUG 00:19:08 event Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\HttpCacheListener::onKernelController".
{
    "event": "kernel.controller",
    "listener": "Sensio\\Bundle\\FrameworkExtraBundle\\EventListener\\HttpCacheListener::onKernelController"
}
DEBUG 00:19:08 event Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\TemplateListener::onKernelController".
{
    "event": "kernel.controller",
    "listener": "Sensio\\Bundle\\FrameworkExtraBundle\\EventListener\\TemplateListener::onKernelController"
}
DEBUG 00:19:08 event Notified event "kernel.controller_arguments" to listener "Symfony\Component\HttpKernel\EventListener\ErrorListener::onControllerArguments".
{
    "event": "kernel.controller_arguments",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\ErrorListener::onControllerArguments"
}
DEBUG 00:19:08 event Notified event "kernel.controller_arguments" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\SecurityListener::onKernelControllerArguments".
{
    "event": "kernel.controller_arguments",
    "listener": "Sensio\\Bundle\\FrameworkExtraBundle\\EventListener\\SecurityListener::onKernelControllerArguments"
}
DEBUG 00:19:08 event Notified event "kernel.controller_arguments" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\IsGrantedListener::onKernelControllerArguments".
{
    "event": "kernel.controller_arguments",
    "listener": "Sensio\\Bundle\\FrameworkExtraBundle\\EventListener\\IsGrantedListener::onKernelControllerArguments"
}
DEBUG 00:19:08 event Notified event "kernel.response" to listener "Symfony\Component\Security\Http\Firewall\ContextListener::onKernelResponse".
{
    "event": "kernel.response",
    "listener": "Symfony\\Component\\Security\\Http\\Firewall\\ContextListener::onKernelResponse"
}
DEBUG 00:19:08 event Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\ResponseListener::onKernelResponse".
{
    "event": "kernel.response",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\ResponseListener::onKernelResponse"
}
DEBUG 00:19:08 event Notified event "kernel.response" to listener "Symfony\Component\WebLink\EventListener\AddLinkHeaderListener::onKernelResponse".
{
    "event": "kernel.response",
    "listener": "Symfony\\Component\\WebLink\\EventListener\\AddLinkHeaderListener::onKernelResponse"
}
DEBUG 00:19:08 event Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelResponse".
{
    "event": "kernel.response",
    "listener": "Symfony\\Component\\HttpKernel\\DataCollector\\RequestDataCollector::onKernelResponse"
}
DEBUG 00:19:08 event Notified event "kernel.response" to listener "Symfony\Component\Security\Http\RememberMe\ResponseListener::onKernelResponse".
{
    "event": "kernel.response",
    "listener": "Symfony\\Component\\Security\\Http\\RememberMe\\ResponseListener::onKernelResponse"
}
DEBUG 00:19:08 event Notified event "kernel.response" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\HttpCacheListener::onKernelResponse".
{
    "event": "kernel.response",
    "listener": "Sensio\\Bundle\\FrameworkExtraBundle\\EventListener\\HttpCacheListener::onKernelResponse"
}
DEBUG 00:19:08 event Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\ProfilerListener::onKernelResponse".
{
    "event": "kernel.response",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\ProfilerListener::onKernelResponse"
}
DEBUG 00:19:08 event Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\ErrorListener::removeCspHeader".
{
    "event": "kernel.response",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\ErrorListener::removeCspHeader"
}
DEBUG 00:19:08 event Notified event "kernel.response" to listener "Symfony\Bundle\WebProfilerBundle\EventListener\WebDebugToolbarListener::onKernelResponse".
{
    "event": "kernel.response",
    "listener": "Symfony\\Bundle\\WebProfilerBundle\\EventListener\\WebDebugToolbarListener::onKernelResponse"
}
DEBUG 00:19:08 event Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\DisallowRobotsIndexingListener::onResponse".
{
    "event": "kernel.response",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\DisallowRobotsIndexingListener::onResponse"
}
DEBUG 00:19:08 event Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelResponse".
{
    "event": "kernel.response",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\SessionListener::onKernelResponse"
}
DEBUG 00:19:08 event Notified event "kernel.finish_request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelFinishRequest".
{
    "event": "kernel.finish_request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleListener::onKernelFinishRequest"
}
DEBUG 00:19:08 event Notified event "kernel.finish_request" to listener "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelFinishRequest".
{
    "event": "kernel.finish_request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\RouterListener::onKernelFinishRequest"
}
DEBUG 00:19:08 event Notified event "kernel.finish_request" to listener "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelFinishRequest".
{
    "event": "kernel.finish_request",
    "listener": "Symfony\\Bundle\\SecurityBundle\\Debug\\TraceableFirewallListener::onKernelFinishRequest"
}
DEBUG 00:19:08 event Notified event "kernel.finish_request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelFinishRequest".
{
    "event": "kernel.finish_request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleAwareListener::onKernelFinishRequest"
}
DEBUG 00:19:08 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure".
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\DebugHandlersListener::configure"
}
DEBUG 00:19:08 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest".
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\ValidateRequestListener::onKernelRequest"
}
DEBUG 00:19:08 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest".
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\SessionListener::onKernelRequest"
}
DEBUG 00:19:08 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::setDefaultLocale".
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleListener::setDefaultLocale"
}
DEBUG 00:19:08 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest".
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\RouterListener::onKernelRequest"
}
DEBUG 00:19:08 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest".
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleListener::onKernelRequest"
}
DEBUG 00:19:08 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelRequest".
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleAwareListener::onKernelRequest"
}
DEBUG 00:19:08 event Notified event "kernel.request" to listener "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::configureLogoutUrlGenerator".
{
    "event": "kernel.request",
    "listener": "Symfony\\Bundle\\SecurityBundle\\Debug\\TraceableFirewallListener::configureLogoutUrlGenerator"
}
DEBUG 00:19:08 event Notified event "kernel.request" to listener "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelRequest".
{
    "event": "kernel.request",
    "listener": "Symfony\\Bundle\\SecurityBundle\\Debug\\TraceableFirewallListener::onKernelRequest"
}
DEBUG 00:19:08 event Notified event "kernel.request" to listener "Knp\Bundle\PaginatorBundle\Subscriber\SlidingPaginationSubscriber::onKernelRequest".
{
    "event": "kernel.request",
    "listener": "Knp\\Bundle\\PaginatorBundle\\Subscriber\\SlidingPaginationSubscriber::onKernelRequest"
}
DEBUG 00:19:08 event Notified event "kernel.request" to listener "EasyCorp\Bundle\EasyAdminBundle\EventListener\AdminRouterSubscriber::onKernelRequest".
{
    "event": "kernel.request",
    "listener": "EasyCorp\\Bundle\\EasyAdminBundle\\EventListener\\AdminRouterSubscriber::onKernelRequest"
}
DEBUG 00:19:08 event Notified event "kernel.controller" to listener "EasyCorp\Bundle\EasyAdminBundle\EventListener\AdminRouterSubscriber::onKernelController".
{
    "event": "kernel.controller",
    "listener": "EasyCorp\\Bundle\\EasyAdminBundle\\EventListener\\AdminRouterSubscriber::onKernelController"
}
DEBUG 00:19:08 event Notified event "kernel.controller" to listener "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController".
{
    "event": "kernel.controller",
    "listener": "Symfony\\Bundle\\FrameworkBundle\\DataCollector\\RouterDataCollector::onKernelController"
}
DEBUG 00:19:08 event Notified event "kernel.controller" to listener "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController".
{
    "event": "kernel.controller",
    "listener": "Symfony\\Component\\HttpKernel\\DataCollector\\RequestDataCollector::onKernelController"
}
DEBUG 00:19:08 event Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\ControllerListener::onKernelController".
{
    "event": "kernel.controller",
    "listener": "Sensio\\Bundle\\FrameworkExtraBundle\\EventListener\\ControllerListener::onKernelController"
}
DEBUG 00:19:08 event Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\ParamConverterListener::onKernelController".
{
    "event": "kernel.controller",
    "listener": "Sensio\\Bundle\\FrameworkExtraBundle\\EventListener\\ParamConverterListener::onKernelController"
}
DEBUG 00:19:08 event Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\HttpCacheListener::onKernelController".
{
    "event": "kernel.controller",
    "listener": "Sensio\\Bundle\\FrameworkExtraBundle\\EventListener\\HttpCacheListener::onKernelController"
}
DEBUG 00:19:08 event Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\TemplateListener::onKernelController".
{
    "event": "kernel.controller",
    "listener": "Sensio\\Bundle\\FrameworkExtraBundle\\EventListener\\TemplateListener::onKernelController"
}
DEBUG 00:19:08 event Notified event "kernel.controller_arguments" to listener "Symfony\Component\HttpKernel\EventListener\ErrorListener::onControllerArguments".
{
    "event": "kernel.controller_arguments",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\ErrorListener::onControllerArguments"
}
DEBUG 00:19:08 event Notified event "kernel.controller_arguments" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\SecurityListener::onKernelControllerArguments".
{
    "event": "kernel.controller_arguments",
    "listener": "Sensio\\Bundle\\FrameworkExtraBundle\\EventListener\\SecurityListener::onKernelControllerArguments"
}
DEBUG 00:19:08 event Notified event "kernel.controller_arguments" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\IsGrantedListener::onKernelControllerArguments".
{
    "event": "kernel.controller_arguments",
    "listener": "Sensio\\Bundle\\FrameworkExtraBundle\\EventListener\\IsGrantedListener::onKernelControllerArguments"
}
DEBUG 00:19:08 event Notified event "kernel.response" to listener "Symfony\Component\Security\Http\Firewall\ContextListener::onKernelResponse".
{
    "event": "kernel.response",
    "listener": "Symfony\\Component\\Security\\Http\\Firewall\\ContextListener::onKernelResponse"
}
DEBUG 00:19:08 event Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\ResponseListener::onKernelResponse".
{
    "event": "kernel.response",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\ResponseListener::onKernelResponse"
}
DEBUG 00:19:08 event Notified event "kernel.response" to listener "Symfony\Component\WebLink\EventListener\AddLinkHeaderListener::onKernelResponse".
{
    "event": "kernel.response",
    "listener": "Symfony\\Component\\WebLink\\EventListener\\AddLinkHeaderListener::onKernelResponse"
}
DEBUG 00:19:08 event Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelResponse".
{
    "event": "kernel.response",
    "listener": "Symfony\\Component\\HttpKernel\\DataCollector\\RequestDataCollector::onKernelResponse"
}
DEBUG 00:19:08 event Notified event "kernel.response" to listener "Symfony\Component\Security\Http\RememberMe\ResponseListener::onKernelResponse".
{
    "event": "kernel.response",
    "listener": "Symfony\\Component\\Security\\Http\\RememberMe\\ResponseListener::onKernelResponse"
}
DEBUG 00:19:08 event Notified event "kernel.response" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\HttpCacheListener::onKernelResponse".
{
    "event": "kernel.response",
    "listener": "Sensio\\Bundle\\FrameworkExtraBundle\\EventListener\\HttpCacheListener::onKernelResponse"
}
DEBUG 00:19:08 event Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\ProfilerListener::onKernelResponse".
{
    "event": "kernel.response",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\ProfilerListener::onKernelResponse"
}
DEBUG 00:19:08 event Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\ErrorListener::removeCspHeader".
{
    "event": "kernel.response",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\ErrorListener::removeCspHeader"
}
DEBUG 00:19:08 event Notified event "kernel.response" to listener "Symfony\Bundle\WebProfilerBundle\EventListener\WebDebugToolbarListener::onKernelResponse".
{
    "event": "kernel.response",
    "listener": "Symfony\\Bundle\\WebProfilerBundle\\EventListener\\WebDebugToolbarListener::onKernelResponse"
}
DEBUG 00:19:08 event Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\DisallowRobotsIndexingListener::onResponse".
{
    "event": "kernel.response",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\DisallowRobotsIndexingListener::onResponse"
}
DEBUG 00:19:08 event Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelResponse".
{
    "event": "kernel.response",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\SessionListener::onKernelResponse"
}
DEBUG 00:19:08 event Notified event "kernel.finish_request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelFinishRequest".
{
    "event": "kernel.finish_request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleListener::onKernelFinishRequest"
}
DEBUG 00:19:08 event Notified event "kernel.finish_request" to listener "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelFinishRequest".
{
    "event": "kernel.finish_request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\RouterListener::onKernelFinishRequest"
}
DEBUG 00:19:08 event Notified event "kernel.finish_request" to listener "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelFinishRequest".
{
    "event": "kernel.finish_request",
    "listener": "Symfony\\Bundle\\SecurityBundle\\Debug\\TraceableFirewallListener::onKernelFinishRequest"
}
DEBUG 00:19:08 event Notified event "kernel.finish_request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelFinishRequest".
{
    "event": "kernel.finish_request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleAwareListener::onKernelFinishRequest"
}
DEBUG 00:19:08 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure".
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\DebugHandlersListener::configure"
}
DEBUG 00:19:08 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest".
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\ValidateRequestListener::onKernelRequest"
}
DEBUG 00:19:08 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest".
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\SessionListener::onKernelRequest"
}
DEBUG 00:19:08 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::setDefaultLocale".
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleListener::setDefaultLocale"
}
DEBUG 00:19:08 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest".
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\RouterListener::onKernelRequest"
}
DEBUG 00:19:08 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest".
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleListener::onKernelRequest"
}
DEBUG 00:19:08 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelRequest".
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleAwareListener::onKernelRequest"
}
DEBUG 00:19:08 event Notified event "kernel.request" to listener "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::configureLogoutUrlGenerator".
{
    "event": "kernel.request",
    "listener": "Symfony\\Bundle\\SecurityBundle\\Debug\\TraceableFirewallListener::configureLogoutUrlGenerator"
}
DEBUG 00:19:08 event Notified event "kernel.request" to listener "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelRequest".
{
    "event": "kernel.request",
    "listener": "Symfony\\Bundle\\SecurityBundle\\Debug\\TraceableFirewallListener::onKernelRequest"
}
DEBUG 00:19:08 event Notified event "kernel.request" to listener "Knp\Bundle\PaginatorBundle\Subscriber\SlidingPaginationSubscriber::onKernelRequest".
{
    "event": "kernel.request",
    "listener": "Knp\\Bundle\\PaginatorBundle\\Subscriber\\SlidingPaginationSubscriber::onKernelRequest"
}
DEBUG 00:19:08 event Notified event "kernel.request" to listener "EasyCorp\Bundle\EasyAdminBundle\EventListener\AdminRouterSubscriber::onKernelRequest".
{
    "event": "kernel.request",
    "listener": "EasyCorp\\Bundle\\EasyAdminBundle\\EventListener\\AdminRouterSubscriber::onKernelRequest"
}
DEBUG 00:19:08 event Notified event "kernel.controller" to listener "EasyCorp\Bundle\EasyAdminBundle\EventListener\AdminRouterSubscriber::onKernelController".
{
    "event": "kernel.controller",
    "listener": "EasyCorp\\Bundle\\EasyAdminBundle\\EventListener\\AdminRouterSubscriber::onKernelController"
}
DEBUG 00:19:08 event Notified event "kernel.controller" to listener "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController".
{
    "event": "kernel.controller",
    "listener": "Symfony\\Bundle\\FrameworkBundle\\DataCollector\\RouterDataCollector::onKernelController"
}
DEBUG 00:19:08 event Notified event "kernel.controller" to listener "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController".
{
    "event": "kernel.controller",
    "listener": "Symfony\\Component\\HttpKernel\\DataCollector\\RequestDataCollector::onKernelController"
}
DEBUG 00:19:08 event Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\ControllerListener::onKernelController".
{
    "event": "kernel.controller",
    "listener": "Sensio\\Bundle\\FrameworkExtraBundle\\EventListener\\ControllerListener::onKernelController"
}
DEBUG 00:19:08 event Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\ParamConverterListener::onKernelController".
{
    "event": "kernel.controller",
    "listener": "Sensio\\Bundle\\FrameworkExtraBundle\\EventListener\\ParamConverterListener::onKernelController"
}
DEBUG 00:19:08 event Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\HttpCacheListener::onKernelController".
{
    "event": "kernel.controller",
    "listener": "Sensio\\Bundle\\FrameworkExtraBundle\\EventListener\\HttpCacheListener::onKernelController"
}
DEBUG 00:19:08 event Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\TemplateListener::onKernelController".
{
    "event": "kernel.controller",
    "listener": "Sensio\\Bundle\\FrameworkExtraBundle\\EventListener\\TemplateListener::onKernelController"
}
DEBUG 00:19:08 event Notified event "kernel.controller_arguments" to listener "Symfony\Component\HttpKernel\EventListener\ErrorListener::onControllerArguments".
{
    "event": "kernel.controller_arguments",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\ErrorListener::onControllerArguments"
}
DEBUG 00:19:08 event Notified event "kernel.controller_arguments" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\SecurityListener::onKernelControllerArguments".
{
    "event": "kernel.controller_arguments",
    "listener": "Sensio\\Bundle\\FrameworkExtraBundle\\EventListener\\SecurityListener::onKernelControllerArguments"
}
DEBUG 00:19:08 event Notified event "kernel.controller_arguments" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\IsGrantedListener::onKernelControllerArguments".
{
    "event": "kernel.controller_arguments",
    "listener": "Sensio\\Bundle\\FrameworkExtraBundle\\EventListener\\IsGrantedListener::onKernelControllerArguments"
}

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:101
  at Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter->convert(object(Exception), null)
     (vendor/doctrine/dbal/src/Connection.php:1943)
  at Doctrine\DBAL\Connection->handleDriverException(object(Exception), null)
     (vendor/doctrine/dbal/src/Connection.php:1891)
  at Doctrine\DBAL\Connection->convertException(object(Exception))
     (vendor/doctrine/dbal/src/Connection.php:380)
  at Doctrine\DBAL\Connection->connect()
     (vendor/doctrine/dbal/src/Connection.php:1659)
  at Doctrine\DBAL\Connection->getWrappedConnection()
     (vendor/doctrine/dbal/src/Connection.php:1082)
  at Doctrine\DBAL\Connection->executeQuery('SELECT count(DISTINCT b0_.id) AS sclr_0 FROM business_information b0_', array(), array(), null)
     (vendor/doctrine/orm/src/Query/Exec/SingleSelectExecutor.php:29)
  at Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute(object(Connection), array(), array())
     (vendor/doctrine/orm/src/Query.php:284)
  at Doctrine\ORM\Query->_doExecute()
     (vendor/doctrine/orm/src/AbstractQuery.php:935)
  at Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache(null, 3)
     (vendor/doctrine/orm/src/AbstractQuery.php:891)
  at Doctrine\ORM\AbstractQuery->execute(null, 3)
     (vendor/doctrine/orm/src/AbstractQuery.php:725)
  at Doctrine\ORM\AbstractQuery->getScalarResult()
     (vendor/doctrine/orm/src/Tools/Pagination/Paginator.php:96)
  at Doctrine\ORM\Tools\Pagination\Paginator->count()
  at count(object(Paginator))
     (vendor/knplabs/knp-components/src/Knp/Component/Pager/Event/Subscriber/Paginate/Doctrine/ORM/QuerySubscriber.php:43)
  at Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber->items(object(ItemsEvent), 'knp_pager.items', object(TraceableEventDispatcher))
     (vendor/symfony/event-dispatcher/Debug/WrappedListener.php:115)
  at Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke(object(ItemsEvent), 'knp_pager.items', object(TraceableEventDispatcher))
     (vendor/symfony/event-dispatcher/EventDispatcher.php:230)
  at Symfony\Component\EventDispatcher\EventDispatcher->callListeners(array(object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener)), 'knp_pager.items', object(ItemsEvent))
     (vendor/symfony/event-dispatcher/EventDispatcher.php:59)
  at Symfony\Component\EventDispatcher\EventDispatcher->dispatch(object(ItemsEvent), 'knp_pager.items')
     (vendor/symfony/event-dispatcher/Debug/TraceableEventDispatcher.php:153)
  at Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch(object(ItemsEvent), 'knp_pager.items')
     (vendor/knplabs/knp-components/src/Knp/Component/Pager/Paginator.php:92)
  at Knp\Component\Pager\Paginator->paginate(object(Query), 4079, 21)
     (src/Controller/SearchController.php:48)
  at App\Controller\SearchController->search(object(Request), object(Paginator), object(BusinessInformationRepository))
     (vendor/symfony/http-kernel/HttpKernel.php:163)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw(object(Request), 1)
     (vendor/symfony/http-kernel/HttpKernel.php:75)
  at Symfony\Component\HttpKernel\HttpKernel->handle(object(Request), 1, true)
     (vendor/symfony/http-kernel/Kernel.php:202)
  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/annuairepn/www/aea/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:28
  at Doctrine\DBAL\Driver\PDO\Exception::new(object(PDOException))
     (vendor/doctrine/dbal/src/Driver/PDO/MySQL/Driver.php:40)
  at Doctrine\DBAL\Driver\PDO\MySQL\Driver->connect(array('use_savepoints' => true, 'driver' => 'pdo_mysql', 'host' => 'annuairepnbakli.mysql.db', 'port' => 3306, 'user' => 'annuairepnbakli', 'password' => 'TiliwaA31000', 'driverOptions' => array(), 'defaultTableOptions' => array('collation' => 'utf8mb4_unicode_ci'), 'dbname' => 'annuairepnbakli', 'serverVersion' => '5.7', 'charset' => 'utf8mb4'))
     (vendor/doctrine/dbal/src/Driver/Middleware/AbstractDriverMiddleware.php:29)
  at Doctrine\DBAL\Driver\Middleware\AbstractDriverMiddleware->connect(array('use_savepoints' => true, 'driver' => 'pdo_mysql', 'host' => 'annuairepnbakli.mysql.db', 'port' => 3306, 'user' => 'annuairepnbakli', 'password' => 'TiliwaA31000', 'driverOptions' => array(), 'defaultTableOptions' => array('collation' => 'utf8mb4_unicode_ci'), 'dbname' => 'annuairepnbakli', 'serverVersion' => '5.7', 'charset' => 'utf8mb4'))
     (vendor/doctrine/dbal/src/Logging/Driver.php:34)
  at Doctrine\DBAL\Logging\Driver->connect(array('use_savepoints' => true, 'driver' => 'pdo_mysql', 'host' => 'annuairepnbakli.mysql.db', 'port' => 3306, 'user' => 'annuairepnbakli', 'password' => 'TiliwaA31000', 'driverOptions' => array(), 'defaultTableOptions' => array('collation' => 'utf8mb4_unicode_ci'), 'dbname' => 'annuairepnbakli', 'serverVersion' => '5.7', 'charset' => 'utf8mb4'))
     (vendor/doctrine/dbal/src/Driver/Middleware/AbstractDriverMiddleware.php:29)
  at Doctrine\DBAL\Driver\Middleware\AbstractDriverMiddleware->connect(array('use_savepoints' => true, 'driver' => 'pdo_mysql', 'host' => 'annuairepnbakli.mysql.db', 'port' => 3306, 'user' => 'annuairepnbakli', 'password' => 'TiliwaA31000', 'driverOptions' => array(), 'defaultTableOptions' => array('collation' => 'utf8mb4_unicode_ci'), 'dbname' => 'annuairepnbakli', 'serverVersion' => '5.7', 'charset' => 'utf8mb4'))
     (vendor/symfony/doctrine-bridge/Middleware/Debug/Driver.php:37)
  at Symfony\Bridge\Doctrine\Middleware\Debug\Driver->connect(array('use_savepoints' => true, 'driver' => 'pdo_mysql', 'host' => 'annuairepnbakli.mysql.db', 'port' => 3306, 'user' => 'annuairepnbakli', 'password' => 'TiliwaA31000', 'driverOptions' => array(), 'defaultTableOptions' => array('collation' => 'utf8mb4_unicode_ci'), 'dbname' => 'annuairepnbakli', 'serverVersion' => '5.7', 'charset' => 'utf8mb4'))
     (vendor/doctrine/dbal/src/Connection.php:378)
  at Doctrine\DBAL\Connection->connect()
     (vendor/doctrine/dbal/src/Connection.php:1659)
  at Doctrine\DBAL\Connection->getWrappedConnection()
     (vendor/doctrine/dbal/src/Connection.php:1082)
  at Doctrine\DBAL\Connection->executeQuery('SELECT count(DISTINCT b0_.id) AS sclr_0 FROM business_information b0_', array(), array(), null)
     (vendor/doctrine/orm/src/Query/Exec/SingleSelectExecutor.php:29)
  at Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute(object(Connection), array(), array())
     (vendor/doctrine/orm/src/Query.php:284)
  at Doctrine\ORM\Query->_doExecute()
     (vendor/doctrine/orm/src/AbstractQuery.php:935)
  at Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache(null, 3)
     (vendor/doctrine/orm/src/AbstractQuery.php:891)
  at Doctrine\ORM\AbstractQuery->execute(null, 3)
     (vendor/doctrine/orm/src/AbstractQuery.php:725)
  at Doctrine\ORM\AbstractQuery->getScalarResult()
     (vendor/doctrine/orm/src/Tools/Pagination/Paginator.php:96)
  at Doctrine\ORM\Tools\Pagination\Paginator->count()
  at count(object(Paginator))
     (vendor/knplabs/knp-components/src/Knp/Component/Pager/Event/Subscriber/Paginate/Doctrine/ORM/QuerySubscriber.php:43)
  at Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber->items(object(ItemsEvent), 'knp_pager.items', object(TraceableEventDispatcher))
     (vendor/symfony/event-dispatcher/Debug/WrappedListener.php:115)
  at Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke(object(ItemsEvent), 'knp_pager.items', object(TraceableEventDispatcher))
     (vendor/symfony/event-dispatcher/EventDispatcher.php:230)
  at Symfony\Component\EventDispatcher\EventDispatcher->callListeners(array(object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener)), 'knp_pager.items', object(ItemsEvent))
     (vendor/symfony/event-dispatcher/EventDispatcher.php:59)
  at Symfony\Component\EventDispatcher\EventDispatcher->dispatch(object(ItemsEvent), 'knp_pager.items')
     (vendor/symfony/event-dispatcher/Debug/TraceableEventDispatcher.php:153)
  at Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch(object(ItemsEvent), 'knp_pager.items')
     (vendor/knplabs/knp-components/src/Knp/Component/Pager/Paginator.php:92)
  at Knp\Component\Pager\Paginator->paginate(object(Query), 4079, 21)
     (src/Controller/SearchController.php:48)
  at App\Controller\SearchController->search(object(Request), object(Paginator), object(BusinessInformationRepository))
     (vendor/symfony/http-kernel/HttpKernel.php:163)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw(object(Request), 1)
     (vendor/symfony/http-kernel/HttpKernel.php:75)
  at Symfony\Component\HttpKernel\HttpKernel->handle(object(Request), 1, true)
     (vendor/symfony/http-kernel/Kernel.php:202)
  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/annuairepn/www/aea/vendor/autoload_runtime.php')
     (public/index.php:5)                
[1/3] PDOException
PDOException:
SQLSTATE[HY000] [2002] Connection refused

  at vendor/doctrine/dbal/src/Driver/PDO/MySQL/Driver.php:34
  at PDO->__construct('mysql:host=annuairepnbakli.mysql.db;port=3306;dbname=annuairepnbakli;charset=utf8mb4;', 'annuairepnbakli', 'TiliwaA31000', array())
     (vendor/doctrine/dbal/src/Driver/PDO/MySQL/Driver.php:34)
  at Doctrine\DBAL\Driver\PDO\MySQL\Driver->connect(array('use_savepoints' => true, 'driver' => 'pdo_mysql', 'host' => 'annuairepnbakli.mysql.db', 'port' => 3306, 'user' => 'annuairepnbakli', 'password' => 'TiliwaA31000', 'driverOptions' => array(), 'defaultTableOptions' => array('collation' => 'utf8mb4_unicode_ci'), 'dbname' => 'annuairepnbakli', 'serverVersion' => '5.7', 'charset' => 'utf8mb4'))
     (vendor/doctrine/dbal/src/Driver/Middleware/AbstractDriverMiddleware.php:29)
  at Doctrine\DBAL\Driver\Middleware\AbstractDriverMiddleware->connect(array('use_savepoints' => true, 'driver' => 'pdo_mysql', 'host' => 'annuairepnbakli.mysql.db', 'port' => 3306, 'user' => 'annuairepnbakli', 'password' => 'TiliwaA31000', 'driverOptions' => array(), 'defaultTableOptions' => array('collation' => 'utf8mb4_unicode_ci'), 'dbname' => 'annuairepnbakli', 'serverVersion' => '5.7', 'charset' => 'utf8mb4'))
     (vendor/doctrine/dbal/src/Logging/Driver.php:34)
  at Doctrine\DBAL\Logging\Driver->connect(array('use_savepoints' => true, 'driver' => 'pdo_mysql', 'host' => 'annuairepnbakli.mysql.db', 'port' => 3306, 'user' => 'annuairepnbakli', 'password' => 'TiliwaA31000', 'driverOptions' => array(), 'defaultTableOptions' => array('collation' => 'utf8mb4_unicode_ci'), 'dbname' => 'annuairepnbakli', 'serverVersion' => '5.7', 'charset' => 'utf8mb4'))
     (vendor/doctrine/dbal/src/Driver/Middleware/AbstractDriverMiddleware.php:29)
  at Doctrine\DBAL\Driver\Middleware\AbstractDriverMiddleware->connect(array('use_savepoints' => true, 'driver' => 'pdo_mysql', 'host' => 'annuairepnbakli.mysql.db', 'port' => 3306, 'user' => 'annuairepnbakli', 'password' => 'TiliwaA31000', 'driverOptions' => array(), 'defaultTableOptions' => array('collation' => 'utf8mb4_unicode_ci'), 'dbname' => 'annuairepnbakli', 'serverVersion' => '5.7', 'charset' => 'utf8mb4'))
     (vendor/symfony/doctrine-bridge/Middleware/Debug/Driver.php:37)
  at Symfony\Bridge\Doctrine\Middleware\Debug\Driver->connect(array('use_savepoints' => true, 'driver' => 'pdo_mysql', 'host' => 'annuairepnbakli.mysql.db', 'port' => 3306, 'user' => 'annuairepnbakli', 'password' => 'TiliwaA31000', 'driverOptions' => array(), 'defaultTableOptions' => array('collation' => 'utf8mb4_unicode_ci'), 'dbname' => 'annuairepnbakli', 'serverVersion' => '5.7', 'charset' => 'utf8mb4'))
     (vendor/doctrine/dbal/src/Connection.php:378)
  at Doctrine\DBAL\Connection->connect()
     (vendor/doctrine/dbal/src/Connection.php:1659)
  at Doctrine\DBAL\Connection->getWrappedConnection()
     (vendor/doctrine/dbal/src/Connection.php:1082)
  at Doctrine\DBAL\Connection->executeQuery('SELECT count(DISTINCT b0_.id) AS sclr_0 FROM business_information b0_', array(), array(), null)
     (vendor/doctrine/orm/src/Query/Exec/SingleSelectExecutor.php:29)
  at Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute(object(Connection), array(), array())
     (vendor/doctrine/orm/src/Query.php:284)
  at Doctrine\ORM\Query->_doExecute()
     (vendor/doctrine/orm/src/AbstractQuery.php:935)
  at Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache(null, 3)
     (vendor/doctrine/orm/src/AbstractQuery.php:891)
  at Doctrine\ORM\AbstractQuery->execute(null, 3)
     (vendor/doctrine/orm/src/AbstractQuery.php:725)
  at Doctrine\ORM\AbstractQuery->getScalarResult()
     (vendor/doctrine/orm/src/Tools/Pagination/Paginator.php:96)
  at Doctrine\ORM\Tools\Pagination\Paginator->count()
  at count(object(Paginator))
     (vendor/knplabs/knp-components/src/Knp/Component/Pager/Event/Subscriber/Paginate/Doctrine/ORM/QuerySubscriber.php:43)
  at Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber->items(object(ItemsEvent), 'knp_pager.items', object(TraceableEventDispatcher))
     (vendor/symfony/event-dispatcher/Debug/WrappedListener.php:115)
  at Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke(object(ItemsEvent), 'knp_pager.items', object(TraceableEventDispatcher))
     (vendor/symfony/event-dispatcher/EventDispatcher.php:230)
  at Symfony\Component\EventDispatcher\EventDispatcher->callListeners(array(object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener)), 'knp_pager.items', object(ItemsEvent))
     (vendor/symfony/event-dispatcher/EventDispatcher.php:59)
  at Symfony\Component\EventDispatcher\EventDispatcher->dispatch(object(ItemsEvent), 'knp_pager.items')
     (vendor/symfony/event-dispatcher/Debug/TraceableEventDispatcher.php:153)
  at Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch(object(ItemsEvent), 'knp_pager.items')
     (vendor/knplabs/knp-components/src/Knp/Component/Pager/Paginator.php:92)
  at Knp\Component\Pager\Paginator->paginate(object(Query), 4079, 21)
     (src/Controller/SearchController.php:48)
  at App\Controller\SearchController->search(object(Request), object(Paginator), object(BusinessInformationRepository))
     (vendor/symfony/http-kernel/HttpKernel.php:163)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw(object(Request), 1)
     (vendor/symfony/http-kernel/HttpKernel.php:75)
  at Symfony\Component\HttpKernel\HttpKernel->handle(object(Request), 1, true)
     (vendor/symfony/http-kernel/Kernel.php:202)
  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/annuairepn/www/aea/vendor/autoload_runtime.php')
     (public/index.php:5)