https://netrom-xmas2021-dev.stage04.netromsoftware.ro/ranking

Forwarded to
ExceptionAction (78ddc3)
Method
GET
HTTP Status
500
IP
111.7.106.105
Profiled on
Token
748def

RetrieveStatsAction

Request

GET Parameters

No GET parameters

POST Parameters

No POST parameters

Uploaded Files

No files were uploaded

Request Attributes

Key Value
_api_collection_operation_name 
"get"
_api_normalization_context 
[
  "operation_type" => "collection"
  "collection_operation_name" => "get"
  "resource_class" => "App\Entity\Stats"
  "input" => null
  "output" => null
  "request_uri" => "/ranking"
  "uri" => "https://netrom-xmas2021-dev.stage04.netromsoftware.ro/ranking"
  "skip_null_values" => true
]
_api_resource_class 
"App\Entity\Stats"
_controller 
"App\Controller\RetrieveStatsAction"
_firewall_context 
"security.firewall.map.context.main"
_format 
null
_links 
Fig\Link\GenericLinkProvider {#1162
  -links: [
    "000000003cbcb274000000002e947ada" => Fig\Link\Link {#1161
      -href: "https://netrom-xmas2021-dev.stage04.netromsoftware.ro/docs.jsonld"
      -rel: [
        "http://www.w3.org/ns/hydra/core#apiDocumentation" => true
      ]
      -attributes: []
    }
  ]
}
_route 
"api_stats_get_collection"
_route_params 
[
  "_format" => null
  "_api_resource_class" => "App\Entity\Stats"
  "_api_collection_operation_name" => "get"
]
data 
ApiPlatform\Core\Bridge\Doctrine\Orm\Paginator {#637
  -totalItems: null
  #paginator: Doctrine\ORM\Tools\Pagination\Paginator {#636 …}
  #iterator: null
  #firstResult: 0
  #maxResults: 30
}

Request Headers

Header Value
accept 
"*/*"
accept-encoding 
"gzip"
accept-language 
"en"
host 
"netrom-xmas2021-dev.stage04.netromsoftware.ro"
origin 
"https://mimaki-webportal-dev.web.netromtest.ro"
referer 
"https://mimaki-webportal-dev.web.netromtest.ro/"
user-agent 
"Mozilla/5.0 (Macintosh; Intel Mac OS X 11_0_0) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/87.0.4280.88 Safari/537.36"
x-php-ob-level 
"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 
"application/ld+json; charset=utf-8"
date 
"Fri, 27 Dec 2024 10:42:28 GMT"
link 
"<https://netrom-xmas2021-dev.stage04.netromsoftware.ro/docs.jsonld>; rel="http://www.w3.org/ns/hydra/core#apiDocumentation""
x-content-type-options 
"nosniff"
x-debug-token 
"748def"
x-debug-token-link 
"https://netrom-xmas2021-dev.stage04.netromsoftware.ro/_profiler/78ddc3"
x-frame-options 
"deny"
x-previous-debug-token 
"78ddc3"
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

Flashes

Flashes

No flash messages were created.

Server Parameters

Server Parameters

Defined in .env

Key Value
APP_ENV 
"dev"
APP_SECRET 
"!ChangeMe!"
CORS_ALLOW_ORIGIN 
"^https?://(localhost|xmas.stage04.netromsoftware.ro|127\.0\.0\.1)(:[0-9]+)?$"
DATABASE_URL 
"mysql://netrom-xmas-usr:r4nd0mpssst@192.168.168.240:3306/netrom_xmas_2021?server_version=5.7"
MERCURE_JWT_TOKEN 
"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJtZXJjdXJlIjp7InB1Ymxpc2giOltdfX0.Oo0yg7y4yMa1vr_bziltxuTCqb8JVHKxp-f_FwwOim0"
MERCURE_PUBLISH_URL 
"https://mercure/.well-known/mercure"
MERCURE_SUBSCRIBE_URL 
"https://localhost:1337/.well-known/mercure"
TRUSTED_HOSTS 
"^(localhost|api|192.168.168.240|netrom-xmas2021-dev.stage04.netromsoftware.ro|xmas.stage04.netromsoftware.ro)$"
TRUSTED_PROXIES 
"127.0.0.0/8,10.0.0.0/8,172.16.0.0/12,192.168.168.240/24"
VARNISH_URL 
"http://cache-proxy"

Defined as regular env variables

Key Value
APP_DEBUG 
"1"
CONTEXT_DOCUMENT_ROOT 
"/var/www2/netrom/2021-12-xmas/api/public"
CONTEXT_PREFIX 
""
DOCUMENT_ROOT 
"/var/www2/netrom/2021-12-xmas/api/public"
FCGI_ROLE 
"RESPONDER"
GATEWAY_INTERFACE 
"CGI/1.1"
HOME 
"/var/www"
HTTPS 
"on"
HTTP_ACCEPT 
"*/*"
HTTP_ACCEPT_ENCODING 
"gzip"
HTTP_ACCEPT_LANGUAGE 
"en"
HTTP_HOST 
"netrom-xmas2021-dev.stage04.netromsoftware.ro"
HTTP_ORIGIN 
"https://mimaki-webportal-dev.web.netromtest.ro"
HTTP_REFERER 
"https://mimaki-webportal-dev.web.netromtest.ro/"
HTTP_USER_AGENT 
"Mozilla/5.0 (Macintosh; Intel Mac OS X 11_0_0) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/87.0.4280.88 Safari/537.36"
PATH 
"/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin"
PHP_SELF 
"/index.php"
QUERY_STRING 
""
REDIRECT_HTTPS 
"on"
REDIRECT_SSL_TLS_SNI 
"netrom-xmas2021-dev.stage04.netromsoftware.ro"
REDIRECT_STATUS 
"200"
REDIRECT_URL 
"/ranking"
REMOTE_ADDR 
"111.7.106.105"
REMOTE_PORT 
"62593"
REQUEST_METHOD 
"GET"
REQUEST_SCHEME 
"https"
REQUEST_TIME 
1735296148
REQUEST_TIME_FLOAT 
1735296148.9602
REQUEST_URI 
"/ranking"
SCRIPT_FILENAME 
"/var/www2/netrom/2021-12-xmas/api/public/index.php"
SCRIPT_NAME 
"/index.php"
SERVER_ADDR 
"81.18.67.112"
SERVER_ADMIN 
"[no address given]"
SERVER_NAME 
"netrom-xmas2021-dev.stage04.netromsoftware.ro"
SERVER_PORT 
"443"
SERVER_PROTOCOL 
"HTTP/1.1"
SERVER_SIGNATURE 
"<address>Apache/2.4.38 (Debian) Server at netrom-xmas2021-dev.stage04.netromsoftware.ro Port 443</address>\n"
SERVER_SOFTWARE 
"Apache/2.4.38 (Debian)"
SSL_TLS_SNI 
"netrom-xmas2021-dev.stage04.netromsoftware.ro"
SYMFONY_DOTENV_VARS 
"MERCURE_SUBSCRIBE_URL,VARNISH_URL,APP_ENV,APP_SECRET,TRUSTED_PROXIES,TRUSTED_HOSTS,DATABASE_URL,CORS_ALLOW_ORIGIN,MERCURE_PUBLISH_URL,MERCURE_JWT_TOKEN"
USER 
"www-data"
proxy-nokeepalive 
"1"

Sub Requests 1

ExceptionAction (token = 78ddc3)

Key Value
_controller 
"api_platform.action.exception"
_links 
Fig\Link\GenericLinkProvider {#1005
  -links: [
    "000000003cbcb511000000002e947ada" => Fig\Link\Link {#1004
      -href: "https://netrom-xmas2021-dev.stage04.netromsoftware.ro/docs.jsonld"
      -rel: [
        "http://www.w3.org/ns/hydra/core#apiDocumentation" => true
      ]
      -attributes: []
    }
  ]
}
exception 
Doctrine\DBAL\Exception\ConnectionException {#701
  -driverException: Doctrine\DBAL\Driver\PDOException {#697 …}
  #message: "An exception occurred in driver: SQLSTATE[HY000] [1044] Access denied for user 'netrom-xmas-usr'@'%' to database 'netrom_xmas_2021'"
  #code: 0
  #file: "/var/www2/netrom/2021-12-xmas/api/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php"
  #line: 93
  -previous: Doctrine\DBAL\Driver\PDOException {#697 …}
  trace: {
    /var/www2/netrom/2021-12-xmas/api/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:93 {
      Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException($message, DriverException $exception) …
      › case '2005':
      ›     return new Exception\ConnectionException($message, $exception);
      › 
    }
    /var/www2/netrom/2021-12-xmas/api/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:169 {
      Doctrine\DBAL\DBALException::wrapException(Driver $driver, Throwable $driverEx, string $msg) …
      › if ($driver instanceof ExceptionConverterDriver && $driverEx instanceof DriverExceptionInterface) {
      ›     return $driver->convertException($msg, $driverEx);
      › }
    }
    /var/www2/netrom/2021-12-xmas/api/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:157 {
      Doctrine\DBAL\DBALException::driverException(Driver $driver, Throwable $driverEx) …
      › {
      ›     return static::wrapException($driver, $driverEx, 'An exception occurred in driver: ' . $driverEx->getMessage());
      › }
    }
    /var/www2/netrom/2021-12-xmas/api/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOMySql/Driver.php:28 {
      Doctrine\DBAL\Driver\PDOMySql\Driver->connect(array $params, $username = null, $password = null, array $driverOptions = []) …
      › } catch (PDOException $e) {
      ›     throw DBALException::driverException($this, $e);
      › }
    }
    /var/www2/netrom/2021-12-xmas/api/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:362 {
      Doctrine\DBAL\Connection->connect() …
      › 
      › $this->_conn       = $this->_driver->connect($this->params, $user, $password, $driverOptions);
      › $this->isConnected = true;
    }
    /var/www2/netrom/2021-12-xmas/api/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1449 {
      Doctrine\DBAL\Connection->getWrappedConnection() …
      › {
      ›     $this->connect();
      › 
    }
    /var/www2/netrom/2021-12-xmas/api/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:892 {
      Doctrine\DBAL\Connection->executeQuery($query, array $params = [], $types = [], QueryCacheProfile $qcp = null) …
      › 
      › $connection = $this->getWrappedConnection();
      › 
    }
    /var/www2/netrom/2021-12-xmas/api/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php:50 {
      Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute(Connection $conn, array $params, array $types) …
      › {
      ›     return $conn->executeQuery($this->_sqlStatements, $params, $types, $this->queryCacheProfile);
      › }
    }
    /var/www2/netrom/2021-12-xmas/api/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php:337 {
      Doctrine\ORM\Query->_doExecute() …
      › 
      ›     return $executor->execute($this->_em->getConnection(), $sqlParams, $types);
      › }
    }
    /var/www2/netrom/2021-12-xmas/api/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:991 {
      Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache($parameters = null, $hydrationMode = null) …
      › 
      › $stmt = $this->_doExecute();
      › 
    }
    /var/www2/netrom/2021-12-xmas/api/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:946 {
      Doctrine\ORM\AbstractQuery->execute($parameters = null, $hydrationMode = null) …
      › 
      ›     return $this->executeIgnoreQueryCache($parameters, $hydrationMode);
      › }
    }
    /var/www2/netrom/2021-12-xmas/api/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:749 {
      Doctrine\ORM\AbstractQuery->getResult($hydrationMode = self::HYDRATE_OBJECT) …
      › {
      ›     return $this->execute(null, $hydrationMode);
      › }
    }
    /var/www2/netrom/2021-12-xmas/api/src/Controller/RetrieveStatsAction.php:33 {
      App\Controller\RetrieveStatsAction->__invoke() …
      › ->getQuery()\r
      › ->getResult();\r
      › \r
    }
    /var/www2/netrom/2021-12-xmas/api/vendor/symfony/http-kernel/HttpKernel.php:157 {
      Symfony\Component\HttpKernel\HttpKernel->handleRaw(Request $request, int $type = self::MASTER_REQUEST): Response …
      › // call controller
      › $response = $controller(...$arguments);
      › 
    }
    /var/www2/netrom/2021-12-xmas/api/vendor/symfony/http-kernel/HttpKernel.php:79 {
      Symfony\Component\HttpKernel\HttpKernel->handle(Request $request, int $type = HttpKernelInterface::MASTER_REQUEST, bool $catch = true) …
      › try {
      ›     return $this->handleRaw($request, $type);
      › } catch (\Exception $e) {
    }
    /var/www2/netrom/2021-12-xmas/api/vendor/symfony/http-kernel/Kernel.php:196 {
      Symfony\Component\HttpKernel\Kernel->handle(Request $request, int $type = HttpKernelInterface::MASTER_REQUEST, bool $catch = true) …
      › try {
      ›     return $this->getHttpKernel()->handle($request, $type, $catch);
      › } finally {
    }
    /var/www2/netrom/2021-12-xmas/api/public/index.php:28 {
      › $request = Request::createFromGlobals();
      › $response = $kernel->handle($request);
      › $response->send();
    }
  }
}
logger 
Symfony\Bridge\Monolog\Logger {#142 …6}