http://opendata.kedirikab.go.id/index.php/api/3901/get

Method
GET
HTTP Status
500
IP
172.16.25.100
Profiled on
Token
43366f

ErrorController

Request

GET Parameters

No GET parameters

POST Parameters

No POST parameters

Uploaded Files

No files were uploaded

Request Attributes

Key Value
_controller 
"error_controller"
_stopwatch_token 
"b6cad6"
exception 
Doctrine\DBAL\Exception\ConnectionException {#1037
  -driverException: Doctrine\DBAL\Driver\PDO\Exception {#1039 …}
  #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 {#1039 …}
  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/src/Controller/ApiController.php:35 {
      App\Controller\ApiController->getApi(?string $id, ?string $row = null, Request $request, TVariabelRepository $tVariabelRepo, TPublikasiRepository $tPublikasiRepo) …
      › {
      ›     $tVariabel = $tVariabelRepo->findBy(['pub' => $id, 'is_tampil' => true], ['id'=>'asc']);
      ›     $tPublikasi = $tPublikasiRepo->find($id);
    }
    /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

Request Headers

Header Value
accept 
"text/html,application/xhtml+xml,application/xml;q=0.9,image/heif,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7"
accept-encoding 
"gzip, deflate, br"
accept-language 
"en-US,en;q=0.5"
authorization 
""
connection 
"close"
cookie 
"sf_redirect=%7B%22token%22%3A%22894376%22%2C%22route%22%3A%22api_get%22%2C%22method%22%3A%22GET%22%2C%22controller%22%3A%7B%22class%22%3A%22Symfony%5C%5CBundle%5C%5CFrameworkBundle%5C%5CController%5C%5CRedirectController%22%2C%22method%22%3A%22urlRedirectAction%22%2C%22file%22%3A%22%5C%2Fvar%5C%2Fwww%5C%2Fhtml%5C%2Fopen_data%5C%2Fvendor%5C%2Fsymfony%5C%2Fframework-bundle%5C%2FController%5C%2FRedirectController.php%22%2C%22line%22%3A110%7D%2C%22status_code%22%3A301%2C%22status_text%22%3A%22Moved%20Permanently%22%7D"
host 
"opendata.kedirikab.go.id"
sec-fetch-dest 
"document"
sec-fetch-mode 
"navigate"
sec-fetch-site 
"none"
sec-fetch-user 
"?1"
upgrade-insecure-requests 
"1"
user-agent 
"Mozilla/5.0 (Linux; Android 5.0) AppleWebKit/537.36 (KHTML, like Gecko) Mobile Safari/537.36 (compatible; Bytespider; spider-feedback@bytedance.com)"
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 
"Thu, 26 Dec 2024 02:39:37 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 
"43366f"

Cookies

Request Cookies

Key Value
sf_redirect 
"{"token":"894376","route":"api_get","method":"GET","controller":{"class":"Symfony\\Bundle\\FrameworkBundle\\Controller\\RedirectController","method":"urlRedirectAction","file":"\/var\/www\/html\/open_data\/vendor\/symfony\/framework-bundle\/Controller\/RedirectController.php","line":110},"status_code":301,"status_text":"Moved Permanently"}"

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 
"text/html,application/xhtml+xml,application/xml;q=0.9,image/heif,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7"
HTTP_ACCEPT_ENCODING 
"gzip, deflate, br"
HTTP_ACCEPT_LANGUAGE 
"en-US,en;q=0.5"
HTTP_AUTHORIZATION 
""
HTTP_CONNECTION 
"close"
HTTP_COOKIE 
"sf_redirect=%7B%22token%22%3A%22894376%22%2C%22route%22%3A%22api_get%22%2C%22method%22%3A%22GET%22%2C%22controller%22%3A%7B%22class%22%3A%22Symfony%5C%5CBundle%5C%5CFrameworkBundle%5C%5CController%5C%5CRedirectController%22%2C%22method%22%3A%22urlRedirectAction%22%2C%22file%22%3A%22%5C%2Fvar%5C%2Fwww%5C%2Fhtml%5C%2Fopen_data%5C%2Fvendor%5C%2Fsymfony%5C%2Fframework-bundle%5C%2FController%5C%2FRedirectController.php%22%2C%22line%22%3A110%7D%2C%22status_code%22%3A301%2C%22status_text%22%3A%22Moved%20Permanently%22%7D"
HTTP_HOST 
"opendata.kedirikab.go.id"
HTTP_SEC_FETCH_DEST 
"document"
HTTP_SEC_FETCH_MODE 
"navigate"
HTTP_SEC_FETCH_SITE 
"none"
HTTP_SEC_FETCH_USER 
"?1"
HTTP_UPGRADE_INSECURE_REQUESTS 
"1"
HTTP_USER_AGENT 
"Mozilla/5.0 (Linux; Android 5.0) AppleWebKit/537.36 (KHTML, like Gecko) Mobile Safari/537.36 (compatible; Bytespider; spider-feedback@bytedance.com)"
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"
PATH_INFO 
"/api/3901/get"
PATH_TRANSLATED 
"redirect:/index.php/get"
PHP_SELF 
"/index.php/api/3901/get"
QUERY_STRING 
""
REMOTE_ADDR 
"172.16.25.100"
REMOTE_PORT 
"50390"
REQUEST_METHOD 
"GET"
REQUEST_SCHEME 
"http"
REQUEST_TIME 
1735180777
REQUEST_TIME_FLOAT 
1735180777.2599
REQUEST_URI 
"/index.php/api/3901/get"
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"

Parent Request

Return to parent request (token = c8c42e)

Key Value
_controller 
"App\Controller\ApiController::getApi"
_firewall_context 
"security.firewall.map.context.main"
_redirected 
true
_remove_csp_headers 
true
_route 
"api_get"
_route_params 
[
  "row" => null
  "id" => "3901"
]
_security_firewall_run 
"_security_main"
_stopwatch_token 
"e6ada4"
id 
"3901"
row 
null