https://scicawally.com/

HomeController :: index

Request

GET Parameters

No GET parameters

POST Parameters

No POST parameters

Uploaded Files

No files were uploaded

Request Attributes

Key Value
_controller
"App\Controller\FrontEnd\HomeController::index"
_firewall_context
"security.firewall.map.context.main"
_remove_csp_headers
true
_route
"frontend_home"
_route_params
[]
_security_firewall_run
"_security_main"
_stopwatch_token
"278e41"

Request Headers

Header Value
accept
"text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7"
accept-encoding
"gzip, deflate"
accept-language
"en-US,en;q=0.9"
cache-control
"no-cache"
host
"scicawally.com"
pragma
"no-cache"
remote-ip
"134.209.186.213"
user-agent
"Mozilla/5.0 (compatible)"
x-forwarded-for
"134.209.186.213"
x-forwarded-proto
"https"
x-ovhrequest-id
"c3d8177487753b4bd26f611258d201d5"
x-php-ob-level
"1"
x-predictor
"1"

Request Content

Request content not available (it was retrieved as a resource).

Response

Response Headers

Header Value
cache-control
"no-cache, private"
content-type
"text/html; charset=UTF-8"
date
"Sun, 20 Apr 2025 00:14:57 GMT"
x-debug-exception
"An%20exception%20occurred%20in%20the%20driver%3A%20SQLSTATE%5BHY000%5D%20%5B2002%5D%20php_network_getaddresses%3A%20getaddrinfo%20for%20scicawwwebmaster.mysql.db%20failed%3A%20Name%20or%20service%20not%20known"
x-debug-exception-file
"%2Fhome%2Fscicaww%2Fsci-cawally%2Fvendor%2Fdoctrine%2Fdbal%2Fsrc%2FDriver%2FAPI%2FMySQL%2FExceptionConverter.php:101"
x-debug-token
"5bd8e8"
x-previous-debug-token
"2073c5"
x-robots-tag
"noindex"

Cookies

Request Cookies

No request cookies

Response Cookies

No response cookies

Session

Session Metadata

No session metadata

Session Attributes

No session attributes

Session Usage

0 Usages
Stateless check enabled

Session not used.

Flashes

Flashes

No flash messages were created.

Server Parameters

Server Parameters

Defined in .env

Key Value
APP_ENV
"dev"
APP_SECRET
"347bb84460fcf91180e61df67995ca89"
DATABASE_URL
"mysql://scicawwwebmaster:SCI2022k1@scicawwwebmaster.mysql.db:3306/scicawwwebmaster?serverVersion=5.7&charset=utf8mb4"
MAILER_DSN
"gmail+smtp://kevinskouame@gmail.com:mlkma1405@default"
MESSENGER_TRANSPORT_DSN
"doctrine://default?auto_setup=0"

Defined as regular env variables

Key Value
APP_DEBUG
"1"
CFG_CLUSTER
"cluster028"
DOCUMENT_ROOT
"/home/scicaww/sci-cawally/public"
ENVIRONMENT
"production"
FCGI_ROLE
"RESPONDER"
GATEWAY_INTERFACE
"CGI/1.1"
GEOIP_AREA_CODE
"0"
GEOIP_CITY
"London"
GEOIP_COUNTRY_CODE
"GB"
GEOIP_COUNTRY_NAME
"United Kingdom"
GEOIP_DMA_CODE
"0"
GEOIP_LATITUDE
"51.536800"
GEOIP_LONGITUDE
"-0.671800"
GEOIP_REGION
"M1"
HTTPS
"on"
HTTP_ACCEPT
"text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7"
HTTP_ACCEPT_ENCODING
"gzip, deflate"
HTTP_ACCEPT_LANGUAGE
"en-US,en;q=0.9"
HTTP_CACHE_CONTROL
"no-cache"
HTTP_HOST
"scicawally.com"
HTTP_PRAGMA
"no-cache"
HTTP_REMOTE_IP
"134.209.186.213"
HTTP_USER_AGENT
"Mozilla/5.0 (compatible)"
HTTP_X_FORWARDED_FOR
"134.209.186.213"
HTTP_X_FORWARDED_PROTO
"https"
HTTP_X_OVHREQUEST_ID
"c3d8177487753b4bd26f611258d201d5"
HTTP_X_PREDICTOR
"1"
PHP_SELF
"/index.php"
QUERY_STRING
""
REDIRECT_STATUS
"200"
REDIRECT_URL
"/"
REMOTE_ADDR
"134.209.186.213"
REMOTE_PORT
"17708"
REQUEST_METHOD
"GET"
REQUEST_TIME
1745108097
REQUEST_TIME_FLOAT
1745108097.5064
REQUEST_URI
"/"
SCRIPT_FILENAME
"/home/scicaww/sci-cawally/public/index.php"
SCRIPT_NAME
"/index.php"
SCRIPT_URI
"https://scicawally.com:443/"
SCRIPT_URL
"/"
SERVER_ADDR
"10.28.20.117"
SERVER_ADMIN
"postmaster@scicawally.com"
SERVER_NAME
"scicawally.com"
SERVER_PORT
"443"
SERVER_PROTOCOL
"HTTP/1.1"
SERVER_SIGNATURE
""
SERVER_SOFTWARE
"Apache"
SYMFONY_DOTENV_VARS
"APP_ENV,APP_SECRET,MESSENGER_TRANSPORT_DSN,DATABASE_URL,MAILER_DSN"
UNIQUE_ID
"aAQ8geaOF@PxA@w7Va8UiwAAAi0"
USER
"scicaww"
argc
0
argv
[]

Sub Requests 1

ErrorController (token = 2073c5)

Key Value
_controller
"error_controller"
_stopwatch_token
"a39fac"
exception
Doctrine\DBAL\Exception\ConnectionException {#560
  #message: "An exception occurred in the driver: SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo for scicawwwebmaster.mysql.db failed: Name or service not known"
  #code: 2002
  #file: "/home/scicaww/sci-cawally/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php"
  #line: 101
  -previous: Doctrine\DBAL\Driver\PDO\Exception {#551 …}
  -query: null
  trace: {
    /home/scicaww/sci-cawally/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:101 {
      Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter->convert(Exception $exception, ?Query $query): DriverException …
      › case 2054:    return new ConnectionException($exception, $query);}
    /home/scicaww/sci-cawally/vendor/doctrine/dbal/src/Connection.php:1908 {
      Doctrine\DBAL\Connection->handleDriverException(Exception $driverException, ?Query $query): DriverException …
      › $this->exceptionConverter ??= $this->_driver->getExceptionConverter();$exception                  = $this->exceptionConverter->convert($driverException, $query);arguments: {
        $exception: Doctrine\DBAL\Driver\PDO\Exception {#551 …}
        $query: null
      }
    }
    /home/scicaww/sci-cawally/vendor/doctrine/dbal/src/Connection.php:1857 {
      Doctrine\DBAL\Connection->convertException(Exception $e): DriverException …
      › {    return $this->handleDriverException($e, null);}
      arguments: {
        $driverException: Doctrine\DBAL\Driver\PDO\Exception {#551 …}
        $query: null
      }
    }
    /home/scicaww/sci-cawally/vendor/doctrine/dbal/src/Connection.php:348 {
      Doctrine\DBAL\Connection->connect() …
      › } catch (Driver\Exception $e) {    throw $this->convertException($e);}
      arguments: {
        $e: Doctrine\DBAL\Driver\PDO\Exception {#551 …}
      }
    }
    /home/scicaww/sci-cawally/vendor/doctrine/dbal/src/Connection.php:1619 {
      Doctrine\DBAL\Connection->getWrappedConnection() …
      › 
      › $this->connect();}
    /home/scicaww/sci-cawally/vendor/doctrine/dbal/src/Connection.php:1046 {
      Doctrine\DBAL\Connection->executeQuery(string $sql, array $params = [], $types = [], QueryCacheProfile $qcp = null): Result …
      › 
      › $connection = $this->getWrappedConnection();}
    /home/scicaww/sci-cawally/vendor/doctrine/orm/lib/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php:916 {
      Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll(array $criteria = [], array $orderBy = null, $limit = null, $offset = null) …
      › [$params, $types] = $this->expandParameters($criteria);$stmt             = $this->conn->executeQuery($sql, $params, $types);arguments: {
        $sql: "SELECT t0.id AS id_1, t0.title AS title_2, t0.desription AS desription_3, t0.firstimage AS firstimage_4, t0.price AS price_5, t0.is_solde AS is_solde_6, t0.is_rent AS is_rent_7, t0.is_to_sale AS is_to_sale_8, t0.surface AS surface_9, t0.room AS room_10, t0.shower AS shower_11, t0.floor AS floor_12, t0.city AS city_13, t0.quatier AS quatier_14, t0.slug AS slug_15, t0.created_at AS created_at_16, t0.illustration1 AS illustration1_17, t0.illustration2 AS illustration2_18, t0.illustration3 AS illustration3_19, t0.illustration4 AS illustration4_20, t0.property_types_id AS property_types_id_21 FROM property t0 ORDER BY t0.created_at DESC LIMIT 6"
        $params: []
        $types: []
      }
    }
    /home/scicaww/sci-cawally/vendor/doctrine/orm/lib/Doctrine/ORM/EntityRepository.php:225 {
      Doctrine\ORM\EntityRepository->findBy(array $criteria, array $orderBy = null, $limit = null, $offset = null) …
      › 
      ›     return $persister->loadAll($criteria, $orderBy, $limit, $offset);}
      arguments: {
        $criteria: []
        $orderBy: [ …1]
        $limit: 6
        $offset: null
      }
    }
    /home/scicaww/sci-cawally/src/Controller/FrontEnd/HomeController.php:18 {
      App\Controller\FrontEnd\HomeController->index(PropertyRepository $repository, Request $request): Response …
      › {    $property = $repository->findBy(array(),orderBy: ["createdAt"=>"DESC"], limit: 6 );    $search = new Search();
      arguments: {
        $criteria: []
        $orderBy: [ …1]
        $limit: 6
      }
    }
    /home/scicaww/sci-cawally/vendor/symfony/http-kernel/HttpKernel.php:163 {
      Symfony\Component\HttpKernel\HttpKernel->handleRaw(Request $request, int $type = self::MAIN_REQUEST): Response …
      › // call controller$response = $controller(...$arguments);arguments: {
        $repository: App\Repository\Admin\PropertyRepository {#680 …}
        $request: Symfony\Component\HttpFoundation\Request {#52 …}
      }
    }
    /home/scicaww/sci-cawally/vendor/symfony/http-kernel/HttpKernel.php:75 {
      Symfony\Component\HttpKernel\HttpKernel->handle(Request $request, int $type = HttpKernelInterface::MAIN_REQUEST, bool $catch = true): Response …
      › try {    return $this->handleRaw($request, $type);} catch (\Exception $e) {
      arguments: {
        $request: Symfony\Component\HttpFoundation\Request {#52 …}
        $type: 1
      }
    }
    /home/scicaww/sci-cawally/vendor/symfony/http-kernel/Kernel.php:202 {
      Symfony\Component\HttpKernel\Kernel->handle(Request $request, int $type = HttpKernelInterface::MAIN_REQUEST, bool $catch = true): Response …
      › try {    return $this->getHttpKernel()->handle($request, $type, $catch);} finally {
      arguments: {
        $request: Symfony\Component\HttpFoundation\Request {#52 …}
        $type: 1
        $catch: true
      }
    }
    /home/scicaww/sci-cawally/vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:35 {
      Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run(): int …
      › {    $response = $this->kernel->handle($this->request);    $response->send();
      arguments: {
        $request: Symfony\Component\HttpFoundation\Request {#52 …}
      }
    }
    /home/scicaww/sci-cawally/vendor/autoload_runtime.php:29 {
      require_once …
      ›         ->getRunner($app)        ->run());
    }
    /home/scicaww/sci-cawally/public/index.php:5 {
      › 
      › require_once dirname(__DIR__).'/vendor/autoload_runtime.php';arguments: {
        "/home/scicaww/sci-cawally/vendor/autoload_runtime.php"
      }
    }
  }
}
logger
Symfony\Bridge\Monolog\Logger {#82 …8}