http://opendata.kedirikab.go.id/api/snapshots?p=api%2Fsnapshots Return to referer URL

ApiController :: index

Request

GET Parameters

Key Value
p
"api/snapshots"

POST Parameters

No POST parameters

Uploaded Files

No files were uploaded

Request Attributes

Key Value
_controller
"App\Controller\ApiController::index"
_firewall_context
"security.firewall.map.context.main"
_remove_csp_headers
true
_route
"api"
_route_params
[
  "id" => "snapshots"
]
_security_firewall_run
"_security_main"
_stopwatch_token
"a073af"
id
"snapshots"

Request Headers

Header Value
accept
"application/json, text/plain, */*"
accept-encoding
"gzip"
accept-language
"en-US,en;q=0.5"
authorization
""
connection
"close"
content-length
"739"
content-type
"application/json"
host
"opendata.kedirikab.go.id"
referer
"https://opendata.kedirikab.go.id"
user-agent
"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.127 Safari/537.36"
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

Pretty

{
    "dashboard": {
        "annotations": {
            "list": [
                {
                    "name": "Annotations & Alerts",
                    "enable": true,
                    "iconColor": "rgba(0, 211, 255, 1)",
                    "type": "dashboard",
                    "builtIn": 1,
                    "hide": true
                }
            ]
        },
        "editable": true,
        "gnetId": null,
        "graphTooltip": 0,
        "id": null,
        "links": [],
        "panels": [],
        "schemaVersion": 18,
        "snapshot": {
            "originalUrl": "javascript:alert('Revers3c')",
            "timestamp": "2020-03-30T01:24:44.529Z"
        },
        "style": "dark",
        "tags": [],
        "templating": {
            "list": []
        },
        "time": {
            "from": null,
            "to": "2020-03-30T01:24:53.549Z",
            "raw": {
                "from": "6h",
                "to": "now"
            }
        },
        "timepicker": {
            "refresh_intervals": [
                "5s",
                "10s",
                "30s",
                "1m",
                "5m",
                "15m",
                "30m",
                "1h",
                "2h",
                "1d"
            ],
            "time_options": [
                "5m",
                "15m",
                "1h",
                "6h",
                "12h",
                "24h",
                "2d",
                "7d",
                "30d"
            ]
        },
        "timezone": "",
        "title": "Dashboard",
        "uid": null,
        "version": 0
    },
    "name": "Dashboard",
    "expires": 0
}

Raw

{"dashboard":{"annotations":{"list":[{"name":"Annotations & Alerts","enable":true,"iconColor":"rgba(0, 211, 255, 1)","type":"dashboard","builtIn":1,"hide":true}]},"editable":true,"gnetId":null,"graphTooltip":0,"id":null,"links":[],"panels":[],"schemaVersion":18,"snapshot":{"originalUrl":"javascript:alert('Revers3c')","timestamp":"2020-03-30T01:24:44.529Z"},"style":"dark","tags":[],"templating":{"list":[]},"time":{"from":null,"to":"2020-03-30T01:24:53.549Z","raw":{"from":"6h","to":"now"}},"timepicker":{"refresh_intervals":["5s","10s","30s","1m","5m","15m","30m","1h","2h","1d"],"time_options":["5m","15m","1h","6h","12h","24h","2d","7d","30d"]},"timezone":"","title":"Dashboard","uid":null,"version":0},"name":"Dashboard","expires":0}

Response

Response Headers

Header Value
cache-control
"no-cache, private"
content-type
"text/html; charset=UTF-8"
date
"Sun, 29 Dec 2024 05:29:29 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
"421b35"
x-debug-token-link
"http://opendata.kedirikab.go.id/_profiler/7d8b88"
x-previous-debug-token
"7d8b88"
x-robots-tag
"noindex"

Cookies

Request Cookies

No request cookies

Response Cookies

No response cookies

Session 1

Session Metadata

No session metadata

Session Attributes

No session attributes

Session Usage

1 Usages
Stateless check enabled
Usage
Symfony\Component\Security\Core\Authentication\Token\Storage\UsageTrackingTokenStorage:44
[
  [
    "file" => "/var/www/html/open_data/vendor/symfony/security-core/Authentication/Token/Storage/UsageTrackingTokenStorage.php"
    "line" => 44
    "function" => "getMetadataBag"
    "class" => "Symfony\Component\HttpFoundation\Session\Session"
    "type" => "->"
  ]
  [
    "file" => "/var/www/html/open_data/vendor/symfony/security-http/Firewall/AccessListener.php"
    "line" => 87
    "function" => "getToken"
    "class" => "Symfony\Component\Security\Core\Authentication\Token\Storage\UsageTrackingTokenStorage"
    "type" => "->"
  ]
  [
    "file" => "/var/www/html/open_data/vendor/symfony/security-bundle/Debug/WrappedLazyListener.php"
    "line" => 49
    "function" => "authenticate"
    "class" => "Symfony\Component\Security\Http\Firewall\AccessListener"
    "type" => "->"
  ]
  [
    "file" => "/var/www/html/open_data/vendor/symfony/security-http/Firewall/AbstractListener.php"
    "line" => 26
    "function" => "authenticate"
    "class" => "Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener"
    "type" => "->"
  ]
  [
    "file" => "/var/www/html/open_data/vendor/symfony/security-bundle/Security/LazyFirewallContext.php"
    "line" => 60
    "function" => "__invoke"
    "class" => "Symfony\Component\Security\Http\Firewall\AbstractListener"
    "type" => "->"
  ]
  [
    "file" => "/var/www/html/open_data/vendor/symfony/security-bundle/Debug/TraceableFirewallListener.php"
    "line" => 70
    "function" => "__invoke"
    "class" => "Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext"
    "type" => "->"
  ]
  [
    "file" => "/var/www/html/open_data/vendor/symfony/security-http/Firewall.php"
    "line" => 92
    "function" => "callListeners"
    "class" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener"
    "type" => "->"
  ]
  [
    "file" => "/var/www/html/open_data/vendor/symfony/event-dispatcher/Debug/WrappedListener.php"
    "line" => 118
    "function" => "onKernelRequest"
    "class" => "Symfony\Component\Security\Http\Firewall"
    "type" => "->"
  ]
  [
    "file" => "/var/www/html/open_data/vendor/symfony/event-dispatcher/EventDispatcher.php"
    "line" => 230
    "function" => "__invoke"
    "class" => "Symfony\Component\EventDispatcher\Debug\WrappedListener"
    "type" => "->"
  ]
  [
    "file" => "/var/www/html/open_data/vendor/symfony/event-dispatcher/EventDispatcher.php"
    "line" => 59
    "function" => "callListeners"
    "class" => "Symfony\Component\EventDispatcher\EventDispatcher"
    "type" => "->"
  ]
  [
    "file" => "/var/www/html/open_data/vendor/symfony/event-dispatcher/Debug/TraceableEventDispatcher.php"
    "line" => 154
    "function" => "dispatch"
    "class" => "Symfony\Component\EventDispatcher\EventDispatcher"
    "type" => "->"
  ]
  [
    "file" => "/var/www/html/open_data/vendor/symfony/http-kernel/HttpKernel.php"
    "line" => 139
    "function" => "dispatch"
    "class" => "Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher"
    "type" => "->"
  ]
  [
    "file" => "/var/www/html/open_data/vendor/symfony/http-kernel/HttpKernel.php"
    "line" => 75
    "function" => "handleRaw"
    "class" => "Symfony\Component\HttpKernel\HttpKernel"
    "type" => "->"
  ]
  [
    "file" => "/var/www/html/open_data/vendor/symfony/http-kernel/Kernel.php"
    "line" => 202
    "function" => "handle"
    "class" => "Symfony\Component\HttpKernel\HttpKernel"
    "type" => "->"
  ]
  [
    "file" => "/var/www/html/open_data/public/index.php"
    "line" => 20
    "function" => "handle"
    "class" => "Symfony\Component\HttpKernel\Kernel"
    "type" => "->"
  ]
]

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"
CONTENT_LENGTH
"739"
CONTENT_TYPE
"application/json"
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
"application/json, text/plain, */*"
HTTP_ACCEPT_ENCODING
"gzip"
HTTP_ACCEPT_LANGUAGE
"en-US,en;q=0.5"
HTTP_AUTHORIZATION
""
HTTP_CONNECTION
"close"
HTTP_HOST
"opendata.kedirikab.go.id"
HTTP_REFERER
"https://opendata.kedirikab.go.id"
HTTP_USER_AGENT
"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.127 Safari/537.36"
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
"p=api/snapshots"
REDIRECT_QUERY_STRING
"p=api/snapshots"
REDIRECT_STATUS
"200"
REDIRECT_URL
"/api/snapshots"
REMOTE_ADDR
"172.16.25.100"
REMOTE_PORT
"57324"
REQUEST_METHOD
"POST"
REQUEST_SCHEME
"http"
REQUEST_TIME
1735450168
REQUEST_TIME_FLOAT
1735450168.9587
REQUEST_URI
"/api/snapshots"
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 = 7d8b88)

Key Value
_controller
"error_controller"
_stopwatch_token
"c9a928"
exception
Doctrine\DBAL\Exception\ConnectionException {#1188
  -driverException: Doctrine\DBAL\Driver\PDO\Exception {#1190 …}
  #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 {#1190 …}
  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:750 {
      Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load(array $criteria, $entity = null, $assoc = null, array $hints = [], $lockMode = null, $limit = null, array $orderBy = null) …
      › [$params, $types] = $this->expandParameters($criteria);$stmt             = $this->conn->executeQuery($sql, $params, $types);}
    /var/www/html/open_data/vendor/doctrine/orm/lib/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php:768 {
      Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById(array $identifier, $entity = null) …
      › {    return $this->load($identifier, $entity);}
    }
    /var/www/html/open_data/vendor/doctrine/orm/lib/Doctrine/ORM/EntityManager.php:521 {
      Doctrine\ORM\EntityManager->find($className, $id, $lockMode = null, $lockVersion = null) …
      ›     default:        return $persister->loadById($sortedId);}
    }
    /var/www/html/open_data/var/cache/dev/ContainerF3J4NcO/EntityManager_9a5be93.php:143 {
      ContainerF3J4NcO\EntityManager_9a5be93->find($className, $id, $lockMode = null, $lockVersion = null) …
      › 
      ›     return $this->valueHolderd14db->find($className, $id, $lockMode, $lockVersion);}
    }
    /var/www/html/open_data/vendor/doctrine/orm/lib/Doctrine/ORM/EntityRepository.php:197 {
      Doctrine\ORM\EntityRepository->find($id, $lockMode = null, $lockVersion = null) …
      › {    return $this->_em->find($this->_entityName, $id, $lockMode, $lockVersion);}
    }
    /var/www/html/open_data/src/Controller/ApiController.php:21 {
      App\Controller\ApiController->index(?string $id, Request $request, TPublikasiRepository $tPublikasiRepo) …
      › {    $publikasi = $tPublikasiRepo->find($id);    $url = $this->base_url();
    }
    /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