http://opendata.kedirikab.go.id/?pid=0&uid=0&url=test&visitorId=1331%27%20and%20sleep%287%29%20or%20%27&wmcAction=wmcTrack

HomepageController :: index

Request

GET Parameters

Key Value
pid
"0"
uid
"0"
url
"test"
visitorId
"1331' and sleep(7) or '"
wmcAction
"wmcTrack"

POST Parameters

No POST parameters

Uploaded Files

No files were uploaded

Request Attributes

Key Value
_controller
"App\Controller\Frontend\HomepageController::index"
_firewall_context
"security.firewall.map.context.main"
_remove_csp_headers
true
_route
"homepage"
_route_params
[]
_security_firewall_run
"_security_main"
_stopwatch_token
"07a2b4"

Request Headers

Header Value
accept-encoding
"gzip"
authorization
""
connection
"close"
host
"opendata.kedirikab.go.id"
user-agent
"Mozilla/5.0 (ZZ; Linux i686; rv:123.0) Gecko/20100101 Firefox/123.0"
x-forwarded-for
"192.168.60.9"
x-forwarded-proto
"https"
x-forwarded-scheme
"https"
x-php-ob-level
"1"
x-real-ip
"192.168.60.9"

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
"Sat, 11 Jan 2025 20:01:44 GMT"
x-debug-exception
"An%20exception%20occurred%20in%20driver%3A%20SQLSTATE%5B08006%5D%20%5B7%5D%20connection%20to%20server%20at%20%22127.0.0.1%22%2C%20port%205432%20failed%3A%20Connection%20refused%0A%09Is%20the%20server%20running%20on%20that%20host%20and%20accepting%20TCP%2FIP%20connections%3F"
x-debug-exception-file
"%2Fvar%2Fwww%2Fhtml%2Fopen_data%2Fvendor%2Fdoctrine%2Fdbal%2Flib%2FDoctrine%2FDBAL%2FDriver%2FAbstractPostgreSQLDriver.php:88"
x-debug-token
"2f5c84"
x-debug-token-link
"http://opendata.kedirikab.go.id/_profiler/1bcde4"
x-previous-debug-token
"1bcde4"
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
API_TOKEN
"4a81432adf56aeb6aadfffa65ab70ab1"
API_URL
"http://172.16.16.68/api_/opendata.php"
APP_CLIENT_ADDRESS
"Jl. Sekartaji No.2, Sumber, Doko, Kec. Ngasem, Kabupaten Kediri, Jawa Timur"
APP_CLIENT_CONTACT
"Telp. (0354) 682152"
APP_CLIENT_EMAIL
""
APP_CLIENT_NAME
"Kabupaten Kediri"
APP_CLIENT_SHORTNAME
"Kabupaten Kediri"
APP_ENV
"dev"
APP_ICON
"assets/logo/logo_masbup.png"
APP_ICON_LOGO
"assets/logo/kota_kediri.png"
APP_NAME
"Open Data Kediri"
APP_SECRET
"302717838b52f3d1699a25e8e3ef6a9d"
COLOR_DANGER
"#b20238;"
COLOR_INFO
"#e8d21d;"
COLOR_PRIMARY
"#039fbe;"
COLOR_WARNING
"#cf1578;"
DATABASE_URL
"postgresql://postgres:opendata2022!@127.0.0.1:5432/open_data_kediri?serverVersion=13&charset=utf8"
OPEN_DATA_ICON
"assets/logo/logo_masbup_merah.png"

Defined as regular env variables

Key Value
APP_DEBUG
"1"
CONTEXT_DOCUMENT_ROOT
"/var/www/html/open_data/public/"
CONTEXT_PREFIX
""
DOCUMENT_ROOT
"/var/www/html/open_data/public/"
GATEWAY_INTERFACE
"CGI/1.1"
HTTP_ACCEPT_ENCODING
"gzip"
HTTP_AUTHORIZATION
""
HTTP_CONNECTION
"close"
HTTP_HOST
"opendata.kedirikab.go.id"
HTTP_USER_AGENT
"Mozilla/5.0 (ZZ; Linux i686; rv:123.0) Gecko/20100101 Firefox/123.0"
HTTP_X_FORWARDED_FOR
"192.168.60.9"
HTTP_X_FORWARDED_PROTO
"https"
HTTP_X_FORWARDED_SCHEME
"https"
HTTP_X_REAL_IP
"192.168.60.9"
PATH
"/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/snap/bin"
PHP_SELF
"/index.php"
QUERY_STRING
"wmcAction=wmcTrack&url=test&uid=0&pid=0&visitorId=1331'+and+sleep(7)+or+'"
REMOTE_ADDR
"172.16.25.100"
REMOTE_PORT
"52152"
REQUEST_METHOD
"GET"
REQUEST_SCHEME
"http"
REQUEST_TIME
1736625704
REQUEST_TIME_FLOAT
1736625704.839
REQUEST_URI
"/?wmcAction=wmcTrack&url=test&uid=0&pid=0&visitorId=1331'+and+sleep(7)+or+'"
SCRIPT_FILENAME
"/var/www/html/open_data/public/index.php"
SCRIPT_NAME
"/index.php"
SERVER_ADDR
"172.16.16.52"
SERVER_ADMIN
"[no address given]"
SERVER_NAME
"opendata.kedirikab.go.id"
SERVER_PORT
"80"
SERVER_PROTOCOL
"HTTP/1.1"
SERVER_SIGNATURE
""
SERVER_SOFTWARE
"Apache"
SYMFONY_DOTENV_VARS
"APP_ENV,APP_SECRET,DATABASE_URL,API_URL,API_TOKEN,APP_NAME,OPEN_DATA_ICON,APP_ICON,APP_ICON_LOGO,APP_CLIENT_NAME,APP_CLIENT_SHORTNAME,APP_CLIENT_ADDRESS,APP_CLIENT_CONTACT,APP_CLIENT_EMAIL,COLOR_PRIMARY,COLOR_WARNING,COLOR_INFO,COLOR_DANGER"

Sub Requests 1

ErrorController (token = 1bcde4)

Key Value
_controller
"error_controller"
_stopwatch_token
"17e751"
exception
Doctrine\DBAL\Exception\ConnectionException {#1110
  -driverException: Doctrine\DBAL\Driver\PDO\Exception {#1112 …}
  #message: """
    An exception occurred in driver: SQLSTATE[08006] [7] connection to server at "127.0.0.1", port 5432 failed: Connection refused\n
    \tIs the server running on that host and accepting TCP/IP connections?
    """
  #code: 0
  #file: "/var/www/html/open_data/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractPostgreSQLDriver.php"
  #line: 88
  -previous: Doctrine\DBAL\Driver\PDO\Exception {#1112 …}
  trace: {
    /var/www/html/open_data/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractPostgreSQLDriver.php:88 {
      Doctrine\DBAL\Driver\AbstractPostgreSQLDriver->convertException($message, DriverException $exception) …
      › case '08006':    return new Exception\ConnectionException($message, $exception);}
    /var/www/html/open_data/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:182 {
      Doctrine\DBAL\DBALException::wrapException(Driver $driver, Throwable $driverEx, string $msg) …
      › if ($driver instanceof ExceptionConverterDriver && $driverEx instanceof DeprecatedDriverException) {    return $driver->convertException($msg, $driverEx);}
    }
    /var/www/html/open_data/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:169 {
      Doctrine\DBAL\DBALException::driverException(Driver $driver, Throwable $driverEx) …
      › {    return self::wrapException($driver, $driverEx, 'An exception occurred in driver: ' . $driverEx->getMessage());}
    }
    /var/www/html/open_data/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOPgSql/Driver.php:52 {
      Doctrine\DBAL\Driver\PDOPgSql\Driver->connect(array $params, $username = null, $password = null, array $driverOptions = []) …
      › } catch (PDOException $e) {    throw Exception::driverException($this, $e);}
    }
    /var/www/html/open_data/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:412 {
      Doctrine\DBAL\Connection->connect() …
      › 
      › $this->_conn = $this->_driver->connect($this->params, $user, $password, $driverOptions);}
    /var/www/html/open_data/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1952 {
      Doctrine\DBAL\Connection->getWrappedConnection() …
      › {    $this->connect();}
    /var/www/html/open_data/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1290 {
      Doctrine\DBAL\Connection->executeQuery($sql, array $params = [], $types = [], QueryCacheProfile $qcp = null) …
      › 
      › $connection = $this->getWrappedConnection();}
    /var/www/html/open_data/vendor/doctrine/orm/lib/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php:918 {
      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);}
    /var/www/html/open_data/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);}
    }
    /var/www/html/open_data/vendor/doctrine/orm/lib/Doctrine/ORM/EntityRepository.php:207 {
      Doctrine\ORM\EntityRepository->findAll() …
      › {    return $this->findBy([]);}
    }
    /var/www/html/open_data/src/Controller/Frontend/HomepageController.php:28 {
      App\Controller\Frontend\HomepageController->index(SeoPageInterface $seoPage, MSektorRepository $MSektorRepo, TDivRepository $TDivRepo, TPublikasiRepository $TPubRepo) …
      › $infografik = $this->getDoctrine()->getRepository(TInfografik::class);$infografik = $infografik->findAll();$total_infografik = count($infografik);
    }
    /var/www/html/open_data/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);}
    /var/www/html/open_data/vendor/symfony/http-kernel/HttpKernel.php:75 {
      Symfony\Component\HttpKernel\HttpKernel->handle(Request $request, int $type = HttpKernelInterface::MAIN_REQUEST, bool $catch = true) …
      › try {    return $this->handleRaw($request, $type);} catch (\Exception $e) {
    }
    /var/www/html/open_data/vendor/symfony/http-kernel/Kernel.php:202 {
      Symfony\Component\HttpKernel\Kernel->handle(Request $request, int $type = HttpKernelInterface::MAIN_REQUEST, bool $catch = true) …
      › try {    return $this->getHttpKernel()->handle($request, $type, $catch);} finally {
    }
    /var/www/html/open_data/public/index.php:20 {$request = Request::createFromGlobals();$response = $kernel->handle($request);$response->send();
    }
  }
}
logger
null